PUBLIC - Liferay Portal Community Edition

The file version compare does not display correctly files contents in the Document Library

Details

  • Branch Version/s:
    6.1.x
  • Backported to Branch:
    Committed
  • Liferay Contributor's Agreement:
    Accept
  • Similar Issues:
    Show 3 results 

Description

I am unable to compare version of word document i.e. doc, rtf extension files, although I had already enabled the OpenOffice from Server Administrtion and integrated OpenOffice with Liferay. However the compare versions it shows some unreadable symbols.
The convert into pdf, txt, odt and rtf are works correctly.

  1. Microsoft Word
    test_chinese_document.doc
    12/Jun/12 1:30 AM
    26 kB
    Tibor Kovács
  2. Text File
    test_chinese_document.txt
    12/Jun/12 1:30 AM
    0.5 kB
    Tibor Kovács
  3. File
    test_chinese2_image.odt
    12/Jun/12 1:30 AM
    39 kB
    Tibor Kovács
  4. Microsoft Word
    test_document.doc
    12/Jun/12 1:30 AM
    11 kB
    Tibor Kovács
  5. Text File
    test_document.txt
    12/Jun/12 1:30 AM
    0.6 kB
    Tibor Kovács
  1. afterfix.png
    25 kB
    05/Aug/11 1:58 AM
  2. beforefix.png
    28 kB
    05/Aug/11 1:58 AM
  3. Compare-Version.png
    106 kB
    12/Jun/12 12:37 AM
  4. pdf.jpg
    5 kB
    11/Aug/11 10:17 PM
  5. rtf.jpg
    68 kB
    11/Aug/11 10:18 PM
  6. unreadable_symbols_on_doc_comparison.JPG
    66 kB
    03/Aug/11 5:20 AM

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Tibor Kovács added a comment -

The file extension's can not be read out from the file name.
(title = name.extension)

Show
Tibor Kovács added a comment - The file extension's can not be read out from the file name. (title = name.extension)
Hide
Permalink
Sophia Zhang added a comment -

FAILED Manual Testing using the following steps:
1. Add a document (content are English)to a DL portlet in a test page.
2. Edit it to change another document(content including Chinese).
3. Go enter the document and compare the versions.

Reproduced on:
Tomcat 6.0.32 + MYSQL 5. 6.0.x Revision 86200.
I got the attached file result.see "before fix"

Failed on:
Tomcat 6.0.32 + MYSQL 5. 6.0.x Revision 86549.
See file "After fix".

Actually,when I open the converted extension files,it doesn't work both on affected version and fixed version.

Show
Sophia Zhang added a comment - FAILED Manual Testing using the following steps: 1. Add a document (content are English)to a DL portlet in a test page. 2. Edit it to change another document(content including Chinese). 3. Go enter the document and compare the versions. Reproduced on: Tomcat 6.0.32 + MYSQL 5. 6.0.x Revision 86200. I got the attached file result.see "before fix" Failed on: Tomcat 6.0.32 + MYSQL 5. 6.0.x Revision 86549. See file "After fix". Actually,when I open the converted extension files,it doesn't work both on affected version and fixed version.
Hide
Permalink
Tibor Kovács added a comment -

Hi Sophia,

Could you please check the uploaded (Chinese content) text file's content, because when I tried the first time to Copy+Paste some Chinese content to a text file I got some unreadable characters but on second attempt it displayed the characters just fine.

What do you get when you try to save a Chinese content's doc file to txt file, do you get unreadable characters?

Regards,

Tibor

Show
Tibor Kovács added a comment - Hi Sophia, Could you please check the uploaded (Chinese content) text file's content, because when I tried the first time to Copy+Paste some Chinese content to a text file I got some unreadable characters but on second attempt it displayed the characters just fine. What do you get when you try to save a Chinese content's doc file to txt file, do you get unreadable characters? Regards, Tibor
Hide
Permalink
Sophia Zhang added a comment - - edited

Hi Tibor,
Here is my test result:
EnglishContent.txt —
.doc failed
.odt failed
.pdf ok
.rtf failed
.sxw failed

chineseContent.txt----
.pdf is unreadable words.
preview of the .txt displays unreadable words too.

chineseContent.doc —
.doc failed
.odt failed
.pdf some chinese world are square box.see attached file.
.rtf failed
.sxw failed
.txt ok
For the wiki page, the conversion is working well.

A question:
Different extention file can't compare versions,it shows document library is unavailable.Is that expected behavior?

Show
Sophia Zhang added a comment - - edited Hi Tibor, Here is my test result: EnglishContent.txt — .doc failed .odt failed .pdf ok .rtf failed .sxw failed chineseContent.txt---- .pdf is unreadable words. preview of the .txt displays unreadable words too. chineseContent.doc — .doc failed .odt failed .pdf some chinese world are square box.see attached file. .rtf failed .sxw failed .txt ok For the wiki page, the conversion is working well. A question: Different extention file can't compare versions,it shows document library is unavailable.Is that expected behavior?
Hide
Permalink
Sophia Zhang added a comment -

