Decimal numbers combines with main numbers without separation

Decimal numbers combines with main numbers without separation

Sep 28 (7 months ago)
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?
Reply
9 Answers
Avatar image
Sep 29 (7 months ago)
Nadia Bezpalko 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 (7 months ago)
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!
Avatar image
Oct 01 (7 months ago)
Nadia Bezpalko agent wrote
Glad to assist you :)
Avatar image
Nov 11 (6 months ago)
Perrone Vincenzo wrote
in the thousands field write "blank" empty space
Avatar image
Nov 11 (6 months ago)
Nadia Bezpalko agent wrote
Hello Vincenzo, please specify your query. You leave thousand field blank and there are troubles on file separation?..
Avatar image
Nov 11 (6 months ago)
Perrone Vincenzo wrote
yes,
yes, you have to write space/blank " " no "" or "."
Avatar image
Nov 11 (6 months ago)
Perrone Vincenzo wrote
so
Avatar image
Nov 11 (6 months ago)
Perrone Vincenzo wrote
.
Avatar image
Nov 12 (6 months ago)
Nadia Bezpalko 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