MozillaZine


Calendar Events & Tasks Add-On

For discussing the Mozilla Calendar, Sunbird and Lightning projects.
Chimewood
 
Posts: 13
Joined: July 15th, 2021, 6:11 am

Post Posted July 22nd, 2021, 3:43 am

Hi, so following on from my post http://forums.mozillazine.org/viewtopic.php?f=39&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
 
Posts: 4838
Joined: February 3rd, 2009, 6:29 pm

Post Posted July 22nd, 2021, 4:51 am

Decathlon wrote: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.php?p=14741221#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/search?q=define+SQLITE_VERSION+&case=true

Chimewood
 
Posts: 13
Joined: July 15th, 2021, 6:11 am

Post Posted July 22nd, 2021, 9:10 am

morat wrote:
Decathlon wrote: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.php?p=14741221#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/search?q=define+SQLITE_VERSION+&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 :shock: ](*,)

morat
 
Posts: 4838
Joined: February 3rd, 2009, 6:29 pm

Post Posted July 22nd, 2021, 9:25 am

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
 
Posts: 13
Joined: July 15th, 2021, 6:11 am

Post Posted July 22nd, 2021, 11:24 am

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
 
Posts: 4838
Joined: February 3rd, 2009, 6:29 pm

Post Posted July 22nd, 2021, 6:01 pm

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.php?p=11955719#p11955719

Chimewood
 
Posts: 13
Joined: July 15th, 2021, 6:11 am

Post Posted July 23rd, 2021, 2:09 am

morat wrote: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.php?p=11955719#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

User avatar
 
Posts: 4991
Joined: May 7th, 2010, 9:38 am
Location: Pennsylvania, USA

Post Posted July 23rd, 2021, 7:11 am

Chimewood wrote:Hi, so following on from my post http://forums.mozillazine.org/viewtopic.php?f=39&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.
Linux Desktop - AMD Athlon(tm) II X3 455 3.3GHz | 8.0GB RAM | GeForce GT 630
Windows Notebook - AMD A8 7410 2.2GHz | 6.0GB RAM | AMD Radeon R5

morat
 
Posts: 4838
Joined: February 3rd, 2009, 6:29 pm

Post Posted July 23rd, 2021, 9:49 am

Chimewood wrote: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
 
Posts: 9
Joined: January 4th, 2005, 10:12 am

Post Posted August 10th, 2021, 4:13 pm

Chimewood wrote:
morat wrote: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.php?p=11955719#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.

Return to Calendar


Who is online

Users browsing this forum: No registered users and 2 guests