Data extraction & CSV2JSON/JSON2CSV python module needed

• Project ID:

  688228

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

A.) I need data extraction done on a web site that uses Joomla (and a it looks like a Sobi2, which is available from www.sigsiu.net.)
I will give you the site to view via PM.
The site is a basic website directory style of site, it should be easily completed using beautiful soup or scrapy.
I need the data in a CSV format.

B.) I need a CSV to JSON and JSON to CSV module written in python. (please take a look at these three snippets)
http://stackoverflow.com/questions/1884395/csv-to-json-script/1884446#1884446
http://djangosnippets.org/snippets/1680/ (CSV to JSON)
http://djangosnippets.org/snippets/2000/ (JSON to CSV)

The module needs to be able to convert arbitrary CSV file in proper format to JSON and JSON to a CSV file.
input and output -->
It should be capable of reading and writing to text files.
It should be capable creating a collection of JSON objects for reuse in other programs.
It should be capable printing out to the terminal when used on the command line for debugging.
(anything else?)

Error handling ---->
The library should fail gracefully.
The library needs to properly sanitize the CSV files.
(anything else?)

Other Items?? (perhaps handle yaml? )

*Bonus if you can create a Django App using the module.

Primary Usage:
I want to be able to use this python module on the command line and in django applications to move data around between formats.
Often, I need to have people check over data in excel to insure that it is written properly before posting to our web site in bulk. As a result, I then need to convert the reviewed data from CSV to JSON in order to add the JSON to Django applications (also the reverse get data in JSON and need to convert to CSV to edit in Excel). I'd like a nice module to handle this process.

Additional Project Description:

05/16/2010 at 18:18 EDT:
CSV to JSON / JSON to CSV

These modules should be used for csv and json parsing:
simplejson
csv

thanks!

Skills required:

Django, Python