Open Office front end edit troubles

Author Message

R Sutton

Friday 10 August 2007 1:39:31 pm

When I export from the front end edit link on the EZ toolbar the doc gets downloaded and opens with OO, I am presented with a OO ASCII filter screen. I have tried literally every setting on this and I am getting nothing but 20-30 pages of skewed characters, maybe only two lines per page. What am I missing here? DO I need something else installed for this to work?

Thanks!

Tony Wood

Saturday 11 August 2007 2:10:29 am

Do you have openoffice installed on your server?

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

R Sutton

Tuesday 14 August 2007 5:20:11 pm

Thanks for your reply, Tony. Sorry for my late reply back :)

I do not know what you are referring to. What do I need to install on the server to make this work? Is there an extension that I am missing? I can't seem to find any documentation on getting this set right.

Thanks for taking the time to help!

Kim Kirkpatrick

Tuesday 14 August 2007 9:53:17 pm

The official name is openoffice.org, to emphasize its web presence and location.

Yes, you need to download and install it (about 90MB download, as I recall). It is roughly equivalent to, and can be made compatible with, MS Office -- and it's open and free.

R Sutton

Wednesday 15 August 2007 4:47:31 am

Thanks Kim. I have open office and have used it for years. The way Tony put it with "Do you have it installed on your server" implied that there was something left that needed to be installed on the server or an extension or something.

If you read my first post you will see that OO is opening the file with the ASCII filter for importing the exported ezpublish and no matter what I choose I am getting pages upon pages of garbled characters.

Thanks for any input or solution to this.

Roland Benedetti

Thursday 16 August 2007 12:37:01 am

Hi,

If you use an Open Document Text compliant application on the client side (best example is of course Open Office, a very used one is Neo Office on the mac platform), you should not need any installation on the server side.

Can you checkon our online demo (http://now.ezpublish.no/ login : editor password : publish). If this doesn't work, it will mean that there is something wrong on your client computer (old version of OOo ?), if this work, it will mean that there is something wrong in your eZ Publish installation ...

Cheers,

--
Roland Benedetti
eZ Systems, Product Management

R Sutton

Thursday 16 August 2007 12:07:25 pm

Thanks Roland for the reply. I did what you suggested and sure enough, it works fine and does not bring up the ASCII Filter in OO. Do you have any ideas of what may be wrong with the EZ install to make this happen? It's a pretty canned test install. Any ideas on what to try out to get this corrected?

Thanks!

R Sutton

Monday 20 August 2007 9:49:23 am

Does anyone have any ideas on how to start to debug this and track the problem on this?

Thanks!

Bruce Morrison

Monday 20 August 2007 6:58:51 pm

Hi R

I did what you suggested and sure enough,

What exactly did you do to fix your issue?

The issue is not with eZ Publish as it works as required in that it produces an Open Document Text and the appropriate headers that tell the browser how it should be opened.

The issue would appear on the client side in that you didn't have the appropriate software (recent version of OO) as Roland pointed out.

I'm not sure what it is that you hope to debug?

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

R Sutton

Monday 20 August 2007 8:08:20 pm

Hi Bruce,

I did as Roland suggested:

::Can you check on our online demo (http://now.ezpublish.no/ login : editor password : publish). If this doesn't work, it will mean that there is something wrong on your client computer (old version of OOo ?), if this works, it will mean that there is something wrong in your eZ Publish installation ...::

And the online demo works just fine with exporting EZ content to OO, which apparently means something is not fine with the my EZ installation in question. So what I am trying to determine is what could be wrong with my EZ installation that would make it generate the ASCII filter in OO to start off with. I have the latest canned version of EZ and the latest version of OO which is all I use for office and doc work anyway.

Is there any suggestions as to what may be wrong in the EZ installation? Where do I start with tracking down what the culprit may be.

Thanks for any insight you can convey!

Bruce Morrison

Monday 20 August 2007 11:22:32 pm

Hi R

Can you give some details as to the version of eZ you are using & web server config. Are you able to save the file and try to open it in OO? Is the site accessable via the internet?

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

R Sutton

Tuesday 21 August 2007 5:56:57 pm

Hi Bruce,

You bet.

Can you give some details as to the version of eZ you are using & web server config.

EZ version 3.92 Stock install
freeBSD 6
php 4.4
mysql 3.2
Content-Type: text/html; charset=utf-8

Are you able to save the file and try to open it in OO?

I have tried this initially, and I can save the file locally and open it, but I am prompted once again by the ASCII import filter in OO. Selecting any of the character encoding options results in the same 20+ pages with only 2-3 lines per page of garbled characters.

Is the site accessable via the internet?

Yes.
Test install with dummy content, on a sandbox.

http://ez.textdriven.com/index.php?/eng

Thanks for your help.

Bruce Morrison

Wednesday 22 August 2007 12:40:52 am

Hi R

Unfortinually I can't look at the exporting functionality without a login. I notice that the URL has the /index.php?/eng appended to it. I wonder if this has something to do with your issue?

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 10:40:36
Script start
Timing: Jan 18 2025 10:40:36
Module start 'layout'
Timing: Jan 18 2025 10:40:36
Module start 'content'
Timing: Jan 18 2025 10:40:37
Module end 'content'
Timing: Jan 18 2025 10:40:37
Script end

Main resources:

Total runtime1.0162 sec
Peak memory usage4,096.0000 KB
Database Queries93

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0098 589.1641152.6406
Module start 'layout' 0.00980.0034 741.804739.4609
Module start 'content' 0.01311.0012 781.2656774.0078
Module end 'content' 1.01440.0018 1,555.273428.1563
Script end 1.0161  1,583.4297 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00340.3375160.0002
Check MTime0.00140.1337160.0001
Mysql Total
Database connection0.00110.104410.0011
Mysqli_queries0.912589.7958930.0098
Looping result0.00110.1059910.0000
Template Total0.980496.520.4902
Template load0.00220.212220.0011
Template processing0.978396.270820.4891
Template load and register function0.00020.024010.0002
states
state_id_array0.00070.072610.0007
state_identifier_array0.00070.069120.0004
Override
Cache load0.00200.2013760.0000
Sytem overhead
Fetch class attribute can translate value0.00070.071350.0001
Fetch class attribute name0.00240.2314160.0001
XML
Image XML parsing0.00210.203350.0004
class_abstraction
Instantiating content class attribute0.00000.0044180.0000
General
dbfile0.00140.1337290.0000
String conversion0.00000.001840.0000
Note: percentages do not add up to 100% because some accumulators overlap

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
13content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
19content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
5content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
5content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 45
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs