display json text as a friendly list in django admin

Question

I have a JSONField (http://djangosnippets.org/snippets/1478/) in a model and I'm trying to find out the best way to display the data to the admin user rather than json.

Does anyone know the best way to do this in django admin?

For instance, I would like

{u'field_user_name': u'foo bar', u'field_email': u'[email protected]'}

to display as

field_user_name = foo bar
field_email = [email protected]

Answer 1

Maybe you should create a template filter to do this :

from django import template
from django.utils import simplejson as json

register = template.Library()

@register.filter
def json_list(value):
    """
    Returns the json list formatted for display
    Use it like this :

    {{ myjsonlist|json_list }}
    """
    try:
        dict = json.loads(value)
        result = []
        for k, v in dict.iteritems():
            result.append(" = ".join([k,v]))
        return "<br/>".join(result)
    except:
        return value

Answer 2

Perhaps create a custom widget?

class FlattenJsonWidget(TextInput):
    def render(self, name, value, attrs=None):
        if not value is None:
            parsed_val = ''
            for k, v in dict(value):
                parsed_val += " = ".join([k, v])
            value = parsed_val
        return super(FlattenJsonWidget, self).render(name, value, attrs)