Importing Data from Address Book

From NeoWiki

Revision as of 17:06, 9 February 2007 (edit) Jgd (Talk | contribs) (→Setting Up the File as a Data Source - a step was missing, sorry.) ← Previous diff		Revision as of 17:46, 9 February 2007 (edit) (undo) Lorinda (Talk | contribs) (just a little polish) Next diff →
Line 13:		Line 13:
	#Click OK		#Click OK
	#Click "Export Address Book".		#Click "Export Address Book".
-	#Then in the save dialog which opens, change the name of the file from "Exported Address Book.txt" to "Exported Address Book.csv" (You can change the name to the left of the dot if you like.	+	#Then in the save dialog which opens, change the name of the file from "Exported Address Book.txt" to "Exported Address Book.csv" (You can change the name to the left of the dot if you like.)
	==Setting Up the File as a Data Source==		==Setting Up the File as a Data Source==
Line 22:		Line 22:
	#Your Address Book Data should now appear as a spreadsheet.		#Your Address Book Data should now appear as a spreadsheet.
	#Choose the {{menu|File}} menu and the {{menu|Save as}}.		#Choose the {{menu|File}} menu and the {{menu|Save as}}.
-	#In the save dialog, select the Open Document Spreadsheet format <tt>.ods</tt>.	+	#In the {{prefName|File Type}} drop down of the {{Window|Save}} dialog box, select the Open Document Spreadsheet format <tt>.ods</tt>.
-	#Then apply the instructions for [[Using a Calc spreadsheet as a data source]]	+	#Then follow the instructions for [[Using a Calc spreadsheet as a data source]]
	{{botlangbarEN|[[Fr:Importer_les_données_du_Carnet_d'adresses|Français]]}}		{{botlangbarEN|[[Fr:Importer_les_données_du_Carnet_d'adresses|Français]]}}
	[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]		[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]

---

Revision as of 17:46, 9 February 2007

Unfortunately, NeoOffice cannot directly use data from the Mac OS X Address Book at this time (although a specification for implementing this functionality exists). However, it is still possible to use data from Address Book with NeoOffice.

Exporting Address Book Data

To export your system Address Book to NeoO:

1. download Address Book Exporter (donation ware) from this site.
2. In Address Book Exporter select the Address Book group you wish to export.
3. Select "Export using current field settings".
4. Click on Configure Settings and select the fields you wish to export.
5. Click OK
6. Click "Export Address Book".
7. Then in the save dialog which opens, change the name of the file from "Exported Address Book.txt" to "Exported Address Book.csv" (You can change the name to the left of the dot if you like.)

Setting Up the File as a Data Source

1. Open this file in NeoOffice.

-->Be aware: the file is encoded in " Apple Macintosh", so you have to change the default option Unicode UTF8 in "Your region (Apple Macintosh)".

1. Choose Tab in the section Separated by then click OK.
2. Your Address Book Data should now appear as a spreadsheet.
3. Choose the File menu and the Save as.
4. In the File Type drop down of the Save dialog box, select the Open Document Spreadsheet format .ods.
5. Then follow the instructions for Using a Calc spreadsheet as a data source