This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
wiki:autolit:extraction:export [2023/03/13 20:06] jthurnham [4. Add Columns] |
wiki:autolit:extraction:export [2023/11/30 15:34] jthurnham [Advanced Settings] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Exporting Tables ====== | + | ====== Exporting |
- | If you'd like to export your collected data into an Excel spreadsheet (CSV file), you can do so by either | + | If you'd like to export |
+ | |||
+ | <WRAP center round important 60%> | ||
+ | NOTE: Most Export functions have **moved to Inspector**. | ||
+ | |||
+ | Specifically, | ||
+ | </ | ||
+ | |||
+ | **Use this Export page for:** | ||
+ | * Custom Table Export and | ||
+ | * CER Builder. | ||
+ | |||
+ | **Use [[wiki: | ||
+ | * Study metadata (CSV or RIS Files) | ||
+ | * Screening decisions | ||
+ | * Tags & Tag Contents | ||
+ | * Extracted | ||
+ | * Critical Appraisal | ||
+ | * All Full Text PDFs | ||
- | Risk of Bias is exported separately from Tagging and Extraction. | ||
===== Custom Table Export ===== | ===== Custom Table Export ===== | ||
Line 19: | Line 36: | ||
Under Synthesis, click " | Under Synthesis, click " | ||
- | {{:wiki:autolit: | + | {{ :undefined:customcer.png? |
It should already be opened to Custom Tables; if you navigate away, click the " | It should already be opened to Custom Tables; if you navigate away, click the " | ||
Line 28: | Line 45: | ||
Click on the drop-down menu under "Table of" in order to choose whether you would like a table showing elements from the study as a whole, the various study arms in each study (placebo, intervention groups, etc.), or across all interventions. | Click on the drop-down menu under "Table of" in order to choose whether you would like a table showing elements from the study as a whole, the various study arms in each study (placebo, intervention groups, etc.), or across all interventions. | ||
- | {{:wiki:autolit: | + | {{ :undefined:studyarm.png? |
**Note** that if you want to be able to export/ | **Note** that if you want to be able to export/ | ||
Line 93: | Line 110: | ||
{{ https:// | {{ https:// | ||
- | ==== 5. Reorder Columns ==== | + | === Including Tag Tables |
- | If you wish to change | + | If you have configured and extracted data in tag tables, you can add individual tags to your custom table or add all table contents. To do so, under the columns |
- | {{ :wiki:autolit: | + | {{ :undefined:screenshot_2023-10-02_at_16.18.23.png?nolink |}} |
- | {{ : | + | Or select "All Table Contents" |
- | ===== CER-specific Exports ===== | + | {{ : |
- | Nested Knowledge offers export | + | When multiple tables are added, NK attempts to join columns that share similar names to reduce duplicate columns. In the below example, both the Age and Sex tables had a column for " |
- | ==== Accessing the CER Export page ==== | + | {{ : |
- | To access the CER Export page, select Export from the AutoLit menu, and then in the resulting page, toggle to "CER Builder." | + | If this is incorrect, you can manually unjoin them by clicking |
- | {{:wiki:autolit: | + | {{ :undefined:screenshot_2023-10-02_at_16.28.38.png? |
+ | ==== 5. Reorder Columns ==== | ||
- | ==== Exporting Documents | + | If you wish to change the order of columns presented, simply drag and drop the column pills: |
- | In the CER Builder, you have the options of exporting your Literature Search or your Screening activities. | + | {{ : |
- | === 1. Literature Search Export === | + | The column order will change accordingly. |
- | To export a record of the Search Engines you used, alongside specific queries used, the number of total records returned, duplicates found and the number included and excluded from each search (as well as all studies that were [[: | + | {{ : |
- | Then, choose whether to export as a .docx or a .csv, and select " | + | ==== Advanced Settings ==== |
- | {{: | + | Once you start customizing your table, you can also toggle with the advanced setting. |
- | === 2. Screening Export === | + | {{ : |
- | To export a record of all studies Screened in your nest, with full citation information and links to full texts, as well as the Screening status and (if excluded) the Exclusion Reason, select " | + | By default, when you add multiple tag columns |
- | {{:wiki:autolit: | + | {{ :undefined:screenshot_2023-11-30_at_15.27.38.png? |
- | Then, choose whether to export as a .docx or a .csv, and select " | + | === Multiple Tag Columns === |
- | {{: | + | See below for an example of tags organized under separate root tags. Specifically, |
+ | {{ : | ||
- | ===== Export All Data ===== | + | If you were to add both these tags as columns in your custom table... |
- | Use Export All Data if you want to obtain a Study Arm-level spreadsheet containing the bibliographic data, Interventions, | + | {{ : |
- | ==== 1. Navigate | + | ...the export will separate their data into separate sheets within your workbook |
- | On the Nest menu, click " | + | Sheet 1: |
- | ---- | + | {{ : |
- | ==== 2. Toggle " | + | Sheet 2: |
- | At the top of the page, toggle to " | + | {{ : |
- | {{:wiki: | + | However, unchecking advanced settings ensures all data is encompassed within one sheet in your workbook: |
- | === Choose Included-Only? === | + | {{ : |
- | For this option, | + | **When your table is customized with the settings of your choice, click Download.** |
+ | ===== CER-specific Exports ===== | ||
- | If you export | + | Nested Knowledge offers |
- | ---- | + | ==== Accessing the CER Export page ==== |
+ | To access the CER Export page, select Export from the AutoLit menu, and then in the resulting page, toggle to "CER Builder." | ||
- | ==== 3. Click " | + | {{ : |
- | Click on the " | + | ==== Exporting Documents and Data ==== |
- | Keep in mind that all data elements are broken out by their constituent parts (e.g. Mean, SD, N) into separate columns and are separated by timepoint. Rows in the spreadsheet will correspond to the various study arms. | + | In the CER Builder, you have the options of exporting your Literature Search or your Screening activities. |
+ | === 1. Literature Search Export === | ||
- | ===== Exporting Risk of Bias ===== | + | To export a record |
- | Risk of Bias outputs | + | Then, choose whether to export as a .docx or a .csv, and select " |
+ | |||
+ | {{:wiki:autolit:admin: | ||
+ | |||
+ | === 2. Screening Export === | ||
+ | |||
+ | To export a record | ||
+ | |||
+ | {{:wiki: | ||
+ | |||
+ | Then, choose whether to export as a .docx or a .csv, and select " | ||
+ | |||
+ | {{: | ||
- | - Navigate to the Export page | ||
- | - Toggle to " | ||
- | - Choose whether to export Included-only (default) or all studies | ||
- | - If your Risk of Bias was assessed at the Data Element level, select which Data Element(s) to export. If your Risk of Bias was study-level (as in the visual below), this option will be greyed out. | ||
- | - When ready, select " | ||
- | {{: | + | ===== Export All Data or Export RIS Files ===== |
+ | These functions have been moved to [[wiki: | ||