Apache OpenOffice (AOO) Bugzilla – Issue 40317
address import from evolution 2.0.2 unusable
Last modified: 2006-09-24 14:51:56 UTC
I like very much how OpenOffice can retrieve data from the Contacts database of evolution (I'm using evolution 2.0.2 on Fedora Core 3). However, OpenOffice gets the entire address label in 1 field called address_label_home in a very unusable format. In evolution, you can define the address (e.g. the home address) in several fields: - Address - City - Zip/Postal Code - State/Province - Country If you look in the file addressbook.db in which evolution stores this (with db_dump -p), you see that the address is then stored e.g. as: ;;Nieuwstraat 100;Brussel;;1000;\0d\0a But once this gets into OpenOffice, you get in address_label_home: Nieuwstraat 100Brussel1000 So, from the db file of evolution it is clear that OpenOffice should be able to get the different subfields from the address field, but OpenOffice only gets the entire field, and, moreover, removes the separators. Unless I'm doing something wrong here, it means that it's very difficult to use these addresses e.g. to make labels.
Hello verthezp, OOo 1.1 is a bit old. Can you reproduce the issue also with the latest milestone build? http://download.openoffice.org/680/index.html Thank you in advance for checking, Max
OOo 1.1 is current on Fedora Core 3, so this can hardly be called old. Anyway, I installed the latest build (1.9.87), and it doesn't even seem to allow me to configure evolution as a data source for an addressbook... - File -> Wizards -> Address Data Source... - then, select "Other external data source" - "Database type" in next window doesn't give any option to select evolution Any suggestions?
>> OOo 1.1 is current on Fedora Core 3, so this can hardly be called old. I admit i got used to the 1 week release interval of our milestone builds.. ;-) still 1.1 is from Oktober 03 and we had 4 bugfix releases since then. >> it doesn't even seem to allow me to configure evolution as a data source for >> an addressbook i see, have to investigate
well, now i found out that OOo 2.0 development snapshots do not support evo2 import yet, we have to wait for CWS evoab201, see issue 34909. verthezp, i'll keep an eye on this.
So I resolve this as a duplicate of issue 34909. When issue 34909 is fixed we should look on this on also. *** This issue has been marked as a duplicate of 34909 ***
close
Reopening, since this is not solved via Issue 34909
-added myself as CC
Cancel that... wrong issue. Steve
@verthezp Still reproducible with 2.0.2 or later?
I've retried it on Fedora Core 6 test 2, with following versions: - evolution: 2.7.4-4 - openoffice.org: 2.0.3-7.7 - evolution-data-server: 1.7.4-3 With these releases, the address line is properly split up into several fields in the database table, and so the issue is fixed. Thanks for solving this.
sounds good, fixed in 2.0.3/2.0.4
closing