| Both sides previous revision Previous revision | |
| rdms:webapp:search [2024/11/15 12:24] – burcu | rdms:webapp:search [2024/11/15 12:29] (current) – burcu |
|---|
| {{ :rdms:webapp:rdms_report_new_1.png?direct&400 |}} | {{ :rdms:webapp:rdms_report_new_1.png?direct&400 |}} |
| |
| After confirmation, you can find your report by selecting the report button ({{:rdms:webapp:rdms_report_button.png?direct&25|}}) from the left navigation bar. From within the report view, you can now select to either create your final report in csv format, view/download the JSON files containing your search results/parameters, or to delete one or more reports. | After confirmation, you can find your report by selecting the report button ({{:rdms:webapp:rdms_report_button.png?direct&25|}}) from the left navigation bar. From within the report view, you can now select to either create your final report in CSV format, view/download the JSON files containing your search results/parameters, or to delete one or more reports. |
| |
| {{ :rdms:webapp:rdms_report_new_2.png?direct&800 |}} | {{ :rdms:webapp:rdms_report_new_2.png?direct&800 |}} |
| {{ :rdms:webapp:rdms_report_new_3.png?direct&600 |}} | {{ :rdms:webapp:rdms_report_new_3.png?direct&600 |}} |
| |
| After confirmation, you can download your report in csv format from the specified RDMS location. | After confirmation, you can download your report in CSV format from the specified RDMS location. |
| |
| {{ :rdms:webapp:rdms_report_6.png?direct&800 |}} | {{ :rdms:webapp:rdms_report_6.png?direct&800 |}} |
| === Using Export Search Results As Function === | === Using Export Search Results As Function === |
| |
| The "Export search results as..." function allows you to directly create an exportable csv from your search results. If you select this option from the search view, you will be asked where your exportable csv should be saved. Afterwards, you are asked to select the export type (data, metadata and/or permissions), and to specify a name for your export (a default value is automatically filled in). | The "Export search results as..." function allows you to directly create an exportable CSV from your search results. If you select this option from the search view, you will be asked where your exportable CSV should be saved. Afterwards, you are asked to select the export type (data, metadata and/or permissions), and to specify a name for your export (a default value is automatically filled in). |
| |
| {{ :rdms:webapp:rdms_report_new_4.png?direct&500 |}} | {{ :rdms:webapp:rdms_report_new_4.png?direct&500 |}} |
| |
| Afterwards, you can download your report in csv format from the selected RDMS location. | Afterwards, you can download your report in CSV format from the selected RDMS location. |
| |
| **Notes**: | **Notes**: |
| * The "Export search results as..." function is **a shortcut way** to generate an exportable csv of your search results, and as such, **it does not allow you to directly select which metadata to extract** if metadata is included in your report. Instead all metadata is exported by default. | * The "Export search results as..." function is **a shortcut way** to generate an exportable CSV of your search results, and as such, **it does not allow you to directly select which metadata to extract** if metadata is included in your report. Instead all metadata is exported by default. |
| * Choosing the "Export search results as..." function will also create JSON files in the background. These files contain your search results and parameters. You can access them via the report button ({{:rdms:webapp:rdms_report_button.png?direct&25|}}) in the left navigation bar. By doing so, you can create further reports from these intermediate JSON files, and you can fine-tune the export parameters (e.g. which metadata to include in the csv). | * Choosing the "Export search results as..." function will also create JSON files in the background. These files contain your search results and parameters. You can access them via the report button ({{:rdms:webapp:rdms_report_button.png?direct&25|}}) in the left navigation bar. By doing so, you can create further reports from these intermediate JSON files, and you can fine-tune the export parameters (e.g. which metadata to include in the CSV). |
| * The "Export search results as..." will automatically use encryption for the intermediate JSON files that are created. | * The "Export search results as..." will automatically use encryption for the intermediate JSON files that are created. |
| |
| === Importing Report Files in Spreadsheet Tools === | === Importing Report Files in Spreadsheet Tools === |
| |
| The exported csv reports can be important in spreadsheet tools (e.g. MS Excel, LibreOffice) for visualization and further processing. | The exported CSV reports can be important in spreadsheet tools (e.g. MS Excel, LibreOffice) for visualization and further processing. |
| | |
| It is important to note that the csv reports in the RDMS use **tab as field delimiter**! | It is important to note that the CSV reports in the RDMS use **tab as field delimiter**! |
| |
| Please be sure that you select this during import in your spreadsheet tool as it will otherwise break the formatting of your import. | Please be sure that you select this during import in your spreadsheet tool as it will otherwise break the formatting of your import. |
| |
| Also note that RDMS metadata fields can be multi-line fields. In cases where this causes problem when exporting the csv to another tool and where it is desired for other reasons, it is possible to automatically replace newlines in the exported csv. To do so, simply select a replace character during report creation. | Also note that RDMS metadata fields can be multi-line fields. In cases where this causes problem when exporting the CSV to another tool and where it is desired for other reasons, it is possible to automatically replace newlines in the exported CSV. To do so, simply select a replace character during report creation. |
| |
| |