[jira] Created: (OFBIZ-170) Incorrect rendering of international characters in PDF reports created using XSL:FO

[Nicolas Malin (Jira)]

Incorrect rendering of international characters in PDF reports created using XSL:FO
------------------------------------------------------------------------------------

                 Key: OFBIZ-170
                 URL: http://issues.apache.org/jira/browse/OFBIZ-170
             Project: OFBiz (The Open for Business Project)
          Issue Type: Bug
          Components: framework, order
            Reporter: Eriks Dobelis
         Attachments: QuoteReport-7.pdf

International characters in XSL:FO reports are replaced with # even if in the database, ecommerce webapp, catalog webapp, etc. characters are displayed correctly.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[Nicolas Malin (Jira)]

    [ http://issues.apache.org/jira/browse/OFBIZ-170?page=comments#action_12429743 ]
           
Christian Geisert commented on OFBIZ-170:
-----------------------------------------

I guess the # are latvian characters which are not part of the ISO Latin 1 character set (see http://xmlgraphics.apache.org/fop/faq.html#pdf-characters for details)

So  you need to add a custom font which contains the needed characters (see http://xmlgraphics.apache.org/fop/0.20.5/fonts.html#custom) and the configuration for the font must be done in FOPRenderer.java (see http://xmlgraphics.apache.org/fop/0.20.5/embedding.html#config-external).

I'll adress this issue with the new FOP api but if you need this now I'm happy to help you with it.

> Incorrect rendering of international characters in PDF reports created using XSL:FO
> -----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-170
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-170
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: framework, order
>            Reporter: Eriks Dobelis
>         Attachments: QuoteReport-7.pdf
>
>
> International characters in XSL:FO reports are replaced with # even if in the database, ecommerce webapp, catalog webapp, etc. characters are displayed correctly.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[Nicolas Malin (Jira)]

     [ http://issues.apache.org/jira/browse/OFBIZ-170?page=all ]

Eriks Dobelis updated OFBIZ-170:
--------------------------------

    Attachment: fo.diff

> Incorrect rendering of international characters in PDF reports created using XSL:FO
> -----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-170
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-170
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: framework, order
>            Reporter: Eriks Dobelis
>         Attachments: fo.diff, QuoteReport-7.pdf, QuoteReport.diff
>
>
> International characters in XSL:FO reports are replaced with # even if in the database, ecommerce webapp, catalog webapp, etc. characters are displayed correctly.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[Nicolas Malin (Jira)]

     [ http://issues.apache.org/jira/browse/OFBIZ-170?page=all ]

Eriks Dobelis updated OFBIZ-170:
--------------------------------

    Attachment: QuoteReport.diff

> Incorrect rendering of international characters in PDF reports created using XSL:FO
> -----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-170
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-170
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: framework, order
>            Reporter: Eriks Dobelis
>         Attachments: fo.diff, QuoteReport-7.pdf, QuoteReport.diff
>
>
> International characters in XSL:FO reports are replaced with # even if in the database, ecommerce webapp, catalog webapp, etc. characters are displayed correctly.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[Nicolas Malin (Jira)]

    [ http://issues.apache.org/jira/browse/OFBIZ-170?page=comments#action_12429749 ]
           
Eriks Dobelis commented on OFBIZ-170:
-------------------------------------

I added a patch that allows to provide user's userconfig.xml. This in turn would allow to specify fonts to be embedded in the report.
It reads fop.properties to get fop.path where userconfig.xml should be located.

The other patch is just changing fonts in QuoteReport.fo.ftl file so that it uses Arial (because you can freely get Arial with many types of encodings as opposed to Helvetica).

 UI elements still do not work correctly, but the data that is retrieved from database looks fine.

I suppose this should work for any character set which uses characters outside ISO Latin 1.

> Incorrect rendering of international characters in PDF reports created using XSL:FO
> -----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-170
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-170
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: framework, order
>            Reporter: Eriks Dobelis
>         Attachments: fo.diff, QuoteReport-7.pdf, QuoteReport.diff
>
>
> International characters in XSL:FO reports are replaced with # even if in the database, ecommerce webapp, catalog webapp, etc. characters are displayed correctly.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[Nicolas Malin (Jira)]

    [ http://issues.apache.org/jira/browse/OFBIZ-170?page=comments#action_12435181 ]
           
Jacopo Cappellato commented on OFBIZ-170:
-----------------------------------------

In order to test how characters are rendered you'll find useful the test report that you can run, in the content component, running this link:

https://localhost:8443/content/control/fonts.pdf

> Incorrect rendering of international characters in PDF reports created using XSL:FO
> -----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-170
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-170
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: framework, order
>            Reporter: Eriks Dobelis
>         Attachments: fo.diff, QuoteReport-7.pdf, QuoteReport.diff
>
>
> International characters in XSL:FO reports are replaced with # even if in the database, ecommerce webapp, catalog webapp, etc. characters are displayed correctly.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[Nicolas Malin (Jira)]

    [ http://issues.apache.org/jira/browse/OFBIZ-170?page=comments#action_12435412 ]
           
Eriks Dobelis commented on OFBIZ-170:
-------------------------------------

The report at content/control/fonts.pdf contains mainly characters in ISO Latin 1. Most of the latvian special characters are in Latin Extended-A.

> Incorrect rendering of international characters in PDF reports created using XSL:FO
> -----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-170
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-170
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: framework, order
>            Reporter: Eriks Dobelis
>         Attachments: fo.diff, QuoteReport-7.pdf, QuoteReport.diff
>
>
> International characters in XSL:FO reports are replaced with # even if in the database, ecommerce webapp, catalog webapp, etc. characters are displayed correctly.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[Nicolas Malin (Jira)]

    [ http://issues.apache.org/jira/browse/OFBIZ-170?page=comments#action_12439506 ]
           
Eriks Dobelis commented on OFBIZ-170:
-------------------------------------

Could somebody take a look at fo.diff, please? I understand why somebody might not like what I propose in QuoteReport.diff, but fo.diff allows to configure user settings for the fonts, which makes it more flexible (especially by allowing to attach custom fonts).

> Incorrect rendering of international characters in PDF reports created using XSL:FO
> -----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-170
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-170
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: framework, order
>            Reporter: Eriks Dobelis
>         Attachments: fo.diff, QuoteReport-7.pdf, QuoteReport.diff
>
>
> International characters in XSL:FO reports are replaced with # even if in the database, ecommerce webapp, catalog webapp, etc. characters are displayed correctly.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[Nicolas Malin (Jira)]

    [ http://issues.apache.org/jira/browse/OFBIZ-170?page=comments#action_12456111 ]
           
Christian Geisert commented on OFBIZ-170:
-----------------------------------------

This patch will not work with FOP 0.92 - I'll provide an updated patch.

> Incorrect rendering of international characters in PDF reports created using XSL:FO
> -----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-170
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-170
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: framework, order
>            Reporter: Eriks Dobelis
>         Attachments: fo.diff, QuoteReport-7.pdf, QuoteReport.diff
>
>
> International characters in XSL:FO reports are replaced with # even if in the database, ecommerce webapp, catalog webapp, etc. characters are displayed correctly.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira