View Issue Details

IDProjectCategoryView StatusLast Update
05475Development Import/Exportpublic2019-09-23 12:20
ReporterMazi Assigned Toc_schmitz  
PrioritylowSeverityminor 
Status confirmedResolutionopen 
Product Version1.91+ 
Target Version2.1Fixed in Version 
Summary05475: Rewrite Word export
Description

When trying to export survey results to MS Word only some weird style information can be found at the exported file if there is no survey data to export.

Steps To Reproduce
  1. Activate a survey
  2. Do not enter any answer data
  3. Click export survey results, leave everything as is and chose "MS Word" as export file type.
  4. Open the file. I see this data in there:
    <style>
    table {
    border-collapse:collapse;
    }
    td, th {
    border:solid black 1.0pt;
    }
    th {
    background: #c0c0c0;
    }
    </style>
Additional Information

<style>
table {
border-collapse:collapse;
}
td, th {
border:solid black 1.0pt;
}
th {
background: #c0c0c0;
}
</style><table><tr><th colspan='2'>NEW RECORD</td></tr><td>ID:</td><td>1</td></tr> <td>Completed</td><td>1980-01-01 00:00:00</td></tr> <td>Last page seen</td><td>4</td></tr> <td>Language:</td><td>en</td></tr> <td>q1</td><td></td></tr> <td>q2</td><td></td></tr> <td>q3</td><td></td></tr> <td>q4
</td><td></td></tr></table>

TagsNo tags attached.

Relationships

related to 08010 new Feature requests survey data export 

Activities

c_schmitz

c_schmitz

2011-10-18 18:01

administrator   ~16450

Why are you trying to export results if there are none ;)

Mazi

Mazi

2011-10-18 18:06

partner   ~16451

To see if this a caught properly or if it causes some weird buggy behavior ;-)

Mazi

Mazi

2011-11-14 22:33

partner   ~16666

A short update: This is a general problem, HTML isn't filtered at the export to MS Word, see attached screen shot.

Mazi

Mazi

2011-11-14 22:33

partner  

html_word_export.PNG (82,494 bytes)
html_word_export.PNG (82,494 bytes)
c_schmitz

c_schmitz

2011-11-15 16:21

administrator   ~16684

It's not a real WORD export, never was. Just a plain HTML export and WORD would silently import it.

c_schmitz

c_schmitz

2012-01-23 16:11

administrator   ~16910

Word export needs to be rewritten in general.

c_schmitz

c_schmitz

2013-10-15 18:31

administrator   ~26809

After careful consideration I think it would be best to re-label this export as what it is - a HTML export. Offering a real DOC(X) export is out of the question as PHP libraries are either not available or only offer partial solutions.
The other option is to drop this completely. Feedback is welcome.

c_schmitz

c_schmitz

2013-10-15 18:50

administrator   ~26810

Last edited: 2013-10-15 18:55

View 2 revisions

Ok, found something which does not seem too big: http://phpword.codeplex.com/

sammousa

sammousa

2013-10-15 23:35

reporter   ~26813

How about supporting OpenDocument instead?

It is supported in MS Office since 2007 (and before that several plugins exist).
http://en.wikipedia.org/wiki/OpenDocument_software

It has good library support (since it is an open standard):
http://www.opendocumentformat.org/developers/

For 2.06 I would see no downside. If you want guaranteed compatibility you should be using PDF in any case. If you want to edit the document I don't think requiring office 2007 or the use of some plugin is too bad...

mfaber

mfaber

2013-10-16 05:15

reporter   ~26814

If you guys decide on a library maybe also have in mind support for excel xlsx format. The present excel 2003 format export only supports 256 columns which is often not enough for large surveys.So, in the long run we should switch to xlsx.

DenisChenu

DenisChenu

2013-10-16 08:25

developer   ~26815

+42 for ODT :)

from scratch : http://php-odt.sourceforge.net/public/home
from template : http://www.tinybutstrong.com/tbsooo.php#features

(there are some other)
template can be interseting to have user template.

Mazi

Mazi

2013-10-16 09:13

partner   ~26816

If MS Office can read ODT and there are easy to use libraries for exporting to that format, then this sounds great.

I also think that we should solve the 256 column limit. That is reported quite often at the forums.

mdekker

mdekker

2013-10-16 11:07

reporter   ~26819

Who wants word export anyway? We have a html export as a plugin already and because of the plugin system any export can be developed and distributed independent of the core. If someone from the team or someone else comes up with a good replacement we can always decide to move it to core and drop one of the old plugins to be an "external" plugin for whoever depends on it.

DenisChenu

DenisChenu

2014-09-14 10:26

developer   ~30623

Like mdekker : waiting for a plugin (or a client ;) ).

For 2.06 : i want to do this

  • Move some export plugin to own core plugin (word for example, staring).
  • Activate this plugin when update
  • Allow deactivate this plugin.

Issue History

Date Modified Username Field Change
2011-09-24 00:11 Mazi New Issue
2011-09-24 00:11 Mazi Status new => assigned
2011-09-24 00:11 Mazi Assigned To => c_schmitz
2011-09-24 00:47 Mazi Summary Exporting survey results to SM Word fails when there is no data => Exporting survey results to MS Word fails when there is no data
2011-09-24 00:47 Mazi Additional Information Updated View Revisions
2011-10-18 18:01 c_schmitz Note Added: 16450
2011-10-18 18:06 Mazi Note Added: 16451
2011-10-18 18:08 c_schmitz Priority normal => low
2011-10-19 18:48 c_schmitz Target Version 1.91+ => 2.00a1
2011-11-14 22:33 Mazi Note Added: 16666
2011-11-14 22:33 Mazi File Added: html_word_export.PNG
2011-11-15 16:21 c_schmitz Note Added: 16684
2012-01-23 16:11 c_schmitz Note Added: 16910
2012-01-23 16:11 c_schmitz Status assigned => acknowledged
2012-01-23 16:13 c_schmitz Target Version 2.00a1 => 2.1
2012-02-27 01:34 c_schmitz Project Bug reports => Development
2012-08-14 23:09 c_schmitz Summary Exporting survey results to MS Word fails when there is no data => Rewrite Word export
2013-10-15 18:31 c_schmitz Note Added: 26809
2013-10-15 18:50 c_schmitz Note Added: 26810
2013-10-15 18:55 c_schmitz Note Edited: 26810 View Revisions
2013-10-15 23:35 sammousa Note Added: 26813
2013-10-16 05:15 mfaber Note Added: 26814
2013-10-16 05:16 mfaber Relationship added related to 08010
2013-10-16 08:25 DenisChenu Note Added: 26815
2013-10-16 09:13 Mazi Note Added: 26816
2013-10-16 11:07 mdekker Note Added: 26819
2014-09-14 10:26 DenisChenu Note Added: 30623
2019-09-23 12:20 c_schmitz Status acknowledged => confirmed