[Hint] How did I fix my ODT file

Discuss the word processor

Re: [Hint] How did I fix my ODT file

Postby John_Ha » Sat Mar 24, 2018 1:23 pm

LovingLife139 wrote:If it helps anyone else in the future, learn from my mistakes

Your biggest mistake was not taking backups to a separate disk and, preferably, to the web.

Install Google Backup and SYnc or Dropbox and invest a few pounds in a USB stick. Take daily backups of important files. As a last resort, email yourself a file - if you configure your email to keep files on the server it will act as a backup. Switch on AOO's Always create backup copy and AutoRecovery - see Tutorial.
AOO 4.1.5, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 5689
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: [Hint] How did I fix my ODT file

Postby H8tank » Tue Jun 19, 2018 9:30 pm

I had a user on a Win 10 machine using Apache Open Office 4.1.2 who had a doc open, accidentally did a select all, type a few characters then freaked out tried to close it down but instinctively hit 'save' on the way out. So years of work gone in a flash.

No Auto Backup, no file in temp, but I did find a shadow copy and was able to retrieve it, however it is corrupted. I have tried every trick I know, multiple versions of open or libre, zipped files open, but the content.xml won't.

I did get 7 pages of text on one attempt, but there should be many, many more.

One error on opening: Read Eror, Format Error discovered in the Filein sub-document content.xml at 1,0(row,col).

Want to have a look? http://apctec.com/SimpleC.zip

Thanks for reading, fingers crossed.
Created Open office 3, Win10, attempted recovery xp 32bit, win764
H8tank
 
Posts: 2
Joined: Tue Jun 19, 2018 9:20 pm

Re: [Hint] How did I fix my ODT file

Postby robleyd » Wed Jun 20, 2018 8:00 am

The content.xml file seems badly corrupted from fairly early in the file. I managed to recover a small amount of the raw text of the content which I have attached. Maybe someone else may recover somewhat more than I managed.
Attachments
content.zip
(4.33 KiB) Downloaded 24 times
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1963
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Hint] How did I fix my ODT file

Postby H8tank » Wed Jun 20, 2018 6:07 pm

Thank you for taking a look. :)

Yeah, that is the same I was able to get, about 9 pages, there were around 300 pages total.

What is weird, is I was able to get 2 copies from shadow folders, one from May, one from June, and they both only have the first 9 pages recoverable.

I guess I am running out of options? Is there anyway the xml file can be repaired even if it costs $$?
Created Open office 3, Win10, attempted recovery xp 32bit, win764
H8tank
 
Posts: 2
Joined: Tue Jun 19, 2018 9:20 pm

Re: [Hint] How did I fix my ODT file

Postby RoryOF » Wed Jun 20, 2018 6:48 pm

Run PhotoRec or Recuva and see what it finds. You will need to rename any files it finds to .odt before opening them
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 27182
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Hint] How did I fix my ODT file

Postby earendil » Wed Aug 08, 2018 10:24 am

Hi guys. I stumbled upon this thread because my fiancee has one chapter of her postgrad thesis corrupted, with the usual error: 'format error discovered in the sub-document context.xml at 2,203644(row,col)). As she was pretty desperate (there weren't any previous versions available), I tried to recover the file using the xml editing instructions posted by some amazing guys above, but to no avail (probably because I'm totally inexperienced with xml tagging).

I know it's too much to ask, but if one of you is willing to give it a shot, it would save her so much time. Thanks in advance! :(

the file was too big for upload here, attaching gdrive link: https://drive.google.com/open?id=10MIND ... jawBMhdpqr
Open Office 4.1 on KDE Neon
earendil
 
Posts: 2
Joined: Wed Aug 08, 2018 10:14 am

Re: [Hint] How did I fix my ODT file

Postby robleyd » Wed Aug 08, 2018 11:45 am

I've managed to recover 42 pages of this document; if you care to PM me an email address I'll send you the repaired document.

As a good potential spouse, you should now introduce your fiancee to the idea of multiple backups of important documents - you might find Timestamped backup a useful tool for creating such; I use it and wouldn't be without it.
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1963
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Hint] How did I fix my ODT file

Postby earendil » Wed Aug 08, 2018 12:01 pm

You are a true hero! The file was completely recovered, including formating!!! :bravo: :bravo: :bravo:
We can't thank you enough for saving her days of re-writing! (She's literally crying out of happiness).

I usually do cloud backups but she prefers to keep copies of her work on USB flash drives, but she got really forgetful and had a single instance saved only. I am sure that was the best lesson for saving timestamped backups. Thx for the extension, I 'll have her download it ASAP! :D
Open Office 4.1 on KDE Neon
earendil
 
