Home

Wasp WaspLabeler +2D

1. 2 147 separator whether or not a decimal is specified means scale the number by dividing it by 1000 rounding as Thousand Separator needed You can scale large numbers using this 127 asp 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 For some countries a period is used as the thousand separator If the format expression contains at least one digit placeholder 0 or to the right of E E e or e the 987654 0 0e0 number is displayed in scientific format and E or e is 98 8e4 inserted between the number and its exponent The number of digit placeholders to the right determines the number of digits in the exponent Use E or e to place a 1503 92311 minus sign next to negative exponents Use E ore to 0 0 e 00 place a minus sign next to negative exponents anda plus 1 504e 03 sign next to positive exponents Display a To display a character other than one of those listed literal precede it with a backslash or enclose it in do
2. String Builder Build a string from substrings for Text 1 Label Total z Add Substring The String is built from the following Substring Properties 3 Label Counter 1 Substring Label Total 1 E Static 1 E Label Total 1 Place Holder E Add Before E add After Ignore if previous substring is blank Format with Data Formatting sample result after concatenating all substrings 1234 of 1234 or om 11 On the Print tab enter 20 in the Number of Labels gt Specify field Properties Number of Labels One full page 2 x13 6 label s Specify Number of Copies Manual from User a As consecutive labels Dynamic from column in data source Select Starting I ahel and Order a Labeler User Manual Now your label will look similar to the following _ inventory number from data source 234 Senalized Number 1001 Label Counter 2 of 20 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 Adda textbox to your label 3 With the textbox selected click String Builder in the Properties Box gt Content tab The String Builder screen appears 4 On the String Builder screen select Copies Counter then click Add Substring
3. 84 Labeler User Manual EAN JAN 8 Properties Box Options The table below lists the options available for EAN JAN 8 in the Properties box gt Barcode tab EAN JAN 8 Field Description Select EAN JAN 8 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 The nominal size for a EAN JAN barcode is 1inch The usual p a Or None reduced size is 80 of the nominal size Check this box to enter a specific bar height Bar Height Enter the exact bar height in the field provided EAN JAN 13 Properties Box Options The table below lists the options available for EAN JAN 13 in the Properties box gt Barcode tab EAN JAN 13 Field Description Select EAN JAN 13 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 The nominal size for a EAN JAN barcode is 1inch The usual 5 l gon NOMINA reduced size is 80 of the nominal size Check this box to enter a specific bar height Bar Height Enter the exact bar height in the field provided 85 d 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 gt Barcode tab Interleaved 2 of 5 Description Select Interl
4. ilap I e bsap E Add Filter Criteria Filter Criteria Mame FilterNamel 163 Labeler User Manual 4 Click the green sign to add a criterion to this filter A new criterion bar appears Add Filter Criteria Se SSO i Asset Tag gt Is equal te E 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 Example In the screen shot below the entered parameters are Asset Tag Is equal to 2456 This means that only rows in which the column Asset Tag equals the value 2456 will appear in the results The preview window displays what rows would be returned for given parameters fi Add Filter Criteria Filter Criteria Name FilterNamel Gant O Cn 24 amp Asset Tag UPC Code Department Code Asset Type Item Descnpton Site 45678965412 Printer Save and Close Cancel 164 E Labeler User Manual You can add additional parameters as needed by clicking the green join icon y Add Filter Criteria Filter Criteria Mame FilterName1 C Oni O Ae e 19 Ce a T Sm EL a A As you add criteria the preview window will continue to update to display what your results will look like with the filter
5. 53 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 For an example of creating a label using the Design tab please refer to the topic Getting Started Creating a Static Label Print d Cut Undo C Box Sk Rotate h Bring to Front hljSend Backward Em Units Ruler Zoom EaCopy gt Redo Line Align A Send to Back Layout pe 100 fe Paste Ellipse H Space A Bring Forward T Reset Docking Clipboard Insert Arrange T i Options View Picture Barcode New Label 1 X Pes tie Nee let a 54 Labeler User Manual 3 1 Design Toolbar Function Descriptions The toolbar on this tab is divided into 5 sections rd ci he me 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 Undo Click this icon to undo the most recent action Redo Click this icon to redo the
6. New Copy Save alete Number of Labels Label Size Across 2 Width 3 375 Down Height 2 333 Page Margins Space Between Labels Left Horizontal 0 375 Vertical 0 167 Lock Edits Rounded Borders l Done Cancel 18 ai 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 Click the Print button on the Print tab toolbar The standard Windows Print screen will appear allowing you to select a printer That s it You ve created a static barcode label You can move on to the next step 19 de 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 Creatinq 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 For example if you are creating employee badges you can create one template badge then bind a database containing all emp
7. lt SOH gt Start of Header lt STX gt Start of Text lt ETX gt End of Text lt EOT gt End of Transmission lt ENQ gt Enquiry lt ACK gt Acknowledgment lt BEL gt Bell lt BS gt Backspace lt TAB gt Horizontal Tab 135 de Labeler User Manual Line Feed Vertical Tab Form Feed Carriage Return Shift Out Shift In lt DLE gt Data Link Escape lt DC1 gt Device Control I lt DC2 gt Device Control 2 lt DC3 gt Device Control 3 lt DC4 gt Device Control 4 lt NAK gt Negative Acknowledgment lt SYN gt Synchronous Idle lt ETB gt End of Transmission Block lt CAN gt Cancel lt EM gt End of Medium lt SUB gt Substitute lt ESC gt Escape File Separator Group Separator Record Separator Unit Separator Space lt DEL gt Delete The remaining codes represent printable characters such as the exclamation point period comma etc Upper and lower case alphabetic characters are also represented 136 a 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 gt Contents box on t
8. e 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 e 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 e Exit Closes the Wasp Labeler application If you have any unsaved label projects open the Save and Exit screen appears Please see the topic Exiting Wasp Labeler with Unsaved Labels for detailed instructions on using the Save and Exit screen 2 2 Exporting a Barcode as an Image File You can export any barcode you create in Labeler as an image file Steps to Export a Barcode as an Image File 1 Select the barcode then right click to see the pop up menu 2 Select Save as image from the pop up menu Ip at Ctrl X Copy Ctrl C Delete Del Order b Export to Image The Export Barcode as Image File screen appears Pe Export Barcode to Image File Barcode Information Symbology Code178 Value 456 Target Format JPEG Image JPG Resolution 300 Dots Per Inch DPI 52 Ee 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
9. Cancel 6 The Data tab will populate with the data from the selected QuickBooks file 150 Wasp Labeler User Manual ga New Label Wasp Labeler File Design n g Refresh Edit Remove Data Connection Connection Data Source Connection HAR Ba Sort Filter Join Sort and Filtering I Join Table 320000 1209153141 2F0000 1209148452 2A0000 1160513873 2D0000 1209146904 280000 1160512729 20000 1160512723 30000 1160512723 50000 1160512723 140000 1160512723 10001 1160512713 300000 1209148452 2C0000 1160516342 280000 1160513873 90000 1160512724 A0000 1160512724 B0000 1160512724 C0000 1160512725 D0000 1160512725 TimeCreated 4 25 2008 2 52 21 PM 4 25 2008 1 34 12 PM 10 10 2006 3 57 53 PM 4 25 2008 1 08 24 PM 10 10 2006 3 38 49 PM 10 10 2006 3 38 43 PM 10 10 2006 3 38 43 PM 10 10 2006 3 38 43 PM 10 10 2006 3 38 43 PM 10 10 2006 3 38 33 PM 4 25 2008 1 34 12 PM 10 10 2006 4 39 02 PM 10 10 2006 3 57 53 PM 10 10 2006 3 38 44 PM 10 10 2006 3 38 44 PM 10 10 2006 3 38 44 PM 10 10 2006 3 38 45 PM 10 10 2006 3 38 45 PM TimeModified 4 25 2008 2 53 07 PM 4 25 2008 2 18 52 PM 8 5 2011 4 48 52 PM 4 25 2008 2 24 49 PM 4 25 2008 2 53 07 PM 4 25 2008 2 52 22 PM 10 10 2006 3 38 43 PM 10 10 2006 3 38 43 PM 10 10 2006 3 38 43 PM 10 10 2006 3 38 44 PM 4 25 2008 2 18 52 PM 10 10 2006 4 59 37 PM 10 10 2006 3 57 53 PM 10 10 2006 3 38 44 PM 10 10 2006 3 38 44 PM 10 10 2006 3 38 44 PM 10 10 200
10. Close 8 By default 100 samples are displayed You can adjust this number up or down using the Number of samples to display field arrows or enter a sample number Click the Refresh button to update the samples with any changes you have made or Close to close the Serialization Preview screen pr ry 9 Click OK on the Serial Alpha screen to save your changes 110 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 Then when you print the badges the appropriate data will appear in the text box and encoded on the barcode There are three ways you can attach a database 1 You can select it from the Data tab allowing you to select which columns you want to make available to your label project and to sort filter data 2 You choose a database on the Properties Box gt Data tab for a selected object 3 You can select it when you create substrings on the String Builder screen Steps to Select a Database Column as the Data Source 1 Select an object barcode picture or text box in the
11. q h help Parameters Description Parameter Description i Opens the specified LAB file and prints it Note Only one file can be p printed from the command line at a time n Prints n labels optional default 1 Note p parameter required cM Prints m copies optional default 1 Note p parameter required Launches the application in quiet mode 1 e does not show the Welcome q screen on startup does not show Objects outside label border warning message h Displays a command line help window Same as and help Displays a command line help window Same as h and help help Displays a command line help window Same as and h U Unloads the running Wlab32 exe 1 e closes the application Example C Labeler Wlab32 exe C temp LABfilename lab p u C Labeler Wlab32 exe C temp LABfilename lab p c 6 u C Labeler Wlab32 exe C temp LABfilename lab p I 10 u C Labeler Wlab32 exe C temp file1 lab C temp file2 lab u C Labeler Wlab32 exe Note In Windows 98 and Me the command interpreter will not wait for Labeler to exit before executing the next command in a batch file A small utility called sleep exe can be found in the Labeler folder which can be used to delay execution of statements following any call to wlab32 exe It uses one argument a numeric value that specifies the number of seconds to wait For example C Lab
12. rarunrnnnnnnnnnnnnnnnnnnnvnnnnnnnnnnnnrnnnnennnnennnnennanennanennnsene 197 FE ole 60110 1 E O CUNO EEE E ER 197 Chapter 8 ABOU STEEN icccscscrsasacesasesasimaavaaaninsinesuidandeddeaddeahSncddenidcadnerdianeddadeacauhenahenbhenbhanihanbhedddutdoabis 198 8 1 Using Viewing the About Screen ararnrnnnrnrnnnvnrnnnrnrnnnrnrnnnrnnnnrnnnnnrnnnnnrnnnnnsnnnnnsnnnnsnnnnennnsnennnssen 198 fa SD SEERNE E 199 m 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 Introductory Materials Wasp Labeler Capabilities What is a Barcode Navigating the Main Screen Creating a Static Label Binding a Data Source to an Object Using String Builder to Concatenate Data Creating Enumerated Labels Example Labels Barcode Symbology Reference After you have read the introductory materials you are ready to start using Wasp Labeler Click on the link below to go to the next step in the Getting Started section Software activation system licensed under Patent No 5 490 216 de Labeler User Manual 1 2 Getting Started Wasp Labeler Capabilities Wasp Labeler is a professional label generation application
13. 1 18 PM default Long Time 1 18 36 PM 108 dr 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 2 Object Data Source Serial Alpha The Serial Alpha setting allows you to serialize your labels alphabetically Objects that can be serialized alphabetically are Barcodes and Textboxes Steps to Serialize an Object Alphabetically 1 With the object Text or Barcode in the Design window click the Serial Alpha button on the Properties box gt Data Source tab The following screen appears Ag Serial Alpha Settings Character Set Start at seed Step Every lA 1 gt Label s E Rollover after 7 Reset after rollover A Serialization Configuration Increment number after each new record in data source use last number as next print job s seed value Preview OK Cancel 2 Select the how you want your letters to appear from the Character Set drop down list Options are Upper case Lower case Upper then lower case Lower then upper case 109 de Label
14. Alger Inforn Reed Inforn Doe Inforn 172 S 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 To add new or edited information from the source file use the Refresh Data function This function is also useful if you have created sorts and filters and want to make sure they have been applied to the data contained in Labeler Each time you click Refresh Data Labeler will pull data from the data source using any filters and sorts you have created except in the case of QuickBooks connections see note below Note QuickBooks users should be aware that clicking Refresh applies filters and sorts to the data that is already contained in the Labeler project New edited data is not pulled from the QuickBooks source file To pull new or edited data from the QuickBooks source file you will need to use the Edit Connection function To update the data contained on the Data Source tab click the Refresh Data button on the toolbar JH Remove sort Filter Data Connection Connection lata Source Connect
15. Chars per Inch 17 4825175 Sar Height 0 4000000 S Char Set Auto ki Append d Enter the data you want encoded in the barcode into the Content box In this case we want the employee name and employee ID number so entered Jane Doe1 23456 into the Content box Properties a Object List for New Label 1 gt Barcode 1 Barcode 0 64 0 78 Content Jane Doe123456 Content Source None 15 de Labeler User Manual Note that your label changes to display Jane Doe123456 below the barcode Jane Doe123456 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 Koper Object List for New Label 1 Barcode 1 Barcode 0 54 0 78 Content Jane Doe123456 Content Source None Rar WAfidth nm NI NANNA Jane Doel23456 Place your cursor where you want the break to occur Here we will place the cursor after the e in Doe Then click the Special Characters button A list of all available special characters appears Scroll through the list and select lt CR gt carriage return Now your data will appear as follows Properties q Object List for New Label 1 J Barcode 1 Barcode 0 53 0 71 i Content Content Source
16. EE 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 Ty Test Connection men Connected successfully i ECS Click OK on the Test Connection message to close it Click Apply to select the database You can optionally change the Max Row count to return more rows from the database Keep in mind that returning a large number of rows can result in slower performance Your data will appear on the Data tab 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 142 S Labeler User Manual 4 4 Connecting to an Excel File 1 On the Data tab click the Excel option Please select your Excel file below First row has column headers 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 After you select your file and click OK on the browser window the Data Source Text File delimited screen will populate with the path and name of your data source in the File Name field 4 Ifthe first
17. GIF gif ICON ico e Allows connecting to external databases Microsoft Access Microsoft SQL Server ODBC data sources QuickBooks as well as comma separated files or other delimited text files e Allows import of text files or Microsoft Excel worksheets e Allows import of QuickBooks data version 2008 or later e Includes over 100 label layout templates Wasp Labeler supports drawing objects including text lines rectangles ellipses and barcodes Each of these drawing objects has full edit capabilities including draw style size position and color In addition practically any picture can be imported onto the label design linked to the original file or retrieved from a database t 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 In addition Wasp Labeler provides the capability to quickly create your own database de 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 barcod
18. 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 These changes should only be attempted if you are an advanced user 5 The Data Source Selection screen appears again displaying the data source you selected Optional You can specify and edit delimiters if needed a Click the Advanced Delimiter Options button if you want to edit which delimiters Labeler will use for the data The ODBC Options screen appears A ODBC Options Specify the beginning and ending delimiter Begin End E Use only when table or column contains 147 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 Click OK to save your changes and return to the Data Source ODBC screen 6 Click Apply to add the database to your label project The Data tab will display the selected data 7 You can now perform the follo
19. Label As All Templates Updates License Open Close Save Help New Document 1 File Toolbar Function Descriptions e New Label Click the New Label icon to open a new label project in the Design window You can have multiple label projects open in the Design window at the same time e Open Click the Open icon to select a saved label project to open When you click Open a drop down menu of recently opened label projects appears Select the project you want to open from the list or click Open Files From Folder to navigate to your project e Close Click the Close icon to close the currently active label project If the project is unsaved you will be prompted to save it before closing e Save Opens an Explorer window allowing you to navigate to a folder to save and name your project e Save As Allows you to save an already saved project under anew name This is useful if you want to create a copy of a label that can be changed without altering the original e Save All Saves changes to all projects currently open in the Design window e Example Templates Launches the Example Templates Please refer to the topic Example Templates for a complete description of available templates e Check for Updates Opens an Internet connection to Wasp Barcode Technologies to determine if any new updates are available for your version of Labeler If an update is found you will be prompted to install it 51 Labeler User Manual
20. Test Results 2 Enter your format expression in the Format String text box This expression serves as a mask that will be placed on all data pulled from the data source You can create format expressions for Strings Characters or combination of numbers and characters Numbers or Dates 126 Ee 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 Number Formatting Character Definition 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 If the number being formatted has fewer digits than there are zeros on either side of the decimal in the format expression leading or trailing zeros are displayed If the number has more digits to the right of the decimal separator than there are zeros to the right of the decimal 0 45678 0 00 separator in the format expression the number is rounded 0 46 to as many decimal places as there are zeros If the number has more digits to the left of the decimal separator than there are zeros to the left of the decimal separator in the format expression the extra digits are displayed without modification Display a digit or nothing If
21. Type in data in the Value field for each object that has a prompt 118 dr 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 119 de 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 To compress two or more text or barcode values of different lengths from an external data source 3 To compress multi line text values to remove blank lines For example if you want your barcode to have a serialized number followed by a space you would use the String Builder to accomplish this Click here for a detailed example of using String Builder to concatenate two different data sources in your barcode Steps to Create Substrings Using String Builder 1 With the text box or barcode object selected click the String Builder button on the Properties Box gt Data Source Tab The String Builder screen appears Note that the String Builde
22. 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 EN General Object Name Barcode 1 Left 0 9843750 a inch Top 0 6539583 inch Width 2 7812750 a inch Height inch Rotate D degrees Display on Print Anchor Center gt Caption Align Below Center Font Arial Drawing Fore Color Back Color A A l 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 Left Enter the precise location you want your barcode relative to the left side of the label Top Enter the precise location you want your barcode relative to the top of the label Width Enter the width you want your barcode This is the width of your entire barcode including the caption if it has one Keep in mind that this affects the density of your barcode which could make it harder to scan e Height Enter the height you want your barcode This is the height of your entire barcode including the caption if it has one Keep in mind that a barcode that is too tall or too short could cause distortion which could make it harder to scan e Rotate Rotate the barcode on your label 73 de Labeler User Manual Dis
23. More Colors 61 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 e Line Style Select how you want the outline to appear dashed solid dot etc from the drop down menu e Line Width Enter how thick you want the outline in pixels e Fill Color Ellipses and Boxes only The fill color is the color of the interior of the drawing object By default the fill color is transparent Click the ellipse button to view the color selection pop up shown above e Fill Style Ellipses and Boxes only Select a style for the interior of the drawing object By default the style is transparent 62 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 tif GIF gif ICON ico 3 3 1 Steps to Add a Pi
24. Text File Wasp Data this option allows you to create your own Wasp database 138 ae Labeler User Manual 4 2 Connecting to a CSV File 1 Onthe Data tab click the CSV option Please select your comma separated file below File Mame First row has column headers 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 After you select your file and click OK on the browser window the Data Source Comma Separated File screen will populate with the path and name of your data source in the File Name field 4 If the first row of your file contains column headers make sure the First Row is Column Headings checkbox is selected 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 139 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 e Connected successfully iD Click OK on the Test Connection message to close it 7 Click Apply to add the connected file to your Labeler project The data contained in the selected file will appear on the D
25. Type a Number of Labels Label Size Across 4 Width Page Margins Space Between Labels Horizontal iz Vertical C Lock Edits Rounded Borders pr area 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 191 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 Ea Delete Layout Se D Deleting layout file Custom Example Layout Continue NOTE This action cannot be undone 3 Click Yes to delete the layout Click No to cancel the delete process 192 a 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 If you would like to extend the trial period beyond thirty days please contact the Sales department at sales waspbarcode com 6 1 Steps to Activate Wasp Labeler 1 Onthe File tab click the Activate Labeler icon New Label W
26. appears Please select your text file below First row has column headers 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 New Label 1 X Example Labellabx X 1 2 3 4 5 Object List for Example Label labx Content meve E LA ou tae Left inch ts na Width inch Height inh 23 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 gt Content tab click the Database button A window appears displaying all available columns from the data source New Labeli X Example Label labx X Properties 2 3 4 5 Object List for Example Label labx Barcode 1 Barcode 0 53 0 71 m Content Jane Doe sis Doe m Content Source None Jane Doe 123456 LAG Select the Column from the external data E Database source which will provide the source data rete venn None mZ Another Object Select the appropriate column from the drop down list and click Done Select the Column from the external data source which wil
27. 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 ETR 9 se Click Add to create new filter criteria Or select an existing filter and click the Delete Edit or Set as Active button Cnteria Active No Filter FilterNamel Asset Tag IsEqualTo 2456 Set As Active Close 9 Highlight the desired filter and click the Set as Active button to apply it to the database results The Status will update to Active Notice that the database results on the Data Source tab update to the highlighted filter This is to provide you with a preview of the filter results The filter is not active until you click the Set as Active button 165 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 New Label Wasp Labeler File Design AlE A N g Y 3 Refresh Edit Remove Sort Filter Join Data Connection Connection Data Source Connection sort and Filtering Join Table Asset Tag UPC Code Department Code Asset Type Item Descnption Site Location Checked Out S 2456 456078965412 Printer 166 Si 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
28. at the number 1 and increase one digit step every one label So each label will go up one level Changing the Every field to 2 means that the number will increase one step every 2 labels 4 By default the serialization continues past Z to AA BB etc If you want to change this select the Rollover after checkbox and enter a value After the entered value is reached the default is Z the serialization will start over with the seed value 5 If you set the labels to rollover after a set value and do not want them to reset to the seed value select the Reset after rollover checkbox Enter the value you want to restart at in the field provided 116 dr 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 HE Serialization Barcode 1 Label 1 Label 2 Label 3 Label 4 Label 5 Label Label 7 Label 8 Label 9 Label i0 10 D OG Ga A bd Pi Number of samples to display 10 Refresh Close 8 By default 100 samples are displayed You can adjust this number up or down using the Number of samples to display field arrows or enter a sample number Click the Refresh butt
29. barcode onto your label After placing the barcode you can choose the symbology and data source using the options in the Properties box For complete instructions on adding a barcode to your label please refer to the topic 55 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 You can use the grab point to rotate the dd as 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 To select multiple objects click on the objects while holding down the CTRL key All alignments are relative to the first object you select when using CTRL click to select them If you select objects using CTRL the first object you added to the barcode will be used for alignment The object that is used for alignment known as the base object will appear selected in blue as shown in the example below UN 123456729 Sample 123 a 123456789 56 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 obje
30. caarsettete teats cbeersetseteetatoetsateirateeieetatealec ee 176 Prompt at PYint ccccccceeeceeeseeeeeeeeeeneeeees 118 Properties Defining for Text Box 101 Properties Text BOX cccsecceeeseeeneeeeeenes 101 Properties Box Barcode c scceeeeeeeeeeees 70 Properties Box Hide Show ccc0sceeeeeeeees J Q QuickBooks Connecting tO rrrrenrnnnrrnnnnnn 148 R Rectangle Adding to a Label 000 59 0 0 FAC 6 EE 54 BENTES DA eee 173 Register your Product r arannnrnnnnnnnnrvnnnnnnnnn 193 Removing Unwanted Spaces arrnnnennnrnnnrn 124 Reset Layout rrarnnnrnnnrnnnrnnnnnnrnnnrnnnnnnnnnsrnnnn 54 Reset ZOOM rrarnnnnnnnrnnnennnnnnrvnnennnnnernnnennennnnnn 54 Resize Picture rrrnrnnnrnnrnnannnnrnnnrnnnnnnnnnnnnnnnn 63 Resizing the SCreen r arnnnrnnnnnnnnnnnnnnennnnnnnnne 5 Rotate Object rrrrrnarernarernarernanennanennanennnnen 54 RER os deierou ssseesiseeeceseseav sens senevoar deur E EES 124 Ruler a nanannnnnnannnnennnnannnnnnnennnnnnnrnrnronrnrnnennnnnae 54 S EE K EEE 51 SEN ENEE 51 Save and Exit Screen arrrnarennarrrnarernanennnnen 53 EN 51 Screen Minimizing ronrrrnnnrrnnnrrnnrnvnnnnnnnennnre 5 SOO EE 176 Select Records NOW ccccesceeeeeseeeeeeeaes 176 Send Backward cccccccesceeeeeceeeceeeeseeeeeetaues 54 9600 0 Bn 54 Serial Number vsssiscsercereviavanvransnveswnennawaiee
31. copies 30 labels This is especially useful if you are creating enumerated labels with serial numbers If you have multiple boxes of the same item and each item has a unique serial number you can print labels that specify 1 of N with N being the number of boxes Example 3 If you are using an external data source and want one label for each record in your data source enter 1 in the Number of Labels Specify box e As consecutive labels If you enter a value greater than 1 in the Manual from User text field you can select the As consecutive labels checkbox to indicate you want all copies printed together one after the other Rather than all of one copy printing followed by all of a second copy Note As consecutive labels is always selected if you have checked Dynamic from column in data source As consecutive labels L Example Printing Copies as Consecutive Labels You have a label connected to an external data source containing 2 records If you print e With the As consecutive labels checkbox selected and 2 entered in the Manual from User field 2 copies of the first label will print followed by 2 copies of the second label and 2 copies of the third label e With the As consecutive labels checkbox unchecked and 2 entered in the Manual from User field One copy of all labels will print followed by the second copy of all labels 182 Si Labeler User Manual e Dynamic from column in data source Select this opt
32. 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 Properties Object List for New Label 1 2 Drag the box to the center or left of the screen Arrows appear on the screen showing you all dockable locations as shown below hiw Document i OM 1 12 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 13 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 For
33. 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 Code 128 is widely used in the shipping industry The Code 128 character set includes the digits 0 9 the letters A Z upper and lower case and all standard ASCII symbols and control codes The codes are divided into three character sets A B and C e Character Set A Contains capital letters control characters and digits e Character Set B Contains all printable characters e Character Set C Contains only numbers and the FNC1 character Code 128 Example 123496 89 A special version of Code 128 called GS1 formerly known as UCC EAN 128 is used extensively world wide in shipping and packaging industries Code 39 Code 39 is variable length and is the most frequently used symbology in industrial bar code systems today The principal feature is to encode messages using the full alohanumeric character set Three of the nine elements bars are wide and six elements are narrow Code 39 Extended Full ASCII Code Standard Code 39 contains only 43 characters 0 9 A Z Code 39 can be extende
34. is too dense may be harder for a scanner to read and may not be scannable at all This settings stands for character per inch You can add more characters per inch by increasing the number in this field resulting in a more dense barcode Notice that as you increase the number in Char per Inchthe Char per inch field the Bar Width field decreases The more characters you add per inch the more dense your barcode will be Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all 97 de Labeler User Manual UPC A Properties Box Options The table below lists the options available for UPC A in the Properties box gt Barcode tab 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 5 ONO the magnification from 80 to 200 Specify Bar Height Check this box to enter a specific bar height Bar Height Enter the exact bar height in the field provided UPC E Properties Box Options The table below lists the options available for UPC E in the Properties box gt Barcode tab Field Description Select UPC E from the drop down list For a complete list of Symbology available symbologies along with examples and descriptions of each please
35. items are unique worldwide and they and the associated supplementary data are defined in a consistent way The major benefit for the users of the GS1 system is the availability of uniquely defined identification code and supplementary data formats for use in their trading transactions GS1 14 encodes the full 14 digit GS1 item identification in a linear symbol that can be scanned omnidirectionally by suitably programmed point of sale scanners GS1 Limited encodes a 14 digit GS1 item identification with indicator digits of zero or one in a linear symbol for use on small items that will not be scanned at the point of sale GS1 14 Stacked is a variation of GS1 14 symbology that is stacked in two rows and is used when the normal symbol would be too wide for the application It comes in two versions a truncated version used for small item marking applications and a taller omnidirectional version that is designed to be read by omnidirectional scanners GS1 Expanded encodes GS1 item identification plus supplementary Al element strings such as weight and best before date in a linear symbol that can be scanned omnidirectionally by suitably programmed point of sale scanners GS1 Expanded can also be printed in multiple rows as a stacked column 43 de 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 bet
36. on the datasource the Link to File checkbox represents what type of data is in the column a path to a picture file or actual picture data Select this checkbox if the linked column contains a path to picture file ex D Pictures mypic jog Do not select this checkbox if the column is an actual picture file stored in the database e Size Select an option from the drop down Original This options keeps the graphic at it s original size Resize with Aspect Ratio This option allows you to resize the image by dragging the corners while maintaining aspect ratio Resize This option allows you to resize the image by dragging the corners without regard to aspect ratio 66 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 Ka Date Time B Serial Number User Defined List Serial Alpha Prompt At Print Another Object Clear Content Click to remove current content settings A Clear Content 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 When this button is selected the following question
37. printed circuit boards and electronics parts etc Micro QR Code Example 46 t 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 123456 789 PDF417 P 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 The name of the symbol is derived from the format of the code PDF stands for Portable Data File and 417 is derived from the module structure Each PDF417 symbol consists of 3 to 90 stacked rows surrounded by a quiet zone on all four sides Each row consists of a leading quiet zone start pattern left row indicator character one to thirty data characters right row indicator character stop pattern and trailing quiet zone PDF417 supports text compaction numeric compaction and byte compaction that correlate the mapping between codeword values and decoded data PDF417 can accommodate up to 340 characters per square inch with a maximum data capacity of 1850 text characters PDF 417 Example et POSTNET POSTNET Postal Numeric Encoding Technique is a barcode symbology that is used by the United States Postal Service to assi
38. printed directly on corrugated surfaces Bearer bars were introduced to prevent barcode distortion when flexible rubber stamps are used to print barcodes onto cardboard boxes Adding lines all around the barcode stamp or just on the top and sides of the stamp provides additional stability so the stamp did not bend as the box was being stamped Enter the width for the bearer bar Maxicode Properties Box Options The table below lists the options available for Maxicode in the Properties box gt Barcode tab Maxicode Description Select Maxicode 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 a Mode from the drop down list Options are Mode 2 Formatted data containing a structured Carrier Message with a numeric postal code Primarily used for US domestic destinations Mode 3 Formatted data containing a structured Carrier Message with an alohanumeric postal code Primarily used for international destinations Mode 4 Unformatted data with Standard Error Correction Mode 5 Unformatted data with Enhanced Error Correction Mode 6 Used for programming hardware devices Note UPS codes use Mode 2 or Mode 3 Postal Code Enter the postal code of the destination address Country Code Class of Service Enter the Country Code of the destination address This field defaults to 840
39. same as above but before it performs a TRIM on the input then the LEFT 3 will be applied to the result e RIGHT 3 gt This command returns the last 3 characters from the input e LTRIM RIGHT 3 gt same as above but before it performs a LTRIM on the input then the RIGHT 3 will be applied to the result e RTRIM RIGHT 3 gt same as above but before it performs a RTRIM on the input then the RIGHT 3 will be applied to the result e TRIM RIGHT 3 gt same as above but before it performs a TRIM on the input then the RIGHT 3 will be applied to the result e MID 2 3 gt This command returns the substring starting at position 2 returning the next 3 chars that appear e LTRIM MID 2 3 gt same as above but before it performs a LTRIM on the input then the MID 2 3 will be applied to the result e RTRIM MID 2 3 gt same as above but before it performs a RTRIM on the input then the MID 2 3 will be applied to the result e TRIM MID 2 3 gt same as above but before it performs a TRIM on the input then the MID 2 3 will be applied to the result ASCII Special Character Codes ASCII American Standard Code for Information Interchange codes represent 128 characters 33 of these are non printable markers that define how spaces are handled by a scanner or printer line breaks tabs etc Below is a table of the non printable ASCII character codes and their associated definitions
40. screen appears HE WASP Labeler Ea sp re you sure that you want to clear current data source Click Yes to remove the current data source or No to cancel and keep the data source 67 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 toa 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 1 Steps to Add a Barcode 1 Onthe Label Design tab click the Barcode icon on the toolbar Example Label labs Wasp Labeler File Des Data d Cut Undo z EA i Su Rotate Uh Bring to Fre EaCopy gt Redo H Line oe bat 3 Align Text 3 Paste M tr Clipboard Insert tura Barcode HA Space uff Bring Forward Example Labellabx X Drag and drop the icon where you want the barcode to appear on your label you can change the location at any time You can use the buttons on the Label Design toolbar to rotate the barcode move it forward or backward etc When you place the barcode on your label notice that the Properties box displays the options for defining your barcode 68 Wasp Labeler User Manual Properties ag
41. 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 Enter the Resolution you want for your image Resolutions as low as 72 dpi and as high as 1800 dpi may be specified If you intend to print the image file for subsequent decoding by bar code scanners you should specify resolution values no lower than 200 dpi The default of 300 dpi is ideal for printing If you only intend to display the image on a monitor 72 dpi is sufficient 5 Click the Export button when you are ready to save the image A browser window will appear allowing you to select a save location 2 3 Exiting Wasp Labeler with Unsaved Labels Click the Close button on the File tab to close the Wasp Labeler application If you have any unsaved label projects open the Save and Exit screen shown below appears 4 Save and exit Save Select the files you want to save New Label 1 C Users Admin Documents Example Label labx Select the labels you want to save then click Yes A standard Windows browser screen appears allowing you to choose a location and name for your label If you have selected to save multiple labels a browser window will appear for each label Select No to close without saving or Cancel to cancel the exit process and return to Labeler
42. t Drag and drop the object where you want the drawing object to appear on your label you can change the location at any time When you place the object on your label notice that the Properties box displays any options for the object 59 Labeler User Manual 2 Properties q Object List for New Label 1 9 Rectangle 1 Rectangle 1 81 0 38 r Content Source None Format General Object Name Rectangle 1 Left 1 8125000 I inch Top 0 3750000 7 inch Width 1 0416667 inch Height 1 0416667 inch Li Rotate 0 degrees Display on Print Anchor Center z Drawing Line Color av Line Style Solid Line Width 1 0 pixels Fill Color AA Fill Style Transparent 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 gt Format tab Options are e Object Name You can optionally enter a new name for the object here e Left Enter the precise location you want your barcode relative to the left side of the label e Top Enter the precise location you want your barcode relative to the top of the label Width Enter the width of your text box Height Enter the height of your text box Rotate Rotate the text box on your label Display on Print Make sure this checkbox is select
43. that as you increase the number in the Char per inch field the Bar Width field decreases The more Char per Inchcharacters you add per inch the more dense your barcode will be Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all It is recommended that you do not exceed 12 8 characters per inch for Codabar barcodes Select the Check Digit checkbox to include an optional check digit on your barcode to enhance data security A check digit appears last Check Digit on the barcode and checks for errors in the preceeding content A modulo 16 check character is used When this option is selected the last digit of the symbol is assumed to be the check digit and it is compared to a calculated check digit to verify the symbol Show in When this option is selected the check digit will appear in the Caption barcode caption Ratio This is the wide to narrow bar ration The default setting is 2 2 1 Select a Start Character for your barcode or choose Auto to let Start Labeler assign one for you A Start Character at the beginning of a Character barcode tells a scanner or barcode reader that the content is about to start Your options are A B C or D Select a Stop Character for your barcode or choose Auto to let Stop Labeler assign one for you A Stop Character at the end of a barcode Character tells a scanner or barcode reader that the content has ended Your options are A B C or D Show Sel
44. 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 lt StringBuilder gt Properties n Object List for Example Label labx a Text 1 Text 1 24 0 44 Placeholder EE 31 de 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 Copies Counter This counts the number of copies of unique labels Copies Total The total number of copies Example One Your warehouse wants to create inventory labels for a set of 20 printers Each printer is the same make and model but has a unique serial number You need a label that has a barcode connected to your inventory database containing the inventory number for the printer type a serialized barcode representing the serial number and a label counter Steps 1 Add your Inventory Database to the label project 2 Insert a barcode onto your label and connect it to the inventory number column in your inventory database 3 Insert another barcode a
45. the format string Display a character or nothing If there is a character in the string being formatted in Character the position where the amp appears in the format string display it otherwise display placeholder nothing in that position Placeholders are filled from right to left unless there is an character in the format string lt Force lowercase All characters are displayed in lowercase format gt Force uppercaseJAll characters are displayed in uppercase format Force placeholders to fill from left to right instead of right to left ABC Literal String Indicates that the enclosed characters should be copied to the result string Delimiter unchanged 129 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 DATEFORMAT Characters and Definitions Example DATEFORMAT Expressions DATEFORMAT Characters and Definitions Character Definition Additional Information Resut Day of the Month The day of the month from through 31 Day of the ale Month Abbreviated ddd Day of The abbreviated day of the week 9 26 2011 Week 1 33 45 Mon Full Day of cada Week Period or 9 26 2011 g or gg Era The period or e
46. to format the value which is the barcode content You can create a mask or format expression that will be applied to all data captions if using a data source for example e Clear Content Click the Clear Content button to remove the data source from the barcode 76 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 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 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 To compress two or more text or barcode values of different lengths from an external data source 3 To compress multi line text values to remove blank lines For example if you want your barcode to have a serialized number followed by a space you would use the String Builder to accomplish this Click here for a detailed example of using String Builder to concatenate two different data sources in your barcode Click here for de
47. will appear in the contents preview window as shown below 22456879845 Printer 12345687555 Printer 161 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 New Label Wasp Labeler File Design S N 8 ATY Refresh Edit Remove sort Filter Join Data Connection Connection Data Source Connection sort and Filtering Join Table The Filter Criteria List screen appears No Filter 162 E Labeler User Manual 2 Click Add to create a new filter for the selected data source The Filter Criteria screen appears ri besarte rnc UPC Code Department Code Asset Type Item Descnpton Site 224566 79845 Printer 244 12345687555 Printer 1556 645788889534 Printer 2456 45678965412 12 Printer Save and Close Cancel 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 i TT I m p a Kr TE ag
48. your barcode data safe from damage while also ensuring readability by most scanners You can optionally create a rune containing the value 0 255 if needed Aztec runes are small machine readable symbols A module in an Aztec barcode is a square dot and is the smallest Code Module component of the barcode In essence the barcode is made up of many light and dark square modules You can adjust the module size up which will increase the size of your barcode or down to decrease it Code Rune Size 80 Labeler User Manual Codabar Properties Box Options The table below lists the options available for Codabar in the Properties box gt Barcode tab Description Select Codabar 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 This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This settings stands for character per inch You can add more characters per inch by increasing the number in this field resulting in a more dense barcode Notice
49. your barcode will be The bar height does not affect density Select the Check Digit checkbox to include an optional check digit on your barcode to enhance data security A check digit appears last on the barcode and checks for errors in the preceeding content A Check Digit modulo 43 check character can be used to enhance data security for Code 39 symbols The last digit of the symbol is assumed to be the check digit and it is compared to a calculated check digit to verify the symbol Show in When this option is selected the check digit will appear in the Caption barcode caption Ratio This is the wide to narrow bar ratio The default setting is 2 2 1 Select this checkbox to display the Start and Stop characters in the captions of the barcode In Code 39 the character is automatically used as the Start and Stop characters Start and Stop characters tell a reader where the barcode content begins and ends Select a Stop Character for your barcode or choose Auto to let Stop Labeler assign one for you A Stop Character at the end of a barcode Character tells a scanner or barcode reader that the content has ended Your options are A B C or D 82 Labeler User Manual Code 93 Properties Box Options The table below lists the options available for Code 93 in the Properties box gt Barcode tab Code 93 Description Select Code 93 from the drop down list For a complete list of available symbologies along with examples and
50. 6 3 38 45 PM 10 10 2006 3 38 45 PM FullName g Community CU Communit Accounts Receivable Accounts Inventory Asset Inventory _ Accounts Payable Accounts Payroll Liabilities Payroll Lia Opening Bal Equity Opening E Owner s Capital Draws Investments Retained Earnings Uncategorized Income Wasp Bar Code Cost of Goods Sold Automobile Expense Bank Service Charges Cash Discounts Contributions Depreciation Expense 7 You can now perform the following functions Edit the Connection Remove Connection Sort the Data Filter the Data Join two or more tables 151 Properties Select columns to use on label ListID TimeCreated TimeModified Name FullName IsActive AccountType AccountNumber EditSequence Sublevel Desc Balance TotalBalance ParentRef_ListID ParentRef_FullName Labeler User Manual 4 8 Connecting to a Text File delimited 1 On the main Data Source tab click the Text option K Wasp Cala g O i Please select your text file below First row has column headers 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 After you select your file and click OK on the browser window the Data Source Text File delimited screen will populate with the path and name of your data source in the File Name fie
51. 63 jpg Adding to label rrrarrrnnrrnnrnnnnnvanevnnnnnn 63 A SN 198 Access Database Connecting To 141 Activating Labeler ccccccssecseeeceeeseeeenes 193 Aal COCO esse 193 Add INGW IF IGN or 162 Add Sort Criteria SCree n ccccccceseeeeseeeees 158 Adding Layout Templates cccseceseees 187 AIOT ODI OO Lc aaa ene ee een enone een ene eee 54 Alpha Serial Preview Screen 109 Alphabetical Serialization ceeeee 109 Another Object rrrarrrnanrnnanennanennanennanennnnen 112 Arrange Objects rrarrnrnnnnnannrranrrnnnnnrnnnnnnnnnnnn 54 B Barcode Example Creating Static 14 Barcode Export as Image arornnrnnnnnnnrvnnnnnn 52 Barcode Properties BOX ccsccseeeseeeeeeeenes 70 Bind Time Date to Object cccceeeeeeeee ees 108 Bind to Another Object rrrarrrrarernnnrnannnnnn 112 Binding to a Database rrnrrnnnrnnnrrnnrnnnnnnnrr 111 BMP Export Barcode as rrrnrnnnnnnnnnvnnnnnnnnnrr 52 Box Adding to a Label cccseceseeeeeeees 59 Bring FOrwalrd cccccceccsseceeeseeeeeeneeeeeeseeeneees 54 Bring to FrONnt cccccceccsseeeeeseeeeeeneeeeeeseeeneees 54 C Character Formatting rrrorrrrnrrrrnrrrrnnrnnnre 124 Check for updates rrrrnnrrrnnnrrnnrrvnnrrnanennnnen 51 AOS EE 51 Close a label rrrranrrrnnrrrnnnrrannrvnnennnnrnnnnennnnen 51 Close Wasp Lab
52. Design window then click on the Properties Box gt Content tab and select Database or select Database Column from the drop down list on the String Builder screen and click Add Substring The following screen appears 4 Content Source Database Select the Column from the external data source which will provide the source data for the object None Note If you have not already selected a Data Source on the main Data Source tab the following message will appear Pig Warning Wasp Labeler No Database defined Would you like to set up your Data Connection no Yes No Click Yes to go to the Data tab and select a Data Source 111 _ 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 To map column to the selected object select a column from the drop down menu If you creating any filters or joins for the database on the Data tab only the columns you selected will appear in the drop down list 4 Click Done after you have made your selection 3 6 4 Object Data Source Another Object You can give a text box or b
53. EE String Builder Build a string from substrings for Text 1 jlt from the following The substring will be added to the list as shown below y String Builder Build a string from substrings for Text 1 Copies Counter The String is built from the following A Copies Counter 1 5 Now select Static from the drop down and click Add Substring 35 _ Labeler User Manual The Static window appears 6 Highlight the sample text and type of without quotation marks then click OK iy Static 1 Enter a static value for the object 7 With your Static substring highlighted in the list select Add gt SPACE Before and Add gt SPACE After Substring Properties Substring Static 1 Place Holder Add Space z Before C Ignore if previous substring is blank Format with Data Formatting 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 String Builder 9 sn Build a string from substrings for Text 1 Copies Total Add Substring The String is built from the following Substring Properties x Copies Counter 1 3 Static 1 Substring Copies Total 1 Place Holder Add Before A v Add After ka Q Copies Total 1 Ignore if previous substring is blank Format with Data Formatting Sample result af
54. File Design rin I hi 175 er 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 From the Print tab you can modify the Page Layout select specific records from the data source to print sort and filter which labels to print and enter the number of copies to print for each label The Print tab consists of a toolbar containing function icons a preview window that displays how your labels will look when printed and a Properties box containing print options If your labels consist of multiple pages you can use the navigation buttons on the toolbar to scroll through the various pages You can manually enter a page number or click First Prev Next or Last to scroll New Label 1 Wasp Labeler Phs File Design Layout Sort Print Select i Records Now Properties l Number of Labels One full page 2 x 2 4 label s Specify 4 Number of Copies Manual from User fi E As consecutive labels Dynamic from column in data source 176 S 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
55. GS1 Expanded in the Properties box gt Barcode tab GS1 Expanded Field Bar Width Bar Height Description Select GS1 Expanded 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 Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This setting determines how tall your barcode will be The bar height does not affect density UCC EAN 128 Properties Box Options The table below lists the options available for UCC EAN 128 in the Properties box gt Barcode tab UCC EAN 128 Description Select UCC EAN 128 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 This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that
56. Label 1 Wasp Labeler Data KA vi Ir i Rotate gi on Cut Undo f 1 Box tu aA Bring to Fron een re se E Align A Send to Back E Inches Paste ST ObBllipse Se Sarcode furSpacer T Bring Forwarc EE Centimeters Clipboard Insert Millimeters The units on the Format tab will update with the new unit of measure Left 3 130197 cm Top 0 7641167 2 cm ee S ee 1 6771056 cm Width 0 3651250 cm Height Format Tab Picture Options are e 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 e Link to File This checkbox performs different functions depending on whether you have bound the object to an actual picture or if you are using an external data source Link to a Picture If this checkbox is NOT selected Labeler will save the picture to the LAB file If this box is not selected Labeler will save a link to the picture in the LAB file Saving a link decreases the size of the LAB file however if you move either the LAB file or the picture file to a different location the link will be broken and the picture will not display on the label If you select Link to File make sure that any moves keep the link intact Data Source When the picture is linked to a column
57. None Ba code Format Content Note For a description of the ASCII Special Characters please refer to the topic ASCII Special Character Codes 16 a Labeler User Manual The barcode on your design label will look similar to the following tT a HEN HAN ane Doe pg 125456 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 Save your label It is a good idea to save your label periodically so you won t lose any information in the event of an unexpected shutdown To save your Label click the File tab Select Save from the toolbar then select a name and location for your label You can also save by pressing CTRL S on your keyboard to save the label 6 Choose the label stock on which you want to print When you have your label designed the way you want you can print it to the label printer of your choice You can select the label stock on the Print tab When you open the Print tab an example of how your label will print is displayed as shown below Me Example Label labx Wasp Labeler File Design Data oo Bg J ea amp La
58. Object List for Example Label labx Barcode 1 Barcode 0 98 0 651 Placeholder 125456789 Database Column Employee ID Format General Object Name Barcode 1 Left 0 9843750 inch Top 0 6539583 inch Width 2 7781250 inch Height 1 3758333 z inch Rotate Di degrees Display on Print p Anchor Center z Caption Align Below Center Font Arial Drawing Fore Color Back Color 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 69 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 You can use these options to define the information encoded in your barcode the caption that appears with your barcode or for precise location placement on your label Contents B
59. United States Enter the Class of Service code These codes vary by carrier 88 Labeler User Manual MicroPDF417 Properties Box Options The table below lists the options available for MicroPDF417 in the Properties box gt Barcode tab MicroPDF417 Field Description Select MicroPDF417 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 Bar Height This setting determines how tall your barcode will be The bar height does not affect density This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is Bar Width decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all Select the barcode version The version represents predefined Version ar combinations of numbers of columns and rows 89 d Labeler User Manual MicroQRCode Properties Box Options The table below lists the options available for MicroQRCode in the Properties box gt Barcode tab MicroQRCode 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
60. Version for your barcode You have five options Auto Use this option to have Labeler select the version for you based on the barcode s content M1 This version is capable of encoding o upto 5 numeric characters with no error correction M2 This version is capable of encoding o upto 10 numeric characters and 6 alphanumeric characters with L error correction or o upto 8 numeric characters and 5 alphanumeric characters with M error correction M3 This version is capable of encoding o upto 23 numeric characters and 14 alphanumeric characters with L error correction or o 18 numeric characters and 11 alphanumeric characters with M error correction M4 This version is capable of encoding o upto 35 numeric characters and 21 alphanumeric characters with L error correction up to 30 numeric characters and 18 alphanumeric characters with M error correction or up to 21 numeric characters and 13 alphanumeric characters with Q error correction level Select the Error Correction Level Options are L Approx 7 capability M Approx 15 capability Q Approx 25 capability H Approx 30 capability Select the type of data you want to encode Options are AlphaNumeric Auto Byte Numeric Code Module Select the size ofyour barcode or let Labeler determine the sized Size based on content or previous selections 90 Labeler User Manual MSI Properties Box Options The table below lists the options available for MSI in
61. Wasp Labeler User Manual asi BARCODE TECHNOLOGIES Copyright O 2012 Wasp Barcode Technologies 1400 10 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 Barcode Technologies the Wasp logo and Wasp Labeler are registered trademarks and or trademarks of Wasp Barcode Technologies in the United States and other countries Other parties trademarks are the property of their respective owners Software activation system licensed under Patent No 5 490 216 Terms conditions features hours and contact information in this document are subject to change without notice Wasp is committed to providing great products and exceptional customer service Occasionally we may decide to update our selection and change our service offerings so please check www waspbarcode com for the latest information Wasp Labeler Install Key Printed on shipped material Wasp Labeler Registration Key Obtained from www waspbarcode com register fe Labeler User Manual Table of Contents eter Ul STING SV CO EEE REE niet eee 1 TATOU OD EE EEE NE NE EE 1 1 2 Getting Started Wasp Labeler Capabilities rrranrrrnnrrrnnnrrnnnrrnnnrrnnnrnanrnnnnrnnanernanrnnanennanennane
62. acnnes 198 Serialization AlDN As cisscwssswetssiessacerseadeaawevanrvens 109 Serialization Preview Screen s 109 MN 158 TN 158 NNN 158 SJAL Ga EE 158 Sorting Data Content rrrarrrrnnrrrrnrnnrnnnnnnr 158 Source Object Serial Alpha 0008 109 Space ODJeCHS cccccceececeeeeeeeeeseeeeseeeeseeeees 54 Spaces Removing Unwanted 06 124 SO DE 0 gt en 145 UT 145 Square Adding to a Label arernnrnnnnnnnnennre 59 Static Label Example rrrrnrrrrnrernnrernnrennnnen 14 ST 0 EE 120 String Create rarrrnrrrnnnnrnnnnrvnnnevnnnrvnnnennnre 120 SUING BUNS Ts 2avs 120 String FOrMatting cccsecceseeeeseeeeaeeeeaeees 124 SIO 70 Substring Properties rrrrrrnrrrrnnnrrnnnernnnennnre 120 SSN necccewaonetsantscsesostnentsnabanntaecheeasennserse 120 201 eae Labeler User Manual T WAS DA 137 Tab Label D SIQN ccseccseeceeeeeseeeeeeenes 54 Tables JOINING cccccseeeceeeeeeeeeeeeneeeseeees 168 Templates Examples ccccccseeeeeeseeeeeees 51 Templates Layout rrrnnnnnnnnrvnnnnnnnnnrvnnennnnnn 187 Text Box Entering Static Data 101 Text Box Properties rrarnnrrnnrrnnrnnnrvnnennnnnn 101 TIFF Export Barcode as rannnnnnnnnnnnnnnnnnnnnn 52 Time FOrMattting cccceecceeeseeeeeeseeeneeeeeeees 124 Time Date arrarrnrrnaronnrnnrrvanrnnrnnnenannnernnnener 108 TEN 124 U Und
63. ade wl Cii F Ciego af Purthicie Dane if Purchase Cast dvale Vike af Depres te Aiari Depredation Degen Date WA Last Depnesasos Deis Current Depeeciation af Total heperrciation y Bock value uth Ordas at Warranty Begin af Wainer Bad Y Warranty Padet Euroen Gute 1 9 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 154 ae 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 Onthe main Data tab click the Wasp Data option 155 Labeler User Manual 3 Click Create New Wasp Data Source The New Wasp Labeler Data Source screen appears iby New Wasp Labeler Data Source Create Column Enter Data Columnl Columnz2 EE EE Delete Selected 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
64. am Files Wasp Technologies Wasp Labeler V7 Examples Badge labx Please choose another folder to save your label OF Click OK on the warning screen to pick a new name and location for your new label 39 Labeler User Manual 1 10 Barcode Symbology Reference Note All example barcodes use the Wasp Labeler default properties unless otherwise noted GJDJEIGIIIMIPIQ 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 There are also 4 start stop code choices possible when using the Codabar symbology These characters A B C or D must be included at the beginning or ending of a string Codabar symbology for any new applications today should not be considered except under unusual circumstances because it is limited and out dated Codabar is widely used in library systems and blood banks and for some package transport companies Codabar Example No Check Digit 123456789 Code 11 Code 11 is used primarily in telecommunications The symbol can encode any length string consisting of the digits 0 9 and the dash character One or more modulo 11 check digit s can be included Code 11 Example No Check Digit 123456789 40 t Labeler User Manual Code 128 Code 128 is variable length and
65. ample here we have selected a page that contains 2 labels across and 2 labels down 2 x 2 This means that 4 labels will print if One full page is selected If you are using an external data source 4 labels for each record in the data source that you have selected to print will print if One full page is selected Properties Number of Labels One full page 2 x 2 4 label s 178 Si 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 LExamples Specifying the Number of Labels and Copies Example 1 A label is setup with Numeric Serialization to produce a series of labels 1 through 500 If you enter 50 in the Specify box the first fifty serialized labels will be printed Froperties Number of Labels 0 One full page 2 x 2 4 label s Number of Copies Manual from User 1 As consecutive labels Dynamic from column in data source bel and Order If you enter 50 in the Number of Labels Specify box and 2 in the Number of Copies Manual from User box 2 copies each of the first 50 serialized labels will be printed resulting in 100 physical labels be GENE Number of Label
66. arcode the same data source as another text box or barcode already on your label using the Bind to Another Object feature If you want two or more objects to use the same data you can go through the adding data source and column mapping functions once then use the Bind to Another Object feature to quickly add the same data source and column to a new object Steps to Bind an Object to Another Object 1 Select an object barcode picture or text box in the Design window then click on the Properties Box gt Data Source tab and select Another Object The Bind to Another Object screen appears fik Bind to Another Objed 7 me Select an object from the canvas which will provide the source data for this object 2 Select which object you want to bind from the drop down menu 3 Click OK on the Bind to Another Object screen Note If you change the data source on the object to which you have bound another object the data source will change for both objects 112 dr 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 gt Data Source tab and select User Defined List The User Defined list screen appears User Defined List Select a user defined list f
67. ased You might want a moredense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This settings stands for character per inch Code 128 is adense barcode and supports a relatively high character per inch You can add more characters per inch by increasing the number in this field resulting in a more dense barcode Notice that as you increase the number in the Char per inch field the Bar Width field decreases The more characters you add per inch the more dense your barcode will be Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This setting determines how tall your barcode will be The bar height does not affect density There are three different character sets for Code 128 A B and C and Default By leaving this set to Default Labeler will determine the best character set to use based on the content of your barcode Default is the recommended setting to help you avoid Char per inch Bar Height Character Set A Contains capital letters control characters and digits Character Set B Contains all printable characters Character Set C Contains only numbers and the FNC1 character Use the Append field to add any characters you want included at the Append end of your barcode 79 d Labeler User Manual Aztec Code Properties Box Options The ta
68. asp Labeler Design Ji HEU x New Open Close Save Save Save Example Check for About Activate Label As All Templates Updates Labeler Open Close l New Labell X Object List for New Li Type in your activation code to activate Wasp Labeler below If you need to purchase an activation code please click Register button 2 Type in the activation code then click the Register button 193 Labeler User Manual The Registering Products page from the Wasp Barcode Technologies website appears Registering Products Back to Support Center If you ve already registered and would like your keys emailed to you please click KHERE Registering your Wasp product is quick and easy By registering you have access to a range of benefits including Complimentary technical support for the life of the product Access to updates and patches Notification of new product announcements enhancements Special pricing on product upgrades Privacy Statement Wasp Barcode Technologies is committed to maintaining the privacy of its customers information Some transactions require that we request information from customers to better serve their needs The information is kept confidential to Wasp and is not given to any third parties For a full Privacy Statement click HERE reguired information Email Confirm Your Email Must be a valid email address in order for us to email you the activation key Please c
69. aste O Ellipse ume Bareee Wa Space E Bring Forward Clipboard W Insert Arange New Label I X Example Label labx 1 Sample 123 MIND Drag and drop a i text object to the design window The Properties Box updates with options for the text box 25 Wasp Labeler User Manual 2 Create a String using String Builder On the Properties Box gt Content tab click the String Builder button Properties Object List for Example Label labx Text 1 Text 1 24 0 44 Content Sample 123 Content ource None Basic Source Database User Defined List Date Time mn Serial Number Serial Alpha Eh Prompt At Print Another Object Strings To Concatenate data click String Builder String Builder Formatting To further apply formatting click Data Formatting tay Format Value None Clear Content Click to remove current content settings Clear Content 26 a Labeler User Manual The String Builder screen appears iy String Builder Build a string from substrings for Text 1 The String 15 built from the following Substring Properties Substring Place Holder Add Before Add After Ignore if previous substring is blank Format with sample result after concatenating all substrings 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
70. ata tab as shown in the example below gm New Label i Wasp Labeler a Ld Refresh Edt Data Canesten Connecter Dats Foure Conmection Sarl and Filter Me Takie rike rsipn Sat Filter Joan Praperties Select columna to use on label H aata OE eee a PE Code he UPE Code Site Gi Department Cade FEM 77956479845 1 int i 11 Asset Type 2456 45674062 1 rinier 1 Fr Site 344 12945587555 1z ing Eji W Location jissa GAS 7RRBEOSA 13 rin 1 a Checked Gut Serial Mo Fl Canditan af Hasafarturer 7 hade st Class F Categor ef Purchase Dets Purchase Cost at Sahage Valve J Deprecate Astel F Depresiation Begin Gate 7 Last Depreciation Cate Current Depreciation Total Depreciation F Book Value A Purchase Order Warrecty Begin ie Warteety End tat Wharrectty Frider Custom Date I w Custom Date 2 Gi Custom Date 3 Custom Dale 4 8 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 140 S Labeler User Manual 4 3 Connecting to a Microsoft Access Database 1 On the Data tab click the Access option Please select your Access file below Username Password 3 Click Browse to navigate to the Access database After you make your selection the path will appear in the File Name field 141
71. beler 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 General Object Name Text 1 Width 0 6670833 inch 1 9258333 inch Height 0 1437500 inch Left 1 4062500 inch Top g S Rotate degrees Display on Print Se ese Anchor Center 7 Justification Left er Font Arial Auto Size Size Rectangle to Text 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 Left Enter the precise location you want your barcode relative to the left side of the label Top Enter the precise location you want your barcode relative to the top of the label Width Enter the width of your text box Height Enter the height of your text box Rotate Rotate the text box on your label Display on Print Make sure this checkbox is selected if you want the text box to display when your label is printed Anchor Select where you want to anchor the text box on the page For example if you set the Anchor to Right if the text box grows or shrinks due to variable data from a data source the Right side will stay in the same position and the text box will grow from the left If you anchor it Center the center posit
72. bject List for New Label 1 rT Picture 1 Picture 2 17 1 98 Content Source None General Object Name Picture 1 i Left 27 1695833 cm Top 1 9785542 cm Width 2 6458333 cm Height 1 0318750 m Rotate degrees Display on Print Mh m a 7 4 Anchor L Picture Ficture File ae Link to file Size Resize 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 Top Enter the precise location you want your barcode relative to the top of the label Width Enter the width of your text box Height Enter the height of your text box Rotate Rotate the text box on your label Display on Print Make sure this checkbox is selected if you want the text box to display when your label is printed e Anchor Select where you want to anchor the object on the page For example if you set the Anchor for the image to Top then adjust the Height the Top will stay in the same position and the picture will grow from the bottom If you anchor it Center the center position will stay the same and the picture will grow from the top and bottom 65 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 ara New
73. ble below lists the options available for Aztec Code in the Properties box gt Barcode tab Aztec Code Description Select Aztec 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 This setting determines the size of the barcode along with error correction and code module size The smallest Aztec Code symbol encodes 13 numeric or 12 alphabetic characters while the largest Aztec Code symbol encodes 3832 numeric or 3067 alphabetic Code Format characters or 1914 bytes of data No quiet zone is required outside the bounds of the symbol There are 32 sizes from which to choose plus an additional 4 compact sizes You can leave this setting at Auto to have Labeler determine the size based on the included content This settings determines the amount of RS Reed Solomon error correction for the barcode This allows the scanner to read the barcode correctly even in the case of a partially damaged barcode You can choose from 5 to 95 of the data in the barcode for error correction The higher the amount of data you select for error correction the larger your barcode will be This makes your barcode less susceptible to damage but could potentially make it harder to read if your barcode contains a large amount of data The default setting is 23 This correction amount 23 is usually the amount of correction necessary to make
74. ble strip of black bars and white spaces above a sequence of 12 numerical digits No letters characters or other content of any kind may appear on a standard UPC A barcode The digits and bars maintain a one to one correspondence in other words there is only one way to represent each 12 digit number visually and there is only one way to represent each visual barcode numerically The UPC A barcode is used on retail goods 48 t 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 right hand most digit UPC E Example 49 a 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 spre New Document Wasp Labeler pea i Label Design DSa HAN S ey New Open Close Save Save Save Example Check for About Update
75. click the Delete button The following warning message appears Hy Filter Criteria List GER Click Add to create new filter criteria Or select an existing filter and click the Delete Edit or Set as Active button Cnteria No Filter FilterNamel Asset Tag IsEqualTo 2456 Set As Active Close 3 Click Yes on the warning message to delete the filter 167 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 To join tables you will link two columns with common data then select which columns from each table you want to include on your label LExample When to Use the Join Tables Function Joining tables is useful if for example you are creating an employee badge and want to include the employee and department You might have two spreadsheets one containing the employee name and department ID code and another containing department ID codes and the corresponding department name You can combine the two tables by creating a link between the department ID code column in the first soreadsheet with the department ID code in the second sprea
76. 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 27 Labeler User Manual Database Column The String ts built from the following Substring Properties Substring Place Holder PO _ Add v After _ Ignore if previous substring is blank Format with Data Formatting sample result after concatenating all substrings The Data Source Database screen appears allowing you to select a column b Select Employee Last Name then click Done Select the Column from the external data source which will provide the source data for the object 28 a Labeler User Manual The substring appears in the window as shown Build a string from substrings for Text 1 Substring Properties Column Employee Last Name Substring Column Employee Last Nam Place Holder a Add Before F Add After Ignore if previous substring is blank Format with m Sample result after concatenating all substrings 1234 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 Column Employee Last Name Column Employee First Name g d Highlight the substring Column Employee First Name and s
77. con 4 To edit Substring Properties highlight a substring in the window The selected Substring name appears in the Substring field The String ts built from the following Label Counter 1 E Static 1 Substring Properties Substring Label Counter 1 Flace Holder Label Total 1 FEE edle E Add Before 7 add After Ignore if previous substring is blank Format with Data Formatting 123 EE 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 This adds a carriage return or space Before and or After the selected substring 7 Select the Ignore if Previous substring is blank if you want Labeler to skip the selected substring if no data is found for the previous substring in the list 8 You can add formatting to a substring by clicking the Data Formatting button Click here for a detailed description of creating format expressions 9 For barcodes you have two additional options Use in barcode value Select this checkbox to include the substring in the barcode value This means the substring will b
78. ct will still be selected for alignment but will no longer be the base object madum 125456739 al Sample 123 123456789 4 LExample 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 Use CTRL click to select the barcodes making sure to select the barcode to which you want the other barcodes aligned first Your label will look similar to the following ICM 9 123456789 ar Sample 123 123456789 97 Labeler User Manual Now select Align gt Horizontal Center wa New La bel 1 Wasp Labeler File ati Print Mi Cut Undo Box Bol W akRotate I Bring to F BaCopy Redo Line ss rer ii Send to Bi Paste Text C Ellipse Picture Barcode Clipboard Insert Right T New Label 1 iX oP Botton Vertical Center Cer te The barcodes are now aligned relative to the center of the first barcode you selected MNA 4 123456789 Sample 123 MM 4567 89 e Space This option allows you to evenly space multiple selected objects across or down e Bring to Front Use this option to move a selected object in front of other objects e Send to Back Use this option to move a selected object behind other objects e Bring Forward Use this option to move a selected object forward e Send Backward Use this option t
79. cture to a Label 1 On the Label Design tab click the Picture icon on the toolbar New Label 1 Wasp Labeler d Cut da Undo d Box Oh Rotate 5 ug Bring to Fro HaC Copy gt Redo Line Align Va Send to Back i Paste Ellipse Hi Space i Bring Forwag Insert Drag and drop the picture where you want it to appear on your label you can change the location at any time 2 A browser window will appear allowing you to navigate to a picture file For Static Images Browse to the desired graphic then click OK Your graphic will appear on the label You can now use the Format tab or the buttons on the Design toolbar to edit your image 63 ae 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 id Fe Image Placeholder gt g 4 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 gt Content tab to bind the picture object to a data source 64 dr 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 Properties 2 O
80. currently connected to will appear Follow the steps you used to connect to that data type to establish a connection with a different file of the same time CSV File Access Database Excel File Microsoft SQL Server ODBS Compliant Data Source QuickBooks Text File Wasp Labeler Data Source 174 aa 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 Note If you want to change to a data source within the same type CSV to CSV or MSSQL to MSSQL for example you will use the Edit Connection function 1 Onthe Data Source tab click the Remove Connection button The warning message shown below appears New Label 1 Wasp Labeler File Design a WY BY Sort Filter Join 2 Click Yes to continuing removing the connection All Joins Filters and Sorts you have created for the current data source will be removed and the data source connection parameters the path to a file SQL settings etc will be deleted from the project The Data tab will appear as shown below after the connection is removed s New Label 1 Wasp Labeler
81. d Criteria button Now a new pair of Column and Sorting Order drop down menus appear n Add Sort Criteria Sort Criteria Name Example Sort Criteria Column Sorting Order Add Criteria Set as Active Clear 7 Repeat steps 4 and 5 You can continue adding additional sort criteria as needed Inthis example we have created a list that will be sorted first by Asset Tag then by UPC Code 160 a 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 Instructions To create new sort criteria click the Add button Or select an existing sort criterion and click the Delete Edit or Set as Active button Sort Criteria List Cnteria Asset ag UPC Code Department Code Asset Type Item Descnpten Site 22456879845 Printer 127345687555 Printer 64578888954 Printer 45678965412 Printer 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 Notice that if you have active sort criteria your data will now be sorted according to the set parameters When you have an active sort applied to the data source contents the name of the sort currently in use
82. d allowing you to enter custom Number of Labels Label Size Page Margins and Space Between Labels Notice that as you enter new data into these fields the preview display on the right updates to reflect your changes ie Page Setup New Label 1 Layout Template _ Preview Family Custom x Type New Type IT Number of Labels Label Size Down Height Space Between Labels Horizontal Vertical E Lock Edits Rounded Borders Done Cancel 189 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 New Layout Layout Template Family Avery InkJet aa OK Cancel 3 Enter a name for your new layout type and click OK Now the fields on the Page Setup screen are enabled allowing you to enter custom Number of Labels Label Size Page Margins and Space Between Labels Notice that as you enter new data into these fields the preview display on the right updates to reflect your changes 190 Si Labeler User Manual T Fage Setup Mew Label 1 Layout Template Family Custom Type New
83. d families of templates are e Avery Dot Matrix Avery Ink Jet Avery Laser One Up Labels W 300 305 E 600 606 187 EE 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 New Label 1 Wasp Labeler File Design Data p Records Now The Page Setup screen appears 3 pr RE lt e N a n e Ey Page Setup New Label 1 Layout Template Type Type A lt Default gt Number of Labels Space Between Labels Horizontal 0 1 Vertical 0 1 Lock Edits Rounded Borders 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 188 E 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 S New Layout Layout Template Family Custom 4 Enter a name for your new layout type and click OK Now the fields on the Page Setup screen are enable
84. d to an 128 character symbology full ASCII by combining one of the special characters with a letter A Z to form the characters that are not present in the standard Code 39 symbology For example in standard Code 39 a lowercase a cannot be represented In Code 39 Full ASCII however a is represented as A Code 39 Example No Check Digit 123496789 41 de 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 Code 93 Example 123456789 Data Matrix D Data Matrix is a 2D variable length symbology capable of encoding all 128 ASCII characters and a number of different character sets Each Data Matrix symbol consists of a perimeter quiet zone border with two solid edges and two dashed edges and cells inside the border which are dark or light The border s two solid lines with data cells are used for symbol identification orientation and cell location Data Matrix can accommodate up to 500 MB per square inch with a data capacity of 1 to 2335 characters Data Matrix has a high degree of redundancy and resists printing defects Data Matrix is popular for labeling small products because it can encode many characters in a
85. density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This settings stands for character per inch You can add more characters per inch by increasing the number in this field resulting in a more dense barcode Notice that as you increase the number in Char per Inchthe Char per inch field the Bar Width field decreases The more characters you add per inch the more dense your barcode will be Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all Data Matrix Properties Box Options The table below lists the options available for Data Matrix in the Properties box gt Barcode tab Data Matrix Description Select Data Matrix 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 Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all
86. 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 This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This settings stands for character per inch You can add more characters per inch by increasing the number in this field resulting in a more dense barcode Notice that as you increase the number in Char per Inchthe Char per inch field the Bar Width field decreases The more characters you add per inch the more dense your barcode will be Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all 83 d Labeler User Manual Code 11 Properties Box Options The table below lists the options available for Code 11 in the Properties box gt Barcode tab Code 11 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 This setting determines
87. 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 You can import data directly from your corporate databases or you can create a new Microsoft Access database In addition Wasp Labeler can generate compliance labels for practically every industry Wasp Labeler e Supports the following barcode languages AztecCode Codabar Code 128 Code 39 Code 93 DataMatrix EanJan13 EanJans Interleaved2of5 Isbn Itf14 MaxiCode MicroPDF417 MicroQRCode Msi PDF417 Postnet QRCode GS1 GS1Stacked GS1 Omnidirectional GS1 Truncated GS1 Expanded GS1Limited UCCEAN128 UPC A UPC E For a description of each of these symbologies please refer to the Barcode Symbology Reference e Prints the most popular 2D barcodes DataMatrix MaxiCode MicroPDF MicroQRCode PDF417 Aztec Code and QRCode e Supports any laser dot matrix thermal or ink jet printer using a standard Windows printer driver e Allows you to edit multiple labels concurrently e Allows you to input data on the label at print time e Capable of advanced graphic resizing and graphic rotation e Allows import of bitmap files bmp JPEG jpg Jpeg jpe jfif PNG png TIFF tiff tif
88. dsheet Then you can select to include only the employee name from the first table and department name from the second table on your labels 168 ae Labeler User Manual 4 12 1 Steps to Join Tables 1 After selecting a data source on the Data tab click the Join button New Label Wasp Labeler File Design Ge Ssinmy Retresh Edit Remove Sort Filter Data Connection Connection Data Source Connection Sort and Filtering Join Table apartment Lode Asset Type Itera Site Location Checked OU The Join Tables screen appears List of Links To link join tables click the Add button 169 _ Labeler User Manual 2 Onthe Join Tables screen click the Add button The Add Link screen appears Table Column ki 3 Onthe 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 invent txt serial numbers txt Link results A list of columns in the selected table spreadsheet etc will appear in the top preview pane 170 i 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 men
89. e dividing line between the Design window and the Properties box until your cursor turns into a double arrow as shown below Arrange Layout Options Properties With the left button held down on your mouse drag the dividing line either left or right Keep in mind that you cannot expand the Design window over the Properties box When the Design window reaches it s maximum width it will stop moving If you need more design area hide the Properties Box 10 t 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 For example on the Design tab the Properties box displays the various options available to the selected object If you want to have a larger design area you can hide the Properties box by clicking on the Pin icon in the right hand corner of the box as shown below Object List for New Lab Click the Pin icon Z to hide the Properties When the Properties box is hidden a label will appear on the right side of the screen as shown below 11 Wasp Labeler User Manual Move the Properties Box By
90. e encoded in the barcode Use in barcode caption Select this checkbox to include the substring in the barcode caption 3 6 9 Formatting Data In this topic Steps to Access and Use the Format Value Screen Character Formatting Definitions and Examples Number Formatting Definitions and Examples String Formatting Definitions and Examples Custom Date and Time Formatting DATEFORMAT Command DATEFORMAT Characters and Definitions Example DATEFORMAT Expressions Removing Unwanted Spaces from Data TRIM Command The Formatting section on the Properties box gt Data Source 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 standard characters to represent digits placeholders decimal placeholders percentage placeholders etc 124 Er 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 gt Content Tab gt Formatting section J Clear Content 125 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 disabl
91. e right side of the Truncate PDF417 barcode This is useful if you need a smaller barcode but makes it more susceptible to damage PLANET Properties Box Options There are no additional options for the PLANET barcode in the Properties box gt Barcode tab 92 Labeler User Manual POSTNET Properties Box Options The table below lists the options available for POSTNET in the Properties box gt Barcode tab POSTNET Field Description Select POSTNET 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 the short bars on your barcode will be The bar height does not affect density This setting determines how tall the tall bars on your barcode will be The bar height does not affect density This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all Columns Select the number of columns for your barcode 1 30 Ratio This is the wide to narrow bar ratio The default setting is 1 1 93 de Labeler User Manual QR Code Properties Box Options The table below lists the options available fo
92. e scanner 1234 WAS Whse1 becomes E1 1234 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 Barcodes get wider with the amount of numbers and characters you want represented by them In other words the width is determined by the amount of numbers or characters represented by the barcode Some barcode scanners have a limited width that they can read If you have very long item numbers or location numbers you may need to reconsider the numbering scheme or the scanner you are using Also be aware that many of the less expensive barcode readers do not read barcodes that are bent at an angle are too small or are damaged Consider the possible disposition of your barcodes before choosing a scanner There are many different barcode formats or symbologies The different symbologies can be thought of as different fonts The same characters are represented by different symbologies in different ways For example the two symbologies below represent the same information Whse1 vn se Bb Chee HPSS These different formats exist to provide ways to compress more data into a smaller space to represent a different set of characters or to enable scanning at different angles or distances When using Wasp Labeler ba
93. e 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 Click OK to close the Connecting to QuickBooks message screen 149 EE 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 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 By Data source QuickBooks H Es Available QuickBooks tables are listed below Data from checked tables will be retrieved once you click Apply button Filter will be enable when CreditMemo Invoice PurchaseOrder or SalesReceipt table is checked Filter Account Bill Check CreditMemo Customer CustomerBillAddress CustomerShipAddress From 6 15 2014 E w 42 93 9011 ia Enter 0 to select all rows Transaction Date Bem ml om one CustomerType Employee Modification Date Estimate E Invoice From 6 15 2011 To 12 12 2011 E ItemInventory a ee Current Company File C Users Public Documents QB06 fille updated Shirley s New Company OBW Test Connection Apply
94. e total number of identical copies of a label that are printed Note You can use the Counter and Total substrings to create enumerated labels 1 of 5 2 of 5 3 of 5 etc For a detailed example of how to create enumerated labels with and without serial numbers please refer to the topic Creating Enumerated Labels 3 Substrings you add will appear in the window as shown below iN String Builder Build a string from substrings for Text 1 Static ki Add Substring The String is built from the following Substring Properties Label Counter 1 Substring Label Counter 1 le Place Holder Label Total 1 abel To E Add F add Space 8 z Ignore if previous substring is blank Format with Data Formatting Sample result after concatenating all substrings 1234 of 1234 122 ae 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 FRE String Builder Build a string from substrings for Text 1 Add Substring The String 15 built from the following Substring l Label Counter 1 Substring Static 1 Label Total 1 d Place Holder Gadd E add sp Ignore Format v Er You can edit a substring by clicking on the Pencil icon or delete it by clicking the red X i
95. eaved 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 The bar height does not affect density This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This settings stands for character per inch You can add more characters per inch by increasing the number in this field resulting in a more dense barcode Notice that as you increase the number in Char per Inchthe Char per inch field the Bar Width field decreases The more characters you add per inch the more dense your barcode will be Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all Select the Check Digit checkbox to include an optional check digit on your barcode to enhance data security A check digit appears last Check Digit on the barcode and checks for errors in the preceeding content A modulo 10 check character is used When this option is selected the last digit of the symbol is assumed to be the check digit and it is compared to a calculated check digit to verify
96. ect Data Source Date Time r rrrrnnnnnnnnnnnnnnnannrnnnnnnnnnnnnnennanennnnennnnennnnennanennnnennanennnnennsene 108 3 6 2 Object Data Source Serial Alpha rrrarrrnnnnrnannrnnnnnrnnnnnnnennnnennnnennnnennnnennnnennnnennaennnsennsen 109 3 6 3 Object Data Source Database rrrrarnrnannnnnnnrnannrnnnnnvanrnnnnennnnennnnennanennnnennanennnennanenneennnsene 111 3 6 4 Object Data Source Another Object arrrrarrrnarernarernanernnnennanennnrrnanennnnrrnanennanennasennanennnsene 112 3 6 5 Object Data Source User Defined List rrarrnnnrrnnanannnnernanennnnennnnnnanennanennnnennanennanennanennnsene 113 3 6 6 Object Data Source Serial Number rrrannnnnnnnnanennanennnnennnnennnnennnennnnennanennnnennanennanennanennnsen 116 3 6 7 Object Data Source Prompt at Print rarannanonnnnennanennnnernnnennnnennnrnnnnennanennanrnnanennnsennunennnsene 118 JON SE assess sess eee ee 120 SOIFON ARN DA e EE 124 Ga 0 ae Da Ge EEE EE 137 PETN NNN 137 ar ETNE 139 4 3 Connecting to a Microsoft Access Database rrrrareranrnnnnnnnnnvarevnnrnnnrnnnevnnrnnnnnnnnnnnnennnennnnnnnnennee 141 4 4 Connecting 10 an Excel Filerna eee bneskakaigde 143 4 5 Connecting to Microsot SAL SA vase 145 4 6 Data Source ODBC Compliant Data SOurce rrrarannarnnnanannananvannnnanennnrnnnnnnnnnnnnnnnnnnnnnnnnnnnnssennn 146 ALT Connecting To QUICK BOOKS 9 i S 148 4 8 Connecting to a Text File delimited rrrrrronrrrnnrrrnn
97. ect this checkbox to display the Start and Stop characters in the Start Stop caption of the barcode 81 d Labeler User Manual Code 39 Properties Box Options The table below lists the options available for Code 39 in the Properties box gt Barcode tab Code 39 Description Select Code 39 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 this checkbox if you want this to be Code 39 Extended symbology Code 39 Extended supports all ASCII characters by using double character encoding This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This settings stands for character per inch You can add more characters per inch by increasing the number in this field resulting in a more dense barcode Notice that as you increase the number in Char per Inchthe Char per inch field the Bar Width field decreases The more characters you add per inch the more dense your barcode will be Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all Bar Height This setting determines how tall
98. ed if you want the text box to display when your label is printed e Anchor Select where you want to anchor the object on the page For example if you set the Anchor for a box to Top then adjust the Height the Top will stay in the same position and the box will grow from the bottom If you anchor it Center the center position will stay the same and the box will grow from the top and bottom 60 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 ape New La bel 1 Wasp Labeler File Des Print LA j wi i Rotate 4 ga Cut 4 Undo L_ Box Hi ak Rotate k EaCopy gt Redo Line Zat Align send to Back m Inches Paste Text Ellipse Picture Barcode PL Space ap Centimeters Clipboard Insert Millimeters The units on the Format tab will update with the new unit of measure Left 3 1301972 cm Top 0 7641167 cm Width 1 6771056 3 Add color and or change the line size using the options in the Drawing section of the Properties box Options are e Line Color This is the color of the outline of your drawing object or the color of the line This color defaults to Black Click the ellipse button to view the color selection pop up shown below Theme Colors BREE REE S Standard Colors He GENENE NE
99. ed to you please click KHERE Registering your Wasp product is quick and easy By registering you have access to a range of benefits including Complimentary technical support for the life of the product Access to updates and patches Notification of new product announcements enhancements Special pricing on product upgrades Privacy Statement Wasp Barcode Technologies is committed to maintaining the privacy of its customers information Some transactions require that we request information from customers to better serve their needs The information is kept confidential to Wasp and is not given to any third parties For a full Privacy Statement click HERE required information Email Confirm Your Email Must be a valid email address in order for us to email you the activation key Please create a password so you may come back and access your software keys at any time Password Confirm Password 4 Enter your Registration information 196 t 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 exe path filename p 1 n c m
100. ed until you create at least one substring For detailed information on creating substrings please refer to the String Builder topic So eT TESTEN PSTN a S A Layout 100 a String Builder oea l y _ ia t Reset Docking sg Build a string from substrings for Barcode 1 Layout Options View Static Add Substring Properties q The String is built from the following Substring Properties Barcode Format nt Static 1 S Substring atic 1 i Basic Source Add 1 x Before v QD Date Time vas Serial Number a E Add After M Ignore if previous substring is bla Format with Strings To Concatenate data click String Builder s String Builder Formatting To further apply formatting click Data Formatting Bf Format Value None BW Format Caption None Clear Content Click to remove current content settings The Format Value Format Caption screen appears Note The Format Value and Format Caption screens are identical and function the same way The screen shots verbiage in this topic refer to Format Value but are applicable to the Format Caption screen Data Formatting 2 i N 4 Include Substring in Bar Code value 4 Include Substring in Bar Code caption Sample result after concatenating all substrings 1234 Format String I Clear Test Area Enter a sample in the field below to test the Format String
101. elect Add Space Before in the Substring Properties box Build a string from substrings for Text 1 Database Column z Add Substring The String is built from the following Column Employee Last Name a Column Employee First Name Substring Properties Column Employee First Nar Substring Place Holder Zz Add Space After substring is blank 29 Labeler User Manual e f 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 iy Static 1 Enter a static value for the object 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 ity String Builder Build a string from substrings for Text 1 Static o Add Substring The String is built from the following Substring Properties Column Employee Last Name w Substring Static 1 Place Holder E Add Before E Add After E Ignore if previous substring is blank Format with Data Formatting sample result after concatenating all substrings 1234 1234 30 a Labeler User Manual g Notice that your sample data at the bottom of
102. eler rrannrnnnnnnnnnnnnnnrnnnnnnnnen 53 Code Activation cccceeceseeeeeeeeeaeeeeaeees 193 Columns Sorting ararranrrrnnrrvannnnnnrnnnnrnnnre 158 Comma Separated Fil cccsseseeeseeeeeees 139 Concatenating Data rrrrnnrrrnnnrnnnnrnnnennnre 120 Connecting to a SQL Database 0 145 Connecting to CSV File rrranrrrnnrrrnnrrnrnnnrnnre 139 Connecting to QUICKBOOKS cccsseeeeee es 148 Connection Properties cccccceeceeeeeeeeees 141 Content Tab rrrrnnnnrannnnnnnrvanennnnennnnennanennnnen 70 Copies Determining when printing 176 JODY AEE TETEE 54 Create Filter rrrrarrrrnrrrnnrrrrnnrrnnnevnnnennnnennnre 162 Creating a Static Label rrrroranernnernnrnnnnennre 14 Creating New Wasp Labeler Data Source 155 Creating Substrings rarrrrnnnrrnnrrvnnnevnnnennnre 120 ETF 162 GE OM EEE 158 199 ENE 139 MN 54 D BEE GSE EE 162 Data Sorting rarrrnrrrrnnrrvnrevnnernnrevnnnennnre 158 Data Source ACCESS rrrarnrnrnnnrrnanevanennnennn 141 Data Source Another Object c068 112 Data Source Binding Example 0 20 Data Source Creating New Labeler Data ME 155 Data Source CSV File rrrrrrrnnrrnnnrrrnnnennnre 139 Data Source Database rrrrnrrnnnrrrnnnennnre 111 Data Source Excel File rrrrrrrnarerarenannnnn 143 Data Source ODBC rrrarenn
103. eler Wlab32 exe C temp LABfilename lab p u C Labeler sleep 10 C Labeler Wlab32 exe C temp LABfilename lab p c 6 u C Labeler sleep 10 C Labeler Wlab32 exe C temp LABfilename lab p I 10 u C Labeler sleep 10 C Labeler Wlab32 exe C temp file1 lab C temp file2 lab u 197 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 am New Label Wasp Labeler mE Design Data Print J a a a New Open Close Save Save Save Example Label g s All Templates Open Close Save New Labell X Version 7 0 0 Build 12 12 2011 0841 Waste Unlimited User Licenses BARCODE TECHNOLOGIES Copyright 1995 2011 Wasp Barcode Technologies mi i him HE TG This product is licensed to piii Gdi M an ee it TI Warning This program is protected by copyright law and wee international treaties Unauthorized reproduction or distribution ih Le of this program or any part of it may result in severe civil Ly hi e and criminal penalties and will be prosecuted to the maximum i extent possible under the law 2 Click OK to close the About screen 198 t Labeler User Manual Index git Adding t LEDE anses 63 ico Adding to Label ccccsccceeeeeeeeeeees
104. er 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 By default the serialization continues past Z to AA BB etc If you want to change this select the Rollover after checkbox and enter a value After the entered value is reached the default is Z the serialization will start over with the seed value 5 If you set the labels to rollover after a set value and do not want them to reset to the seed value select the Reset after rollover checkbox Enter the value you want to restart at in the field provided 6 In the Serialization Configuration section check the checkbox if you want to do one of the following increment the sequence 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 2 Serialization Barcode 1 A B C D E F G H I m E di Number of samples to display 100 Refresh
105. he Design tab Using a data source allows for the automation of your labels as Labeler will extract the data from the associated data source and use that as the content for your text field barcode picture etc Example When to Use an External Data Source Using an external database from which to draw data is useful if your company has inventory information stored in a database Microsoft Access or Excel any ODBC compliant data source a delimited text file etc from which inventory labels with barcodes are produced Another example might be that a company needs to print mailing labels for their customers where the customer address information is stored in a spreadsheet In either case Labeler can easily access the data from the external data source and apply it to the label Please refer to the topic Getting Started Binding a Data Source to an Object for a step by step example of linking an object to an external source 137 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 New Label 1 Wasp Labeler File Design 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 Your options are CSV File Access Database Excel Spreadsheet MSSQL ODBC Connection QuickBooks
106. his field is always used to determine the number of copies if no objects are mapped to an external data source LExamples Specifying the Number of Labels and Copies Example 1 A label is setup with Numeric Serialization to produce a series of labels 1 through 500 If you enter 50 in the Specify box the first fifty serialized labels will be printed Properties Number of Labels m One full page 2 x 2 4 label s Specify 50 Number of Copies Manual from User As consecutive labels Dynamic from column in data source Abel and Order If you enter 50 in the Number of Labels Specify box and 2 in the Number of Copies Manual from User box 2 copies each of the first 50 serialized labels will be printed resulting in 100 physical labels Properties Number of Labels One full page 2 x 2 4 label s T Manual from User As consecutive labels Dynamic from column in data source Starting Label and Order Beginning Label 1 Select Order Across then down 181 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
107. ht the row s you want to delete then click the Delete Selected button Press the CTRL 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 For example you might want to print mailing labels in zip code order or conference badges alphabetically by participant name There are two methods for sorting data 4 10 1 Method 1 Sort Data Using Column Headers You can sort the data ascending or descending by clicking on the column heading in the Data tab When you click the header an arrow appears indicating if it is sorted ascending up arrow or descending down arrow The first time you click a heading it will sort ascending An example of columns with a sort arrow displayed on a header is shown below Employee Master List csv me Employee ID Depart J 158 Si 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 New Label Wasp Labeler File Design Refresh Edit Remove Join Data C
108. ies Object List for Example Label labx Text 2 Text 1 84 1 68 Content Source None 101 EE 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 Object List for Example Label labx Tr Text 2 Text 1 84 1 68 Content Sample 123 Content Source None Sample 123 General Ohiert Mame Tayt 7 Special Characters are ASCII Codes These are printable and non printable markers that tell a printer scanner etc how to handle spaces Note that for text boxes the only available Special Characters are lt TAB gt and lt CR gt These are the characters for Tab and Carriage Return For a complete list of ASCII Codes available please refer to the topic ASCII Special Character Codes 3 The data you entered into the Content box of the place holder text will appear in the text box on the Special Characters List as shown in the example above Select the special characters you want to appear in the Content of your text box The data will change depending on the code you select Note that codes that represent a non printable marker such as a space or carriage return will be represented by a symbol 4 Click anywhere off of the Special Characters list to close it The text box will display the content you entered 102 dr La
109. ilable label templates Highlight a label to see a preview and description Choose a label Addr3 labx Address labx X Address1 labx Address2 labx AddrSemi labx AddrTab labx Coupan tabs I Ii IM I I Il 1234 Name John Smith Company XYZ Corp CTIA labx Disks labx Badge 1000 EIA556A labx EntryFrm labx Badge labx HithClub labx Contains a sample conference or expo badge label It uses an external data source from a comma delimited text file It also has an example of a ID_Badge labx Serialized Text object representing the badge number Item Lbl labx 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 Badge labx Wasp Labeler Design ld Why amp Xa New Open Close Save Save Save Example Check for Abo Label 7 As All Templates Updates Open Close Save Badgelabx X Bar Code Expo Name Badge Name Name Company Company 1234 Badge 1000 38 a 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 fy Save Label EA i The following is a restricted location C Progr
110. 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 When you are ready to add a new column select Click here to add new column A new Column and Type column will appear Repeat steps 4 and 5 156 i 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 N ety Wasp Labeler D ata Source Create Column Click here to add new column Last Name String First Name String Number Last Name First Name Employee Number Delete Selected Save 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 browser window appears You can navigate to the location of your choice rename your database and save it The default Wasp Labeler Data Source name is DataSource1 WDF 10 Your data will appear in the Data tab 11 If you connected to the file from the main Data Source tab you can now perform the following functions Refresh the Data Edit the Connection Remove Connection Sort the Data Filter the Data 157 de Labeler User Manual 4 9 1 Deleting Columns or Data From the Database Highlig
111. ion Sort and Filtering Labeler will establish a connection using the same parameters you initially entered You will not need to reenter a path or other connection information All data contained in the source file that meets any sorts filters you have created in Labeler will be returned 173 de 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 You can also use this feature if you move the external data source to a new location For QuickBooks users you can use the Edit function to pull new edited data from the existing QuickBooks file If you want to switch to an entirely different type of external data source use the Remove function to delete the existing data from your project then create a new connection To edit the connection to the external data source click the Refresh Data button on the Data Source Tab toolbar New Label 1 Wasp Labeler File Design ort Filter Sort and Filtering Join Table The Connection screen specific to the type of file you are
112. ion 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 L Example Using the Dynamic from Column Option An Excel spreadsheet containing data columns mapped to multiple label objects could be modified to include an additional column in which the user specifies the number of copies Labeler is to print for each record Each record can have a different number of copies specified in this column You might find that data already existing within an External Data Source is ideal for controlling the number of copies to print of each label the quantity column of an inventory database could be used for printing item labels for example Steps for Using the Dynamic from Column Option Note You should already have an external data source setup for your label via the Data tab and bound to at least one object 1 Select the Dynamic from column in data source checkbox 2 Click the Select button The Dynamic from Column in Data Source screen appears ty Dynamic from Column in Data Source New Label 1 Instructions employee master st tt Employee First Name employee master list t Select the column containing the numeric values that will determine how many copies of each label are to be printed John Doe Milly Darling Settings Foster Cain Column Marla Sooner Lo
113. ion will stay the same and the text box will grow from the right and left 103 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 sie New La bel 1 Wasp Labeler TT File Jesien Data bA a th R otate E Dan nm ta Front dk Cut Undo C Box ti ak j Bring to Fron EaCopy Redo Line baa Align dy Send to Back E Inches 3 Paste EN Ellipse eure are H Space TH Bring Forward F Centimeters Clipboard Insert eg Amange Millimeters The units on the Format tab will update with the new unit of measure Left 3 1301972 cm Top 0 7641167 2 cm Height Format tab Text options are e Justification Select an option from the drop down list to set the justification of your text box Options are Left Center or Right e Font Click the ellipse button to select a font for your caption Below is an example of the Font screen Font Family Typeface Arial Regular italic Bold Bold Italic Black Raavi Red Sakkal Majallz Caigue Bold Obique Segoe Print Black Oblique Segoe Sa Lt Segoe UI Sample sample text 104 r 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 Sam
114. ipse button to view the color selection pop up shown below 74 Wasp Labeler User Manual Theme Colors E Ann Standard Colors HE HENNE More Colors Click on a color to select it or click More Colors to view the Advanced Color Palette screen shown below Advanced Color Palette 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 19 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 Basic Source A User Defined List amp Date Time va Serial Number 3 serial Alpha 3 Prompt At Print Another Object Strings To Concatenate data click String Builder String Builder Formatting To further apply formatting click Data Formatting Biff Format Value lily Format Caption Clear Content Click to remove current content settings 2 Clear Content This tab is divided into four sections e Basic Source This section is where you can bind the barcode to a data source object serial number or alpha date time etc e Strings To add more than one data source to the barcode use the String Builder e Formatting This section allows you to build on the general formatting done to the caption on the Format tab and
115. l provide the source data for the object Notice that the Properties Box now indicates that this object is using the Employee ID column as the data source Properties q Object List for Example Label labx T Barcode 1 Barcode 0 98 0 78 123456789 Database Column Employee ID Placeholder That s all there is to adding a data source and binding an object to it You can continue binding objects to columns or other data sources Serialized Numbers or Letters Data Time Etc as needed 24 ai 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 Continuing the Employee Badge example we previously bound the column containing the Employee ID to a barcode now let s bind the Employee First Name and Employee Last Name columns to a text box 1 Adda Text Box Object Click on the barcode icon and drag it to the Design window se Example Label labx Wasp Labeler r a File Data i Cut 4 Undo C Box ha po Sh Rotate ah Bring to Front EaCopy gt Redo Line Align i Send to Back i Pi tu B od ere ml ae 4 P
116. 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 Print The Print icon accesses the standard Windows Print screen where you can select a printer and print your labels Select Records Now Click the Select Records Now icon to select records to print 4 Select Records Now Asset Tag UPC Code Department Code Asset Type Item Descnpton Site Location Checked Out Senal No Condition Manufacturer 43078901412 12345687555 Frinter 64578688954 Printer You can CTRL Click on records to select multiple non adjacent records or SHIFT Click to select multiple adjacent records You can also e click Sort to access the Sort Criteria screen and apply an existing sort or create new sort criteria to the chosen records e click Filter to access the Filter Criteria screen and apply an existing filter or create a new filter to the chosen records e select a record s and click Print to print directly from the Select Records Now screen Any filters put on the data other than those created from the Select Records Now screen will be ignored The left Magnifying Glass icon takes you to the previous search entry and the right Magnifying Glass icon takes you to the next search entry Click the center Magnifying Glass b
117. ld 152 i 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 Ta Data Source Text File delimited Please select your text file below lt First row has column headers MaxRows 1000 E Test Connection 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 Enter 0 zero to return all rows of data Keep in mind that a very large number of rows may result in slower performance 7 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 EN Test Connection Sa e Connected successfully i OK Click OK on the Test Connection message to close it 153 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 Propertes 4 Select oolemins to ure on label W eet Tag J Department Code w Aiie Typ Then Descristiea Jr ft Lanier v Chita Gut 7 Serial Ne at Condition Manghacturer m
118. lect ITF 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 how tall your barcode will be The bar height does not affect density This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This settings stands for character per inch You can add more characters per inch by increasing the number in this field resulting in a more dense barcode Notice that as you increase the number in Char per Inchthe Char per inch field the Bar Width field decreases The more characters you add per inch the more dense your barcode will be Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all 87 de Labeler User Manual Ratio Bearer Bars Bearer Bar Width 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
119. lly Boomer Substitution for Non numenc Values If the column value is non numeric or blank then mey Marsupial Substitute the value with 1 sally Newman Tero Value Horatio Alger If the column value is equal to zero then Ralph Reed Print no copies for the record Jane Doe O Use the substitution value from above d C FP Maximum number of copies Limit maximum number of copies to This screen displays the first few rows of the data source associated with this label file 183 a 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 Use the substitution value from above this is the number you entered in the Substitute the value with field 6 Finally you can limit the maximum number of copies to a specified amount Labels will not be printed over this amount even if the number in the associated column is greater The default is 999 7 Click OK on the Dynamic from Column in Data Source when you are finished entering information 184 S Labeler User Manual 5 1 3 Print Tab Propertie
120. loyee names and ID numbers to objects on your label When printing Labeler will pull the information from the database and place it in the associated bound barcode or text box on the badge This topic will show you the basic steps for attaching a database to your label using the Static Label you created in the previous step 1 Open your label On the File tab select the Open icon New Label 1 Wasp Labeler Design Check for Updates Recently opened files will appear in the drop down If you see your label listed click on it to open If you do not see your label in the list click Open Files From Folder Browse to your label and select it It will appear in the Design window 20 ai Labeler User Manual Example Label labx Wasp Labeler Design Data Print oo Ws amp a New Open Close Save Save Save Example Check for Label z s All Templates Updates Open Close New Labell X Example Labellabx X 1 2 Jane Doe 123456 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 21 Wasp Labeler User Manual New Label 1 Wasp Labeler File Design Print Select the type of database you want to add For this example we want to add a ixt file that contains a list of employee ids and names so click on Text 22 ai Labeler User Manual The Data Source Text File delimited screen
121. mage Contact Journal Document Rich Text Document ER Ht q Text Document Compressed zipped Folder Briefcase F Ps Save the file with the name of your choosing make sure the extension stays txt then double click on the file name to open and edit the document The new list will appear in the browser window 115 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 gt Data Source tab The following screen appears sa Serial Number Settings 5 se series Start at seed Step iB Label E Rollover after Reset after rollover Serialization Configuration Increment number after each new record in data source use last number as next print job s seed value Preview OK Cancel 2 Select if you want your labels serialized in Incrementing series or Decrementing series by selecting the appropriate radio button 3 Enter the beginning number 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
122. most recent action undone by clicking Undo Insert The Insert options allow you to insert text basic shapes a picture or a barcode into your label After you insert an object you can add content to it from a variety of sources The options in the Properties box will vary depending on the type of object you chose to insert These icons use the Drag and Drop method for placement Place your cursor on the desired object then drag it to the Design window and drop it where you want it You can place it more precisely or move it as needed Insert Text This icon allows you to insert a text box onto your label You can enter static content into your text box or attach a database string soreadsheet etc to it For complete instructions on adding a Textbox to your label please refer to the topic Adding a Textbox Insert Drawing Object The Box Line and Ellipse icons allow you to add basic shapes to your label You can add a rectangle ellipse or line For complete instructions on adding a shape to your label please refer to the topic Adding a Drawing Object Insert Picture This icon allows you to insert a graphic onto your label The supported graphic formats are o Bitmap Files BMP o JPEG JPG JPEG JPE JFIF o PNG PNG o TIFF TIFF TIF o GIF GIF o ICON ICO For complete instructions on adding a picture please refer to the topic Adding a Picture Insert Barcode This icon allows you to insert a
123. mplates cccseceseeeeeenees 37 51 Er 143 Excel Connecting tO rrrnnrrrnnrrrnnrevnnnennnre 143 Export Barcode as IMage ccseceeeeeeees 52 Expression Forimat cccccccsseceecseeeeeesees 124 External Data Source rrarrnnnrnnnrnnanevanennnnnnn 137 External Data Source Excel 0ccee 143 External Data Source Sorting 0008 158 F PIG Tae 51 PUG OOM soeia EE E 59 Me Nav 162 Filter Criteria List rrrronrrrrnnrrornnrronrannennnnre 162 Filtering Data rrrnrnnnonnnnnnrnnnrvnnvnervnnennnnnnnnn 162 SEN 176 FI 59 Format Barcode arrranrnnnnnnnnnvnnevnnrnnnnnnnnennnnn 70 Format Date rrarrnrrnnrnnrnarvnrrnernnrnnnnnrrnarnsnner 124 Format Expression rrnrrnarnnnrvnnrnnnnnnnnnnrnnnn 124 Format TIMG ccccccceccecceeceeeeeeeeeseeeeeeeeees 124 OFM La EE 124 G Getting Started Binding a Data Source to an Go nee 20 Getting Started Creating a Static Label 14 Getting Started Example Static Label 14 Getting Started Navigating the Main Screen 5 GIF Export Barcode as 0cccceeeeseeeeeeeeees 52 Graphic Adding to Label eceeeeeees 63 Graphics Supported Formats cc0008 54 GS1 Limited Properties rrrrrrrnrnrrnnrrrnnrrvnnen 95 GS1 14 Properties rrrarrrranrrrnnnrvnnnrnanennanen 95 H Hide Show Properties BOX c cccceseeeeeeeeees 5 I Image E
124. n cece ceeccceeeeceeeeceececeeeeseeeceeeeseeeeseeeesaueesaeeesaueeseneesaes 175 onanie ad EE EEE EEE ER 176 PN TAD NNM 176 5 1 1 Print Toolbar Function Descriptions rrnnrrnnrrnanenanennnnnnnnnnanrnnnnnannnanennsrnnnnnnnnennnennennnnnnnsenn 177 5 1 2 Print Tab Properties Box Number of Copies rrarnrnnnnnnnnnnnnnnnnnrnnnnnrnnnnnrnnnnrnnnnnnennnsrnnnnnnennnnne 181 5 1 3 Print Tab Properties Box Starting Label and Order cccccseeeeccseeeeceeeeceeeecaeeeesaeueesaaees 185 5 1 4 Print Tab Properties Box Data SOurCe rrrrarnvnnannvnnnnnvvrnnnrnvnnnrnvanrnnnnnrnnnnnsnvnnnsnnnnnsnnnnnsennnnne 186 5 1 5 Print Tab Properties Box Print Summary rrnnnnnrnnnnnnennnnnnnnnnnrnnnnnrnnnnrennnnsnnnnssennnssnnnnnnennnnee 186 52 Page Sep NN 187 5 2 1 Access and Use the Page Setup SCreen arnrnnnnnrnnnnnrnnnnnrnrnnnrnrnnnnrnnnrnnnnnsnnnnnrennnnsnsnnnsennnnee 188 5 2 2 Create a Custom Layout sccscccsanctateasantanssssanchenduendisyandsendcmnnonasanaiaaniannmanenedantteaatioasieenieawiuewtes 189 ee OOD aay T E E E A A E E E E E EE 190 5 2 4 Delete EE EEE 192 Chapter 6 Activating Wasp Labeler rrannrnrnnnrnrnnnrnrnnnrnrnnnrnvanrrnnnnnrnnnnsrnnnnnrnnnnnrnnnnernnnnnrnnnnsennnnsennnsee 193 6 1 Steps to Activate Wasp Labeler arrnrarannnnrnnnnrnvnnrnrnnrnvnnrnvnrnnnnnnnnnennnnsnnnnsnnnnsnnnnsnnnnsnnnnennunennnnen 193 6 2 Updating YoUr LICH SC edda 195 Chapter 7 Running Labeler from a Command Line
125. n a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This setting determines how tall your barcode will be The bar height does not affect density The table below lists the options available for GS1 Limited Code in the Properties box gt Barcode tab GS1 Limited Field Description Select GS1 Limited from the drop down list For a complete list of Symbology available symbologies along with examples and descriptions of each Bar Width Bar Height please refer to the topic Barcode Symbology Reference This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This setting determines how tall your barcode will be The bar height does not affect density 95 Labeler User Manual GS1 Stacked Omnidirectional The table below lists the options available for GS1 Stacked Omnidirectional in the Properties box gt Barcode tab GS1 Stacked Omnidirectional Field Symbology Bar Width Bar Height Description Select GS1 Stacked Omnidirectional from the drop down list Fora complete list of available symbologies along with examples and descriptions
126. n the field below to test the Format String Dec 1 2011 5 15 35 PM Test Results 05 15 35 133 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 Format Value Enter a sample in the field below to test the Format String Dec 1 2011 5 15 35 PM Test Results 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 Format Value Format String DATEFORMAT MMMM dd yyyy hh mm tt Test Area Enter a sample in the field below to test the Format String Dec 1 2011 5 15 35 PM Test Results December 01 2011 05 15 PM 134 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 e LEFT 3 This command returns the first 3 characters from the input e LTRIM LEFT 3 gt same as above but before it performs a LTRIM on the input then the LEFT 3 will be applied to the result e RTRIM LEFT 3 gt same as above but before it performs a RTRIM on the input then the LEFT 3 will be applied to the result e TRIM LEFT 3 gt
127. natinnalinnatanatanetianativentaineaerasis 55 3 2 Adding a Drawing ODJeCt cccccccccceecceeeceeeeneeeseeese ees eeseeeseeeeseeeseeeseeeeeeeeseeeseeeseeeseeeseeesseeeseeegeeegs 59 3 3 Adding d cd o e nen ne eee eee ee eee 63 3 3 1 Steps to Add a Picture to a Label 0 0 ccc cecccseccseeeceeeeeeeeeeeseueeeeeeseeeseeeseueeseeeseeeseeeeueeeeenanes 63 3 3 2 Picture Properties Box Format Talo cccccccceccseeceeeceeeeeeeeeeeeeceeeseeeaeeceeeseeeaeeseeeseeeeeeseeeneeses 65 3 3 3 Picture Properties Box Content Tab rrrnnnnnnnnnnnnnnrnnnrrnnnnnnnnnrnnnnnnnennanennanennanennanennuennasennnsennn 67 9 4 Adding Bal COG 6 vase tiea tose siucdbigetbincubnancbonooledieSteaisseciedececededscesecedecedeiedesd 68 3 4 1 Steps to Add a Barcode cccccecccseccceccceeeceueceueecueceuceneeeceueceuecsueeseeeseeecsueesuesueeaueeseeeseeesaass 68 3 4 2 Adding a Barcode Properties BOX ccccccceeccseeeseeeceeeeeeeeseeeeueeseeeseeeseeesaueeseeeseeeseeeeeueeeeesanes 70 3 4 3 Barcode Properties cccccccccsccceecceeccceeeceeeceeecuecueesueeseeesaeesauecsucesueeseesaeeseeeteueesuesseeeseeesaass 79 39 5 Adding Text BOX EEE 99 3 5 1 Steps to Add a Text BOX ccccccceccseccceecceeeceueceueecueceueeseeecueceueseueeseeesueseueesueseueeseessaeeseeesaass 99 3 5 2 Adding a Text Box Properties BOx rrrarrnnnrnnnnrvanennrennnrnnnnnnnnrnnnnnanennnennennannnnnennnennennnennnsenn 101 KEN OPON eae nee eee ENER 108 3 6 1 Obj
128. nd bind it to Serial Number Make sure the Last value as next print job s seed checkbox is selected on the Serial Number Settings screen 4 Adda textbox to your label 5 With the textbox selected click String Builder in the Properties Box gt Content tab The String Builder screen appears 6 On the String Builder screen select Label Counter then click Add Substring String Builder Build a string Label Counter x Add Substring dt from the following from substrings for Text 1 The substring will be added to the list as shown below 32 m tt Labeler User Manual Ay String Builder Build a string from substrings for Text 1 Label Counter The String is built from the following da Label Counter 1 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 Enter static value for the object 9 With your Static substring highlighted in the list select Add gt SPACE Before and Add gt SPACE After Substring Properties Substring Static 1 Place Holder C Ignore if previous substring is blank Format with Data Formatting 33 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
129. nnnsene 2 1 3 Getting Started What is Barcode uuunuss4auvussdredsenasdsinidsnadesnnesssneesnedenaveksnesde E 4 1 4 Getting Started Navigating the Main Screen rrranrrrnnnrranrrranrrnanrnranrrnannrnnnnrnnrnnnnnnnnnnnnnnsennnsnnnnssnnn 5 141 Section A Help Resizing ES ar 6 SNE TN T 2 TN 10 1 4 4 Section D Design Window arannnrnnnnnnanevnnrnnnrnnnnnnnnennnrnanennnrnnnsnnnnnnanennnennnsnnnnnnnnennnnnnnennnennnene 10 IA SE PN NEEB 11 1 5 Getting Started Creating a Static Label rrrnnnnnnnnrnnnnennnnennnnennnrnnanennnnennnnennanennanennansnnnnsnnnsannnne 14 1 6 Getting Started Binding a Data Source to an Object rrranrernnrrrnnnnnnnrranrrnrrrnerrnnrrnnrrnarnnnnrnnnennsennn 20 1 7 Getting Started Using String Builder to Concatenate Data rrnnrnnnnnnnnnnnnnrnvnnvrnnnnrnnnvrnnnrennnrennnr 25 1 8 Getting Started Creating Enumerated Labels rrrrannnnnnnnrnnnnrnnnnnnnnnnnnnnnnnennnnennnnennnnennnnennanennnne 32 1 9 Getting Started Example LAS 5 55555445 444 37 1 10 Barcode Symbology Reference urira EAA a 40 Ne 51 TET NNN 51 2 2 Exporting a Barcode as an Image File cccccccccecccssccceeeceeeceucceeceueceueesueeceeeseuecsuesaeeeseeeseeeneeess 52 2 3 Exiting Wasp Labeler with Unsaved Labels ccccccceecceeeseeeceeeeeeeeeeeseueeeeeeseeeseeeseeesaeeeaeeeseeens 53 NENNE 54 39 1 D sign Toolbar Function DESCHDIION Ss lt lt acesesesnsitsenveasstsouseoaatesairewaniseanmainmneia
130. nrnnnnrnanevanennnennn 146 Data Source Prompt at Print 008 118 Data Source QUICKBOOKS rorrrrnnrrrnnnennnre 148 Data Source Refresh cccccceeeeeeeeeeeees 173 Data Source Text Box nrrnnrrrnnrrrarevnrnnnnn 101 Data Source User Defined List 113 Data Sources Concatenating c008 120 Data Sources Multiple rrrrrrrerarernnennnrr 120 Data Tab Overview rrrarrnnrrnnnrnnareranennrnnnnnn 137 Database ACCess r arrrarnnnrnaronnrnnernannnnnnnee 141 Database Binding tO rarrnnnrnnnnnnnnrvnnrnnnnnnn 111 Database Filter rrarernrrnnrraronnrnnrrvannnnnnnre 162 Date Formatting arvnnrnnnnnnrnnnrvnnnnnnnnnnnnnener 124 BEE AE NE 108 Decimal Placeholder rranrnanonnnnnnrnannnnnnnre 124 Deleting a Filter rrnrrnnnnnrrnnennnnnnnnnnennnene 162 Design Window R SIZING csccseeeseeeeeenees 5 Digit Placeholder rrranrnnnrnnnnnnnnnnnnennnnnnnnnn 124 Drawing Object Adding rarernnnvnnrnnnnnnnnnnnre 59 Dynamic from Column in Data Source 176 E Editing Layout Templates rrrrrnrernrrnnvrnnn 187 Example Binding a Data Source to an Object20 Example Creating a Static Label 14 Example Label Design Tab 000c0ee 54 Example Labels cccccssccseecseeeeeeeseeeseees 37 Example Static Label rronnornnnornnrernnnennnner 14 Example Te
131. o Last AGO M up 54 Units Ruler rrrnrnnnrrnarrnnrvnrerannnnrnnnrnanennnnnnnnn 54 Unsaved Labels Closing rrarerarnnnrnnnevnnnnn 53 Updates Checking fOr ccccseceseeeseeeeeees 51 User Defined List rarrnnrnnnennnnnnrnnrrnannnnnnre 113 V Version Number rannnnnnannnnrnnnenannnnrnnnennnnnn 198 MTOM WIG IU a E A 54 W Wasp Labeler Data Source Creating New 155 WMP Export Barcode a5 rrnrnnnnnnnnnnnnnnnnnn 52 Z LOOM IN hce ARA 54 LOOM Ur 54 Zoom Percentage arnnnrnnnnnnnnnnrvnnnnnnnnnennnen 54
132. o move a selected object backward 58 ar 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 e Units Ruler Changes the ruler units Options are Inches Centimeters and Millimeters e Layout Accesses the Page Setup screen where you can choose the label type size e 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 To move it back to the default position click the Reset Docking icon View The View menu allows you to zoom in or out of the Design window e Zoom In Allows you to get a close up view of your label e Zoom Out Allows you to see more of the page at a reduced size e Zoom Select a percentage from the drop down to zoom in on the label e Reset Zoom Returns the view to default settings 100 3 2 Adding a Drawing Object You can add Boxes Lines and Ellipses to your label using the drag and drop method Drawing objects can be moved resized and customized as needed 1 Onthe Label Design tab click the Box Line or Ellipse icon on the toolbar New Label 1 Wasp Labeler Data amp Cut Undo _ Box ju i sue h Bring to Front Line anti Align iia Send to Back aCopy gt Redo Text _ icture Barcode 4 Paste j Ellipse Peale Hakon Space W Bring Forward Clipboard
133. ob 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 5 Print Tab Properties Box Print Summary This section displays a summary of the print options you have selected Number of labels Indicates the number of unique physical labels Number of copies Indicates the number of copies of each label Total pages to print The total number of label pages that will print Total labels to print The Number of Labels x Number of Copies This is the total number of labels that will print based on your settings e Current Printer The printer you currently have selected for label printing You can change this by clicking the Print button and selecting a different printer e Print Page Size The size of the label page you selected on the Page Setup screen via the Layout icon 186 Si 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 The available predefine
134. of each please refer to the topic Barcode Symbology Reference This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This setting determines how tall your barcode will be The bar height does not affect density GS1 Truncated Properties Box Options The table below lists the options available for GS1 Truncated in the Properties box gt Barcode tab Field GS1 Truncated Description Select GS1 Truncated from the drop down list For a complete list of Symbology available symbologies along with examples and descriptions of each Bar Width Bar Height please refer to the topic Barcode Symbology Reference This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This setting determines how tall your barcode will be The bar height does not affect density 96 Labeler User Manual GS1 Expanded Properties Box Options The table below lists the options available for
135. on to update the samples with any changes you have made or Close to close the Serialization Preview screen 9 Click OK on the Serial Number screen to save your changes 117 de 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 Steps to Enable Prompt at Print for an Object 1 With the object Text Barcode or Picture in the Design window click the Prompt at Print button on the Properties box gt Data Source tab The following screen appears En Prompt at Print Prompt Description 2 Enter a description for the prompt in the field provided This should be descriptive enough that the user printing the labels will know what value to enter Click the OK button When the labels are ready to be printed on the Print tab click the Print button A Keyboard Entry screen similar to the following iy Print Keyboard Input Label 1 of 40 Object Name Question Barcode 1 Prompt Description Example E Loop continuously Next 5 Any objects that are setup for a prompt appear in the top window
136. onnection Connection Data Source Connection Sort and Filtering Join Table a Instructions To create new sort criteria click the Add button Or select an existing sort criterion and click the Delete Edit or Set as Active button Sort Criteria List Cnteria Asset Tag UPC Code Department Code Asset Type Item Descnpton Site 22450879845 i Frinter 45678065412 Frinter 12345687555 Frinter 64578888954 i Frinter 159 EE 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 fS Add Sort Criteria 9 me Sort Criteria Name SortNamel Column Sorting Order Asset Tag Ascending Add Criteria Set as Active Clear OK Cancel 3 Enter the name of your new Sort Criterion in the Sort Criteria Name field 4 The Column drop down menu lists all columns from the data source that you have selected to be included in your label project Select the column you want to sort from the drop down menu 5 Select Ascending or Descending from the Sorting Order drop down menu 6 You can add additional criteria to by clicking the Ad
137. ou select Note that codes that represent a non printable marker such as a space or carriage return will be represented by a symbol 4 Click anywhere off of the Special Character box to close it The barcode on your label will change to depict the content you entered 71 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 gt 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 Symbology Gode1d2 amp itl Bar Width 0 0104000 Chars per Inch 17 4825175 gt Bar Height 0 4000000 n Char Set Auto Append The fields available on the Barcode tab vary depending on the symbology selected Click a symbology below to view a description for the related properties E e e MicroQRCode Az C gt MS Aztec Code e PDF417 e NET e PLANET ET 7 e POSTNET e Lode 95 e QRCode e Code 11 AE Data Matrix G5114 EANJANS e GS1 Limited STE e GS1 Stacked ee Omnidirectional interleaved 2 2 e GS1 Truncated of gt e GS1 Expanded e ISBN ISDN e GS1 128 e ITF14 LAE e UPC A e Maxicode e UPC E e MicroPDF417 KG 12 dr Labeler User
138. ox Entering Static Data Static Data is data that does not change as your labels are printed The content for that object will be the same on each label For a detailed example of creating a static barcode please refer to the topic Getting Started Creating a Static Label Steps to Enter Static Data 1 Make sure your barcode object is selected in the Object List drop down menu Properties Object List for Example Label labx Barcode 1 Barcode 0 98 0 65 Placeholder 123456789 Database Column Employee ID 70 Ee 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 Properties g Object List for New Label 1 g Barcode 1 Barcode 0 64 0 78 Content Source None Symbology Gode 1287 Rar Width n AI NANNA Jane Doel23456 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 The data you entered into the Content box will appear in the text box on the Special Characters List as shown in the example above Select any special characters you want to appear in the Content of your barcode The data will change depending on the code y
139. perform a check on the entire string including the first check digit Show in When this option is selected the check digit will appear in the Caption barcode caption Ratio This is the wide to narrow bar ratio The default setting is 2 2 1 91 de Labeler User Manual PDF417 Properties Box Options The table below lists the options available for PDF417 in the Properties box gt Barcode tab PDF417 Field Description Select PDF417 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 Joes not affect density This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is Bar Width decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all Columns Select the number of columns for your barcode 1 30 Rows Select the number of rows for your barcode 3 90 Error Select the error correction level 1 8 The error correction level Correction depends on the amount of data that needs to be encoded the size Level and the amount of symbol damage that could occur Select this checkbox to truncate or remove th
140. play 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 If you anchor it Center the center position will stay the same and the barcode will grow from the right and left Format tab Caption options are Align Select an option from the drop down list to set the alignment of your caption above or below your barcode Font Click the ellipse button to select a font for your caption Below is an example of the Font screen Font Family Typeface Arial Regular a italic uiv k yp Bold Raavi Bold Italic Rod Black Sakkal Majalla Coaingue Bold Oblique Segoe Print _ Black Oblique Segoe Sta Lt Segoe UI 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 Format tab Drawing options are Fore Color Back Color The Fore color the color of your barcode defaults to black The Back color the background color defaults to white Click the ell
141. ple section Click OK to save your selections or Cancel to close the Font screen without saving your selection e 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 Content Tab The Content tab allows you to specify the content of your text box if you are not using static data Below is an example of the Content tab 105 Labeler User Manual This tab is divided into four sections e Basic Source This section is where you can bind the text box to a data source object serial number or alpha date time etc e String Builder To add more than one data source to the data source serial number plus static content for example use the String Builder e Formatting This section allows you to build on the general formatting done to the caption on the Format tab Here you can format the value which is the barcode content and or format the caption by creating a mask that will be applied to all data captions if using a data source for example e Clear Content Click the Clear Content button to remove the data source from the barcode Basic Source This section lets you choose the data that will be encoded into your text box Click on a source type to bind it to your object barcode graphic or textbox Source options for text boxes are Database Date Time Serial Alpha Another Object User Defined Li
142. r QR Code in the Properties box gt Barcode tab QR Code Field Description Select QR Code from the drop down list For a complete list of Svmbol available symbologies along with examples and descriptions of each ym9ot09Y please refer to the topic Barcode Symbology Reference Select the Code Version for your barcode You can choose Auto to Code Versionhave Labeler select the version for you based on the barcode s content or select Version V01 through V40 Select the Error Correction Level Options are L Approx 7 capability M Approx 15 capability Q Approx 25 capability H Approx 30 capability Select the type of data you want to encode Options are AlphaNumeric Auto Byte Numeric Code Module Select the size ofyour barcode or let Labeler determine the sized Size based on content or previous selections 94 Labeler User Manual GS1 14 Properties Box Options The table below lists the options available for GS1 14 Code in the Properties box gt Barcode tab Field Bar Width Bar Height GS1 Limited Description Select GS1 14 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 Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit o
143. r labels based on a beginning number you select e Serialized Alpha The Serialized Alpha option allows you to serialize your labels alphabetically based on a beginning letter you select e Static This option allows you to enter static text or characters that will appear on all of your labels e User Defined List Labeler contains a set of pre defined lists you can select from or you can create your own lists e Date Time This option displays the current date time or a date time of your choosing on the associated object e Prompt at Print This option allows you to enter a question or prompt for information that will appear when you print the label e Bind to another Object This allows you to bind the substring to another object that already has a data source e Label Counter Text Box Only This option allows you to put 121 EE 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 e Label Total Text Box Only This option displays the total number of physical unique labels printed e Copies Counter Text Box Only This option allows you to put a copies counter on a text box A copies counter counts the number of identical copies of a label that are printed determined in the Number of Copies fields on the Print tab e Copies Total Text Box Only This option displays th
144. r screen is different for barcodes and text boxes String Builder Screen Barcodes String Builder Build a string from substrings for Barcode 1 The String is built from the following Substring Properties Substring Place Holder Add Before Add After Ignore if previous substring is blank Format with Include Substring in Bar Code value Include Substring in Bar Code caption Sample result after concatenating all substrings OK Cancel 120 Wasp Labeler User Manual String Builder Screen Text Boxes Biy String Builder Build a string from substrings for Text 1 M The String is built from the following Substring Properties Substring Place Holder Add Before Add After Ignore if previous substring is blank Format with sample result after concatenating all substrings ret 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 e 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 If you have not yet connected to a data source please refer to the topic Data Tab Overview for detailed instructions e Serialized Number The Serialized Number option allows you to create serial numbers for you
145. ra A D 1 33 45 AD 1 33 45 AM I The day of the month from 01 through 31 The full name of the day of the week h Hour The hour using a 12 hour clock from 1 to 12 9 26 2011 1 33 45 PM I hh Hour The hour using a 12 hour clock from 01 to 12 H Hour The hour using a 24 hour lock from 0 to 23 1 33 45 AM I 9 26 2011 130 Wasp Labeler User Manual _ 0 W sre HH Hour e hour using a 24 hour clock from 00 to 23 m Minute e minute from through 59 mm Minute e minute from 00 through 59 9 26 2011 MM Month The month from 01 through 12 MMM Month Mhe abbreviated name of the month MMMM Month 9 26 2011 ss Second e second from 00 through 50 9 26 2011 tt AM PM The AM PM designator Year The year from 0 to 99 yy Year Mhe year from 00 to 99 yyy Year The year with a minimum of three digits yyyy Year Mhe year as a four digit number The full name of the month 131 EE Labeler User Manual l Time The ti i 9 26 2011 z Separator e ume separator 1 01 A5 AM Ev j Date Ja 9 26 2011 Separator e date separator 1 01 45 AM ABC Any other character Literal String Delimiter Custom Format Specifier Escape Character Indicates that the enclosed characters should be copied to the result string unchanged Defines the following character as a custom format specifier Many characters in the format expression have a
146. rcodes should be printed using a high quality laser or ink jet printer or a thermal label printer You want the barcode label to be high quality because low quality barcodes are harder to scan and usually do not last long Wasp Labeler can print to a regular printer or a barcode printer ai 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 Use this topic to help familiarize yourself with getting around in the application Links to detailed instructions for using each function are provided throughout this topic New Label Wasp Labeler File Print es Cut lt lt Undo Ag C Box EO NN Sb Rotate ch Bring to Front i Send Backward Hi Units Ruler Zoom UERS BaCopy gt Redo Sk S Align Gia Send to Back _ Layout A 1100 l Paste Ellipse ette Barcode HA Space 1 Bring Forward Tw Reset Docking I Clipboard Insert Arrange Layout Options View New Label 1 X Object List for New Label 1 Help Resizing Icons Tabs Icon Toolbar Design Window Properties Box mUNW g
147. reate a password so you may come back and access your software keys at any time Password Confirm Password 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 Success screen appears iy SUCCESS mn i j Product now activated Ku Click OK on the Success message screen After activation the Activate Labeler icon changes to Update License 194 EG Labeler User Manual 6 2 Updating Your License 1 After product activation On the File tab click the Update License icon gre New La bel Wasp Labeler is HEE E Design Data New Open Close Save Save Save Example Check for About Update Label s All Templates Updates License Open Close Save Help New Labell Your Unlimited User Licenses key is If you wish to update your license you can do so by entering a new activated license key below then click OR button J0000000000004 Register 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 195 Labeler User Manual The Registering Products page from the Wasp Barcode Technologies website appears Registering Products Back to Support Center If you ve already registered and would like your keys email
148. refer to the topic Barcode Symbology Reference Nominal symbol height for UPC E is 25 9 mm 1 02 in You can set GOE Nomina the magnification from 80 to 200 Specify Bar Height Check this box to enter a specific bar height Bar Height Enter the exact bar height in the field provided 98 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 Mg Example Label labx Wasp Labeler dy Cut Undo A _ Box ba wy a 23 Copy io 5 Line Text O Ellipse Picture Barcode HL Spa Paste Clipboar Drag and drop the icon where you want the text box to appear on your label you can change the location at any time When you place the text box on your label notice that the Properties Box displays the options for defining your text box 99 Labeler User Manual Properties Object List for Example Label labx Text 2 Text 1 84 1 73 Content Source None General Object Name Text 2 Left 1 8435417 EI inch Top 1 7279167 3 inch kl i i a Height 0 145833 Rotate 0 degrees Display on Prin
149. rom the dropdown Step 1 a Every 1 a label s List Preview 113 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 Colors tt State Abbreviations txt State Names txt or click Manage Lists to create a new list or select a list you have already created When Manage Lists is selected a Manage Lists browser window appears JQ VES Wasp Technologies Wasp Labeler V7 UserDefinedLists v 4 Search UserDefinedLists Organize v Include in library v Share with Burn New folder r Favcidies Name Date modified Type Size E Desktop E Colors txt 12 7 2011 8 28 AM Text Document 1 KB J Downloads State Abbreviations bt 12 7 2011 8 28 AM Text Document 1 KB El Recent Places L State Names txt 12 7 2011 8 28 AM Tet Document 1 KB Libraries Ea Documents a Music Pictures H Videos jE Computer th Network A 3 items 114 dr Labeler User Manual 3 This browser window opens to the lt path gt 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 right clicking anywhere in the window and selecting New gt Text Document View Sort by Group by Refresh Customize this folder Paste Paste shortcut Undo Copy Share with m New Folder Shortcut Properties Bitmap I
150. row of your file contains column headers make sure the First Row is Column Headings checkbox is selected 143 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 Connected successfully iD Click OK on the Test Connection message to close it 7 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 Properties a Select columns to ude on label Fi Himera de articula af Desorgskda Lop 8 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 144 S Labeler User Manual 4 5 Connecting to Microsoft SQL Server 1 Onthe Data tab click the MSSQL option Please enter your Microsoft SQL Server information below Username Use Windows Authentication Password Databas 2 Any SQL servers setup on your network will appear in the Server drop down menu Select the desired Server from the drop do
151. rrrnnrernnnrrnnnrvanrnnanernanennanennanennanennanennanennnsennn 152 Wasp Labeler User Manual 4 9 Creating a Wasp Labeler Data SOUICe rrrnnrnnnnnnrvnnnnnvvnnnnnnnnnnennnnrnrnnnrnnnnnrnnnnnrnnnnnrnnnnnsnnnnssnnnnnen 155 4 9 1 Deleting Columns or Data From the Database rnrrrnnnrvrnnrennnrrnnnrrnnnrennnrrnnrrnnnrrnnnnrnnnernnnsen 158 410 SOM Dale Source CONN gt EE NNN PE 158 4 10 1 Method 1 Sort Data Using Column Headers urrrnrrvnrnvrvnrnvnvnrnvnvnnnnnernnerennnerernnerernnenennnvn 158 4 10 2 Method 2 Sort Data Using the Sort Button rrrrnnrrrrrnrrvrnnnrrerrnnrernnnrrnnnrrnnnnrrennnrrrnnnerennnnn 159 4 11 Filter the Data Source COMIN uvaner sesaseneeeadaaagaddd dd dd dedj ahead 162 TITT T E E TETTE 162 4 11 2 Deleting a Filter rrarnnnrnnnrvnnnnnrnnnrvnnrvnnnnarnnrnnnrnnnnnnrnnnennnnnnnnnnennnnnnnnnernennnennnnneennnennnnnennene 167 4 12 Joining Tables rrrnnrrnnnrvnnnrrnnnrernnrernnrennnrnnanernanrrnnrennanrnnnnennnnrnnnnennnnennrennsennssennssennsennsennseennn 168 4 12 1 Steps to Join Tables sssisccscssatencntccactiaceseczcdseresuenstentetenetusedoertacwiaccuneagurecednnaeadstesceesereceseccsceces 169 4 13 Refreshing Data Source Information rrrronnrrnnnernnnrrnnnernnnrrnnnrnanrnnanennanennanennanennasennasennanennasennn 173 4 14 Editing the Data Source Connection rrrrnnnrrnnrrrnnrevnnnernnnernnrrnanrnnanennanennanennanennanennanennanennssennn 174 4 15 Removing the Data Source Connectio
152. rrrrnrnnrnrrrannenrnnnennnn 145 Minimizing the screen rrrrrnnrrnnnnnrvnrennnnnnnnne 5 MIRIM EEE 124 Multiple Data Sources rrrnnrrnnnrrnnnrrvnnnennnre 120 N New Data SOurce arrnnarannnrennnnennnnennnnennnnn 155 New Labell cccccccecceceseeeeeeeeeeeeeseeeseeeeeeees 51 Number Formatting cccceccceeeeeeeeeeeenes 124 Number of Labels rrrannnnnnnnnnnnnnennnevnnnnnnnnnn 176 O Object Bind Time Date to rrrnnnrrnnnrrnnnnnn 108 Object Bind to Another 112 Object Drawing Objects rrrnnnrrnnnrrnnnrennnr 59 Object Data Source Prompt at Print 118 Object Source Serial Alpha rrnnnnnnner 109 ODBC Connecting cccccseeeeseeeeeeeeees 146 5 eee nee ee eee eee 51 Open an exising label rrrnrrnnnrernnrernnrennnre 51 Outline Width rrronrrnrnnrnornnrrornnnnornnnennnnnennnn 59 P Page Ede 187 Page Setup ScCreen rnrarrnnarannannnvanrnnnnnnnnn 187 Fe 54 Percentage Placeholder rrnnnnnnnnnnnnnnnnn 124 Picture Adding to Label 63 Picture Resize r rrrrarrnnrnnrrvarevnrnnervanennrnnnnnn 63 Pictures Supported Formats rrrnnnrrnnnrr 54 Placeholders arannnnnnnnnnnnnvanevnnrvnnrnnnnnnsnnn 124 PNG Export Barcode aS 52 Preview Serial Alpha rrrarnnrennnnrrnnnennnre 109 Print Prompt At ccceccseeceeeseeeeeeeeeenees 118 Print Tab ee 176 se ald go EA 1S io
153. s One full page 2 x 2 4 label s Number of Copies Manual from User As consecutive labels Dynamic from column in data source Starting Label and Order Beginning Label 1 Select Order Across then down x Zs 179 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 If you have multiple boxes of the same item and each item has a unique serial number you can print labels that specify 1 of N with N being the number of boxes Example 3 If you are using an external data source and want one label for each record in your data source enter 1 in the Number of Labels Specify box 180 Si 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 T
154. s Box Starting Label and Order e 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 Select Beginning Label Choose the beginning label for this print job by selecting it with the mouse or specify it below Label i Column The preview pane shows how many labels are on the page as per the label format you selected on the Page Setup screen 2 Click on the label in the preview pane where you want to start printing Or you can enter the Row and Column number in the Label fields 3 Click OK when you are done making your selection The Print Preview pane on the Print tab will update to reflect your selection e Order You can use this feature to tell Labeler in what order to print the labels on the page Your options are Across then down this tells the printer to start at the left side of the page print across then go down one row and across Down then across this tells the printer to print all the way down the column on a page then across to the next column and down 185 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 j
155. s printed on labels and as a full box with H gauges when printed directly on corrugated surfaces ITF14 Example 12345678 90123 1 45 de 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 MaxiCode uses three unique properties when encoding the data Class of Service Country Code and Mode Maxicode Example Postal Code 75074 Country Code 840 Class of Service 003 MicroPDF417 MicroPDF417 is a multi row 2D symbology derived from and closely based on PDF417 It is designed for applications that need improved area efficiency but without the requirement for PDF417 s maximum data capacity A limited set of symbols is available together with a fixed level of error correction for each symbol size Module dimensions are user specified to enable symbol production and reading by a wide variety of techniques MicroPDF417 Example pe Micro QR Code Micro QR Code is a very small QR Code that fits applications that require a smaller space and use smaller amounts of data such as ID of
156. small area It is becoming the industry standard for marking small electronic equipment It is also used in the aeronautical industry and the US Department of Defense Data Matrix barcodes can be read by smart phones by downloading a reader Data Matrix Example dn EAN JAN The EAN JAN 13 is fixed length and is similar to the UPC A symbology but encodes a 13th digit Also the 12th and 13th digits of an EAN 13 may represent a country code in its entirety or just the beginning of the country code which may vary from 2 to 3 digits The code 00 04 and 06 09 are assigned to the United States The nominal height for the EAN JAN 13 bar code is one inch The reduced size is 80 of the nominal size The EAN JAN 8 is fixed length and is similar to the UPC E code but includes two more digits for the country code The nominal height for the EAN JAN 8 bar code is one inch The reduced size is 80 of the nominal size 42 t Labeler User Manual EAN JAN 8 Example 1234 5670 EAN JAN 13 Example 4567 890128 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 The administration of the numbering system by GS1 ensures that identification codes assigned to particular
157. special meaning and can t be displayed as literal characters unless they are preceded by a backslash The backslash itself isn t displayed Using a backslash is the same as enclosing the next character in double quotation marks To display a backslash use two backslashes For example the numeric formatting characters 0 E e comma and period and the string formatting characters amp lt gt and can t be displayed 1 01 45 AM arr hh mm t arr 01 45 A The character is copied to the result string unchanged 132 Labeler User Manual Example Data and Time Format Expressions Enter a custom date format in the format shown below DATEFORMAT lt format string here gt The DATEFORMAT prefix must be specified followed by the lt format string here gt section Inside the lt format string here gt you can enter any valid formatting string from the table above The brackets are required Example 1 DATEFORMAT dd MM yyyy If the value Oct 4 1973 is entered the Test Results will display 04 10 1973 as shown in the screen example below n Format Value F al Format String DATEFORMAT dd MM yyy Clear Test Area Enter a sample in the field below to test the Format String Oct 4 1973 Test Results 04 10 1973 Example 2 DATEFORMAT hh mm ss If the value Dec 1 2011 5 15 35 PM is entered the Test Results will display 05 15 35 4 Format Value Enter a sample i
158. st Serial Number Prompt at Print String Builder To add more than one data source to the text box use the String Builder You can create multiple substrings on the String Builder screen Substrings allow you to concatenate or join different values to build what appears to be a single text box or barcode object on the label from multiple data sources This option can be 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 To compress two or more text or barcode values of different lengths from an external data source 3 To compress multi line text values to remove blank lines For example if you want your text box to have a serialized number followed by a space you would use the String Builder to accomplish this Click here for a detailed example of using String Builder to concatenate two different data sources in a barcode Click here for detailed instructions on using the String Builder screen 106 Labeler User Manual Formatting The Formatting section on the Properties box gt 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 crea
159. st in directing mail The ZIP Code or ZIP 4 code is encoded in half and full height bars Most often the delivery point is added usually being the last two digits of the address or PO box number The barcode starts and ends with a full bar often called a guard rail or frame bar and represented as the letter S in one version of the USPS TrueType Font and has a check digit after the ZIP ZIP 4 or delivery point The encoding table is shown on the right Each individual digit is represented by a set of five bars two of which are full bars i e two out of five code The full bars represent on bits in a pseudo binary code in which the places represent from left to right 7 4 2 1 0 Though in this scheme zero is encoded as 11 decimal or binary 11000 47 de Labeler User Manual POSTNET Example PLANET PLANET stands for Postal AlohaNumeric 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 12345678901 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 The code consists of black modules arranged in a square pattern on a white background The information encoded may be text URL or other data QR Code Example ordo ot U UPC A Each UPC A barcode consists of a scanna
160. t 1 J Ld Lal T page ja LI Mi Anchor enter Text Justification Left Font Arial is Auto Size Size Rectangle to Text ne 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 100 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 The topics covered in this section are Entering Static Data Format Tab Content Tab Basic Source Section String Builder Section Formatting Section Content Field Entering Static Data Static Data is data that does not change as your labels are printed The content for that object will be the same on each label For a detailed example of creating a static barcode please refer to the topic Getting Started Creating a Static Label Steps to Enter Static Data 1 Make sure your text box object is selected in the Object List drop down menu Propert
161. t 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 You can search for or navigate to other topics as needed Context Sensitive Help You can access a Help topic specific to the screen or feature you are currently using by clicking on the small question mark arrow that appear on most screens and in the Properties box Clicking the Help icon on the Properties box launches Help specific to the object you have selected You can also launch context sensitive help by hitting the F7 key on your keyboard Help Button Example Screen oe Date Time Settings Ea Includes Date Format Time Format DateTime per Date al Mediuim Time Help Button Example Properties Box Properties q Object Selector for New Document 1 i a 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 oom In Zoom 7 oom O
162. ta 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 Print Wasp Labeler User Manual Print Tab The Print Tab contains functions relating to printing your labels including Page Layout Print Select First Prev Records Now Print 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 When you first open Wasp Labeler the Design tab is displayed and this is the tab you will probably use the most You can switch to a different tab by clicking on the desired tab label New Label Wasp Labeler File om Glick on a tab cu Undo T ox f to open lt Copy Redo mase Text Paste eS Fllipse Picture TEETER Clipboard Insert 1 4 4 Section D Design Window The Wasp Labeler Design window by default shares space on the Main screen with the Properties box You can Hide the Properties box entirely or you can resize the Design window as needed To resize the window place your mouse over th
163. tailed instructions on using the String Builder screen Formatting The Formatting section on the Properties box gt Data Source 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 1 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 SG WASP Labeler Are you sure that you want to clear current data source Yes No Click Yes to remove the current data source or No to cancel and keep the data source 78 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 gt 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 Increase the bar width applies to the individual bars in the barcode and the density is Bar Width decre
164. te Format Expressions 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 BE WASP Labeler Are you sure that you want to clear current data source i Ta Click Yes to remove the current data source or No to cancel and keep the data source 107 de 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 gt Data Source tab The following screen appears e Date Time settings Es Includes Date Format Time Format Date Time Short Date Medium Time Years Months Days Offset by D os 12 9 2011 10 26 AM Ok me 2 Select what information you want to appear or be encoded in the object from the Includes drop down list Options are Sample Date Time Time Date Date Time 3 Select how you want the date formatted from the Date Format drop down list Options are Short Date 8 31 2011 default Medium Date 31 AUG 2011 Long Date Wednesday August 31 2011 4 Select how you want the time formatted from the Time Format drop down list Options are Short Time 13 18 Medium Time
165. ter concatenating all substrings 1234 of 1234 OK Cancel 9 On the Print tab enter 2 in the Number of Copies gt Manual from User field 36 a 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 Example Label labx Wasp Labeler if ile Design Data Maa WhO S te Example Templates New Open Close Save Save Save Label gt As All Open Close 5 Check for About Update Exit Updates License Help Choose a label Address labx me Pi ACME Supply Company ER VAN 1234 Industrial Bivd Address labx Cleveland OH 44101 Addr emilabx AddrTab labx Mail to pen John Doe ici coe 123 Main Street Coupon labx Metropolis ST 99999 9999 CTIA labx Disks labx Se brrrbberbibiilbirbiibibibil EIAS56A labx EntryFrm labx Addr3 labx HithClub labx Contains an example to address US Mail It demonstrates the use of Postnet bar codes static graphics and the use of SubStrings and External ID Badge labx Data Source files Item Lbllabx 3 Labeler User Manual 2 Scroll through the list of ava
166. ter on certain packaging configurations The separator pattern between the two rows is designed to eliminate cross row scanning errors GS1 Truncated Any member of the GS1 family can be printed as a stand alone linear symbol or as a composite symbol with an accompanying 2D Composite component printed directly above the GS1 linear component GS1 128 Formerly UCC EAN 128 GS1 128 is a Serial Shipping Container Code with a secure bar code symbology It allows all participants in the supply chain to use a common standard solution for their individual tracking and tracing needs The GS1 128 bar code symbology requires Als to define the data architecture Als are prefixes which indicate the meaning and format of the data which follows Among the things they may be used for are item identification measurements quantities traceability dates transaction references and location numbers GS1 128 Example 12 3456789 Interleaved 2 of 5 Interleaved 2 of 5 is a variable length even numbered numeric bar code symbol It is typically used in industrial and master carton labeling The symbology uses bars to represent the first character and the interleaved white spaces to represent the second character Each character has two wide elements and three narrow elements A modulo 10 check character can be used to enhance data security for Interleaved 2 of 5 barcode symbols When this option is selected the last digit of the symbol is assumed to be
167. the Properties box gt Barcode tab 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 This setting determines density of the barcode Increase the bar width applies to the individual bars in the barcode and the density is decreased You might want a more dense barcode to fit on a small label for example Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all This settings stands for character per inch You can add more characters per inch by increasing the number in this field resulting in a more dense barcode Notice that as you increase the number in Char per Inchthe Char per inch field the Bar Width field decreases The more characters you add per inch the more dense your barcode will be Keep in mind that a barcode that is too dense may be harder for a scanner to read and may not be scannable at all Select the Check Digit checkbox to include an optional check digit on your barcode to enhance data security A check digit appears last Check Digit on the barcode and checks for errors in the preceeding content A modulo 10 check digit calculation is always performed on the data string A second modulo 10 check digit is optional and is used to
168. the check digit and it is compared to a calculated check digit to verify the symbol Interleaved 2 of 5 Example No Check Digit 0123456789 44 t 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 An International Standard Book Number consists of 4 or 5 parts e fora 13 digit ISBN a GS1 Code 128 prefix 978 or 979 indicating the industry in this case 978 denotes book publishing the group identifier language sharing country group the publisher code the item number title of the book and a check sum character or a check digit The ISBN separates its parts group publisher title and check digit with either a hyphen or a space Other than the check digit no part of the ISBN will have a fixed number of digits ISBN Example 78123456768697 ITF14 The ITF 14 Traded Unit Case Code is used in the retail sector on outer cases and pallets traded units Based on Interleaved 2 of 5 the 14 digit code is numeric and used to display the unique traded unit number Bearer bars must be included in horizontal form for code
169. the symbol Show in When this option is selected the check digit will appear in the Caption barcode caption 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 were introduced to prevent barcode distortion when Bearer Bars flexible rubber stamps are used to print Interleaved 2 of 5 barcodes onto cardboard boxes Adding lines all around the barcode stamp or just on the top and sides of the stamp was found to provide additional stability so the stamp did not bend as the box was being stamped Bearer Bar Enter the width for the bearer bar s Width 86 Labeler User Manual ISBN Properties Box Options The table below lists the options available for ISBN in the Properties box gt Barcode tab Field Description Select ISBN from the drop down list For a complete list of available Symbology symbologies along with examples and descriptions of each please refer to the topic Barcode Symbology Reference The nominal size for a EAN JAN barcode is 1inch The usual reduced size Is 80 of the nominal size of Nominal Check this box to enter a specific bar height Enter the exact bar height in the field provided ITF 14 Properties Box Options The table below lists the options available for ITF 14 in the Properties box gt Barcode tab Description Se
170. there is a digit in the position where the appears in the format string display it otherwise display nothing in that position This symbol works like the 0 digit placeholder except that Placeholderjleading and trailing zeros aren t displayed if the number has the same or fewer digits than there are characters on 0 45678 either side of the decimal separator in the format 46 00000 012345 Digit Placeholder 1234 5678 HHH 12345 expression The decimal placeholder determines how many digits are displayed to the left and right of the decimal separator If the format expression contains only numbers sign to the 0 45678 0 00 Decimal Biaceholder left of this symbol numbers smaller than 1 begin with a decimal separator If you want a leading zero to always be displayed with fractional numbers use 0 as the first digit placeholder to the left of the decimal separator instead 0 46 0 3697 0 00 The expression is multiplied by 100 The percent character FF 736 97 is inserted in the position where it appears in the format string 0 3697 0 37 0 Percentage Placeholder The thousand separator separates thousands from hundreds within a number that has four or more places to the left of the decimal separator Surround the thousand separator with the digit placeholders 0 or Two adjacent 2147483647 commas or a comma immediately to the left of the decimal
171. this example we are going to create one name badge label containing a standard Code 128 barcode and a text field containing a name and employee ID number Links are provided in each step to detailed information regarding the tabs and screens 1 Open a document Open a New Document and make sure the Design tab is selected 2 Add a barcode Click on the barcode icon and drag it to the Design window arm New Document Wasp Labeler Ai BEE m Cut HaUndo a C Box NNN SlRotate Bring to Front Copy Ba Redo Line Align Ui Send to Back Text icture Paste cD Ellipse betre Barton H Space L Bring Forward Clipboard Insert rrange New Document 1 Drag and drop barcode onto the design area pl You can move the barcode around on your label as needed by clicking on it and dragging it where you want it 14 a 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 SNORE og ie Object List for New Label 1 Barcode 1 Barcode 0 92 0 70 l Content 1273456789 ae Content Source None Bar Width 0 0104000 i
172. u A list of columns in the selected table spreadsheet etc will appear in the bottom preview pane Human Resources Warehouse Sales Information Technology 171 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 List of Links Column Department Code of table employee master list tct is linked to Column Department Cc Darling Doe Cain Sooner 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 gt 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 vile nian Select columns to use on label results SS employee master list txt Employee Last Name E employee master listtxt Employee ID Darling Huma E employee master list txt Department Code E employee master list txt Site E employee master list txt Location Cain Warel E employee master list txt Check Out Privileges Sooner Sales E employee master list txt Additional Info E departments txt Department Code departments txt Department Name employee master list txt Employee First Name employee master listtdt Employee Last Name depar Doe Huma Boomer Sales Marsupial Sales Newman Sales
173. uble character quotation marks Many characters in the format expression have a special meaning and can t be displayed as literal characters unless they are preceded by a backslash The backslash itself isn t displayed Using a backslash is the same as enclosing 987654 the next character in double quotation marks To display a ra backslash use two backslashes VW For example the numeric formatting characters 0 E e comma and period and the string formatting characters amp lt gt ser 1 can t be displayed ABC ee Indicates that the enclosed characters should be copied to the 68 degrees Sane esult string unchanged 68 degrees Defines sections with separate format strings for positive negative and zero numbers A format expression can have from one to four sections separated by semicolons The first section applies to positive values the second to negative values the third to zeros and the fourth to Null values E E e Exponential e Notation Escape Character Section Separator 128 Labeler User Manual String Formatting Character Definition Additional Information and Examples Display a character or a space If there is a character in the string being formatted in Character the position where the appears in the format string display it otherwise display placeholder ja space in that position Placeholders are filled from right to left unless there is an character in
174. ut 100 h eset Zoom 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 To minimize the screen and place it on the taskbar click the minimize icon in the top right of the Main screen as shown below n In Zoom ET ar Tu Labeler will be placed on your taskbar To reopen it click on the icon on your taskbar 1 4 2 Section B Tabs File Tab The File Tab contains save open and close options This tab also allows you to launch example labels and check for updates to your software Click on an icon to access a function Design Tab The Design Tab contains all of the options for customizing your label Click on an icon to access that function The toolbar on this tab is divided into 5 sections Clipboard This section contains basic commands such as Cut Copy Paste Undo and Redo Insert The Insert options allow you to insert text basic shapes a picture or a barcode into your label Arrange The Arrange menu allows for precision placement of objects or text you insert onto your label 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 Da
175. utton to access the Find screen shown below 177 er Labeler User Manual Find Find f OUp 9 Down Match Column To Search C Less Than lt employee master list tx Less Than or Equal lt employee master list b employee master list tx employee master list tx Greater Than or Equal gt employee master listftx y i employee master list tx L Greater Than gt Py G gt employee master list tx O Partial Math string only employee master list tx a a oom gt Soundex string only S Equal 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 2 Print Tab Properties Box Number of Labels The Number of Labels section allows you to select how many unique labels will be printed This should not be confused with copies of labels The Number of Labels section controls the number of physical unique labels you want printed Your options are e One Full Page The number of labels printed using this option will vary depending on the label type you selected on the Page Setup screen For ex
176. wing functions Refresh the Data Edit the Connection Remove Connection Sort the Data Filter the Data Join two or more tables 4 7 Connecting to QuickBooks Note Make sure you have QuickBooks running before connecting 1 On the Data tab click the QuickBooks icon Nasp Data p 148 S 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 Labeler is ready to extract data from Quickbooks Please ensure that the Quickbooks application is installed and is running As soon as you dismiss this window Quickbooks may prompt you with a dialog window that looks similiar to this an Anpfesbar rt rapen amet fhe Haans 1ridnska TL Thim sr aug Arran may Posts radne and ecg skr dlanka als au m ll aa dang Jor Gudok uer bot b r The Anffraba Caa Jha Tr ST ETE gt Meee Capo ain fou det rogucsta d thot Qudksecis ook br fers Co you want 20 slow shee applicato to read and nod fr Jie Er Jow ive diver svar ut ee Cub i m EET fle Pa pole rkan in anne parsuanAl dela she Sond Sey Meher n l aner uelli hemes Tell myr any You may have to select the QuickBooks icon from the Windows taskbar in order for the QuickBooks window to appear E Don t show me this reminder again As indicated in the warning message you may see a QuickBooks message similar to the one shown on th
177. wn 3 Ifyou have your SQL server setup to accept Windows Authentication select the Use Windows Authentication checkbox default If you want to use the SQL Server Authentication enter your User Name and Password in the fields provided You can click the Test Connection button to make sure you are connected to the server 4 A list of available databases appears in the Database field Select a database from the list 145 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 Press the ODBC Configuration button to select your ODBC connection ODBC Configuration Advanced Delimiter Options ODBC Connection 146 i Labeler User Manual 3 Click the ODBC Configuration button to configure the connection The Connection Properties screen appears Connection Properties Microsoft ODBC Data Source ODBC Change Data source specification 4 Use user or system data source name EE Refresh C Use connection string PB Login information Password Advanced Test Connection 4 The installed ODBC driver read from your system will appear in the Data Source field
178. xport Barcode as 0cceseeeeeeees 52 Insert Menu rrarnnnnnnrnnrnanvnnrnernarnernnrnnnnnnnnenne 54 J JOINING Fo gt 168 JPG Export Barcode ag rrranonnnennnrnnnnnvnnnnnnrr 52 K Keyboard Entry SCreen ccccccceseeeeeeeeeees 118 L LADE OS C n EE 51 Label Creating a Static rrrerarernnennnrnnanenr 14 EE NEW sesa 51 Label Open an existing rrrrrrnnrernnrernnrennnre 51 Label SWING uses 51 Label Design Tab cccccccseccseeeeeeeseeeseeeees 54 Label Design Tab Example rrrrnrrnnnernnrnnnnr 54 Label Stock Templates rrrrarernnennnrnnnnennre 187 Labeler Creating New Data Source 155 Labeler New Data Source Creating 155 Labels Examples cccccscccseeceeesseeeeeeenes 37 Labels Printing used 176 Labels Templates cccscccceseceeecseeeeeeenes 37 Layo t OO 110 eourouna ETETEN 54 Layout Templates rrarrnnrnnnrvnrevnrvnnrnnnrnnnnnn 187 Layout Templates Adding rrnnnnnrvnnrnnnnnn 187 Layout Templates Editing errrnnnrnnrernrrnn 187 License Update ranonnnrnnnnrnnnnvnnrnnnrnnnnnnnre 193 Line Adding to a Label rranannnnnnnnnvanrvnnnnnn 59 EA Ille 59 List User Delne sser 113 EAN var 124 M Main Screen Overview rrrrrnnurrrarerarennnrnnnnnn 5 200 EE Labeler User Manual Microsoft Excel Connecting to 005 143 Microsoft SQL Server r
179. yout Print Firs Print Properties Number of Labels One full page 2 x 2 4 label s Specify 4 Number of Copies Manual from User As consecutive labels Dynamic from column in data source J J ane Doe 123456 Starting Label and Order Beginning Label 1 n 2 a 1 17 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 s Page Setup New Label 1 Layout Template Family Custom Type Type A lt Default gt New Copy 5a etete Number of Labels Label Size Across 2 Width Height Space Between Labels Horizontal 0 1 Vertical 0 1 Lock Edits Rounded Borders 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 Let s assume our example company uses a laser printer with Avery name badge labels for the employee badges In this case we should select Avery Laser from the Family drop down and Name Badge from the Type drop down The screen will now look like this oy Page Setup Example Label labx Layout Template Preview Family Avery Laser bl Type 5095 Name Badge x

Wasp WaspLabeler +2D

Contents

Download Pdf Manuals

Related Search

Related Contents