FamilySearch Wiki:WikiProject Czech Archives Part 2

Purpose
Identify the correct archive for all localities not found yet in the Czech Gazetteer Spreadsheet.

Project Leader
Heather Mecham

Task List
Task List

Project Instructions
Before you begin: You will need to create a free account if you haven't used GenTeam before.

Part 1: Find localities that don't have an archive in the archive column
1. Choose a letter sheet (A-Z) at the bottom of the task list. 2. Sort the gazetteer sheet:
 * highlight the entire sheet by clicking the little rectangle to the top left of the sheet.


 * clicking the data menu


 * select sort range
 * go to sort by and select column J and select A-Z.
 * press sort

3. Scroll to the bottom of the sheet where you will find any blank spaces in the archive column (J). 4. When you find a line where the archive is blank, check the notes column (K) to see if the archive is listed. If an archive is listed, move from the notes column (K) to the archive column (J). The notes column (K) may say someting like "this locality is not on either sheet". This means it wasn't found in the last phase of the project. You will be address this in Part 2 of these instructions. 5. If no archive is listed in the notes column, try the Bohemian Gazetteer and Moravian Gazetteer from part two of the project in case they were missed. If you have questions about how to use these gazetteers, you can find instructions on the FamilySearch Wiki:WikiProject Czech Republic Archives page. 6. If found, add the name of the archive to the archive column and go back to step one. 7. If not found in the PDF gazetteer, try searching GenTeam for the locality.
 * click Gazetteer on the menu to the far left
 * enter in the name of the locality in the place field
 * leave the crown land field blank
 * If locality is found, you will see a list of search results. If there is more than one locality with the same name, compare the parish name in GenTeam with the parish name in the Google Sheet.
 * Click in the "details" column for the locality that matches.
 * Towards the bottom and right of the detail view, for the locality, you will see a heading that says "respective archives". Click the link to the archive. The name of the archive in GenTeam is the German name. We need the name in English or Czech, which can be retrieved from the archive's site.
 * Google Translate will pop up, offering to translate the page from Czech to English. Click English.
 * Once the page is translated. You will be able to find the name of the archive on that page. It will say something like "State Archive in Zamrsk".
 * Enter the archive name and in the archive column (J) and go back to step 1.
 * if not found, go to step 7.

8. If not found, try Wikipedia, using the locality name with Czech Republic or Czechia.
 * If found in Wikipedia, look at the district in the sidebar on the right and continue to the next step. If not found mark the line red and put not found in PDF gazetteers, GenTeam or Wikipedia.
 * Make a note of the line you are on on the sheet.
 * Using control F, search the Google sheet for the name of the district found in Wikipedia.
 * Once found, look at the archive column for that district.
 * Copy the name of the archive.
 * Return to the line you were on and paste the archive in the archive column.
 * Return to step 1.

Part 2: Check the notes column
1.Sort the gazetteer spreadsheet by highlighting the whole sheet, clicking on data, selecting sort range, column K and sort A-Z. This will shift all rows with notes in the notes column to the top of the sheet. 2. Search through the spreadsheet, looking for any notes in the notes column. 3. When you get to a note, read it. It may list an alternate archive for the locality. Replace the name of that archive with the archive listed in the archive column for that line. 4. If the note says the locality was not found in either PDF, try to find it by doing the following:
 * Check the archive column for that line. If it's already filled in, you can go to the next line with a note on it.
 * Check the PDF gazetteers for that locality.
 * Check GenTeam
 * Check Wikipedia. If the judicial district is found in Wikipedia, compare it to the judicial district listed in the sheet. If they don't match, put the name of the judicial district found in Wikipedia.
 * Look in the judicial district column to see if the judicial district is listed.
 * Make a note of the line you are on on the sheet.
 * Using control F, search for the name of the district found in Wikipedia.
 * Once found, look at the archive column for that district.
 * Copy the name of the archive.
 * Return to the line you were on and paste the archive in the archive column.

Part 3: Add links to the archives
1. Sort the Google sheet by highlighting the whole sheet, clicking on data, select sort range, column J and A-Z. 2. Open the Czech Republic Archives and Libraries page in the Wiki. 3. Go to the first archive listed in the spreadsheet. 4. Find that archive on the Czech Republic Archives and Libraries and click the link for it. 5. Copy the link for the archive. 6. Go back to the Google sheet and right click on the archive you want to add the link for. 7. Select insert link. 8. Paste the link in the link field. 9. Click apply and move to the next line. 10. When you get to the next archive name, go back to step 2.