Fwd: JSON Failed to import

Now is working! Thank you guys! Rgds

---------- Forwarded message ---------- From: Sjoerd Mullender Date: 2016-04-21 17:51 GMT-03:00 Subject: Re: JSON Failed to import To: users-list@monetdb.org

This works:

301|{"data":[{"cdr_dialnumber":"6596871820"}]}

So the quoting of the json string doesn't help.

On 04/21/2016 09:26 PM, Ariel Abadi wrote:

...

Hi!

Can someone help me ? Im trying to upload a CSV file with json data, but Im receiving an error. Does anybody has an idea how to solve this?

Thks in advance

mclient -s"COPY 1 RECORDS INTO traf.jsontbl FROM STDIN USING DELIMITERS '|','\n','\"' NULL AS 'null'" - < j.csv

*The data on j.csv is:* 301|"{\"data\":[{\"cdr_dialnumber\":\"6596871820\"}]}"

*TABLE traf.xx *

...

sql>\d jsontbl CREATE TABLE "traf"."jsontbl" ( "a" INTEGER, "b" JSON );

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- Sjoerd Mullender

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list