TheocBase/Test

Tip:

<span>You can copy and paste the talks from the Public Talk List (S-99) or directly from jw.org. The result of the public talk outlines in the documents section may be displayed on multiple pages with 15 talks on each. If this list contains both, the talk number along with its theme, then you can copy and paste the talks directly from each page.</span> 
<br><span>In each case you need to check and <a href="#revised_public_talk_outlines">update revised or discontinued talks</a> afterward. A separate form accompanying the Public Talk List (S-99) may be available, that contains corrections. If this form is not available in your language, you can find updated talks also if you filter the public talk outlines by the revision date found on the S-99 form. Check also the announcements (S-147) regarding public talks for further informations (e.g. discontinued date).</span>

Note:

If you plan to import further data, containing historical record, it may be beneficial to maintain also a complete list of discontinued and revised talks along with the corresponding dates, in order to match the given talk numbers correctly. See the section <a href="#revised_public_talk_outlines">Revised Public Talks</a> on how to update talks.

Make necessary corrections making sure there are only talk numbers and titles.

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 talk list, press the <strong>Save to Database</strong> button.

Adding Congregations and Speakers

Multiple congregations and speakers, along with their talks, can be added via a tab delimited list at once.

You need to <a href="#revised_public_talk_outlines">add the complete list of public talk outlines</a> first.

In the <strong>Settings</strong> select the <strong>Add congregations and speakers</strong> tab on the <strong>Public Talks</strong> page.

In the dialog, enter the speakers and congregations in the following format:<br><code class="green">Congregation</code><code class="highlight_gray"> TAB </code><code class="green">Speaker's name</code><code class="highlight_gray"> TAB </code><code class="green">Phone</code><code class="highlight_gray"> TAB </code><code class="green">Public talk number(s comma separated)</code>

The fields are separated with a tab character and multiple talks can be entered, separated with a comma. 

Select in which order you entered the names (last name first name vs first name last name).

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

Revised Public Talk Outlines

In order to keep track of changing titles, outlines or complete replacements of talks it is possible to set the corresponding dates of their releasing and discontinuing as well as their current revision date. When a discontinued talk is replaced by another, it is neccessary to set the discontinued date [1] of the old talk and the release date [2] of the new talk, because these dates determine which of these talks should be displayed at a given time:

Revised talk outlines

Update a Talk