TheocBase/TheocBase

Compare the labeling, when the option <strong>Assignment</strong> is chosen from the <a href="user_interface.html#lookup_control_settings">settings</a> to discover similar type of assignments.

<span><img src="../images/equal-circle_24x24.png" alt="" width="24" height="24" /> <strong>With the same student</strong></span> 
<br><span>When assigning an assistant for a student part, this option is available, in order to only display assignments with the one, who is already selected as student.</span> 

check the <a href="user_interface.html#lookup_control_settings">settings</a> in the bottom right corner for further adjustments

In the <strong>Settings</strong> select the <strong>Songs</strong> page.

Press the <strong>Next</strong> button and choose a language.

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.

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

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>.

Working with the Territory Data in a Geographic Information System (GIS)

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>