Is possible to have a unique file name while implementing a ION integration.

LuisRodriguez92 · 2025-03-03T13:16:44+00:00

There was an error rendering this rich post.

TLDR:

Is it possible to configure the SFTP output in the Infor M3 IMS-connector so that the file name is built dynamically from the XML content? For example, instead of a static pattern like 'Name_[current_datetime].xml', can we generate a file name in the format '[Test_Value2_CIF]_[current_datetime].xml', where 'Test_Value2_CIF' is extracted from the XML output?

So this is our use case.

We received a xml file in a SFTP, when the file is received this trigger an agreement (created in MEC Mapper).

In the "processed" section of the agreement I chose "XML Transform" and then "Send".

When the file is received in the Infor m3 IMS-connector, we sent it to a SFTP, here we can choose the "File Name Pattern", and we need to adjust the name according some variables defined within the Agreement Code e.g [Test_Value2_CIF]_[current_datetime].xml

So far we were only able to do somethine like this Name_[current_datetime].xml

This is the workflow→

1.I have created an Agreement using MEC mapper.
2.I have created Object schemas.
3. I have created DataFlows for this matter.
4.I have created two Connection Point in order to send a file from a SFTP to Infor M3 IMS-connector and sent a file from Infor M3 IMS connector to a SFTP

This is a sample content I sent from M3 to SFTP→

<?xml version="1.0" encoding="UTF-8"?><Test xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

    <Value1 Ref="XXXXXX"/>

    <Value2  CIF="XXXXXXX" />

    <Client ClientID="9999"/>

    <Value3>

        <Val3 CustomerID="1020" />

    </Value3>

    <Value4>

        <Val4 PORef="23232323"/>

    </Value4>

    <Value5>

        <Val5 SupplierSKU="XXXXXXXXXX"  UP="2.9" Total="14.5"/>

    </Value5>

    <Value6>

        <Val6 Type="IVA" Rate="4" Base="9999" Amount="9999"/>

    </Value6>

    <Val7 Total="9999" Tax="99" SubTotal="9999"/>

</Test>

Find more posts tagged with

Accepted answers

CWRIGHT

Worth mentioning that if the file is originating from M3 MEC, and you have the option to customize the MEC map, you can set custom headers directly without needing to use ION Scripting. You can also set the ION Document ID this way.

setManifestInfo(ManifestConstants.MAP_ION_CUSTOM + "FileName", NBNR + "_" + DLIX);

setManifestInfo(ManifestConstants.MAP_ION_DOCUMENT_ID, NBNR);

Connection point file name: [Custom_FileName]I003[current_datetime].xml

Do note however that if you use MEC or Kevin's way in ION Scripting, you are subject to a limit of 3 custom header fields.

https://docs.infor.com/inforos/2025.x/en-us/useradminlib_cloud/default.html?helpcontent=iondeskceug_cloud_osm/rjw1569847387732.html&hl=custom%2Cheader

For your scenario there may be no need to set the custom headers in data catalog (as you aren't using them in dataflows for routing), but I believe the limit of 3 still applies.

All comments

Kevin Heiman

XML Schemas can have Custom Headers.

You would then use a script to find the XML element of data, and then add it to the header for the next step (FTP connection) to use in the name.

https://docs.infor.com/inforos/2024.x/en-us/useradminlib_cloud/default.html?helpcontent=ioncedg_cloud_osm/kvv1569931958834.html

a script example that would be extended to parse the XML element data ;

Kevin Heiman

Adding that you could have the producer of the document / BOD put the data in the header for you, vs using a script to extract and populate.

CWRIGHT

setManifestInfo(ManifestConstants.MAP_ION_CUSTOM + "FileName", NBNR + "_" + DLIX);

setManifestInfo(ManifestConstants.MAP_ION_DOCUMENT_ID, NBNR);

Connection point file name: [Custom_FileName]I003[current_datetime].xml

Do note however that if you use MEC or Kevin's way in ION Scripting, you are subject to a limit of 3 custom header fields.

https://docs.infor.com/inforos/2025.x/en-us/useradminlib_cloud/default.html?helpcontent=iondeskceug_cloud_osm/rjw1569847387732.html&hl=custom%2Cheader

For your scenario there may be no need to set the custom headers in data catalog (as you aren't using them in dataflows for routing), but I believe the limit of 3 still applies.

Kevin Heiman

Noting that if you use a custom header, you do need to define it in the catalog so that in the File Name builder you will have that choice when you request the prompt for what is available.
You may be able to just type it in, but recommend defining in catalog. Maybe you eventually would want to notify someone of the delivery (or failure) of the file name .
https://docs.infor.com/inforos/2024.x/en-us/useradminlib_cloud/default.html?helpcontent=iontechconceag_cloud_osm/lsm1436532314824.html

LuisRodriguez92

Thanks a lot! This was a straightforward approach! While I was trying to implement Kevin's suggestion, I found that your answer was easier to implement.