My Pages index.db files were all in the 200-400k range.
That's how/why I started to piece them together by opneing the saved copies in text editor. I'd suspect if yours are as small a say then there is sadly nothing in them.
One iWork specialist from France on the forums here stated that without a .xml file no iWork file could be recovered. But the AppleCare expert I talked with at length stated confidently that iOS does not use .xml files, since it does not store documents the same way as OSX does. (Which is why when if change the folder name from ~tef it changes it to a Pages doc that can't be opened by OSX).
As per Gvde's solution above (if I followed it correctly: copying the -tef folder over, changing the name to remove the "-tef", synching, then renaming it back to -tef and resyching), regretably did not cause the file even to appear on my iPad. My iMac auto reformats the file as a Pages doc when the -tef is removed and doesn't reformat it when changed back -- the file retains the pages icon, in other words.
Btw, I discovered that if you have any .db Pages files in your mobile doc folder, they can be opened manually by Text Editor and actual readible portions of your work can be found there and salvaged. It's scattered, chopped, duplicated, imcomplete, and contains older previously edited portions, but enough material remains to reassemble a good amount. Beast rewriting from scrtah in some instances.
Documents in the index.db file that have a file size of 29KB CANNOT BE RECOVERED. There's nothing there related to the text. (But yes you can open in Text Edit and verify this, thanks for the heads-up there.)
I should know. Last December I restored my iPad 2 from an iTunes backup and I lost files that Apple Engineering spent nearly a month trying to recover. The index.db files they "recovered" we're 29 KB and they could not get them to work even after my Apple support person threw apples at the Apple Engineering department.
When I upgraded to the "New iPad" and finished installing from my iTunes backup... The same thing happened... Lost Pages documents and this time my iPad was disconnected from the iCloud iWork webpage. Same result with Apple support this time so far but it's only been about 3 weeks that my iCoud service has been down for Pages documents.
Anyone else at their wits end with similar failures, after restoring from iTunes backup? And similar results with Apple Engineering?
Mountain Lion had better fix this...the functionality of iWork documents between IOS and OSX stinks and the repeated loss of documents stinks even more.
That's sad. Sorry to hear that.
Although Applecare engineers spent 9 days on my case, and I had all manner of Pages files of up to 400k, they found nothing to recover for me. I regained some only through the text edit route.
I've still not regained trust in IOS / iCloud for doing any iWork without manual backups (i.e., send to iTunes).
I've also started using the free Dropbox to save my files by senidng them via email.
Sqlite? Hmmm. That's very interesting. I googled it, but I would have no idea how to use it. Doesn't look like it allows you to just open files since it's all done through terminal and I have no idea what commands I would use. Would it open only the proper text or all the tons and tons of gibberish coding characters of a file?
I have tried to find my data in the -delete folder but that folder didn't even exist, however I did find a folder in Time machine from late september that had my pages-numbers and keynote files intact.
Restored them and then copied and pasted them into a safe location (anywhere except iCloud) I have restored them numerous times and the only reliable thing to happen everytime is that they are deleted.
Like others on here I've spoke to Apple support, initially told I wasn't covered but I do have a new iPhone so managed to get through the hoops. Still no word from them after being promised a response in 5 working days.
iCloud if it worked would be fantastic and was for me until early October
After spending another day with this I cannot get my data to appear in iCloud if I have any IOS device set to iCloud for Numbers, Pages Keynote.
I haven't found a cure but after downloading iExplore for mac and browsing my iPhone the numbers documents etc are actually stored on the device until I turn on iCloud on any IOS device then they disapear from everywhere.
So if this continues to happen (it did it to me this morning, all the Numbers, Pages and Keynote files I had in iCloud disappeared), how can we trust iCloud in general? What is the probability that tomorrow all my contacts, calender items and icoud /me emails are gone too!
As mentioned before, it does not seem that Apple have a grip on 'cloud computing' at all!
Sorry to hear that. I agree.
Can you supply some more information?
On what device did you first see them disappear?
Do you see any ghost documents listed?
Btw, re my own disatser back in February, a few weeks ago I suddenly saw several lost Pages documents [whose ghost files I left on my ipad!] miraculously restored to my ipad ...and this occured right after I purchased a brand new iMac with Lion preinstalled. ...Very strange. My original loss of cloud Pages files occured after upgrading an older imac to MLion whereby it auto activiated the cloud and deleted everything. Weeks of tech calls with Apple got me no where and nothing restored.
So, don't ever delet any ghost files that remain.
I have an iPhone 4S, an iPad2 and a new 15"MacBook Pro (the non-Retina mid 2012 version). I use iOS 6 on the Pad and Mountain Lion (with all the updates) on the MacBook.
I have pages, Numbers and Keynote installed on the iPad and MacBook, not the iPhone. But I (of course) use iCloud on all three devices to synchonise Contacts, Calender and Mail.
So far I have been very happy with the shole setup (apart from the fact that the iOS and OSX versions of the iWork apps have only a limited 'overlap' in functionality but that's another issue than the current one).
I have so far mostly (but not exclusovely) used iCloud for the iPad versions of a few documents and spreadsheets. But this morning I made a small Pages file and as I wanted to show it to a co-worker and was not going to take the MacBook along, I saved it in iCloud instead of in a documents folder. When I opened Pages on the iPad, there was only the new document, nothing else. Then - curious - I opened Numbers, only to see all my numbers documents for about a second and then they all disappeared.....
When I looked in the 'mobile documents' folder (in Finder, on the MacBook), there is also only that one (new) file.
And of course nothing in time machine, as 'Mobile Documents' is only a 'mirror' of iCloud, not an actual folder.
What do you mean with 'ghost files'?
And you are saying that your 'lost' files miraculously reappeared after 8 months or so?