Still able to reproduce it on:
Tomcat 7.0 + MySQL 5. 6.1.x GIT ID: 6d6b8814da7c7295ed4cab8420e070793361f856.
Tomcat 7.0 + MySQL 5. 6.2.x GIT ID: 71ce8e940ae12bae24e2a5e14cf3f836bb291915.

Show
Sophia Zhang added a comment - Still able to reproduce it on: Tomcat 7.0 + MySQL 5. 6.1.x GIT ID: 6d6b8814da7c7295ed4cab8420e070793361f856. Tomcat 7.0 + MySQL 5. 6.2.x GIT ID: 71ce8e940ae12bae24e2a5e14cf3f836bb291915.
Hide
Permalink
Justin Choi added a comment -

Able to reproduce on:
Tomcat 7.0 + MySQL 5. Portal 6.1.x CE GIT ID: 0c68e511c8ca1ec0f735718bffe564af7437ddbb.

Compare Versions:

  • English doc to Chinese odt (fail).
  • English doc to English doc (fail).
  • English doc to Chinese txt (pass).
  • English txt to Chinese txt (pass).
  • Chinese odt to Chinese txt (fail).
  • Unable to compare pdf.

Viewed individually, all the files can be viewed without errors.

Tomcat 7.0 + MySQL 5. Portal 6.1.x EE GIT ID: 8c98736fa1ded7d4589adf94268fe29013b6bc91.
Compare Versions:

  • English doc to Chinese odt (pass).
  • English doc to Chinese txt (fail).
  • English doc to English doc (pass).
  • Chinese odt to Chinese txt (fail) - txt is corrupted.
  • Chinese txt to English txt (fail).

Tomcat 7.0 + MySQL 5. Portal 6.2.x GIT ID: 73fd14c1da1ec13f906fb060975035b6737ad341.

Compare Versions:

  • English doc to Chinese odt (pass).
  • English doc to Chinese txt (pass).
  • English doc to English doc (pass).
  • Chinese odt to Chinese txt (fail) - txt is corrupted.
  • Chinese txt to English txt (pass).
  • Unable to convert pdf.
Show
Justin Choi added a comment - Able to reproduce on: Tomcat 7.0 + MySQL 5. Portal 6.1.x CE GIT ID: 0c68e511c8ca1ec0f735718bffe564af7437ddbb. Compare Versions: English doc to Chinese odt (fail). English doc to English doc (fail). English doc to Chinese txt (pass). English txt to Chinese txt (pass). Chinese odt to Chinese txt (fail). Unable to compare pdf. Viewed individually, all the files can be viewed without errors. Tomcat 7.0 + MySQL 5. Portal 6.1.x EE GIT ID: 8c98736fa1ded7d4589adf94268fe29013b6bc91. Compare Versions: English doc to Chinese odt (pass). English doc to Chinese txt (fail). English doc to English doc (pass). Chinese odt to Chinese txt (fail) - txt is corrupted. Chinese txt to English txt (fail). Tomcat 7.0 + MySQL 5. Portal 6.2.x GIT ID: 73fd14c1da1ec13f906fb060975035b6737ad341. Compare Versions: English doc to Chinese odt (pass). English doc to Chinese txt (pass). English doc to English doc (pass). Chinese odt to Chinese txt (fail) - txt is corrupted. Chinese txt to English txt (pass). Unable to convert pdf.
Hide
Permalink
Justin Choi added a comment - - edited

I also installed and enabled ImagicMagick which then became the default system to view thumbnails instead of PDFBox but this should not make a difference. - Justin

Show
Justin Choi added a comment - - edited I also installed and enabled ImagicMagick which then became the default system to view thumbnails instead of PDFBox but this should not make a difference. - Justin
Hide
Permalink
Sophia Zhang added a comment -

Hi Justin,
I don't know if the feature changed. I didn't find Compare Version button any more on:
Tomcat 7.0 + MySQL 5. Portal 6.1.x EE GIT ID: b2b275ebbe7592bde591fd350da854d6d18f8af4.
Tomcat 7.0 + MySQL 5. Portal 6.2.x GIT ID: 1b353b3e52eb260a5d62c01cf655fc419cc5e371.
Is this feature removed? See my attached screenshot.

Show
Sophia Zhang added a comment - Hi Justin, I don't know if the feature changed. I didn't find Compare Version button any more on: Tomcat 7.0 + MySQL 5. Portal 6.1.x EE GIT ID: b2b275ebbe7592bde591fd350da854d6d18f8af4. Tomcat 7.0 + MySQL 5. Portal 6.2.x GIT ID: 1b353b3e52eb260a5d62c01cf655fc419cc5e371. Is this feature removed? See my attached screenshot.
Hide
Permalink
Tibor Kovács added a comment -

Hi Sophia, Justin,

We tested this on trunk, but it works well for us.

