Is ION Desk splitting functionality available for XML files?

ruwo · 2025-01-16T13:17:56+00:00

There was an error rendering this rich post.

I am exploring the use of splitting an XML file in ION Desk to split it in multiple XML file per Item. After that step I want to map it to an ItemMaster BOD. The incoming XML file is not a standard BOD, but a Windchill XML. I can split a standard BOD e.g. a PurchaseOrder into a BOD per orderline, but when I use it for my Windchill XML with defining a path for splitting on the Part tag, it finds 0 instances.

I have created an Object Scheme for my Windchill XML file te enable a dataflow with the split function

Please advise

Find more posts tagged with

Accepted answers

Brandon Watson

<SyncItemSplit releaseID="9.2"><ApplicationArea><Sender><LogicalID>infor.file.parts</LogicalID><ComponentID>External</ComponentID><ConfirmationCode>OnError</ConfirmationCode></Sender><CreationDateTime>2025-01-23T17:33:00.061Z</CreationDateTime><BODID>infor.file.parts:::</BODID></ApplicationArea><DataArea><Sync><TenantID>TENANT_TST</TenantID><AccountingEntityID/><LocationID/><ActionCriteria><ActionExpression actionCode="Replace"/></ActionCriteria></Sync><ItemSplit><Release NAME="string" TYPE="string" STATUS="243"><Transaction><TransactionNumber>132</TransactionNumber><ReleaseNumber>237</ReleaseNumber><PrimaryObjectID>string</PrimaryObjectID><CreatedBy>string</CreatedBy><CreatedDate>string</CreatedDate><Locale>string</Locale><Destination>string</Destination></Transaction></Release><AddedParts NAME="string" TYPE="string" STATUS="69"><Part><ObjectID>string</ObjectID><Class>string</Class><LastChangedBy>string</LastChangedBy><Number>string</Number><DefaultUnit>string</DefaultUnit><Name>string</Name><PartType>string</PartType><Source>string</Source><State>string</State><View>string</View><IsPhantom>1</IsPhantom><Version>string</Version><Iteration>214</Iteration><EnterpriseVersion /><PreviousVersion>string</PreviousVersion><IsConfigurable>1</IsConfigurable><IsCollapsible>true</IsCollapsible><AssociatedEffectivityID /><IsAllocatedAsResource>true</IsAllocatedAsResource><DTTranslationLanguages /><TargetID>string</TargetID></Part></AddedParts></ItemSplit></DataArea></SyncItemSplit>

I think I see the issue now. You are only picking up the BOD content. You will need to add the BOD Header information to the xml that you pick up. Above is an example of a full BOD, including header. If you try this, it should work for the Data Flow that you have.

All comments

Brandon Watson

https://community.developer.infor.com/discussion/432/is-ion-desk-splitting-functionality-available-for-xml-files

Does the Windchill XML node show as a Repeatable property in the Object Schema. In the below case, both User and Order show as a Repeatable Property allowing for repeated nodes. The splitter can only split on Repeatable Properties. If you want to paste the raw view of the Windchill XML, I could help you validate this.

ruwo

Hi Brandon thanks for you help. I had already set Repeatable to yes for the Part Property, but based on your suggestions I also did this for one level higher 'AddedParts', but without succes. I minimized my Windchill XML and the related scheme to the relevant parts for test purposes.

TestSplit.txt

Brandon Watson

Hello ruwo - Sorry for delay. I downloaded your XSD file, converted it to a sample xml and then created the data catalog item from that sample. I was able to then split that BOD on AddedParts and Part, along with all of the nodes under Part, which I don't think is needed, but it does seem to be working. Can you give me a sample BOD to work with? I usually create a sample bod and use that to generate the metadata in ION, that way the XSD is converted there.

ruwo

https://community.developer.infor.com/discussion/comment/892#Comment_892

Hello Brandon, I sent the XSD file because you requested the 'Raw view'. I thought you meant that. Please find attached the XML that I used to generate scheme.

Split_WC2INFOR.txt

Brandon Watson

What node are you trying to split on exactly? I was able to take your sample and be able to split on Part node only. Is that what you are looking for? I just had the Data Catalog schema wizard create the schema from your sample xml file. Your issue is definitely with the XML. I would just mess with that schema until you get it working.

ruwo

https://community.developer.infor.com/discussion/comment/907#Comment_907

Hi Brandon,

I agree, everything works fine until that point. I have added a connection point at the end to save the new documents, and put the combined xml in the input folder. The result is the same xml document (different name, thus processed) in the output folder, not split into two.

And also in Oneview it shows no part occurances

Brandon Watson

<SyncItemSplit releaseID="9.2"><ApplicationArea><Sender><LogicalID>infor.file.parts</LogicalID><ComponentID>External</ComponentID><ConfirmationCode>OnError</ConfirmationCode></Sender><CreationDateTime>2025-01-23T17:33:00.061Z</CreationDateTime><BODID>infor.file.parts:::</BODID></ApplicationArea><DataArea><Sync><TenantID>TENANT_TST</TenantID><AccountingEntityID/><LocationID/><ActionCriteria><ActionExpression actionCode="Replace"/></ActionCriteria></Sync><ItemSplit><Release NAME="string" TYPE="string" STATUS="243"><Transaction><TransactionNumber>132</TransactionNumber><ReleaseNumber>237</ReleaseNumber><PrimaryObjectID>string</PrimaryObjectID><CreatedBy>string</CreatedBy><CreatedDate>string</CreatedDate><Locale>string</Locale><Destination>string</Destination></Transaction></Release><AddedParts NAME="string" TYPE="string" STATUS="69"><Part><ObjectID>string</ObjectID><Class>string</Class><LastChangedBy>string</LastChangedBy><Number>string</Number><DefaultUnit>string</DefaultUnit><Name>string</Name><PartType>string</PartType><Source>string</Source><State>string</State><View>string</View><IsPhantom>1</IsPhantom><Version>string</Version><Iteration>214</Iteration><EnterpriseVersion /><PreviousVersion>string</PreviousVersion><IsConfigurable>1</IsConfigurable><IsCollapsible>true</IsCollapsible><AssociatedEffectivityID /><IsAllocatedAsResource>true</IsAllocatedAsResource><DTTranslationLanguages /><TargetID>string</TargetID></Part></AddedParts></ItemSplit></DataArea></SyncItemSplit>

ruwo

https://community.developer.infor.com/discussion/comment/915#Comment_915

Sorry, have been away for a few days. But you are right. It really needs to be a BOD. So I now convert my original Windchill XML to a BOD via the Mapping functionality in ION Desk en then it can be split. Thanks!

ruwo

Just an additional question. Is it possible to use the content of a property within the repeatable node (e.g. the item number) to create the filename of the split file?

Brandon Watson

https://community.developer.infor.com/discussion/comment/961#Comment_961

I would say yes, with scripting or custom mapping, but you wouldnt be able to reach that value from the normal file write scenario. Below are the options available and that would not include the attribute filter property of the repeated node.