While I wait to see if Pinboard can fix their Google Reader JSON (JavaScript Object Notation) import, and while I consider Google Reader Share JSON import into WordPress, I'm also exploring JSON import/export tools. If, for example, I could import JSON into FileMaker Pro or other data management tool I might be able to manipulate the archive and produce a more useful WordPress import.
StackOverflow and its kin have a good set of references on this topic. Note that CSV can manage only very simple JSON; we really want native importers similar to what Microsoft Access tried with XML [1]. I suspect one approach might be to convert JSON to XML then use Microsoft Access 2010 import.
Incidentally, this topic veered off unexpectedly into something that's actually relevant to my work life and a Strata conference I'm attending in a few weeks.
As of today here are some of my pointers ...
- What is “JSON” and what does it have to do with distributed computing? « DivConq: great reference (see below for DivConq series on Access)
- JSON - Wikipedia, the free encyclopedia: I liked the comparison to XML [1]
- JSON.org: points to libraries
- 18.2. json — JSON encoder and decoder — Python v2.7.2 documentation: If I have to use a programming library to manipulate Google Reader json files my choices are probably Python or Javascript and I prefer Python.
- conversion - Convert JSON format to CSV format (for MS Excel) - Stack Overflow: JavaScript
- convert from json to csv using python - Stack Overflow
- Download JSON data and convert it to CSV using Python - Stack Overflow
- python - Convert JSON to CSV - Stack Overflow
- javascript - Python - convert csv file to JSON - Stack Overflow
For me this DivConq series was particularly useful because it placed JSON nosql processing in a familiar context - Microsoft Access.
- What is “JSON” and what does it have to do with distributed computing? « DivConq: best single reference for my purposes
- Export a Microsoft Access Database to JSON (Northwind Example) « DivConq
- Why Cassandra « DivConq
- Installing and Running the Cassandra Database « DivConq
- Migrate a Relational Database Structure into a NoSQL Cassandra Structure (Part I) « DivConq
- Migrate a Relational Database into Cassandra (Part II – Northwind Planning) « DivConq
- Migrate a Relational Database into Cassandra (Part III – Northwind Conversion) « DivConq
- Migrate a Relational Database into Cassandra (Part IV – Northwind Import) « DivConq
Maybe I should start using Apache Cassandra to manipulate my Google Reader JSON archive and prepare it for WordPress processing. For example ... Cassandra Development Environment in Mac OS Snow Leopard « BigDiver.
[1] I doubt JSON has truly significant advantages over XML as a data interchange format (see JSON Example and wikipedia xml/json). Alas, nobody asked me. Fashion is more powerful than geeks imagine.
No comments:
Post a Comment