{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Step 1 - EndNote","Steps 2-4 - Zotero","Imported","About","Links"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Full text seeker"]
[null,"Steps 1 and 2  offer advice on using EndNote and Zotero's automatic search to find and attach the PDFs to your Library.",null,null,null,null,null,null,null,null,null,null,null,null,"Bruce, Tracy (2024). Full text seeker. Figshare. Online resource. https://doi.org/10.6084/m9.figshare.25273096"]
[null,"Steps 3 to 6  will give links for you to manually download the PDFs, and attach or store them.",null,null,null,null,null,null,null,null,null,null,null,null,"Full text seeker © 2024 by Tracy Bruce is licensed under CC BY 4.0. "]
[]
[null,"Step 1   EndNote",null,null,null,null,null,null,null,null,null,null,null,null," Search strings needed by this spreadsheet to generate links (don't delete)"]
[null,"Highlight group of references selected for full text review"]
[null,"Use Find Full Text to automatically find and attach PDFs",null,null,null,null,null,null,null,null,null,null,null,null," DOI",null,null,"https://doi.org/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," Google Scholar",null,null,"https://scholar.google.com/scholar?hl=en&as_sdt=0%2C5&q="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," Internet Scholar Archive",null,null,"https://scholar.archive.org/search?q="]
[null,"Step 2   Zotero Standalone (Desktop)",null,null,null,null,null,null,null,null,null,null,null,null," ResearchGate",null,null,"https://www.researchgate.net/search.Search.html?query="]
[null,"Export the records still missing PDFs from EndNote to Zotero"]
[null,"Use the Find Available PDFs option "]
[]
[]
[null,"Step 3   Zotero Lookup Engines (Optional)"]
[null,"Use Zotero's Lookup Engines to search your Library, Google Scholar, & CrossRef"]
[]
[]
[null,"Step 4   Zotero - Export remainder to CSV file (max 2000 records)"]
[null,"Select the remaining records without PDFs, and export to a .CSV file"]
[]
[]
[null,"Step 5   This spreadsheet - Import the Zotero CSV"]
[null,"Click the button to import the CSV to this Workbook",null,null,null,null,null,null,"à"]
[null,"Imports to yellow Imported tab. This tab can be ignored. Go to Step 6"]
[]
[]
[null,"Step 6   This spreadsheet - Create links",null,null,null,null,null,null,null,null,null,null,null,null,"Follow the links in Columns J-M on the pink Links tab to find pages with the PDFs. "]
[null,"Click the button to get links. They will be on pink Links tab below",null,null,null,null,null,null,"à",null,null,null,null,null,"Optional - use extensions in your browser such as Unpaywall, EndNote Click, or Mendeley to help download PDFs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attach the PDFs to your Library or save in a central folder with other Systematic Review files"]
[]
[null,"  Step 7   Request through Document Supply/Inter-Library Loan"]
[null,"Place requests for remaining references through your Library"]

{"sheet":"Step 1 - EndNote","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"EndNote help"]
[]
[]
[null,"      For general EndNote tips see Clarivate FAQ and Knowledge Base: ",null,null,null,null,null,null,"https://support.clarivate.com/Endnote/s/article/EndNote-FAQs?language=en_US"]
[null,"      See their training and video links here:",null,null,null,null,null,null,"https://clarivate.com/webofsciencegroup/support/endnote-20/"]
[]
[null,"      This guide assumes you have run your Title and Abstract screening, and have a group of references in EndNote that need PDFs for the Full Text screening phase"]
[]
[null,"      Automatic - Using EndNote to search for PDFs"]
[null,"      Set your Full Text preferences:  Edit > Preferences > Find Full Text (or EndNote > Preferences on a Mac)"]
[null,null,"Add your university's OpenURL path (check with your Library) - often starts with https://universityname.primo.exlibrisgroup.com"]
[null,null,"Add your university's Authenticate with URL - often starts with http://ezproxy…."]
[]
[null,"      Run the search"]
[null,"      You can search for up to 250 records at a time. Often works best when you are on campus. Works best with records that have a DOI."]
[null,null,"Highlight all needed records, right-click, choose Find Full Text (or choose References > Find Full Text)"]
[null,null,"You will need to login to your institution to Authenticate"]
[null,null,"You will see a Searching... group appear in the Groups Pane on the left showing progress, paperclips will appear next to records when the PDF has been found and attached"]
[]
[null,"      Export the records without PDFs ready for Zotero"]
[null,"      Zotero has its own PDF search tool which you can use"]
[null,null,"Click the Attachments column heading (paperclip)  to sort your group, so that you can highlight just the records without PDFs"]
[null,null,"Highlight just this group of references in your Library, then choose File > Export..., and choose Text File (*.txt) as the type, and EndNote Export as the Output Style."]
[null,null,"Make sure the Export Selected References option is ticked"]
[null,null,"This will create a .txt file in your chosen folder. Optionally rename this file with the extension .ris"]
[null,null," Zotero will also recognise either a .txt or a .ris file that has been exported as an EndNote Export"]
[]
[null,"      Start Zotero Standalone (Desktop), and import the .ris/.txt file (see Zotero tab below for help)"]

{"sheet":"Steps 2-4 - Zotero","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,1,4,5]]}
[null,"Zotero help"]
[]
[]
[]
[null,"Download standalone desktop version of Zotero",null,null,null,null,"Zotero | Your personal research assistant"]
[null,"Zotero Help",null,null,null,null,"getting_help [Zotero Documentation]"]
[]
[]
[null,"      Zotero has its own Find PDFs tool, runs pre-populated searches, and then allows for easy export to CSV for this spreadsheet."]
[]
[null,"      Import the .txt or .ris file from EndNote"]
[null,"      File > Import > A file"]
[null,"      Click Next, and choose the .txt or .ris file you created from EndNote"]
[null,"Click Finish"]
[]
[null,"Use the Find Available PDFs tool"]
[null,"Highlight the group of references"]
[null,"Right-click and choose Find Available PDFs"]
[null,"PDFs will appear next to records if found"]
[null,"Find where PDFs are stored on your computer by going to Edit > Preferences > Advanced > Files and Folders"]
[null,"You can search that folder for all PDFs if you want to copy them all to another location, or attach them to records in EndNote"]
[]
[null,"Use the Lookup Engines"]
[null,"Zotero comes with Google Scholar and CrossRef lookup engines"]
[null,"You can add your Library OpenURL resolver URL - Edit > Preferences > Advanced > General (check with your Library)"]
[null,"Highlight the references, then click the green arrow at the top right of the Library"]
[null,"This will open a series of results pages in your browser"]
[null,"You can then download the PDFs and attach to your Zotero or EndNote Library, or save to a folder"]
[null,"Installing a browser extension can make downloading the PDF easier - examples include Unpaywall, EndNote Click, and Mendeley"]
[]
[null,"Export as CSV to use in this spreadsheet"]
[null,"Either right-click an entire collection (if you have put all unmatched references into a collection), and choose Export Collection…"]
[null,"Or highlight selected references inside the collection (using ctrl or shift), and choose Export items... "]
[null,"In the dialog box that appears, select CSV format."]
[null,"Don't check the Export notes option."]
[null,"Save File: Click OK, select a location for this file, and click Save (note the location, so that you can find it later)."]
[null,"Return to Step 5 on the Instructions tab of this spreadsheet, and click the \"Import CSV\" button"]

{"sheet":"Imported","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"About","index":4,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"About"]
[]
[null,"Full Text Seeker.xlsm, version 1, 25.2.2024"]
[null,"The Full text seeker spreadsheet is designed to step researchers through the process of locating the full text documents needed for the full text screening stage in systematic type literature reviews."]
[null,"Useful when you have a large number (over 100) PDFs to find, It aims to help researchers exhaust the legal and accessible online options, before they fill out inter-library loan/document-supply requests"]
[null,"for items outside of their library subscriptions."]
[]
[null,"Possible modifications could include adding your own search engine strings to use with the Concatenate function. Or adapting the the logic as a free-standing application."]
[]
[]
[]
[]
[null,"Citing, credits, and licence"]
[]
[null,"Bruce, Tracy (2024). Full text seeker. Figshare. Online resource. https://doi.org/10.6084/m9.figshare.25273096"]
[]
[null,"Portions of VBA code on the Import CSV and Generate Links buttons created by Microsoft Copilot"]
[null,"Paper plane image created by Microsoft Designer (2024, February 23) using the prompt \"A clipart image of a paper plane with speed trails behind it\"."]
[]
[null,"Full text seeker © 2024 by Tracy Bruce is licensed under CC BY 4.0 "]

{"sheet":"Links","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}