Export foreign characters to PDF?

jaker over 6 years ago

Hi All,

I am using the Export to PDF smart service and my data contains foreign characters such as Russian, Chinese, etc. However, when the export generates the foreign characters are being written to the PDF as "#". To elaborate we use Export to Word then convert to PDF.

Does anyone have a workaround to get foreign characters into a PDF using Export to PDF?

Thanks in advance...

Discussion posts and replies are publicly visible

Parents

0 josep over 6 years ago

Hello Jaker,

I don't have an specific workaround but I saw this error before and there are ideas you can look at.
- When converting to PDF the library does not support the font (or the font itself doesn't contains that character)
- Try to use a font and charset available all around (DOC, Appian, PDF Converter)
- The encoding is not well specified,
- Does the word document displays the special characters properly?

Finally is you struggle too much I recommend consider the XSL-FO transformation with that you have little more control over this kind of things and additional you can control your pdf.

Jose
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Chitra Sharma over 6 years ago in reply to josep

Hi Josep, I am using PDF from XSL-FO smart service, but this is also not displaying characters as expected. I am passing a simple XML containing Japanese characters and associated XSL is also passed in. Any other consideration I am missing here. Thanks for your help!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 josep over 6 years ago in reply to Chitra Sharma

Hello can you attach an example to reproduce the error ?
Jose
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 josep over 6 years ago in reply to josep

BTW, Have you tried to use the Unicode?
 
www.w3.org/.../

Jose
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

0 Chitra Sharma over 6 years ago in reply to josep

XML Content-

<?xml version="1.0" encoding="UTF-8"?>
<record>
<name>Test</name>
<friend>
<!-- japanese unicode characters for 'hello'-->
	<name>&#12371;&#12435;&#12395;&#12385;&#12399;</name>
	<phNo>77890011</phNo>
</friend>
<friend>
<!-- japanese plain characters for 'hello'-->
	<name>こんにちは</name>
	<phNo>32323232323</phNo>
</friend>
</record>

XSL Content -

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.1" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format"	exclude-result-prefixes="fo">
<xsl:template match="record">
<fo:root xmlns:fo="http://www.w3.org/1999/XSL/Format">
  <fo:layout-master-set>
    <fo:simple-page-master master-name="my-page">
      <fo:region-body margin="1in"/>
    </fo:simple-page-master>
  </fo:layout-master-set>

  <fo:page-sequence master-reference="my-page">
    <fo:flow flow-name="xsl-region-body">
      <fo:block>Hello, <xsl:value-of select="name" />!</fo:block>
      <fo:block>
      	<fo:table>
      		 <fo:table-body>
      		 	<fo:table-row>
                	<fo:table-cell border="solid 1px black" 

			text-align="center" font-weight="bold">
                		<fo:block>
                    		No.
                  		</fo:block>
                	</fo:table-cell>
                	<fo:table-cell border="solid 1px black" 

			text-align="center" font-weight="bold">
                		<fo:block>
                    		Name
                  		</fo:block>
                	</fo:table-cell>
                	<fo:table-cell border="solid 1px black" 

			text-align="center" font-weight="bold">
                		<fo:block>
                    		Phone Number
                  		</fo:block>
                	</fo:table-cell>
                </fo:table-row>
                <xsl:for-each select="./friend">
                	<fo:table-row>
                	<fo:table-cell border="solid 1px black" text-align="center">
                		<fo:block>
                    		<xsl:value-of select="position()" />
                  		</fo:block>
                	</fo:table-cell>
                	<fo:table-cell border="solid 1px black" text-align="center">
                		<fo:block>
                    		<xsl:value-of select="name" />
                  		</fo:block>
                	</fo:table-cell>
                	<fo:table-cell border="solid 1px black" text-align="center">
                		<fo:block>
                    		<xsl:value-of select="phNo" />
                  		</fo:block>
                	</fo:table-cell>
                </fo:table-row>
                </xsl:for-each>
      		 </fo:table-body>
      	</fo:table>
      </fo:block>
    </fo:flow>
  </fo:page-sequence>
</fo:root>
</xsl:template>
</xsl:stylesheet>

Reply

0 Chitra Sharma over 6 years ago in reply to josep

XML Content-

<?xml version="1.0" encoding="UTF-8"?>
<record>
<name>Test</name>
<friend>
<!-- japanese unicode characters for 'hello'-->
	<name>&#12371;&#12435;&#12395;&#12385;&#12399;</name>
	<phNo>77890011</phNo>
</friend>
<friend>
<!-- japanese plain characters for 'hello'-->
	<name>こんにちは</name>
	<phNo>32323232323</phNo>
</friend>
</record>

XSL Content -

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.1" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format"	exclude-result-prefixes="fo">
<xsl:template match="record">
<fo:root xmlns:fo="http://www.w3.org/1999/XSL/Format">
  <fo:layout-master-set>
    <fo:simple-page-master master-name="my-page">
      <fo:region-body margin="1in"/>
    </fo:simple-page-master>
  </fo:layout-master-set>

  <fo:page-sequence master-reference="my-page">
    <fo:flow flow-name="xsl-region-body">
      <fo:block>Hello, <xsl:value-of select="name" />!</fo:block>
      <fo:block>
      	<fo:table>
      		 <fo:table-body>
      		 	<fo:table-row>
                	<fo:table-cell border="solid 1px black" 

			text-align="center" font-weight="bold">
                		<fo:block>
                    		No.
                  		</fo:block>
                	</fo:table-cell>
                	<fo:table-cell border="solid 1px black" 

			text-align="center" font-weight="bold">
                		<fo:block>
                    		Name
                  		</fo:block>
                	</fo:table-cell>
                	<fo:table-cell border="solid 1px black" 

			text-align="center" font-weight="bold">
                		<fo:block>
                    		Phone Number
                  		</fo:block>
                	</fo:table-cell>
                </fo:table-row>
                <xsl:for-each select="./friend">
                	<fo:table-row>
                	<fo:table-cell border="solid 1px black" text-align="center">
                		<fo:block>
                    		<xsl:value-of select="position()" />
                  		</fo:block>
                	</fo:table-cell>
                	<fo:table-cell border="solid 1px black" text-align="center">
                		<fo:block>
                    		<xsl:value-of select="name" />
                  		</fo:block>
                	</fo:table-cell>
                	<fo:table-cell border="solid 1px black" text-align="center">
                		<fo:block>
                    		<xsl:value-of select="phNo" />
                  		</fo:block>
                	</fo:table-cell>
                </fo:table-row>
                </xsl:for-each>
      		 </fo:table-body>
      	</fo:table>
      </fo:block>
    </fo:flow>
  </fo:page-sequence>
</fo:root>
</xsl:template>
</xsl:stylesheet>

Children

No Data