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



  • 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-

  • developer

    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?



  • 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! :)


Log in to reply
 

Looks like your connection to Bitfire App Forums was lost, please wait while we try to reconnect.