TheocBase/TheocBase

Press the <strong>OK</strong> button and review what you have pasted.

When satisfied with the song list, press the <strong>Save to Database</strong> button.

After pressing the <img src="../images/add_24x24.png" alt="" /> button, the <strong>Wizard</strong> dialog opens.

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)

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.

The TheocBase SQLite database can be opened in a GIS software that allows users to analyze or combine the data with other sources e.g. create high quality maps for the Kingdom Hall. In the following instructions QGIS is used, a multi-platform GIS available for free, but other programs may be used similarly.

<span>Select the layers you want to use in QGIS:</span> 
<br><span><strong><!-- Table name: -->territory<!-- Don't translate this. --></strong>: for editing boundaries</span> 
<br><span><strong><!-- Table name: -->territories<!-- Don't translate this. --></strong>: for viewing and analyzing the territories</span> 
<br><span><strong><!-- Table name: -->territory_address<!-- Don't translate this. --></strong>: for editing addresses</span> 
<br><span><strong><!-- Table name: -->territoryaddresses<!-- Don't translate this. --></strong>: for viewing and analyzing the addresses</span> 
<br><span><strong><!-- Table name: -->territory_street<!-- Don't translate this. --></strong>: for editing streets</span> 
<br><span><strong><!-- Table name: -->territorystreets<!-- Don't translate this. --></strong>: for viewing and analyzing the streets</span> 

<span><!-- Field name: -->territory_number<!-- Don't translate this. --></span><br><span><!-- Field name: -->locality<!-- Don't translate this. --></span>

<span>Enter "<!-- Field name: -->locality<!-- Don't translate this. -->" next to <strong>DescriptionField</strong>.</span><br><span>Enter "<!-- Field name: -->territory_number<!-- Don't translate this. -->" next to <strong>NameField</strong>.</span>

Territories - Streets

Add Streets

Select a territory.

Click the <img src="../images/street_add_24x24.png" alt="" width="24" height="24" /> button on the <strong>Streets</strong> tab to add a new row in the street list box.