Convert XML to CSV - VisualCron - Forum

Community forum

ifeguy
2019-06-26T22:38:43Z
Hello,
I am in need of a way to convert XML files to CSV using a task. Any ideas on how to approach this? Thank you!

Kind Regards,
John
ErikC
2019-09-23T06:56:31Z
Hi John,

There is no tool out of the box for this i believe.
To convert XML to CSV, you need to have the specs of the XML and for the CSV file.

As a programmer myself I would use the .net task to read from the xml file with a XmlDocument.
You can read the whole file and you can write to a text file with a StreamWriter. With the buisiness logic of both files, you can create the csv file.

Regards
Erik
Uses Visualcron since 2006.
ifeguy
2019-09-23T15:56:44Z
Thank you for your response Erik. Good idea. I will look into the .net approach. I have recently become more familiar with .net since I posted this, so I think this is a good idea. Take care.
Scroll to Top