[Hint] How did I fix my ODT file

Discuss the word processor

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

Postby RoryOF » Mon Jan 08, 2018 7:54 pm

Try the attached. The problem was one Comment which seemed to be repeated three times. I removed two of the repeats, but cannot now see the remaining comment.

 Edit: File deleted for confidentiality 
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: 26942
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby Blazej_Zych » Mon Jan 08, 2018 7:58 pm

RoryOF wrote:Try the attached. The problem was one Comment which seemed to be repeated three times. I removed two of the repeats, but cannot now see the remaining comment.


Great!!! thank you very much!! it works properly. Can you make me a favour and delete repaired file from here? There is private data...
OpenOffice 3.1 on Windows 10
Blazej_Zych
 
Posts: 2
Joined: Mon Jan 08, 2018 7:20 pm

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

Postby agusia » Tue Jan 09, 2018 1:23 pm

Thank you keme for your advice. Actually, one of the functions of omega t is to be able to keep the styles from the original "source" document and apply them automatically to the translated, "target" document. So with omega t i can see a lot of tags along the text but I'm not really able to - and I shouldn't, for the purpose of having an already properly formatted translated text - modify or delete them. An error probably occurred somewhere along the way, though, and this is what RoryOF managed to fix... But the error is still present in the omega t file, and is being rewritten each time I generate the file again...
Apache OpenOffice 4.1.0
Mac OS X 10.9.3
agusia
 
Posts: 9
Joined: Wed Jul 15, 2015 5:28 pm

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

Postby dod » Fri Jan 19, 2018 11:55 pm

can someone please take a look at this and see if they can recover anything I have tried so many things that I have found on this site with no luck.
thanks for any and all help.
Attachments
Sin título 1.odt
(34.19 KiB) Downloaded 123 times
Windows 10, OpenOffice 4.1.1
dod
 
Posts: 5
Joined: Fri Jan 19, 2018 11:53 pm

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

Postby robleyd » Sat Jan 20, 2018 2:05 am

Is that file the one which you have already tried to repair? If so, do you have the original before your repair attempts?

The file supplied is not anything like a Writer 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: 1849
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

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

Postby dod » Sat Jan 20, 2018 10:05 am

This file is the one that I recovered with easeus, unfortunately I do not have another.
With recovering the text plan I would be more than happy.
thank you very much
Windows 10, OpenOffice 4.1.1
dod
 
Posts: 5
Joined: Fri Jan 19, 2018 11:53 pm

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

Postby John_Ha » Sat Jan 20, 2018 10:54 am

 Edit: Tutorial added 


See [Tutorial] How to fix SAXParse errors in LibreOffice .docx files or [Tutorial] Format error discovered in sub-document for full instructions to recover the text.
Last edited by John_Ha on Wed Aug 08, 2018 12:19 pm, edited 1 time in total.
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 dod » Sat Jan 20, 2018 11:55 am

my document was done with OpenOffice, your link is for LibreOffice, am I wrong?
Windows 10, OpenOffice 4.1.1
dod
 
Posts: 5
Joined: Fri Jan 19, 2018 11:53 pm

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

Postby robleyd » Sat Jan 20, 2018 1:17 pm

The link is for documents saved as .docx from LibreOffice; your issue is a file with .odt extension which does not have the format of a .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: 1849
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

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

Postby dod » Sat Jan 20, 2018 7:32 pm

Attach another version of the file...
Attachments
Sin título 1.odt
(30.24 KiB) Downloaded 123 times
Windows 10, OpenOffice 4.1.1
dod
 
Posts: 5
Joined: Fri Jan 19, 2018 11:53 pm

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

Postby John_Ha » Sat Jan 20, 2018 9:52 pm

dod wrote:my document was done with OpenOffice, your link is for LibreOffice, am I wrong?

1. Extract content.xml from the .odt
2. Edit as described in the 3rd method where you delete all tags and are left with just the text.

It is identical for .odt written by AOO or LO and identical for .docx files - just extract \word\document.xml
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 dod » Sat Jan 20, 2018 11:28 pm

With zip extension it is not possible to open the archive, so I can not open the xml

Thank you very much
Windows 10, OpenOffice 4.1.1
dod
 
Posts: 5
Joined: Fri Jan 19, 2018 11:53 pm

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

Postby RoryOF » Sat Jan 20, 2018 11:31 pm

When the .zip file does not open, it can sometimes be possible to repair it (at least partially) with powerful archive diagnostics. I tried using two applications of increasing power and got no results. I fear your file is lost beyond recovery.
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: 26942
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby volcano » Tue Jan 23, 2018 1:50 pm

