FamilySearch Wiki:WikiProject Creating the Czech Archive Finder, Part 1

Project Leader
Heather Mecham

Task List
Task List

Purpose
Adding FamilySearch collections wikitext to the Czech Gazetteer Google sheet.

Project Instructions
This project only needs to be completed in Google sheets.

Part 1
1. Go to the Task List. 2. Select a letter in the tab column to work on in the Czech Gazetteer Google sheet by putting your name in the name column. 3. Go to the Czech Gazetteer Google sheet and find the letter you selected, which will be across the bottom of the Google sheet. 4. Sort the sheet by the archive column (column E) by following the steps below.
 * a. Select the entire sheet by clicking the empty rectangle to the upper left of the sheet.
 * b. Go to the data menu and click "sort range".
 * c. Check "data has header row" box.
 * d. Select the column header "archive" which is column E.
 * e. Click sort.

5. You will use the table below to fill in columns F and G according to the name of the archive in column E. See part 2 for detailed instructions.

Part 2
1. Look at the name in the archive column in the Google sheet. In the screenshot below it says "Brno".

2. Using the Archive Table at the bottom of this page, find the archive name under the heading “If column E says”. See screenshot below.

3. The name of the archive in the column “If column E (archive) says” determines the information to be added to columns F and G in the Czech Republic Gazetteer Google sheet. Columns “Add to column F” and “Add to column G” have the codes to be added.
 * Example: In the screenshot, Brno is shown as the archive for the locality Adamov. Both columns to the right of “If column E (archive) says” have the word “blank”. This means you will leave those two columns blank. See screenshot below.
 * If the either or both columns say “blank” leave the column blank on the Google sheet and go back to step 1. If there is code in either or both columns, got to step 4 to add it to the Google sheet.

4. Copy and paste the code from the table below into the Google sheet.

5. Highlight the and copy the code you just pasted to the Google sheet. Then highlight multiple cells to paste the code into multiple cells. 6. Once you've pasted to multiple cells, it will look like the screenshot below. 7. Continue to add code for the name of the archive until all of the rows for that archive name have the correct code (or are left blank) according to the table below.

8. Move on to the next archive on the sheet, using the table below, until all archives on the sheet have been processed.

9. Go back to part 1 and select another tab on the task list.