Sender File Content Conversion Creating Incomplete XML File

[former_member202642]

Hello Experts,
I am trying to convert a CSV file into XML file and then pass this XML file (without any mapping) to a target folder.
I tried using FCC in the sender File channel but it resulted in an invalid XML file getting generated in the target

For ex. If my Source CSV file is of 5.5 MB then the target file is of 13 MB (which should be fine considering the XML tags getting added) but with an incomplete XML structure.

I am giving more details about the settings which I did in the channel and a sample of the data which I want to convert:

Requirement

Sender Channel Configuration
Poll Interval (secs) = 100

Can you please let me know what should I do to get a complete XML file in the target with all the data getting converted properly?

Thank you!

[former_member202642]

Hi Abhishek,

Are you getting the all the values for a record in a file?

I mean is there any value missing in any of the records?

Thanks

[Former Member · Accepted solution]

Dear,

Notepad is to be blamed here! The file was getting generated with complete structure.

It was however, the Notepad which truncated data after certain length. I used Notepad++ for this and the file with all the necessary fields was there already.

Thank you for taking time out and supporting on this issue!

[former_member202642]

Hi Abhishek,

What's the error you are getting?

Thanks.

[Former Member]

Dear Aamir,

There is no error. However when I open the generate file, it is not a valid XML as it does not contain the end tags.

I have done FCC earlier as well. The problem that I see is because of the number of records and also that I cannot split the file and it has to be transferred as a single file.

Any inputs what needs to be done?

Thank you!

[former_member202642]

Hi Abhishek,

XML file is getting created correctly.

All the 3 records are there in the XML file. The first line in file is header line and it is being skipped because you have mentioned "Document Offset" as 1.

Thanks,

Aamir

[Former Member]

Hello Amir,

The file which I showed above is only a sample file. Actually my CSV file is around 2 MB and has around 9500 records. This count may vary.
Now the problem is how to process these many records successfully and generate only one file in the target folder.

Thank you!