Hello!
Could you please help me recover this file? Thanks in advance.
Attachments
1.odg
(53.46 KiB) Downloaded 28 times
LibreOffice 5.4 on Windows 10
volcano
 
Posts: 2
Joined: Tue Jan 23, 2018 1:34 pm

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

Postby RoryOF » Tue Jan 23, 2018 2:15 pm

Try the attached. Please ensure that formatting and content are as you require.
Attachments
1_repaired.odg
(53.25 KiB) Downloaded 23 times
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: 26942
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby robleyd » Tue Jan 23, 2018 2:31 pm

And another version of a network diagram.
repaired.odg
(54.61 KiB) Downloaded 22 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: 1849
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

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

Postby volcano » Tue Jan 23, 2018 3:02 pm

RoryOF wrote:Try the attached. Please ensure that formatting and content are as you require.

Thank you very much! Everything works fine.
LibreOffice 5.4 on Windows 10
volcano
 
Posts: 2
Joined: Tue Jan 23, 2018 1:34 pm

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

Postby Lapprentis » Tue Jan 23, 2018 9:49 pm

I have tried to fix a ODT file myself but without success: I have limited computering skills,,,,Can someone help me ? Thanks. File is too big to put here: If someone can contact me to my email, I would send it back ! Thanks. Just add the @
lapprentis777 gmail.com
OpenOffice 4.5.1 Windows 7
Lapprentis
 
Posts: 1
Joined: Tue Jan 23, 2018 9:37 pm

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

Postby robleyd » Wed Jan 24, 2018 12:40 am

Alternatively you could upload the file to a file sharing service 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: 1849
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

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

Postby agusia » Tue Jan 30, 2018 1:47 am

Hello everyone,

Here is the file that I finished translating with the free software i am using (OmegaT). earlier this month RoryOF was able to repair an earlier version of the file, but unfortunately each time I generated it again from the software the error came back. So here is the final version, I tried to fix it myself once again but failed... (This is not the version I tried to fix). Here is the error message: Format error discovered in the file in sub-document content.xml at 2,66113(row,col). Thank you very much for your help!
 Edit: File deleted as requested by the OP - FJCC 
Apache OpenOffice 4.1.0
Mac OS X 10.9.3
agusia
 
Posts: 9
Joined: Wed Jul 15, 2015 5:28 pm

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

Postby robleyd » Tue Jan 30, 2018 5:04 am

Try this - I got 32 pages after repair.

 Edit: File deleted as requested by the OP - FJCC 
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1849
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

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

Postby agusia » Tue Jan 30, 2018 5:21 pm

Thank you so much, this is perfect! I hope in the future I won't have the same problem with this software. Could it be possible to delete the file (including in its earlier version posted on January 8), since this is unpublished translation of a text I don't personally own the rights for? Thank you again everyone for your precious help.
Apache OpenOffice 4.1.0
Mac OS X 10.9.3
agusia
 
Posts: 9
Joined: Wed Jul 15, 2015 5:28 pm

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

Postby Pangloss » Wed Feb 28, 2018 11:31 pm

Had a hard drive failure, went to go find an old backup copy of the file to find they were corrupted! I've got these two copies of the file with slightly different file sizes. Changing it to a .zip isn't recognized as an archive. If there is anything you can do that would be amazing.

Thank you for anything you can do!
Attachments
Corrupted Document Two.odt
(31.98 KiB) Downloaded 113 times
Corrupted Document.odt
(35.21 KiB) Downloaded 108 times
OOo v3.5.1 on Win7
Pangloss
 
Posts: 1
Joined: Wed Feb 28, 2018 11:22 pm

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

Postby John_Ha » Thu Mar 01, 2018 12:34 am

Welcome to the forum.

I am sorry to have to tell you that both the files you uploaded are complete gibberish from start to end and there is no recoverable data in either. I examined them with a Hex editor (HxD) and they just have random junk in them. As you found, ODT files are ZIP files and your files are not ZIP files.

There is no hope of getting anything from them.

You say you had a disk crash. If just Windows got corrupted, and the data may still be OK, install the drive in another PC (or connect to a USB port with an adapter) and see [Tutorial] How to find and un-delete Writer temporary files for
a) detailed instructions on how to recover your file as it was when you last opened or saved it, or as it was when it was last saved with AutoRecovery.
b) how to find previous versions of the file in the folder it is located in, but which have since been deleted.
c) how to un-delete the temporary files Writer wrote while you were editing the file, and then deleted.

