CSV does not import into DataIllustrator

[Dorsey Kaufmann]

Attached is a screenshot of how my CSV is formatted. 

When I click on the "Import my dataset" button, I can select my csv and click "open."

After doing this, the interface does not change and still says "No data imported."

It's like the program does not recognize my file.

Any ideas on how I can get it to recognize my file?

[eleonora.c...@gmail.com]

Hi, I had the same issue. 

I saved the csv with a different encoding (UTF-8 No BOM) and it worked.

[Dorsey Kaufmann]

I'm saving it from Excel as a UTF-8 file (see screenshot) and it still does not upload.

Should I encode it in a different program in order for it to work?

[Leo Zhicheng Liu]

Hi Dorsey,

There seems to be a bug in the app when it reads in the csv file. While we are working to fix it, you can simply rename the column "Ripple Effect vs. Booklet" to "Ripple Effect vs Booklet" (remove the period), and it should work.

Thanks,

Leo

--
You received this message because you are subscribed to the Google Groups "Data Illustrator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to data-illustrat...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/data-illustrator/b0ff6dad-45f8-4100-9610-8018d3af5610o%40googlegroups.com.

[Dorsey Kaufmann]

Thank you, it works now!

On Thursday, July 9, 2020 at 5:19:30 PM UTC-7, Leo Zhicheng Liu wrote:

Hi Dorsey,

There seems to be a bug in the app when it reads in the csv file. While we are working to fix it, you can simply rename the column "Ripple Effect vs. Booklet" to "Ripple Effect vs Booklet" (remove the period), and it should work.

Thanks,

Leo

On Thu, Jul 9, 2020 at 4:26 PM Dorsey Kaufmann <dorsey....@gmail.com> wrote:

I'm saving it from Excel as a UTF-8 file (see screenshot) and it still does not upload.

Should I encode it in a different program in order for it to work?

On Thursday, July 9, 2020 at 7:33:02 AM UTC-7, eleonora....@gmail.com wrote:

Hi, I had the same issue. 

I saved the csv with a different encoding (UTF-8 No BOM) and it worked.

Il giorno lunedì 6 luglio 2020 00:15:36 UTC+2, Dorsey Kaufmann ha scritto:

Attached is a screenshot of how my CSV is formatted. 

When I click on the "Import my dataset" button, I can select my csv and click "open."

After doing this, the interface does not change and still says "No data imported."

It's like the program does not recognize my file.

Any ideas on how I can get it to recognize my file?

--
You received this message because you are subscribed to the Google Groups "Data Illustrator" group.

To unsubscribe from this group and stop receiving emails from it, send an email to data-ill...@googlegroups.com.

[Dorsey Kaufmann]

Hi, 

I am working on another visualization and the following csv will not load.

Is there another bug I am not aware of?

This one has the "." deleted, so I'm not sure what else could be the issue.

To unsubscribe from this group and stop receiving emails from it, send an email to data-illustrat...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/data-illustrator/aeb023d5-5968-4b85-b1f5-ed500c55e0d1o%40googlegroups.com.

--

Dorsey Kaufmann

Graduate Research Assistant

University of Arizona

College of Fine Arts - Illustration and Design

College of Agriculture and Life Sciences - Soil, Water, and Environmental Science

dorsey....@gmail.com

[Leo Zhicheng Liu]

Hi,

It seems that the first column name is empty? The first line is ",Year 1,Year 2,Year 1 vs Year 2". Putting something in front of the first comma will work, 

Thanks,

To view this discussion on the web visit https://groups.google.com/d/msgid/data-illustrator/CAKDph6H3GOwd1pVZgANpNs1SuE%3DRYu2wKJwL3nJcym0PEsyUzA%40mail.gmail.com.

[Dorsey Kaufmann]

I see it, whoops!

Thanks for looking into that.

[Dorsey Kaufmann]

Looks like I spoke too soon - I have added the first column and it still does not load.

[Leo Zhicheng Liu]

Hmm.. it's working for me, please try the attached file. Also, try clearing your browser's cache so that it is reloading the file instead of using the cached file.