Skip to Content

Changes for page Excel plugin

Last modified by Robert Jan Daams on 2025/02/04 11:03
From version 9.3
edited by Nico Lemaire
on 2024/12/03 14:15
Change comment: There is no comment for this version
To version 3.1
edited by Roelof Zwaan
on 2022/07/11 16:29
Change comment: Uploaded new attachment "ITWorks.TerraIndex.ExcelPlugin_1_0_2_46 (1).zip", version {1}

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.NicoLemaire
1 +XWiki.RoelofZwaan
Content
... ... @@ -1,52 +15,9 @@
1 -(% class="box warningmessage" %)
2 -(((
3 -ATTENTION:
4 -As from 1-1-2025 the Excel Plugin will stop to work! 
5 -The Excel plugin is based on old technology that cannot be supported anymore and blocks new developments for TerraIndex.
6 -\\With the Excel plugin you can download data in 2 formats; ‘TerraIndex Delphi’ en ‘XML Field’For the ‘TerraIndex Delphi’ version we've created a new report that you can find in TerraIndex Web on the report page. The name of this report is ‘Projectdump Excel plugin’ and can be found under General
7 -
8 -De XML Field version you can get by making a TerraIndex .ti export. Rename this file to .zip and extract. The xml file that you get can be imported in Excel with the Excel Power Query function.
9 -
10 -Another way to get information from the TerraIndex database or upload data to TerraIndex is by using the Webservices. Details regarding the Webservices you can find [[here >>doc:Implementation documentation.Setting up a Webservice connection for project exports.WebHome]]in this Wiki.
11 -)))
12 -
13 -
14 -
15 15  The excel plugin makes it possible to export your projects to excel (and reimport them back into the Terraindex environment).
16 16  Usage of this tool is recommended for expert users only...
17 17  
18 -**Download link:** [[ITWorks.TerraIndex.ExcelPlugin_1_0_2_46.zip>>attach:ITWorks.TerraIndex.ExcelPlugin_1_0_2_46 (1).zip||rel="noopener noreferrer" target="_blank"]]
4 +**Download link:** [[attach:ITWorks.TerraIndex.ExcelPlugin_1_0_2_43.zip||rel=" noopener noreferrer" target="_blank"]]
19 19  
20 20  __**Release Notes:**__
21 21  
22 -__**11-07-2022, Updated to newest version**__
23 -
24 24  __29-11-2021, ITWorks.TerraIndex.ExcelPlugin_1_0_2_43;__
25 25  - New fields added for synchronisation; see [[https:~~/~~/wiki.terraindex.com/bin/view/TerraIndex%20ReleaseNotes/>>https://wiki.terraindex.com/bin/view/TerraIndex%20ReleaseNotes/]].
26 -
27 -
28 -
29 -== How to use ==
30 -
31 -* Install the plugin. You'll need admin rights to install. In Excel check that plugins are allowed to be used
32 -* Start Excel and open the menu Add-ins
33 -* Use the Get Project option below to download the project to Excel
34 -[[image:1663765095894-237.png]]
35 -
36 -* A popup screen will appear. Use the following settings:
37 -** Username and Password: your TerraIndex username and password ~-~-> Read about the new Pincode usage: 
38 -[[https:~~/~~/wiki.terraindex.com/bin/view/test/New%20login%20process%20for%20TerraIndex/#HWatverandertervoorTerraIndexGeoserver28voorQGISenArcGIS29endeExcelPlugin3F>>https://wiki.terraindex.com/bin/view/test/New%20login%20process%20for%20TerraIndex/#HWatverandertervoorTerraIndexGeoserver28voorQGISenArcGIS29endeExcelPlugin3F]]
39 -** LicenseNR: you can find your licensenr in TerraIndex Web via the menu, option License management
40 -** Projectcode: the projectcode of the project you want to download
41 -[[image:1663765255228-932.png]]
42 -
43 -* 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
44 -* **Changing data**
45 -** 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 keep the same date format)
46 -* **Adding new information** 
47 -** 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
48 -* **Uploading changes**
49 -** Use the Upload project option to send the changes to TerraIndex
50 -[[image:1663766038448-866.png]]
51 -
52 -
1663765095894-237.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.NicoLemaire
Size
... ... @@ -1,1 +1,0 @@
1 -15.5 KB
Content
1663765255228-932.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.NicoLemaire
Size
... ... @@ -1,1 +1,0 @@
1 -7.5 KB
Content
1663766038448-866.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.NicoLemaire
Size
... ... @@ -1,1 +1,0 @@
1 -15.4 KB
Content