IBM Support portal is very useful for those of us who is working with GIS/SI/Gentran. But VERY often there are some problems with the text format. For example here you see a total mess instead of an SQL query:
To “convert” it into the right code, just copy this text with using of your mouse. Create a file with “html” extension, open it in your text editor, put <pre> </pre> tags and put the copied code between them. Save&Close, and open it in your browser:
As you can see, it’s a correct SQL code now.
Working on a migration to SI 5.2 project, I installed a new version of Map Editor (8.***). But when I tried to test my map, I got an error: “A Java 1.7 Runtime Environment must be installed to use this function, but one could not be located. Please install a Java 1.7 Runtime Environment and retry this operation.”. I downloaded Java 1.7 JRE from here, installed it – but it didn’t help :-|. “java -version” gives me “1.7” but Map Editor didn’t “see” it. I checked the registry keys it looked for and found that it tried to use HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\JavaSoft\1.7 , but I didn’t have one. So, as a temporary solution I added it to the registry (just copied it from existing 1.6) – and now it works fine. Not sure about my “solution” here, but it works for me and I have no time to find out what was the exact reason of my problems.
Variables (and Arrays)
In this lesson we’ll see how to use variables and the difference between variables and arrays.
It’s time to start working with more complex structures which are more similar to the “live” documents. We’ll be using our map “example02” we created on previous step as the base. Let’s change it.
First of all, we need to change the structures of both source and target documents. In the real life documents usually contain three main parts (blocks of data):
- Header. This block usually contains the document number/date, addresses and so on – the common information.
- Details. Usually there some kind of a repeatable data (Line Items and their IDs, names, quantity, price and so on)
- Summary section. This block contains all the total amounts, taxes/fees, total quantities and so forth. This section is very similar to the Header section, but often it is placed at the end of the document to emphasize its “summary” role (like you can see in the paper documents).
Arrays of data
In this lesson I’ll introduce you a concept of arrays in GXS AI.
Our first map we created on previous lesson is pretty simple. Both source and target have almost the same structure, only one type of records and a few fields. In real life such maps are very seldom. So, we need to gradually work on more and more complicated maps. Let’s get started!