Return to Jive Software

1,110 Views 26 Replies Last post: Jan 7, 2009 8:51 AM by Andy Goldstein RSS
Jeff Crump Novice 356 posts since
Nov 27, 2006
Currently Being Moderated

Nov 11, 2008 7:09 PM

View as PDF turns bullets into "???" (CS 2.5.3)

Hi, We're on Clearspace 2.5.3.

 

We've found a bug in the PDF creator. After conversion to PDF bullets appear as "???". This happens with documents created IN the HTML editor (as well as if it was pasted originally from Word). It also happens in discussions, but we didn't test blogs.

 

Here's what the resulting PDF looks like:

PDFtestBLNL.jpg

 

As you can see numbered lists paste fine.

 

Thanks!

Jeff

Long Ton That Jive Employee 9,674 posts since
Apr 1, 2008
Currently Being Moderated
Nov 12, 2008 8:41 AM in response to: Jeff Crump
Re: View as PDF turns bullets into "???" (CS 2.5.3)

Hey Jeff,

I just tested on my local instance of 2.5.3 by copying and pasting a bullet list from Word, however I could not replicate the '?' issue:

VIDEO

 

Perhaps this is related to the previous Clearspace <-> Word conversion issue, can you verify which version of Word and OS are you using?

~Long

Long Ton That Jive Employee 9,674 posts since
Apr 1, 2008
Currently Being Moderated
Nov 12, 2008 11:25 AM in response to: Jeff Crump
Re: View as PDF turns bullets into &quot;???&quot; (CS 2.5.3)

Hey Jeff,

Regarding:

 

Though for us, the PDF problem happens whether or not pasting is involved. Native HTML documents with bullets convert to PDF the same way.



Just wanted to confirm, even the out-of-box bullets from Clearspace's rich text editor are being replaced with '?' when converted to PDF?

~Long

Long Ton That Jive Employee 9,674 posts since
Apr 1, 2008
Currently Being Moderated
Nov 12, 2008 9:20 AM in response to: Jeff Crump
Re: View as PDF turns bullets into &quot;???&quot; (CS 2.5.3)

2.jpg

I'm not certain why I cannot replicate this issue, but this might be a known issue. I am going to discuss with our resident RTE developer to verify.

 

I'll post an update here if I find anything out.

~Long

Long Ton That Jive Employee 9,674 posts since
Apr 1, 2008
Currently Being Moderated
Nov 18, 2008 4:54 PM in response to: Jeff Crump
Re: View as PDF turns bullets into ??? (CS 2.5.3)

Hey Jeff,

I apologize for the delay, I'm still having issues getting ahold our developer that worked closely with the RTE and view PDF.

 

A couple of items that would be helpful in troubleshooting this would be:

  • The PDF output of a document with this bullets issue.
  • The documents HTML content (when in RTE, select HTML in top right corner). Could you copy and paste this to a text file.

 

Thanks again and I apologize for not providing an update.

~Long

Long Ton That Jive Employee 9,674 posts since
Apr 1, 2008
Currently Being Moderated
Nov 19, 2008 2:42 PM in response to: Jeff Crump
Re: View as PDF turns bullets into ??? (CS 2.5.3)

Jeff,

Even replicating the document exactly with the supplied HTML, I couldn't replicate the issue on my local instance which leads me to believe there is a missing variable.

 

I noticed that I could hit your site from one of the links in the documents, would it be possible for me to troubleshoot on your site directly? (Perhaps setting up an account, private community to test on, or just even a link to one of the trouble documents)

 

