Hi Tesfay, From Collect Earth the easiest thing to do would be : 1. Create a CSV file with the data ( go to **Tools->Data Import/Export -> Export data to CSV**) 2. Open the file using Excel, LibreOffice or any other style sheet type of software. In Excel you will need to load the CSV file by using the Data tab ![alt text][1] 3. Now filter the data however you want through Excel/LibreOffice and remove all the columns in the CSV file except for the id ( the id of the plot in the DB) column and the column that you want to update. The result would be something like (assuming the attribute you want to change is called land_management, check the headers in your CSV!! ): > id,land_management > > 1,"conservation/protected" > > 2,"conservation/protected" > > 3,"conservation/protected" > > 4,"conservation/protected" So at the end you have the list of all of the plots in the DB that you want to update and their newer values! 4. SO the last steep is to import this data back into Collect Earth. Go to **Tools->Data Import/Export->Update current records using CSV** , and use this CSV that you have created! Afterwards you can run Saiku again (making sure to say that you want to update the Saiku database when your are prompted). And that should it.... Hope this clarifies! [1]: http://www.openforis.org/support/upfiles/EXCEL_2016-07-12_15-42-19.png

Hi Tesfay, From Collect Earth the easiest thing to do would be : 1. Create a CSV file with the data ( go to **Tools->Data Import/Export -> Export data to CSV**) 2. Open the file using Excel, LibreOffice or any other style sheet type of software. In Excel you will need to load the CSV file by using the Data tab ![alt text][1] 3. Now filter the data however you want through Excel/LibreOffice and remove all the columns in the CSV file except for the id ( the id of the plot in the DB) column and the column that you want to update. The result would be something like (assuming the attribute you want to change is called land_management, check the headers in your CSV!! ): > id,land_management > > 1,"conservation/protected" > > 2,"conservation/protected" > > 3,"conservation/protected" > > 4,"conservation/protected" So at the end you have the list of all of the plots in the DB that you want to update and their newer values! 4. SO the last steep is to import this data back into Collect Earth. Go to **Tools->Data Import/Export->Update current records using CSV** , and use this CSV that you have created! Afterwards you can run Saiku again (making sure to say that you want to update the Saiku database when your are prompted). And that should it.... Hope this clarifies! [1]: http://www.openforis.org/support/upfiles/EXCEL_2016-07-12_15-42-19.png

Hi Tesfay, From Collect Earth the easiest thing to do would be : 1. Create a CSV file with the data ( go to **Tools->Data Import/Export -> Export data to CSV**) 2. Open the file using Excel, LibreOffice or any other style sheet type of software. In Excel you will need to load the CSV file by using the Data tab ![alt text][1] 3. Now filter the data however you want through Excel/LibreOffice and remove all the columns in the CSV file except for the id ( the id of the plot in the DB) column and the column that you want to update. The result would be something like (assuming the attribute you want to change is called land_management, check the headers in your CSV!! ): *id,land_management id,land_management 1,"conservation/protected" 2,"conservation/protected" 3,"conservation/protected" 4,"conservation/protected"* 4,"conservation/protected" So at the end you have the list of all of the plots in the DB that you want to update and their newer values! 4. SO the last steep is to import this data back into Collect Earth. Go to **Tools->Data Import/Export->Update current records using CSV** , and use this CSV that you have created! Afterwards you can run Saiku again (making sure to say that you want to update the Saiku database when your are prompted). And that should it.... Hope this clarifies! [1]: http://www.openforis.org/support/upfiles/EXCEL_2016-07-12_15-42-19.png

Hi Tesfay, From Collect Earth the easiest thing to do would be : 1. Create a CSV file with the data ( go to **Tools->Data Import/Export -> Export data to CSV**) 2. Open the file using Excel, LibreOffice or any other style sheet type of software. In Excel you will need to load the CSV file by using the Data tab ![alt text][1] 3. Now filter the data however you want through Excel/LibreOffice and remove all the columns in the CSV file except for the id ( the id of the plot in the DB) column and the column that you want to update. The result would be something like (assuming the attribute you want to change is called land_management, check the headers in your CSV!! ): id,land_management *id,land_management 1,"conservation/protected" 2,"conservation/protected" 3,"conservation/protected" 4,"conservation/protected" 4,"conservation/protected"* So at the end you have the list of all of the plots in the DB that you want to update and their newer values! 4. SO the last steep is to import this data back into Collect Earth. Go to **Tools->Data Import/Export->Update current records using CSV** , and use this CSV that you have created! Afterwards you can run Saiku again (making sure to say that you want to update the Saiku database when your are prompted). And that should it.... Hope this clarifies! [1]: http://www.openforis.org/support/upfiles/EXCEL_2016-07-12_15-42-19.png

