Make import of csv ile independend of regional settings
im in the netherlands and i have to change the regional settings to US in order to be able to import a csv file
without changing regional settings it doesnt work!
Really? What happens when you try with your local settings?
What country version of ACT!?
Regards,Mike LazarusACT! EvangelistGL Computing, AustraliaJoin the LinkedIN ACT! Fanatics Group - http://www.linkedin.com/groups?gid=49896
Dutch or UK version of ACT! doesn't matter, all have the same problem
the csv file isn't recognized as long Dutch (and other then US ?) regional settings are used
(fields aren't seperated, so can't do field mapping)
in US regional settings:
Decimal symbol is . (point)
Digital groupng symbol is , (comma)
The default list seperator is , (comma)
in Dutch regional setiings:
Decimal symbol is , (comma)
Digital groupng symbol is . (point)
The default list seperator is ; (point/comma)
Once you know its easy to change setting and do the import via a csv file and change it back when finished.
Average user dont understand this and is only experiencing problems with import
This is with ACT! 2010?
I haven't heard of this, and I'm in Australia... but deal with a lot of resellers in the UK
Does it work if you edit the source and Replace (comma) to (point) and (semi-colon) to (comma) ?
EG: Is ACT! just using the regional settings correctly, but needs ability to detect the others?
If you're a member of the LinkedIN ACT! Fanatics Group (free to join), we do have a discussion on items that only effect users outside North America:
Would be worth while posting this there
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.