Export from ArcGIS to Excel - Revision history

Alnaucler at 13:59, 17 October 2014

2014-10-17T13:59:33Z

← Older revision		Revision as of 15:59, 17 October 2014
Line 1:		Line 1:
	When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format does not support UTF-16. The work-around is to copy from ArcMap to Excel which in ArcMap 9.3.1 was possible to do with keyboard shortcuts like Ctrl + A. In ArcMap 10.1 these keyboard shortcuts do not work in the Attribute table and therefore the menus must be used.		When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format does not support UTF-16. The work-around is to copy from ArcMap to Excel which in ArcMap 9.3.1 was possible to do with keyboard shortcuts like Ctrl + A. In ArcMap 10.1 these keyboard shortcuts do not work in the Attribute table and therefore the menus must be used.

	[[Image:UTF 16 dbf.png\|~~400~~]]		[[Image:UTF 16 dbf.png\|350px]]
	<div >		<div >
	''In the dbf-file the non-Latin characters are not readable''		''In the dbf-file the non-Latin characters are not readable''
Line 7:		Line 7:
	<br/>		<br/>
	# Open the Attribute table in ArcMap.		# Open the Attribute table in ArcMap.
	[[Image:UTF 16 attr table.png\|~~400px~~]]		[[Image:UTF 16 attr table.png\|350px]]
	<div >		<div >
	''In the Attribute table in ArcMap 10.1 the non-Latin characters looks OK''		''In the Attribute table in ArcMap 10.1 the non-Latin characters looks OK''

Dionysia at 11:30, 13 October 2014

2014-10-13T11:30:15Z

