Dear Sergey,
I have created an xml export template. In another, I have created an xml import template. There is wrong behavior for numeric fields.
The number format is the same for both entities (exported and imported) "2/,/.", and the prefix is "₺" (turkish lira symbol).
The problem is when import the xml, it imports the numeric fields with wrong format and add the "₺" symbol to the field value (not as prefix) ansd there are two ₺ symbols because of original prefix, and of course behave as text not numeric.
And the number 36.000,00 is imported as 36.000.00 (the first on should be dot, second one comma, but there are two dots.)
In think, the xml export should contaion only raw data, not number format or prefix/suffix for numeric fields.
You can see from the screenshots.
Wrong behavior of XML export and import
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Wrong behavior of XML export and import
The number in XML should be true number. The value should be 36000.00
And other case app can't convert correctly this number.
And other case app can't convert correctly this number.