{"id":22495,"date":"2024-10-22T04:24:53","date_gmt":"2024-10-22T04:24:53","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=22495"},"modified":"2024-10-22T04:24:53","modified_gmt":"2024-10-22T04:24:53","slug":"convert-xml-attributes-to-csv-columns","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/use\/convert-xml-attributes-to-csv-columns.html","title":{"rendered":"Convert XML attributes to CSV columns"},"content":{"rendered":"

I see a post How to convert XML into CSV using XSL<\/a>, the poster has a test XML like this:<\/p>\n

<Tester author=\"Name\" id=\"16384543\">\r\n  <insert tableName=\"sampletable\">\r\n    <column name=\"id\" valueNumeric=\"2\"\/>\r\n    <column name=\"name\" value=\"kathy\"\/>\r\n    <column name=\"active\" valueBoolean=\"true\"\/>\r\n    <column name=\"age\" valueNumeric=\"2\"\/>\r\n  <\/insert>\r\n  <insert tableName=\"sampletable\">\r\n    <column name=\"id\" valueNumeric=\"23\"\/>\r\n    <column name=\"name\" value=\"Queen\"\/>\r\n    <column name=\"active\" valueBoolean=\"true\"\/>\r\n    <column name=\"age\" valueNumeric=\"29\"\/>\r\n  <\/insert>\r\n  <insert tableName=\"sampletable\">\r\n    <column name=\"id\" valueNumeric=\"25\"\/>\r\n    <column name=\"name\" value=\"varshan\"\/>\r\n    <column name=\"active\" valueBoolean=\"false\"\/>\r\n    <column name=\"age\" valueNumeric=\"5\"\/>\r\n  <\/insert>\r\n<\/Tester>\r\n<\/pre>\n
He want to convert it to CSV like this:<\/p>\n
id,name,active,age\r\n2,kathy,TRUE,2\r\n23,Queen,TRUE,29\r\n25,varshan,FALSE,5\r\n<\/pre>\n
So the XML attributes need to be converted CSV columns. I used Data File Converter<\/a>, figured out converting this XML, in a minute.<\/p>\n
1. Open XML in DataFileConverter, set XML options.
\n\"Convert<\/p>\n
2. Set XML custom columns, map XML attributes to columns.
\n\"Convert<\/p>\n
\"Convert<\/p>\n
3. Set CSV options.
\n\"Convert<\/p>\n
4. “Next” and “Next”, convert, get the output CSV file.<\/p>\n","protected":false},"excerpt":{"rendered":"
I see a post How to convert XML into CSV using XSL, the poster has a test XML like this: <Tester author=”Name” id=”16384543″> <insert tableName=”sampletable”> <column name=”id” valueNumeric=”2″\/> <column name=”name” value=”kathy”\/> <column name=”active” valueBoolean=”true”\/> <column name=”age” valueNumeric=”2″\/> <\/insert> <insert tableName=”sampletable”> <column name=”id” valueNumeric=”23″\/> <column name=”name” value=”Queen”\/> <column name=”active” valueBoolean=”true”\/> <column name=”age” valueNumeric=”29″\/> <\/insert> <insert tableName=”sampletable”> […]<\/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-22495","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\/22495","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=22495"}],"version-history":[{"count":2,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22495\/revisions"}],"predecessor-version":[{"id":22497,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22495\/revisions\/22497"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=22495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=22495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=22495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}