|
|
 next
|
  Subject: Need Help Creating Custom XML Conversion with Components/Sub-Components
Author: Jon St. Onge
Date: 11 Jul 2009 12:42 PM
|
I would appreciate any help somebody would be willing to offer. One of my manufacturers sent me a spreadsheet of their data, but my shopping cart software only has an Upload XML option. I need to convert my product database into a specific xml format that contains sub-fields or variants. While a given product can technically contain multiple variants, my products only have one variant per product. I've played with Stylus Studios for the last 12 hours, and I am not having any luck creating the proper .conv file that I need to convert my .csv file with thousands of products into the properly formatted .xml file.
I have enclosed a sample of my .csv file, as well as a sample of what the final .xml file should look like. The examples seem pretty straight forward, but I wanted to point out that the first row of the .csv file will contain the <tag> headers and the ProductName field in Column Y would be the <component> field. Everything to the right of Column Y would be a sub-component of Column Y, as can be seen in the sample .xml file. I guess another small thing to point out is that there may be blanks fields in the data as seen in the .csv file. Feel free to modify the .csv file to meet your needs, but let me know those changes, so that I can make proper adjustments to my file.
Ideally, I would like somebody to post the .conv file here that would do the conversion, but I would also like to see if you could give step-by-step instructions on how you did it, so that others (including myself) can learn.
thanks
jon
 samplechoppeddown.csv
samplechoppeddownflat.xml
|
|
|
|
samplechoppeddown(1).csv
top