Jump to content

newem

Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About newem

  • Rank
    Newbie
  1. I have the following problem. My company "lost" the .xsd file they used to export products from an Excel file to an XML file, and now I tried to re-write it myself but I came to a problem of how to split a field that has values separated by commas. Here is an example from the Excel file. http://i.stack.imgur.com/KICvP.jpg It's the second to last field named masterreference. Now the problem is writing an .xsd file that will through the Excel XML export come up with the following structure: <universalld>0AF1AA0F18FB44F5C125701800445CC3</universalld> <brand>ACEC</brand> <type>Canister</type> <commercialname></commercialname> <model>AT 81, 82</model> <importance>0</importance> <diameter>32 mm</diameter> <masterreferences> <masterreference>FL 11</masterreference> <masterreference>T 40</masterreference> </masterreferences> <productpictureno></productpictureno> </cleaner> This is the .xsd I have right now. http://i.stack.imgur.com/YbIew.png Can someone help me?
×
×
  • Create New...