Hi,

I have an 'old' website in DNN3 and a new website in DNN4. I'm copying content from the DNN3-site to the DNN4-site. In the DNN3-site I have a UDT with 50 rows and 12 columns. I managed to get this content in Excel (there is no export). Now I try to import this in the new DNN4 UDT (3.3.0), but I don't know how this is done. I tried to export the excel-table to xml and uploaded the xml-file in the portal root folder, but this file does not appear in the drop-down list at the importscreen. I chose 'import content' from the module menu. Can anyone help me?

Jan-Geert Taekema.

Thanks very much for your quick help, the last part was very helpful. In the DNN3 version of my site, I'm not authorized to upload any modules, so I had to choose a different approach. Here's my solution, though quite complicated.

• In the DNN4-version I filled one row, exported this en downloaded the xml-file from the portal root (as admin) content.UserDefinedTable.MINE.xml, where MINE is the title of the module.
• I copied the <data> ... </data> part of this file (opened in notepad) and pasted this in Word.
• From the old site I copied from screen (selected all rows as it was presented when I viewed the page) to Excel, did some cleaning and saved it with a named region.
• I used the Word document as the basefile and merged it with the excel-region as though I was making multiple letters. I replaced all data which I entered in the first row with fields from the excel-region. This needs a bit tuning, but can be done!
• I saved the merged as a txt-file and opened it in notepad.
• I copied the first rows (just before the first <Data>-tag from the original xml-file, which was still open in notepad and pasted it into the new txt-file.
• I copied all rows right after the </Data> (that is: starting with <Fields>) from the original file and pasted them into the new file.
• I saved the new file, deleted the original file and renamed the new file to the original name, ending with .xml.
• I uploaded the file to the portal root (as admin)
• I imported this file in the new DNN4 UDT and it works!!!

To be honest: I made one mistake and had to ask my provider to delete all datarows from the SQL-database, but that could be done!

Then there still remains the question if it is possible to create a 'import csv-file' function. CSV-files are much easier for most people. The first row should contain the column-names. Maybe one step beyond this: Display field names in UDT and display behind each fieldname a listbox of fields found in the csv-file, so there is an easy way of matching fields.

Hope you can use all this information!

Jan-Geert Taekema.