This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
wiki:autolit:search:import [2023/11/02 12:08] jthurnham [Spreadsheet-based Upload of Studies] |
wiki:autolit:search:import [2024/05/29 16:25] jthurnham [Custom Bibliographic Fields in Spreadsheets:] |
||
---|---|---|---|
Line 32: | Line 32: | ||
* In the modal that appears, select "File Import" | * In the modal that appears, select "File Import" | ||
- | {{:wiki:autolit: | + | {{ :undefined:screenshot_2024-05-17_at_16.43.51.png? |
* If your RIS File resulted from a search on an index, enter the full query you used and identify the Search Engine/ | * If your RIS File resulted from a search on an index, enter the full query you used and identify the Search Engine/ | ||
Line 94: | Line 94: | ||
===== Spreadsheet-based Upload of Studies ===== | ===== Spreadsheet-based Upload of Studies ===== | ||
- | You can also bulk upload studies via a spreadsheet. For accurate data retrieval, there must be a column for DOI, PMID or PubMed ID. Ideally | + | You can also bulk upload studies via a spreadsheet. For basic import, at minimum |
- | {{ : | + | {{youtube> |
- | Once your spreadsheet is formatted correctly, you go to File Import and select your spreadsheet under Import Search. Then you must add an applicable query in order for the Add button to be enabled. Then click Add to add the studies to your nest. | ||
- | {{ : | + | ==== Using DOI or PubMed ID, with automatically sourced bibliographic data: ==== |
+ | |||
+ | If your spreadsheet contains only DOI and/or PMID/PubMed ID, records and bibliographic data are imported from PubMed and CrossRef. While this generation of bibliographic data is accurate, there may be gaps. Method 2 ensures import of all desired data from an existing spreadsheet. | ||
+ | |||
+ | e.g. {{ : | ||
+ | |||
+ | ==== Custom Bibliographic Fields in Spreadsheets: | ||
+ | |||
+ | If your spreadsheet contains columns for DOI, PMID/PubMed ID //plus other additional columns//, i.e. Title, Year, First Author/ | ||
+ | |||
+ | While this means any missing data within the spreadsheet will not be retrieved via PubMed/ | ||
+ | |||
+ | e.g. {{ : | ||
+ | |||
+ | You may download the above template for reference when attempting to upload your file. Once your spreadsheet is formatted for your chosen method of import, go to File Import and select your spreadsheet under Import Search. Then click Add to add the studies to your nest. | ||
+ | |||
+ | {{ : | ||
This search will be added to the top of existing searches as below: | This search will be added to the top of existing searches as below: | ||
- | {{ :undefined:queryquery2.png? | + | {{ :undefined:screenshot_2023-11-02_at_12.44.05.png? |