Export Search Result - Revision history

Alnaucler at 21:05, 6 October 2016

2016-10-06T21:05:27Z

← Older revision		Revision as of 23:05, 6 October 2016
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.		{{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.}}		It is possible to show the Country Structure as a string ''Country/Province/District/Subdistrict/Town'' or as separate columns.}}

Alnaucler at 13:41, 22 September 2016

2016-09-22T13:41:50Z

← Older revision		Revision as of 15:41, 22 September 2016
Line 48:		Line 48:
	It is possible to show the Country Structure as a string ''Country/Province/District/Subdistrict/Town'' or as separate columns.}}		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:NAA]]

Alnaucler at 15:39, 21 September 2016

2016-09-21T15:39:18Z

← Older revision		Revision as of 17:39, 21 September 2016
Line 44:		Line 44:
	<li>The Export finished window displays.</li>		<li>The Export finished window displays.</li>
	<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 possible to show the Country Structure as a string ''Country/Province/District/Subdistrict/Town'' or as separate columns.}}

	{{NavBox HowTo Search}}		{{NavBox HowTo Search}}
			[[Category:NAA]]
	[[Category:~~COO~~]]

Alnaucler at 15:28, 21 September 2016

2016-09-21T15:28:58Z

← Older revision		Revision as of 17:28, 21 September 2016
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'''.

Dionysia at 11:12, 7 April 2015

2015-04-07T11:12:13Z

← Older revision		Revision as of 13:12, 7 April 2015
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]]

Dionysia at 11:10, 7 April 2015

2015-04-07T11:10:03Z

← Older revision		Revision as of 13:10, 7 April 2015
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 example is non-Latin characters are not supported. }}		{{Note \| The file format CSV has its limitations. As an example non-Latin characters are not supported. }}

	{\|		{\|

Alnaucler at 19:51, 5 April 2015

2015-04-05T19:51:54Z

← Older revision		Revision as of 21:51, 5 April 2015
Line 20:		Line 20:

	{{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 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:

Alnaucler at 19:47, 5 April 2015

2015-04-05T19:47:18Z

← Older revision		Revision as of 21:47, 5 April 2015
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:

Alnaucler at 12:06, 5 April 2015

2015-04-05T12:06:54Z

← Older revision		Revision as of 14:06, 5 April 2015
Line 6:		Line 6:

	{{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 [[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:

Alnaucler at 12:04, 5 April 2015

2015-04-05T12:04:29Z

← Older revision		Revision as of 14:04, 5 April 2015
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]].}}