Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
19%
200 - 500 GB
13%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
13%
1500 - 2000 GB
19%
> 2000 GB
25%
Total votes: 16

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 27th June 2018, 15:05
litrax's Avatar
litrax litrax is offline
Senior Member
 
Join Date: Sep 2005
Location: Germany
Posts: 110
litrax is on a distinguished road
Baan: ERP LN (10.2.1) - DB: Oracle12c (12.1.0.2.0) - OS: Red Hat Enterprise Linux 7.1
Umlauts in PCL to PDF conversion
Baan: ERP LN 6.1 FP8 (Infor ERP 10.2)
C/S: Server

Hello everyone.

I know the topic PDF conversion was discussed a lot.
I already searched the forum for a solution but couldn't find one.

Here is my problem:

I took the idea (amongst others I think Vamsi was the most markable) of an own conversion script instead of ttstpconv to generate PDF files. It works really fine if you do it this way:
ttstpconv --> PS file --> ghostscript --> PDF file
or
some TXT file --> ttstpconv --> PS file --> ghostscript --> PDF file

BUT!

We have some User Fonts in some report layouts.
The reports for customers and suppliers look .... special.
Like bigger font for "Purchase Order" or other things to make the layout and look and feel of the business reports nicer.
Additionaly it could happen that a report layout has eg. UserFont5 but a field within the layout could have UserFont3.
When we print this to a printer the report looks fine, but as soon as we use ttstpconv to TXT, RTF or PS the report looks horrible. So converting to a PDF always needs a special report with NO UserFonts.
That's to know the background...

Now I thought if I make PDF files I want it
1. to look like the ones we print out
2. get rid of extra reports especially for the PDF conversion
Sounds good so far.

So I found a tool called "gpcl6" which is a Ghost PCL to PDF converter.
I used that in my baan conversion script and at a first glance it looked good.
The PDFs really look nearly identical to the print outs.
Now I have a conversion like this:
PCL --> gpcl6 --> PDF

Besides the problem that you cannot copy and paste the text of this PDFs I realised another big problem: We need german umlauts!
But in the files some umlauts are written and others are "hacked" with other letters or cryptic signs.
Further analysis showed that the umlauts are correct in layouts with UserFonts.
And on the other hand umlauts are not correct in layouts without UserFonts. In this layouts Baan uses just Small/Middle/Large for a font height and width definition. But I read somewhere that in this case an ANSI-font is used with the lack of german umlauts!

Has someone already had this problem and solved it?
I want to avoid to edit all layouts of all documents that could possibly be printed via PDF printer and change all this fonts to a UserFont and test it on some devices afterwards to see how it looks!
Is there a possibility to just add a standard font WITH umlauts?

How can I get rid of this problem?
Please advice...

P.S.: When it's all done without errors I post my script in " Code & Utilities" forum.

_
__________________
Have a lot of fun...

Please look at this before asking wholes in the stomach ;-)
http://www.baanboard.com/programmers_manual_baanerp
Reply With Quote
  #2  
Old 28th June 2018, 14:17
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,122
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well I do not know enough about ln so this may be way off base. In 4v4 we have print driver files out that there were you could possible go play and change what small/middle/large do. Basically an escape sequence I could play with to change fonts on. I only played with ghostscript once but was told we could not use it. That was years and years ago so not really sure how it works anymore.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 28th June 2018, 16:21
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,722
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Solutions

Hello,

Using HiDox should solve the Problem.

Maybe try another tool : pcl2pdf

https://www.componentsource.com/prod...df-unix/prices

HiDox is full integrated in BIV , LN

Regards
__________________
//Bernd
Reply With Quote
  #4  
Old 11th July 2018, 13:12
litrax's Avatar
litrax litrax is offline
Senior Member
 
Join Date: Sep 2005
Location: Germany
Posts: 110
litrax is on a distinguished road
Baan: ERP LN (10.2.1) - DB: Oracle12c (12.1.0.2.0) - OS: Red Hat Enterprise Linux 7.1
Thank you for your answers. Finally the answer was so easy as always...