Clipboard01.gif
Random binary junk - not a ZIP file which begins with PK

As a new poster you will find much useful information in the Writer FAQ, the Writer Tutorials, the up to date Writer guide and the Writer Manual. May I suggest you bookmark the pages.

When a pop-up window opens, click the Help button for extensive help on that function - it is often more comprehensive than the manual.
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 LovingLife139 » Fri Mar 23, 2018 6:15 am

Hi there...I've been having issues with Windows 10 shutting down randomly which keeps messing with OpenOffice. Was in the midst of trying to get that fixed when it corrupted the most important file I have on my computer. I was hoping someone could help me and see if there is anything recoverable. There are 60,000 words on the line so I'm hoping to recover as much as possible; my last recoverable back-up was 30K words ago. I've been working on this for ten hours and can't seem to make progress, but I don't know that I'm even doing it right. The original file was giving me nothing but pound signs and during my attempts to fix it today I've been getting nothing but gibberish. I have bought and used the EaseUS Data Recovery program and have been trying to follow directions to convert zip files but keep getting a "Unable to find the local header for content.xml" message.

The .odt file is too big (152 KB) to post here so I am attaching a .zip file of the original and a .zip file of one of the older "recovered" files from EaseUS. Please let me know if there's anything more I need to do or if anyone can help me recover anything. Thank you so, so much for anything you can do and/or recover. I'm at my wit's end trying to figure this out. :cry:
Last edited by FJCC on Fri Mar 23, 2018 6:47 pm, edited 1 time in total.
Reason: Attached files deleted per user request.
OpenOffice 4 on Windows 10
LovingLife139
 
Posts: 2
Joined: Fri Mar 23, 2018 5:29 am

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

Postby RoryOF » Fri Mar 23, 2018 10:59 am

I got nothing usable from either.
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: 26942
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby John_Ha » Fri Mar 23, 2018 11:04 am

Both files are completely corrupted and there is no user data in either file.

Neither of the files is a proper .odt file: one is full of NULL characters (which is why the zip file is tiny) and the other has random junk in it with a tiny extract of some AOO metadata.

Your only hope is to see [Tutorial] How to find and un-delete Writer temporary files for
a) detailed instructions on how to recover your file as it was when you last opened or saved it, or as it was when it was last saved with AutoRecovery.
b) how to find previous versions of the file in the folder it is located in, but which have since been deleted.
c) how to un-delete the temporary files Writer wrote while you were editing the file, and then deleted. This will recover your file as it was when you last opened or you last saved it and is probably your best hope.
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 LovingLife139 » Fri Mar 23, 2018 6:25 pm

Thank you both so much for trying. If it helps anyone else in the future, learn from my mistakes: Windows 10 has been shutting down randomly despite all tried fixes other than reinstalling the OS. It was messing with OpenOffice for obvious reasons and it got to the point where I couldn't edit my WIP because it would lock it as read-only. I scoured the internet for fixes and someone suggested turning off the OpenOffice AutoRecovery and back-ups. I did. It solved my problem and I could then edit and save my document. I was backing it up in other ways (clearly not often enough) when this happened. Because of the "fix" for the other issue, I now have lost half of my work and am devastated. I'm not sure what the answer is to the first issue I had, but don't fix it like I did since it can lead to not having those extra "just in case" files.

Thank you again. I went through your posted link, John, and all of those steps are what I tried to do yesterday, unfortunately. Can I request that someone delete the two files I left in my last post? Not that it matters content-wise since the file is gibberish, but the work is my own copyright.
OpenOffice 4 on Windows 10
LovingLife139
 
Posts: 2
Joined: Fri Mar 23, 2018 5:29 am

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

Postby RoryOF » Fri Mar 23, 2018 7:10 pm

On any work of major importance, be it a thesis, or The Great American Novel, we strongly recommend making regular (daily?, hourly?) timed/dated backups. Alternately, you can install the extension to automatically make such backup. This is at
http://www.flowcont.hu/LO_oxt_store/oxt/timeStampBackup_v1-1-6.oxt

On my works in progress I make daily dated backups manually - doing so means I know they have been done and I am not subject to failure of any automation.
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: 26942
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby Zizi64 » Sat Mar 24, 2018 8:12 am

timeStampBackup on the GitHub (mainteined by my son, Levente Kovács) :

The https://github.com/kovleventer/timeStampBackup
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7002
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

PreviousNext

Return to Writer

Who is online

Users browsing this forum: No registered users and 26 guests