Edit Lookup File Data, Edit Data | Datamax v1.1x guide

Chapter 3 : Creating a Project

3.4.4.Edit Lookup File Data

General introduction	Once a Lookup file is created from scratch or through importation of an
	existing data source, you can edit your Lookup File data. You may
	perform the following on your data records:
	Add
	Insert
	Modify
	Delete

Edit Data	The Lookup File data may be edited at any time—when the file is first
	being created or at a later time whenever changes are required.

In the Lookup Files window,

1Select the Lookup File to be edited

This example edits the Product Description file created in Section 3.4.2

– Add Lookup file from Import File

2Click the Data button

The Lookup File – Data window is displayed as shown below

October 2007

Page 104

www.mcl-collection.com

對	對 Copyright © 2007 • MCL Technologies • All Rights Reserved

Image 104

Datamax v1.1x user manual Edit Lookup File Data, Edit Data, Add Lookup file from Import File

Contents

Print Preface Background Table of Contents 218 220221 222 Primer What is 123 Print General introductionPrint Purpose Sample Labels Sample labels Primer October User Interface Project FlowLabels Labels Project User Interface User input is required on screens at a and B Getting Started Getting Started This section describes how to install 123 Print Is C\123Print Copyright 2007 MCL Technologies All Rights Reserved Copyright 2007 MCL Technologies All Rights Reserved Desktop Once 123 Print is installed, start it byStarting 123 Print Activation Activation Enter the License Number found on your License Certificate Click Next October Agreement Proceeding, you must read and accept these license terms Software versus Copyright 2007 MCL Technologies All Rights Reserved Enter the Password found on your License Certificate Copyright 2007 MCL Technologies All Rights Reserved Cut on the Windows desktop Main 123 Print window is displayed as shown here October Click 123 Print Settings General SetupSetup Setup dialogue box DPL ConnectionDPL Connection Click on the DPL Connection tab MCL Connection MCL ConnectionClick on the MCL Connection tab MCL Connection options screen is displayed as shown here Local Settings Local SettingsClick on the Local Settings tab Local Settings screen is displayed as shown here Getting Started Assign Com 2 Printer Port To Labels. In the Setup window OthersOthers Click the Others tab Copyright 2007 MCL Technologies All Rights Reserved What is called a label program Creating a ProjectCreating a Project Programs for your Datamax printers Project Description On the Project Description screen Click Project Click Project Description Click Project Click User Interface User InterfaceGeneral introduction User Interface Text Display User Interface for a text display printer is as shown here Status Toolbar Welcome Screen Welcome ScreenYou entered in the Project Description in Section Shown here Large Graphical Display ElementsAbout Printer Status see .2 User Interface Graphical Display Status Toolbar Copyright 2007 MCL Technologies All Rights Reserved Copyright 2007 MCL Technologies All Rights Reserved Than those supplied by default by 123 Print Select Label ScreenSelect Label screen Click on the Select Label screen, or Click the Select Copyright 2007 MCL Technologies All Rights Reserved Quantity to Print Screen ScreenClick on the Quantity to Print screen, or Click the Quantity Display Quantity to Print Screen Click on the Select Quantity screen, or Copyright 2007 MCL Technologies All Rights Reserved Print Error Message Screen Appropriate here for your environment Copyright 2007 MCL Technologies All Rights Reserved Creating a Project October As a label program Associate a label Nbr File NameLabel Name Quantity to Static label Dynamic labelƒ See .3.1 Edit ƒ See .3.2 Variables Click the Edit EditEdit Variables Variables Copyright 2007 MCL Technologies All Rights Reserved Procedure is identical for graphical displays ProgramPurchase Text displays are used in the following example. However, Input Methods Copyright 2007 MCL Technologies All Rights Reserved Location Click OK October Copyright 2007 MCL Technologies All Rights Reserved Copyright 2007 MCL Technologies All Rights Reserved Copyright 2007 MCL Technologies All Rights Reserved Copyright 2007 MCL Technologies All Rights Reserved Button at the bottom of the Process list to add a Select A2 Confirmation in the If Value field Set the Condition field to Equal to Set the Then Goto field to Continue Front Panel Up/Dw Numeric Methods are available for your screen prompts External Keyboard Creating a Project Extract To Characters from the inputFor example, if you set Extract From 4 Extract To 6, you will extract 555 out External Barcode Reader ReadUser will not be able to input a value that Does not match the pattern Input from the external barcode reader. Several Weight Scale From the weight scale. The following Be received from the weightValidation Mode Set the mode with which the data Measurements from the weight scale Copyright 2007 MCL Technologies All Rights Reserved Creating a Project Select Value from List List by typing entries directlyList. To select a variable, click Variables Icon beside the table Creating a Project October Select Value from File Example Described aboveThat is used for browsing and searching That entry as the input You need to set up when you select this input type Display Data Mapping Mapping Copyright 2007 MCL Technologies All Rights Reserved Copyright 2007 MCL Technologies All Rights Reserved Copyright 2007 MCL Technologies All Rights Reserved Result Labels Example looks as follows Two different ways-as a list or as thumbnails Labels ListAdded for your label Deleting a label Adding more labelsTo add a new label, simply click on Modify the properties as appropriate Lookup FilesClick Project Click Lookup Files Lookup File Data Lookup Files window Click on the Data ButtonTo delete a Lookup File from your project Select the file you want to delete Add Lookup File Add Lookup fileFile. The file you create is of type *.dat Are saved Copyright 2007 MCL Technologies All Rights Reserved Copyright 2007 MCL Technologies All Rights Reserved Add Lookup File from Scratch Add Lookup File from Import Add Lookup File from Import File Import fileSeveral file types are valid for import Dat, *.txt, *.xls, *.cvs Copyright 2007 MCL Technologies All Rights Reserved Check the checkbox beside First line = Column Title Double Click on the field to be edited 4 Edit Lookup File Data Scratch Add Lookup File from Scratch123 Print, you can create a Lookup File from Scratch Copyright 2007 MCL Technologies All Rights Reserved Save Lookup File To save the Lookup File Creating a Project October Add Lookup file from Import File Edit Lookup File DataEdit Data Columns Right click any of the column headers Add record To add a record Click the Add Insert a record To insert a record Modify a record Delete record Creating a Project October Graphical Display System SetupClick System Setup Copyright 2007 MCL Technologies All Rights Reserved Soft Keys Setup Graphical Display Only Soft Keys SetupClick Project Click System Setup Datamax printer keys Copyright 2007 MCL Technologies All Rights Reserved Copyright 2007 MCL Technologies All Rights Reserved Large Screen Small Screen Auxiliary Communications Connected serially to your Datamax printer Copyright 2007 MCL Technologies All Rights Reserved ƒ Never The input buffer is never cleared October Designing a Label BarTender Integration Run 123 Print Click Save As… Launch BarTenderClick BarTender Label Designing a Label Click on the browse icon Set the Label Properties as per .3- Labels Copyright 2007 MCL Technologies All Rights Reserved Master copy in BarTender’s default label location …\BarTender\Formats as seen in above,Project\Labels Red as shown below Label Graphic Elements Using Processes Using ProcessesThis chapter covers the following topics and processes Introduction to 123 Print Variables 131 Add a process Process window is displayed as shown here Click VariablesClick the arrow Copyright 2007 MCL Technologies All Rights Reserved Introduction to 123 Print Variables Label programsIntroduction to Print variables User local Price LabelAll local For definition as user local variables System GlobalVariables may be used by any label program Branch You can perform in your label programBranch Processes Box to see the list of available branching processes Case and Branch Case and Branch Hardware Following variable contents give the following results Control and BranchVariable against a specific pattern Defined destination-a screen, label or code line What is a label Goto LabelReference Goto Label Goto Screen Goto ScreenAdd the process Goto Screen to your label program Goto Screen dialogue box is displayed Key and Branch Key & Branch process allows you to request a program stopBranch if a time-out occurs without user input Key and Branch Set Label Set Label Test and Branch Test and BranchSelect the comparison criteria String or numeric? Date Operation Date Operation Date Add/Subtract Date Conversion Date Difference File Search File Search Respectively into the variables A4 Product Code, A5 Product Description, and B0 Manufacturer Operation Mathematic OperationMathematic Other Perform in your label programOther Processes Box to see the list of other available processes Delay Delay MCL Code MCL Code Type your comment To insert a comment, proceed as followsAdd the process Note to your label program Print Label Print label Serial Communications That you can perform in your label programSerial communication Communications Checkbox beside Extract from Received Data SerialSerial Abbreviations Serial Out Serial Out Processes on Variables Variables in your label programVariable Processes Box to see the list of available processes for variables Variable Assign Variable Assign This example, the first three variables E0, E1, and E2 are Initialized with the system date, System Variable 73 Date Variable Concatenate Existing variables or constants into a new variableTo concatenate variables, proceed as follows Add the process Variable Concatenate to your label program Variable Extract Variable ExtractVariable Substring process Their contents to variables B1 and B3 respectively Examples Variable FormatVariable Format Copyright 2007 MCL Technologies All Rights Reserved Variable Length Variable Length Beside the Result Variable box Variable PositionVariable Position Variable Search and Replace Replace Variable Substring General introduction Variable Substring Examples Simulating Your Project Simulation Mode Using the simulatorRunning on the printer With a mouse click Click Options Click ExecutionClick the desired option Check the checkbox beside Interactive I/O dialogue box Click Execute Click Scan Input… F12 Click Execution Click Debugger Debugger ModeText Display Printer MCL Code Viewer Using the ViewerMCL Screen View Variable Viewer Local Files Viewer Options Click Execute Click Options Copyright 2007 MCL Technologies All Rights Reserved Large graphical display printer Deploying a Printer Project Deploying a Printer ProjectAffect one printer at a time Available in 123 Print Connect / Disconnect Printer A given printerBefore proceeding with this section Connect Copyright 2007 MCL Technologies All Rights Reserved Printer controls Following sections Disconnect To disconnect 123 Print from your printer Printer Status Information shown on these screensPrinter Status Click on the Printer Status Deploying a Printer Project Activated Deploying a Printer Project October To control a printer, on the 123 Print menu bar Printer ControlFollowing printer controls are available in 123 Print Cancel Printing Control executionFeed Label Pause Printer Load File / Control Load File / Control Load firmware and MCL system menu options Load FirmwareLoad firmware action Copyright 2007 MCL Technologies All Rights Reserved Download Process Load Font Load font actionSelect Load Font Load font options Load Graphic Load graphic actionSelect Load Graphic Load graphic options Copyright 2007 MCL Technologies All Rights Reserved Load Label Load label actionSelect Load Label Load label options Load Lookup Load lookup actionSelect Load Lookup Load lookup options Load Any File Load any file actionSelect Load Any File Load any file options Load Profile Load profile actionSelect Load Profile Load profile options Load MCL-Project ActionSelect Load MCL-Project Load project options Load DPL Control DPL Control action Copyright 2007 MCL Technologies All Rights Reserved Remote printer management using DMXNet Manager Choose the User MCL Agent Command optionMCL Agent Control MCL Agent Control Click Load Project Into your printer using the Load Project functionLoad Project Scripts General introduction Create script Script Actions Script actionsYou want this script to execute. On the Script menu bar Click Add Pause options Described in .4 Load File / ControlPause Script edit action Script BuildingScript add action Select the action you want to delete Script delete actionYou have previously inserted in the script Script Save Script saveClick Save, or Click Save as… At any time. On the Script menu bar Script OpenScript open Script Execution Script execution Downloaded with the project load ProgressIndicating the progress of the script execution Appendix a Sample License Certificate License Certificate Sales Order Appendix B Datamax Printer Setup Go to the Datamax Menu Mode Supports Appendix C Supported Datamax PrintersClass Appendix D System Requirements Appendix E Mapping Label Graphic Elements Replace By 3 Mapping states the followingUnderstanding Restrictions Appendix F Connectivity / Function Matrix = Invalid option System Menu together will not succeed Receive an Operation Failed dialogue box as shown here MCL Technologies US Competence Centre MCL Technologies UK Competence CentreMCL Technologies Ireland Competence Centre MCL Technologies NL Competence Centre