Originally posted by: SystemAdmin

I need examples of XML files used to load data into Commerce Manager using the XML File Load Utility. We use 6.5, but, any version is fine.

Please CC your reply to:
Tom Lander
tlander@expertig.com
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Below is a sample that enters one X12 Trading Partner and three Post Offices. You will have to modify the DTD name to match the version in use (which may be "mercpm61.dtd"); you may also have to fully qualify the path to that DTD if it's not in the same directory as the XML Autoload.

If you are familiar with Datastage TX mapping, it may help you to generate a type tree from the DTD and generate your XML that way.
code:1:c26c84c6d1<?xml version="1.0"?>
<!-- Mercator Partner Manager Autoload Sample XML -->
<!DOCTYPE PartnerManagerAutoLoad SYSTEM "mercpm70.dtd">
<PartnerManagerAutoLoad>
<X12TradingPartners>
<IntExt>I</IntExt>
<PartnerName>Test Partner Name</PartnerName>
<IchgQual>ZZ</IchgQual>
<IchgID>558521</IchgID>
<Auth>Auth</Auth>
<SecurityQual>00</SecurityQual>
<SecurityPassword>SamplePassword</SecurityPassword>
<IchgCtrlStdsID>U</IchgCtrlStdsID>
<IchgCtrlVerNo>00305</IchgCtrlVerNo>
<ElementSeparator>21</ElementSeparator>
<SubElementSeparator>0D 0A</SubElementSeparator>
<SegmentTerminator>0D</SegmentTerminator>

</X12TradingPartners>
<PostOffices>
<POName>TEST Post Office1</POName>
<Get_Put_Indicator>G</Get_Put_Indicator>
<POType>FILE</POType>
<AdapterString1>U:\UnixDir</AdapterString1>
</PostOffices>

<PostOffices>
<POName>TEST Post Office2</POName>
<Get_Put_Indicator>G</Get_Put_Indicator>
<POType>FILE</POType>
<AdapterString1>U:\UnixDir</AdapterString1>
</PostOffices>

<PostOffices>
<POName>TEST Post Office3</POName>
<Get_Put_Indicator>G</Get_Put_Indicator>
<POType>FILE</POType>
<AdapterString1>U:\UnixDir</AdapterString1>
</PostOffices>

<PostOffices>
<POName>TEST Post Office4</POName>
<Get_Put_Indicator>G</Get_Put_Indicator>
<POType>FILE</POType>
<AdapterString1>U:\UnixDir</AdapterString1>
</PostOffices>
</PartnerManagerAutoLoad>[/code:1:c26c84c6d1]
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

We have two similar transactions using XML. When we developed the system (version 6.0) XML was not supported in CMgr.

Our file was simple. The entire transaction was in a single XML tag. We stripped the XML off and processed the remainder.

Not sure 6.5/6.1 can handle XML either.

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

Originally posted by: SystemAdmin

Perhaps I missunderstood, do you want to process XML transactions via CMgr or load Partner data in to the Cmgr tables via XML (bypassing the Partner Manager interface)?

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

Originally posted by: SystemAdmin

In somewhat a related topic, I was wondering if anybody has automated their process of entering new partner info in Commerce Manager.

We have a information that is being updated in a seperate Database for mainframe verification of EDI data, but would also like to figure out someway to automate the process of getting data in CMGR.

Anybody been able to automate this process?
Thanks,

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

Originally posted by: SystemAdmin

eds5,

The only supported way is by using the XML Autoload utility. We have many customers using it to automate the loading of CMGR data.

In addition, starting with CM version 7.5, we added a command-line interface to the XML Autoload so that it can be run unattended. Also, starting in CM 7.5, you can change or delete data via XML (prior versions only supported "add").

If you know mapping, you can generate the XML source via maps, using the DTD importer against the DTD shipped with the utility. Or, you can create the XML via code, the format is fairly straight-foward (except Trade Links can be a bit tricky).

Hope this helps!
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender