Nested Knowledge

Bringing Systematic Review to Life

User Tools

Site Tools


wiki:autolit:admin:import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
wiki:autolit:admin:import [2023/10/11 12:19]
jthurnham [Format and Template]
wiki:autolit:admin:import [2024/04/01 12:12]
jthurnham
Line 1: Line 1:
 ====== Import Existing Screening Decisions or Tags ====== ====== Import Existing Screening Decisions or Tags ======
  
-This page addresses how to move existing review data, specifically screening & tagging, from spreadsheets into your nest.+This page addresses how to move existing review data, specifically screening & tagging, from spreadsheets into your nest. For video instructions, see T=2:37 in this video: 
 + 
 +{{youtube>RbIKMex7yPE}}
  
 ===== Where to Import ===== ===== Where to Import =====
Line 7: Line 9:
 Import can be found under [[:wiki:autolit:admin:configure|Settings]]. Import can be found under [[:wiki:autolit:admin:configure|Settings]].
  
-{{:wiki:autolit:admin:img23_2.png?nolink&  }}+{{ :undefined:screenshot_2024-04-01_at_13.09.03.png?nolink |}}
  
   * For **Screening**, see the "Import" section under Screening - select **"Begin"**  under "Upload Data"   * For **Screening**, see the "Import" section under Screening - select **"Begin"**  under "Upload Data"
Line 24: Line 26:
 ==== Format and Template ==== ==== Format and Template ====
  
-You can download the template from the Import Modal (see first red outline below):+You can download the template from the Import Modal:
  
-{{ :undefined:screenshot_2023-10-11_at_13.17.14.png?nolink |}}+{{ :undefined:screenshot_2024-04-01_at_13.10.15.png?nolink |}}
  
 The titles of your sheet must have the following **exact column names**: The titles of your sheet must have the following **exact column names**:
Line 33: Line 35:
   * Title   * Title
   * PubMed Id   * PubMed Id
-  * Ref Id+  * Ref Id (if applicable) 
 +  * External Id
   * Exclusion Reason   * Exclusion Reason
   * [Optional] Full Text Review   * [Optional] Full Text Review
Line 49: Line 52:
  
 In this sheet, the third record would be Included (with full text review) while the other three would have Exclusion Reasons added matching the text in that column. In this sheet, the third record would be Included (with full text review) while the other three would have Exclusion Reasons added matching the text in that column.
- 
  
 ==== Settings: Allow Exclusion Reason Creation ==== ==== Settings: Allow Exclusion Reason Creation ====
Line 71: Line 73:
 ==== Import Screening Decisions ==== ==== Import Screening Decisions ====
  
-Once you have **ensured that your import sheet is the proper format**, upload your sheet by drag-and-drop or by selecting the Upload button: {{:wiki:autolit:admin:img26.png?nolink&  }}+Once you have **ensured that your import sheet is the proper format**, upload your sheet by drag-and-drop or by selecting the Upload button.
  
 When complete, check your nest for the Screening Decisions you uploaded and to ensure that they were altered as you had planned. When complete, check your nest for the Screening Decisions you uploaded and to ensure that they were altered as you had planned.
Line 83: Line 85:
 ==== Format and Template ==== ==== Format and Template ====
  
-You can download the template from the Import Modal (see first red outline below): {{:wiki:autolit:admin:img27.png?nolink&  }}+You can download the template from the Import Modal (see first red outline below): 
 + 
 +{{  :undefined:screenshot_2023-10-11_at_13.20.08.png?nolink&  }}
  
 The titles of your sheet must have the following **exact column names**: The titles of your sheet must have the following **exact column names**:
  
-   * DOI+  * DOI
   * Title   * Title
   * PubMed Id   * PubMed Id
 +  * Ref Id (if applicable)
 +  * External Id
  
 Then, every column to the right of these **must be an exact Tag name**; the cells under the Tag Name will indicate whether that Tag should be added to the record in question with the text in the cell as the Tag Excerpt. Then, every column to the right of these **must be an exact Tag name**; the cells under the Tag Name will indicate whether that Tag should be added to the record in question with the text in the cell as the Tag Excerpt.
Line 95: Line 101:
 You must provide, in those columns: You must provide, in those columns:
  
-  * At least one bibliographic item (DOI, Title, or PubMed Id)+  * At least one bibliographic itemDOI, Title, PubMed Id and, if applicable, Ref Id
   * For all Tags to be applied to any record, the exact Tag name in the column header,   * For all Tags to be applied to any record, the exact Tag name in the column header,
   * For all records a Tag should be applied to, **fill in your desired Text Content**  in the cell. If the cell is left blank, **this indicates that the Tag in question should NOT be added to that record.**   * For all records a Tag should be applied to, **fill in your desired Text Content**  in the cell. If the cell is left blank, **this indicates that the Tag in question should NOT be added to that record.**
  
-See below for a correctly-filled-out example sheet:+See below for a correctly-filled-out example sheet (if using Ref ID, this would be an additional column):
  
 {{:wiki:autolit:admin:img28.png?nolink&  }} {{:wiki:autolit:admin:img28.png?nolink&  }}
  
 In this sheet, the first two records would have only one of the tags listed added to them; the last two records would have both tags added: "Study Type" and "Intervention." The text added to each tag is found in the corresponding cell for each record. In this sheet, the first two records would have only one of the tags listed added to them; the last two records would have both tags added: "Study Type" and "Intervention." The text added to each tag is found in the corresponding cell for each record.
- 
  
 ==== Settings: Allow Tag Creation ==== ==== Settings: Allow Tag Creation ====
Line 128: Line 133:
 ==== Import Tags ==== ==== Import Tags ====
  
-Once you have **ensured that your import sheet is the proper format**, upload your sheet by drag-and-drop or by selecting the Upload button+Once you have **ensured that your import sheet is the proper format**, upload your sheet by drag-and-drop or by selecting the Upload button.
- +
-{{:wiki:autolit:admin:img29.png?nolink&  }}+
  
 When complete, check your nest for the new Tags you uploaded and to ensure that they were altered as you had planned. When complete, check your nest for the new Tags you uploaded and to ensure that they were altered as you had planned.
  
  
wiki/autolit/admin/import.txt · Last modified: 2024/04/01 12:57 by jthurnham