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 of the archive column in the Google sheet. In the screenshot below it says "Brno".

2. Find the archive in the table (under the heading "If column E says") at the bottom of this page. See screenshot below.

3. Look to the right of the archive to the columns with the headings "add to column F" and "add to column G" to see what needs to be added to the Google sheet for your archive. If it says "blank" leave the column blank on the Google sheet and go back to step 1. If there is code to the right of the archive name in either column, go to step 4 to add it to the Google sheet. In this example, you will leave columns F and G blank.

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.