Posts: 2
Joined: Wed Aug 08, 2018 10:14 am

Re: [Hint] How did I fix my ODT file

Postby robleyd » Wed Aug 08, 2018 12:19 pm

I'd be cautious about saving direct to USB memory sticks; there are reports here of people having corrupted files as a result. If you need to store data on a USB stick, save it to the normal hard drive, then copy to USB, making sure you observe the correct removal procedures.

A good day, another happy customer :-)
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1963
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Hint] How did I fix my ODT file

Postby sukivalencia » Wed Aug 15, 2018 12:26 am

I have a corrupted ODT file that means many months of hard work

please help us recover it

this is the link https://drive.google.com/file/d/10EmGTL ... sp=sharing

anything you can get, saves us from a lot of chaos on future weeks, thank you
openoffice 4 on windows 7
sukivalencia
 
Posts: 2
Joined: Tue Aug 14, 2018 11:48 pm

Re: [Hint] How did I fix my ODT file

Postby robleyd » Wed Aug 15, 2018 2:35 am

Unfortunately that file is damaged such that I cannot open it and access the contents; perhaps others will try. If you have backups, now is the time to use them.

If not, I suggest you try and recover any temporary files that Writer may have created - see [Tutorial] How to find and un-delete Writer temporary files. Do this as soon as possible.

If you aren't using some backup procedure, you might consider Timestamped backup
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1963
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Hint] How did I fix my ODT file

Postby John_Ha » Wed Aug 15, 2018 12:55 pm

sukivalencia wrote:I have a corrupted ODT file that means many months of hard work

robleyd wrote:perhaps others will try

I am sorry but the file is not an AOO file - it is random garbage and there is no user data anywhere in it.
AOO 4.1.5, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 5689
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: [Hint] How did I fix my ODT file

Postby sukivalencia » Thu Aug 16, 2018 1:55 am

Thank you for trying =)

I have the recovered files, but seem to be the same story, here they are

https://drive.google.com/open?id=1ZGmfE ... irfIVDxIIS

=)
openoffice 4 on windows 7
sukivalencia
 
Posts: 2
Joined: Tue Aug 14, 2018 11:48 pm

Re: [Hint] How did I fix my ODT file

Postby robleyd » Thu Aug 16, 2018 7:25 am

Unfortunately you are right - there is nothing recoverable in those files.
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1963
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Hint] How did I fix my ODT file

Postby lexroadie7 » Sat Aug 25, 2018 5:18 pm

Hi everyone! I've got an odt file which has been deleted by error and then recovered using DMDE, but unfortunately seems that files on the inside are gone (especially content.xml), because when i zipped with winrar it tells me that archive is damaged or in a unknown format.

By the way, if somebody wanna try to take a look would be great, thanks in advance!
Attachments
report.odt
(26.97 KiB) Downloaded 15 times
OpenOffice 3.4.1 Windows 8.1
lexroadie7
 
Posts: 1
Joined: Sat Aug 25, 2018 4:57 pm

Re: [Hint] How did I fix my ODT file

Postby robleyd » Sun Aug 26, 2018 1:47 am

Unfortunately there is nothing recoverable in the file you posted; it is not even a valid .odt file
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1963
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Hint] How did I fix my ODT file

Postby Nteuzz » Thu Sep 13, 2018 8:30 pm

Hello,

something have happened to my huge .odt file which contains close to 240 pages. It took me 2 years to work on it and I am really not sure what to do.
A week ago, I shutdown my windows based computer and the next day all text was changed to "###############" :crazy:
The article is written in French and Russian.

I have tried the methods described here, but I am not able to get context.xml file.

Could any one please help me? :oops:

Let me add google drive link as well, as .zip version has a tiny size.
Google drive: https://drive.google.com/file/d/0B0AW7JnR0RAPLU9qd1NOUG9RSjRCMnNsdTdjc1F1QzJ5VUFV/view?usp=sharing
Attachments
stat'yaFDS - Copy.zip
File copy
(943 Bytes) Downloaded 1 time
Last edited by Nteuzz on Thu Sep 13, 2018 9:41 pm, edited 2 times in total.
OppenOffice 4.1.15 on Ubuntu, Mac and Windows 10!
Nteuzz
 
Posts: 4
Joined: Thu Sep 13, 2018 8:20 pm

Re: [Hint] How did I fix my ODT file

Postby RoryOF » Thu Sep 13, 2018 9:14 pm

Forget that copy of the file, there will be nothing in it; the size alone indicates that.


