Error loading occurrence data

[Camilla Waltrick]

Hi everyone,

I'm having problems loading my occurrence data. After I load my  occurrences , an error appears in the screen, saying: "Please input CSV file with columns "name", "longitude", "latitude"". The problem is: i'm inputting the files just the way the program says. I'm attaching the screenshots of the error and csv.

Best regards,

Camilla

[Andrea Paz]

Hi Camilla,

Can you please attach one of the csv files? (not the screenshot)

Best,

Andrea

Andrea Paz 
PhD candidate
Biology program, Graduate Center
City University of New York
https://andrepazv.github.io

On Jan 11, 2021, at 8:47 AM, Camilla Waltrick <camilla....@hotmail.com> wrote:

Hi everyone,

I'm having problems loading my occurrence data. After I load my  occurrences , an error appears in the screen, saying: "Please input CSV file with columns "name", "longitude", "latitude"". The problem is: i'm inputting the files just the way the program says. I'm attaching the screenshots of the error and csv.

Best regards,

Camilla

<WhatsApp Image 2020-12-16 at 16.11.05.jpeg><WhatsApp Image 2020-12-16 at 16.11.05 (1).jpeg>

--
You received this message because you are subscribed to the Google Groups "Wallace Ecological Modeling App" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wallaceEcoMo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/wallaceEcoMod/4b4ff620-05f4-4f6e-a2b4-dcb37600d3efn%40googlegroups.com.
<WhatsApp Image 2020-12-16 at 16.11.05 (1).jpeg><WhatsApp Image 2020-12-16 at 16.11.05.jpeg>

[Camilla Waltrick]

Yes of course

Best, 

Camilla

[Andrea Paz]

Hi!

So this should work. When your excel is configured in a different language (this happens to me frequently in spanish for example) when you save as csv it actually separates columns with “;” instead of “,”. You can change this in your excel configuration or just open the file in a text editor and use find and replace to change the delimiter. Your file also had a blank row at the end that was causing issues. 

I hope this solves it, I loaded this attached file and it worked 

best, 

Andrea

[Camilla Waltrick]

Thanks Andrea, it's working now.

Best,

Camilla