Hi,

When I export CE data in csv, the fields (in columns) don't appear by alphabetical order, which makes it very difficult to navigate the file.

Can something be done about this?

Thanks!

Florence

asked 29 Aug '19, 21:24

flandsberg's gravatar image

flandsberg
10112676
accept rate: 0%

edited 29 Aug '19, 21:24


Dear Florence,

So far this is not possible to change. The order of columns is the order to the fields on the survey.

If you need the fields to be ordered alphabetically there is a very simple solution in Excel!

Just open the CSV exported from Collect Earth in Excel (remember these are CSV delimited by commas, which sometimes in Excel does not look right - the columns are mixed - you then need to use the Data-> From text see LINK)

Then go to the Data tab and click on the short menu icon, then on the dialog choose sort options and there pick the option "Sort left to right". Finally you chose that you want to use the row 1 (the attribute names row) to sort by. When you click OK the columns will rearrange following the alphabetical order of the attribute names.

alt text

alt text

alt text

permanent link

answered 01 Sep '19, 11:21

Open%20Foris's gravatar image

Open Foris ♦♦
9995714
accept rate: 10%

edited 01 Sep '19, 11:23

Hi OF,

Thanks but actually, the order of the fields in my case is NOT the order in the survey. I have fields that are one after another in the survey that have many columns between them.

I wonder if the order in the csv is not chronological, i.e., based on when the fields were entered in the survey.

I can add an example...

Cheers,

Florence

permanent link

answered 03 Sep '19, 16:50

flandsberg's gravatar image

flandsberg
10112676
accept rate: 0%

Dear Florence,

Collect data export follows the order of fields according to "Data Structure" view under Schema. That view is also used to organize the order of fields for Collect Mobile data entry and it does not affect to "Entry form" view. Please reorganize your data structure as needed.

Regards, Lauri

permanent link

answered 06 Sep '19, 14:11

Lauri%20%28OF%29's gravatar image

Lauri (OF) ♦♦
6652815
accept rate: 21%

Thanks Lauri, this is great. I will reorganize the fields in the Data Structure interface. Cheers, Florence

(10 Sep '19, 21:33) flandsberg flandsberg's gravatar image
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:

×281

question asked: 29 Aug '19, 21:24

question was seen: 1,795 times

last updated: 10 Sep '19, 21:33