Pandat

XML:

	      <CATALOG>
		<CD>
		  <TITLE>Empire Burlesque</TITLE>
		  <ARTIST>Bob Dylan</ARTIST>
		  <COUNTRY>USA</COUNTRY>
		  <COMPANY>Columbia</COMPANY>
		  <PRICE>10.90</PRICE>
		  <YEAR>1985</YEAR>
		</CD>
		<CD>
		  <TITLE>Hide your heart</TITLE>
		  <ARTIST>Bonnie Tyler</ARTIST>
		  <COUNTRY>UK</COUNTRY>
		  <COMPANY>CBS Records</COMPANY>
		  <PRICE>9.90</PRICE>
		  <YEAR>1988</YEAR>
		</CD>
		<CD>
		  <TITLE>Greatest Hits</TITLE>
		  <ARTIST>Dolly Parton</ARTIST>
		  <COUNTRY>USA</COUNTRY>
		  <COMPANY>RCA</COMPANY>
		  <PRICE>9.90</PRICE>
		  <YEAR>1982</YEAR>
		</CD>
	      </CATALOG>

Some XML data for a CD collection

Remember CDs?

We can convert this representation into CSV, JSON, SQL, and GraphViz.

npm install -g pandat

Press the button to see the converted data...

JSON:

pandat -f xml -t json file.xml


	      {"catalog":
	      [{"cd": {"title": "Empire Burlesque",
              "artist": "Bob Dylan",
              "country": "USA",
              "company": "Columbia",
              "price": 10.90,
              "year": 1985 }
	      },
	      {"cd": {"title": "Hide your heart",
              "artist": "Bonnie Tyler",
              "country": "UK",
              "company": "CBS Records",
              "price": 9.90,
              "year": 1988 }
	      },
	      {"cd": {"title": "Greatest Hits",
              "artist": "Dolly Parton",
              "country": "USA",
              "price": 9.90,
              "year": 1982 }
	      }]
	      }

CSV:

pandat -f xml -t csv file.xml


	      title,artist,country,company,price,year
	      Empire Burlesque,Bob Dylan,USA,Columbia,10.90,1985
	      Hide your heart,Bonnie Tyler,UK,CBS Records,9.90,1988
	      Greatest Hits,Dolly Parton,USA,9.90,1982

SQL:

pandat -f xml -t sql file.xml


	      INSERT INTO catalog (title,artist,country,company,price, year) VALUES("Empire Burlesque","Bob Dylan","USA","Columbia","10.90","1985");
	      INSERT INTO catalog (title,artist,country,company,price, year) VALUES("Hide your heart","Bonnie Tyler","UK","CBS Records","9.90","1988");
	      INSERT INTO catalog (title,artist,country,company,price, year) VALUES("Greatest Hits","Dolly Parton","USA","RCA","9.90","1982");

Graphviz:

pandat -f xml -t gv file.xml > file.dot dot -Tpng file.dot > graph.png

Pandat

Pandat is Pandoc for data. It lets you convert between XML, JSON, CSV, SQL, and many more. It's on NPM and Github.

Some XML data for a CD collection

Remember CDs?