Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Barcode Lotus Script Functions

 

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Barcoding in Lotus Notes and Lotus Approach

Purchase Via: IDAutomation

Approach

Our LotusScript barcode macros and functions are designed for the intermediate to advanced user of Lotus Notes, Approach and Lotus SmartSuite. Our Bar Code LotusScript functions for Lotus Notes and Approach work with our POSTNET, Code 39, Interleaved 2 of 5, Code 128, UPC-A, EAN-13, EAN-8, UCC-128, MSI / Plessy, Code 11, RM4SCC, 4-State, EAN-14, SSCC-18 and SCC-14 barcode fonts and specifications. The LotusScript funtions will generate check digits, add the Start and stop characters and format the return string for one of our barcode fonts. The LotusScript functions can be integrated into your Lotus application for automation purposes.

The LotusScript functions are ready to install and are only designed to calculate barcode strings for the barcode fonts available from ID-Automation.com . The macros, functions and LotusScript  source code are free to use as long as you are using them with one of our barcode fonts. They have been tested with Lotus Notes 4.51 and Lotus Approach 9.5. The download contains working examples and additional instructions for implementation.


User Comments:

"ID-Automation's barcodes quickly and easily integrated with our Lotus Notes Printing and Reporting Tool called Print Merge Express, which allowed us to provide our customers with additional barcode mail merge functionality, as well as displaying barcodes in Notes views."  - Lance Zakin, Certified Lotus Professional, IVE Technologies, http://www.PrintMergeExpress.com


Lotus Notes / Lotus Domino Barcode Tutorial

The database in the Lotus Notes download package was created in Lotus Notes 4.x. You must install the appropriate barcode font that is specified in the field to print and display the barcode. The Code 39 barcode fields in this database are calculated for display because they are easy to format.

Barcodes in Lotus Notes can be created from information in fields using 2 methods:

Method 1 - Use a formula with self-checking barcode fonts. This is by far the easiest method. The self checking fonts you can use are Code39, Codabar and Industrial 2 of 5. All you have to do is create a field computed for display that combines the Start and stop characters with the field.

For example, for Code39, the field formula would be: "*" + DataField + "*"

Method 2 - Using LotusScript. This method is only recommended for advanced Lotus Notes / Domino developers. Code128 and other more complicated barcodes require a LotusScript event and a LotusScript function. See the Lotus Script in the barcode database example for an example of how to implement these barcodes. In this database example, the LotusScript code that formats the Code128 field is located in the "QuerySave" Event of the form.

The LotusScript source code for the QuerySave event:

  1. Retrieves the data field.
  2. Calls the function to format the barcode.
  3. Saves the result to a field on the form during the save process.

The LotusScript source code for the QuerySave event:

Sub Querysave(Source As Notesuidocument, Continue As Variant) 

    Dim uiDoc As NotesUIDocument

    Dim uiWorkspace As New NotesUIWorkspace

    Set uiDoc = uiWorkspace.CurrentDocument

    'call the function to format the data from field SSN and save it to field Method2SSN

    Call uiDoc.FieldSetText("Method2SSN", Code128b(uiDoc.FieldGetText("SSN")))

End Sub

The LotusScript for the function that formats the text to the barcode font is called "Code128b" in the "Globals" definition for the form in this example. These must be imported from our file of LotusScript Functions. In Notes 4.5, there is a limit of how many functions that can be placed here so you will need to copy and paste only the functions you need.To copy the functions into the form:

  1. Open the ID-AutomationLS.lss file with a text editor. Copy everything in the declarations section at the top of the file into the declarations event.
  2. Then copy the functions you need from the ID-AutomationLS.lss LotusScript file into the "Options" event. After this, they will appear as an event in (Globals).

Please note that some functions require others and some require an additional argument. Every time the document is edited, the field will be updated. After the field is updated, it may be used on forms and in views with the appropriate barcode font selected. [LotusScript Function List | Lotus Notes Tutorial | Approach Tutorial ]


Lotus Approach Barcode Tutorial

You must install the appropriate barcode fonts before you can display or print them. For instructions, please refer to the font installation procedures.