Do what this tutorial suggests
[Tutorial] How to find and un-delete AOO temporary files

If that doesn't help download Recuva or PhotoRec (only one needed) and let it do an indepth recovery of deleted files on your computer. You may get a file containing some or all of your data (or not). Do this as a first priority; other use of the computer may overwrite any existing but deleted files and prevent their recovery. There is no guarantee that you will recover anything useful.

Do the above soonest!
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 27182
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Hint] How did I fix my ODT file

Postby Nteuzz » Thu Sep 13, 2018 9:45 pm

RoryOF wrote:Forget that copy of the file, there will be nothing in it; the size alone indicates that.


Do what this tutorial suggests
[Tutorial] How to find and un-delete AOO temporary files

If that doesn't help download Recuva or PhotoRec (only one needed) and let it do an indepth recovery of deleted files on your computer. You may get a file containing some or all of your data (or not). Do this as a first priority; other use of the computer may overwrite any existing but deleted files and prevent their recovery. There is no guarantee that you will recover anything useful.

Do the above soonest!


Running recuva in deep scan mode. Last two attempts it froze, so I am doing it again.
How do I identify the file I need as .tmp copies might have a random name?
OppenOffice 4.1.15 on Ubuntu, Mac and Windows 10!
Nteuzz
 
Posts: 4
Joined: Thu Sep 13, 2018 8:20 pm

Re: [Hint] How did I fix my ODT file

Postby RoryOF » Thu Sep 13, 2018 9:49 pm

Look at their timestamps. Before opening them you will need to rename them to the file type you were using.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 27182
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Hint] How did I fix my ODT file

Postby Nteuzz » Sun Sep 16, 2018 8:19 am

After 3 scans with Recuva I was not able to find good copy.

I mean I did see deleted copies of my article, but they were all bad. I tried to restore old .odt,tmp and bak files. Out of 12-15 which I have tried only 2 were in OK condition but were one of the early copies (30 pages out of 120) .

I also uninstalled all windows updates which were auto installed at the date of the event. :knock:

Next thing I did, I used ShadowExplorer, and on the first attempt was able to retrieve semi decent copy of my article. Decent in a sense that at least I am able to get context.xml
I am going to continue tomorrow, got too tired after working on this for 13 hours.
Meanwhile, could anyone please try to fix content.xml? :fist:
https://drive.google.com/open?id=1KCkbg ... p1R6TcgzkF
OppenOffice 4.1.15 on Ubuntu, Mac and Windows 10!
Nteuzz
 
Posts: 4
Joined: Thu Sep 13, 2018 8:20 pm

Re: [Hint] How did I fix my ODT file

Postby RoryOF » Sun Sep 16, 2018 8:57 am

My first attempt tells me that content.xml is badly damaged and my tools refuse to open it. This makes sense in a damaged file, as I suspect content.xml is the last file written and often in a damaged file space is reserved for it, but the computer has closed down before the content was written to the reserved space.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 27182
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Hint] How did I fix my ODT file

Postby RoryOF » Sun Sep 16, 2018 9:06 am

If you have a printout, consider scanning and OCRing the printout to restore your text to that time.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 27182
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Hint] How did I fix my ODT file

Postby Nteuzz » Sun Sep 16, 2018 4:44 pm

RoryOF wrote:My first attempt tells me that content.xml is badly damaged and my tools refuse to open it. This makes sense in a damaged file, as I suspect content.xml is the last file written and often in a damaged file space is reserved for it, but the computer has closed down before the content was written to the reserved space.


Thank you RoryOF very much for your time taken to check the files.
OppenOffice 4.1.15 on Ubuntu, Mac and Windows 10!
Nteuzz
 
Posts: 4
Joined: Thu Sep 13, 2018 8:20 pm

Re: [Hint] How did I fix my ODT file

Postby zillahmtl » Mon Sep 17, 2018 10:00 pm

Help!!! I just had the problem mentioned in the post but I don't have the knowledge to achieve the steps!

Can anybody help me please? I need to submit that paperwork in less than 8 hours :-(

Thanks in advance for the help!!
Last edited by robleyd on Tue Sep 18, 2018 1:20 am, edited 1 time in total.
Reason: Remove Known Issues icon [robleyd, Moderator]
OpenOffice 5.4 on Windows Vista
zillahmtl
 
Posts: 1
Joined: Mon Sep 17, 2018 9:57 pm

Re: [Hint] How did I fix my ODT file

Postby robleyd » Tue Sep 18, 2018 1:19 am

Upload the file. [Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here.
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1963
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Previous

Return to Writer

Who is online

Users browsing this forum: No registered users and 33 guests