Import external files automatically with routing rule

Hi @Zerode ,

did you find the solution?
we have the same problem 

Regards

@Jacques

Hello everyone,

In the end, I decided to recreate the routing rule that I needed.

Then I had to setup my reader and my routing rule together.

But now, I want to import my file into IFS without using a “Schedule” from the external voucher assistant. I want it to be like “when a file is catch by the reader, it’s directly import into IFS”. Is it possible to do it that way ?

Dear @Zerode 

why do you want to import it via IFS Connect?

What kind of files do you want to import?

Hello @Link 

I want to import an ExtVoucher type of file. Which is the same one as you on your post ?

But since i don’t have the “SERVER_DIRECTORY” that you had, I’m a bit lost with the way you did it.

And i’m sorry if this is a dumb question but what is the difference between IFS Connect and IFS Cloud ?

Hi @Zerode 

the setting in IFS Connect aren’t required. 

At first make sure that the mapping works:

Example:

You can test it with the file assistant:

If the process works as required, then you can create the directory with PL/SQL developer or soething else.

About the process, I think it’s working.

What I did to test was :

• Put my files into a directory
• My reader catch thoses files
• I used the External Voucher Assistant in batch mode to create a Schedule
• When the Schedule trigger, all my files that have been load that fit my file template are loaded.

Now, I don’t want any Schedule running in background. I just want it to be execute when a file is catch by my reader. This is where i’m stuck. 😅

I agree that it’s still doing what i want it to do correctly but I’m just curious if this is possible.

Sounds good. Then you need to automate the process.

At first create a physical path on the IFS database server.

Then create it in PL/SQL developer:

CREATE OR REPLACE DIRECTORY IN_PATH 
AS ‘E:\IFS\in\testpath‘;

Then grant it:

GRANT ALL ON DIRECTORY IN_PATH TO "IFSADMIN";

After that you should see the path “IN_PATH” on the tab “Input Files” field Input File Directory (screen External File Template).

@Zerode 

Were you able to manage it? 😊

I forgot to write: If you create the physical path with rmb on “New...” then you don’t need to create it with the query below.

But you can also use the query only.

With the following query you can check if the creation was successfully:

SELECT * FROM DBA_DIRECTORIES

And you need the IFSAPP user...

Hello @Link,

I’m very sorry but I won’t have time to work on this until Friday 😅

I’ll get back to you on Friday or Monday with, I hope, good news ! 😄

But still, thank you so much for your help !

No problem. You are welcome! 👍🏼

Hi @Zerode ,

We are also trying a similar setup as your solution two,
 

• Put the files in a folder in SFTP Server
• Configure Reader and Routing Rule to pick the file up
• Trigger a Custom Event on Application Message Record to execute the External Supplier Invoice logic.
   

But we are having some issues,  ExternalBatchLoadFile.FND_RECORD_EXIST: The External Batch Load File already exists comes up.

Were you able to test out the configuration?

Best Regards,
Devin Amarasekara

Hello @Link,

In the end, we decided to use a Schedule since it’s much easier to setup 😅

Thank you for your time and your help ! 😄

Have a nice day !

Hello @devin.amarasekara 

I’m sorry, i have never setup a  Custom Event before so I can’t help you on this.

Best Regards and have a nice day ! 😃

 Hi ​@devin.amarasekara 
Were you able to complete the configuration? I'm trying to achieve the same thing retrieving files from an SFTP server to create an external supplier invoice.

I imported a file to sftp server and then checked application messages and under error text I have “message of type ‘APPLICATION_MESSAGE’ doesn’t match any routing rule”. 
I’m new to IFS Connect, so any suggestions would be really helpful. Is there something I might have missed? 

Here’s how I’ve configured the reader so far: The host is set to the SFTP server.

and this was how I configured the rule I didn’t add an address:
 

Hi ​@InfShemaG ,

Sorry for the late response, But yes I was able to finish the configuration.

I think what you are missing is the Destination Address.

 

Best Regards,
Devin Amarasekara

Hi ​@devin.amarasekara ,

Thanks for your response. I had to connect a routing address and I had to remove the file path on the routing rule and then it worked:)

Best regards,
Shemani Gawarammana