Manualbook Software Barcode Doc - 03 - ENG
Manualbook Software Barcode Doc - 03 - ENG
2
3.4.5 Ellipse Object ........................................................................................... 45
3.5 CREATE PICTURE OBJECT – “MAIN” PAGE.............................................................. 46
3.5.1 How to Create .......................................................................................... 46
3.5.2 Image Source and Size Settings ................................................................. 46
3.6 OBJECT SETTINGS ............................................................................................. 47
3.6.1 General .................................................................................................... 47
3.6.2 Position.................................................................................................... 48
3.6.3 Object Content......................................................................................... 49
3.6.4 Font Settings ............................................................................................ 50
4 DATA SOURCE INTRODUCTION ........................................................................... 51
4.1 DATA LIST ...................................................................................................... 51
4.2 DATA SOURCE (ADVANCED SETTINGS) ................................................................... 53
4.2.1 Arithmetic ................................................................................................ 53
4.2.2 Format ..................................................................................................... 55
4.2.3 Truncation ............................................................................................... 55
5 DATABASE SETTING AND PRINTING..................................................................... 57
5.1 HOW TO USE DATABASE .................................................................................... 57
5.2 DATABASE SETTINGS ......................................................................................... 60
5.2.1 Connect Microsoft Excel File (*.xls, *.xlsx) ................................................. 61
5.2.2 Connect SQL Database.............................................................................. 62
5.2.3 Connect Text File (*.txt, *.dat, *.csv)......................................................... 63
5.3 DATA PRINTING ........................................................................................... 65
6 RULER, LABEL DESIGN AREA, AND STATUS ROW .................................................. 68
6.1 RULER ........................................................................................................... 68
6.2 LABEL DESIGN AREA .......................................................................................... 68
6.3 STATUS ROW .................................................................................................. 69
3
STARTUP
Click WinLabel icon on the desktop to open the program as the Figure 1 below,
click the new label (or browse the file list to open a saved-label file); and then see
the Figure 2, select a printing method (Command Printing or Graphic Printing) and
then click the “Finish” button; enter the Figure 3, set the label size in setup page
and click” OK” to enter the operation menu.
(Figure 1)
(Figure 2)
4
Item Description
Document Properties & Please refer to the description of 3.1.2 Printing Setup
Printer Properties
WLF: Direct Print Normal label design file
WLP: Standalone Standalone file, only support LP423A and LP433A models
Program for standalone operation
Install printer driver Please refer to the description of 6.2 Install Driver
Devices and Printers A shortcut connecting to the Devices and Printers of
Windows dialog
(Figure 3)
5
OPERATING INTERFACE OVERVIEW
I. Start Button, Quick Access Toolbar and Style Setting Toolbar: Listing open/save,
print, and other icons of common commands.
These command icons on the Quick Access Toolbar can be added/decreased by
user’s interest and demand.
Style Setting Toolbar has language and theme settings.
II. Functional Zone: Listing main functions of designing label for user to efficiently
execute functional icons.
III. Label Switching Bar: A number of Label designs is placed on this bar to allow user
to switch labels for editing. The selected label is appeared on the top screen.
IV. Rulers, Label Design area, and Status Row:
Rulers: Having measurement function for user to measure object size. (Click unit
icon at the upper right bar to change different unit)
Label Design area: Editing and composing objects
Status Raw: Provide shortcut functions to set printer property, page/label setup
and cursor coordinates.
V. Data area: Data Source and Object List.
6
1 START Button, QUICK ACCESS Toolbar and Style
Setting
1.1 Start Button
Item Description
New label Open a blank label
Open Open a file dialog to choose the existing file
Save Save the current editing label file
Save as Save the current editing label file and designate
another file name
Export Save file as PDF format or graphic file (supports file suffix:
png、bmp、jpg、gif、tiff)
Print ➢ Preview (refer to 2.1.3Print)
➢ Print Setup: printer and paper setup
About WinLabel version
Close Close the current editing label
Recent Files List recent 10 label files to let user open file quickly
Check for update Version confirmation and update
7
Environment
Settings
User Interface:
➢ Language: English / 中文(简体) / 中文(繁體) /
Español / Türkçe / Tiếng Việt support, select and
effect after restarting the program
➢ Style: Different style of interface for users’
preferences.
Editor:
➢ Right to Left Aligned: Typing from right to left
Format:
➢ Image Format: P64, PNG, PCX
PCX: Recommended for firmware 1.0.66 or less.
P64: Recommended for firmware 1.0.66 or more.
Exit Exit WinLabel program
8
1.2 Quick Access Toolbar
User can adjust common command icons on this toolbar, toolbar position,
Item Description
Language Support simplified Chinese, traditional Chinese,
Spanish, Turkish, Vietnamese, and English. Effect after
restarting the program.
Style Choose theme style with user’s preferences.
Pinter Utility Refer to the 2.4.1 Printer Utility
9
2 FUNCTIONAL ZONE
2.1 Main Page
(Figure 1)
Item Description
Dimension The dimension means each page size (the width setting is from
left- most to right-most). The default setting has two label sizes
(4 x 3 inch and 2 x 1 inch). If needed, user can tick “Self-Defined”
button to set width and height of each page size respectively.
Paper tray Default is “Automatically Select”
Orientation Portrait and Landscape (Rotate 90 degrees), user can also choose
180-degree rotation
1
0
2) Label layout
Set up the size of label design area as Figure 2
(Figure 2)
Item Description
Label Set up each label size that would be also automatically adjusted based on
dimensions the margins settings and row/column quantities.
If size is not compatible, user can set up each label size manually and get
the result in the “Page Preview” area.
Margins Margin distance can be adjustable
➢ Select “Enable Top/Bottom Margin” to arrange the top/bottom
margin.
Layout Set up a number of labels in a page by adjusting row and column
number.
Row/column Set up horizontal and vertical gap distances between labels. Manually
Gaps set up is allowable.
3) Measurement
set up measurement unit and image output format.
11
Item Description
Units Inch (in.), Centimeter (cm), and Millimeter (mm) are selected.
Item Description
Paper/Layout ➢ Name:Choose paper size (4 x 3 inch and 2 x 1 inch); User
can also define each paper size.
➢ Directions: Portrait and landscape (rotate 90
degrees); 180 degrees, rotation is accepted.
12
Settings ➢ Copies:Each page quantity
➢ Speed:Printing speed
➢ Darkness:Adjust Printing darkness status.
Caution: If the value is higher, that would cause the
temperature of print head higher, and would make ribbon
melting and breaking easily. (Suggest value less than 8 for
wax ribbon loading)
➢ Measurement:inch, cm, and mm options
2) Media Settings
Item Description
Mode Thermal Transfer and Direct Thermal.
13
Type Label with gaps:
Continuous:
Printing with Ignoring “Gap” and “Black Line”.
➢ Stop Offset: The paper will be moved a distance after each printing
action stops. (Yet not functional.)
➢ Stop On Last Element: Printing action will stop while printing the
last label, unselect while printing assigned label size. (Yet not
functional.)
14
Sensor Sensor type:
settings
➢ Use Current Printer Setting (default)
➢ Reflective
➢ Transmissive
Start Position Offset: If selected, user can fill up how many dots to
adjust the start printing position. (recommend to input number when
the printing position has a little bit shift up or shift down)
3) Calibration
Please run the sensor calibration after the label material has been changed. If it is the
same material but different size of label, the user will only need to change the “Page
Setting” of WinLabel.
Auto Detection recommend. Select “Manual Set” when there is specific material which
could not be detected. Insert the Sensor Value (default value is 15, the value range is from
5 to 100, less value is more sensitive).
15
4) Options
Item Description
After Print Use Current Printer Settings: Tick this option (default option)
Removing tick option would have below several options
➢ None
Press a button to print: execute the label printing while pressing
the “Feed” button each time.
16
➢ Tear off
The label gap is stopped at the tear off position to let user
easily tear off label.
- Tear Off Position: to adjust the tear off position
- Press a button to print: execute the label printing
while pressing the “Feed” button each time.
➢ Peeler
Peeler module can peel labels continuously while printing. The
printer will run the next label after removing peeled label.
- Peel Off Position: to adjust the peer position
17
➢ Cutter
The cutter will run after printer ends each label printing.
- Every Cut: the amount of label come out to run the
cutter once.
- Cut Position: to adjust the cutting position
- Press a button to print: execute the label printing
while pressing the “Feed” button each time.
User Commands User can fill printer commands in this dialog when there are
specific commands needed. Select and click “…” to insert more
data.
18
5) Tools
Item Description
Print ➢ Generic Test: Order printer to print a label with texts for
testing purpose.
➢ Self Test: Printer will print the inside settings on the label
Action ➢ Reset Printer:Restart printer.
➢ Factory Defaults:Inside parameters to be default
➢ Label Feed:Order printer to deliver a label come out
Send to ➢ Printer Command: send command to the printer.
Printer
➢ File: select the file that needed and send to the printer.
19
6) About:
WinLabel driver version
20
2.1.3 Print
Item Description
Printer ➢ Name: Listing all connecting printer, user can choose proper
printer with corresponding interface port.
➢ Print to file: Save label design to the specified printer file (*.prn)
Quantity Settings:
21
Printing Result:
Quantity Settings:
Printing Result:
Quantity Settings:
Printing Result:
22
Advance ➢ Database:Please refer to the Database printing
➢ Printer settings:Please refer to the Printer Setup
Preview Preview the printing outcome
Print Print label design in the printer
23
2.1.4 Edit
Item Description
Paste Paste the object to the editing area
2.1.5 Format
Item Description
Font ➢ Display selectable fonts, press pull down button to select as
below figure.
24
Display font size, and press pulldown button to modify or
Font size input the font size value.
Bold, Italic, As long as selecting a text object, press these icons can alter the text
Underline, White on appearance directly.
Black, Font Scale
A group of text objects can be altered together.
Font Scale :the text size (up and down) can be expanded.
Otherwise, the text size can be adjusted by fixed length-to-
width ratio.
Text Align The texts in the 1D barcode can be aligned to left side, middle, right
side, and left-right sides. Note: These icons are not supported
general text object.
The text position in The texts in the 1D barcode can be adjusted in the different
the 1D barcode positions (upon barcode, under barcode, hidden texts)
And adjust the gap between barcode and text by press and hold the
orange point.
WinLabel provides some common objects for usage. User may choose
requested objects to design label to meet a variety of applications. The
25
object setting description is in the next Chapter 3for reference.
Item Description
Text ➢ Single Line Text:Set up a text object in a single row
➢ Multi-Line Text:Set up a text object in multiple rows
1D Barcode Set up 1D barcode as Code11, EAN/JAN-8, UPC-A …etc.
2D Barcode Set up 2D barcode as QR code, Data Matrix, Code49 …etc.
GS1 Barcode Developing, not available now
Shape ➢ Line:Use solid line to draw a vertical/horizontal line or a
solid square/rectangular.
➢ Diagonal:Make a line with any angle in three different line
styles (Solid, Dashed, and Dotted); The line thickness is
adjustable.
➢ Box:Make a hollow or solid square/rectangular. The four
corners can be rounded; The line color/style, fill color, and
line thickness can be adjustable.
➢ Ellipse:Make a hollow or solid circle/ellipse. The line
style/thickness can be adjustable.
Pictures A window object is appeared in the design area, then click this
window image to open a sub-dialog for user to insert an image file.
The image size is adjustable.
26
2.2 VIEW
Item Description
Zoom In Zoom-in function for label design area
Snap to Grid The objects can be moved in grid distance in the label design area
Grid The dots appeared in the background of design area for easily
typesetting.
PS: a tick is only appeared in the object that includes variable data
Object list Open/close the right side Object List window in the Data area
Data Source List Open/close the right side Data Source List window in the Data area
27
2.3 ARRANGE
28
2.3.2 Group
Item Description
Group Items Use mouse to enclose multiple objects and then click “Group
Items” icon to group all selected objects. If moving one single
object, the other objects in the same group can be moved
together.
Ungroup Items Cancel “Group Items” command to release each single object
Example:
20
2.3.3 Overlay
After moving texts forward, the user need to enter the objects settings and
then check “Overwrite other objects behind this one” in Position settings.
20
2.3.4 Align
User can apply this function to make more than two objects aligning
together and make more than 3 objects to be placed in the same gaps.
Item Description
20
➢ Space ➢ After selecting a group of objects, press this
down button, the objects can be spacing vertically with
the same gap.
20
2.3.5 Appearance
1) Provide user to set multiple objects having the same dimensions including
height, width or both.
Item Description
Width The width of a group of objects all can be set up the same width
based on the width of selected object.
Height The height of a group of objects all can be set up the same
height based on the height of selected object.
Both The width and height of a group of objects all can be set up the
same dimensions based on the dimensions of selected object.
33
2.3.6 Lock
1) Provide fixed function to the selected object. If user wants object fixed in the design
area, open this Lock function.
2) If the object has been locked, a small lock icon is appeared in the left-top corner of
this object.
3) When a group of objects moving together, the locked object cannot be moved.
34
2.4 TOOLS
2.4.1 Printer Utility
Item Description
Interface Interface port selection: USB, RS232, LPT (Centronics)
port
Printer While printer has been connected with computer, the program can automatically
selection detect printer equipment. Then user can select a printer from a pulldown list.
Port settings Only for RS232, Ethernet interface settings
• RS232: Bits Per Second, Data Bits, Parity Check, Stop Bit, Flow Control (right
figure below)
• Ethernet: Auto Detect / Manual Detect (left figure below)
Download The current printer setting information can be showed in the Printer Summary area.
information
Upload The setting information in the Printer Utility will be uploaded to the printer.
information
35
1) Printer Summary
Printer Printer Summary: Listing printer information
Summary
• Start Calibration
Please run this calibration after the label material has been changed, If it
is the same material but different size of label, the user will only need to
change the “Page Setting” of WinLabel.
• Auto Detection recommend. Select “Manual Set” when there is specific
material which could not be detected. Insert the Sensor Value (default
value is 15, the value range is from 5 to 100, less value is more sensitive).
• Sensor and Paper Size Detection
• Get Label Size: The detecting value of label size will be showed in the
right table
• Get sensor value: The detecting value of sensors will be showed in the
right table
• Cutter Turning Clockwise: Cutter cuts label from up to down (Fully cut)
• Cutter Turning Anti-Clockwise:Cutter cuts from down to up (Not
completely cut-off)
• Restore Factory Defaults: The parameters of printer will be factory
default setting.
• Printer Self Test: Printer will print the inside settings on the label
• Reset Printer:Restart the printer
• Enter DUMP Mode: Entering to the DUMP mode, so printer will printer
the ASCII code of objects on the label
Settings Please refer to the Settings
File Send the selected file from stored spaces to the printer (Ram Disk, Flash Dish,
Management and SD Card) and also can manage these files in these spaces.
Send Send printer’s command to printer, please refer to the Printer Command
command Manual.
Unit- Tools Printing unit: millimeter (mm), centimeter (cm), inch (in.)
page
30
2) Settings
➢ Print Job
Item Description
Printing Speed Select required parameters, the value can be set up depended on
the printer model
Printing Darkness Select required parameters from 0 to 15 (7 is recommended)
Device Selection General, tear-off, peel-off and cutter modes are selectable
Printing Mode Direct Thermal and Thermal Transfer modes are selectable
Cutting Number Input required parameters from 1 to 255.
Cutting Position Offset Input required parameters from -255 to 255.
Cutting Mode Cut each label, Cut after a number of labels printing, Cut after all
labels printing
Cutting Method Full cut and Half cut modes
Feed Position Offset Input required parameters. (If printer is connected cutter/peeler,
(After printing) user may use this offset settings. Otherwise, the default is 0)
Backward Position Input the required parameters (If printer is connected cutter/peeler,
Offset (Before user may use this offset settings. Otherwise, the default is 0)
printing)
Initial Position Input the required parameters
Offset (Before
printing)
Label Direction Label-out from top or Label-out from bottom
Mirror Drawing No effect or mirror reflection (Not available now)
Drawing origin X Input the required parameters (Not available now)
axis offset
Drawing origin Y Input the required parameters (Not available now)
axis offset
➢ Others
Item Description
Characters Character Set: Select required character set
RS-232 Please make sure the listed settings are the same as Port settings
Internet Connection Internet basic setting
Bluetooth The user can insert name and PIN code
➢ System
Item Description
Keyboard Input The default is US Keyboard
country
On-screen display English, traditional Chinese, simplified Chinese, Vietnamese, Italian,
language and Spanish are selectable
LCD Contrast Very Low. Low. Normal, High, Very High
*Only for LP advanced series
Buzzer volume Close, Low, Middle, High
Feed after cover Close, Open
closed
Paper Near End Close, Low, Middle, High
Indicator
Printer Command Printer Emulation:
Auto Detect (Default): auto detect WPL, TSPL, ZPL, EPL, DPL
➢ Time Setup
Item Description
Printer Current Time • Get the timw:to get the current time of the printer
• Set the time of the computer to the printer
• Manual setup:the user can setup the time of the printer
Reset to manufacturer Reset the printer to manufacturer default
default
Undo Reset the numeral to the original numeral, will not affect the setup in
the printer.
30
3) File Management
Item Description
Get the file list To get the file list in C:[RamDisk], D:[FlashDisk] or E:[SDcard]
Format the target disk Initialize the disk
Delete selected file Delete the selected file
Delete all the file Delete all the file in the storage area
Print selected file Print out the selected file.
Send the file to the printer ➢ File path:select the file that needed to upload
➢ File size:shown the size of the file automatically
➢ Storage location:select the storage location C:[RamDisk]、
D:[FlashDisk]、E:[SDcard]
➢ Send to the printer:send the selected file to the assigned storage
area in the printer
30
4) Send Command
Item Description
Edit Zone Edit the command
• Clear the current edit zone:to clear the command in the
current edit zone
• Clear all the edit zone:to clear all the command in the edit
zone
• Paste to the current edit zone:paste the command to the
current edit zone
• Copy the current edit zone:copy the content in the edit zone
• search:search the specific content in the edit zone
• search and replace:replace the searched content
• replace all:replace all the assigned content in the edit zone
Send Send the command to the printer
Send the file Send the file to the printer
Save the file Save the command in the edit zone
Read the file Read the file to the edit zone
30
2.4.2 Printer Installation
The printer supports USB, COM, LPT and TCP/IP connection. For WIFI, Ethernet,
please connect with TCP/IP; for Bluetooth, RS-232, please connect with COM.
Step1
Open WinLabel software and click InstallDriver, the user will see the figure below. Connect
the printer to the computer with USB / RS-232 / LPT cable and press Next.
Step2
Choose the model of the printer and then click “Next”.
30
➢ USB connection: the program will select the port of the printer automatically.
➢ RS-232, LPT connection: please select the correspond COM or LPT.
➢ Ethernet, WIFI and IP Sharer connection: please select “add ICP/IP port”
Use automatically search: It will search the whole printers that connected to the
internet, the program will bring the user to the selected printer IP and the number
of port automatically.
If the user select manual insert, please insert the number of the IP and port
(default: 9100).
30
Step3
If the information is correct, click “Next” to start the installation.
Step4
Installing
30
Step5
“Windows Security”, please select “continue the installation”.
Step6
Installation Finished.
30
3 CREATING AND EDITING OBJECT
3.1 Create Text Object (Single-line / Multi-line text)
3.1.1 How to Create
2) Pull down this option to choose “Single Line Text” or “Multi- Line Text”
3) Put the cursor at the position that needed the object and click.
• The object properties of each text object can be entered via clicking
“Object Setting” at the “MAIN” page.
30
User can use aligned functions (“FORMAT”–“MAIN” page) to adjust the
multi-line texts’ aligned positions, please see the below examples.
30
While selecting 1D barcode object, click the “Object Settings” icon in “MAIN”
page to open a dialog and then select in the left column to enter
1D “Barcode Settings” page. See the below details.
Item Description
Barcode Selected 1D barcode,Code11, Code39, Code93, Code128, CODABAR,
Type EAN/JAN-8, EAN/JAN-13, Interleaved 2 of 5, ITF14, MSI, Telepen, UPC-A,
UPC-E, Post Code, UCC-128
Special There are different settings while selecting different barcode type as
Options following figures.
Code11
Code39
30
Special
Options Code93/Code128
CODABAR
EAN/JAN-8
EAN/JAN-13
31
Interleaved 2 of 5
ITF14
MSI
Telepen
32
UPC-A
UPC-E
Post Code
UCC
33
Options ➢ List allowed data code and date length
description ➢ Data content has inconformity with character code, the program
will delete this character code automatically.
➢ Data content is exceeded the specified barcode length;
the program will delete the exceeded character code.
➢ Data content is less than specified barcode length, the program
will automatically add number “0” until meeting the specified
barcode length.
34
• If the content is not conformed with 2D barcode’s standard, a red
“x” mark is appeared in the center of 2D barcode and this object
will not be printed out.
1) Aztec Code
• Dimensions:Adjust object size
• Input Mode:Choose input data type
• Data Layer:More information is included and the image size is
bigger (Auto option is suggested)
• Error Correction : Provide 10%, 23%, 36% and 50% four options
(Auto option is suggested)
2) Data Matrix
• Dimensions:Adjust object size
• Specification:Only support ECC 200
35
• Row x Column:The capacity of filling character and number, the
details can be reviewed in the “Input Capacity Info”
3) Grid Matrix
• Dimension:Adjust 2D barcode size
• Input model :Select required date type
• Data layer:The more data input and the bigger 2D barcode size
(Auto option is suggested)
• Error correction: Provide 10%, 20%, 30%, 40%, and 50% options
(Auto option is suggested)
36
4) MaxiCode
• Different modes are selectable as below Figures
41
6) PDF417 and Micro PDF417
• Dimension:Adjust 2D barcode size
• Correction Level:Provide 1-8 level option
• Truncated : If ticking this option, barcode size can be truncated a
half of length.
• Under the Micro PDF417 model, the “Correction Level” and
“Truncated” options cannot be selected.
• Columns/Rows:Auto is default, but raw value is adjustable.
42
3.4 Create Shape object – “MAIN” page
3.4.1 How to Create
1) Click the icon from the “Create Object” toolbar (“Main” page)
2) Pull down a list to select Line, Diagonal, Box, and Ellipse options.
3) Drag the shape at the edit zone.
3.4.2 Line Object
• Solid lines: Vertical or horizontal line, and solid square or rectangle
shape is possible.
• Using mouse to draw eight green points rounded the object to
adjust size. Or input dimensional values in the “Object Settings”
dialog to adjust size.
• It will be output as a command while printing to keep the quantity
of data lower.
43
values in the “Object Settings” to adjust size
• Shape settings: Size, Line color, Line style and Line thickness
• Diagonal object is sent to printer in graphic mode, the data volume
is bigger than sending in command mode.
• The line color is selectable but non-black color line is printed out in
vague black dot style.
44
3.4.5 Ellipse Object
• Solid or hollow circle/ellipse, the drawing line can be solid, dashed,
dotted styles.
• Moving cursor to draw eight green points to adjust the object size
or inputting dimensional value in “Object Settings” dialog.
• The ellipse size, line color, line style, and line thickness are
selectable.
• Line color and Line style (solid, dashed, dotted) are selectable but
non-black line is printed out in vague black dot style.
• Fill color: fill specified color in the inside object
• Border thickness: input value to adjust line thickness
45
3.5 Create Picture Object – “MAIN” page
3.5.1 How to Create
1) Click icon in the “Create object” toolbar to create a picture object.
2) Put the cursor at the position that needed the object and click.
• The size of the object can be adjusted by drawing eight dots
rounded the object border.
• Image file supports following formats as BMP, DIB, GIF, ICO, JIF,
JPEG, JPG, PCX, PNG, TIF, and TIFF。
• There are three ways (embedded, linking, content) to insert
image in the label design area.
Item Description
•
•
Embedded The file is stored in the label file
Linking• The image is not stored in the label file so when
• opening this label design, the image needs to be
• existed in the same folder together.
Content The file can insert many images
This “General” dialog shows the general information of this object, such as
object name, comments for this object, and option for “Do not print this object”.
Item Description
Object Name Object name is unique and it cannot be repeated with any object
name.
Do Not Print This If ticking this option, this object will not be printed on the label.
Object
Comments for User can input relevant information for future reference.
This Object
47
3.6.2 Position
The “Position” page includes object coordinates, rotation option, and protection
function, please see the below description.
Item Description
Position ➢ While object is selected, a blue dot showed in the top left
corner in the object border.
➢ The coordinates status of this blue dot is showed in this area.
Rotation The angle of selected object is adjustable (0, 90, 180, 270 degrees)
Protection The object cannot be moved in the design area under this option.
48
Overwrite other The other objects behind will be covered under this option.
objects behind
this one
2) Variable Data
User can select different data sources to build different text string
combinations. This option can support words, articles, 1D barcode, and 2D
barcode objects. Please refer to Data Source Introduction
49
3.6.4 Font Settings
User can select font style, typeface, font size and text-effects options in this page.
• Provide strikeout, underline, white on black, scale options to
adjust text-effects.
• While undo the “Scale” option, user can fill up the required
value to adjust font’s width.
• Wincode’s Fonts are not supported strikeout, underline, and
font color functions.
• Font Preview: font style preview.
50
4 Data Source Introduction
2) Keyboard Input: A keyboard input field that user can input text while
printer is connected with keyboard.
3) Serialization: A continuous number is increasing/decreasing when printing
continuous labels.
4) Date: Input a Date field; Date can be showed in the different styles.
5) Time: Input a Time field; Time can be showed in the different styles.
• The user can also adjust variable item order or delete item by clicking
rightmost side icons.
• Press “OK” to leave the dialog, the object is showed in the Label Design
area as below.
52
4.2 Data Source (Advanced Settings)
The default is “Close”. If user wants to open this option, click “Creat a Data
Source”, select any item in the Data List and then click “Advanced Settings”
button to enter the setting dialog that would shown Truncation, Arithmetic,
and Validation functions. Also the user may click “Modify Advanced”
button from the main dialog. Please see the description below:
4.2.1 Arithmetic
Set 3 groups of fixed text at the data source area and then adjust them as 3
groups of numbers as the figure below:
Item Description
Rounding Floating Digits: if choose 4, the number will show the
four digit decimal places.
53
Position: choose the number position for carrying digit. 0
means unit digit
1 means ten digit
-1 means one decimal place
Replace Digital The original data in the item to be replaced with filled
(Order: 0~9) symbols, numbers or letters.
e.g. Replace object 1 as below:
54
4.2.2 Format
Item Description
Validation Ex: 0.0, 0.00, #.#, #.##, #.#0, #.##0, $#.##0
0: digit reserved position. If input 8.9, the custom format is 0.00, and
the showed value is 8.90.
#: digit reserved position. The same rule is as format 0, but the input
number is less than the number of format #, the value will not show
the extra 0. For example: input 8.9, the custom format is #.##, and the
value result is 8.9.
To Upper Case To convert original English lower case letters to upper case.
To Lower Case To convert original English upper case to the lower case.
4.2.3 Truncation
Item Description and Example
Discard Text from The original text is” ABCDE12345”
Left Discard 3 characters from the left side of text.
The result is” DE12345”
55
Fetch Substring from The original text is ”ABCDE12345”
Left Get a substring from the left side of text: the value is 2;
Character length is 3;
The result is “BCD”
Remove Decimal The original text is” ABCDE.12345” If selected, the result is
Symbol “ABCED12345”
Trim Spaces from The original text is ” ABCDE12345”. If selected, the result
Left is ”ABCDE12345”.
Trim Spaces from The original text is ”ABCDE12345 ”. If selected, the result
Right is ”ABCDE12345”.
Trim “0” from Left The original text is ”0000ABCDE12345”. If selected, the result is
“ABCDE12345”.
Remove “CR/LF” Remove the line break and line feed symbols from the “Multi
line Text” object.
Get Specified Field The original text is “Product name: beef Product,
number:1234”.
Get Specified Field :the value is” Product number:”
The result is “1234”.
56
5 DATABASE SETTING AND PRINTING
5.1 How to Use Database
1) Click the “Database Setup” icon from the “DATABASE” page to open a
Database Overview dialog. Then click the “Add Database” button to open a
sub dialog “Database Type”.
57
• Linked Objects:Show all linked objects, and all linked items
• Table Content: To find the relevant key word string from the
database via “Find Record” button.
4) Create a Text or Barcode object and then enter setting, set the Variable Data
source as “Database Field” to start the database function.
58
5) After setting, the hint text will show on the screen.
59
5.2 Database Settings
When open “Database Setup” dialog, and click “Add Database” button,
there are three columns named “Connect natively (No Engine needed)”,
“Connect via OLE DB” and “Connect via OBDC”. The “Connect natively (No
Engine needed)” mode is suggested to connect database.
If use “OLE DB” mode and it cannot be connected database successfully, user
can choose “OBDC” mode as alternative.
The following is to describe how to connect with different types of
database. (Note: if user cannot connect with database successfully, please
download and install the OLE DB Support Suit file from the CD disc or our
website: [Link])
60
5.2.1 Connect Microsoft Excel File (*.xls, *.xlsx)
1) Choose “Microsoft Excel” and then browse file list to choose the
specified Excel file.
2) Then a table will show all pages of this Excel file in the “Available Tables”
field, user can add/delete requested page into the right “Selected
Tables” field.
PS: The Microsoft Access and dBase database connections are the same
way with Microsoft Excel connection.
61
5.2.2 Connect SQL Database
1) Before connecting SQL server, the operated platform has to be
installed SQL Express or SQL Server Management Studio Express.
2) Click “Microsoft SQL Server” from the “Database Type” dialog.
3) Input the name of SQL Server and login information, and press “Get
Database List” to obtain a database list from the server, then decide
the target database.
4) The next dialog lists available tables, and then select requested tables
into right “Selected Table” to finish setting.
62
5.2.3 Connect Text File (*.txt, *.dat, *.csv)
1) Click “Text file” in the “Database Type” dialog.
2) Press button to select (*.txt, *.dat, *.csv) files and choose
corresponding character code, then press “Next” button to the next
dialog.
3) This dialog lists the content of this table, the column in the table can
be decided by placing symbol (semicolon, comma, space) or self-
defined character to separate different columns in the Text file.
The column separation type is listed as Figure below. User can choose
the corresponding symbol to separate data listing in the different
columns. (PS: The data in the Text file was separated by the same symbol)
63
4) User can choose “Other” option to define separated character, and
fill the specified character in the “Other” field (PS: The data in the
Text file was separated by the same defined character)
64
5.3 DATA PRINTING
1) If any object connects with database, there is a Database setting area in the
“Print” dialog for user’s option.
2) Select Ref. Database: Provide user to select database type and table.
65
3) Copy mode
• Unified copies: Print out the same amount of all the records from
“Selected Records”, the amount can be set at “Page Copies” at the left
• Copy field: Add a record from the “Select Record”, can print out
different amounts of label
66
4) Please click to enter the Figure below, set the printing
amount at “Copy” column and it will be shown at “Selected Records”.
5) Selected Records: User can input printing commands to set the selected
records. (Printing command introduction: 1,5,8,10 (individual selection); 18-
20 (part selection); 18,19,20 (specified selection); 30… (after 30th selection,
including 30).
6) Click “First Only” or “All records” buttons to print the first label or all labels.
67
6 RULER, LABEL DESIGN AREA, AND STATUS ROW
6.1 Ruler
WinLabel provides ruler in three dimensional standards (inch, centimeter,
millimeter) to let user measure object in the Label Design area conveniently.
Click the top right side of horizontal ruler to switch measurement unit. The
default is inch.
• Centimeter
• Millimeter
• Inch
• Nothing is selected
coordinates
57