Cannot import one of my csv files | Voters

Cannot import one of my csv files

jiahao.qiu@abio-x.com

I have generated two csv files in the same way. However, I cannot upload one of them to the data importer and therefore cannot create node from that file. I don't know why and there's no error message

July 11, 2022

Gregory King

Hi - can you check the one that doesn't work. Does it have at least one row for the header and one data row?

jiahao.qiu@abio-x.com

Gregory King: sure. It just fails to be uploaded through "Drag & Drop

or browse". But other files generated in the same way can.

Gregory King

jiahao.qiu@abio-x.com: Thanks for sending the example file by email. From an initial inspection it seems we have a problem with some of the column values being very large (eg lists of hundreds of IDs in one column). We'll look into how we might be able to resolve that and get back to you. In the meantime, if possible, see if you can omit or reduce these columns.

Gregory King

jiahao.qiu@abio-x.com: Hi, a fix to support files with larger rows went out in today's release. Please try again with this latest release.

In the file you sent I noted that some of the columns had many repeating values in them. For the time being, you may want to split these out into a transposed table to allow you to use the data in data importer, eg:

from

A_ID, B_IDS
1, [1,2,3,4,5]
2, [3,4,5]
...

into

A_ID, B_ID
1, 1
1, 2
1, 3
1, 4
1, 5
2, 3
2, 4
2, 5
...