User:Caileigholdroyd/Sandbox/Antenati Links

Project Leader
Caileigh Oldroyd

Purpose
Take links from the Antenati website for each jurisdiction and paste them in a task list.

Video Instructions
Video Link

Task List
Task List
 * NOTE: You can scroll through tabs on Google Sheets. Next to the first tab, there are four lines stacked vertically. If you click that, you can see a complete list of all tabs on the Google Sheet. Additionally, next to the last tab, there are right and left arrows that you can click to scroll through.

=Copy Links=

1. Open the task list and choose a tab to work on
 * Put your name in Cell B1 to show that you have worked on that tab

2. Go to Antenati State Archives and click the link that corresponds with your task list
 * Note that the tabs on the task list don't include the words "State Archives of," so just look for the jurisdiction name

3. Click the orange button that says "Search the Registries"

4. Click in your URL and add in the following code to the end of it and press enter: &s_size=10000
 * Before adding in the code
 * After adding in the code
 * This may take a moment for the page to load as it is putting the results list to have 10,000 links on it rather than 5, 10, 50, or 100
 * 10,000 is the maximum this website will allow

5. Take note of the number of results there are at the top of the page and calculate how many pages you will need to click through. The example below would be two pages because there are 11,259 results. 11,259/10,000 = ~2 pages.

6. Once your page has loaded, use your keyboard to select the whole page using the key command "CTRL+A." Once the whole page is highlighted, use the key command "CTRL+C" to copy it.

7. Go to the task list and paste the results you just copied into cell A3.
 * Be sure that when you paste that you can see the links. Do not paste as plain text as that will exclude the links.
 * This may also take a minute to load and your google sheets might not respond, but just click "continue" and it eventually will paste.

8. Then scroll to the bottom of the Antenati page (using the side bar is fastest) and click the next page

9. Repeat step 6 and paste directly under the other results from the first page on the task list. Repeat as needed until you have copied all the results for the locality. 

10. Start the process over on the next locality

If You Exceed the Cell Limit on Google Sheets
There are only two columns because Google Sheets has a limit on how many cells can exist in a tab. If there is a locality that exceeds the limit do the following: 

1. Right click on the tab you are working on and click "Duplicate" 2. Remove all the previously pasted links in the new copid tab by clicking the A at the top of column A and then clicking on your keyboard "DEL" or "Delete" 3. Paste the rest of the links to finish the set