exported CSV columns disordered

[zoometh]

Please briefly describe your problem and what output you expect.

Please include a minimal reproducible example (AKA a reprex, a search URL).

[nsheldrick]

When exporting data to files like .csv or .shp from the database, the resulting export has the data fields in a random order (see attached). For example, in the .csv export, the first three columns are "Depositional Process", "Wave Climate", and "Geometric Place Expression". Even fields that should be linked, like Disturbance Cause Type and Disturbance Cause Certainty, are separated by several columns. The former is in Column BJ and the latter in Column Y. This makes understanding the data, without significant editing, practically impossible for the casual user who wants to export data and work with it.

The exported fields need to come out in an order that is at least similar to the order they appear in the database, so that the information can be understood in the table, in a logical order, from left to right. Heritage Place.csv

[zoometh]

@nsheldrick I have uploaded your CSV example here: https://github.com/eamena-project/eamena-arches-dev/blob/main/data/csv/Heritage.Place.csv I suggest to create a function in the eamenaR package to reorder columns, starting with this example. What do you think?

[zoometh]

I think there might be a way to rearrange directly on Arches. Which will be more useful

[zoometh]

It was already a topic on the Arches forum: https://community.archesproject.org/t/export-search-sort/1103?u=zoometh

[zoometh]

Following this Arches forum thread, I have updated the EXPORT_DATA_FIELDS_IN_CARD_ORDER variable to True in settings_local.py. It should now work

[nsheldrick]

No, this has not fixed the problem. I exported the attached csv today and the fields are still not in order.

Heritage Place.csv

[zoometh]

Please consult this thread on the Arches forum: https://community.archesproject.org/t/export-search-sort/1103/5. It will show you the current limits of exports