Message Boards

UTF8 DB.Recipient of datafile cannot handle accent marks.

Jan Westfall, modified 3 Years ago.

UTF8 DB.Recipient of datafile cannot handle accent marks.

Post Date: 9/3/15 (Bronze, 6 Posts) Recent Posts

UTF-8 DB is creating ouput data file which has accent marks.  The recipient of our data file has specifically asked us to remove the accent marks and replace with the corresponding letter without the accent marks. EX: Replace  é with e.  Datafile is generated from Ecommerce output.  Other than writing Progress Code for EVERY field output replacing all possible accent marks is there an easier method?  Not sure if converting to a different code page would help.  Appreciate any help you can offer.

 

thumbnail
Michael Forman, modified 10 Years ago.

Re: UTF8 DB.Recipient of datafile cannot handle accent marks.

Post Date: 9/7/15 (Platinum, 334 Posts) Recent Posts
Hi Jan, This has occurred before. Issue/Symptoms:

CIM fails without error when trying to load French characters. Codepage is UTF-8. CIM seems to load normally until cedilla ( ~) or French accent mark is encountered then CIM load fails without error. Issue arose when doing CIM load for new French site. Note that CIM completed successfully for 2 previous French sites.


Facts/Environment:

2011.1

Root Cause:

Bad data caused CIM load to fail.

Resolution/Fix:

French users removed bad data then CIM loaded normally.
Jan Westfall, modified 10 Years ago.

Re: UTF8 DB.Recipient of datafile cannot handle accent marks.

Post Date: 9/8/15 (Bronze, 6 Posts) Recent Posts
Unfortunately this does not apply to our issue. 1) Have UTF-8 database created with Latin Spanish data. 2) Data file sent to vendor using Ecommerce module. 3) Vendor (who is in Mexico) DOES NOT WANT ANY exported QAD data in the file to contain any accent marks (so they have asked us to export 'e' instead of 'é' with an accent mark (also change a,i,o,u and n) letters which have special characters (accent or tilde over the letter n). I'm wanting to know if there is an easy way to remove the accent and tilde marks in the file other than by searching and replacing all text occurrences in the Progress mapping of the Ecommerce. The Ecommerce file is an XML file.

Message place holder