Test Environmnet:
Open Office 3, Open Office 3.3
Tomcat 7.0.25, MySQL 5.5, Portal 6.2.x (e509db822c62a0a302f32c0fd4a99d30566fa84b)

Test scenarios:
1) English doc to Endlish txt (Passed)
2) English doc to English odt (Passed)
3) English txt to English odt (Passed)
4) English otd to English txt (Passed)

5) Chinese doc to Chinese txt (Passed)
6) Chinese doc to Chinese odt (Passed)
7) Chinese txt to Chinese odt (Passed)
8) Chinese otd to Chinese txt (Passed)

9) Chinese doc to Endlish txt (Passed)
10) Chinese doc with image to Endlish txt (Passed)
11) Chinese doc to English odt (Passed)
12) Chinese doc with image to English odt (Passed)
13) Chinese txt to English odt (Passed)
14) Chinese otd to English txt (Passed)

15) Chinese doc save to odt, txt, pdf, rtf (Passed)
16) Englis doc save to odt, txt, pdf, rtf (Passed)
In 15, 16 I tested this type of documents all permutation and all of these tests worked for me.

Please note if the file saving to different file formats are not working correclty then the file version compare will not work as well.
Were you able to set the Open Office integration successfully, because it seems to me this could be the reason why it fails on your side, or the button is not displayed.
Could you please test the file saving to different file formats first?

You can find the files attached which I used during the tests.

Show
Tibor Kovács added a comment - Hi Sophia, Justin, We tested this on trunk, but it works well for us. Test Environmnet: Open Office 3, Open Office 3.3 Tomcat 7.0.25, MySQL 5.5, Portal 6.2.x (e509db822c62a0a302f32c0fd4a99d30566fa84b) Test scenarios: 1) English doc to Endlish txt (Passed) 2) English doc to English odt (Passed) 3) English txt to English odt (Passed) 4) English otd to English txt (Passed) 5) Chinese doc to Chinese txt (Passed) 6) Chinese doc to Chinese odt (Passed) 7) Chinese txt to Chinese odt (Passed) 8) Chinese otd to Chinese txt (Passed) 9) Chinese doc to Endlish txt (Passed) 10) Chinese doc with image to Endlish txt (Passed) 11) Chinese doc to English odt (Passed) 12) Chinese doc with image to English odt (Passed) 13) Chinese txt to English odt (Passed) 14) Chinese otd to English txt (Passed) 15) Chinese doc save to odt, txt, pdf, rtf (Passed) 16) Englis doc save to odt, txt, pdf, rtf (Passed) In 15, 16 I tested this type of documents all permutation and all of these tests worked for me. Please note if the file saving to different file formats are not working correclty then the file version compare will not work as well. Were you able to set the Open Office integration successfully, because it seems to me this could be the reason why it fails on your side, or the button is not displayed. Could you please test the file saving to different file formats first? You can find the files attached which I used during the tests.
Hide
Permalink
Sophia Zhang added a comment -

Hi Tibor,
Yes, you are right. Thanks. Today's build open office is not working, and formats conversion failed.
I will test it tomorrow to make sure it works, then I will close it. Thank you very much.

Show
Sophia Zhang added a comment - Hi Tibor, Yes, you are right. Thanks. Today's build open office is not working, and formats conversion failed. I will test it tomorrow to make sure it works, then I will close it. Thank you very much.
Hide
Permalink
Sophia Zhang added a comment -

PASSED Manual Testing following the steps in the description.

Reproduced on:
Tomcat 7.0 + MySQL 5. 6.1.x GIT ID: 6d6b8814da7c7295ed4cab8420e070793361f856.
Tomcat 7.0 + MySQL 5. 6.2.x GIT ID: 71ce8e940ae12bae24e2a5e14cf3f836bb291915.

Failed results as Justin's previous comments.

Fixed on:
Tomcat 7.0 + MySQL 5. Portal 6.1.x EE GIT ID: 19aabb75583a436fa9861ced02ac9ca08892c76b.
Tomcat 7.0 + MySQL 5. Portal 6.2.x GIT ID: fa5a3b8677681947cd1e60de882f4d2d9b5930a8.

Passed results as Tibor Kovács's comment.

Show
Sophia Zhang added a comment - PASSED Manual Testing following the steps in the description. Reproduced on: Tomcat 7.0 + MySQL 5. 6.1.x GIT ID: 6d6b8814da7c7295ed4cab8420e070793361f856. Tomcat 7.0 + MySQL 5. 6.2.x GIT ID: 71ce8e940ae12bae24e2a5e14cf3f836bb291915. Failed results as Justin's previous comments. Fixed on: Tomcat 7.0 + MySQL 5. Portal 6.1.x EE GIT ID: 19aabb75583a436fa9861ced02ac9ca08892c76b. Tomcat 7.0 + MySQL 5. Portal 6.2.x GIT ID: fa5a3b8677681947cd1e60de882f4d2d9b5930a8. Passed results as Tibor Kovács's comment.

People

Vote (0)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved:
    Days since last comment:
    42 weeks, 6 days ago