Hi Tesfay, From Collect Earth the easiest thing to do would be : 1. Create a CSV file with the data ( go to **Tools->Data Import/Export -> Export data to CSV**) 2. Open the file using Excel, LibreOffice or any other style sheet type of software. In Excel you will need to load the CSV file by using the Data tab ![alt text][1] 3. Now filter the data however you want through Excel/LibreOffice and remove all the columns in the CSV file except for the id ( the id of the plot in the DB) column and the column that you want to update. The result would be something like (assuming the attribute you want to change is called land_management, check the headers in your CSV!! ): id,land_management 1,"conservation/protected" 2,"conservation/protected" 3,"conservation/protected" 4,"conservation/protected" So at the end you have the list of all of the plots in the DB that you want to update and their newer values! 4. SO the last steep is to import this data back into Collect Earth. Go to **Tools->Data Import/Export->Update current records using CSV** , and use this CSV that you have created! Afterwards you can run Saiku again (making sure to say that you want to update the Saiku database when your are prompted). And that should it.... Hope this clarifies! [1]: http://www.openforis.org/support/upfiles/EXCEL_2016-07-12_15-42-19.png

Hi Tesfay, From Collect Earth the easiest thing to do would be : 1. Create a CSV file with the data ( go to **Tools->Data Import/Export -> Export data to CSV**) 2. Open the file using Excel, LibreOffice or any other style sheet type of software. In Excel you will need to load the CSV file by using the Data tab ![alt text][1] 3. Now filter the data however you want through Excel/LibreOffice and remove all the columns in the CSV file except for the id ( the id of the plot in the DB) column and the column that you want to update. The result would be something like (assuming the attribute you want to change is called land_management, check the headers in your CSV!! ): > id,land_management 1,"conservation/protected" 2,"conservation/protected" 3,"conservation/protected" 4,"conservation/protected" So at the end you have the list of all of the plots in the DB that you want to update and their newer values! 4. SO the last steep is to import this data back into Collect Earth. Go to **Tools->Data Import/Export->Update current records using CSV** , and use this CSV that you have created! Afterwards you can run Saiku again (making sure to say that you want to update the Saiku database when your are prompted). And that should it.... Hope this clarifies! [1]: http://www.openforis.org/support/upfiles/EXCEL_2016-07-12_15-42-19.png

Hi Tesfay, From Collect Earth the easiest thing to do would be : 1. Create a CSV file with the data ( go to **Tools->Data Import/Export -> Export data to CSV**) 2. Open the file using Excel, LibreOffice or any other style sheet type of software. In Excel you will need to load the CSV file by using the Data tab ![alt text][1] 3. Now filter the data however you want through Excel/LibreOffice and remove all the columns in the CSV file except for the id ( the id of the plot in the DB) column and the column that you want to update. The result would be something like (assuming the attribute you want to change is called land_management, check the headers in your CSV!! ): > id,land_management > 1,"conservation/protected" > 2,"conservation/protected" > 3,"conservation/protected" > 4,"conservation/protected" So at the end you have the list of all of the plots in the DB that you want to update and their newer values! 4. SO the last steep is to import this data back into Collect Earth. Go to **Tools->Data Import/Export->Update current records using CSV** , and use this CSV that you have created! Afterwards you can run Saiku again (making sure to say that you want to update the Saiku database when your are prompted). And that should it.... Hope this clarifies! [1]: http://www.openforis.org/support/upfiles/EXCEL_2016-07-12_15-42-19.png

Hi Tesfay, From Collect Earth the easiest thing to do would be : 1. Create a CSV file with the data ( go to **Tools->Data Import/Export -> Export data to CSV**) 2. Open the file using Excel, LibreOffice or any other style sheet type of software. In Excel you will need to load the CSV file by using the Data tab ![alt text][1] 3. Now filter the data however you want through Excel/LibreOffice and remove all the columns in the CSV file except for the id ( the id of the plot in the DB) column and the column that you want to update. The result would be something like (assuming the attribute you want to change is called land_management, check the headers in your CSV!! ): > id,land_management > 1,"conservation/protected" > 2,"conservation/protected" > 3,"conservation/protected" > 4,"conservation/protected" So at the end you have the list of all of the plots in the DB that you want to update and their newer values! 4. SO the last steep is to import this data back into Collect Earth. Go to **Tools->Data Import/Export->Update current records using CSV** , and use this CSV that you have created! Afterwards you can run Saiku again (making sure to say that you want to update the Saiku database when your are prompted). And that should it.... Hope this clarifies! [1]: http://www.openforis.org/support/upfiles/EXCEL_2016-07-12_15-42-19.png