Hi again Andres, just saw your response now!
The reason why we prefer to share the data using the XML version rather than the CSV is that it becomes easier to import it! When you have the data as a CSV file you will need to have the data in a format that will fit the structure of the attributes of the survey.
This means that if you have entities within your main entity (the plot) the data must be imported separately.
In the case of your survey there is an entity called *element* ( that holds the attributes *element* -a key attribute that is used to identify the values in the DB - and *coverage*)
So, practically this means that you must divide the CSV that you have into one with the data (the columns) that belong to the plot (minus all of the calculated attributes that you actually don't need to import as they are calculated when the data is imported) and then the data for the elements of the plot as a separate CSV.
There are many things to know here so it is quite an advanced procedure.
First, I have imported your survey CEP file inside the Open Foris Collect Survey Designer. And then I have published it (using the advanced button when you are on the screen that sows the list of surveys). You need to publish the survey in order to be able to later access its data through the Data Management section of Open Foris Collect.
![alt text][1]
I have then generated a CSV file from the original one you sent where I have removed the columns that start with element (elementforest_element, elementforet_coverage....) and also removed the columns for calculated attributes (all of the oens that start with alu_category , alu_subcategory, alu_subdivision ... ). The result is this CSV [DOWNLOAD PLOT LEVEL DATA][1] DATA][2] . When you import the data, remember that Collect Earth data will be in the **ENTRY** phase. The data in Collect can be in three phases Entry, Cleansing and Analysis! In the Data import window choose the "**Insert new records**" option and then choose the CSV file and click on import.
![alt text][2]
text][3]
Then I have created another file with only the plot ID column and the columns that belong to the element entity ( [DOWNLOAD INTERMEDIATE CSV HERE][3]) HERE][4]) . Using EXCEL (or LibreOffice) you can then create a new CSV that is in the right format to be imported. In this case is quite simple, the entity "element" has just two attributes, element (which is also the key attribute and that can have value "foret" and "noforet" ) and coverage. This means that for each plot there will be two rows, one for foret and another one for noforet, like this
plot_id element coverage
3564 foret 25
3564 non_foret 0
3763 foret 25
3763 non_foret 0
3963 foret 15
3963 non_foret 10
4763 foret 20
4763 non_foret 5
The resulting CSV file is this one [DOWNLOAD ELEMENT ENTITY DATA][4]
DATA][5]
I have then imported this CSV file, but in the option I have specified that I am **UPDATING** data in the database, then I have **chosen the "element" entity** (a child of the main entity "plot"), and I have also (very important) selected that this data update should be **applied to the records in the phase "entry"**.
![alt text][5]
text][6]
So,now finally I have all of the data that was in the original CSV inside the Collect Database!! You can now start Saiku from Collect or you could export the data that you have into a Collec-data/XML file and import it into Collect Earth, where your CEP file has already been loaded. Then you can import it into Collect Earth using the usual *File->Data Import/Export->Import new data from ZIP (compressed XML)*
**EASY, right??**
I have done it myself (in case you don't want to repeat this laborious process). **Here is the resulting file that you can import into CE : [DOWNLOAD FINAL COLLECT_DATA FILE][6]**
FILE][7]**
[1]: http://www.openforis.org/support/upfiles/chrome_2019-11-27_22-29-38.png
[2]: https://drive.google.com/file/d/1E6RZfYk2FyWP4J08Oao7Ialnqd_WGcQp/view?usp=sharing
[2]: [3]: http://www.openforis.org/support/upfiles/chrome_2019-11-27_21-38-50.png
[3]: [4]: https://drive.google.com/file/d/14ICwJkfuEaho2cCk4XjH2yhHcLJZZ9vY/view?usp=sharing
[4]: [5]: https://drive.google.com/file/d/1-KpbehUfc9oQlBLMzN2YyGkYXkNW1jS1/view?usp=sharing
[5]: [6]: http://www.openforis.org/support/upfiles/chrome_2019-11-27_21-48-55.png
[6]: [7]: https://drive.google.com/file/d/1rZ7rWCoSp5lAq9OVmEfeykNCswAVj09y/view?usp=sharing