Data Import
-
KermitTensmeyer
- Posts: 7
- Joined: Sat Mar 08, 2008 12:03 am
Data Import
I'm not requesting a new feature, but a clarification of the data import function.
When importing a spreadsheet, every column becomes a element in every row. Currently it is a manual process to turn off columns so that data is not converted. Is there an option to turn off all the columns except those which have some non-blank data?
My output xml will have 700 rows of 999 elements and only 7 elements are useful. (I admit that using these files as training material to teach XSL to new users, is a simpler operation. heck match on the row, create new output row with new element names using value-of for mapping the old values. Teaches the basics of xslt transformation.)
But is there an option not to process those empty elements?
Regards --- Kermit Tensmeyer
When importing a spreadsheet, every column becomes a element in every row. Currently it is a manual process to turn off columns so that data is not converted. Is there an option to turn off all the columns except those which have some non-blank data?
My output xml will have 700 rows of 999 elements and only 7 elements are useful. (I admit that using these files as training material to teach XSL to new users, is a simpler operation. heck match on the row, create new output row with new element names using value-of for mapping the old values. Teaches the basics of xslt transformation.)
But is there an option not to process those empty elements?
Regards --- Kermit Tensmeyer
-
sorin_ristache
- Posts: 4141
- Joined: Fri Mar 28, 2003 2:12 pm
Re: Data Import
Hello,
No, there is no quick way to turn off a group of columns. You have to turn off manually the columns that you want to exclude from the import operation.
You should import the spreadsheet as it is now and exclude all the columns with blank data by applying a simple XSLT transformation based on the identity transformation. Such an XSLT stylesheet can be developed very quickly.
Regards,
Sorin
No, there is no quick way to turn off a group of columns. You have to turn off manually the columns that you want to exclude from the import operation.
You should import the spreadsheet as it is now and exclude all the columns with blank data by applying a simple XSLT transformation based on the identity transformation. Such an XSLT stylesheet can be developed very quickly.
Regards,
Sorin