Notifications

296 views

Currency field value on a table is not exported via XML export

Problem
After export, the record from any table contains currency field to XML file. When modifying the currency value in the XML file and import gain, the currency field value does not update.

 

Symptoms
1. Open the core_company table.
2. Open company ACME Africa, and set profit to $1234.00.



3. Export the record to XML file. The profit is shown on the XML file.



4. Modify the value for Profit, a currency field, to $1000.00. Save the record.



5. Import the XML file saved from step 3.

Note that the currency field value did not update.

 

Cause
The XML export feature is designed to work for exporting records from a table as is (raw data), without dependents such as currency records. This behavior is as intended.

Resolution
Export/Import of currency fields should be done through other methods such as Excel/Csv/Import sets where the value of the currency field is exported and imported.

Any method involving direct web services or XML has to separately transfer the fx_currency_instance table records first, and then the parent records (thus wanted record).
 

Article Information

Last Updated:2018-01-02 07:49:18
Published:2018-01-02
2017-04-10_1707-xml-profix.png2017-04-10_1713-profix.png2017-04-10_1714-import.png2017-04-10_1715-result.png2017-04-10_1717-export.png