TheocBase/TheocBase

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.

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

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

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.

Click in the <strong>Name</strong>, <strong>From</strong>, <strong>To</strong> or <strong>Quantity</strong> field of the street and edit the corresponding value.

Click on the <strong>Type</strong> field and select the <a href="settings_territories.html#streets">type of the street</a>.

Click the <img src="../images/street_remove_24x24.png" alt="" width="24" height="24" /> button on the <strong>Streets</strong> tab to remove the street.

The <strong>Add streets</strong> dialog displays the streets within the territory's boundary. Uncheck the field <strong>Hide already added streets</strong> to see the complete list.

It is mandatory to <a href="territories_view_edit.html#import_territory_boundaries">add a territory boundary</a> first, before this feature can be used.

Select the check boxes next to the streets you want to add. Click on the column header to select all at once.

Territories are displayed by city, publisher, type or worked date [2] in the territory list box [1]. You can assign territories, display their boundaries and <a href="#find_territory_by_address">find territories by address</a>.

In the <a href="settings_territories.html">settings</a> add the cities that belong to your congregation's territory and the types of territories and addresses you want to use.

Edit the <a href="#edit_territory_attributes">territory attributes</a> of the selected territory [4].

Use the <img src="../images/territory_add_24x24.png" alt="" width="24" height="24" /> button to add a territory.

Click the <img src="../images/territory_remove_24x24.png" alt="" width="24" height="24" /> button to remove the selected territory.

Territories are searched by the assigned <strong>Name</strong> field. If no territory is found, a new territory will be created. If the <strong>Description</strong> field is assigned, the corresponding value will be saved.

You can use <strong>Google Maps</strong> to create a KML-file. Sign in and create a map. When you finish drawing the shape of a territory, enter the territory number in the <strong>Name</strong> field and the locality in the <strong>Description</strong> field. Finally you can save your map by clicking on the <strong>Export to KML</strong> menu item.