**This script converts a CSV file into a JSON file ready to be imported via `manage.py loaddata` like any other fixture data.**
It can be used manually to do a one-time conversion (for placing into a /fixtures folder), or used in a fabric script that automatically converts CSV to JSON live then runs `loaddata` to import as fixture data.
To run script:
>`csv2json.py input_file_name model_name`
>
>e.g. csv2json.py airport.csv app_airport.Airport
>
>Note: input_file_name should be a path relative to where this script is.
**Scripts depends on simplejson module.** The module can just be placed in a sub-folder to the script to make it easy to import. If you use the same Python binary that you use for your Django site, you could use the Django import instead: `from django.utils import simplejson`
**File Input/Ouptut formats:**
Assumes CSV files are saved with LF line endings, and that first line has field values. First column is the model's pk field.
Sample CSV input:
id,ident,name,city,state
1,00C,Animas Air Park,Durango,CO
6,00V,Meadow Lake,Colorado Springs,CO
7,00W,Lower Granite State,Colfax,WA
12,01J,Hilliard Airpark,Hilliard,FL
Output file name is input name + ".json" extension.
Sample JSON output:
[
{
"pk": 1,
"model": "app_airport.Airport",
"fields": {
"name": "Animas Air Park",
"city": "Durango",
"ident": "00C",
"state": "CO",
}
}
]
**Debugging Conversion Problems**
If JSON import errors out with "ValidationError: This value must be an integer", you probably have a blank in an Integer field within your CSV file, but if can't figure out, try setting a breakpoint in file:
./django/django/db/models/fields/__init__.py
e.g.
688 try:
689 return int(value)
690 except (TypeError, ValueError):
691 import pdb; pdb.set_trace()
692 -> raise exceptions.ValidationError(
693 _("This value must be an integer."))
To figure out what field caused the error, while in the debugger:
(Pdb) u <- to go UP the callstack
(Pdb) field.name
- json
- loaddata
- fixtures
- csv
- import
- fixture