Search code examples
jsonexcelcouchdbdata-export

save excel data to couchDB


I'm wondering if there is a tool that will save/push my MS Excel (or OO calc) data to CouchDB database. Googling didn't help a lot so I don't think there is an existing solution for this.

Excel -> json -> Curl to CouchDB would do the trick but I'm still hoping there is something out there that will save my time on programming this.


Solution

  • If you get the Excel data into a JSON file as Sam Bisbee suggests, you should be able to use the tools/load.py script from couchdb-python to easily and quickly dump it into CouchDB without spending too much time writing your own. (Although I wouldn't think it would take that long to write your own...)

    Check out this blog post about loading/dumping JSON into/out of CouchDB. The implementation uses Python.

    Loading the JSON file should be as easy as:

    ./load.py –input=msg_db.json http://target-couchdb:5984/msg_db