Export Search Result: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 4: Line 4:


{{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. }}
{|
|- valign="top"
|
{| class="wikitable"
|-
| [[Image:Csv Excel correct data type.png|250px|center]]
| [[Image:Csv Excel changed to date.png|250px|center]]
| [[Image:Csv Excel changed to date2.png|250px|center]]
|- align="center"
| ''How it should be''
| ''Excel transforms to Date''
| ''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'''.
{{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 [[Open CSV in Excel | here]].}}
Therefore check carefully the result in Excel before sharing the export result with others. A word around 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:

Revision as of 20:47, 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.
}}{{#if:|}}{{#if: Searching for Data in IMSMANG|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:|{{#if:Using IMSMANG{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=
How it should be Excel transforms to Date Result if you change to Text
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:

  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 button.
  3. The Export Options window displays.
Export Options Window
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

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. Export confirmation window
  5. The Export finished window displays.
  6. Click the OK button.
{{#switch:|subgroup|child=|none=|#default={{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:Using IMSMANG|}}}}{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:export search result
doc sandbox testcases = #default = {{#switch: plainlist hlist hlist hnum hlist vcard vcard hlist = #default =
 }}
}}
}}}}}}|{{#if:Using IMSMANG|
Searching for Data in IMSMANG doc sandbox testcases = #default = {{#switch: plainlist hlist hlist hnum hlist vcard vcard hlist = #default =
 }}
}}
}}}}}}

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:export search result doc sandbox testcases = #default = {{#switch: plainlist hlist hlist hnum hlist vcard vcard hlist = #default =

 }}
}}

}}}}}}|}}{{#if:|{{{group2}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list2}}}

}}{{#if:|{{#if:Using IMSMANG{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:export search result doc sandbox testcases = #default = {{#switch: plainlist hlist hlist hnum hlist vcard vcard hlist = #default =

 }}
}}

}}}}}}|}}{{#if:|{{{group3}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list3}}}

}}{{#if:|{{#if:|{{{group4}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list4}}}

}}{{#if:|{{#if:|{{{group5}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list5}}}

}}{{#if:|{{#if:|{{{group6}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list6}}}

}}{{#if:|{{#if:|{{{group7}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list7}}}

}}{{#if:|{{#if:|{{{group8}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list8}}}

}}{{#if:|{{#if:|{{{group9}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list9}}}

}}{{#if:|{{#if:|{{{group10}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list10}}}

}}{{#if:|{{#if:|{{{group11}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list11}}}

}}{{#if:|{{#if:|{{{group12}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list12}}}

}}{{#if:|{{#if:|{{{group13}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list13}}}

}}{{#if:|{{#if:|{{{group14}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list14}}}

}}{{#if:|{{#if:|{{{group15}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list15}}}

}}{{#if:|{{#if:|{{{group16}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list16}}}

}}{{#if:|{{#if:|{{{group17}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list17}}}

}}{{#if:|{{#if:|{{{group18}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list18}}}

}}{{#if:|{{#if:|{{{group19}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list19}}}

}}{{#if:|{{#if:|{{{group20}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list20}}}

}}{{#if:|{{#if:Using IMSMANG{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:export search result doc sandbox testcases = #default = {{#switch: plainlist hlist hlist hnum hlist vcard vcard hlist = #default =

 }}
}}

}}}}}}|}}

{{{below}}}

}}{{#switch:|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:export search result doc sandbox testcases = #default = {{#switch:hlist plainlist hlist hlist hnum hlist vcard vcard hlist = #default =
 }}
}}

}}}}}}