search

matheussilvasantos / dynamocli

Utilities for interaction with AWS DynamoDB
MIT License
26 stars 5 forks source link

problems importing arrays #4

Open integraitco opened 4 years ago

integraitco commented 4 years ago

Hi, Im trying to import a csv with arrays in it. I export the table from the console using the export to csv function.

here is a csv file example. I have an array of users. When importing with this tool Im getting a String not an array.

"id","__typename","authUsers","createdAt","departmentCompanyId","departmentDepartmentParentId","level","name","state","updatedAt","author" "0c1e446b-50d4-4547-bd66-e98905c031ce","Department","[ { ""S"" : ""nramirez"" }, { ""S"" : ""aaragon"" }, { ""S"" : ""cfballen"" }]","2019-11-08T16:44:36.676Z","90971188-f06d-45bc-86d2-62b0ec391448","Company","1","Innovación","1","2019-11-08T16:44:36.676Z","cfballen" "161d2d47-cbb2-4f04-aebe-1c94442dec82","Department","[ { ""S"" : ""lvgallego"" }, { ""S"" : ""cfballen"" }, { ""S"" : ""aaragon"" }]","2019-11-08T16:44:20.273Z","90971188-f06d-45bc-86d2-62b0ec391448","Company","1","DHCO","1","2019-11-08T16:44:20.273Z","cfballen" "1eb1b702-9494-43f2-bd67-35eee44d2a49","Department","[ { ""S"" : ""dataEntry"" }]","2019-10-18T19:18:48.913Z","c0702fec-c118-4d27-99ce-827f8da70135","Company","1","test5","1","2019-10-18T19:18:48.913Z", "6380c47c-cfc5-42a6-9437-d826e04688ad","Department","[ { ""S"" : ""scortes"" }, { ""S"" : ""lrojas"" }, { ""S"" : ""aaragon"" }]","2019-10-18T21:31:12.905Z","90971188-f06d-45bc-86d2-62b0ec391448","c3c4a73a-bd04-41f1-872c-4c7c8cf3e99e","2","Tecnología de la Info","1","2019-10-22T20:31:22.842Z", "64b109e8-157e-46a3-9950-092644c98eef","Department","[ { ""S"" : ""hdospina"" }, { ""S"" : ""esalcedog"" }, { ""S"" : ""cfballen"" }, { ""S"" : ""aaragon"" }, { ""S"" : ""vortiz"" }]","2019-11-08T16:43:57.083Z","90971188-f06d-45bc-86d2-62b0ec391448","Company","1","Cadena","1","2019-11-19T16:21:17.714Z","cfballen" "73a43da0-f945-4870-8ba4-31817252a7fc","Department","[ { ""S"" : ""sergio"" }]","2019-10-18T19:12:06.599Z","c0702fec-c118-4d27-99ce-827f8da70135","bef35f82-398a-41e5-b099-3abc6e192061","2","test","1","2019-10-21T17:13:01.643Z", "9c22c25b-06d9-4007-8c34-584d04b0d2cc","Department","[ { ""S"" : ""lvvega"" }, { ""S"" : ""aaragon"" }, { ""S"" : ""cfballen"" }]","2019-11-08T16:43:35.754Z","90971188-f06d-45bc-86d2-62b0ec391448","Company","1","Ventas","1","2019-11-08T16:43:35.754Z","cfballen" "bef35f82-398a-41e5-b099-3abc6e192061","Department","[ { ""S"" : ""sergio"" }]","2019-10-18T19:24:12.067Z","c0702fec-c118-4d27-99ce-827f8da70135","Company","1","123","1","2019-10-18T19:24:12.067Z", "c3c4a73a-bd04-41f1-872c-4c7c8cf3e99e","Department","[ { ""S"" : ""aaragon"" }, { ""S"" : ""lrojas"" }, { ""S"" : ""scortes"" }, { ""S"" : ""cfballen"" }, { ""S"" : ""DataEntry"" }]","2019-10-18T21:30:48.426Z","90971188-f06d-45bc-86d2-62b0ec391448","Company","1","Financiera","1","2019-11-07T21:58:29.620Z","sergiomeals" "e25a1eef-4de6-4531-bbee-6c864c669d23","Department","[ { ""S"" : ""jpcamargo"" }, { ""S"" : ""aaragon"" }, { ""S"" : ""cfballen"" }]","2019-11-08T16:42:29.964Z","90971188-f06d-45bc-86d2-62b0ec391448","Company","1","Mercadeo","1","2019-11-08T16:58:54.142Z","cfballen"

Any help apreciated.

matheussilvasantos commented 4 years ago

Could you create a gist with your CSV file, please?

matheussilvasantos commented 4 years ago

I was able to reproduce this issue. Unfortunately, this library is not supporting arrays at the moment.