Difference between revisions of "Export Search Result"

From IMSMA Wiki
Jump to: navigation, search
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 and together with Excel has its limitations. For example:
+
{{Note | The file format CSV has its limitations. For example:
 
* non-Latin characters are not supported
 
* non-Latin characters are not supported
 
* data like ''1-10'' (beneficiaries) may be interpreted in Excel as '1st October''.
 
* data like ''1-10'' (beneficiaries) may be interpreted in Excel as '1st October''.

Revision as of 13:06, 24 March 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. For example:
  • non-Latin characters are not supported
  • data like 1-10 (beneficiaries) may be interpreted in Excel as '1st October.

Therefore check carefully the result in Excel before sharing the export result with others.

One possible workaround is to select all rows in the Search result, copy and paste into Excel.

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

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

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