← Older revision		Revision as of 13:30, 13 October 2014
Line 20:		Line 20:
	''How the final result looks like''		''How the final result looks like''
	</div>		</div>
			</ol>

	{{NavBox Technical Notes}}		{{NavBox Technical Notes}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 17:55, 12 October 2014

2014-10-12T17:55:15Z

← Older revision		Revision as of 19:55, 12 October 2014
Line 1:		Line 1:
	When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format does not support UTF-16. The work-around is to copy from ArcMap to Excel.		When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format does not support UTF-16. The work-around is to copy from ArcMap to Excel which in ArcMap 9.3.1 was possible to do with keyboard shortcuts like Ctrl + A. In ArcMap 10.1 these keyboard shortcuts do not work in the Attribute table and therefore the menus must be used.

	[[Image:UTF 16 dbf.png\|400]]		[[Image:UTF 16 dbf.png\|400]]
Line 6:		Line 6:
	</div>		</div>
	<br/>		<br/>
	# Open the Attribute table in ArcMap		# Open the Attribute table in ArcMap.
	[[Image:UTF 16 attr table.png\|400px]]		[[Image:UTF 16 attr table.png\|400px]]
	<div >		<div >
Line 12:		Line 12:
	</div>		</div>
	<ol start="2">		<ol start="2">
	<li> Click on the Table ~~icon~~ and choose ''Select All'' in the menu <br/><br/>		<li> Click on the Table button and choose ''Select All'' in the drop-down menu. <br/><br/>
	[[Image:Table grab buttons.png\|400px]]		[[Image:Table grab buttons.png\|400px]]
	<li> Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the menu		<li> Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the drop-down menu.
	<li> Paste into an Excel file <br/>		<li> Paste into an Excel file <br/>
	[[Image:UTF 16 Excel.png\|400]]		[[Image:UTF 16 Excel.png\|400]]

Alnaucler at 14:51, 12 October 2014

2014-10-12T14:51:57Z

← Older revision		Revision as of 16:51, 12 October 2014
Line 1:		Line 1:
	~~{{Under construction\| Images missing}}~~
	When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format does not support UTF-16. The work-around is to copy from ArcMap to Excel.		When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format does not support UTF-16. The work-around is to copy from ArcMap to Excel.

	[[Image:UTF 16 dbf.png\|400]]		[[Image:UTF 16 dbf.png\|400]]
	<div >		<div >
	''~~How~~ the dbf-file ~~looks like~~''		''In the dbf-file the non-Latin characters are not readable''
	</div>		</div>
			<br/>
	# Open the Attribute table in ArcMap		# Open the Attribute table in ArcMap
	[[Image:UTF 16 attr table.png\|400px]]		[[Image:UTF 16 attr table.png\|400px]]
	<div >		<div >
	''~~How~~ the Attribute table in ArcMap 10.1 looks ~~like~~''		''In the Attribute table in ArcMap 10.1 the non-Latin characters looks OK''
	</div>		</div>
	# Click on the Table icon and choose ''Select All'' in the menu		<ol start="2">
			<li> Click on the Table icon and choose ''Select All'' in the menu <br/><br/>
	[[Image:Table grab buttons.png\|400px]]		[[Image:Table grab buttons.png\|400px]]
	<~~div~~>		<li> Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the menu
	~~''Table button and the grab handle''~~		<li> Paste into an Excel file <br/>
	~~</div>~~
	# Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the menu
	# Paste into an Excel file
	[[Image:UTF 16 Excel.png\|400]]		[[Image:UTF 16 Excel.png\|400]]
	<div >		<div >

Alnaucler at 14:45, 12 October 2014

2014-10-12T14:45:35Z

← Older revision		Revision as of 16:45, 12 October 2014
Line 8:		Line 8:

	# Open the Attribute table in ArcMap		# Open the Attribute table in ArcMap
	[[Image:~~xxx1~~.png\|400px]]		[[Image:UTF 16 attr table.png\|400px]]
	<div >		<div >
	''How the Attribute table in ArcMap 10.1 looks like''		''How the Attribute table in ArcMap 10.1 looks like''
	</div>		</div>
	# Click on the Table icon and choose ''Select All'' in the menu		# Click on the Table icon and choose ''Select All'' in the menu
	[[Image:~~xxx2~~.png\|400px]]		[[Image:Table grab buttons.png\|400px]]
	<div>		<div>
	''Table button and the grab handle''		''Table button and the grab handle''
Line 19:		Line 19:
	# Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the menu		# Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the menu
	# Paste into an Excel file		# Paste into an Excel file
	[[Image:~~xxx3~~.png\|400]]		[[Image:UTF 16 Excel.png\|400]]
	<div >		<div >
	''How the final result looks like''		''How the final result looks like''

Alnaucler at 13:50, 12 October 2014

2014-10-12T13:50:59Z

← Older revision		Revision as of 15:50, 12 October 2014
Line 19:		Line 19:
	# Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the menu		# Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the menu
	# Paste into an Excel file		# Paste into an Excel file
			[[Image:xxx3.png\|400]]
			<div >
			''How the final result looks like''
			</div>

	{{NavBox Technical Notes}}		{{NavBox Technical Notes}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 13:17, 12 October 2014

2014-10-12T13:17:35Z

← Older revision		Revision as of 15:17, 12 October 2014
Line 1:		Line 1:
	{{Under construction\| ~~Text should be placed here~~}}		{{Under construction\| Images missing}}
	When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format does not support UTF-16. The work-around is to copy from ArcMap to Excel.		When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format does not support UTF-16. The work-around is to copy from ArcMap to Excel.

	[[Image:UTF 16 dbf.png\|~~400px\|center~~]]		[[Image:UTF 16 dbf.png\|400]]
	<div ~~align="center"~~>		<div >
	''How the dbf-file looks like''		''How the dbf-file looks like''
	</div>		</div>

	# Open the Attribute table in ArcMap		# Open the Attribute table in ArcMap
	[[Image:xxx1.png\|400px~~\|center~~]]		[[Image:xxx1.png\|400px]]
	<div ~~align="center"~~>		<div >
	''How the Attribute table in ArcMap 10.1 looks like''		''How the Attribute table in ArcMap 10.1 looks like''
	</div>		</div>
	# Click on the Table icon and choose ''Select All'' in the menu		# Click on the Table icon and choose ''Select All'' in the menu
	[[Image:xxx2.png\|400px~~\|center~~]]		[[Image:xxx2.png\|400px]]
	<div ~~align="center"~~>		<div>
	''Table button and the grab handle''		''Table button and the grab handle''
	</div>		</div>

Alnaucler: Created page with "{{Under construction| Text should be placed here}} When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format d..."

2014-10-12T13:15:04Z

Created page with "{{Under construction| Text should be placed here}} When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format d..."

New page

{{Under construction| Text should be placed here}}
When the text fields are written with a non-Latin alphabet it is not possible to use the dbf-file because that file format does not support UTF-16. The work-around is to copy from ArcMap to Excel.

[[Image:UTF 16 dbf.png|400px|center]]
<div align="center">
''How the dbf-file looks like''
</div>

# Open the Attribute table in ArcMap
[[Image:xxx1.png|400px|center]]
<div align="center">
''How the Attribute table in ArcMap 10.1 looks like''
</div>
# Click on the Table icon and choose ''Select All'' in the menu
[[Image:xxx2.png|400px|center]]
<div align="center">
''Table button and the grab handle''
</div>
# Hold down ''Shift'', right-click on the first row's grab handle and choose ''Copy Selected'' in the menu
# Paste into an Excel file
{{NavBox Technical Notes}}
[[Category:NAA]]