TheocBase/TheocBase

if necessary, adjust the <a href="user_interface.html#lookup_control_filter">filter buttons</a> to determine which historical records you want to take into consideration for the person's details

<span>Assignments are differentiated also by their types in terms such as reading, demonstration, talk or study conductor, which can be a subset of more than one of the above mentioned categories, e.g. reading assignments are available in both <strong>Other assignments</strong> and <strong>Student parts</strong>.</span> 

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> 

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.

Enter a street name in the <strong>search</strong> field in order to quickly find a specific street.

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.