{"id":7822,"date":"2015-03-13T14:37:51","date_gmt":"2015-03-13T14:37:51","guid":{"rendered":"https:\/\/test.simple-talk.com\/uncategorized\/converting-xml-files-to-yaml-or-pson\/"},"modified":"2016-07-07T13:16:30","modified_gmt":"2016-07-07T13:16:30","slug":"converting-xml-files-to-yaml-or-pson","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/converting-xml-files-to-yaml-or-pson\/","title":{"rendered":"Converting XML files to YAML or PSON"},"content":{"rendered":"

\nThe other day, I needed to convert a whole stack of XML files to YAML.\u00a0 Actually , I would have settled for a conversion to JSON, but for some reason, the built-in cmdlet wouldn’t do it. I was trying to figure out a way of doing the YAML conversion when I suddenly remembered I’d actually already published a way of doing it, in ‘Getting Data Into and Out of PowerShell Objects’<\/a>. With relief, I got the routine out and tried it. It didn’t work, because I’d chosen to display an XML value as an innerXML<\/b> string. This is the behaviour you might want, but not in this case.<\/p>\n

There are two different ways of rendering XML values. You can render the object represented by the XML or you can do it just as an InnerXML string. The former method allows us to convert XML files directly into YAML or PSON.\u00a0 Useful? \u00a0Sure. It is easier to demo than explain. First\u00a0 rendering it as an object…<\/p>\n

  \r\n$xml= [Xml] @' \r\n   <emp id=\"salary='60000'>\"> \r\n   <name> \r\n    <first>William<\/first> \r\n    <la st>Murphy<\/last> \r\n   <\/name> \r\n   <spouse> \r\n    <name> \r\n     <first>Cecilia Bertha Matilda<\/first> \r\n     <last>Murphy<\/last> \r\n    <\/name> \r\n   <\/spouse> \r\n   <dept id=\"K55'>Finance<\/dept>\"> \r\n  <\/emp> \r\n  '@ \r\n   ConvertTo-YAML $xml \r\n<\/pre>\n
…giving …<\/p>\n
  \r\n--- \r\n  \u00a0 \r\n  \u00a0emp:\u00a0\u00a0 \r\n  \u00a0\u00a0\u00a0dept:\u00a0\u00a0 \r\n  \u00a0\u00a0\u00a0\u00a0\u00a0#text:\u00a0\u00a0\u00a0'Finance' \r\n  \u00a0\u00a0\u00a0\u00a0\u00a0id:\u00a0\u00a0\u00a0'K55' \r\n  \u00a0\u00a0\u00a0id:\u00a0\u00a0\u00a0'12345' \r\n  \u00a0\u00a0\u00a0name:\u00a0\u00a0 \r\n  \u00a0\u00a0\u00a0\u00a0\u00a0first:\u00a0\u00a0\u00a0'William' \r\n  \u00a0\u00a0\u00a0\u00a0\u00a0last:\u00a0\u00a0\u00a0'Murphy' \r\n  \u00a0\u00a0\u00a0salary:\u00a0\u00a0\u00a0'60000' \r\n  \u00a0\u00a0\u00a0spouse:\u00a0\u00a0 \r\n  \u00a0\u00a0\u00a0\u00a0\u00a0name:\u00a0\u00a0 \r\n  \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0first:\u00a0\u00a0\u00a0'Cecilia Bertha Matilda' \r\n  \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0last:\u00a0\u00a0\u00a0'Murphy' \r\n  \u00a0 \r\n<\/pre>\n
and the other way, simply giving it as an XML fragment, (note the parameter if you want that behaviour)\u00a0 is.<\/p>\n
  \r\n$xml=\u00a0[Xml]\u00a0@' \r\n  \u00a0<emp id=\"salary='60000'>\"> \r\n  \u00a0<name> \r\n  \u00a0\u00a0<first>William<\/first> \r\n  \u00a0\u00a0<last>Murphy<\/last> \r\n  \u00a0<\/name> \r\n  \u00a0<spouse> \r\n  \u00a0\u00a0<name> \r\n  \u00a0\u00a0\u00a0<first>Cecilia Bertha Matilda<\/first> \r\n  \u00a0\u00a0\u00a0<last>Murphy<\/last> \r\n  \u00a0\u00a0<\/name> \r\n  \u00a0<\/spouse> \r\n  \u00a0<dept id=\"K55'>Finance<\/dept>\"> \r\n  <\/emp> \r\n  '@ \r\n  \u00a0ConvertTo-YAML\u00a0$xml\u00a0-XMLAsInnerXML\u00a01 \r\n<\/pre>\n
… giving …<\/p>\n
  \r\n--- \r\n  | \r\n  <emp id=\"12345\" salary=\"60000\"><name><first>William<\/first><last>Murphy<\/last><\/name><spouse><name><first>Cecilia Bertha matilda<\/first><last>Murphy<\/last><\/name><\/spouse><dept id=\"K55\">Finance<\/dept><\/emp> \r\n  \r\n<\/pre>\n<\/p>\n
It turned out that it was just as easy to handle the XML as an object as an XML document, and I’d already developed a way of doing a PowerShell object. After modifying the routine, and updating the article, I tried again. Nice. It worked a treat, and the YAML parser gulped it all in with no complaint. It wasn’t quick by any means with multi-megabyte XML files, but who cares when there are good videos to be watched? The PowerShell scripts are with the article  here<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
The other day, I needed to convert a whole stack of XML files to YAML.\u00a0 Actually , I would have settled for a conversion to JSON, but for some reason, the built-in cmdlet wouldn’t do it. I was trying to figure out a way of doing the YAML conversion when I suddenly remembered I’d actually……<\/p>\n","protected":false},"author":154613,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[],"class_list":["post-7822","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/7822","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/154613"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=7822"}],"version-history":[{"count":6,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/7822\/revisions"}],"predecessor-version":[{"id":22905,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/7822\/revisions\/22905"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=7822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=7822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=7822"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=7822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}