I completely understand if this isn't a possibility. If not, could you supply me with the following items about your enviroment:

  • Application server + version
    • Is SSL enabled
  • Database
  • PDF View (application opened when viewing PDF's)
  • Any customizations / plugins (outside of theming)

~Long

Ben Davis Novice 195 posts since
Feb 20, 2003
Currently Being Moderated
Nov 19, 2008 4:17 PM in response to: Long Ton That
Re: View as PDF turns bullets into ??? (CS 2.5.3)

I'm seeing the same thing on Solaris

 

Clearspace Version:     2.5.3
JVM Version and Vendor:     1.5.0_14 Sun Microsystems Inc.
Application server:     Apache Tomcat/6.0.16
Operating System:     SunOS
Hardware:     sparc

 

                       Solaris 10 8/07 s10s_u4wos_12b SPARC
           Copyright 2007 Sun Microsystems, Inc.  All Rights Reserved.
                        Use is subject to license terms.
                            Assembled 16 August 2007

 

 

It works fine on my development system. The only difference between the two is the OS release.

 

                       Solaris 10 5/08 s10s_u5wos_10 SPARC
           Copyright 2008 Sun Microsystems, Inc.  All Rights Reserved.
                        Use is subject to license terms.
                             Assembled 24 March 2008

Long Ton That Jive Employee 9,674 posts since
Apr 1, 2008
Currently Being Moderated
Nov 19, 2008 4:33 PM in response to: Ben Davis
Re: View as PDF turns bullets into ??? (CS 2.5.3)

Hey Ben,

Thanks for the input, maybe we can isolate the issue if we can find a common element between Jeff and your environment.

 

This is a question for both you and Jeff: Which database are you using? and which character encoding is it configured to (UTF-8)? Finally, which character encoding is set in Clearspace (Admin Console > System > Locale)?

 

 

Note: Also Ben, a couple of items in your environment aren't officially supported in Clearspace 2.5.3 yet, Solaris 10 and Sun JDK 1.5 will be in version 2.5.5. Platform Support in Clearspace 2.5

Ben Davis Novice 195 posts since
Feb 20, 2003
Currently Being Moderated
Nov 19, 2008 4:51 PM in response to: Long Ton That
Re: View as PDF turns bullets into ??? (CS 2.5.3)

MySQL             5.0.45

MySQL-AB JDBC Driver mysql-connector-java-5.1.6

Character encoding for both is UTF-8

 

Yeah, I know about the support but the 1.x HTML editor was making everyone crazy.

Doug Carter Novice 178 posts since
Jul 23, 2005
Currently Being Moderated
Nov 20, 2008 7:05 AM in response to: Jeff Crump
Re: View as PDF turns bullets into ??? (CS 2.5.3)

The webserver is encoded with ISO-8859-1.

 

Each MySQL table is either using utf8 or latin1.

 

I hope this helps,

 

Doug

Long Ton That Jive Employee 9,674 posts since
Apr 1, 2008
Currently Being Moderated
Nov 20, 2008 10:42 AM in response to: Doug Carter
Re: View as PDF turns bullets into ??? (CS 2.5.3)

Thanks,

I believe the Character Encoding should match at the Webserver and Database level, could you set the Webserver to UTF-8.

 

Which version of the Java JDK is MercyCorp using? 1.5 or 1.6?

~Long

Doug Carter Novice 178 posts since
Jul 23, 2005
Currently Being Moderated
Nov 20, 2008 10:47 AM in response to: Long Ton That
Re: View as PDF turns bullets into ??? (CS 2.5.3)

Hi Long,

 

We can't use UTF-8 right now, because it will break other websites on the same server. I'll try it on our development server.

 

We are Java 1.6.0_07-b06, running on Linux.

 

Thanks,

 

Doug

1.6.0_07-b06

Doug Carter Novice 178 posts since
Jul 23, 2005
Currently Being Moderated
Nov 20, 2008 11:42 AM in response to: Long Ton That
Re: View as PDF turns bullets into ??? (CS 2.5.3)

Long,

 

I just changed our test server over to UTF-8 and it has no effect on this PDF encoding problem.

 

Anything else to try?

 

 

Thanks,

 

Doug

Long Ton That Jive Employee 9,674 posts since
Apr 1, 2008
Currently Being Moderated
Nov 21, 2008 2:31 PM in response to: Doug Carter
Re: View as PDF turns bullets into ??? (CS 2.5.3)

Hey guys,

We're still not sure what could be causing this, I cannot replicate this on my nearly identical setup. I've exhausted any potential root causes I could think of, I will need to discuss with one of our developers unfortunately he's not in the office today.

 

Thanks for your patience, I will try to have an update for you guys next monday.

~Long

Long Ton That Jive Employee 9,674 posts since
Apr 1, 2008
Currently Being Moderated
Nov 26, 2008 4:29 PM in response to: Jeff Crump
Re: View as PDF turns bullets into "???" (CS 2.5.3)

Hey Jeff,

I had a chance to discuss this with our resident PDF developer, and we weren't able to determine the root cause. The bullets appear to be standard HTML bullets, the only explaination would be that the font used in the PDF's doesn't have the bullet character. At the moment, I'm not sure how we could confirm this, I'm going to have to look through the code a bit more to verify exactly what's occurring during PDF generation.

 

We're not sure if this is necessary yet, but would it be possible to get a copy of your database & Tomcat deployment? Also which specific Linux flavor & version is this OS running on?

~Long

Long Ton That Jive Employee 9,674 posts since
Apr 1, 2008
Currently Being Moderated
Dec 12, 2008 8:03 AM in response to: Jeff Crump
Re: View as PDF turns bullets into "???" (CS 2.5.3)

This is great to hear Jeff! Glad it's working as expected now.

~Long

Andy Goldstein Beginner 358 posts since
Apr 6, 2007
Currently Being Moderated
Jan 7, 2009 7:57 AM in response to: Jeff Crump
Re: View as PDF turns bullets into "???" (CS 2.5.3)

Jeff, could you elaborate on what you did to make this work?  We're having the same problem and would like to know how to resolve it.

 

Thanks!

Andy

Doug Carter Novice 178 posts since
Jul 23, 2005
Currently Being Moderated
Jan 7, 2009 8:37 AM in response to: Andy Goldstein
Re: View as PDF turns bullets into "???" (CS 2.5.3)

Hi Andy,

 

Although we had several things mis-configured, the fix for this was quite simple.

 

The default file encoding for our JVM (Sun 1.6) is not UTF-8. So, you need to specify this as a startup parameter for your servlet engine. We are using Tomcat 5.5, and it has an environment variable called JAVA_OPTS for adding additional JVM parameters. To fix this encoding problem add this parameter to your servlet engine startup script:

 

     -Dfile.encoding=UTF-8

 

Then restart your servlet engine.

 

Doug

Andy Goldstein Beginner 358 posts since
Apr 6, 2007
Currently Being Moderated
Jan 7, 2009 8:51 AM in response to: Doug Carter
Re: View as PDF turns bullets into &quot;???&quot; (CS 2.5.3)

Thanks, that worked like a charm!

More Like This

  • Retrieving data ...

Bookmarked By (0)

To better serve our customers we have included functionality to automatically follow up on a case after it has been idle for more than 5 days, and then auto close after an additional 3 days of inactivity. Choose No to acknowledge that this case will remain idle for longer than 5 days.
Making cases public allows other customers to learn from the solution of the case. It can also be used to gain feedback from others in the community. Ask our Support Engineers for more info, but we encourage you to make your cases public.