[Hint] How did I fix my ODT file
Re: [Hint] How did I fix my ODT file
It's very hard to do anything but guess without having the actual (.odt) file to look at. I'm sure if you can attach it here, or upload it somewhere else and give us a link, that someone can take a look and see if anything can be recovered.
You can use the "Upload Attachment" link (below the message entry area after you click "POST REPLY"). [Forum] How to attach a document here
You can use the "Upload Attachment" link (below the message entry area after you click "POST REPLY"). [Forum] How to attach a document here
AOO4/LO5 • Linux • Fedora 23
-
- Posts: 2
- Joined: Thu Dec 09, 2010 1:08 am
Re: [Hint] How did I fix my ODT file
Hi acknak.
Thanks for your quick reply. I will attach the troubled document.
I read on another forum that images in OOo are by default linked rather than embedded when pasted into a document. Not realizing this, I deleted the image that I had pasted into this document off the hard drive and I think that's what caused this file to go hay-wire.
Thanks for your quick reply. I will attach the troubled document.
I read on another forum that images in OOo are by default linked rather than embedded when pasted into a document. Not realizing this, I deleted the image that I had pasted into this document off the hard drive and I think that's what caused this file to go hay-wire.
- Attachments
-
- fix.odt
- This is the file that has garbled text in the content.xml
- (57.51 KiB) Downloaded 6297 times
OOo 2.4.1 on Windows XP SP2
Re: [Hint] How did I fix my ODT file
Sorry, I don't know of anything that can be done with it. This type of damage is new to me; it looks like some binary data was saved in the document archive in place of the document content. Very strange.
There is an intact image in the file, some kind of process flowchart. That can be recovered easily, but I presume that you still have the original image as a separate file.
There is an intact image in the file, some kind of process flowchart. That can be recovered easily, but I presume that you still have the original image as a separate file.
AOO4/LO5 • Linux • Fedora 23
Re: [Hint] How did I fix my ODT file
I could get nothing from it. I also looked to see if content.xml was (incorrectly ) some form of archive, but again, nothing.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: [Hint] How did I fix my ODT file
Hi,
Could you guys check on this file?
Tried several ways, none seems to be working.
I would be very thankfull
http://www.mediafire.com/?b53evbgbn8zxz3g
Could you guys check on this file?
Tried several ways, none seems to be working.
I would be very thankfull
http://www.mediafire.com/?b53evbgbn8zxz3g
OpenOffice 3.1 on Windows 7x64
Re: [Hint] How did I fix my ODT file
Try this one: uk op 6_recovered.ods
Let me know when you have it and I'll remove the link+file.
Let me know when you have it and I'll remove the link+file.
Last edited by acknak on Wed Feb 02, 2011 12:45 am, edited 1 time in total.
Reason: removed sample file
Reason: removed sample file
AOO4/LO5 • Linux • Fedora 23
Re: [Hint] How did I fix my ODT file
Works! Thanks a bunch!
What was the problem? Invalid characters or style errors?
What was the problem? Invalid characters or style errors?
OpenOffice 3.1 on Windows 7x64
Re: [Hint] How did I fix my ODT file
Yes; there was a single invalid character in the content.xml.
All I had to do was pass the content.xml file through an xml syntax checker ("xmllint") which found that In one attribute "office:value-type="float", the dash character was replaced with a Ctrl+A (0x01) character.
Once I replaced the invalid character with the hyphen, and replaced the content.xml in the archive, the document opened fine.
All I had to do was pass the content.xml file through an xml syntax checker ("xmllint") which found that In one attribute "office:value-type="float", the dash character was replaced with a Ctrl+A (0x01) character.
Once I replaced the invalid character with the hyphen, and replaced the content.xml in the archive, the document opened fine.
AOO4/LO5 • Linux • Fedora 23
Re: [Hint] How did I fix my ODT file
Could anyone help me repair this file?
I already tried to delete all data between "<office:automatic-styles>" and "</office:automatic-styles>" without any results.
A lot of thanks in advance.
I already tried to delete all data between "<office:automatic-styles>" and "</office:automatic-styles>" without any results.
A lot of thanks in advance.
Edit: Hagar (Moderator): file removed. |
Open Office 3.2.1
Windows 7
Windows 7
- Hagar Delest
- Moderator
- Posts: 32657
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: [Hint] How did I fix my ODT file
I've sent you a PM with the recovered file. Since there are some personal data inside, I've removed it from your post.
I think that the file has been cropped, that is the end of the content.xml file has not been correctly written. So by adding the tags that close the document, I've saved what was before the "cut". Don't know how much I've recovered.
I think that the file has been cropped, that is the end of the content.xml file has not been correctly written. So by adding the tags that close the document, I've saved what was before the "cut". Don't know how much I've recovered.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
- Hagar Delest
- Moderator
- Posts: 32657
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: [Hint] How did I fix my ODT file
Just for the record, do you have suffered a heavy data loss or just some bits?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: [Hint] How did I fix my ODT file
No, the data is pretty much intact.
Open Office 3.2.1
Windows 7
Windows 7
Re: [Hint] How did I fix my ODT file
i am having tough time recovering attached file. I did file recovery using Recuva after accidental mess up deleting files. i have few about 30 files like this state. If somebody can help on this and guide how i might recover rest of the file using same pattern would be much appreciated
- Attachments
-
- vitamins.odt
- (23.12 KiB) Downloaded 4951 times
OpenOffice.org 3 windows xp
Re: [Hint] How did I fix my ODT file
Sorry, but the file you attached does not contain the document's data. It seems to contain random information from other files on the system.
There's nothing there to recover.
There's nothing there to recover.
AOO4/LO5 • Linux • Fedora 23
Re: [Hint] How did I fix my ODT file
Similar but different . Did a search ref above if this is wrong place let me know and I'll change
I don't get the above error code.
When I try to open the hour glass shows up , have it left run several hours with no joy, the task manager reports running ( no non_ responding report). When I terminate the process with the task manger then this file shows up .~lock.simplification of meshes.odt# Have deleted all my OO programs via the add and remove route, including those left behind form previous installs, cleaned the registry, ran virus check and then installed latest OO 3.3 ( The problem file is a 3.2 version). The results are the same. Have not tried any fixes ref above. Should I try the above or should I attach file. It is large 1.5 MB??
Ran the validator and it showed 11 warnings and this error;
This file is NOT valid
Result details:
upload:///simplification of meshes.odt/META-INF/manifest.xml[2,88]:Error:element "manifest:manifest" is missing "version" attribute
upload:///simplification of meshes.odt:Info:Generator: OpenOffice.org/3.2$Win32 OpenOffice.org_project/320m18$Build-9502
I don't have a manifest .xml but have a mainfest.rdf.
I extracted the files by rename of my file from xxxx.odt to xxxx.zip and then extracted and then changed back for the above test
I don't get the above error code.
When I try to open the hour glass shows up , have it left run several hours with no joy, the task manager reports running ( no non_ responding report). When I terminate the process with the task manger then this file shows up .~lock.simplification of meshes.odt# Have deleted all my OO programs via the add and remove route, including those left behind form previous installs, cleaned the registry, ran virus check and then installed latest OO 3.3 ( The problem file is a 3.2 version). The results are the same. Have not tried any fixes ref above. Should I try the above or should I attach file. It is large 1.5 MB??
Ran the validator and it showed 11 warnings and this error;
This file is NOT valid
Result details:
upload:///simplification of meshes.odt/META-INF/manifest.xml[2,88]:Error:element "manifest:manifest" is missing "version" attribute
upload:///simplification of meshes.odt:Info:Generator: OpenOffice.org/3.2$Win32 OpenOffice.org_project/320m18$Build-9502
I don't have a manifest .xml but have a mainfest.rdf.
I extracted the files by rename of my file from xxxx.odt to xxxx.zip and then extracted and then changed back for the above test
OOo 3.2+, Windows Xp Pro sp3 P4 3.2Ghz, 4Gb memory, 600 GB hard disk
Re: [Hint] How did I fix my ODT file
It's probably simplest to make the file available so others can try it--if the file works for others, then we'll know it's not a problem with the file. The validator sometimes complains about things that OOo doesn't care about.
You can use the "Upload Attachment" link (below the message entry area after you click "POST REPLY"). [Forum] How to attach a document here
Note: large documents have to be shared through some other means; there are suggestions in the link above.
You can use the "Upload Attachment" link (below the message entry area after you click "POST REPLY"). [Forum] How to attach a document here
Note: large documents have to be shared through some other means; there are suggestions in the link above.
AOO4/LO5 • Linux • Fedora 23
Re: [Hint] How did I fix my ODT file
Up date;
ajut001 determined what to do but I did change the flow a little:
1) Unzip the xxxxxx.zip ( the original xxxxx.odt OO with extension change) . I use Zip Genius for this. ;
2) Open the xml file using the xml NotePad 2007 I downloaded form Microsoft. The program has a tree capability so search for the target to delete is not required because it appears in the top level of the hierarchy;
2) Delete target and save file;
4) Select this save file and the others extracted from the xxxxxx.zip and use Zip Genius to make a archive;
5) Save archive and change file name back to xxxxxxx.odt
File now opens OK. It appears the number of jpg's I had in th file were causing the problem. File must be re- formatted and pictures re-inserted.
How does one avoid this goat rope in the future
I was very close to submitting this as a WIKI and these problems are not acceptable.
ajut001 determined what to do but I did change the flow a little:
1) Unzip the xxxxxx.zip ( the original xxxxx.odt OO with extension change) . I use Zip Genius for this. ;
2) Open the xml file using the xml NotePad 2007 I downloaded form Microsoft. The program has a tree capability so search for the target to delete is not required because it appears in the top level of the hierarchy;
2) Delete target and save file;
4) Select this save file and the others extracted from the xxxxxx.zip and use Zip Genius to make a archive;
5) Save archive and change file name back to xxxxxxx.odt
File now opens OK. It appears the number of jpg's I had in th file were causing the problem. File must be re- formatted and pictures re-inserted.
How does one avoid this goat rope in the future
I was very close to submitting this as a WIKI and these problems are not acceptable.
OOo 3.2+, Windows Xp Pro sp3 P4 3.2Ghz, 4Gb memory, 600 GB hard disk
Re: [Hint] How did I fix my ODT file
Hello,
Can someone fix my file, 6 months of work is in this file.
It's a spreadsheet and the error is:
Error in subdocument content.xml on position 2,528190 (row,column).
I've tried every tip in this forum, still Ooo refuses to read.
http://www.mediafire.com/?7oz2hf5f3skf5hn
Regards,
Boudewijn
Can someone fix my file, 6 months of work is in this file.
It's a spreadsheet and the error is:
Error in subdocument content.xml on position 2,528190 (row,column).
I've tried every tip in this forum, still Ooo refuses to read.
http://www.mediafire.com/?7oz2hf5f3skf5hn
Regards,
Boudewijn
OpenOffice 3.3.0 on Windows Vista / LibreOffice 3.4.0 on Windows Vista / LibreOffice 3.3.0 on openSUSE
Re: [Hint] How did I fix my ODT file
Try this one: Dagboeken 2011_recovered.ods
Do remember to make regular backup copies of important documents. Every time you open a document you're taking a chance that it will be corrupted or lost. Your only real protection is to make backup copies regularly, using different file names.
Do remember to make regular backup copies of important documents. Every time you open a document you're taking a chance that it will be corrupted or lost. Your only real protection is to make backup copies regularly, using different file names.
AOO4/LO5 • Linux • Fedora 23
Re: [Hint] How did I fix my ODT file
Thanks it worked,
and I will start immediate with a daily backup system. I had but didn't installed it on my new file server yet.
I don't know why but I opened this file in Libre Office 3.4.0 did some work in it saved it, got some error, saved it again without any warning now so I assumed it was ok. A few days later found this error.
What was wrong with the file because I could not find the "real" error. The validator http://tools.services.openoffice.org/odfvalidator/ of Ooo gave me some errors in some columns but still couldn't open it after fixing most of them.
Which tool you used to edit the xml file, notepad++ was terribly slow editing such a big file.
Regards,
Boudewijn
and I will start immediate with a daily backup system. I had but didn't installed it on my new file server yet.
I don't know why but I opened this file in Libre Office 3.4.0 did some work in it saved it, got some error, saved it again without any warning now so I assumed it was ok. A few days later found this error.
What was wrong with the file because I could not find the "real" error. The validator http://tools.services.openoffice.org/odfvalidator/ of Ooo gave me some errors in some columns but still couldn't open it after fixing most of them.
Which tool you used to edit the xml file, notepad++ was terribly slow editing such a big file.
Regards,
Boudewijn
OpenOffice 3.3.0 on Windows Vista / LibreOffice 3.4.0 on Windows Vista / LibreOffice 3.3.0 on openSUSE
- Hagar Delest
- Moderator
- Posts: 32657
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: [Hint] How did I fix my ODT file
Don't know for acknak but personally, I use XML Copy Editor (both on Windows and GNU/Linux) and it works fine, it can check the XML structure directly so you can undo modifications if you introduce errors.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: [Hint] How did I fix my ODT file
Any software that I've ever tried for working with ODF's xml has been very unpleasant--either too slow or somehow unable to cope with OOo's "all in one line" xml, or an xml file that OOo has made a hash of.
I generally use two command-line utilities and a plain text editor. Emacs is my text editor; xmlindent is handy to re-format OOo's all-in-one-line xml, and xmllint tries to check an xml file for errors.
In this case, the problem turned out to be very easy to deal with.
Xmllint gave me this output:
I used a text editor to remove the first set of attribute values, leaving only the second set, shown in blue. I then updated the content.xml file in your document with the modified one and that opened without errors in Calc.
I generally use two command-line utilities and a plain text editor. Emacs is my text editor; xmlindent is handy to re-format OOo's all-in-one-line xml, and xmllint tries to check an xml file for errors.
In this case, the problem turned out to be very easy to deal with.
Xmllint gave me this output:
- $ xmlindent -i2 content.xml | xmllint -noout -
-:4725: parser error : Attribute table:end-cell-address redefined
-:4725: parser error : Attribute table:end-x redefined
-:4725: parser error : Attribute table:end-y redefined
-:4725: parser error : Attribute draw:z-index redefined
- <table:table-cell table:end-cell-address="'Kasboek per dag'.J42" table:end-x="0.926cm" table:end-y="0.417cm" draw:z-index="0" table:end-cell-address="'Kasboek per dag'.J40" table:end-x="0.476cm" table:end-y="0.365cm" draw:z-index="0" table:style-name="ce251" office:value-type="string" table:number-columns-spanned="6" table:number-rows-spanned="2">
I used a text editor to remove the first set of attribute values, leaving only the second set, shown in blue. I then updated the content.xml file in your document with the modified one and that opened without errors in Calc.
AOO4/LO5 • Linux • Fedora 23
Re: [Hint] How did I fix my ODT file
I don't know if you guys are still helping out people with file errors, I've tried all the things listed and at wits end right now. Wondering if anyone can help out with a file. I've posted it http://www.mediafire.com/file/4ou69opcq ... orynew.ods
Thank you for the help, I used ALZIP to unzip the file so I will upload that content.xml http://www.mediafire.com/?qd24fb2u18d98p6
Thank you for the help, I used ALZIP to unzip the file so I will upload that content.xml http://www.mediafire.com/?qd24fb2u18d98p6
Last edited by n1120ec on Tue Oct 11, 2011 8:57 pm, edited 1 time in total.
Openoffice 3.3 Windows 7
Re: [Hint] How did I fix my ODT file
There's a problem with your file: I couldn't extract content.xml so I downloaded a demo of ZipRepair Pro to see if I could repair it and it reports that the filesize of the archive seems to be incorrect. To be sure, a compression of 95% seems a bit much. I'm afraid that part of the file got truncated and that content.xml can't be recovered.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
- Hagar Delest
- Moderator
- Posts: 32657
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: [Hint] How did I fix my ODT file
I managed to extract the content.xml file (but having the CRC error). Managed to get a part of it in vi but no way to make it displayed in Gedit or XML Copy Editor so not sure it can be recovered.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: [Hint] How did I fix my ODT file
Do you guys think if I use Sysinfo tools for Calc recovery to fix, if it would work???? And thank you guys for all the help
Openoffice 3.3 Windows 7
Re: [Hint] How did I fix my ODT file
Sadly no.n1120ec wrote:Do you guys think if I use Sysinfo tools for Calc recovery to fix, if it would work? And thank you guys for all the help
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
Gurkha Welfare Trust
Re: [Hint] How did I fix my ODT file
The text in the content.xml file is very badly garbled. I very much doubt that any usable data can be recovered from it, by any tool. The only solution is a backup file.
AOO4/LO5 • Linux • Fedora 23
Re: [Hint] How did I fix my ODT file
Maybe you can recover a previous version of the file:
Previous versions of files: frequently asked questions
Previous versions of files: frequently asked questions