This site will have limited functionality while we undergo maintenance to improve your experience. If an article doesn't solve your issue and you want to ask a question, we have our support community waiting to help you at @FirefoxSupport on Twitter and/r/firefox on Reddit.

Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

This thread was archived. Please ask a new question if you need help.

Where is calendar name stored in sqlite?

  • 2 replies
  • 1 has this problem
  • 9 views
  • Last reply by Mark Foley

Mark Foley
Mark Foley
more options

Since Lightning doesn't periodically update published iCals, I've created a script to do it myself by querying the sqlite database. No problem, except that now I have a user with two calendars. I can find both cal_id's by "select distinct cal_id from cal_events", which gives me two 36 bytes strings, but which is for which calendar? I can figure it out by comparing my script output with the original published calendars, but that is time consuming and will require my manual intervention whenever a person happens to publish 2 or more calendars.

Is there something in the database, or some config file that correlates calendar name with cal_id? Of course, there must be or Lightning wouldn't be able to find the calendar data by calendar name! I guess the question is, where is is this kept and is it accessible by me?

Since Lightning doesn't periodically update published iCals, I've created a script to do it myself by querying the sqlite database. No problem, except that now I have a user with two calendars. I can find both cal_id's by "select distinct cal_id from cal_events", which gives me two 36 bytes strings, but which is for which calendar? I can figure it out by comparing my script output with the original published calendars, but that is time consuming and will require my manual intervention whenever a person happens to publish 2 or more calendars. Is there something in the database, or some config file that correlates calendar name with cal_id? Of course, there must be or Lightning wouldn't be able to find the calendar data by calendar name! I guess the question is, where is is this kept and is it accessible by me?

Chosen solution

I found the answer by grepping the files in the Thunderbird Profiles directory:

.../Profiles/<myProfileName>/prefs.js

e.g.: prefs.js:user_pref("calendar.registry.2d738716-98a2-491b-b640-1b9d640a4135.name", "Holly's Calendar");

Read this answer in context 👍 0

All Replies (2)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

Really I am beyond my skill level with your questions. I suggest you ask them where developers hang out. like the mozilla.dev.apps.thunderbird newsgroup.

There is a google groups mirror here https://groups.google.com/forum/#!forum/mozilla.dev.apps.thunderbird

Modified by Matt

Mark Foley
Mark Foley Question owner
more options

Chosen Solution

I found the answer by grepping the files in the Thunderbird Profiles directory:

.../Profiles/<myProfileName>/prefs.js

e.g.: prefs.js:user_pref("calendar.registry.2d738716-98a2-491b-b640-1b9d640a4135.name", "Holly's Calendar");