I am trying to add a date column to the CSV of the grid of my plots.

It seems that the date attribute that I am trying to "link it to" is not understanding the date format or something.

Currently my CSV looks a like this:

id,Ycoordinate,Xcoordinate,visit_date,plot_type
1,-31.28116389,148.9776111,2018-05-11,3
2,-31.27856667,148.9924667,2018-05-12,3
3,-30.45390278,149.2280417,2018-05-13,3

but when I use this CSV on my survey I keep getting an error about the date attribute not being filled...

alt text

asked 14 Apr '20, 23:49

collector's gravatar image

collector
2671626
accept rate: 0%

edited 14 Apr '20, 23:50

Open%20Foris's gravatar image

Open Foris ♦♦
1.0k5714


In order to use dates as "From CSV" type of attributes Collect Earth expects this format:

MM/dd/YYYY ( so two digits month, two digits day and four digit year )

So, in your case, the format to use dates as grid columns in the CSV should be:

id,Ycoordinate,Xcoordinate,visit_date,plot_type
1,-31.28116389,148.9776111,11/05/2018,3
2,-31.27856667,148.9924667,15/05/2018,3
3,-30.45390278,149.2280417,25/06/2018,3
permanent link

answered 16 Apr '20, 11:21

collectearth's gravatar image

collectearth ♦
1.0k16
accept rate: 17%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×284

question asked: 14 Apr '20, 23:49

question was seen: 1,510 times

last updated: 16 Apr '20, 11:21