{"id":22479,"date":"2024-10-18T03:53:06","date_gmt":"2024-10-18T03:53:06","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=22479"},"modified":"2024-11-25T03:46:20","modified_gmt":"2024-11-25T03:46:20","slug":"convert-xml-to-csv-with-node-path-as-header","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/use\/convert-xml-to-csv-with-node-path-as-header.html","title":{"rendered":"Convert XML to CSV with node path as header"},"content":{"rendered":"

I see a post Convert XML to CSV (with node path as header) using XSLT<\/a>, the poster have this XML data:<\/p>\n

<tXML>\r\n    <Header>\r\n        <Source>XPTO<\/Source>\r\n        <User_ID>127<\/User_ID>\r\n        <Message_Type>Ship<\/Message_Type>\r\n        <Company_ID>105<\/Company_ID>\r\n        <Msg_Locale>English (United States)<\/Msg_Locale>\r\n        <Version>2017<\/Version>\r\n    <\/Header>\r\n    <Message>\r\n        <Ship>\r\n            <ShipSummary>\r\n                <ComName>XPTO 123<\/ComName>\r\n                <FacName>6<\/FacName>\r\n            <\/ShipSummary>\r\n        <\/Ship>\r\n    <\/Message>\r\n<\/tXML>\r\n<\/pre>\n
He want to convert to CSV like this:<\/p>\n
tXML\/Header\/Source,tXML\/Header\/User_ID,tXML\/Header\/Message_Type,tXML\/Header\/Company_ID,tXML\/Header\/Msg_Locale,tXML\/Header\/Version,tXML\/Message\/Ship\/ShipSummary\/ComName,tXML\/Message\/Ship\/ShipSummary\/FacName\r\nXPTO,127,Ship,105,English (United States),2017,XPTO 123,6\r\n<\/pre>\n
I don’t like using XSLT, I like my tool Data File Converter<\/a>, so I test, it can do this, in a minute.<\/p>\n
1. Open XML file, set XML options.<\/p>\n
\"Convert<\/p>\n
2. set CSV options.<\/p>\n
\"Convert<\/p>\n
3. “Next” and “Next”, convert, get output CSV file.<\/p>\n","protected":false},"excerpt":{"rendered":"
I see a post Convert XML to CSV (with node path as header) using XSLT, the poster have this XML data: <tXML> <Header> <Source>XPTO<\/Source> <User_ID>127<\/User_ID> <Message_Type>Ship<\/Message_Type> <Company_ID>105<\/Company_ID> <Msg_Locale>English (United States)<\/Msg_Locale> <Version>2017<\/Version> <\/Header> <Message> <Ship> <ShipSummary> <ComName>XPTO 123<\/ComName> <FacName>6<\/FacName> <\/ShipSummary> <\/Ship> <\/Message> <\/tXML> He want to convert to CSV like this: tXML\/Header\/Source,tXML\/Header\/User_ID,tXML\/Header\/Message_Type,tXML\/Header\/Company_ID,tXML\/Header\/Msg_Locale,tXML\/Header\/Version,tXML\/Message\/Ship\/ShipSummary\/ComName,tXML\/Message\/Ship\/ShipSummary\/FacName XPTO,127,Ship,105,English (United States),2017,XPTO 123,6 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3141],"tags":[34,68,1491],"class_list":["post-22479","post","type-post","status-publish","format-standard","hentry","category-use","tag-csv","tag-xml","tag-xml-to-csv"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22479","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=22479"}],"version-history":[{"count":3,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22479\/revisions"}],"predecessor-version":[{"id":22765,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22479\/revisions\/22765"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=22479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=22479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=22479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}