Approach Barcoding Method 1 - Use a formula with self-checking barcode fonts. This is the easiest method of adding barcodes to Approach. The self checking fonts you can use are Code39, Codabar and Industrial 2 of 5. All you have to do is create a field computed for display that combines the Start and stop characters with the field.

For example, the field formula for a Code 39 font is Combine('*', DataField, '*')

  1. Create a new field in your database to place the barcode in.
  2. Choose Field Properties - Basics - Field Definition - Options.
  3. Then enter the formula in the Modification Formula box.
  4. Choose the correct barcode font for your barcode field, make sure it is centered in the box with some white space before and after the barcode.

Approach Barcoding Method 2 - Using LotusScript. Code128, UPC, EAN, Interleaved and other more complicated barcodes require a LotusScript event and a LotusScript function. In this database example, the LotusScript that formats the Code128 field is located in the "Change" Event of the form. A separate field must be created that will contain the barcode.

To copy the functions into your database:

Open your database. Press CTRL - K to open the LotusScript editor. Choose File - Import Script and choose the ID-AutomationLS.lss file which is included in the download package. After the scripts are imported, you should see several scripts listed in the script drop down box.Click the Object drop down box and browse to the field that contains the data you need to encode in the barcode.

Click the script drop down box and choose Change. Enter the following source code for the change event, changing the function name for the barcode you need (in this case the function is Code128b) and changing "DataField" and "BarcodeField" to the names of the fields in your database.Choose File - Save Scripts. Return to your database file.

Choose Design and choose the field that contains the barcode, in this case it is "BarcodeField". Then choose the appropriate barcode font so the barcode will be in the field. Make sure it is centered in the box with some white space before and after the barcode. Since this field now contains the data formatted to the barcode font, you can also use the data from this field in a mail-merge to create barcodes in Lotus Word Pro. And of course, you can use this field to display barcodes in forms, reports, envelopes, labels and letters.

When entering your data, the barcode field will be automatically updated when you tab to the next field, Choose CTRL - R,  Refresh or save the database.

NOTE: When selecting the font from the pull down menu, be sure not use the fonts that begin with the "@" Symbol .  Instead, scroll down in the list and select the ones that begin with "ID-Automation". [LotusScript Function List | Lotus Notes Barcode Tutorial | Approach Barcoding Tutorial ]


The Following LotusScript Functions are Available:

These functions are supplied in the file named "ID-AutomationLS.lss" which is provided in the Lotus Script download package. NOTE: You must use Interleaved 2 of 5 fonts dated May 1, 2001 or later for Interleaved 2 of 5 functions. You MUST use Code 128 fonts dated December 2000 or later for Code 128 functions.  

For all functions below the data input type is a single string. For all functions requiring second parameters, the second parameter is an integer. For example, Code128c("123456",0). For all number symbologies such as POSTNET and UPC, you may input dashes or spaces for easier readability and they will be filtered out by the function before the barcode is generated. For UPC-A, UPC-E & EAN-13 you can enter the +2 and +5 add-on codes by just adding them to the end of the string. 

