Where does Sunbird store its calendar files?

[Sandman2012]

I've tried looking in the Mozilla Sunbird folder in Program Files and the Sunbird folder in Application Data, and can't find any .ics files.

I'm having a problem with a calendar that had some corrupted data. If I delete the calendar from within Sunbird, then create a new calendar with the same name, I get the corrupted data back. I'm thinking deleting the file from within Windows should fix the problem.

I'm using Sunbird 0.3a1.

[norcimo]

If you edit the calendar (in Sunbird) it should display the local file location.

[Old ssiter]

In Sunbird 0.3a1 the calendars are stored in a local database. You can verify this by looking at the Location field in the calendar properties. If the location starts with "moz-profile-calendar://" the calendar is stored internally.

At the moment it is a known issue that the calendar events are not deleted from database if you delete the calendar. Right now I'm aware of two workarounds:

A) First create the new calendar and then delete/unsubscribe the old calendar. The events will stay in database but will not show up in the new calendar.

B) Explicitly delete all events from calendar before deleting the calendar. Unselect all calendars so that only events from the calendar that should be deleted are shown in the unifinder (event list above the calendar view). Then you could just highlight all the events with that name (using ctrl or shift) and delete them. Then delete the calendar.

[Sandman2012]

Thanks.

[JaapB]

I do want to restore the old calendar, It would be a hell of a job to make a new calendar.
Where is the calendar, and how can I edit it?

[Jesdisciple]

JaapB, the default location for the standard installation is apparently (based on this post and my copy-and-paste solution for a bugged upgrade of my portable installation) C:\Documents and Settings\[username]\Application Data\Mozilla\Sunbird\Profiles\[gibberish].default\storage.sdb, although I believe you can tell Sunbird to use an iCal file when you create a new calendar.

(In case anyone wonders why I bumped this thread half a year after the last post, I Googled this topic and ended up answering it for myself.)

[evansbrasil]

how do I get my 5 calendars in Sunbird into a file I can sync with my PDA? It appears that they are all stored internally! I switched to Thunderbird and Sunbird because Outlook was so unsable, but now this.

[dserodio]

JaapB, the default location for the standard installation is apparently (based on this post and my copy-and-paste solution for a bugged upgrade of my portable installation) C:\Documents and Settings\[username]\Application Data\Mozilla\Sunbird\Profiles\[gibberish].default\storage.sdb, although I believe you can tell Sunbird to use an iCal file when you create a new calendar.

(In case anyone wonders why I bumped this thread half a year after the last post, I Googled this topic and ended up answering it for myself.)

I don't know if this information is still true, because my storage.sdb file is empty (checked with sqlite browser) and I have a calender in Lightning. To be sure, I created a new (local) calendar, and storage.sdb modification date is unchanged from two months ago.

Before this test, Lightning showed only one calendar in the "Calendars" pane, but 4 in the calendars drop-down in the event details dialog (see screenshot).

[ssitter]

I don't know if this information is still true, because my storage.sdb file is empty (checked with sqlite browser) and I have a calender in Lightning. To be sure, I created a new (local) calendar, and storage.sdb modification date is unchanged from two months ago. Before this test, Lightning showed only one calendar in the "Calendars" pane, but 4 in the calendars drop-down in the event details dialog (see screenshot).

Based on the screenshot it seems that you are using a Lightning 1.0pre nightly test build. Lightning 1.0pre stores its data and preferences different to Lightning 0.9. Are you looking for something specific?

[dserodio]

I want to delete all of my local calendars, and keep only the Google Calendar.

[dserodio]

I noticed there's a calendar-data folder inside my profile folder, which only contains a local.sqlite file; but this file doesn't contain my calendar(s) either, because the cal_events table (and almost every table) is empty.

[Jesdisciple]

dseradio: I suggest that you start a new topic since you need help. Logging new information in an old but relevant thread is useful, but questions probably won't get answered here.

[ssitter]

I noticed there's a calendar-data folder inside my profile folder, which only contains a local.sqlite file; but this file doesn't contain my calendar(s) either, because the cal_events table (and almost every table) is empty.

The information about your calendars and other preferences are stored inside the pref.js file. You can access this settings via Tools > Options > Advanced > Config Editor.

[dserodio]

Awesome! I opened prefs.js and removed all "calendar.registry.*" entries, and finally managed to get rid of all events. Now I subscribed to my Google Calendar and apparently got the results I expected.

Thanks.