This thread was archived. Please ask a new question if you need help.
restoring or trasnsfering calander files
Why is it that what should be the simplest task in the world is a Rube Goldberg nightmare? We have a number of Thunderbird Calendars in different colors (red for appointments, blue for special occasions etc).
First: one of the calendars seems to be corrupted and we want to restore it from the Windows 7 back up. Simple? Impossible. We can not find them. You can not restore what you can not find.
Second: our office has a new computer and we SIMPLY want to copy those calendars over to the new unit where we have installed Thunderbird. Simple? Impossible. Same problem: if you can not find them you can't copy them over.
All responses to these issues have been wrong and been given by people who have obviously not ACTUALLY DONE IT. People should not tell us to do what they have not actually done themselves for the documentation simply wrong in many regards. So please do not tell us to do what you have not ACTUALLY DONE to confirm the instructions are correct. Simple: Verify in fact. Vet the instructions in real life where we actually live. Don't tell us what *should* be true but show us what is proven to actually *be* true. All else is a waste of all our time. Don't tell -- show.
We are told the calendars are in the Profile. We find the Profile (we are showing hidden files and folders) but we can find nothing that even suggests calendar files and nothing that even suggests files with the properties of the calendars on our computer. Not a hint. not a clue. We can not even discover the path-name. We have supplied screen shots of all this. When instructions are proven to be wrong the solution is not to just ignore the fact. This should be the simplest task imaginable and not the embarking on a new career.
We have Windows 7 and the most recent version of FireFox. If a calender is corrupted how do we restore of from a back up? If we buy a new computer and install Thunderbird and want to copy the calendar over how do we do that? We can do none of this and we can not even find the calendars. When someone actually does this do let us know. Does anything really need to be this complicated?
All Replies (20)
The difficulty you present here is that you have fixated on restoring just calendar files.
Thunderbird's profile is quite a complex beast and it wasn't anticipated that "regular users", as you claim to be, would want to dissect out of it specific files. Pretty much all the help and advice, and even third party tools such as MozBackup and TEBE, are aimed at transferring and restoring entire profiles.
Personally, I don't worry about trying to manage calendar files. I synchronize Lightning via external 3rd party calendars such as Google Calendar. This way I see the same calendar on a variety of devices (PC, laptops, tablets, smartphones) and it seems highly likely that you could use this same method to share a calender between various users, so long as they all had access to a common cloud-based calendar.
If you manage to identify and copy out the data file that stores a calendar then you'll still have a cludgy job each time you want to synchronize your computers. It just wasn't designed to be used that way, which is why you're finding it difficult. For instance, the profile is made hidden precisely to deter casual changes to it.
The obvious non-cloud way to synch the calendars on two machines would be to export each calendar to an ics file or similar on one machine, and import those files to the other machine. But you have no simple way of defining which is the "master" calendar, nor of merging separate calendars. Each import would create a new additional calendar.
This article tells me that the local calendar data is stored in local.sqlite. Since I know next to nothing about SQL and databases in general, I can't help you any further. You could try copying this file between profiles. I don't know what happens if you have defined multiple calendars.
Thanks but adding Google calendar into the dynamic only makes this more complicated. "You could try" and "I don't know" are not very helpful. Like I said, I do not want a new career. I just want to restore and/or transfer a file. Simple.
Please see attached screenshot. When we left click on any named calender file it tell us the location of the file is moz-storage-calendar://
A truncated path-name is rather insane but we have searched the hard drive and there is not location called moz-storage-calendar:// and we can fine no file on the computer that even suggests the file name or location you see in the screen shot. WHO write this stuff? WHERE do they find these people?
Wonder why PC sales are down? This is why. NO ONE wants to buy a new computer -- for just these reasons. When we ask what time it is we are told how we *might* make a clock.
At this point I think the best solution is to dump Thunderbird and find a calendar that a person with an IQ of 185 can begin to understand. Anyone who deigns such a program should know and anticipate these are the simple, every day, problems and issues any reasonable user will have to confront eventually.
So you didn't look at local.sqlite?
I don't know the formal terminology, but the location you are given is symbolic, not a literal pathname. It's a form of URI.
Modified by Zenos
And P.S. even if we want to transfer restore an entire profile we still can not find it. Every documented directive is flat-out wrong. WHO writes this stuff? The only place we fund a profile is in appdata/roaming/Thunderbird/profiles. Ten back and forth messages never told us this. There there is a place called Calender-data but we don't know what to do with it because the cryptic file-names are nothing like the properties on the files when we left click on the computer.
This is totally maddening.
PLEASE READ the question presented. If you do not know the answer and have not actually done the process to confirm your instructions please have the courtesy to not send people down one rabbit hole after another or send them off to cyberspace to use and synch a different program. 'Maybe this' or 'try that' and 'I don't know' are not helpful. Keep it simple and only respond to the question only if you have an answer you have verified it.
My calendar data appears to be stored in a folder under the profile named, quite appropriately, calendar-data, which contains various sqlite files, including the aforementioned local.sqlite.
I don't have an SQL browser here to examine the files.
I'd suggest you copy the entire calendar-data folder between computers. Ensure Thunderbird is NOT running when directly accessing the profile in this way.
Please define your terms. I have no clue what local.sqlite is and how do you expect anyone to know? What on earth are you talking about? I want to solve this problem not create ten more.
As I said before, you're out there on your own here. Transferring individual data files between profiles is NOT a standard procedure.
I find if I remove the calendar-data folder from the profile, all my non-cloud events vanish. When I restore it, they re-appear. Note that in the meantime, Thunderbird creates a new more-or-less empty calendar-data folder which you'd want to delete or overwrite.
So, I have done what I suggested to you and found it works as expected.
And so you didn't bother to read the article I linked to, which lists and describes the files in the profile?
It is a file. It is in your Thunderbird profile and so is hidden by default. To work with it you must set your file explorer to show hidden files.
Incomplete instructions but I found it. As I said, I know where the Profile and that's not where a lot of people told us to look in a different query. The calendar data is located in app/data/roaming/Thunderbird/Profile. See attached. There are backups by cryptic names (incomprehensible) and when we click on SQLITE you see what you get. We don't have a clue what to do with this and wonder how on earth you expect us to know. What on earth does this have to do with restoring a calendar file?
PLEASE have the courtesy to actually READ the question. When you can actually DO the task then let us know by providing clear, complete, directions that you have tested and know work but this just sends us down another rabbit hole. We do not have a clue what you expect us to do with this.
PC sales are down because there are competing technologies such as tablets. However, I have yet to meet a tablet that can be used to create complex documents, do CAD work, do spreadsheets, etc etc. PC-type computers will not vanish from the workplace readily. And you'll know this if you're using computers in an office environment. Most businesses shun or are wary of Windows 8 and its Fisher-Price style UI.
Now, how easy is it to move or share a calendar on an iPad or Android tablet? Near impossible, in my estimation, but we don't care because they all use cloud-based services. The apparent simplicity is actually due to a technology you have dismissed as adding unwanted further complexity.
You have been told in other threads how to locate your profile. I don't understand why you remain bemused by having found it under AppData...
Here is the screen shot I forgot to attach. We do not have a clue what to do with your sqlite comment. It take us nowhere. Clicking it gets us nowhere.
I am not interested in an editorial debate but in solving a problem. I have found the profile and it is NOT where others said it was -- not even close. But once there that solves nothing. All that was explained with screen shots.
This is simple. Create a Thunderbird calendar. Make some entries. Do a Windows back up or just do a backup. Now go delete that Calender as if was an accidental delete and restore it.
And/or try to copy that new calendar to another computer where you also have Thunderbird calendars.
I moved my calendar data out of Lightning by removing the folder calendar-data. I restored said data by reinstating said folder. I don't know what else to say to make it easier.
As said before, you're off piste here and on your own. It wasn't designed to be used in this way. You need to bring to it skills and understanding of your filesystem, hidden folders and how to search for and manipulate specific files. That is all outside the remit of the use and operation of an email client.
Machine #1: Close Thunderbird. Locate its profile Copy calendar-data to a thumbdrive or equivalent.
Machine#2: Close Thunderbird Locate its profile Overwrite its calendar-data using the calendar-data folder from machine #1.
Back up both profiles beforehand Ensure both computers are running the same versions of Lightning and Thunderbird to avoid file format or structure incompatibilities.
Why do you want to "open" local.sqlite? It's a database file, using the SQL format and will be undecipherable unless opened by a program that knows SQL.
You can get tools for accessing and editing SQL and SQLlite files, but I can't see that this is relevant to the task at hand, which is moving or restoring a file which happens to be a calendar events database.
You obviously did not read the original issue. We DO see all hidden files. We do see the profile and we do see the Calender data and we do see the Sqlite. This tells us nothing.
The article is wrong. There is no such place local.sqlite. As I said three times, calendar data is stored in appdata/roaming/thunderbird/profile. There there is a directory called 9w2ydrc4.default. In that directory is the local.sqlite. (No one ever informed us of that in any previous thread) But that and 50 cents won't get us on the bus. It tells us nothing. It gets us nowhere.
The "article" you link to as a haystack full of needles. Absolutely nothing in that maddening haystack tells us anything about restoring a calendar file.
"I don't have an SQL browser here to examine the files."
If you don't have and SQL browser (whatever that is) then how on earth can you say you have actually done this? Getting us to SQL gets us nowhere and that haystack of an 'article' tells me nothing in this regard. It doe not tell us how to restore a calendar.
Not "standard procedure"? If I have a file that is accidentally deleted or corrupted it is standard procedure to restore if from a back up. If my letterhead becomes corrupted I do not ave to replace every file in my document directory. Ergo if one of four Thunderbird calenders is accidentally deleted or corrupted any user would want to restore it.
Looking local.sqlite get me nowhere. How is that an answer? It's down a rabbit hole and onto a dead end street. It gets us nowhere?
If getting the tools for accessing and editing SQL and SQLlite files is not relevant to the task at hand why on earth do you send me there. Like I said. I do not want a new career – I already have one.
I don't get a comfortable feeling that you understand what you're doing. We have found the file in question. We don't know what the accompanying files do, so the safe thing is to keep all the files together. So to synchronise one computer with another, we copy the entire folder. We don't care what the individual files do.
Since you haven't appreciated what sqlite means or implies, I have offered a link to describe sqlite and by inference its relevance to your extraordinary request to work with just calendar data. In the several years I've been trying to help Thunderbird users, the question about which file holds calendar data has come up once or twice only. So it's not a topic which has a well rehearsed set of questions and replies.
You have found the profile, you have found the calendar-data folder, so all that remains is to copy it for backup purposes, and overwrite another computer's calendar-data folder, or replace a broken or lost file by a previously copied healthy version. Backing up your entire Thunderbird profile folder means that not just your calendar, but all your other Thunderbird-related data can be restored, including your somewhat unusual requirement to work just on calendar data.
Regular users are not expected or required to have deep knowledge of the profile, nor be intimate with it. You're in admin or super user territory, and as such, are expected to be able to find your own way around. I didn't anticipate having to explain that local.sqlite is a file, nor why opening it is a somewhat specialised operation.
Please provide a link to a help article that was wrong with respect to the location of the profile. I'd like to understand why you found it difficult to locate.