Dear list,
I have a table in SQLlite db where one column is of json type (w2p defined).
When I save json string :
[
{
"value":"",
"Param1": "0",
"Param2": "y"
}
{
"value":"",
"Param1": "1",
"Param2": "n"
}]
via web2py table admin console into this column everything works fine, but if I
load csv into SQLite table via admin console (csv import) it returns an errors
related to json formatting. Even if I export what I successfully done above
with web2py admin console into csv :
|{u'value': u'', u'param1': u'0', u'param2': u'y' }|{u'value': u'', u'param1':
u'1', u'param2': u'n'} |
and try to load it via csv import - nothing works. I understand that there is
something wrong with the json formatting, but I cannt get my head over iwhy it
works with one approach but not the second.
Question: how can I load csv file which has json column in it, into web2py
table with json column (SQLite database)? What is the correct json formatting
at each step of this procedure? Can you give me a working example
Thanks
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
