Developer forum

Forum » Integration » Export selected ecom product groups to XML

Export selected ecom product groups to XML

E-mail notifications
Per Søgaard
Reply
Posted on 04/03/2013 10:44:29

I need to export selected ecom product groups to an xml file so that it can be downloadet and imported in an internet portal.

Maybe only selected fields and fieldnames should maybe be changed to other names in the export file.

Only active products should be included in the export.

It should run daily, overwriting the previus file.

Can this be done using dataintegration and how to set it up?

 

Format:

<?xml version="1.0" encoding="UTF-8"?> <annoncer>
<annonce> <feltnavn1>Oplysning1</feltnavn1> <feltnavn2>Oplysning2</feltnavn2>
</annonce> <annonce>
<feltnavn1>Oplysning1</feltnavn1>
<feltnavn2>Oplysning2</feltnavn2> </annonce>
</annoncer>

 


Replies

 
Morten Snedker
Posted on 19/03/2013 13:24:18
Reply

Hi Per,

To get the products out in first place, create a new job.

Source: Ecom Provider. Change nothing and use default settings
Destination: XML Provider. Set output-file and optionally output path.

 

On window of selection source tables:

 

 

Next window: click the "Add source table to destination" icon. This will map source/destination table and source/destination columns.

Next, find ProductActive and click the scripting icon:

 

Now you just need to save and run. 

 

Finally, when on the window where you'd choose your destination (xml), you also have the option to provide an XSLT. The XSLT-file is what will get you from the default output format to the format you have described. This XSLT you'll to write yourself (or get someone to do so).

 

 

 

Regards /Snedker

 
Per Søgaard
Posted on 19/03/2013 16:29:02
Reply

Thank you for the reply.

So if i need the xml in a special format, can i then edit it and export to it again?

 
Morten Snedker
Posted on 20/03/2013 09:10:20
Reply

Yes. On the job you have, where you export from eCom to XML, you may apply an XSLT. The job of an XSLT is to transform the conent of an XML from one format to another. 

 

As you can see on screendump below, you can apply the XSL(T) from the destination settings.

 

 

Regards /Snedker

 

You must be logged in to post in the forum