CSV Export Vs DB.XML Export

[sn1405]

Hi all,

Could any one please tell me what is the difference between CSV Export and DB.XML Export.

This page can be accesed in OTM via Business Process and Automation>Data Export.

Thanks and regards,
Pradeep

[chrisplough]

Re: CSV Export Vs DB.XML Export

Pradeep,

At the highest level, the difference is the format that the exported data is provided in. The CSV provides the export file in comma separated format, while the DB.XML provides the data within an XML format.

--Chris

[sn1405]

Re: CSV Export Vs DB.XML Export

Thanks for reply,

Are they any more diffrences between CSV Export and DB.XML Export.

Regards,
Pradeep

[AlejandroBarba]

Re: CSV Export Vs DB.XML Export

Hi Pradeep,

Other difference for certain elements is that the CSV export only works on one specific data table at a time. If you want to export a Location, you need to export one the following tables one by one:
Location
Corporation
Location_refnum
Location_corporation
Location_address
Location_role_profile
All the information from the different tables are present in only one XML file.

Hope this helps,

Alejandro B.

[vsevs]

Re: CSV Export Vs DB.XML Export

Can anyone suggest me how to use DB.XML format to upload consolidated invoices. If possible give me a sample XML file for Consolidated invoices?