Skip to main content
Solved

Import CSV file with IFS Connect

  • August 31, 2021
  • 2 replies
  • 1337 views

Forum|alt.badge.img+9
  • Sidekick (Employee)
  • 50 replies

Hi, 

To import a CSV from FTPS , we would like to use IFS Connect.

And from my understanding, the flow will be:

  1. IFS Connect – FTP Reader FTPS
  2. IFS Connect – Routing Rules , Routing Address
  3. In Routing Address – we need develop an transform (in Java or xlst) , convert CSV to IFS XML
  4. Then, to read that IFS XML and insert into DB,  we need develop a BizAPI

Is the understanding correct?  And how people do this in Real Project?

 

Also, with IFS Cloud,

since we are discarding BizAPI,  then how we implement the actual logic to insert data to DB.

Best answer by BLLBrucemo

Does anyone know how to setup the FTP reader? I can get the sender to work, but the reader doesnt seem to work. I am not seeing any logs written to verify whats happening?

Is there an application server process i need to enable for the polling?

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

2 replies

dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 880 replies
  • September 7, 2021

If you are in Apps10, best approach is to use PL/SQL Methods instead of BizApi so it will be future proof.

With PLSQL method, you can process the CSV directly inside the PLSQL logic or if you need more sustained approach, develop PLSQL method to take generic XML/Json input and add a transformer to convert CSV to the XML/Json. By that way you can change the input file format without needing to modify PLSQL logic.

So the approach will be

  1. IFS Connect – FTP Reader FTPS
  2. IFS Connect – Routing Rules , Routing Address
  3. Transformer (optional) to convert CSV to generic format
  4. PLSQL method - Takes CLOB IN argument. CSV/XML/Json is parsed and processed inside here.

Read more about PLSQL methods here: PL/SQL Methods (ifs.com)

Cheers!

Damith


Forum|alt.badge.img+11
  • Sidekick (Customer)
  • 126 replies
  • Answer
  • September 10, 2021

Does anyone know how to setup the FTP reader? I can get the sender to work, but the reader doesnt seem to work. I am not seeing any logs written to verify whats happening?

Is there an application server process i need to enable for the polling?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings