How to schedule to IFS send a fila from IFS Server to FTP?

Hi Erik!

Thanks for your help!

I already created a Connectors Senders, where I set a FTP as an Instance Type.

I set the FTP IP, User, Password. Guess everything is correct so far.

Now, do I need to configure a Router Address or not?

I tried to dig into Router Rules, but I coudn’t make any progress there.

What is my next step? I need to get the CSV file and send to the FTP that I set in Connectors Senders.

After that, I need to schedule to do this each two hours.

How do I do that? Is there a way?

Thank you so much!!!

Hi @farze ,

We use FTP to send an XML file to our EDI partner as part of EDI integration.  You’ll need to create an FTP Sender instance with FTP IP Address, Username, Password, security protocol and connect mode.  We have security protocol set to NONE and connect mode set to PASSIVE.

Next you’ll need to create a routing address such as the following.

Next you’ll need to create a routing rule similar to the following.

Regards,

William Klotz

Hi @farze ,

You need something to kickoff the routing rule you’ve setup to send you CSV file that you’ve generated using IFS Migration.   If you are familiar with writing PL/SQL code you could create a custom event and event action which executes and kicks off the a Post Outbound BizAPI call to basically start the routing rule engine to match your custom BizAPI event with a routing rule.

We have a custom routing rule which has a message function of SEND_PRODUCTION_DASHBOARD and receiver of IGNITION.  This routing rule call a routing address that uses a RestAPI to post our production line information to a dashboard to another application.   We created a custom PL/SQL package that builds the message and data we wish to send then we call the Post_Outbound_BizAPI call to place it in the routing queue so IFS will match the Message Function and Receiver to our routing rule.   

We use a Transformer on the routing address to convert the data from XML to JSON which is then sent to the remote application.  I’m not sure if IFS has a built-in converted to CSV but you could create a custom transformer to perform the task.

Go here then search for some key items.

IFS Application 10 Technical Docs

Search for PLSQLAP_Document_API and Post_Outbound_BizAPI

Read through BizAPI under overview and PLSQLAccess Provider and Plsqlap_Document_API_Overview and Plsqlap_Server_API_Overview.   

Here’s a segment of the code which builds the data document and posts the message.  You would do something similar but with your data instead.

   --Declare the variable
   msg_payload_ PLSQLAP_Document_API.Document;

   --Create the new document
   msg_payload_ := PLSQLAP_Document_API.New_document('DASHBOARD');

   --Fillin the information using a key/value pairing.
   PLSQLAP_Document_API.Add_Attribute(msg_payload_, 'SHOP_ORDER', order_no_);
   PLSQLAP_Document_API.Add_Attribute(msg_payload_, 'PART_NO', part_no_);
   PLSQLAP_Document_API.Add_Attribute(msg_payload_, 'PART_DESCRIPTION', part_desc_);
   PLSQLAP_Document_API.Add_Attribute(msg_payload_, 'QUANTITY_DUE', qty_due_);
   PLSQLAP_Document_API.Add_Attribute(msg_payload_, 'PACK_SIZE', pack_size_);
   PLSQLAP_Document_API.Add_Attribute(msg_payload_, 'FLUID_TANK', fluid_tank_);
   PLSQLAP_Document_API.Add_Attribute(msg_payload_, 'FLUID_NO', fluid_part_no_);
   PLSQLAP_Document_API.Add_Attribute(msg_payload_, 'PRODUCTION_LINE', shop_workcenter_);      
   PLSQLAP_Document_API.Add_Attribute(msg_payload_, 'ASSEMBLY_GALLONS', assembly_gallons_);
   PLSQLAP_Document_API.Add_Attribute(msg_payload_, 'FLUID_DENSITY', fluid_density_);
   PLSQLAP_Document_API.Add_Attribute(msg_payload_, 'LOT_BATCH_NO', lot_batch_no_);
   PLSQLAP_Document_API.Add_Attribute(msg_payload_, 'PRODUCT_CODE', product_code_);

   --Call API to post the message
   Plsqlap_Server_API.Post_Outbound_BizAPI( 'SEND_PRODUCTION_DASHBOARD', msg_payload_, 
                                            NULL, 'IGNITION', 'EVENT_BIZAPI' );

Regards,

William Klotz