Important Notice: We're experiencing email notification issues. If you've posted a question in the community forums recently, please check your profile manually for responses while we're working to fix this.

On Monday the 3rd of March, around 5pm UTC (9am PT) users may experience a brief period of downtime while one of our underlying services is under maintenance.

Avatar for Username

Cari Bantuan

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.

Pelajari Lebih Lanjut

Utas ini telah diarsipkan. Silakan membuat pertanyaan baru jika Anda membutuhkan bantuan.

Where is calendar name stored in sqlite?

  • 2 balas
  • 1 memiliki masalah ini
  • 10 kunjungan
  • Balasan terakhir oleh 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?

Solusi terpilih

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");

Baca jawaban ini dalam konteks 👍 0

Semua Balasan (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

Diperbarui oleh Matt pada

Mark Foley
Mark Foley Pemilik pertanyaan
more options

Solusi Terpilih

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");