Welcome Guest! Log in

Topic-icon Question XML

More
22 Jul 2015 13:17 #1 by J.M
XML was created by J.M
Hi,
I’m trying to implement an XML file from Excel, everything is working but the mapping don’t generate the OUT FILE
Attachments:

Please Log in or Create an account to join the conversation.

More
22 Jul 2015 15:18 #2 by Cyril Dussud
Replied by Cyril Dussud on topic XML
Hi,
If I understand well, you are doing a Mapping, in which you have an excel file as a source and XML as a target.
What template are you using ? and with what parameters ?
If it is possible a screenshot of the mapping would help to understand better what's going on.

Please Log in or Create an account to join the conversation.

More
22 Jul 2015 15:30 #3 by J.M
Replied by J.M on topic XML
Yes,here it is,
Inv_air is the excel file
Invoicing is the XSD
Ec_country is a table in Posgresql (I have to it with the excel file in order to get the column ‘code’ )
Attachments:

Please Log in or Create an account to join the conversation.

More
22 Jul 2015 15:52 #4 by Cyril Dussud
Replied by Cyril Dussud on topic XML
When loading XML Files, keys needs to be mapped to enable iteration on the element.
Cf : Designer Help Tutorials/Tutorial: Working with XML Files/ Loading a Simple XMl Structure

Try to map the keys of your XML File, it should work

Please Log in or Create an account to join the conversation.

More
22 Jul 2015 16:01 #5 by J.M
Replied by J.M on topic XML
even if I map the keys, the xml file is not generate

Please Log in or Create an account to join the conversation.

More
22 Jul 2015 16:24 #6 by Cyril Dussud
Replied by Cyril Dussud on topic XML
Can you show a new screenshot of the mapping with the mapped Keys , and all the Template's parameters (if there are more configured than the ones show in your last screen) ? And have the statistics changed after having mapped the keys ?

Please Log in or Create an account to join the conversation.

More
22 Jul 2015 16:34 #7 by J.M
Replied by J.M on topic XML
Can you show a new screenshot of the mapping with the mapped Keys , and all the Template's parameters (if there are more configured than the ones show in your last screen) ? And have the statistics changed after having mapped the keys ?

Here is the screenshot of the new mapping:


No I did not add any other Template
No, the statistic did not change

Attachments:

Please Log in or Create an account to join the conversation.

More
22 Jul 2015 16:54 - 28 Sep 2016 16:13 #8 by Cyril Dussud
Replied by Cyril Dussud on topic XML
Ok, thanks.
Can you export the mapping with :
-> Right click on the mapping in the project Explorer
-> Export Models And Dependencies
and send it to the support team? We'll look at it.
Last edit: 28 Sep 2016 16:13 by Thomas BLETON.

Please Log in or Create an account to join the conversation.