Solved

Import CSV file with IFS Connect

  • 31 August 2021
  • 2 replies
  • 1022 views
S
Rank
Userlevel 5
Badge +9
  • Shou
  • 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.

icon

Best answer by BLLBrucemo 10 September 2021, 13:58

View original
This topic has been closed for comments

2 replies

dsj
Rank
Userlevel 7
Badge +20

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

DSJ - https://dsj23.me
B
Rank
Userlevel 6
Badge +11

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?

Terms & ConditionsCookie settings