Function Notes
Code128(Data, Number) If you are not sure which Code 128 set is for your application, then use this one. This is a "Code 128 Auto" function that will automatically encode any data from ASCII 0 to ASCII 127. It will automatically switch to character set C for numbers also.
To encode alpha-numeric UCC/EAN-128, ASCII 202 or character is entered as the FNC1 before each AI. For example, the UCC number of (8100)712345(21)12WH5678 should be entered as: 81007123452112WH5678.
(Data, 0) formats barcode output string for the Code 128 barcode fonts.
(Data, 1) returns the human readable data.
(Data, 2) returns only the check digit.
Code128a() Use the characters from set B to print characters not on the keyboard; the scanner will scan characters from set A. Formats output to the Code 128 barcode fonts.
Code128b() Returns codes formatted to the Code 128 character set B. Formats output to the Code 128 barcode fonts.
Code128c(Data, Number) This code128 function "interleaves" numbers into pairs for high density.
(Data, 0) formats output to the Code 128 barcode fonts.
(Data, 1) returns the human readable data with the check digit included.
(Data, 2) returns only the check digit.
I2of5() This function "interleaves" numbers into pairs for high density without check digits and formats the return string to the Interleaved 2 of 5 font.
I2of5Mod10(Data, Number) (Data, 0) performs the mod10 checksum calculation for increased accuracy and formats the return string to the Interleaved 2 of 5 font. MOD 10 checksums are required by USPS for special services and for SSC-14 when using Interleaved 2 of 5 for that purpose.
(Data, 1) returns the human readable data with the MOD10 check digit included.
(Data, 2) returns the MOD10 check digit.
Code39() Formats the output to print using Code 39 fonts.
Code39Mod43(Data, Number) (Data, 0) performs the mod43 checksum calculation for increased accuracy and then formats the output to print using Code 39 fonts. The mod43 checksum is usually required for LOGMARS and HIBC applications.
(Data, 1) returns the human readable data with the check digit included.
(Data, 2) returns only the check digit.
Codabar() Formats the output to print using Codabar fonts.
UCC128() Use this function for UCC/EAN-128 applications when you have already generated your MOD10 check digit if required. Supports UCC-128, EAN-128, SCC-18 and SCC-14. FNC1 automatically included after Start digit, enter "FA" between even numbers for additional FNC1 Codes. Formats the output to print using Code 128 fonts.
SCC14(Data, Number) SCC14(Data, 0) generates the MOD10 required and then formats the output to print EAN-14 and SCC-14 using Code 128 fonts. The input for Data must be a 13 to 17 digit number, however, only 13 are needed. The required application identifier of (01) is automatically added.
SCC14(Data, 1) returns the human readable data for SCC14 / EAN14.
SCC14(Data, 2) returns the MOD10 check digit.
SSCC18(Data, Number) SCC18(Data, 0) generates the MOD10 required for SSCC-18 and then formats the output to print SSCC-18 using Code 128 fonts. The input for Data must be a 17 to 21 digit number, however, only 17 are needed. The required application identifier of (00) is automatically added.
SCC18(Data, 1) returns the human readable data for SCC-18.
SCC18(Data, 2) returns the MOD10 check digit.
Postnet(Data, Number) Enter a single string of Zip, Zip + 4 or Zip + 4 + Delivery Point. The input for Data must be a number and can include dashes and spaces.
(Data, 0) formats output to the POSTNET barcode fonts.
(Data, 1) returns the human readable data with the check digit included.
(Data, 2) returns only the check digit.
USPSss(Data, Number) Used for 20 digit USPS special services numbers with Code 128 fonts. Enter a 19 or 20 digit number; only the first 19 are used. This function also calls Code128c().
(Data, 0) formats output to the Code 128 barcode fonts.
(Data, 1) returns the human readable data with the check digit included.
(Data, 2) returns only the check digit.
RM4SCC() Formats the output to print using RM4SCC fonts. Checksum calculated according to the mailsort customer barcoding specification.
MSI(Data, Number) (Data, 0) formats output to the MSI barcode fonts.
(Data, 1) returns the human readable data with the check digit included.
(Data, 2) returns only the check digit.
Code11() Only the "C" check digit is calculated which is the standard when encoding 10 digits or less.
UPCa() Enter UPC-A with or without a check digit, add-ons are supported. Formats output to the UPC/EAN barcode font.
UPCe<>() Enter the full 11 or 12 digit UPC-A number. The purpose of this function is to print the UPC-E barcode from a UPC-A barcode that can be compressed. It will print a UPC-A if it cannot be compressed by zero suppression rules. Formats output to the UPC/EAN barcode font.
EAN13() Enter EAN-13 with or without a check digit, add-ons are supported. Formats output to the UPC/EAN barcode font.
EAN8() Enter exactly 7 characters (EAN-8 without the check digit). Formats output to the UPC/EAN barcode font.
MOD10() Returns the MOD 10 check digit of a number string.

Purchase Via: IDAutomation

Special ! Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site or IdAutomation . Send payment proof to [email protected] 31 days after purchase date.



Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS