search

bexis / Module_ResearchAreaManagement

A tool to manage research areas. You can define the shape of your main plots and draw subplots inside. You can plan the localization of field experiments. You can use maps for orientation in the field. As you will keep the history of the subplots, you will always be able to distribute prospective subplots. Module for Core @BEXIS2.
0 stars 0 forks source link

Export csv: sometimes the status is not exported #106

Closed aostrow closed 2 years ago

aostrow commented 2 years ago

I checked the db. Th evalue is set. It is missing in the file, e.g. HEW10.

aostrow commented 2 years ago

Seems to be an Excel problem. If I import the stuff below then the last 2 lines will be somehow cut on the semicolon if you start to make the data into columns.

plotId|internal plotId|geometryId|geometry name|geometry type|coordinate|coordinate type|line width|color|description|status AEW10|773|34286|Core 10 - SIA E|rectangle|13,9,15,11|xy|1|#0000FFAA|2018 - 2019: Self-Integrating Accumulator (SIAs, buried resin cartridges), CO2 measurement|1 AEW10|773|34605|FunWood IV - BEShortDead|rectangle|25.5,19,27.5,21|xy|1|#D2691EAA|2017 - 2018: exposition of small wooden specimen|1 AEW10|773|40850|soil sampling campaign|linestring|(-11,-11),(-10,30)|xy|2|#0000FFAA|2011, 2014: Soil sampling campaign; 2014 - 2015: buried mesh bags (ProEMM)|1 AEW10|773|40851|soil sampling campaign|linestring|(-31,9),(10,10)|xy|2|#0000FFAA|2011, 2014: Soil sampling campaign; 2014 - 2015: buried mesh bags (ProEMM)|1

aostrow commented 2 years ago

Excel just shows this behavior if I open the downloaded file. Not if I copy/paste the above example.

Aew10.csv

aostrow commented 2 years ago

Do NOT open the csv directly with Excel (double click).

Download file. Open Excle. Import csv via Excel does also work.