Passing a date in the extra attributes of the plot CSV

  • Asked
  • Active
  • Viewed 2683 times
0

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

0

Accepted answer

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

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.