|
|
Rank: Newbie
Joined: 12/5/2007
Posts: 3
|
Thanks first of all for a great product. Used it a couple of times before and everything was spot on.
I have just been given a new XML document and i need to export the data to SQL Server, and then mash that data into a new format that the client has asked for...bit of a pain but hey ho its my job.
Everything seems to have worked with the database convert, there were no errors, however when i look at some of the tables it has flattened certain elements into 1 field.
Part of XML Document before convert...
<objectlist>
<object>
<cooking>
<cuisine>Sfd</cuisine>
<cuisine>Idn</cuisine>
<cuisine>Brit</cuisine>
<cuisine>Scsh</cuisine>
<cuisine>Itn</cuisine>
<cuisine>Mxn</cuisine>
<cuisine>Cajn</cuisine>
<cuisine>Gen</cuisine>
<cuisine>SrvF</cuisine>
<cuisine>Snk</cuisine>
</cooking>
</object>
<object />
.
.
.
<object />
</objectlist>
And there are other nodes that have similar structure. However when the convert does it's job, the out put looks like:
PrimaryKey ForiegnKey Cuisine
1 1 SfdIdnBritScshItnMxnCajnGenSrvFSnk
Is there any options (that are currently escaping me) to allow for comma seperation of these fields? Or even to have a seperate cuisine table that would reference cooking top level object with a foreign key?
Also some of the elements do not seem to be converted into fields. Is the 30day trial limited in someway?
|
|
Rank: Newbie
Joined: 12/5/2007
Posts: 3
|
Forget that last sentence. My bad, it was limited to 4 nodes deep...working now. But still need to comma seperate multiple nodes.
|
|
Rank: Advanced Member
Joined: 12/27/2006
Posts: 31
Location: Vienna
|
Hello Colin,
There is no way in XMLSpy to insert commas. To do so, or to get a row for each cuisine element, you'd have to use Altova MapForce.
There is a FAQ entry that refers to this behavior:
https://www.altova.com/support_faq_ide_convert.html#q5_imex
Christophe
Support Engineer
|
|
Rank: Newbie
Joined: 12/5/2007
Posts: 3
|
Hi Christophe,
Ok i will give it a shot. Will let you know if i have success.
Cheers
Colin
|
|
|
guest |
