Forums / Developer / openoffice.org extension

openoffice.org extension

Author Message

Jack Rackham

Friday 08 April 2005 6:12:11 am

After waiting a long time for a new version to come, I fixed the image and øæå issue myself.
Here is a version of the openoffice.org extension that supports images and øæå.
http://hk5.50megs.com/

Bård Farstad

Monday 11 April 2005 5:59:48 am

New release of the OpenOffice.org extension is now available:
http://ez.no/community/contribs/import_export/openoffice_org_extension

Please report any bugs you find.

--bård

Documentation: http://ez.no/doc

Jack Rackham

Tuesday 12 April 2005 5:03:38 am

Bugs in beta 2
-Error when opening exported files. (Format error) Test on OO 1.1.3 winxp, Suse 9.2
-Exported files named "test".

Bård Farstad

Tuesday 12 April 2005 5:29:54 am

Haavard,

do you have a bit more information on how we can re-produce this?

--bård

Documentation: http://ez.no/doc

Jack Rackham

Tuesday 12 April 2005 6:19:45 am

Format error in content.xml 3,96(row,col)

Jack Rackham

Tuesday 12 April 2005 6:50:30 am

The problem is caused by images "in the xml part of the article" or by a image relation (standard image import at end of edit a article "Image [Object relation] (id:154)"). Because when I try to export an article without any images the document works fine.

EZ generates the following error the first time OO ex. is started after clear cache, but they are most likely unrelated.

Error: eZTemplate @ extension/oo/design/standard/templates/oo/export.tpl:34[63] Apr 12 2005 14:36:43 
parser error @ extension/oo/design/standard/templates/oo/export.tpl:34[78]
Extra characters found in expression, they will be ignored.
|i18n('design/standard/oo/import)' ('Export Object')

Error: eZTemplate:ElementParser::parseVariableTag Apr 12 2005 14:36:43 
parser error @ s
Parser position did not move, this is most likely a bug in the template parser.

Jack Rackham

Wednesday 13 April 2005 11:53:38 am

My advice is that you skip the OO export in the next version, and instead concentrates on the import function, because EZ already have PDF support. But then again OO documents have some advantages over PDF.

Jack Rackham

Saturday 23 April 2005 11:13:24 am

When I started using the OO extension for real, I quickly discovered that there are a lot of bugs in beta 2 of the extension. Here are a few bugs.

- Random appearing of emphasize and strong in imported files
- Sometimes extra lines appears
- Random text is removed when importing docs

To re-produce this errors try using another document that the example.

Bård Farstad

Tuesday 26 April 2005 1:02:32 am

Håvard,

please provide more information when you discover bugs.

It would be great if you could use the bugreporting system as well, so we can track the bugs reported.

I am now looking into reproducing the image bug you mention.

--bård

Documentation: http://ez.no/doc

Jack Rackham

Tuesday 26 April 2005 2:03:46 pm

Do the current version support different OO "styles". Looking at the ezoogenerator.php file I see that Illustration, Table, Text, Drawing is named, but what about default and the rest.

- Do you mean this image bug?
The problem is caused by images "in the xml part of the article" or by a image relation (standard image import at end of edit a article "Image [Object relation] (id:154)"). ....................

Tuesday 03 May 2005 3:51:07 am

I have installed and tried oo extension version 1.0 but when I export a document the size is always 0 bytes. Do I have to do some magic to get this working ?
Import works flawlessly though.
Tested on eZ 3.5.2

Bård Farstad

Tuesday 03 May 2005 5:10:59 am

Hans-Henry, to get export working you need to have the "zip" command line program installed or mod_gzip in PHP.

--bård

Documentation: http://ez.no/doc

Tuesday 03 May 2005 6:12:50 am

I can export files after installing zip but when I try to open it in openoffice 1.1.4 I get the following error message:

"Read-Error.
Format error discovered in the file in sub-document content.xml at 4,129(row,col)."

The row,col number is different from article to article.

I have unzipped the sxw document and opened the content.xml document without any error messages.

Bård Farstad

Tuesday 03 May 2005 6:27:19 am

This is interesting. I did get reports about this happening. I have not been able to reproduce this on my systems. Can you provide more information on how this is re-produced?

Does it always happen? What is your system information?

--bård

Documentation: http://ez.no/doc

Tuesday 03 May 2005 6:32:26 am

Can I provide you with this information outside of this forum. I don't like to publish such information to everyone :)

Bård Farstad

Tuesday 03 May 2005 6:37:58 am

Yes, feel free to send me an e-mail. My initials at ez.no.

Documentation: http://ez.no/doc

Tuesday 10 May 2005 6:21:07 am

Hi,

Have you had time to look through the info I sent you?

Mail was sent Tuesday 03.05.2005 (DDMMYYYY) 15:44

Bård Farstad

Tuesday 10 May 2005 6:25:30 am

Hans-Henry,

Yes, we have looked at the info you sent me. I have not been able to re-produce it on my systems (all Linux) but on a windows system.

We haven't had time to find a solution for it. But the problem was related to the files generated in the ezoogenerator.php file. If someone with a windows environment would have time to look a bit at this problem happening during export that would be great ;)

--bård

Documentation: http://ez.no/doc

Joshua Newman

Tuesday 10 May 2005 12:17:14 pm

I believe this is an OO.o bug not an eZ bug. I am using OO.o 1.9.100 on Linux but not using eZpublish, and am getting the same error (but with different row and column numbers). Did not ever see this error prior to upgrading to OO.o version 1.9.100 from version (I believe) 1.9.72.

Jack Rackham

Tuesday 10 May 2005 1:36:27 pm

I have tested the beta 2 on SUSE 9.2 and Windows XP, and the export don.t work on any of them. The same old error is displayed.

eZ debug

Timing: Jan 20 2025 03:57:39
Script start
Timing: Jan 20 2025 03:57:39
Module start 'content'
Timing: Jan 20 2025 03:57:41
Module end 'content'
Timing: Jan 20 2025 03:57:41
Script end

Main resources:

Total runtime2.1447 sec
Peak memory usage4,096.0000 KB
Database Queries267

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0099 588.9531180.8359
Module start 'content' 0.00992.0042 769.7891819.1563
Module end 'content' 2.01410.1304 1,588.9453366.5625
Script end 2.1446  1,955.5078 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00450.2112210.0002
Check MTime0.00150.0723210.0001
Mysql Total
Database connection0.00470.219010.0047
Mysqli_queries1.998393.17452670.0075
Looping result0.00220.10372650.0000
Template Total2.107498.321.0537
Template load0.00210.098520.0011
Template processing2.105398.163621.0526
Template load and register function0.00030.015110.0003
states
state_id_array0.00140.065110.0014
state_identifier_array0.00080.035420.0004
Override
Cache load0.00200.0952960.0000
Sytem overhead
Fetch class attribute can translate value0.00140.064950.0003
Fetch class attribute name0.00100.0467230.0000
XML
Image XML parsing0.01330.620950.0027
class_abstraction
Instantiating content class attribute0.00010.0035390.0000
General
dbfile0.02080.9718400.0005
String conversion0.00000.000430.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
19content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
20content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
7content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
23content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 72
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs