Sep 28, 2021
Henryk Ćwik
wrote
Hello,
I have problem - Im importing .xls file with prices in format XXXX,XX and importer dont recognize separation between main and decimal number - result is XXXXXX.
Do anyone had this problem before?
I have problem - Im importing .xls file with prices in format XXXX,XX and importer dont recognize separation between main and decimal number - result is XXXXXX.
Do anyone had this problem before?
Reply
9 Answers
Sep 29, 2021
Support Manager
agent
wrote
Thanks for yoru post. Most likely the separator is not correct. Use either dot or comma https://prnt.sc/1u3681l If the issue remains, please write us with details and import file+ Import configuration file (can be saved on the last step of the import: in cfg format https://prnt.sc/vxkzrk ) at our support contact@emagicone.com
Sep 30, 2021
Henryk Ćwik
wrote
Hi Nadia,
Much thanks for help, I actually never noticed this option before, I dont know how I missed it ;-)
Changed from , to . and works perfectly as before.
Best regards!
Much thanks for help, I actually never noticed this option before, I dont know how I missed it ;-)
Changed from , to . and works perfectly as before.
Best regards!
Oct 01, 2021
Support Manager
agent
wrote
Glad to assist you :)
Nov 11, 2021
Perrone Vincenzo
wrote
in the thousands field write "blank" empty space
Nov 11, 2021
Support Manager
agent
wrote
Hello Vincenzo, please specify your query. You leave thousand field blank and there are troubles on file separation?..
Nov 11, 2021
Perrone Vincenzo
wrote
yes,
yes, you have to write space/blank " " no "" or "."
yes, you have to write space/blank " " no "" or "."
Nov 12, 2021
Support Manager
agent
wrote
Thousand field is used for detecting the separator value that allows differing the numbers. It does not influence the number of values that will be imported or exported. Also, we can see that you created a ticket contacting us on cantact@emagicone.com. We replied your question also there