Difference between revisions of "Export Search Result"
From IMSMA Wiki
m |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
*''Text Export'' – exports to a file in CSV format. This comma separated file may be opened with e.g. Excel. | *''Text Export'' – exports to a file in CSV format. This comma separated file may be opened with e.g. Excel. | ||
| − | {{Note | The file format CSV has its limitations. As an example non-Latin characters are not supported. }} | + | {{Note | The file format CSV has its limitations. As an example non-Latin characters are not supported. A possible workaround is to copy the rows from the Search Results window and paste them into Excel.}} |
{{Warning | When you open the CSV file 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'''. | ||
| Line 45: | Line 45: | ||
<li>Click the '''OK''' button.</li></ol> | <li>Click the '''OK''' button.</li></ol> | ||
| + | {{New_6.0 | The calculated column ''Linked IDs'' have been added in version 6.0. It is not possible to filter on but it is possible to include in the export. | ||
| + | It is possible to show the Country Structure as a string ''Country/Province/District/Subdistrict/Town'' or as separate columns.}} | ||
| + | |||
| + | [[Image:SearchResultsWindow.png|center|800px|''Search Results Window'']] | ||
| + | <div align="center"> | ||
| + | ''Search Results Window'' | ||
| + | </div> | ||
| + | |||
| + | The Country structure columns are found in the Location node. | ||
{{NavBox HowTo Search}} | {{NavBox HowTo Search}} | ||
| − | + | [[Category:NAA]] | |
| − | [[Category: | ||
Latest revision as of 22:05, 6 October 2016
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 an example non-Latin characters are not supported. A possible workaround is to copy the rows from the Search Results window and paste them into Excel. |
 |
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 workaround for this Excel behaviour is described here. |
To Export data from the selected row(s) to a file:
 Search Results Window The Country structure columns are found in the Location node.
|
|||||||||||||||||||||||||
