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>