| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Database Collection Workflows

This version was saved 6 years, 2 months ago View current version     Page history
Saved by Samina Gul Ali
on January 28, 2018 at 6:39:48 pm
 

Database Collection Workflow Steps:

Use this page for posts on your database workflows (for future RA’s to follow your directions), as well as a place to post about challenges that you face as you collect articles for the project. Below are two examples, as well as links to specific newspaper collection workflows.

 

USA Today Collection Workflow

New Yorker Collection Workflow

New York Times Random Corpus Collection Workflow

 

  1. EXAMPLE ONE: Search ProQuest Newsstand
    1. Since an institutional license is required for ProQuest, you need to be working on campus or ou need to sign in to ProQuest via the UM/UCSB/CSUN library site.
      1. Go to your library site. Search the Databases > P. Select "ProQuest Newsstand."
    2. If you're off campus, you will need to sign in with your student ID and password.
    3. Click on the "Advanced Search" link to show the Advanced Search interface for ProQuest. You might also be taken here automatically.
      1. Click on "Publications." Search for your selected publication
    4. You should now be looking at the "Publication Information" site for your selected publication. Scroll down and select "Advanced Search" under "Search within this publication." 
    5.   Search as follows: 
      1. First Search bar: Make sure the publication's pubid is automatically entered into the first search bar. 
      2. Second search bar: To search for a literal word or phrase, put quotes around the term. Enter the word "humanities" including the quotes.      
      3. Publication date. Select "specific date range" from the drop-down menu and fill out as follows:
        1. Start: January 1, whatever year you are collecting
        2. End: December 31, whatever year you are collecting
      4. Sort results by: Scroll to the bottom of the ProQuest search form and make sure "Relevance" is selected for this field.
      5. Items per page: This is where you tell ProQuest how many search results to display on one page at a time. You will want to change this number depending on how many articles you are going to be collecting for your year. For example, if you need to collect 102 articles, setting the "items per page" to 100 makes the most sense and will allow for the quickest collection. However, if you're only collecting 25 articles, you will likely want to set the items per page to 20.
    6. After running the search, select the number of articles you need to download. Depending on how many you need, you may need to go to the next page and select the rest. For example, if you need to collect 104 articles, select all from the first page of results, then click "Next," and select 4 from the following page. Make sure to select only articles from the year you are searching for.
    7. Once you've selected the proper number of articles, use the "Export/Save" function to export to "HTML."  Fill in the dialogue box for export options as follows:
      1. output: HTML
      2. content: full text
      3. sort order: oldest first
      4. include: select cover page/header, table of contents, document numbering
    8. Save the resulting HTML page (a local web page consisting of a .html file) in whatever folder you have set up to hold WE1S materials. The file name for the HTML file has by default the date of collection (e.g., ProQuestDocuments-2015-07-21.html). To help keep things straight, change the name to reflect the materials being collected.  For example, the HTML file with the results of a New York Times search for the year 1987 should be: "ProQuestDocuments-nyt-1987.html" [the .html is the file extension, not part of the file's name]).

 

  1. EXAMPLE TWO: Search Gale News Vault 
    1. Since an institutional license is required for Gale, you need to be working on a campus or you need to sign in to Gale via the UM/UCSB/CSUN Library site.
      1. Go to your library site. Search for Databases > G. Select "Gale News Vault."
      2. If you're off campus, you will need to sign in with your student ID and password.  
    2. Under “Limit Your Search,” scroll down to “By Publication Title” and click “Browse Publication Titles” (to the left of the search box)
      1. Click on the first letter of your chosen publication, and select your publication
      2. Click “submit” (this will return you to the Gale News Vault homepage, with your pubid now in the “By Publication Title” search box
      3. Hit “Search” on the right-hand side of the page
    3. On the “Search Results” page, make sure you have correctly selected your publication
      1. On the left-hand side, you will see a dark blue box. At the bottom of the blue box, you should see “Limit By” followed by a drop-down menu. The selection on the drop-down menu should be “Publication Title.” Underneath “Publication Title” should be the name of your chosen publication.
    4. On the left-hand side of the “Search Results” page, you can refine your results by date or keyword. Search as follows: 
      1. Refine Results. Here is where you enter keywords like “humanities.” Be sure to include quotes around the term.  
      2. Limit by date.  Select "specific date range" from the drop-down menu and fill out as follows:
        1. Start: January 1, whatever year you are collecting
        2. End: December 31, whatever year you are collecting
      3. Sort by: On the top right corner of your search results, click the “Sort by” drop-down menu and choose "Relevance"
    5. After running the search, select the number of articles you need to download. Depending on how many you need, you may need to go to the next page and select the rest. For example, if you need to collect 104 articles, select all from the first page of results, then click "Next," and select 4 from the following page. Make sure to select only articles from the year you are searching for.
    6. HERE IS WHERE WE RUN INTO A PROBLEM ON GALE NEWS VAULT: There is no clear option where you can collect/download more than one article at a time. After doing a quick google search on Gale News Vault, it seems as though they do have a limitation on how many articles can be downloaded by a single user (although I have not found an exact number)

 

Comments (0)

You don't have permission to comment on this page.