Changes for page Excel plugin
Last modified by Robert Jan Daams on 2025/02/04 11:03
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -9,3 +9,29 @@ 9 9 10 10 __29-11-2021, ITWorks.TerraIndex.ExcelPlugin_1_0_2_43;__ 11 11 - New fields added for synchronisation; see [[https:~~/~~/wiki.terraindex.com/bin/view/TerraIndex%20ReleaseNotes/>>https://wiki.terraindex.com/bin/view/TerraIndex%20ReleaseNotes/]]. 12 + 13 + 14 + 15 +== How to use == 16 + 17 +* Install the plugin. You'll need admin rights to install. In Excel check that plugins are allowed to be used 18 +* Start Excel and open the menu Add-ins 19 +* Use the Get Project option below to download the project to Excel 20 +[[image:1663765095894-237.png]] 21 + 22 +* A popup screen will appear. Use the following settings: 23 +** Username and Password: your TerraIndex username and password 24 +** LicenseNR: you can find your licensenr in TerraIndex Web via the menu, option License management 25 +** Project code: the projectcode of the project you want to download 26 +[[image:1663765255228-932.png]] 27 + 28 +* When the project is downloaded, you'll get different tabs with all the project information. E.g. 'tblMeasurementPoints' with all the measurementpoint information or 'tblLayers' with layer information 29 +* **Changing data** 30 +** When you want to change data (e.g. the names of Measurementpoints), change this in the Excel. Then look for the column '~*~*DateLastChanged' and change the date to a date in the future (make sure to use the same date format) 31 +* **Adding new information** 32 +** You can also add new rows with new information. It is important to use the right ID's in the different ID columns. You can study existing data to see how these ID's are used 33 +* **Uploading changes** 34 +** Use the Upload project option to send the changes to TerraIndex 35 +[[image:1663766038448-866.png]] 36 + 37 +