Importing Data from Address Book

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 10:58, 9 February 2007 (edit)
Jgd (Talk | contribs)
(Glenner - translate French update in comments)
← Previous diff
Current revision (23:54, 22 December 2007) (edit) (undo)
Lorinda (Talk | contribs)
(Exporting Address Book Data - fix url for Address Book Exporter)
 
(11 intermediate revisions not shown.)
Line 1: Line 1:
{{fixme}} {{fixme}}
-Unfortunately, NeoOffice cannot directly use data from the Mac OS X Address Book at this time (although a [http://www.dashboardbuddha.com/OOo/specs/index.html specification] for implementing this functionality exists). However, it is still possible to use data from Address Book with NeoOffice.+Unfortunately, NeoOffice 2.1 and older cannot directly use data from the Mac OS X Address Book. However, it is still possible to use data from Address Book with NeoOffice.
-From [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=14478#14478 this thread on trinity]:+''Note that '''NeoOffice 2.2.1 EA includes support for reading the Mac OS X Address Book directly'''. See [[Accessing the Mac OS X Address Book]] for information on accessing the Mac OSX Address Book in NeoOffice 2.2.1.''
-===Glenner===+==Exporting Address Book Data==
-To export your system Address Book to NeoO download Address Book Exporter from http://gwenhiver.net/applications/addressbookexporter/index.php (donation ware). In Address Book Exporter select the Address Book group you wish to export. Select "Export using current field settings". Click on Configure Settings and select the fields you wish to export. Click "Export". This creates a file called Exported Address Book.txt.+To export your system Address Book to NeoOffice:
 +# download '''Address Book Exporter''' (donation ware) from [http://gwenhiver.net/ this site].
 +#Start '''Address Book Exporter'''
 +#In, '''Address Book Exporter''' select the '''Address Book''' group or groups you wish to export.
 +#Select {{prefName|Export using current field settings}}.
 +#Click on {{button|Configure Settings}} and select the fields you wish to export.
 +#Click {{button|OK}}
 +#Click on the '''Export Address Book''' icon.
 +#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 filename if you like, but it is important that the file extension remain <tt>.csv</tt>.)
-<!--Replace from "This create a file etc" above until the end by+==Setting Up the File as a Data Source==
-Then in the dialog which opens, change the format .txt for .csv. You'll get a file called "Exported Address Book.csv".+
-Open it in Neo. Be aware: the file is encoded in " Apple Macintosh", so you have to change the default option Unicode UTF8 in "Your region (Apple Macintosh)". (Maybe, it's irrelevant for English language?).+
-Choose {{prefName|Tab}} in the section {{section|Separated by}}  then click {{button|OK}}. +
-Then apply the instructions given in [[Using a Calc spreadsheet as a data source|the wiki]]-->+
-Open file in NeoO. Go Edit>Select all. Go to Tools>Text<->Table. In the opening window select the following options:+#Open this file in '''NeoOffice'''.
-Separate text at Tabs, Equal width for all columns, Header & Don't split table selected, Repeat Header & Border unselected. Press OK. This converts the data into a NeoO table. Select the first row of the table. Go Edit>Select all>Copy. Go to File>New>Spreadsheet and go Edit>Paste. Save as NeoO spreadsheet.+#: '''N.B.''': the file is encoded in one of the legacy “Apple Macintosh” character encodings, 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}} and then click {{button|OK}}.
 +#Your Address Book data should now appear as a spreadsheet.
 +#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 OpenDocument Spreadsheet format <tt>.ods</tt>.
-Go File>AutoPilot>Address Data Source. Select "Other external data source", click Next and click on Settings. In the General tab insert appropriate name, under Data base type select Spreadsheet, click radio button under Data source URL, navigate to the spreadsheet file you saved earlier, click Open>OK. Click on Field Assignment and associate the NeoO fields with the appropriate fields of the spreadsheet. In most cases the fields correlate to each other while other times a user-defined NeoO field may have to be used. Click OK and then Create. The AutoPilot confirms that data has now become available to NeoO. Click OK.+You now have two options for working with the data (both approaches may be used with the same file):
-When creating mailing labels the address data are now available. Most of the above steps can be automated by recording a macro.+===As a "Regular" Data Source===
-===Amayze===+''Using this method, the Address Book data is treated like any other database you have registered.''
-I'm not at a Mac I can test this on, but if you change the file extension to .csv NeoOffice should opening it using the spreadsheet. Change the delimiter from comma to tab in the import dialogue and then save it as a spreadsheet and jump straight to the third paragraph of Glenner's instructions.+
 +#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.)
-{{botlangbarEN|[[Fr:Importer_les_données_du_Carnet_d'adresses|Français]]}}+===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.
 + 
 +==References==
 +* Originally from [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=14478#14478 this thread on trinity]
 +* Revision for NeoOffice 2 in [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=3810 this thread]
 + 
 + 
 +{{botlangbarEN|[[Fr:Importer_les_données_du_Carnet_d'adresses|Français]] [[It:Importazione_dei_dati_da_Rubrica_Indirizzi|Italiano]]}}
[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]] [[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]]

Current revision

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

Unfortunately, NeoOffice 2.1 and older cannot directly use data from the Mac OS X Address Book. However, it is still possible to use data from Address Book with NeoOffice.

Note that NeoOffice 2.2.1 EA includes support for reading the Mac OS X Address Book directly. See Accessing the Mac OS X Address Book for information on accessing the Mac OSX Address Book in NeoOffice 2.2.1.

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 filename if you like, but it is important that the file extension remain .csv.)

Setting Up the File as a Data Source

  1. Open this file in NeoOffice.
    N.B.: the file is encoded in one of the legacy “Apple Macintosh” character encodings, so you have to change the default Character set option from Unicode UTF8 to Your region (Apple Macintosh). For example, Western Europe (Apple Macintosh).
  2. Choose Tab in the section Separated by and then click OK.
  3. Your Address Book data should now appear as a spreadsheet.
  4. Choose the File menu and then Save as.
  5. In the File Type drop-down of the Save dialog box, select the OpenDocument 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 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.

References



This article in other languages: Français Italiano
Personal tools