Developer forum

Forum » Integration » Export orders CDATA tag

Export orders CDATA tag

Martijn van Tongeren
Reply

We created a export order job with the dataintegration module. The export creates an xml file. Each column content element has an CDATA attribute, is it possible to remove this? Other question is it possible to change the datatype format, now it is dd-MM-yyyy HH:mm:ss:fff our customer want to have yyyy-MM-ddTHH:mm:ss

 

example:

<?xml version="1.0" encoding="utf-8"?>
<tables>
  <table tableName="EcomOrders">
    <item table="EcomOrders">
      <column columnName="OrderID"><![CDATA[DEMOORDER462]]></column>
      <column columnName="OrderDate"><![CDATA[22-08-2016 14:20:14:790]]></column>
      <column columnName="OrderCustomerCompany"><![CDATA[Innovadis]]></column>
      <column columnName="OrderCustomerName"><![CDATA[test]]></column>
      <column columnName="OrderCustomerAddress"><![CDATA[Pantheon 18]]></column>
      <column columnName="OrderCustomerZip"><![CDATA[]]></column>


Replies

 
Jonas Krarup Dam
Reply

Hi Martijn,

The CData is needed, since we cannot know for sure if any given field contains characters that would result in an invalid XML document. You might be able to remove them using XSLT, but if that doesn't work, you will have to do some custom coding to get output without CData.

There is no way to change the output formatting of datetime objects. If you really need this, feel free to post a feature request, and we'll try to fit it into an upcomming version.

/Jonas

 

You must be logged in to post in the forum