Calendar Events & Tasks Add-On

[Chimewood]

Hi, so following on from my post http://forums.mozillazine.org/viewtopic ... &t=3077078 I have managed to retrieve all my folders and emails using the ImportExportToolsNG add-on but I can't find an add-on for importing my Calendar events and tasks.
The file on the computer - calendar-data>backup shows a SQLITE File but the SQLite Manager Add-On is not compatible for the latest version 78.12.0
Can anyone help please? TIA

[morat]

Local calendars are stored as sqlite database in the local.sqlite file in your profile folder but it shouldn't be touched by the user. You can export/import your calendars as ics file from the "Events and Tasks" menu...

More info
http://forums.mozillazine.org/viewtopic ... #p14741221

You can use the SQLite command line shell to dump the local.sqlite file.

Code: Select all

sqlite3.exe "C:\...\local.sqlite" .dump > local.txt
notepad.exe local.txt

If the database is corrupt, then sqlite3.exe should output an error message.

SQLite Command Line Shell
http://www.sqlite.org/cli.html

SQLite Download Page
http://www.sqlite.org/download.html
http://www.sqlite.org/2019/sqlite-tools-win32-x86-3290000.zip

Thunderbird 78 uses sqlite version 3.29.0.

Reference
http://searchfox.org/mozilla-esr78/sear ... &case=true

[Chimewood]

Local calendars are stored as sqlite database in the local.sqlite file in your profile folder but it shouldn't be touched by the user. You can export/import your calendars as ics file from the "Events and Tasks" menu...

More info
http://forums.mozillazine.org/viewtopic ... #p14741221

You can use the SQLite command line shell to dump the local.sqlite file.

Code: Select all

sqlite3.exe "C:\...\local.sqlite" .dump > local.txt
notepad.exe local.txt

If the database is corrupt, then sqlite3.exe should output an error message.

SQLite Command Line Shell
http://www.sqlite.org/cli.html

SQLite Download Page
http://www.sqlite.org/download.html
http://www.sqlite.org/2019/sqlite-tools ... 290000.zip

Thunderbird 78 uses sqlite version 3.29.0.

Reference
http://searchfox.org/mozilla-esr78/sear ... &case=true

Thank you for your reply morat, I have looked at the links you posted, but I'm sorry to say that it is all way over the top of my head

[morat]

Why do you want to use the SQLite Manager addon? I was just posting an alternative to the obsolete addon.

Do you have a .ics file to import?

Did you try copying the local.sqlite file from the old profile to the new profile?

It's been a long time since I did this...

[Chimewood]

Morat, I don't have an .ics file to import, I could do it if it was. The only file is as detailed below

The file is under User > AppData > Roaming > Thunderbird > Profiles > 'numbers/letters' default > calendar-data > SQLITE File

Thank you for trying to help

[morat]

I got a local.sqlite file from another profile working with a fresh Thunderbird Portable 78.12.0 installation.

I had to change the cal_id value in the prefs.js file.

More info
http://support.mozilla.org/questions/1169200
http://forums.mozillazine.org/viewtopic ... #p11955719

[Chimewood]

I got a local.sqlite file from another profile working with a fresh Thunderbird Portable 78.12.0 installation.

I had to change the cal_id value in the prefs.js file.

More info
http://support.mozilla.org/questions/1169200
http://forums.mozillazine.org/viewtopic ... #p11955719

Thank you again for your help morat, sadly the above is beyond my capabilities.
However, I've solved my problem by downloading a SQLite viewer. From that I was able to see my reminders and I can add them to the new calendar.

[WaltS48]

Hi, so following on from my post http://forums.mozillazine.org/viewtopic ... &t=3077078 I have managed to retrieve all my folders and emails using the ImportExportToolsNG add-on but I can't find an add-on for importing my Calendar events and tasks.
The file on the computer - calendar-data>backup shows a SQLITE File but the SQLite Manager Add-On is not compatible for the latest version 78.12.0
Can anyone help please? TIA

Well, if you are in the Calendar tab, you can select the "Events and Tasks" menu item.
If you had previously used "Export" from that menu item, you can use "Import" to add them back into Thunderbird.

I export or back up my profile regularly.

[morat]

beyond my capabilities

The calendar.list.sortOrder pref has a cal_id value for each calendar.

I just globally replaced the 7fa126da-c552-40f5-a679-2e92be0c0ac9 string with a0d91ed5-75e2-4069-b2ee-96d302ef7687 in the prefs.js file in the new profile using Notepad.

* lines with cal_id value in prefs.js file in old profile

Code: Select all

user_pref("calendar.list.sortOrder", "a0d91ed5-75e2-4069-b2ee-96d302ef7687");
user_pref("calendar.registry.a0d91ed5-75e2-4069-b2ee-96d302ef7687.calendar-main-default", true);
user_pref("calendar.registry.a0d91ed5-75e2-4069-b2ee-96d302ef7687.calendar-main-in-composite", true);
user_pref("calendar.registry.a0d91ed5-75e2-4069-b2ee-96d302ef7687.disabled", false);
user_pref("calendar.registry.a0d91ed5-75e2-4069-b2ee-96d302ef7687.name", "Home");
user_pref("calendar.registry.a0d91ed5-75e2-4069-b2ee-96d302ef7687.type", "storage");
user_pref("calendar.registry.a0d91ed5-75e2-4069-b2ee-96d302ef7687.uri", "moz-storage-calendar://");

* lines with cal_id value in prefs.js file in new profile

Code: Select all

user_pref("calendar.list.sortOrder", "7fa126da-c552-40f5-a679-2e92be0c0ac9");
user_pref("calendar.registry.7fa126da-c552-40f5-a679-2e92be0c0ac9.calendar-main-default", true);
user_pref("calendar.registry.7fa126da-c552-40f5-a679-2e92be0c0ac9.calendar-main-in-composite", true);
user_pref("calendar.registry.7fa126da-c552-40f5-a679-2e92be0c0ac9.disabled", false);
user_pref("calendar.registry.7fa126da-c552-40f5-a679-2e92be0c0ac9.name", "Home");
user_pref("calendar.registry.7fa126da-c552-40f5-a679-2e92be0c0ac9.type", "storage");
user_pref("calendar.registry.7fa126da-c552-40f5-a679-2e92be0c0ac9.uri", "moz-storage-calendar://");

[docja]

I got a local.sqlite file from another profile working with a fresh Thunderbird Portable 78.12.0 installation.

I had to change the cal_id value in the prefs.js file.

More info
http://support.mozilla.org/questions/1169200
http://forums.mozillazine.org/viewtopic ... #p11955719

Thank you again for your help morat, sadly the above is beyond my capabilities.
However, I've solved my problem by downloading a SQLite viewer. From that I was able to see my reminders and I can add them to the new calendar.

Hey Chimewood, I have a similar problem. What SQLite viewer did you use? Thanks.