Hi Adia,
In order to achieve this functionality ( to update the values of certain variables that have already been collected ) you need to follow these steps:
- Create a CSV file which will list the new values as columns and that includes the id of the plots.
So for instance if you have a variable called "region" and when you were assessing the plots through Collect Earth that variable was not set properly. See example of a plot location file which had no good information when it was created (missing elevation, slope,aspect and region data):
id,latitude,longitude,elevation,slope,aspect,region
1,41,12,0,0,0,Unknown
2,40,14,0,0,0,Unknown
3,45,9,0,0,0,Unknown
Now I want to fix the region information, so what I should do is to generate a CSV file with two columns : id (which would be the ID of the plot and is usually found as the first column of a plot location file - .ced ) and region like this
id,region
1,Rome
2,Naples
3,Milano
- Import the CSV file through the Collect Earth menu. Now if you had registers with the IDs 1,2 and 3 the regions will be updated. ( this menu item should probable be called "update information through CSV" as the "Import data from XML" sitting next to it has quite a different functionality)
**IMPORTANT: Use "Update current records using CSV"**
![alt text][1]
That is it, if you followed the steps correctly the values stored for those variables should have changed in the Collect database ( attention : this process only updates data that is already there, it doesn't add new registers )
When you start **Saiku** again choose **choose the option to refresh the Saiku database database** so this information is reloaded by Saiku and shown for the analysis.
![alt text][2]
Hope that was clear!
[1]: http://www.openforis.org/support/upfiles/importFromCsv.png
http://www.openforis.org/support/upfiles/notepad++_2017-03-15_12-25-26_1.png
[2]: http://www.openforis.org/support/upfiles/refreshSaiku.jpghttp://www.openforis.org/support/upfiles/javaw_2017-03-15_12-28-51.png