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
Revision as of 15:22, 9 February 2007 (edit) (undo)
Lorinda (Talk | contribs)
(Uncommenting jgd's revisions updating to Neo 2.0 process)
Next diff →
Line 2: Line 2:
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 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.
-From [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=14478#14478 this thread on trinity]:+<!-- Originally From [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=14478#14478 this thread on trinity] It has been adapted to work with NeoOffice 2.0-->
-===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 NeoO:
 +# download Address Book Exporter (donation ware) from [http://gwenhiver.net/applications/addressbookexporter/index.php this site].
 +#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 OK
 +#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.
-<!--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.+-->''Be aware: the file is encoded in " Apple Macintosh", so you have to change the default option Unicode UTF8 in "Your region (Apple Macintosh)"''.
- +#Choose {{prefName|Tab}} in the section {{section|Separated by}} then click {{button|OK}}.
-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.+#Your Address Book Data should now appear as a spreadsheet. Save this file.
- +#Then apply the instructions for [[Using a Calc spreadsheet as a data source]]
-When creating mailing labels the address data are now available. Most of the above steps can be automated by recording a macro.+
- +
-===Amayze===+
-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.+
{{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 15:22, 9 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.


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. Save this file.
  3. Then apply the instructions for Using a Calc spreadsheet as a data source



This article in other languages: Français
Personal tools