Hi OFT,

I want to prepare the CSV file for the plots. Reading the manual, and other posts here I understand that the file needs to respect specific minimum requirements in the structure (i.e ID, LAT, LON, ELEV, SLOPE, ASPECT, REGION) at a minimum. My questions are:

  1. Are there upper (max) limits on the columns in the CSV? I have a lot of information that I would like to include in advance for the plots, without asking the user to fill it.
  2. Are there any limits in the maximum number of characters the headers of the columns in the CSV file might have?
  3. Does the header in the way is written matters, especially for the six main columns (e.g. ID vs plot_ID)?

Thanks,

itzam

asked 23 Jan '18, 14:25

itzam's gravatar image

itzam
21410
accept rate: 0%


Hi Itzam,

Are there upper (max) limits on the columns in the CSV?

There are no limits, you can have hundreds of them. But of course, you need to make sure to add the attributes to the survey and set them as coming from the CSV.

Are there any limits in the maximum number of characters the headers of the columns in the CSV file might have?

No limits there.

Does the header in the way is written matters, especially for the six main columns (e.g. ID vs plot_ID)?

It does not matter although it helps readability if you use the same names than the attributes. Collect Earth complains if the names of the columns do not match exactly the names of the attributes they represent, but it is not a showstopper.

If you want to make sure that the CSV is using the right structure you should always check the expected column order in Collect. Go to the tools in the survey editor and choose the option "Export Collect Earth grid template"

alt text

permanent link

answered 23 Jan '18, 22:32

collectearth's gravatar image

collectearth ♦
1.0k16
accept rate: 17%

Dear OFT,

Thanks a lot for your valuable information.

Regards,

itzam

permanent link

answered 24 Jan '18, 10:23

itzam's gravatar image

itzam
21410
accept rate: 0%

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:

×71

question asked: 23 Jan '18, 14:25

question was seen: 2,813 times

last updated: 24 Jan '18, 10:23