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 firstname.lastname@example.org and provide your corporate email address, company, and name.
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?
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
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 || '*';
TABLE FILE CAR
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
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.
WebFOCUS 8.2.03 (8.2.06 in testing)
Posts: 253 | Location: Melbourne, Australia | Registered: February 07, 2007
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 :
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, 2011
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