Community forum

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
Offline ifeguy  
#1 Posted : Thursday, June 27, 2019 12:38:43 AM(UTC)
ifeguy

Rank: Paid support

Joined: 10/29/2016(UTC)
Posts: 21
United States
Location: California, East Irvine

Thanks: 4 times
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
Offline ErikC  
#2 Posted : Monday, September 23, 2019 8:56:31 AM(UTC)
ErikC

Rank: Paid support

Joined: 2/26/2008(UTC)
Posts: 1,511
Netherlands
Location: Amsterdam

Thanks: 113 times
Was thanked: 216 time(s) in 185 post(s)
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.
Offline ifeguy  
#3 Posted : Monday, September 23, 2019 5:56:44 PM(UTC)
ifeguy

Rank: Paid support

Joined: 10/29/2016(UTC)
Posts: 21
United States
Location: California, East Irvine

Thanks: 4 times
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.
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Scroll to Top