GXS AI: how to process slash in XML data

If you are working with XML in GXS AI and your data contains a slash (like <Date>2016/01/08</Date>), you might face a situation when your map cannot process it, since slash is a special symbol.

Since this question is raised from time to time, I decided to write a short post about it. There are 2 ways (we are speaking about the map development, not about the map working in the production system):

1. you can change your data manually and add a release character in front of your slashes in the data
-or-
2. you can run otxmlcanon.exe pre-processor which would “fix” your XML file and do the same as it described in #1

otxmlcanon.exe -r \ _in.xml

Then, in your source model you should add release character:

SET_FIRST_DELIM(62) ; >
SET_SECOND_DELIM(60) ; <
SET_THIRD_DELIM(47) ; /
SET_FOURTH_DELIM(34) ; "
SET_FIFTH_DELIM(39) ; ,
SET_RELEASE(92) ; \ – this one is important

Gennady Kim

Advertisements

6 thoughts on “GXS AI: how to process slash in XML data

      • It ain’t possible to get this information from AI_HELP.
        We were running the following comment for each files in bash scripts first, then translate them.

        xmllint –c14n $FILE

        Really good to know that someone was also dealing with these problems:) Did you ever deal with GXS Mapper?


        Regards,
        Koral Cayla

    • when you run your test from the command line, try to “play” with locales

      -DLOCALE=”English_UnitedStates.UTF-8@Binary”
      -DLOCALE=”English_UnitedStates.Latin1@Binary”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s