IFS Cloud - Importing currency rate file

Can you see it from the assistant?

Hi @cperdue,

Yes, I can, but we are using “batch process”. We have a task schedule running every day in IFS 9 to treat our files. The “online process” it is a manual process.

Thanks,

Gianni

Hi,

We are having same situation, how did you solve it? 

Br

Andreas 

Hi @Andreas_M,

We’ve solved using the external file. I attached, all screen you need to going through. 

If you have any question, you can reach by send me a private message.

Gianni NEVES 

Hey ​@gianni.neves ,

I did everything exactly as you did in the screenshots, but I keep getting the error: ORA-20110: ExternalFileUtility.FILENOTEXIST

What could be the cause? Did you somehow specify which reader the External Transaction should use?

Hi ​@kacperifs ,

Is the file name you configure in IFS, correct? Do you have any job that move the file from a directory to another?

Hey ​@gianni.neves 

Thanks for your reply. I did everything exactly as you did in the screenshots. I get the following messages:

I have not configured any routing rules.

From what I see, the author use .txt file type in the example, so if one wants to use the same setup, the input file type should be in .txt format 

kacperifs-  the error at the application message points to .csv file type, is it possible to replace .csv file with .txt and give it a try

Hey ​@VirajW 

Thank you for your reply. I tried with .txt also and I’m getting same error.

I would double-check the following 
Background job is looking for the file name " STDRCURR_currency.txt " , application message sees  " currency.csv " or now " currency.txt “  
Double-check the converted .txt file, adhere to the External File template setup

Hi ​@VirajW 

That's probably because I tried different variants and chose the wrong background job. Let's start again from the beginning:

1. My READER:

2. Directory which contains file STDCURR_currency.txt

3. 

      

4.

5.

And still getting error.

Is it possible to increase the  log level from warning to debug from warning in setup IFS Connect > Readers to gain more error details

I changed the value to debug, but how can I view a specific message? The one from the Application Message level is still the same.

I just double checked some application messages in the error state don't have thorough error details.

Normally, it resides bottom of the application message

In this scenario, you can get a second look at the whole setup with a fresh set of eyes.

I have just checked Application Messages and Background Jobs, and in both cases there is no detailed information – that is why I am doubtful and looking for information on the forum, because without it I cannot handle it. I am surprised that no Routing Rule is set here and the API External File knows that it should upload the file based on its name. I wonder, since I get a message that the file was not found, maybe it is going to some wrong location?

Some troubleshooting steps that I can think of, if you have not fixed it already.
Check that other file readers in the instance work as expected, or try it on another test instance
Generate a new .txt file (not converted) and see if it works

Hope this helps