{"id":22482,"date":"2024-10-19T08:15:57","date_gmt":"2024-10-19T08:15:57","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=22482"},"modified":"2024-10-19T08:15:57","modified_gmt":"2024-10-19T08:15:57","slug":"convert-xml-mixed-nodes-and-attributes-to-csv-file","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/use\/convert-xml-mixed-nodes-and-attributes-to-csv-file.html","title":{"rendered":"Convert XML (mixed nodes and attributes) to CSV file"},"content":{"rendered":"

I see a post Convert xml (mixed nodes and attributes) to csv file using c#<\/a>, the poster has an XML which has mix of nodes and nodes with attributes:<\/p>\n

<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<Root> \r\n  <StudentRequestList count=\"3\">\r\n    <StudentRequest>\r\n        <StudentFirstName>Test1<\/StudentFirstName>\r\n        <StudentLastName>TestLastName<\/StudentLastName>\r\n        <StudentGrade>3<\/StudentGrade>\r\n        <StudentHomeroomTeacher>WhiteTest1<\/StudentHomeroomTeacher>\r\n        <VariableData>\r\n            <Variable name=\"Email\">test@email.com<\/Variable>\r\n            <Variable name=\"Hobby1\">TestHobby1<\/Variable>\r\n            <Variable name=\"Hobby2\">TestHobby2<\/Variable>\r\n            <Variable name=\"Hobby3\">TestHobby3<\/Variable>\r\n            <Variable name=\"satscore\">satscoreTest1<\/Variable>\r\n            <Variable name=\"kprepscore\">krepscore1<\/Variable>           \r\n        <\/VariableData>\r\n    <\/StudentRequest>\r\n        <StudentRequest>\r\n        <StudentFirstName>Test2<\/StudentFirstName>\r\n        <StudentLastName>TestLastName2<\/StudentLastName>\r\n        <StudentGrade>3<\/StudentGrade>\r\n        <StudentHomeroomTeacher>WhiteTest1<\/StudentHomeroomTeacher>\r\n        <VariableData>\r\n            <Variable name=\"Email\">test2@email.com<\/Variable>\r\n            <Variable name=\"Hobby5\">TestHobby5<\/Variable>\r\n            <Variable name=\"Hobby6\">TestHobby6<\/Variable>\r\n            <Variable name=\"Hobby3\">TestHobby3<\/Variable>\r\n            <Variable name=\"satscore\">satscoreTest2<\/Variable>\r\n            <Variable name=\"kprepscore\">krepscore2<\/Variable>           \r\n        <\/VariableData>\r\n    <\/StudentRequest>\r\n        <StudentRequest>\r\n        <StudentFirstName>Test1<\/StudentFirstName>\r\n        <StudentLastName>TestLastName<\/StudentLastName>\r\n        <StudentGrade>3<\/StudentGrade>\r\n        <StudentHomeroomTeacher>WhiteTest1<\/StudentHomeroomTeacher>\r\n        <VariableData>\r\n            <Variable name=\"Email\">test@email.com<\/Variable>\r\n            <Variable name=\"Hobby4\">TestHobby4<\/Variable>\r\n            <Variable name=\"Hobby2\">TestHobby2<\/Variable>\r\n            <Variable name=\"Hobby3\">TestHobby3<\/Variable>\r\n            <Variable name=\"satscore\">satscoreTest3<\/Variable>\r\n            <Variable name=\"kprepscore\">krepscore3<\/Variable>           \r\n        <\/VariableData>\r\n    <\/StudentRequest>\r\n  <\/StudentRequestList>\r\n<\/Root>\r\n<\/pre>\n
CSV is supposed to look like:<\/p>\n
StudentFirstName,StudentLastName,StudentGrade,StudentHomeroomTeacher,Email, Hobby1, Hobby2,Hobby3, Hobby4, Hobby5, Hobby6, satscore, kprepscore     \r\nTest1,TestLastName,3,WhiteTest1,test@email.com,TestHobby1,TestHobby2,TestHobby3,,,,satscoreTest1,krepscore1 \r\nTest2,TestLastName2,3,WhiteTest1,test2@email.com,,,Hobby3,,Hobby5,Hobby6,satscoreTest2,krepscore2\r\nTest1,TestLastName,3,WhiteTest1,test@email.com,,Hobby2,Hobby3,Hobby4,,,satscoreTest3,krepscore3\r\n<\/pre>\n
I think Data File Converter<\/a> can do this, need to coding, so I tried, yes, it can, in a minute.<\/p>\n
1. Open XML file in DataFileConverter, set XML options.
\n\"Convert<\/p>\n
2. Set XML custom columns.
\n\"Convert<\/p>\n
3. Set CSV options.
\n\"Convert<\/p>\n
4. “Next” and “Next”, convert, get output CSV file.<\/p>\n","protected":false},"excerpt":{"rendered":"
I see a post Convert xml (mixed nodes and attributes) to csv file using c#, the poster has an XML which has mix of nodes and nodes with attributes: <?xml version=”1.0″ encoding=”utf-8″?> <Root> <StudentRequestList count=”3″> <StudentRequest> <StudentFirstName>Test1<\/StudentFirstName> <StudentLastName>TestLastName<\/StudentLastName> <StudentGrade>3<\/StudentGrade> <StudentHomeroomTeacher>WhiteTest1<\/StudentHomeroomTeacher> <VariableData> <Variable name=”Email”>test@email.com<\/Variable> <Variable name=”Hobby1″>TestHobby1<\/Variable> <Variable name=”Hobby2″>TestHobby2<\/Variable> <Variable name=”Hobby3″>TestHobby3<\/Variable> <Variable name=”satscore”>satscoreTest1<\/Variable> <Variable name=”kprepscore”>krepscore1<\/Variable> <\/VariableData> <\/StudentRequest> […]<\/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-22482","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\/22482","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=22482"}],"version-history":[{"count":1,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22482\/revisions"}],"predecessor-version":[{"id":22483,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/22482\/revisions\/22483"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=22482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=22482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=22482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}