1
Cannot import one of my csv files
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
...