TheocBase/TheocBase

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.

Territories - Working with the territory data in a geographic information system (GIS)

Add Territory Layers to a QGIS Project

Open or create a new project in QGIS.

Select the menu item <strong>Layer>Add Layer>Add Vector Layer...</strong>

Click on the <strong>Browse</strong> button and select the "theocbase.sqlite" file.

Click on the <strong>Add</strong> button.

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.

Add the layers by clicking on the <strong>OK</strong> button.

Export into a KML File

Right click the layer you want to export and select <strong>Export>Save Features As...</strong>

In the <strong>Format</strong> field choose <strong>Keyhole Markup Language [KML]</strong>.

Click on the <strong>Browse</strong> button and select a filename.

Under <strong>Select fields to export and their export options</strong> check the following fields:

Edit the <strong>Datasource Options</strong>

Click <strong>OK</strong> to save the KML file.

Choose <strong>File</strong> as <strong>Vector Source Type</strong>.

Choose the <strong>CRS</strong> (Coordinate Reference System): <strong>EPSG:4326</strong>.