Wasp Labeler User Manual
Copyright © 2012 Wasp Barcode Technologies 1400 10th St. Plano, TX 75074 All Rights Reserved STATEMENTS IN THIS DOCUMENT REGARDING THIRD PARTY PRODUCTS OR SERVICES ARE BASED ON INFORMATION MADE AVAILABLE BY THIRD PARTIES. WASP BARCODE TECHNOLOGIES AND ITS AFFILIATES ARE NOT THE SOURCE OF SUCH INFORMATION. THE INFORMATION IN THIS DOCUMENT IS SUBJECT TO CHANGE WITHOUT NOTICE.
Wasp Labeler User Manual Table of Contents Chapter 1 - Getting Started ...................................................................................................................... 1 1.1 Introduction .................................................................................................................................... 1 1.2 Getting Started - Wasp Labeler Capabilities.................................................................................... 2 1.
Wasp Labeler User Manual Wasp Labeler User Manual 4.9 Creating a Wasp Labeler Data Source........................................................................................ 155 4.9.1 Deleting Columns or Data From the Database: .................................................................... 158 4.10 Sorting Data Source Content .................................................................................................... 158 4.10.1 Method 1: Sort Data Using Column Headers ...................
Wasp Labeler User Manual Chapter 1 - Getting Started 1.1 Introduction Thank you for your purchase of the Wasp Labeler barcode creation software. This topic contains information that will help familiarize you with barcodes and show you how to create customized barcodes. The Introductory Materials section contains important information you should familiarize yourself with prior to creating barcodes.
Wasp Labeler User Manual 1.2 Getting Started - Wasp Labeler Capabilities Wasp Labeler is a professional label generation application designed to meet the most demanding barcode labeling and printing requirements. Easily generate barcode labels, asset or inventory labels, address labels and envelopes with PostNet Zip Codes, ID badge labels, business checks, and date and time stamps for perishable goods, then print your labels from any local or network Windows printer.
Wasp Labeler User Manual Wasp Labeler supports Static, Serialization, Prompt at Print Time, External Data Source, Bind to Another Object, and Date/Time for objects. The 'Prompt at Print Time' feature is used to interactively enter information onto the label at print time. The 'External Data Source' feature allows you to import, view, and edit information from the most common databases and allows your Text and Bar Code objects to retrieve their source value from an external file.
Wasp Labeler User Manual 1.3 Getting Started - What is a Barcode? A barcode is a graphical representation of a set of numeric or alphanumeric characters that can be read by a barcode scanner. 1234 becomes: Whse1 becomes: . . Assigning a permanent barcode to each site, location, item, supplier and customer creates an environment where a mobile device can be used to easily keep track of inventory movements and alleviates the problem of data-entry errors.
Wasp Labeler User Manual 1.4 Getting Started - Navigating the Main Screen In this topic: Help/Resizing Icons Accessing Help Resizing/Minimizing Wasp Labeler Tabs Icon Toolbar Design Window Properties Box Hide/Show the Properties Box Move the Properties Box This topic provides a brief overview of Wasp Labeler's Main screen. The Main screen provides access to all of the features and functions you will need to create customized labels or to create labels using the templates.
Wasp Labeler User Manual 1.4.1 Section A: Help/Resizing Icons This section contains icons that allow you to adjust the size of the Labeler screen, access this Help file or close the Labeler window. Accessing Help Launching the Help File: You can launch this Help file from anywhere in the Labeler application by clicking the question mark icon in the top right of the screen. Using this method launches the Help with the topic related to the currently open screen/tab displayed.
Wasp Labeler User Manual Resizing/Minimizing Wasp Labeler Wasp Labeler can be resized to fit your whole screen or reduced to appear as a portion of your screen. To resize the window, click the icon in the top, right of the Main screen, as shown below: The screen will reduce in size when the icon is clicked. You can resize the screen by dragging any of the corners or borders. Labeler will remember the size when it is closed and re-opened.
Wasp Labeler User Manual Layout Options - Use these options to change the layout of your label or to hide/show the ruler along the top and side of the label. View - The View menu allows you to zoom in or out. Changes you make will appear in the Label Design window. Data Tab: The Data Tab allows you to add a database, spreadsheet, .csv file or other data source to your label project. You can then associate an object on your label, such as a text field or a barcode with the data source.
Wasp Labeler User Manual Print Tab: The Print Tab contains functions relating to printing your labels, including Page Layout.
Wasp Labeler User Manual 1.4.3 Section C: Icon Toolbar The tabs at the top of the Main screen allow you to switch between functionalities. The tabs act as a way to group Wasp Labeler's features together by task. For instance, the File tab contains functionality related to opening a new file, closing a file, saving a file, etc., while the Design tab contains functionality related to creating and designing your labels.
Wasp Labeler User Manual 1.4.5 Section E: Properties Box The Properties box contains options specific to the type of object you have selected in the Design window (barcode, text box, picture or drawing object). You can hide the Properties box or "dock" it in a different location as needed. Hide/Show the Properties Box The Properties box is displayed on the Main screen by default. This box displays information relating to the tab you are currently using.
Wasp Labeler User Manual Move the Properties Box By default the Properties Box is docked on the right side of the Labeler screen. You can move, or redock, the Properties Box to the center-left, center-right or left side of the screen as needed. 1. Click on the top of the Properties Box and drag it. The box will undock from it's current location and appear as a small, floating box similar to the example shown below: 2. Drag the box to the center or left of the screen.
Wasp Labeler User Manual 3. Drag the box to an arrow.. The screen will highlight yellow indicating the area in which the box will appear if docked there. In the example shown below, the box would appear from the center of the window to the right. You can then let go of the box and it will dock where indicated. To move the Properties box back to the default location, click the Reset Docking icon on the Design Tab toolbar.
Wasp Labeler User Manual 1.5 Getting Started - Creating a Static Label Now that you are familiar with the basics of moving around the Main screen, you can begin creating your labels. This topic will take you through the steps to create the most basic label - a static barcode label. A static label means the information on it does not change. The label does not pull information from a database, isn't serialized, etc.
Wasp Labeler User Manual 3. Define your barcode: By default, a Code128 barcode with content123456789 will be placed onto your label. Use the Properties box to select the appropriate barcode and enter the content (what you want encoded in the barcode). a. Make sure the barcode is selected in the Design window. b. Click the Barcode tab in the Properties box. c. Make sure Code 128 is selected in the Symbology drop down box. d. Enter the data you want encoded in the barcode into the Content box.
Wasp Labeler User Manual Note that your label changes to display Jane Doe123456 below the barcode. e. Now that we have the content in the barcode, we can specify how it should be formatted. In this case, we want the employee ID number to appear below the employee name. To do this, click the ellipse (...) button to the right of the Content field. The Special Characters menu option appears. Place your cursor where you want the break to occur. Here we will place the cursor after the e in Doe.
Wasp Labeler User Manual The barcode on your design label will look similar to the following: 4. Add additional objects to your label: You can include additional objects on your label as needed. In the case of the name badge we are creating in this example, a graphic such as a picture of the employee or a company logo might be included. To add objects, you will follow the same steps you used for adding a barcode. Click on the icon of the object you want to add and drag it to your label. 5.
Wasp Labeler User Manual The example in the screen shot above shows a layout of 4 labels per page. To change the type of label, click the Layout button on the toolbar. The Page Setup screen appears: The Page Setup screen allows you to choose a different label template or create custom templates. The template should match the label stock you are using. For our example label, we want to print just one employee badge for Jane Doe.
Wasp Labeler User Manual Click Done to close the Page Setup screen. Notice that the Print Preview window changes based on the Family and Type of label you selected. The Properties box indicates that 8 labels will be printed, because this particular type of label (Avery Name Badge) has 8 labels per page. We just want to print one label, so in the Number of Labels section select Specify and enter 1 as shown below: 7. Print your label: Now you are ready to print your label.
Wasp Labeler User Manual 1.6 Getting Started - Binding a Data Source to an Object Now that you can create a basic label (see Getting Started - Creating a Static Label), let's try binding a data source to an object. This allows you to create one label template, attach a database to it, then let Labeler pull information from the database when printing.
Wasp Labeler User Manual 2. Select an External Data Source on the Data tab. We'll add a data source to this project using the Data tab. Your data source options are listed on the Data tab.
Wasp Labeler User Manual Select the type of database you want to add. For this example, we want to add a .txt file that contains a list of employee ids, and names so click on Text.
Wasp Labeler User Manual The Data Source - Text File (delimited) screen appears: Select your file and the associated Delimiter, then click Apply. For detailed instructions on adding a Text file, see the topic Connecting to a Text File. 3. Bind an object on the label to a column in the data source. On the Design tab, select the object to which you want to bind data. The property options for the selected object appear in the Properties box.
Wasp Labeler User Manual Here we have selected the barcode object and want to bind it to the Employee ID column in the data source. On the Properties box > Content tab, click the Database button. A window appears displaying all available columns from the data source. Select the appropriate column from the drop down list and click Done. Notice that the Properties Box now indicates that this object is using the Employee ID column as the data source.
Wasp Labeler User Manual 1.7 Getting Started - Using String Builder to Concatenate Data In the previous example we learned how to add a data source to the label project and bind an object to a column within that data source. Now let's learn how to concatenate, or combine, two different columns. Joined data is called a "string". Creating strings allows you to bind data from two different columns in your data source to one object.
Wasp Labeler User Manual 2. Create a String using String Builder. On the Properties Box > Content tab, click the String Builder button.
Wasp Labeler User Manual The String Builder screen appears. For this example we want to create a string containing two database columns: Employee Last Name and Employee First Name. Let's assume we want the Last Name first, then a comma and a space, followed by the First Name. The result should look like this: Doe, John a. First, select Database Column from the drop down, then click the Add Substring button.
Wasp Labeler User Manual The Data Source - Database screen appears allowing you to select a column. b. Select Employee Last Name, then click Done.
Wasp Labeler User Manual The substring appears in the window as shown: c. Now repeat Steps a and b, but this time select Employee First Name from the drop down list and click Done. Another substring will be added. d. Highlight the substring Column: Employee First Name and select Add Space Before in the Substring Properties box.
Wasp Labeler User Manual e. Now we just need to add the comma. To do this, we'll add a static substring with the character "," in it. Select Static from the drop down menu, then click Add Substring. The Static content screen appears. Enter a comma in the text box provided, then click OK. f. The Static substring appears in the String list. Highlight it and click the up arrow icon once to move it between the Employee Last Name and Employee First Name substrings.
Wasp Labeler User Manual g. Notice that your sample data at the bottom of the String Builder screen now shows the correct formatting for your data. Click OK to save your new string. The Content Source for your text box now shows .
Wasp Labeler User Manual 1.8 Getting Started - Creating Enumerated Labels A common need when printing labels is a "label counter" or "copy counter". Counters tell you what number out of a set each label represents: i.e. 1 of 12, 2 of 12, 3 of 12, etc. You can create these counters using a text field and the String Builder screen. You have four counter field options on the String Builder screen: Label Counter - This counts the number of unique labels. Label Total - The total number of unique labels.
Wasp Labeler User Manual 7. Now select Static from the drop down and click Add Substring. The Static window appears. 8. Highlight the sample text and type "of" (without quotation marks), then click OK. 9. With your Static substring highlighted in the list, select Add > SPACE Before and Add > SPACE After.
Wasp Labeler User Manual 10. Finally, select Label Total from the drop down list and click Add Substring. Label Total will be added to your substring list. Your screen should look similar to the following: 11. On the Print tab enter 20 in the Number of Labels > Specify field.
Wasp Labeler User Manual Now your label will look similar to the following: Example Two: You are sending a shipment to a customer. The items will be packed into two separate boxes. You need identical labels on each box with a counter indicating 1 of 2 and 2 of 2. Steps: 1. Create your label as desired 2. Add a textbox to your label. 3. With the textbox selected, click String Builder in the Properties Box > Content tab. The String Builder screen appears. 4.
Wasp Labeler User Manual The Static window appears. 6. Highlight the sample text and type "of" (without quotation marks), then click OK. 7. With your Static substring highlighted in the list, select Add > SPACE Before and Add > SPACE After. 8. Finally, select Copy Total from the drop down list and click Add Substring. Copy Total will be added to your substring list. Your screen should look similar to the following: 9. On the Print tab enter 2 in the Number of Copies > Manual from User field.
Wasp Labeler User Manual 1.9 Getting Started - Example Labels Wasp Labeler includes a set of example labels that you can access for a quick demonstration of various Labeler features. Choosing an example label is a good starting point for your label design. Review the descriptions in the list of example labels and choose one that best fits your needs. 1. On the File tab, select the Example Templates icon. The Example Templates screen appears.
Wasp Labeler User Manual 2. Scroll through the list of available label templates. Highlight a label to see a preview and description. 3. To open an example template in the design window, highlight a template and click the Open button. The label will open in the design window.
Wasp Labeler User Manual You can click on any of the elements on the label and see their associated properties in the Properties box. You can do a "Save As" function to save the label under a different name and make changes to it as needed. You cannot make changes directly to the label template. If you try to save changes directly to the template file, the following screen appears: Click OK on the warning screen to pick a new name and location for your new label.
Wasp Labeler User Manual 1.10 Barcode Symbology Reference Note: All example barcodes use the Wasp Labeler default properties unless otherwise noted. C|D|E|G|I|M|P|Q|U C Codabar Codabar is a variable length symbology capable of encoding 16 characters within any length message. Codabar can encode six special characters ("+" (plus), "-" (minus), "$" (dollar sign), "/" (slash), ":" (colon), and "." (point)) and all numeric digits.
Wasp Labeler User Manual Code 128 Code 128 is variable length and encodes the full 128 ASCII character set. Each character is represented by 11 modules that can be one of four bar widths. Code 128 is the most easily read code with the highest message integrity due to several separate message check routines. Of all the common linear symbologies, Code 128 is the most flexible. It supports both alpha and numeric characters easily, has the highest number of characters per inch, and is variable length.
Wasp Labeler User Manual Code 93 Code 93 encodes the full 128 ASCII character set using 9 modules arranged into 3 bars with adjacent spaces. Two of the characters are check characters. Code 93 is similar to Code 39 but encodes more characters per inch. Code 93 encodes the full 128 ASCII character set and is encoded similarly to Code 39 Extended.
Wasp Labeler User Manual EAN/JAN 8 Example EAN/JAN 13 Example G GS1 (Formerly RSS) The GS1 family contains three linear symbologies to be used with the GS1 (formerly EAN.UCC) system. The use of this symbology is intended to comply with the GS1 application guidelines. GS1 bar code symbols are intended for encoding identification numbers and data supplementary to the identification.
Wasp Labeler User Manual GS1Stacked Omnidirectional allows the full height GS1-14 to be printed in two rows of two segments each, which reduces the overall length of the linear bar code so it can fit better on certain packaging configurations. The separator pattern between the two rows is designed to eliminate cross-row scanning errors.
Wasp Labeler User Manual ISBN The International Standard Book Number (ISBN) is a unique machine-readable identification number used to identify books. ISBN is based on an ISO International Standard that was first published in 1972 as ISO 2108. ISO 2108 specifies the basic structure of an ISBN, the rules for its allocation, and the administration of the ISBN system. ISBN barcodes have consisted of 13 digits since 2007. Prior to 2007 they contained 13 digits.
Wasp Labeler User Manual M MaxiCode Predominantly used by United Parcel Service to sort mail at high speed, MaxiCode is well suited to being read quickly and often in any direction. MaxiCode is a fixed-size 2D matrix barcode symbology having 866 hexagonal elements arranged in 33 rows around a central finder pattern. The size of a MaxiCode symbol is 1.1 inch by 1.05 inch. A single MaxiCode symbol can encode up to 93 characters of data and uses five different code sets to encode all 256 ASCII characters.
Wasp Labeler User Manual MSI The MSI character set consist of the numbers 0..9 as well as two "guard" characters (representing the beginning and end of the barcode). The symbology does not support alphabetic characters. MSI Example P PDF417 PDF417 is a stacked linear barcode symbol format used in a variety of applications, primarily transport, identification cards, and inventory management. PDF stands for Portable Data File. Each character consists of 4 bars and 4 spaces in a 17 module structure.
Wasp Labeler User Manual POSTNET Example PLANET PLANET stands for Postal AlphaNumeric Encoding Technique and is used by the United States Post Office to identify and track pieces of mail. This barcode can be 12 or 14 digits long. PLANET Example Q QR Code A QR code (abbreviated from Quick Response code) is a specific matrix barcode (or two-dimensional code) that is readable by dedicated QR barcode readers and camera telephones.
Wasp Labeler User Manual UPC-A Example UPC-E To allow the use of UPC barcodes on smaller packages where a full 12-digit barcode may not fit, a 'zero-compressed' version of UPC was developed called UPC-E. This symbology differs from UPC-A in that it only uses a 6-digit code, does not use middle guard bars, and the end bit pattern (E) becomes 010101. The way in which a 6-digit UPC-E relates to a 12-digit UPC-A is determined by the last (righthand most) digit.
Wasp Labeler User Manual Chapter 2 - File Tab 2.1 File Tab Overview The File tab contains basic functions that you would typically find on a Windows File menu. The Open, Close and New Document functions are found on this tab. You can access the Example Templates here or search for updates to Labeler. In addition, you can Activate the product from this tab and view the About screen. File Toolbar Function Descriptions • New Label - Click the New Label icon to open a new label project in the Design window.
Wasp Labeler User Manual • About - Opens the About screen. The About screen lists the version number and serial number of your product. For a description and example of the About screen please refer to the topic About Screen. • Update License - This icon only appears if you are running Wasp Labeler in Trial Mode. Click on this button to access the Activate Labeler screen where you can enter your activation code and register your software. • Exit - Closes the Wasp Labeler application.
Wasp Labeler User Manual 3. The Barcode Information section of the Export Barcode...screen lists the Symbology and Value encoded into the barcode. Note: If the barcode is bound to a database or other external source, the placeholder value will appear in the Value field. In the Target section, select the Format to which you want to convert your barcode. Options are: Bitmap Image (BMP) GIF Image (GIF) JPEG Image (JPG) PNG Image (PNG) TIFF Image (TIFF) WMP Image (WMP) 4.
Wasp Labeler User Manual Chapter 3 - Design Tab In this topic: Design Toolbar Function Descriptions Clipboard Insert Arrange Layout Options View The Design tab contains all of the options for customizing your label. This tab allows you to place items such as barcodes, text boxes, graphics and drawing objects onto your label. This topic provides details on the functions contained on the Design tab.
Wasp Labeler User Manual 3.1 Design Toolbar Function Descriptions The toolbar on this tab is divided into 5 sections: 1. 2. 3. 4. 5. Clipboard Insert Arrange Layout Options View Clipboard - This section contains basic commands: • Cut - Removes the selected object from the canvas and saves it to the clipboard. • Copy - Copies the selected object from the canvas and saves it to the clipboard. • Paste - Places an object saved to the clipboard onto a new location.
Wasp Labeler User Manual Adding a Barcode. Arrange - The Arrange menu allows for precision placement of objects or text you insert onto your label. • Rotate - This option allows you to rotate a select object clockwise or counter clockwise. Note that you can also use the top grab point on a selected item to rotate it as shown below: • Align - This option allows you to align a selected object or multiple selected objects. You can align Left, Right, Top, Bottom, Vertical Center or Horizontal Center.
Wasp Labeler User Manual If you want to change your base object, hold down the SHIFT key and click on a different object. The blue outline will change to the newly selected object. The previous base object will still be selected for alignment, but will no longer be the base object. Example - Using the Align Function You have three barcodes on your label and you want to align two of the barcodes centered horizontally relative to the third one.
Wasp Labeler User Manual Now select Align > Horizontal Center. The barcodes are now aligned relative to the center of the first barcode you selected. • Space - This option allows you to evenly space multiple selected objects across or down. • Bring to Front - Use this option to move a selected object in front of other objects. • Send to Back - Use this option to move a selected object behind other objects. • Bring Forward - Use this option to move a selected object forward.
Wasp Labeler User Manual Layout Options - Use these options to change the layout of your label or to hide/show the ruler along the top and side of the label. • Units/Ruler - Changes the ruler units. Options are Inches, Centimeters and Millimeters • Layout - Accesses the Page Setup screen where you can choose the label type/size. • Reset Docking- You can move and "redock" the Properties box to the left or center of the Labeler window (by default it is docked on the right side of the screen).
Wasp Labeler User Manual 2. You can move the drawing object by clicking on it and dragging it. Resize the object by clicking on a corner of the object and dragging it. You can also enter precise size and location coordinates in the Properties Box > Format tab. Options are: • • • • • • • • Object Name - You can optionally enter a new name for the object here. Left - Enter the precise location you want your barcode relative to the left side of the label.
Wasp Labeler User Manual Note: By default the unit of measurement is inches. To change this, select Units/Ruler on the Design tab toolbar and select a different unit of measure. The units on the Format tab will update with the new unit of measure. 3. Add color and/or change the line size using the options in the Drawing section of the Properties box. Options are: • Line Color - This is the color of the outline of your drawing object (or the color of the line). This color defaults to Black.
Wasp Labeler User Manual Click on a color to select it or click More Colors...to view the Advanced Color Palette screen, shown below: Click on an area of the palette and/or drag the arrow up or down on the shade bar. A sample of your color appears in the lower, left corner. Click OK to save your selection. • Line Style - Select how you want the outline to appear (dashed, solid, dot, etc.) from the drop down menu. • Line Width - Enter how thick you want the outline (in pixels).
Wasp Labeler User Manual 3.3 Adding a Picture In this topic: Adding a Picture to a Label Picture Properties Box: Format Tab Picture Properties Box: Content Tab You can add pictures to your label either "statically", meaning you add a single picture that will appear on all labels, or you can link a picture placeholder to a database and have Labeler pull the pictures onto each label at print time. Labeler allows import of bitmap files (*.bmp), JPEG (*.jpg, *.jpeg, *.jpe, *jfif), PNG (*.png), TIFF (*.tiff, *.
Wasp Labeler User Manual For Pictures Bound to a Database: If you do not want to import a single graphic, click Cancel on the browser window. This inserts a Placeholder representing your image as shown below: You can now use the Format tab or the buttons on the Design toolbar to edit the placement/alignment of your image. Use the Properties Box > Content tab to bind the picture object to a data source.
Wasp Labeler User Manual 3.3.2 Picture Properties Box: Format Tab The Format tab allows you to specify an exact location for a selected barcode on your label. You can also enter precise height and width measurements on this tab. Below is an example of the Format tab. The Format tab is divided into two sections, General and Picture. Format Tab - General Options are: • • • • • • • Left - Enter the precise location you want your barcode relative to the left side of the label.
Wasp Labeler User Manual Note: By default the unit of measurement is inches. To change this, select Units/Ruler on the Design tab toolbar and select a different unit of measure. The units on the Format tab will update with the new unit of measure. Format Tab - Picture Options are: • Picture File - If you imported a graphic, the path to it will be listed here. Click the ellipse button (...) to open a browser window to choose a new graphic file.
Wasp Labeler User Manual 3.3.3 Picture Properties Box: Content Tab The Content tab allows you to specify the content of your barcode (if you are not using a static picture). Below is an example of the Content tab. Basic Source Section The Basic Source section lets you choose a source for the picture. Your options are: Database Prompt at Print Clear Content Section Click the Clear Content button to remove the currently selected data source (including a string).
Wasp Labeler User Manual 3.4 Adding a Barcode Adding a barcode to your label is as simple as dragging and dropping it where you want it to appear. After you have placed your barcode, you can select a symbology, choose a data source (or bind it to a data source you have added via the data source screen) or add static content, add and format a caption, etc. For a detailed example of adding a static barcode to your label, please refer to the topic Getting Started - Creating a Static Label. 3.4.
Wasp Labeler User Manual 2. Define your barcode by using the Barcode Properties box - Barcode Tab to select the symbology and any available optional settings for the selected symbology. 3. You can move your barcode on your label by clicking on it and dragging it where you want. You can enter precise location coordinates using the Barcode Properties box - Format Tab. 4. Attach your barcode to an external data source or define serialization, date/time, etc using the Barcode Properties box - Content Tab.
Wasp Labeler User Manual 3.4.2 Adding a Barcode: Properties Box In this topic: Entering Static Data Barcode Tab Format Tab Content Tab Basic Source Section String Builder Section Formatting Section After you add a barcode to a label, the Properties box populates with the options available to barcodes (symbology, data source, formatting, etc.
Wasp Labeler User Manual 2. Enter your data directly into the Content text box. If you need to add special characters to your barcode, click the ellipse (...) button to the right of the Content field. The Special Characters list appears. Special Characters are ASCII Codes. These are printable and non-printable markers that tell a printer, scanner, etc. how to handle spaces. For a complete list of ASCII Codes available, please refer to the topic ASCII Special Character Codes. 3.
Wasp Labeler User Manual Barcode Tab: The Barcode tab on the Properties box is where you will select the symbology for your barcode. This tab also has fields for precision placement of your barcode. Below is an example of the Properties Box > Barcode tab. The options available on this tab vary depending on the symbology you have selected. The example below is with Code 128 selected, the actual screen will look slightly different depending on your selected symbology.
Wasp Labeler User Manual Format Tab: The Format tab allows you to specify an exact location for a selected barcode on your label. You can also enter precise height and width measurements on this tab. Below is an example of the Format tab. The Format tab is divided into three sections: General, Caption and Drawing. Format tab - General options are: • • • • • • Object Name - You can optionally enter a new name for the barcode object.
Wasp Labeler User Manual • • Display on Print - Make sure this checkbox is selected if you want the barcode to display when your label is printed. Anchor - Select where you want to anchor the barcode on the page. For example, if you set the Anchor to Right, if the barcode grows or shrinks due to variable data from a data source, the Right side will stay in the same position and the barcode will "grow" from the left.
Wasp Labeler User Manual Click on a color to select it or click More Colors...to view the Advanced Color Palette screen, shown below: Click on an area of the palette and/or drag the arrow up or down on the shade bar. A sample of your color appears in the lower, left corner. Click OK to save your selection.
Wasp Labeler User Manual Content Tab: The Content tab allows you to specify the content of your barcode (if you are not using static data). Below is an example of the Content tab. This tab is divided into four sections: • Basic Source - This section is where you can bind the barcode to a data source, object, serial number or alpha, date/time, etc. • Strings - To add more than one data source to the barcode, use the String Builder.
Wasp Labeler User Manual Basic Source This section lets you choose the data that will be encoded into your barcode. Click on a source type to bind it to your object (barcode, graphic or textbox). Source options for barcodes are: Database Date/Time Serial Alpha Another Object User Defined List Serial Number Prompt at Print String Builder To add more than one data source to the barcode, use the String Builder.
Wasp Labeler User Manual Clear Content Click the Clear Content button to remove the currently selected data source (including a string). When this button is selected, the following question screen appears: Click Yes to remove the current data source or No to cancel and keep the data source.
Wasp Labeler User Manual 3.4.3 Barcode Properties Code 128 Properties Box Options The table below lists the options available for Code 128 in the Properties box > Barcode tab. Code 128 Field Description Select Code 128 from the drop down list. For a complete list of Symbology available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines density of the barcode.
Wasp Labeler User Manual Aztec Code Properties Box Options The table below lists the options available for Aztec Code in the Properties box > Barcode tab. Aztec Code Field Description Select Aztec Code from the drop down list. For a complete list of Symbology available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines the size of the barcode (along with error correction and code module size).
Wasp Labeler User Manual Codabar Properties Box Options The table below lists the options available for Codabar in the Properties box > Barcode tab. Codabar Field Description Select Codabar from the drop down list. For a complete list of Symbology available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines how tall your barcode will be. The bar height Bar Height does not affect density.
Wasp Labeler User Manual Code 39 Properties Box Options The table below lists the options available for Code 39 in the Properties box > Barcode tab. Code 39 Field Description Select Code 39 from the drop down list. For a complete list of Symbology available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. Select this checkbox if you want this to be Code 39 Extended Extended symbology.
Wasp Labeler User Manual Code 93 Properties Box Options The table below lists the options available for Code 93 in the Properties box > Barcode tab. Code 93 Field Symbology Bar Height Description Select Code 93 from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines how tall your barcode will be. The bar height does not affect density.
Wasp Labeler User Manual Code 11 Properties Box Options The table below lists the options available for Code 11 in the Properties box > Barcode tab. Code 11 Field Symbology Bar Height Description Select Code 11 from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines how tall your barcode will be. The bar height does not affect density.
Wasp Labeler User Manual EAN/JAN 8 Properties Box Options The table below lists the options available for EAN/JAN 8 in the Properties box > Barcode tab. EAN/JAN 8 Field Symbology Description Select EAN/JAN 8 from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. % of Nominal The nominal size for a EAN/JAN barcode is 1inch. The usual reduced size is 80% of the nominal size.
Wasp Labeler User Manual Interleaved 2 of 5 Properties Box Options The table below lists the options available for Interleaved 2 of 5 in the Properties box > Barcode tab. Interleaved 2 of 5 Field Symbology Bar Height Description Select Interleaved 2 of 5 from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines how tall your barcode will be.
Wasp Labeler User Manual ISBN Properties Box Options The table below lists the options available for ISBN in the Properties box > Barcode tab. ISBN Field Description Select ISBN from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. Symbology % of Nominal The nominal size for a EAN/JAN barcode is 1inch. The usual reduced size is 80% of the nominal size.
Wasp Labeler User Manual Ratio This is the wide to narrow bar ration. The default setting is 2 (2:1). Bearer bars are lines that can be added to frame your barcode. Your options are None, Top and Bottom and Top, Bottom and Sides. Bearer bars must be included in horizontal form for codes printed on labels, and as a full box (with H gauges) when printed directly on corrugated surfaces.
Wasp Labeler User Manual MicroPDF417 Properties Box Options The table below lists the options available for MicroPDF417 in the Properties box > Barcode tab. MicroPDF417 Field Symbology Bar Height Bar Width Version Description Select MicroPDF417 from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines how tall your barcode will be.
Wasp Labeler User Manual MicroQRCode Properties Box Options The table below lists the options available for MicroQRCode in the Properties box > Barcode tab. MicroQRCode Field Symbology Description Select MicroQRCode from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. Select the Code Version for your barcode.
Wasp Labeler User Manual MSI Properties Box Options The table below lists the options available for MSI in the Properties box > Barcode tab. MSI Field Symbology Bar Height Description Select MSI from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines how tall your barcode will be. The bar height does not affect density.
Wasp Labeler User Manual PDF417 Properties Box Options The table below lists the options available for PDF417 in the Properties box > Barcode tab. PDF417 Field Symbology Bar Height Description Select PDF417 from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines how tall your barcode will be. The bar height does not affect density.
Wasp Labeler User Manual POSTNET Properties Box Options The table below lists the options available for POSTNET in the Properties box > Barcode tab. POSTNET Field Columns Description Select POSTNET from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines how tall the short bars on your barcode will be. The bar height does not affect density.
Wasp Labeler User Manual QR Code Properties Box Options The table below lists the options available for QR Code in the Properties box > Barcode tab. QR Code Field Symbology Description Select QR Code from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. Select the Code Version for your barcode.
Wasp Labeler User Manual GS1-14 Properties Box Options The table below lists the options available for GS1-14 Code in the Properties box > Barcode tab. GS1-14 Field Symbology Bar Width Bar Height Description Select GS1-14 from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines density of the barcode.
Wasp Labeler User Manual GS1 Stacked Omnidirectional The table below lists the options available for GS1 Stacked Omnidirectional in the Properties box > Barcode tab. GS1 Stacked Omnidirectional Field Symbology Bar Width Bar Height Description Select GS1 Stacked Omnidirectional from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines density of the barcode.
Wasp Labeler User Manual GS1 Expanded Properties Box Options The table below lists the options available for GS1 Expanded in the Properties box > Barcode tab. GS1 Expanded Field Symbology Bar Width Bar Height Description Select GS1 Expanded from the drop down list. For a complete list of available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. This setting determines density of the barcode.
Wasp Labeler User Manual UPC-A Properties Box Options The table below lists the options available for UPC-A in the Properties box > Barcode tab. UPC-A Field Description Select UPC-A from the drop down list. For a complete list of Symbology available symbologies along with examples and descriptions of each, please refer to the topic Barcode Symbology Reference. Nominal symbol height for UPC-A is 25.9 mm (1.02 in.) You can set % of Nominal the magnification from 80% to 200%.
Wasp Labeler User Manual 3.5 Adding a Text Box Labeler allows you to add Text Boxes to your label and place them where you need them using the drag and drop method. You can bind your text box to a variety of data sources, or enter static text (text that does not change as labels are printed). 3.5.1 Steps to Add a Text Box 1. On the Label Design tab click the Text Box icon on the toolbar. Drag and drop the icon where you want the text box to appear on your label (you can change the location at any time).
Wasp Labeler User Manual 2. You can move the text box on the label by clicking on it and dragging it where you want it. Enter precise location coordinates and size using the Text Box Properties box - Format Tab. 3. Attach your text box to an external data source or define serialization, date/time, etc using the Text Box Properties box Data Source tab.
Wasp Labeler User Manual 3.5.2 Adding a Text Box: Properties Box After you add a barcode to a label, the Properties box populates with the options available to barcodes (symbology, data source, formatting, etc.) You can use these options to define the information encoded in your barcode, the caption that appears with your barcode and even allows for precise location placement on your label.
Wasp Labeler User Manual 2. Enter your data directly into the Content text box. If you need to add special characters to your text box, click the ellipse (...) button to the right of the Content field. The Special Characters List appears. Special Characters are ASCII Codes. These are printable and nonprintable markers that tell a printer, scanner, etc. how to handle spaces. Note that for text boxes, the only available Special Characters are and .
Wasp Labeler User Manual Format Tab: The Format tab allows you to specify an exact location for a selected text box on your label. You can also enter precise height and width measurements on this tab. Below is an example of the Format tab. The Format tab is divided into two sections: General and Text.. Format tab - General options are: • • • • • • • • Object Name - You can optionally enter a new name for the text box object.
Wasp Labeler User Manual Note: By default the unit of measurement is inches. To change this, select Units/Ruler on the Design tab toolbar and select a different unit of measure. The units on the Format tab will update with the new unit of measure. Format tab - Text options are: • Justification - Select an option from the drop down list to set the justification of your text box. Options are Left, Center or Right. • Font - Click the ellipse button (...) to select a font for your caption.
Wasp Labeler User Manual Select the desired font from the Font Family drop down menu. Click on the desired Typeface and font Size. A sample of your selections will appear in the Sample section. Click OK to save your selections or Cancel to close the Font screen without saving your selection. • Auto Size - Select how you want Labeler to handle text wrapping for your text box. Options are Size Rectangle to Text (default) or Wrap Text to fit Rectangle.
Wasp Labeler User Manual This tab is divided into four sections: • Basic Source - This section is where you can bind the text box to a data source, object, serial number or alpha, date/time, etc. • String Builder - To add more than one data source to the data source (serial number plus static content, for example), use the String Builder. • Formatting - This section allows you to build on the general formatting done to the caption on the Format tab.
Wasp Labeler User Manual Formatting The Formatting section on the Properties box > Content tab allows you to add formatting to your barcode caption or to the value encoded in your barcode. To do this you will create a Format Expression using the Format Value and Format Caption buttons in this section. Click here for detailed instructions on formatting barcode values and captions and for a list of standard characters used to create Format Expressions.
Wasp Labeler User Manual 3.6 Content Options 3.6.1 Object Data Source - Date/Time You can set your object (text box or barcode) to display the current date/time or a set date/time. Steps to Add Date/Time to an Object 1. With the text box or barcode selected in the Design window, select the Date/Time option from the Properties box > Data Source tab. The following screen appears: 2. Select what information you want to appear or be encoded in the object from the Includes drop down list.
Wasp Labeler User Manual 5. If you want the date to start earlier or later than today, enter in the duration in the Offset by Years, Months, Days fields. For example, to start the dates one year from the current date, enter 1 in the Years fields or click the up arrow once. To start the dates one year prior to today, enter -1 in the Years field or click the down arrow once. Notice that an example of how your date/time will look appears in the Sample field. 6. Click OK to save your data. 3.6.
Wasp Labeler User Manual 3. Enter the beginning character in the Start at seed: field, then enter how many characters you want to increase per a set number of labels in the Step and Every fields. For example, the default settings (shown in the screen shot above) sets the serialization to start at letter A and increase one letter (step) every one label. So each label will go up one level. Changing the Every field to 2 means that the alpha serialization will increase one letter (step) every 2 labels. 4.
Wasp Labeler User Manual 3.6.3 Object Data Source - Database You can attach, or bind, your barcode, graphic or text box to a database to obtain data. For example, if you are creating conference badges, you may have attendee names in one database. You can create your label, then attach various objects to different columns in the database from which they can pull data. You might have a text box pull data from the company column and a barcode with a caption pull data from an employee name column.
Wasp Labeler User Manual 2. The Content Source - Database screen allows you to "map" a column in your data source to the selected object. For example, if you are creating a name badge, you might "map" the column containing employee names to a text box. Keep in mind that you can use this screen to map one column to your object. If you want to add data from more than one column to an object, use the String Builder to concatenate (join) data. 3.
Wasp Labeler User Manual 3.6.5 Object Data Source - User Defined List Labeler contains a set of lists you can use as a data source, or you can create a custom list. Steps to Bind an Object to a User Defined List 1. Select an object (barcode, picture or text box) in the Design window, then click on the Properties Box > Data Source tab and select User Defined List.
Wasp Labeler User Manual 2. There are three pre-built lists contained in Labeler: Colors.txt, State Abbreviations.txt and State Names.txt. You can select one of these lists from the drop down: or click Manage Lists to create a new list or select a list you have already created.
Wasp Labeler User Manual 3. This browser window opens to the folder on the machine where Labeler was installed. In this folder are the three pre-built lists. You can create a new list from scratch by rightclicking anywhere in the window and selecting New > Text Document. Save the file with the name of your choosing (make sure the extension stays .txt) then doubleclick on the file name to open and edit the document. The new list will appear in the browser window.
Wasp Labeler User Manual 3.6.6 Object Data Source - Serial Number The Serial Number setting allows you to serialize your labels numerically. Objects that can be serialized numerically are Barcodes and Text boxes. To Create a Serial Number Object 1. With the object (Text or Barcode) in the Design window, click the Serial Number button on the Properties box > Data Source tab. The following screen appears: 2.
Wasp Labeler User Manual 6. In the Serialization Configuration section, check the checkbox if you want to do one of the following: - increment the number with each new record in an external data source, or - resume the serialization where it left off at the next printing. 7. Click the Preview button to view how your serialization will look. Below is an example of the Serialization Preview screen: 8. By default 100 samples are displayed.
Wasp Labeler User Manual 3.6.7 Object Data Source - Prompt at Print Prompt at Print is used to permit keyboard entry of information onto the label during the Print process. Prompt at Print should be considered when the label information is available only at the time of print. The Prompt at Print Time information is not stored anywhere; it is dynamically input by the user when the label is configured to print. Prompt at Print can be used with Text, Barcode or Picture objects.
Wasp Labeler User Manual 6. Click Next to move on to the next label. 7. Select the Loop continuously checkbox to apply the data you entered in the Value field to that object on all labels. 8. Click the Print button when you have finished entering values at all the prompts.
Wasp Labeler User Manual 3.6.8 String Builder To add more than one data source to the barcode, use the String Builder. Substrings concatenate, or join, different values to build what appears to be a single text or barcode object on the label from multiple data sources. This option can be used for the following: 1. To customize, or build, the caption of a barcode by combining two or more data sources (static plus date/time, for example). 2.
Wasp Labeler User Manual String Builder Screen - Text Boxes 2. Select the data source from the drop down menu, then click the Add Substring button. The options will vary depending on the type of object you have selected. Options are: • • • • • • • • • Database Column - This option allows you to select a column from the data source associated with your label file. You must have a data source associated with the current label in order to use this option.
Wasp Labeler User Manual • • • a label counter on a text box. A Label Counter counts the number of physical, unique labels that are printed (determined in the Number of Labels fields on the Print tab). Label Total (Text Box Only) - This option displays the total number of physical, unique labels printed. Copies Counter (Text Box Only) - This option allows you to put a copies counter on a text box.
Wasp Labeler User Manual A sample of the entire string appears in the Sample result after concatenating all substrings field. You can reorder substrings by clicking the up or down arrows to the right of the substring list: You can edit a substring by clicking on the Pencil icon or delete it by clicking the red X icon. 4. To edit Substring Properties, highlight a substring in the window.
Wasp Labeler User Manual 5. For dynamic data sources that pull data from an external source, such as a text file or Access database, you can enter a place holder in the Place Holder field. The content you enter here will appear in the text box or barcode as a 'place holder' for display purposes, but will change to the content pulled from the external source at print time. 6. Select the Add checkbox(s), then select Carriage Return or Space from the drop down.
Wasp Labeler User Manual Steps to Access and Use the Format Value/Caption Screen 1. There are two methods for accessing the Format screen. a. After you have added a barcode or text box to your label and bound data to it, click on the Format Value or Format Caption buttons in the Properties Box > Content Tab > Formatting section.
Wasp Labeler User Manual b. If you are creating an object with substrings, click String Builder in the Strings section. Add a Substring, then click Data Formatting (the Data Formatting button will be disabled until you create at least one substring). For detailed information on creating substrings, please refer to the String Builder topic. The Format Value/Format Caption screen appears. Note: The Format Value and Format Caption screens are identical and function the same way.
Wasp Labeler User Manual Formatting Character Definitions and Examples The tables below contain the formatting characters, their meanings and additional information about each one. You will combine these characters to create your format expression. Character Definition Number Formatting Additional Information Examples Display a digit or a zero. If there is a digit in the position where the 0 appears in the format string, display it; otherwise display a zero in that position. 1234.5678 0 # .
Wasp Labeler User Manual technique. For example, you can use the format string "##0,," to represent 100 million as 100. Numbers smaller than 1 million are displayed as 0. Two adjacent commas in any position other than immediately to the left of the decimal separator are treated simply as specifying the use of a thousand separator. The actual character used as the thousand separator in the formatted output depends on the Number Format specified in the International section of the Control Panel.
Wasp Labeler User Manual Character @ & < > ! "ABC" Definition String Formatting Additional Information and Examples Display a character or a space. If there is a character in the string being formatted in the position where the @ appears in the format string, display it; otherwise, display a space in that position. Placeholders are filled from right to left unless there is an ! character in the format string. Display a character or nothing.
Wasp Labeler User Manual Custom Date and Time Formatting (DATEFORMAT Command) Labeler always stores date as DateTime format. This means that if you have a column in your data that is just a date, Labeler will add the default time of 12:00:00 AM to it. If you do not want to show the time on your label, use the DATEFORMAT function described below.
Wasp Labeler User Manual HH Hour The hour using a 24-hour clock from 00 to 23. 1:33:45 PM = 13 9/26/2011 1:33:45 AM = 01 9/26/2011 1:33:45 PM = 13 9/26/2011 1:01:45 AM = 1 m mm Minute Minute The minute from 1 through 59 The minute from 00 through 59 M Month The month from 1 through 12. MM Month The month from 01 through 12. MMM Month The abbreviated name of the month. MMMM Month The full name of the month s Second The second from 0 through 59.
Wasp Labeler User Manual 9/26/2011 1:01:45 AM = : 9/26/2011 The date separator. 1:01:45 AM = / 9/26/2011 Indicates that the enclosed characters should be copied to the result 1:01:45 AM string unchanged. ("arr:" h"m t) arr: 1:45 A 9/26/2011 Defines the following character as a custom format specifier. 1:01:45 AM (%h) = 1 : Time The time separator.
Wasp Labeler User Manual Example Data and Time Format Expressions Enter a custom date format in the format shown below: [DATEFORMAT:] The “DATEFORMAT:” prefix must be specified, followed by the section. Inside the you can enter any valid formatting string from the table above. The [] brackets are required.
Wasp Labeler User Manual Example 3 [DATEFORMAT: hh:mm tt] If the value Dec 1, 2011 5:15:35 PM is entered, the Test Results will display 05:15 PM. Example 4 [DATEFORMAT: MMMM dd, yyyy hh:mm tt] If the value Dec 1, 2011 5:15:35 PM is entered, the Test Results will display December 01, 2011 05:15 PM.
Wasp Labeler User Manual Removing Unwanted Spaces from Data (TRIM Command) There may be instances where data source has spaces at the end or beginning of data. You can use the "TRIM" function to remove unwanted spaces from the final output on your label. The formatting commands for removing spaces are provided below: • • • • • • • • • • • • [LEFT:3] - This command returns the first 3 characters from the input.
Wasp Labeler User Manual Line Feed Vertical Tab Form Feed Carriage Return Shift Out Shift In Data Link Escape Device Control 1 Device Control 2 Device Control 3 Device Control 4 Negative Acknowledgment Synchronous Idle End of Transmission Block Cancel End of Medium Substitute Escape File Separator Group Separator Record Separator Unit Separator Space Delete The remaining codes
Wasp Labeler User Manual Chapter 4 - Data Tab 4.1 Data Tab Overview In this topic: Select an External Data Source Sort the Data Source Content Filter the Data Source Content Join Tables Refresh Data Edit Connection Remove Connection The Data tab allows you to add a database, spreadsheet, .csv file or other data source to your label project. You can then associate an object on your label, such as a text field or a barcode with the data source using the Properties > Contents box on the Design tab.
Wasp Labeler User Manual On the Data tab you can add one external data source and define which columns and rows you want to include. Adding a data source here makes it available to bind to objects on the Design Tab. Select an External Data Source To create a connection to an external data source, click on the desired data source type on the Data tab.
Wasp Labeler User Manual 4.2 Connecting to a CSV File 1. On the Data tab click the CSV option. 2. The Data Source - Comma Separated File screen appears: 3. Enter the file name and location or click the Browse button to navigate to the file. When you click Browse, a browser window will appear allowing you to navigate to your file.
Wasp Labeler User Manual Enter 0 (zero) to return all rows of data. Keep in mind that a very large number of rows may result in slower performance. 6. Click Test Connection to make sure Labeler is able to successfully establish a connection to the selected file. If a connection is established, the message shown below appears: Click OK on the Test Connection message to close it. 7. Click Apply to add the connected file to your Labeler project.
Wasp Labeler User Manual 4.3 Connecting to a Microsoft Access Database 1. On the Data tab click the Access option. 2. The Data Source - Microsoft Access screen appears: 3. Click Browse to navigate to the Access database. After you make your selection the path will appear in the File Name field.
Wasp Labeler User Manual 4. If you have security setup on the database, enter your user name and password. This is the same User Name and Password used when opening the database directly. You can click the Test Connection button to make sure you are connected to the database. If a connection is established, the message shown below appears: Click OK on the Test Connection message to close it. 5. Click Apply to select the database.
Wasp Labeler User Manual 4.4 Connecting to an Excel File 1. On the Data tab click the Excel option. 2. The Data Source - Microsoft Excel screen appears: 3. Enter the file name and location or click the Browse button to navigate to the file. When you click Browse, a browser window will appear allowing you to navigate to your file.
Wasp Labeler User Manual 5. The maximum rows included in your label defaults to 1,000. You can enter a smaller or larger number as needed in the Max Rows field. Enter 0 (zero) to return all rows of data. Keep in mind that a very large number of rows may result in slower performance. 6. You can click the Test Connection button to make sure you are connected to the database. If a connection is established, the message shown below appears: Click OK on the Test Connection message to close it. 7.
Wasp Labeler User Manual 4.5 Connecting to Microsoft SQL Server 1. On the Data tab click the MSSQL option The Data Source - Microsoft SQL Server screen appears: 2. Any SQL servers setup on your network will appear in the Server drop down menu. Select the desired Server from the drop down. 3. If you have your SQL server setup to accept Windows Authentication, select the Use Windows Authentication checkbox (default).
Wasp Labeler User Manual 5. Click Apply to add the database to your label project. The Data tab will display the selected data. 6. You can now perform the following functions: Refresh the Data Edit the Connection Remove Connection Sort the Data Filter the Data Join two or more tables 4.6 Data Source - ODBC Compliant Data Source 1. On the Data Source tab click the ODBC option. 2.
Wasp Labeler User Manual 3. Click the ODBC Configuration button to configure the connection. The Connection Properties screen appears. 4. The installed ODBC driver read from your system will appear in the Data Source field. If you want to select a different driver, click the Change button. The Change Data Source screen appears. The Change Data Source screen is a Microsoft screen. From here you can select a different data source and make changes to it or to the connection.
Wasp Labeler User Manual b. Enter the beginning and ending delimiter in the Begin and End fields. For instance, if the data in the ODBC data source is divided by commas, enter commas here. Brackets appear by default. Some ODBC drivers have difficulty handling square brackets [ ] in the query string. c. Select the Use only when table or column contains: checkbox and accept the default entry or enter a new parameter in the text field. d. Click Reset to return the options to the default values. e.
Wasp Labeler User Manual 2. Select QuickBooks® from the Source Type drop down list, then click the OK button. The following Connecting to QuickBooks® message appears: As indicated in the warning message, you may see a QuickBooks® message similar to the one shown on the screen after you close the Connecting to QuickBooks® message screen. Select the Don't show me this reminder again checkbox if you don't want this message to display each time you connect to QuickBooks®. 3.
Wasp Labeler User Manual 4. If you see a QuickBooks® screen similar to the one indicated in the Connecting to QuickBooks® message, select one of the following options, then click OK Yes, Prompt each time Yes, Whenever this QuickBooks® company file is open Yes, Always: allow even if QuickBooks® is not running 5. A screen will appear showing all data from QuickBooks®. You can set up a filter to limit the data you bring into your Labeler file. 6.
Wasp Labeler User Manual 7.
Wasp Labeler User Manual 4.8 Connecting to a Text File (delimited) 1. On the main Data Source tab click the Text option 2. The Data Source - Text File (delimited) screen appears: 3. Enter the file name and location or click the Browse button to navigate to the file. When you click Browse, a browser window will appear allowing you to navigate to your file.
Wasp Labeler User Manual 4. Select the Delimiter from the drop down menu. Options are: Comma (default) Semicolon Tab Space Other.. If you select Other, enter the delimiter in the text box to the right of the Delimiter field. 5. If the first row of your file contains column headers, make sure the First Row is Column Headings checkbox is selected. 6. The maximum rows included in your label defaults to 1,000. You can enter a smaller or larger number as needed in the Max Rows field.
Wasp Labeler User Manual 8. Click Apply to add the connected file to your Labeler project. The data contained in the selected file will appear on the Data tab as shown in the example below: 9.
Wasp Labeler User Manual 4.9 Creating a Wasp Labeler Data Source Wasp Labeler provides the capability to creating a new data source from within the application. Labeler generates a Wasp Data File (extension .WDF) and provides the capability to create a single database table by entering the column and data. Use this option only when you want to create labels that will be composed of one or more variable fields for which you do not currently have an external data source. 1.
Wasp Labeler User Manual 3. Click Create New Wasp Data Source. The New Wasp Labeler Data Source screen appears. 4. Two sample columns appear in the Create Column section. Click in the Column1 area and type in a new column header. 5. Press TAB or click in the Type field and select the type of data that will be contained in this column. Options are: String - This can be a combination of text and numbers. Date Number 6. Click in the Column2 field and repeat steps 4 and 5. 7.
Wasp Labeler User Manual 8. After you have created your columns, you are ready to add data to them. Any columns you have created will appear as column headings in the Enter Data section as shown in the example below: Click in a field and add data that corresponds to the column heading and type. You can tab from field to field to speed up data entry. 9. When you have completed entering data, click the Save button. A browser window appears.
Wasp Labeler User Manual 4.9.1 Deleting Columns or Data From the Database: Highlight the row(s) you want to delete, then click the Delete Selected button. Press the CTRL + A keys on your keyboard to select all rows. Select multiple rows by pressing SHIFT + Click. 4.10 Sorting Data Source Content After you have attached a data source to your project, you can sort the data on the Data tab. Sorting is a useful way to make sure your data prints in the order you want.
Wasp Labeler User Manual 4.10.2 Method 2: Sort Data Using the Sort Button Using the Sort button allows you to create and save multiple sort criteria. This is useful if you want to sort by multiple criteria. For example, you may want to sort alphabetically by Company, then alphabetically by employee name. 1. On the Data tab, select the Sort button on the toolbar.
Wasp Labeler User Manual The top of the screen displays all sort criteria you have already created along with their status (active or inactive). The bottom of the screen shows a preview of your data with one of the sort criterion applied. You can only have one criterion set as active at a time. 2. To add a new criterion select the Add button at the bottom of the Sort Criteria List. The Add Sort Criteria screen appears: 3. Enter the name of your new Sort Criterion in the Sort Criteria Name field. 4.
Wasp Labeler User Manual 8. Check the Set as Active checkbox if you want the sort criteria you just created to be applied to your data. 9. Click OK to save your new criteria. Click Clear to delete the criteria and start over. When you click OK the Sort Criteria List screen appears displaying your changes: 10. To change which sort criteria is currently active, highlight a listing, then click the Set as Active button. 11. Click Done on the Sort Criteria List to return to the Data Source tab.
Wasp Labeler User Manual 4.11 Filter the Data Source Content Filtering the data source content on the Data tab allows you to only the data that meets the criteria you specify. For example, if the data source contains a list of item numbers, descriptions, and quantity in stock, you can display only the item numbers that are out of stock (QTY=0). 4.11.1 Creating a Filter 1. After you have selected a data source on the Data tab, click the Filter button on the toolbar.
Wasp Labeler User Manual 2. Click Add to create a new filter for the selected data source. The Filter Criteria screen appears: 3. Enter a name for the filter in the Filter Criteria Name field. An operator selection bar appears at the top of the screen. Click in the middle of the bar to toggle between the And and Or operators. Leave the first filter as And.
Wasp Labeler User Manual 4. Click the green + sign to add a criterion to this filter. A new criterion bar appears: 5. The first drop down menu contains the columns from your data source. Select a column from the first drop down. 6. Select a parameter from the second drop down. Options are: • • • • • • Is equal to Is not equal to Is less than Is less than or equal to Is greater than or equal to Is greater than 7. Enter a value in the last field.
Wasp Labeler User Manual You can add additional parameters as needed by clicking the green join icon. As you add criteria, the preview window will continue to update to display what your results will look like with the filter applied. 8. Click Save and Close to save the new filter and return to the Filter Criteria List. The new filter will appear on the Filter Criteria List. 9. Highlight the desired filter and click the Set as Active button to apply it to the database results.
Wasp Labeler User Manual When you have an active filter applied to the data source contents, the name of the filter currently in use will appear in the contents preview window as shown below: 166
Wasp Labeler User Manual 4.11.2 Deleting a Filter 1. Click the Filter icon on the Data tab toolbar. The Filter Criteria List appears. 2. Highlight the filter you want to delete, then click the Delete button. The following warning message appears: 3. Click Yes on the warning message to delete the filter.
Wasp Labeler User Manual 4.12 Joining Tables After selecting a data source on the Data Source tab, one or more tables (or spreadsheets) can be selected for use with the label you are designing. While you can't select more than one data source at a time for your label, you can select more than one table within a single data source. In order to use data from more than one table, you will need to join the tables by creating a link between them.
Wasp Labeler User Manual 4.12.1 Steps to Join Tables 1. After selecting a data source on the Data tab, click the Join button.
Wasp Labeler User Manual 2. On the Join Tables screen, click the Add button. The Add Link screen appears: 3. On the Add Link screen select the table, spreadsheet, .csv or .txt file from which you want to create a link in the From Table drop down menu. All available tables, spreadsheets, etc. from the selected data source will appear here. A list of columns in the selected table, spreadsheet, etc. will appear in the top preview pane.
Wasp Labeler User Manual 4. Select the column from which you want to create a link using the From Column drop down menu. 5. Now select the table, spreadsheet, etc. to which you want to link using the To Table drop down menu. 6. Select the column to which you want to create a link using the To Column drop down menu. A list of columns in the selected table, spreadsheet, etc. will appear in the bottom preview pane .
Wasp Labeler User Manual 7. Click the Save button to create your link. Your link will now appear in the List of Links window on the Join Tables screen. 8. Click Save on the Join Tables screen to return to the Data tab. 9. All columns from both tables, spreadsheets, etc. will appear in the Properties > Select Columns to Use on Label window. Select those columns you want to use on your label and deselect those you do not want to use on your label. The preview window will update with your column selections.
Wasp Labeler User Manual 4.13 Refreshing Data Source Information When you establish a connection to a data source, the data contained within the selected file is added to your Wasp Labeler project and displayed on the Data Source tab. While the path/connection information is retained, a constant, live connection to the file is not maintained, meaning that changes made within the source file after you create the Labeler connection will not be reflected in the Labeler project.
Wasp Labeler User Manual 4.14 Editing the Data Source Connection The Edit Data Source Connection allows you to change from one external data source to another, as long as they are the same time. For example, if you are connected to an Excel file, but want to change to a different Excel file, you can use the Edit function to browse to the new file. Keep in mind that any filters or sorts you have created for your existing external data source will be deleted.
Wasp Labeler User Manual 4.15 Removing the Data Source Connection To completely break a connection with a data source and remove the data source's information from your project, use the Remove Connection function. You will use this function if you want to delete the data source information and change your label to a static label (that does not use an external data source at all) or if you want to change to a different external data source type.
Wasp Labeler User Manual Chapter 5 - Print Tab 5.1 Print Tab Overview In this topic: Print Toolbar Function Descriptions Print Tab Properties Box Number of Copies Number of Labels Starting Label and Order Data Source Prompt at Print Time Function The Print tab provides a preview of how your printed labels will look.
Wasp Labeler User Manual 5.1.1 Print Toolbar Function Descriptions Layout (Page Setup)- The Layout icon accesses the Page Setup screen where you can choose the label type/size. Sort - Sort accesses the Sort Criteria List where you can create a new sort. Keep in mind that when the Sort function is accessed from the Print tab, any sort criteria already created and set as active on the Data Source tab will already be applied to the data.
Wasp Labeler User Manual The Find screen allows you to enter parameters to search for specific data. Enter the text or number for which you want to search in the Find text box, then select a controller and the column in which you want to search. For example, here we have entered Payroll Liabilities in the Find text box, selected the Equal (=) controller and the Name column. This means Labeler will look for any text that equals Payroll Liabilities in the Name column. 5.1.
Wasp Labeler User Manual • Specify - Enter the number of labels for each record you want to print in the text box. In the example below a value of 10 is entered. This means that 10 labels for each record in your data source (if you are using one) will be printed. Enter 1 in the Specify field if you want one label for each record in the data source to print.
Wasp Labeler User Manual Example 2: The label is pulling data from an external data source. If you have 3 records in the data source and you enter 5 in the Number of Labels Specify box, you will get 15 labels. 3 records x 5 labels each = 15 labels. Now if you also enter 2 in the Number of Copies - Manual from User box, you will end up with 30 labels printing. 3 records x 5 labels each = 15 x 2 copies = 30 labels. This is especially useful if you are creating enumerated labels with serial numbers.
Wasp Labeler User Manual 5.1.2 Print Tab Properties Box - Number of Copies The Number of Copies section allows you to enter how many copies of each unique label you want to print. • Manual from User - The number of copies of each label is determined by the user entering a value in the Manual from User text field. The default value is 1, meaning one copy of each label. This field is always used to determine the number of copies if no objects are mapped to an external data source.
Wasp Labeler User Manual Example 2: The label is pulling data from an external data source. If you have 3 records in the data source and you enter 5 in the Number of Labels Specify box, you will get 15 labels. 3 records x 5 labels each = 15 labels. Now if you also enter 2 in the Number of Copies - Manual from User box, you will end up with 30 labels printing. 3 records x 5 labels each = 15 x 2 copies = 30 labels. This is especially useful if you are creating enumerated labels with serial numbers.
Wasp Labeler User Manual • Dynamic from column in data source - Select this option if you want to control the number of copies on a label-by-label basis. The number of copies for the labels will be determined by an associated column in the external data source. The associated column must contain a numeric value.
Wasp Labeler User Manual 3. Select the column from which you want to pull the number of copies from the Column drop down menu (the column must be numeric). 4. Next, in the Substitute the value with field, enter the number of copies to print if rows of the selected column are blank or contain non-numeric values. 5. The next section applies if the value is equal to zero. You can select to: Print no copies for the record - this option means no labels will be printed if the value equals zero.
Wasp Labeler User Manual 5.1.3 Print Tab Properties Box - Starting Label and Order • Beginning Label - This option allows you to select where on the page of labels you want to start printing. This is a useful feature if you want to continue printing on a partially printed label sheet. To use this feature: 1. Click the Select button next to the Beginning Label field. The Select Beginning Label field appears.
Wasp Labeler User Manual 5.1.4 Print Tab Properties Box - Data Source The Data Source section allows you to limit the number of rows contained in this print job. This section contains two options: Max Rows - If your data source contains many rows, you can set how many you want to print at a time by entering a value in the Max Rows field. The default value is 50. Prompt for Filter Values - If you want to be prompted to enter filter values. 5.1.
Wasp Labeler User Manual 5.2 Page Setup Screen In this topic: Access and Use the Page Setup Screen Create a Custom Layout Copy a Layout Delete a Layout The Page Setup screen allows you to specify label placement on the page and the page size. You can choose a custom layout or use one of the predefined Avery label templates. Wasp Labeler contains a predefined set of Avery label templates.
Wasp Labeler User Manual 5.2.1 Access and Use the Page Setup Screen 1. On the Design tab, select Layout. Or, on the Print tab, select Layout. The Page Setup screen appears: 2. On the Page Setup screen, select the label you want to create from the Family and type drop down menus. You can choose Custom Layout or one of the Predefined Label Layouts. 3. Click Done on the Page Setup screen.
Wasp Labeler User Manual 5.2.2 Create a Custom Layout 1. Select Custom from the Family drop down menu. 2. Select the Type of label from the Type drop down menu. By default, Type A is selected (this is the only predefined custom type). If you want to use the settings in Type A, click Done. You have completed your selection on the Page Setup screen. If you do not want to use the settings in Type A, proceed to Step C. 3. Click New. The New Layout screen appears. 4.
Wasp Labeler User Manual 5. If you do not want changes made to your custom layout select the Lock Edits checkbox. 6. Select Rounded Borders if the labels have rounded borders. Uncheck this checkbox for square borders. 7. Click Save to save your new layout template. 5.2.3 Copy a Layout 1. Select the layout you would like to copy from the Family and Type drop down lists. 2. Click Copy. The New Layout screen appears. 3. Enter a name for your new layout type and click OK.
Wasp Labeler User Manual 4. If you do not want changes made to your custom layout select the Lock Edits checkbox. 5. Select Rounded Borders if the labels have rounded borders. Uncheck this checkbox for square borders. 6. Click Save to save your new layout template.
Wasp Labeler User Manual 5.2.4 Delete a Layout 1. Select the layout you would like to delete from the Family and Type drop down lists. 2. Click Delete. The Warning screen appears. 3. Click Yes to delete the layout. Click No to cancel the delete process.
Wasp Labeler User Manual Chapter 6 - Activating Wasp Labeler In this topic: Activating Wasp Labeler Updating Your License You can run Wasp Labeler in "Demo" mode for 30 days. During that time, an icon will appear on the File tab toolbar allowing you to enter an activation key. Wasp Labeler will cease to function if an Activation Code has been entered within 30 days of product installation..
Wasp Labeler User Manual The Registering Products page from the Wasp Barcode Technologies website appears. 3. Enter your Registration information. Note: If you want to register your product later, click OK on the Activate Labeler screen after entering your Activation Code. 4. Click OK on the Activate Labeler screen. A Success screen appears: Click OK on the Success message screen. After activation, the Activate Labeler icon changes to Update License.
Wasp Labeler User Manual 6.2 Updating Your License: 1. (After product activation) On the File tab, click the Update License icon. The Update License screen appears. 2. Type in the new activation code, then click the OK button. 3. You can also click the Register button to register your product if you did not do so at activation.
Wasp Labeler User Manual The Registering Products page from the Wasp Barcode Technologies website appears. 4. Enter your Registration information.
Wasp Labeler User Manual Chapter 7 - Running Labeler from a Command Line 7.1 Application Execution The Wasp Labeler application can be executed from the command line (i.e. Run Command). You must specify the directory where the Wasp Labeler application was originally loaded and the appropriate directory and filename of the LAB file to be opened. Multiple files can be opened using a single command. Syntax Wlab32[.
Wasp Labeler User Manual Chapter 8 - About Screen The About screen allows you to view program version and license details. The serial number assigned to this product appears here as well. 8.1 Using/Viewing the About Screen 1. On the File tab, click the About icon. The About screen appears: 2. Click OK to close the About screen.
Wasp Labeler User Manual Index . .gif - Adding to Label.......................................63 .ico - Adding to Label ......................................63 .jpg - Adding to label .......................................63 A About Screen................................................198 Access Database - Connecting To ................ 141 Activating Labeler ......................................... 193 Activation Code ............................................ 193 Add New Filter .....................
Wasp Labeler User Manual Filter - Deleting ............................................. 162 Filter Criteria List .......................................... 162 Filtering Data ................................................ 162 Find Screen ..................................................176 Fore Color ......................................................59 Format Barcode..............................................70 Format Date ................................................. 124 Format Expression .
Wasp Labeler User Manual T Tab - Data .................................................... 137 Tab - Label Design ......................................... 54 Tables - Joining............................................ 168 Templates - Examples.................................... 51 Templates - Layout ...................................... 187 Text Box - Entering Static Data .................... 101 Text Box - Properties ................................... 101 TIFF - Export Barcode as .....................