You just have to specify a font in the driver file in $BSE/lib/printinf/<letter>/<driverfile> .
In our driver file there was no specific font for the three print sizes large, middle and small. So I specified a font:

OLD: small=\E(s0p16.67h8.5v0T\E&k7.0H,
NEW: small=\E(12U\E(s0p16.67h8.5v4099T\E&k7.0H,

For now all the details and stuff that have a small font in its report layout defined are printed in Courier. Perhaps I change it sometimes...

But the main problem, that no special font is defined and gpcl takes an ansi font without Umlauts, is solved. Now I have Courier in those layouts and gpcl takes Courier also. WITH Umlauts!


Now the only left disadvantage of pcl2pdf is that the text is not copieable and not searchable!
__________________
Have a lot of fun...

Please look at this before asking wholes in the stomach ;-)
http://www.baanboard.com/programmers_manual_baanerp
Reply With Quote
  #5  
Old 11th July 2018, 14:10
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,122
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Quote:
Originally Posted by litrax View Post
Now the only left disadvantage of pcl2pdf is that the text is not copieable and not searchable!
Are you saying you cannot search the pdf file it creates?
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #6  
Old 11th July 2018, 16:47
litrax's Avatar
litrax litrax is offline
Senior Member
 
Join Date: Sep 2005
Location: Germany
Posts: 110
litrax is on a distinguished road
Baan: ERP LN (10.2.1) - DB: Oracle12c (12.1.0.2.0) - OS: Red Hat Enterprise Linux 7.1
Yeah. Its a known issue of gpcl6. Cause pcl was never intended to create a text or pdf file but just to simply print files on a printer. If you want to search a string in this pdf files, than it wont find it. Also you cannot copy text. Tough in my case it's broken.

There might be solution which I don't know yet.
For example I found this tool which says it produces searchable pdfs from pcl:
http://www.visual.co.uk/pcl2pdf.html

If anyone has a solution for this in linux. And pls do NOT suggest any tool to buy
__________________
Have a lot of fun...

Please look at this before asking wholes in the stomach ;-)
http://www.baanboard.com/programmers_manual_baanerp
Reply With Quote
Sponsored Links
  #7  
Old 12th July 2018, 19:11
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,122
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
I did not know that about ghostscript. Before converting could you use another type format besides PCL? Not sure what formatting differences there might be.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #8  
Old 13th July 2018, 14:18
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,355
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Have you tried considering iText library? I have designed several reports with foreign languages using simple Java programs. Just another option. Never tried gpcl.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #9  
Old 17th July 2018, 07:58
litrax's Avatar
litrax litrax is offline
Senior Member
 
Join Date: Sep 2005
Location: Germany
Posts: 110
litrax is on a distinguished road
Baan: ERP LN (10.2.1) - DB: Oracle12c (12.1.0.2.0) - OS: Red Hat Enterprise Linux 7.1
Yeah I know. iText is the state of the art converter library. Perhaps I try it out. Infor and many others ( FreePDF I think ) use it too
Look in $BSE/java

Thanks for the help. I'll find a solution now...
__________________
Have a lot of fun...

Please look at this before asking wholes in the stomach ;-)
http://www.baanboard.com/programmers_manual_baanerp
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
BPF to PDF conversion nitisha Tools Development 0 21st June 2016 13:26
PDF Conversion and custom workflow utility (python) fmathias Code & Utilities 0 14th June 2012 22:41
Creating PDF documents with logo dthomson Third Party Products 4 30th July 2008 15:59
EDI - Item Code Conversion In shaboo Distribution, Transportation & Warehousing 2 12th April 2006 14:16
Urgent help req -Customized Item Conversion factor noorulhaq Manufacturing & Supply Chain 0 7th June 2003 07:32


All times are GMT +2. The time now is 05:21.


©2001-2018 - Baanboard.com - Baanforums.com