Originally posted by: swatiroi22

Hi,

We are usinf the WTX 8.3.0.4 and the NACHA business pack.

We are reading the data from the NACHA input file and putting it in MySQL database. To begin with we had added validation rules to process and map only the file header and the batch header recoreds from the input file. Please note that the input file is as per the NACHA message format and consits of many batches and the detail records.

But when we are executing only one batch header record is getting inserted in the table although there are many batches present in the input file.

Can anybody help us on this? If somebody can share the example map/pointers for this that will be really helpful to us.

Also please note that we have not added any rules/mapping for the detail entries in the input file assuming we will go step by step after batch header is done we will move to detail records.

Urgent help/inputs for this will really be helpful to us.

Thanks in advance.

-Swati
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: NancyR

Did you use a functional map to process your batch(s)?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: swatiroi22

We are new to WTX. So not clear with the terms functional map and executable map. we are trying to learn more about it.

But as far as our implementation goes we have created only 1 map and has got 1 input card and 2 output cards each for transfering the input data into two different tables.

This is where we are seeing that data for all the batches are not getting inserted in the batch header table.

So any inputs on that front?

And thanks for the reply.

-swati
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: NancyR

If you don't understand the difference between functional and executable maps you need to take a training course as they are pretty basic to understanding WTX.

If you post an project interchange I should have time to take a look.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: swatiroi

Thanks so much for the reply.

In meantime we read about functional maps and its implementation. We realized that we need to use Functional maps to process all the records from the input file in the database.

We are proceeding fruther in the direction of using the Functional Maps. We may need any pointers related with the functional maps implementation but for time being we are trying to run the simple example for the Functional Maps.

We have planned to use the same approach for our actual NACHA message transformation.

Thanks again for the help and time.

-Swati
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: swatiroi

Hi Nancy,

Here is the project interchange attached with this thread which we were trying to run for Functional Maps usage. This is the simple Cobol to XML copy book example.

Input Text File Records -
WIDGET 16 JOHN DOE 122 NORTH ST MIAMI LL 33177
WWIIET 17 JJJJ ABC 123 SOUTH NT JAPAN MM 33178
Output XML Data -
<purchaseOrder orderDate="2011-07-08">
<item>WIDGET</item>
<item_count></item_count>
<shipTo>
<name>JOHN DOE</name>
<street>122 NORTH ST</street>
<city>JOHN DOE</city>
<state>LL</state>
<zip></zip>
</shipTo>
</purchaseOrder>

Unfortunately we are still able to transfer only one recrod to the XML file.

Please note that the approach we followed to use the Functional Maps could be wrong or may contain some mistakes.

Could you please take a look at it and let us know where exactly we have done mistakes?

Thanks a lot for your help and time. Your help is much appretiated.
-Swati
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: NancyR

It would have been helpful if you had included your source file in your project interchange.

The first problem was that you never added a file type to the tree generated from the Cobol importer. Since the input card to your map defined only a single record the WTX engine would only read one input record. When you ran the map you should have gotten a message saying "Input valid but unknown data found".

The type tree representing your XML output has no repeating object. Since you did not include the schema I can't tell if that was true of the schema as well. I modified the type tree to contain multiple purchaseOrder elements.

I hope you get a feeling for how functional maps work from the modified map source file attached.

WTX is a very powerful tool. I would strongly recommend your taking some courses so you will be able to take full advantage of the product.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: swatiroi22

Thanks so much for the solution. It worked-:).

Although as you commented, we required to do the changes in the XSD and then could run the example. That was a big thing for us.

Also we have got an idea of using the Functional Maps and now working on implementing the same in the our actual NACHA message transformations.

Thanks so much for your help and time.

Also as suggessted by you we would defintitely like to take course for usage of WTX, but currently its not possible because of some other issues which we cant quote here. Bottomline is we have to work on our own and complete this task by self learning process.
-Swati
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange