Hello:
Overseas, we have many users with accent marks and tildes over letters of their names. These names are imported into GP, through Integration Manager, as sales contacts for invoices.
The problem is that, whether the import file is saved as a tab-delimited text or comma-delimited text file, these accents and ultimately the names of these salespeople appear garbled in SQL tables due to the accents and tildes not importing correctly.
Prior to importing these sales invoices, our Finance department will occasionally open up the import file to make any necessary corrections. When the file is re-saved, afterward, the accent marks and other similar items do not remain intact. That's what causes the issue.
Our main business analyst "across the pond" who overseas this importing has tried "playing with" ANSI-encoding and Unicode features of saving this file prior to import.
But, no matter how he does things, the import still has this issue. As a "backup solution", he has a VBA macro which is able to replace accent letters in names to non-accent letters (i.e. ó to o or ñ to n). But, this is a workaround, rather than a long-term solution.
Has anyone out there tackled importing data into GP where the names of individuals have accent marks and other special symbols?
Thanks! Much appreciated!
John
