Imported addresses not showing in CardDAV

Get help from the community here.

Moderator: Developers

allwi
Posts: 4
Joined: Mon Jul 13, 2020 1:58 am
Location: Australia

Imported addresses not showing in CardDAV

Postby allwi » Mon Jul 13, 2020 2:07 am

Hi,

I'm thinking of moving from Nextcloud to GO and am evaluating the server.
I exported my addressbook from Nextcloud as VCF.
Imported it painlessly in GO.
GO created the company entries as described but when I synchronise the addressbook via carddav to a client, I only see the company entries and not any of the imported contact.
I checked directly the carddav URL https://GO/carddav/addressbooks/<user>/<addressbook#> and had to confirm that it shows only the created entries.
I did another test and inserted a new address entry manually and this is shown in carddav.

So it seems that the imported entries are not "published" to carddav but only available internally in GO.

Is there a way to synchronise an addressbook with the carddav module manually or to force the publishing of the addresses to carddav?

Cheers
Max
allwi
Posts: 4
Joined: Mon Jul 13, 2020 1:58 am
Location: Australia

Re: Imported addresses not showing in CardDAV

Postby allwi » Tue Jul 14, 2020 7:50 am

Ok, I digged around a bit and found that the URI column in the addressbook_contact table is NULL for the imported contact.
When I update it to the value of to UID so that it aligns with the created entries, I get the contact via CardDAV.

The only issue I'm seeing now is that some - different - entries have the same UID.

Code: Select all

| 133 | Mandagery Creek (Venison)                          | 133@cloud.com          | 133@cloud.com.vcf      | aa70f7cfba5ac63cfaf713b2bd7891b9404e02d4 |

Code: Select all

| 134 | Mandagery Creek (Venison)                          | 138@cloud.com          | NULL                                     | 94e33cce98eb64b39c9c5c1e9401ffa9725066d1 |

Code: Select all

| 138 | Sirens B&B                                         | 138@cloud.com          | 138@cloud.com.vcf      | b020c335206cbd5af40994abd8b9f7b365de927a |
What happened here? What does this mean?
mschering
Site Admin
Site Admin
Posts: 8357
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: Imported addresses not showing in CardDAV

Postby mschering » Tue Jul 14, 2020 8:12 am

I think I just fixed this issue. Please retest this with v6.4.159 when released later today.
Best regards,

Merijn Schering
Intermesh
allwi
Posts: 4
Joined: Mon Jul 13, 2020 1:58 am
Location: Australia

Re: Imported addresses not showing in CardDAV

Postby allwi » Wed Jul 15, 2020 3:57 am

Hi Merijn,

thanks for the response. I upgrade the installation and confirmed that I now run v6.4.159
I create a new DB and pointed the deployment to the new DB.
I enabled all required modules, imported a small set of limited test data ... but still see the same behaviour :(
The addresses are imported correctly and shown in the web console of GO.

But when I look at the carddav URL, I only see the Company record which was created during the import.
The database still shows

MariaDB [groupoffice_prod]> select id, name, uid, uri, vcardBlobId from addressbook_contact;
+----+-----------------------+--------------------------------------+-----------------------------------+------------------------------------------+
| id | name | uid | uri | vcardBlobId |
+----+-----------------------+--------------------------------------+-----------------------------------+------------------------------------------+
| 1 | Testuser, One | 13f149d2-9b68-4942-be65-fb312d1f44d2 | NULL | 8de2d1c5314be7349abb0e55e3a27b5c599f8a37 |
| 2 | Testuser, Two | db9581ff-22f8-481c-9a2a-d123e3b63e8e | NULL | 7ed2ebbf689222927688cfc95da853196e59c751 |
| 3 | Testuser, Three | 02121a08-782e-40ef-b70f-3ecebe15024c | NULL | c0eda68137bf39d5634aee538601fb7c489af364 |
| 4 | Example Company, Inc. | 4@cloud.com | 4@cloud.com.vcf | 45002544f4079371623128b1aece466ac4c09f77 |
| 5 | Testuser, Four | 54cd81ab-c486-4561-beb1-031afd78a0b7 | NULL | d9dd66e01dd07671a5891702a0e5ea5fa7185d05 |
| 6 | Testuser, Five | 99d04d1a-a2c3-4257-b0f2-273e0cee89f5 | NULL | 9d7f88efb873f858dc4e8bc384b589a2db18af98 |
+----+-----------------------+--------------------------------------+-----------------------------------+------------------------------------------+
allwi
Posts: 4
Joined: Mon Jul 13, 2020 1:58 am
Location: Australia

Re: Imported addresses not showing in CardDAV

Postby allwi » Wed Jul 15, 2020 7:08 am

btw - Importing existing addressbooks is only a one-off task. So I don't see this as a critical issue, if there's a manual workaround.
A DB update like
update addressbook_contact set uri=concat(uid,'.vcf') where uri is null;
seems to do the trick but I'm not sure, if there are any unexpected side effects. Can you comment on this?

Who is online

Users browsing this forum: Bing [Bot] and 3 guests

cron