Skip to main content
Question

Import external files automatically with routing rule

Hello everyone, 

I would like to import an external file automatically by “External File Assistant” (Batch process) exactly like on this topic (Import external files automatically | IFS Community).

Unfortunately, i’ve got a few problems with the solution. 

The first one was to define a value for the parameter “SERVER_DIRECTORY” in “System Parameters For Accounting Rules” but I do not have this parameter in the list.

List of all parameters

The second solution was to setup a Routing Rule with FTP Reader. There was supposed to be a template named “Example_External_File_Import” but I can’t find it.

Should I create it myself or maybe it’s a permission problem ? 

I’m on IFS Cloud (version 22R2)

13 replies

J
Rank
Badge +1

Hi @Zerode ,

did you find the solution?
we have the same problem 

 

Regards

@Jacques

Z
Rank
Badge +2

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 ?

Link
Rank
Userlevel 7
Badge +22

Dear @Zerode 

why do you want to import it via IFS Connect?

What kind of files do you want to import?

 

Kind regards
Z
Rank
Badge +2

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 ?

Link
Rank
Userlevel 7
Badge +22

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.

Kind regards
Z
Rank
Badge +2

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.

Link
Rank
Userlevel 7
Badge +22

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).

Kind regards
Link
Rank
Userlevel 7
Badge +22

@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...

Kind regards
Z
Rank
Badge +2

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 !

Link
Rank
Userlevel 7
Badge +22

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! 👍🏼

Kind regards
D
Rank
Userlevel 1
Badge +5

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

Z
Rank
Badge +2

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 !

Z
Rank
Badge +2

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 ! 😃

Reply


Terms & ConditionsCookie settings