Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Bar Codes Generated in Reports?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Bar Codes Generated in Reports?
 Login/Join
 
Member
posted
We are looking into putting bar codes instead of a numerical code on our mailings. Ideally we would like to have the bar codes generated and exported in a WebFocus report. Does anyone do this? I found one link that mentioned briefly how to do this in a PDF format, but we would need a specific bar code for each person in an address list. Is this possible with WebFocus?

Thanks in Advance!


WebFocus 7703
 
Posts: 27 | Registered: April 04, 2012Report This Post
Virtuoso
posted Hide Post
We used to do this with an image generator into HTML, but that software disappeared, but the original code still works.

A different approach I've seen is here which generates Code 39 barcodes with js and css.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Virtuoso
posted Hide Post
I haven't done this, but you could use a free java bar code generator like barbecue and build a CALLJAVA routine to generate the images in your TEMPDISK, FOCCACHE or whatever. Then reference them in whatever output format you are looking for.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Guru
posted Hide Post
You can do this within WebFOCUS quite simply - once you have the fonts installed for PDF use anyway.

If you are just doing HTML then it's even easier.

1) Grab your self a barcode font - the Open Source barfonts (http://www.karrman.org/barfonts/) works well and can be set up for PDF easily.

2) Write your FEX. Note: for all the Code 39 fonts I found you needed to start and end your string with '*'

Here is an example from CAR

DEFINE FILE CAR
SERIAL/A50 = '*HAPPY-FROG-7856956*';
CNTRY_CODE/A50 = '*' || COUNTRY || '*';
END
TABLE FILE CAR
SUM 
     SALES
     CNTRY_CODE
BY  COUNTRY
HEADING
"<SERIAL"
" "
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
$
TYPE=REPORT,
     GRID=OFF,
$
TYPE=DATA,
     COLUMN=N3,
     FONT='BARCODE39',
$
TYPE=HEADING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     FONT='BARCODE39',
     SIZE=42,
$
ENDSTYLE
END  


When I scan the barcodes with my phone I get the names of the Country for each row. Shouldn't take to much to create individua; mailing labels.

Regards

Stuart


WebFOCUS 8.2.03 (8.2.06 in testing)
 
Posts: 253 | Location: Melbourne, Australia | Registered: February 07, 2007Report This Post
Virtuoso
posted Hide Post
quote:
Note: for all the Code 39 fonts I found you needed to start and end your string with '*'


I think I know why that is. If a scanner sees an '*' at both sides of the scanned code, then it knows it read the entire code and not just part of it.

For HTML; I know that in modern HTML you can embed fonts, which would allow directly using the font in your HTML report. I haven't looked into that yet, but this seems a good reason to do so. That seems preferable to drawing barcodes using spans of different widths...

Well, this guy seems to have worked most of it out for us: http://taggedzi.com/articles/d...edding-fonts-in-html
Now it's just a matter of adding the right CSS for the fields that you want to use barcodes for and make sure the stylesheet gets referenced correctly in your mailed messages.

This message has been edited. Last edited by: Wep5622,


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Member
posted Hide Post
This is what we do:
1. Define the bar code format:
POLICYN_BAR/A26=IF POL_LEN EQ 11 THEN '*' || '0' || POLICY_NUMBER || '00' || 'MCGCORR' || '===*' ELSE '*' || '0' || POLICY_CO || POLICY_NUM || '00' || 'MCGCORR' || '===*';
2. Put it in the letter footing:
FOOTING
"ON TABLE NOTOTAL
3. Format it:
TYPE=FOOTING,
FONT='IDAUTOMATIONHC39M',
SIZE=8,STYLE=NORMAL,
POSITION=(4.000000 11.00000),
$

Just remember that you need to load the bar code font on the server you're using.
 
Posts: 22 | Location: Tulsa, OK | Registered: February 17, 2011Report This Post
Member
posted Hide Post
oops. step 2 should be:
FOOTING
double quote - less than sign - bar code name - closing double quote
ON TABLE NOTOTAL
 
Posts: 22 | Location: Tulsa, OK | Registered: February 17, 2011Report This Post
Virtuoso
posted Hide Post
Yes, but that doesn't work for HTML I think? Unless you installed that particular font on all user PC's?

BTW, your markup broke; you need to put your code between code tags (the button marked </> in the toolbar).


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Platinum Member
posted Hide Post
YEs you can have a font in HTML that is not on the PC... Custom Font in HTML


Currenly working @ Learning Circle Education Services
Previously worked @ Nationwide Insurance
Prod: WebFOCUS 7.6.11


Test: WebFOCUS 7.6.11


Dev: WebFOCUS 7.6.11
 
Posts: 125 | Location: Columbus, Ohio | Registered: March 31, 2006Report This Post
Member
posted Hide Post
Thank you all! We first need to install the font, so I will start there. Thank you for help!


WebFocus 7703
 
Posts: 27 | Registered: April 04, 2012Report This Post
Platinum Member
posted Hide Post
If you are doing it via HTML then you wont need to install it just call the font file. Though not sure from a PDF perspective. Sometimes we have to end up displaying to HTML and then printing to PDF because we just cannot get PDF output from Focus to do what we want.


Currenly working @ Learning Circle Education Services
Previously worked @ Nationwide Insurance
Prod: WebFOCUS 7.6.11


Test: WebFOCUS 7.6.11


Dev: WebFOCUS 7.6.11
 
Posts: 125 | Location: Columbus, Ohio | Registered: March 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Bar Codes Generated in Reports?

Copyright © 1996-2020 Information Builders