Last post May 18, 2005 05:15 AM by hmnguyen
May 17, 2005 02:06 PM|bradoyler|LINK
Anyone work on a module for importing a spreadsheet? Similar to Sharepoint feature.
May 18, 2005 01:20 AM|xpdit|LINK
i have many flavors of this. i have made it for many people, but i can tell you one thing. export the excel file to a tab delimited file, then parse it into xml and do the import that way. excel has a bad habit of using the first cell of data in a column
to determine its column - datatype. so if you have a column with integer, text, integer, text , it will eval to integer, and lose data in the text cells. so just a heads up, and yes, i can help you with this.
the big thing is column-mapping. thats all that there is to it. oh yeah, xml makes the import soooooooooo fast compared to xl or tab delim.
May 18, 2005 05:15 AM|hmnguyen|LINK