Difference between revisions of "Export Search Result"

From IMSMA Wiki
Jump to: navigation, search
m
m
Line 4: Line 4:
  
 
{{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. }}
 +
 +
{{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 workaround for this Excel behaviour is described '''[[Open CSV in Excel | here]]'''.}}
  
 
{|
 
{|
Line 18: Line 21:
 
| ''Result if you change to Text''
 
| ''Result if you change to Text''
 
|}
 
|}
 
{{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 workaround for this Excel behaviour is described '''[[Open CSV in Excel | here]]'''.}}
 
  
 
To Export data from the selected row(s) to a file:
 
To Export data from the selected row(s) to a file:
<ol>
+
<ol><li>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.</li>
<li>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.</li>
 
 
<li>Click the [[Image:FieldReportExportIcon.png]] button.</li>
 
<li>Click the [[Image:FieldReportExportIcon.png]] button.</li>
<li>The Export Options window displays.</li>
+
<li>The Export Options window displays.
</ol>
 
  
 
[[Image:ExportOptionsWindow.png|500px|center|''Export Options Window'']]
 
[[Image:ExportOptionsWindow.png|500px|center|''Export Options Window'']]
 
<div align="center">
 
<div align="center">
 
''Export Options Window''
 
''Export Options Window''
</div>
+
</div></li>
 
 
<ol start="4">
 
 
<li>If you select the Text Export option, you can select the columns that you would like to include in the export file.
 
<li>If you select the Text Export option, you can select the columns that you would like to include in the export file.
</ol>
 
  
 
[[Image:ExportOptionsWindowTextExport.png|center|600px|''Export Options Window – Text Export'']]
 
[[Image:ExportOptionsWindowTextExport.png|center|600px|''Export Options Window – Text Export'']]
 
<div align="center">
 
<div align="center">
 
''Export Options Window – Text Export''
 
''Export Options Window – Text Export''
</div>
+
</div></li>
 
 
<ol start="4">
 
 
<li>Click the '''OK''' button.</li>
 
<li>Click the '''OK''' button.</li>
 
<li>Specify the directory to which you would like to export the file and the name of the file.</li>
 
<li>Specify the directory to which you would like to export the file and the name of the file.</li>
<li>Click the '''Save''' button.</li>
+
<li>Click the '''Save''' button.
 
[[Image:Xml Export confirm.png|500px|center]]
 
[[Image:Xml Export confirm.png|500px|center]]
<div align="center"> '' Export confirmation window''</div>
+
<div align="center"> '' Export confirmation window''</div></li>
 
<li>The Export finished window displays.</li>
 
<li>The Export finished window displays.</li>
<li>Click the '''OK''' button.</li>
+
<li>Click the '''OK''' button.</li></ol>
</ol>
 
  
 
{{NavBox HowTo Search}}
 
{{NavBox HowTo Search}}
  
 
[[Category:COO]]
 
[[Category:COO]]

Revision as of 12:12, 7 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.
Note.jpg The file format CSV has its limitations. As an example non-Latin characters are not supported.
Warning.jpg 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.

Csv Excel correct data type.png
Csv Excel changed to date.png
Csv Excel changed to date2.png
How it should be Excel transforms to Date Result if you change to Text

To Export data from the selected row(s) to a file:

  1. 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.
  2. Click the FieldReportExportIcon.png button.
  3. The Export Options window displays.
    Export Options Window

    Export Options Window

  4. 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

    Export Options Window – Text Export

  5. Click the OK button.
  6. Specify the directory to which you would like to export the file and the name of the file.
  7. Click the Save button.
    Xml Export confirm.png
    Export confirmation window
  8. The Export finished window displays.
  9. Click the OK button.