I have a
JSONField in my model and I wasn't able to clean the initial import on my resource so the data imported were treated as strings instead of lists. When I export the data it looks like this:
The ones below are the previous data from the initial
import-export without a custom
JSONWidget. The ones above are the data that was cleaned.
How can I then fix the current
JSONField with the
string and convert it to a
Presumably you want to clean the values in the database, so that they are standardised to empty list. If so, there are a few ways you could do this:
UPDATEcommand via SQL (example)
./manage.py shellyou should be able to filter the entries and correct the data.
django-admincommands, write a script which filters and corrects the data, then use the django-extensions runscript command.
Please correct me if I have misunderstood what you are aiming to do.