Import CSV data into UDT - User Defined Table Module [Lead: Sebastian Leupold]

Forum DotNetNuke® Pro... User Defined Ta... Import CSV data into UDT

9/2/2008 1:47 PM

	Stefan Cullmann
1553 posts

Import CSV data into UDT

For a long time ago I wrote a small console application that transforms CSV tables into UDT import files. Yesterday I updated it to reflect the latest changes and created a project inside the forge: http://www.dotnetnuke.com/Products/Development/Forge/tabid/824/ctl/Details/mid/3713/Projectid/159/Default.aspx

The application is limited, the only datatype supported is "String/Text". Please, this is no encouragement to upload big datasets!

Stefan Cullmann - stefan.cullmann [at] dotnetnuke.com
Form and List will be the successor of the User Defined Table module.
----------------------------------------------------------------------
Do you want to import external data to Form and List /User Defined Table?
Check out http://www.codeplex.com/Csv2UDTImport

9/4/2008 10:26 AM

	j_ruez
50 posts
www.tennesseewrestling.com

Re: Import CSV data into UDT

Here are my comments:

1. Dragging and dropping did not work. I don't know why because it gave no error message (at least that I could see in the cmd window that dissappeared quickly.

2. After creating an xml doc by running your app through the command prompt, I imported the file to my UDT, and it failed .. no error message except "An error occurred during the import". Then, I went back to my UDT and all my columns were gone and the table was empty.

9/5/2008 12:48 AM

	Stefan Cullmann
1553 posts

Re: Import CSV data into UDT

Thank you for testing and reporting.

Can you please send me your CSV and the XML file? Iwould like to reproduce what is happening.

Which UDT version are you running?

A module import always removes all data, the module will be rebuild with the new data. It needs to remove the old columns. Now import failed, did you notify new but empty columns? I suggest to test import only using fresh inserted UDT modules.

I tested drag'drop again. The cmd windows opens for 0.5s, afterwards the XML file appears in the same folder as the source file.

9/12/2008 11:32 AM

	simonduz
194 posts
www.virtualsignpost.com

Re: Import CSV data into UDT

Modified By simonduz on 9/12/2008 1:33:17 PM)

Stefan, did you ever get those sample files? I am seeing the same as j_ruez.
My excel spread sheet has 7 columns, and 149 records, this includes the column headers (labels). Simple text, max cell length is around 35 characters.
I exported this to CSV file then tried the Drag-N-Drop method but it did not work. I executed this from the command prompt and it created an XML file but from what I could see the format was incorrect.

Example of Excel:

Code Asset Serial User Description End of Support Assignment

123456 AC679697 06830763UAKCT2YGG VACANT IBM DESKTOP M42, 8307-63U 6/27/2006 In use

123456 AC668727 SKPBPFDK LOOW IBM THINKPAD T40, 1.5GHZ 40GB 8/6/2006 In use

Example of CSV:
Code,Asset,Serial,User,Description,End of Support,Assignment,
123456,AC679697,06830763UAKCT2YGG,VACANT,"IBM DESKTOP M42, 8307-63U",6/27/2006,In use,
123456,AC668727,SKPBPFDK,LOOW,"IBM THINKPAD T40, 1.5GHZ 40GB",8/6/2006,In use,

Example of XML:
<?xml version="1.0" encoding="utf-8" ?>
<content type="DNNUserDefinedTable" version="3.0.0">
<UserDefinedTable xmlns="DotNetNuke/UserDefinedTable">
<Data>
    <Code_x002C_Asset_x002C_Serial_x002C_User_x002C_Description_x002C_End_x0020_of_x0020_Support_x002C_Assignment_x002C_>Code,Asset,Serial,User,Description,End of Support,Assignment,</Code_x002C_Asset_x002C_Serial_x002C_User_x002C_Description_x002C_End_x0020_of_x0020_Support_x002C_Assignment_x002C_>
    <CreatedBy>ImportFromCsv</CreatedBy>
    <CreatedAt>2008-09-12T13:28:39.29626-04:00</CreatedAt>
    <ChangedBy>ImportFromCsv</ChangedBy>
    <ChangedAt>2008-09-12T13:28:39.29626-04:00</ChangedAt>
    <UserDefinedRowId>-1</UserDefinedRowId>
</Data>
<Data>
    <Code_x002C_Asset_x002C_Serial_x002C_User_x002C_Description_x002C_End_x0020_of_x0020_Support_x002C_Assignment_x002C_>123456,AC679697,06830763UAKCT2YGG,VACANT,"IBM DESKTOP M42, 8307-63U",6/27/2006,In use,</Code_x002C_Asset_x002C_Serial_x002C_User_x002C_Description_x002C_End_x0020_of_x0020_Support_x002C_Assignment_x002C_>
    <CreatedBy>ImportFromCsv</CreatedBy>
    <CreatedAt>2008-09-12T13:28:39.29626-04:00</CreatedAt>
    <ChangedBy>ImportFromCsv</ChangedBy>
    <ChangedAt>2008-09-12T13:28:39.29626-04:00</ChangedAt>
    <UserDefinedRowId>-1</UserDefinedRowId>
</Data>
<Data>
    <Code_x002C_Asset_x002C_Serial_x002C_User_x002C_Description_x002C_End_x0020_of_x0020_Support_x002C_Assignment_x002C_>123456,AC668727,SKPBPFDK,LOOW,"IBM THINKPAD T40, 1.5GHZ 40GB",8/6/2006,In use,</Code_x002C_Asset_x002C_Serial_x002C_User_x002C_Description_x002C_End_x0020_of_x0020_Support_x002C_Assignment_x002C_>
    <CreatedBy>ImportFromCsv</CreatedBy>
    <CreatedAt>2008-09-12T13:28:39.29626-04:00</CreatedAt>
    <ChangedBy>ImportFromCsv</ChangedBy>
    <ChangedAt>2008-09-12T13:28:39.29626-04:00</ChangedAt>
    <UserDefinedRowId>-1</UserDefinedRowId>
</Data>

Have you seen our website lately?

Brought to you by the Papa Bear.

9/13/2008 5:35 AM

	Stefan Cullmann
1553 posts

Re: Import CSV data into UDT

Simon,

The application expects that the fields are separated with a semicolon, not a comma.

Code;Asset;Serial;User;Description;End of Support;Assignment;
123456;AC679697;06830763UAKCT2YGG;VACANT;"IBM DESKTOP M42; 8307-63U";6/27/2006;In use;
123456;AC668727;SKPBPFDK;LOOW;"IBM THINKPAD T40; 1.5GHZ 40GB";8/6/2006;In use;

Page 1 of 2

Forum

DotNetNuke® Pro...

User Defined Ta...

Import CSV data into UDT