Approver, Reviewer, editor, pagecreator
46,825
edits
| Line 72: | Line 72: | ||
===== Phase 5: Identify online newspapers ===== | ===== Phase 5: Identify online newspapers ===== | ||
:A) Identify online copies of newspapers from well-known sites. | :A) Identify online copies of newspapers from well-known sites. | ||
:: | ::Purpose: find and paste links to online copies of newspapers from the county sortable tables | ||
:::Use the Excel file (WA Newspapers 2010) to 1) identify the counties and 2) create the external link | |||
::*See "CA online" tab in WA Newspapers 2010. | ::*See "CA online" tab in WA Newspapers 2010. | ||
::::1) Sort by column | ::::1) Find the counties for each newspaper (done in Column G by Wilma) | ||
:::::1a) Sort by county | |||
:::::1b) In column H, copy the formula: =left(b1,search(".",b1)-1) | |||
::::2) Navigate to the __ County Newspapers page in Wiki | ::::2) Navigate to the __ County Newspapers page in Wiki | ||
::::3) In WikiText, find the newspaper on the list (Ctrl+F) | ::::3) In WikiText, find the newspaper on the list (Ctrl+F) | ||
::::4) In the Online Column ( | ::::4) In the Online Column (fifth pipe) paste the link [ + URL + space + CA + ] (For the URL, click the icon in column B of the Excel File.) | ||
::::5) Back in the Excel file, type Done in column J. | ::::5) Back in the Excel file, type Done in column J. | ||
::*See "SOS" tab in WA Newspapers 2010 | ::*See "SOS" tab in WA Newspapers 2010 | ||