Bulk move events from one service/homeset/collection to another

[mace]

Hi,

I’ve had a synchronisation issue for a long time (over a year), but haven’t had the time to look into it properly until now (due to a requirement for a factory reset).

Long story short, I have somehow ended up with two DAVdroid accounts (services) on my phone, one with just my name, and the other with my full email address. Otherwise both accounts are identical, using the same server (davical).

What seems to have been happening is that although all collections are available via both accounts, events have been created under the short name account, and those events are not being submitted back to davical.

I’m assuming that this issue is something related to the installation comment about creating accounts with an email address, although these aren’t group-scheduled events, so I’m not sure if that’s an incorrect assumption?

Anyhow, before I reset the phone, I want to recover all past and future events and get them into davical.

Is there some way I can do this, perhaps by modifying the name of the DAVdroid account to my email address and forcing a resync?

I’m not adverse to writing some code to achieve this if needs be, but would need some pointers/suggestions as to the best way to go.

Thanks,

Miah

-debug info-
SOFTWARE INFORMATION
DAVdroid version: 1.3.8-ose (134) Sat Feb 04 22:41:38 GMT+00:00 2017
Installed from: com.android.packageinstaller
JB Workaround installed: no

CONFIGURATION
System-wide synchronization: automatically
Account: miah
  Address book sync. interval: —
  Calendar     sync. interval: —
  OpenTasks    sync. interval: —
  WiFi only: false
  [CardDAV] Contact group method: CATEGORIES
  [CalDAV] Time range (past days): 90
           Manage calendar colors: true
Account: miah@emailaddress.net
  Address book sync. interval: 1440 min
  Calendar     sync. interval: 1440 min
  OpenTasks    sync. interval: —
  WiFi only: false
  [CardDAV] Contact group method: CATEGORIES
  [CalDAV] Time range (past days): null
           Manage calendar colors: true

SQLITE DUMP
android_metadata
        |  locale |
        |  en_GB |
----------
settings
        |  setting | value |
        |  distrustSystemCerts | 0 |
        |  logToExternalStorage | 0 |
----------
services
        |  _id | accountName | service | principal |
        |  1 | miah | carddav | <null> |
        |  2 | miah | caldav | <null> |
        |  3 | miah@emailaddress.net | carddav | <null> |
        |  4 | miah@emailaddress.net | caldav | <null> |
----------
sqlite_sequence
        |  name | seq |
        |  services | 4 |
        |  collections | 18 |
        |  homesets | 9 |
----------
homesets
        |  _id | serviceID | url |
        |  6 | 2 | https://www.emailaddress.co.uk/dav/caldav.php/miah/ |
        |  7 | 3 | https://www.emailaddress.co.uk/dav/caldav.php/miah/ |
        |  8 | 1 | https://www.emailaddress.co.uk/dav/caldav.php/miah/ |
        |  9 | 4 | https://www.emailaddress.co.uk/dav/caldav.php/miah/ |
----------
collections
        |  _id | serviceID | url | readOnly | displayName | description | color | timezone | supportsVEVENT | supportsVTODO | sync |
        |  11 | 2 | https://www.emailaddress.co.uk/dav/caldav.php/miah/home/ | 0 | Miah Gregory | <null> | <null> | <null> | 1 | 1 | 1 |
        |  12 | 2 | https://www.emailaddress.co.uk/dav/caldav.php/miah/personal/ | 0 | Miahs Personal Calendar | <null> | <null> | <null> | 1 | 1 | 1 |
        |  13 | 2 | https://www.emailaddress.co.uk/dav/caldav.php/miah/tasks/ | 0 | Miahs Tasks | <null> | <null> | <null> | 1 | 1 | 0 |
        |  14 | 3 | https://www.emailaddress.co.uk/dav/caldav.php/miah/contacts/ | 0 | Miahs Contacts | <null> | <null> | <null> | <null> | <null> | 1 |
        |  15 | 1 | https://www.emailaddress.co.uk/dav/caldav.php/miah/contacts/ | 0 | Miahs Contacts | <null> | <null> | <null> | <null> | <null> | 1 |
        |  16 | 4 | https://www.emailaddress.co.uk/dav/caldav.php/miah/home/ | 0 | Miah Gregory | <null> | <null> | <null> | 1 | 1 | 1 |
        |  17 | 4 | https://www.emailaddress.co.uk/dav/caldav.php/miah/personal/ | 0 | Miahs Personal Calendar | <null> | <null> | <null> | 1 | 1 | 1 |
        |  18 | 4 | https://www.emailaddress.co.uk/dav/caldav.php/miah/tasks/ | 0 | Miahs Tasks | <null> | <null> | <null> | 1 | 1 | 1 |
----------

SYSTEM INFORMATION
Android version: 7.1.1 (bacon-userdebug 7.1.1 NMF26V b6ec81fab4)
Device: OnePlus A0001 (A0001)
-debug info-

[rfc2822]

I’m assuming that this issue is something related to the installation comment about creating accounts with an email address, although these aren’t group-scheduled events, so I’m not sure if that’s an incorrect assumption?

If the events are not group-scheduled, the ORGANIZER and thus the account name should not matter.

Anyhow, before I reset the phone, I want to recover all past and future events and get them into davical.

Can you exports the events in your calendar app?

[mace]

Thanks for getting back to me.

I’m using google calendar, which doesn’t have an export option as far as I can tell.

However, your comment gave me the idea to find something that could export from it, and I found iCal Import/Export CalDAV. Using that, I exported all of the calendars to file, then connected to my davical server and imported all the previously saved files. That appears to have successfully merged in the events which were in limbo.

Thanks!