Removing multiple header lines from CSV file

[former_member774303]

Hello Everyone,

I have a IDOC to CSV file scenario in PI, where multiple IDOCs for a particular Vendor gets converted into a single CSV file. Now as per the requirement, we need to generate a header line in the CSV file.

I have developed it and currently header line is generating in the file but the problem is, each and every time a IDOCs sent to PI, the header generation logic gets triggered and at end in the final CSV file, multiple header lines are populating instead of once.

Kindly suggest to solve the issue.

Do let me know if you require any further information on the same.

Regards,

Ravi

[pvishnuvardan_reddy · Accepted solution]

Hi Ravi,

Can you let me know for generating same file for the same vendor for multiple idoc's I assume you are using Append Construction mode in the channel.

And in FCC, you have maintained the logic for header in the FCC parameters.

Am I right? Just want to understand how it is done

[former_member774303 · Accepted solution]

Hi Vishnu,

Thanks for your response.

You are correct. To generate file for multiple IDOCs, I am using Append mode in the channel and using FCC parameter to generate the header line.

Regards,

Ravi

[pvishnuvardan_reddy · Accepted solution]

Hi Ravi,

I think there is no validation available to check if the file already exists on the server then don't need of header line and if not need to use header line in the file at the channel level.

I think we can go for IDOC packaging where you can generate file for multiple idoc's. Check out the below blog for the same.