Difference between revisions of "Export Search Result"
From IMSMA Wiki
Line 5: | Line 5: | ||
{{Note | The file format CSV has its limitations. As example is non-Latin characters are not supported. }} | {{Note | The file format CSV has its limitations. As example is non-Latin characters are not supported. }} | ||
− | {{Warning | When you open the CSV in Excel, Excel will automatically interpret data like '''1-10''' as '''10-Jan'''. | + | {{Warning | When you open the CSV file in Excel, Excel will automatically interpret data like '''1-10''' as '''10-Jan'''. |
Therefore check carefully the result in Excel before sharing the export result with others. A word around for this Excel behaviour is described [[here]].}} | Therefore check carefully the result in Excel before sharing the export result with others. A word around for this Excel behaviour is described [[here]].}} | ||
Revision as of 13:04, 5 April 2015
Depending on your Search Target, then search result may be exported in two different formats:
- XML Export – exports to a file in XML format.
- Text Export – exports to a file in CSV format. This comma separated file may be opened with e.g. Excel.
The file format CSV has its limitations. As example is non-Latin characters are not supported. |
When you open the CSV file in Excel, Excel will automatically interpret data like 1-10 as 10-Jan.
Therefore check carefully the result in Excel before sharing the export result with others. A word around for this Excel behaviour is described here. |
To Export data from the selected row(s) to a file:
- Select the row(s) that you would like to export to a file. If you do not select any row(s) all rows will be exported.
- Click the button.
- The Export Options window displays.
Export Options Window
- If you select the Text Export option, you can select the columns that you would like to include in the export file.
Export Options Window – Text Export
- Click the OK button.
- Specify the directory to which you would like to export the file and the name of the file.
- Click the Save button.
- The Export finished window displays.
- Click the OK button.
Export confirmation window
|