Ask Your Question

How to unzip ODB file and edit the content.xml file to fix Firebird bug?

asked 2018-10-19 03:32:54 +0200

sdritchey gravatar image

updated 2018-10-19 06:52:31 +0200

Ratslinger gravatar image

I'm attempting to unzip an ODB file and manually edit the content.xml file on MacOS. For some reason the built-in Archive Utility will not unzip the ODB file.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-19 03:47:22 +0200

Ratslinger gravatar image

updated 2018-10-19 06:30:31 +0200



Please note that this question and answer were in direct response to comments on this post -> firebird_sdbc error.

End Edit

Instead of editing the content.xml file here may be a quicker method. Running from a macro.

If you are having problems with a resolution to Bug #117053, Firebird files created with parameter name substitution disabled, this may be a solution for you.

I have created a simple extension with the necessary macro code to fix the problem. Download the extension:

The file needs to be renamed from:




as this site doesn't allow this extension to be downloaded (HUH!???!!).

Extension to download ----- FireBirdParameterFix.odt

Don't forget to rename!

Then just install the extension. On most systems you can just double click the file & the install will begin. If not, install from any open document from the menu -> Tools->Extension Manager...

Select the Add button and point to the above .oxt file. This installs the necessary macro in MyMacros.

Close any and ALL LibreOffice files. Open the problem Firebird Base file. On the main screen run a macro from the menu -> Tools->Macros->Run Macro...

Under Library section, click on + left of MyMacros. Find FireBirdParameterFix and click on that +:

image description

Left mouse click on Module1 and Macro Name section will have entries. Double click on Main. This runs the macro & a message box will appear. It will say Fixed! That is it! Check your form. You may uninstall the extension or leave it for fixing other Firebird Base files.

edit flag offensive delete link more


This worked as advertised! Thank you so much for this. I wonder what it will take for the bug to get squashed. Your solution is getting close to a year old.

wyomason gravatar imagewyomason ( 2019-08-30 02:31:34 +0200 )edit

If you look a the Bug report, it may not be fixed.

Ratslinger gravatar imageRatslinger ( 2019-08-30 03:46:23 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-19 03:32:54 +0200

Seen: 382 times

Last updated: Oct 19 '18