TheocBase/TheocBase

From the <strong>Year</strong> drop-down, select the year for your Life and Ministry Meeting entry.

To edit the meeting items, please use the directions located in <a href="settings_mw_meeting.html#edit_lmm_schedule">Edit the Life and Ministry Meeting Schedules</a>.

In the sidebar, open the corresponding drop-down list and use the <a href="user_interface.html#lookup_control">lookup control</a> features to select someone:

by <a href="user_interface.html#lookup_control_settings_default">default</a>, the most fitting persons appear at the top of the list

pay attention to the <a href="user_interface.html#lookup_control_details">warnings and classifications in the person's details</a>

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

The first four buttons represent different categories of assignments:

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

This option can be combined with the selected categories to only display assignments that are similar to the one, that is currently assigned.

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

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.

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>

Addresses

Click on the <strong>Request date</strong> field and enter a date, e.g. the date of a "Do not call"-request.

Settings - Territories