| View previous topic :: View next topic |
| Author |
Message |
Leopold
Guest
|
 Posted: Sun Apr 10, 2005 2:42 pm Post subject: How to use AddressBook (OS X) with Neooffice ? |
|
Hello,
How is it possible to use AddressBook with Neooffice ?
Is it dBase, mySQL, JDBC, ODBC, Text, Classeur ?
I tryed with "Classeur" and choosed addressbook.data (in /Users/myname/Library/Application Support/Addressbook/addressbook.data, but after I have an error about name and password. I don't know what I must do to make a connection between my Addressbook and Neooffice.
Thanks.
Leo |
|
| Back to top |
|
 |
Guest
|
| Posted: Sat Jul 30, 2005 9:50 am Post subject: I have the same question as Leopold |
|
| Unfortunately, NeoOffice doesn't parse data within cells. For example, Excel has a function called text to column. As a last resort I want to try importing fields from Addressbook to NeoOffice. |
|
| Back to top |
|
|
sardisson
Town Crier
Joined: Feb 01, 2004
Posts: 4588
|
| Posted: Sat Jul 30, 2005 2:39 pm Post subject: |
|
Ed wrote a spec for Address Book support, but no one's come forth to run with it in the past two years 
Max mentioned offhand in the thread from which this topic was split that he had posted a work-around years ago on OOoDocs. I think this is it.
Smokey
_________________
"[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki |
|
| Back to top |
|
|
Glenner
Oracle
Joined: Feb 03, 2004
Posts: 241
Location: Scotland
|
| Posted: Sun Jul 31, 2005 7:21 am Post subject: |
|
| I use Address Book Exporter (do a search on Versiontracker) to export the data in txt format and then import this into a speadsheet or table. However, this is a static version and the whole process has to be repeated after every change to the address data. |
|
| Back to top |
|
|
Guest
Guest
|
| Posted: Mon Sep 26, 2005 2:54 pm Post subject: address book export |
|
Tried the export version with txt file and it worked like a charm  . Only one problem, Im from Sweden and we have those pesky letters with dots... When I set up the data source it seems that the åäö got converted. Is there a solution to this or some setting I missed? |
|
| Back to top |
|
|
OPENSTEP
The One
Joined: May 25, 2003
Posts: 4752
Location: Santa Barbara, CA
|
| Posted: Mon Sep 26, 2005 6:23 pm Post subject: |
|
Do you know if that text exporter can export UTF-8 or other encoded text? A regular ASCII .txt export might not be able to capture all of the accent marks correctly.
ed |
|
| Back to top |
|
|
Max_Barel
Oracle
Joined: May 31, 2003
Posts: 219
Location: French Alps
|
| Posted: Tue Sep 27, 2005 2:40 am Post subject: |
|
| OPENSTEP wrote: | | Do you know if that text exporter can export UTF-8 or other encoded text? A regular ASCII .txt export might not be able to capture all of the accent marks correctly. |
Quoted from my original thread on OOodocs : | Quote: | Text file exported with AddressBookExporter is encoded with a charset which adapt automatically to the characters used in AddressBook contacts. If there are only simple latin accented chars, it default to MacOSRoman. If there are other more complicated chars it use Unicode and more precisely UTF-16. This is a standard Cocoa frameworks feature. It is easy to convert from UTF-16 to UTF-8 with TextEdit.
Problem arise when importing this file in OO since the text format database dialog do NOT offer the UTF-8 charset as a choice. This choice IS present in the JDBC and ODBC database dialogs. The "system" item defaults to IsoLatin1 as I already noticed in an other thread. |
So you must open the text file in TextEdit and "Save As" with latin-1 charset before importing in Neo/J.
The problem case is for characters which does not translate in latin-1. If there is such in swedish you are out of luck. I had to avoid exporting some AddresBook items which are using Romanian chars (latin-2) for exemple.
Max |
|
| Back to top |
|
|
tomsteg
Red Pill
Joined: Oct 25, 2005
Posts: 9
|
| Posted: Thu Jun 08, 2006 9:05 am Post subject: an easy solution |
|
| Click on the field next to the address, you want to export, in addressbook and choose copy. The address with name and company is copied to the clipboard. In neooffice you paste the address with apple v. Thats it. |
|
| Back to top |
|
|
Samwise
Captain Naiobi
Joined: Apr 25, 2006
Posts: 2315
Location: Montpellier, France
|
| Posted: Thu Jun 08, 2006 9:22 am Post subject: |
|
| Quote: | | I use Address Book Exporter (do a search on Versiontracker) to export the data in txt format and then import this into a speadsheet or table. However, this is a static version and the whole process has to be repeated after every change to the address data. |
It might be possible to create an AppleScript or Automator action to automate the process ... maybe I can even figure out a way myself, if I can find enough time and courage; I wonder where I could find some of that Sam Adams summer ale here in Geneva |
|
| Back to top |
|
|
Samwise
Captain Naiobi
Joined: Apr 25, 2006
Posts: 2315
Location: Montpellier, France
|
| Posted: Thu Jun 08, 2006 10:37 am Post subject: |
|
I'm not making much progress with Automator. I can have my workflow launch/make active NeoOffice, get contact information from Address Book and export it as formatted text (with labels) or unformatted "Spreadsheet (tabs)" text (w/out labels), then copy it to clipboard; but I have no action to have it paste the text into NeoOffice.
Moreover, when I try to paste manually, I get the following error message (from Neo) : requested clipboard format is not available. And no summer ale at hand |
|
| Back to top |
|
|
researcher
Blue Pill
Joined: Aug 29, 2006
Posts: 2
Location: the Netherlands
|
| Posted: Thu Dec 14, 2006 4:14 am Post subject: apple scripts to export addressbook entries |
|
| Glenner wrote: | | I use Address Book Exporter (do a search on Versiontracker) to export the data in txt format and then import this into a speadsheet or table. However, this is a static version and the whole process has to be repeated after every change to the address data. |
this may be a little late  this respons
but this guy has created a set of usefull scripts to export your entries.
it works  |
|
| Back to top |
|
|
|
