Fwd: JSON Failed to import

Ariel Abadi aabadi at starconnecting.com
Tue Apr 26 01:54:55 CEST 2016


Now is working!

Thank you guys!
Rgds

>
>
> ---------- Forwarded message ----------
> From: Sjoerd Mullender <sjoerd at monetdb.org>
> Date: 2016-04-21 17:51 GMT-03:00
> Subject: Re: JSON Failed to import
> To: users-list at 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 at monetdb.org
> > https://www.monetdb.org/mailman/listinfo/users-list
> >
>
> --
> Sjoerd Mullender
>
>
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20160425/0b9a4614/attachment.html>


More information about the users-list mailing list