Regarding Requirement Query

[Former Member]

hi

this is my requirement

Read a CSV file ( Header, Body, Trailor)

Reading File name is required along with Time Stamp.

Part of file name need to be extracted to make a query

Select Query to table 1 (Synchronous)

Select Query to table 2 (Synchronous)

Select Query to table 3 (Synchronous)

Insert into one table using all previous Select and CSV data.

Collect no of rows updated.

Give me good solution how to solve this

[Former Member]

Hi,

1)Read a CSV file ( Header, Body, Trailor)

You need to use the File content conversion using Key field value refer the belwo weblog

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

2) Reading File name is required along with Time Stamp.

You need to use the dynamic configuration and addtitional parameter tab in File communication channel

Refer the below weblog

/people/michal.krawczyk2/blog/2005/11/10/xi-the-same-filename-from-a-sender-to-a-receiver-file-adapter--sp14

/people/william.li/blog/2006/04/18/dynamic-configuration-of-some-communication-channel-parameters-using-message-mapping

3) Part of file name need to be extracted to make a query

Select Query to table 1 (Synchronous)

Select Query to table 2 (Synchronous)

Select Query to table 3 (Synchronous)

Insert into one table using all previous Select and CSV data.

I think in this case u need to use the lookup in DB.

DB lookup - /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

Collect no of rows updated.

What is ur output is it DB or File??

Thnx

Chirag

Reward points if it hepls.