Importing Data from Address Book

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 03:44, 10 February 2007 (edit)
Lorinda (Talk | contribs)
(→Exporting Address Book Data - polish; button etc. templates)
← Previous diff		 Revision as of 04:18, 10 February 2007 (edit) (undo)
Lorinda (Talk | contribs)
(→Setting Up the File as a Data Source - polish and menu templates)
Next diff →
Line 18: Line 18:
==Setting Up the File as a Data Source== ==Setting Up the File as a Data Source==
-#Open this file in NeoOffice. +#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)"''. +-->''Be aware: the file is encoded in " Apple Macintosh", so you have to change the default {{prefName|Character set}} option from '''Unicode UTF8''' to '''''Your region'' (Apple Macintosh)'''. For example, '''Western Europe (Apple Macintosh)'''
#Choose {{prefName|Tab}} in the section {{section|Separated by}} then click {{button|OK}}. #Choose {{prefName|Tab}} in the section {{section|Separated by}} then click {{button|OK}}.
#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 then {{menu|Save as}}.
#In the {{prefName|File Type}} drop down of the {{Window|Save}} dialog box, 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>.
You now have two options for working with the data (both approaches may be used with the same file) You now have two options for working with the data (both approaches may be used with the same file)
-Option 1:+===As a "Regular" Data Source===
-Begin by following the instructions for [[Using a Calc spreadsheet as a data source]]+
-Open a document in writer and set up the page style as you would like (e.g. for an envelope)+
-Under the View menu, choose "Data Sources" a new "split window" appears at the top of your document.+
-Choose the database and "Table" you want+
-You can then drag either field names or particular entries into the correct location+
-(You can also go to the Insert Menu, Choose "Fields," and then the "Database Tab," choose your database and insert fields that way.+
-Option 2:+''Using this method, the Address Book data is treated like any other database you have registered.''
-Under the File Menu, go to Wizards, then Address Data Source+
-Follow the instructions in the wizard to identify your Address Data (make sure to set the connection type to "spreadsheet"+
-You will also be asked to make field assignments+
-Then you should be able to use Insert>Envelope+
-In that dialog, you can select your database, and then enter the fields one by one. +
 +#Begin by following the instructions for [[Using a Calc spreadsheet as a data source]]
 +#Open a document in writer and set up the page style as you would like (e.g. for an envelope)
 +#Under the View menu, choose "Data Sources" a new "split window" appears at the top of your document.
 +#Choose the database and Table you want
 +#You can then drag either field names or particular entries into the correct location
 +(You can also go to the {{menu|Insert}} menu, Choose {{menu|Fields}} click on the {{section|Database}} Tab, choose your database, and insert fields from this dialog box.)
 +
 +===As a "System Address Book"===
 +
 +#Under the {{menu|File}} Menu, go to [[menu|Wizards}}, then {{menu|Address Data Source.}}
 +#Follow the instructions in the wizard to identify your Address Data (make sure to set the connection type to '''spreadsheet''')
 +#You will also be asked to make field assignments
{{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 04:18, 10 February 2007

This article is not up to date, or it needs structural or stylistic changes to conform with the rest of this wiki.

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.


Contents

Exporting Address Book Data

To export your system Address Book to NeoOffice:

  1. download Address Book Exporter (donation ware) from this site.
  2. Start Address Book Exporter
  3. In, Address Book Exporter select the Address Book group or groups you wish to export.
  4. Select Export using current field settings.
  5. Click on Configure Settings and select the fields you wish to export.
  6. Click OK
  7. Click on the Export Address Book icon.
  8. 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 Character set option from Unicode UTF8 to Your region (Apple Macintosh). For example, Western Europe (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 then Save as.
  4. In the File Type drop down of the Save dialog box, select the Open Document Spreadsheet format .ods.

You now have two options for working with the data (both approaches may be used with the same file)

As a "Regular" Data Source

Using this method, the Address Book data is treated like any other database you have registered.

  1. Begin by following the instructions for Using a Calc spreadsheet as a data source
  2. Open a document in writer and set up the page style as you would like (e.g. for an envelope)
  3. Under the View menu, choose "Data Sources" a new "split window" appears at the top of your document.
  4. Choose the database and Table you want
  5. You can then drag either field names or particular entries into the correct location

(You can also go to the Insert menu, Choose Fields click on the Database Tab, choose your database, and insert fields from this dialog box.)

As a "System Address Book"

  1. Under the File Menu, go to [[menu|Wizards}}, then Address Data Source.
  2. Follow the instructions in the wizard to identify your Address Data (make sure to set the connection type to spreadsheet)
  3. You will also be asked to make field assignments



This article in other languages: Français
Retrieved from "https://neowiki.neooffice.org/index.php/Importing_Data_from_Address_Book"
Personal tools