TheocBase/TheocBase
-
f7080309177d48db87aeef9eff6a266c3b6985f3
f7080309177d48db87aeef9eff6a266c3b6985f3
When satisfied with the song list, press the<strong>Save to Database</strong>button. -
4aa016e638c40181e932352631bdc3e838e02992
4aa016e638c40181e932352631bdc3e838e02992
After pressing the<img src="../images/add_24x24.png" alt="" />button, the<strong>Wizard</strong>dialog opens. -
a75f09320247365826e20e505d8a3a1b155dde3b
a75f09320247365826e20e505d8a3a1b155dde3b
To switch the order of the song's title and number you can use regular expressions (regex) or wildcards in the replace dialog of many text editors, e.g. enter<strong><span class="nobr">(.+) (\d+)</span></strong>or<strong><span class="nobr">(<*) (<[0-9]@>)</span></strong>in the<strong>Find</strong>field and enter<strong><span class="nobr">$2 $1</span></strong>or<strong><span class="nobr">\2 \1</span></strong>in the corresponding<strong>Replace</strong>field. -
6616725d63f15b0e7b3c94c2385110fe498e2f20
6616725d63f15b0e7b3c94c2385110fe498e2f20
Territories - Working with the territory data in a geographic information system (GIS) -
b7024c0b1a718d2e2c93eb17889e6d6867aece1f
b7024c0b1a718d2e2c93eb17889e6d6867aece1f
Territories -
9f430377c982d071677932b27161bc2aec4983e9
9f430377c982d071677932b27161bc2aec4983e9
Add Territory Layers to a QGIS Project -
b1271cb5a45fac458607aebd1fad57b23fbf4dd8
b1271cb5a45fac458607aebd1fad57b23fbf4dd8
Open or create a new project in QGIS. -
4dbe40ee5cfbd7536a1dfdc806ce334e4cfa8995
4dbe40ee5cfbd7536a1dfdc806ce334e4cfa8995
Select the menu item<strong>Layer>Add Layer>Add Vector Layer...</strong> -
c7f1c66eee4d8cab1b1868e3ac3ab976e2bb9bb6
c7f1c66eee4d8cab1b1868e3ac3ab976e2bb9bb6
Click on the<strong>Browse</strong>button and select the "theocbase.sqlite" file. -
0d39e40c13023eb018928a26f0a74d0ffbc11860
0d39e40c13023eb018928a26f0a74d0ffbc11860
Click on the<strong>Add</strong>button. -
23b399bd413c8dfe8688f37d0df1a1c1d399fe2a
23b399bd413c8dfe8688f37d0df1a1c1d399fe2a
Caution: -
d6d94c5328e29111a28b62ff70caa9687a753c6a
d6d94c5328e29111a28b62ff70caa9687a753c6a
When editing the geometry in a third party tool like QGIS, TheocBase will not be aware of the changes during cloud syncing. In order to upload the changes you need to mark the territories as edited e.g. add a blank in the remark field. Alternatively you can also export the territories into a KML file and reimport this file in TheocBase. -
0d84a9a756e2271959f478f5a7856cfb40bd1aea
0d84a9a756e2271959f478f5a7856cfb40bd1aea
Add the layers by clicking on the<strong>OK</strong>button. -
817348a2e0e997c90ef87c78b83fabf0bc74a1f6
817348a2e0e997c90ef87c78b83fabf0bc74a1f6
Export into a KML File -
8eb988c435f58babc318124f1a1a1f9104f5abb1
8eb988c435f58babc318124f1a1a1f9104f5abb1
Right click the layer you want to export and select<strong>Export>Save Features As...</strong> -
bb0cd5f28ff1bfe24aa46da26dad7da92ff35616
bb0cd5f28ff1bfe24aa46da26dad7da92ff35616
In the<strong>Format</strong>field choose<strong>Keyhole Markup Language [KML]</strong>. -
cc8c2251cad9b909a69588df806712c8a93e0797
cc8c2251cad9b909a69588df806712c8a93e0797
Click on the<strong>Browse</strong>button and select a filename. -
f357a05cb0316664fd047be5dff8cadfd04b1dd2
f357a05cb0316664fd047be5dff8cadfd04b1dd2
Under<strong>Select fields to export and their export options</strong>check the following fields: -
fd96b0d46f733925e4c6ef5e64cd871030181a0d
fd96b0d46f733925e4c6ef5e64cd871030181a0d
Edit the<strong>Datasource Options</strong> -
86cee4a721d8bf900a420f1374ea0e35fe638cb3
86cee4a721d8bf900a420f1374ea0e35fe638cb3
Click<strong>OK</strong>to save the KML file.