TFORMer Designer
Contents
1. A IrOrMer Matl ngrlowerFowerxmal 5 oa X 3 File Edit Insert Layout Data Tools View Window Help ellx O64 Mace sualx o e 0 eat eS EEE Be z Arial je ie z u F 72 a a m v ifBasis TCode128 Repository Design a x Bt Berge GGFR g 190147112113 14445 1G 1718119 120 Bt 122123 12h 125 1261 DF 1 DG 1291901911392 199194 13513613 Page as Page a gt Shed Demos tr C ProgramData TEC IT TFORMe Tray Mappings U Datasources ea Global Datafields a Projects EmptyProject IE IndustryTemplates gt TFORMer_Runtime_Examples 2 49 Datasources O New_Datasource ca Datafields 5 A Forms 2 BarcodeLabels BusinessCard_Fixed 2 BusinessCard_Multi 2 MailingCoupon MailingFlowerPower ProductCatalogue SerialNumber ne Posen Tau aan ene Sia OG Bie ties sen 123 Main Street t YG ai aat sios Gos N Nowhere PA 12334 gt 0 o o ooo Pie eS scouuoom BOOORE mis 3 Detail Detail Station Name Tere i i i E LN EM RE ss Be pl city Were moved ites your area i Be EROAA Birthday Thark You or Omnia Flower Pawer offers the perfect gift T forevery occasion We pride ourselves on having the freshest highest quality and best selection of flowers at 12 locations in the Nowhere metropolitan area And now we are amp bring2. u BEREITET I se gt AA 4 l Ta j 7 ze 3 Font Arial 12pt Auto Font Size False u Auto Font SizeM 50 Auto Font Size M 200 F 5E Fore Color F Fill Color No Color je Line Color C Nole Line Width 0 100 mm si Text Text with embedded Expressions and Datafields IO TT t 41H gt Layout Data A Preview Ready Ti 7 20 36 30 mm iD 30 00 x 10 00 mm A 200 Figure 31 Insert a Static Text and a Datafield In the layout toolbar select the text symbol and click on the desired position on the detail band A text element will be inserted and the Edit Text dialog is opened The content of the text field is a combination of a fixed text and the actual value of the serial number The fixed text Serial can be entered directly in The datafield SerialNumber is inserted via the setata menu of the dialog After selecting the entry Datafield the dialog Select Datafield opens Double click the datafield SerialNumber to insert it directly into the text The resulting text is now Serial SerialNumber Close the Edit Text dialog with OK gt TFORMer displays expressions or single datafields which are embedded into text or bar code element with surrounding square brackets or angle brackets lt gt Angle brackets are used for interpreting the result of an expression as HTML 7 2 3 3 Format the Text Element The newly inserted text
3. Detail Band The detail band is used for the body of the letter It contains some customer specific fields like the salutation or the address of the customer In addition the current date will be printed automatically Page Footer Besides the static data like the greeting formula and the image for the signature the page footer also contains a bar code which encodes the customer number Page 10 of 36 This conceptual partitioning of the letter is not a must there are also other possible solutions You might as well use one detail band which contains allthe required elements In such a case no page header and no page footer are required TFORMer supports different types of printing areas called bands Bands divide a layout into logical areas Depending on the type of a band TFORMer maintains its occurrence and position in the output automatically E g Page footers are always printed at the bottom of a page Beside detail bands which are usually used to print the body of the document TFORMer supports report headers and report footers page headers and page footers group headers and group footers The layout which is used in this tutorial is the MailingFlowerPower example which can be found in our demo repository For details on how to open this example see section 5 4 5 1 2 Data to be used in the Serial Letter In this example we assume that a worksheet with customer specific data is maintained in Microsoft
4. in group Automotive VDA and click Finish Fl TFORMer VDA_4902_EN fee a File Edit Insert Layout Data Tools View _Window Help amp xX o0se4Waonelsna x ea ee Hu sanere unlimeme Br U Fr lars mr sS 0 0 len 12 0 13 a lge DD 1 20 a Repostory Design ag F 8 Detail Detail 7 g a TFORMeri m 1 Consignee full addr 2 Unloading point Warehouse Usage Code a tiy ae i ca Datafields gt epee Consignees aB Tray Mappings E Consignee2 Consigneed a Layers E Consignee3 Bands CJ 3 ee Note No N i 4 Consignor ship from AdviceNoteNo Consignor 5 N et weight 5 Gross weight 7 Number of packages 2 I NetWeiah GrossWeig Numberc u Lena D N AdviceNoteNo Part number Pay PartNumberCustomer le Quantity packa ge Q a 10 Part Description SET PartDescription 2 Print Order Across then Down v Pa rt N u m be rS u pp li le r Orientation Printer Default Corsign or not ConsignorNo Datasource Edit manually default 1 I I B 13 Date prod shipment expiny 14 Engineering Revision f Date EngineeringRevisior P BUBBE EDO Properties ax zA TFORMer1 Properties m Bl AES TSR SE EGS Eo IE C15 Label Serial No 5 No B Batch tchN al 17 Consignor _ Warenanhaenger VDA 4202 Version 4 Print
5. Excel In order to use this data in TFORMer the excel spreadsheet is saved as CSV file file with comma separated values This file format can be exported in Microsoft Excel and it can be imported in TFORMer In this example we use the file SerialLetterData csv as included in TFORMer see also section 5 2 4 1 The following datafields are available in the CSV file City CustNr DateValid Name Salutation Salutation Mr Mrs ZIP Code Table 1 Column Names in the CSV File Content of the CSV file Address Salutation YCity YCustNre Y Dateyalicd Name YZip Mean Street 6 Mer Nowhere HS12346 12 31 2006 Jephen Stobs 12334 Sice streer 7 VMrs Y Nowhere Hoeo432h 2 37 2006 Tus Nelda Iz334 Some Street 5 Mes Nowhere 8033423 12 31 2006 Silent boo 12334 Down Street 1 YMre Nowhere JMily 34 12 31 2006 Je Me Hendrix 219233418 her Street i Mire somewhere YGBL234W 12 31 2006 Gill Bares 12334 W VStar Street 10 Mr YElsewhere VLT4321 12 31 2006 Tinus Lor yalds 12335 5 2 Create the Serial Letter 5 2 1 Start TFORMer Designer See section 4 1 5 2 2 Create the Basic Layout Create a new layout Therefore press Cir N or use the menu File New Form Page 11 of 36 In the appearing dialog you can choose between creating a new report a new label or using one of the pre designed layouts Template Wh
6. 7 3 6 Ready To Use Example The finished example can be opened after the installation of TFORMer Designer with the following steps Start All Programs TEC IT TFORMer 6 0 Examples QuickPrint Serial Numbers Page 35 of 36 8 Contact and Support Information 8 1 Free Support If you have any questions please contact us Email support tec it com Web http www tec it com support Don t hesitate to tell us your feedback If the product does not fulfill your requirements please tell us why We are highly interested in meeting the requirements of our customers 8 2 How to Unlock the Demo Version You can unlock the demo version with a license key License keys can be obtained from TEC IT by Email online order form or FAX Email sales tec it com Online http www tec it com order Fax 43 0 7252 72 720 77 8 3 Company Contact Information TEC IT Datenverarbeitung GmbH Address Wagnerstr 6 AT 4400 Steyr Austria Europe Phone 43 0 7252 72720 Fax 43 0 7252 72720 77 Email support tec it com Web http www tec it com AIX is a registered trademark of IBM Corporation HTML DHTML XML XHTML are trademarks or registered trademarks of W3C World Wide Web Consortium Laboratory for Computer Science NE43 358 Massachusetts Institute of Technology 545 Technology Square Cambridge MA 02139 JAVA is a registered trademark of Sun Microsystems Inc 901 San Antonio Road Palo Alto CA 94303
7. Datasources Flower Power ea Ae er B Edit manually default Nowhere PA 12334 Global Datafields a6 Projects a EmptyProject IndustryTemplates TFORMer_Runtime_Examples Slutation Name ie 372 el 2 2 2 2 TustNi 4 iy Datasources Address 2 ea Salas SO See ae a DR Datafields cg Ben aa S Foms in wane Gee N F E BarcodeLabels B BusinessCard_Fixed BusinessCard_Multi n i i MailingCoupon Be it Romance Birthday Thark You or Sympathy Flower Power offers the perfect gift e MAN MailingFlowerPower forevery occasion We pride ourselves on having the freshest highest quality and best y3 ProductCatalogue 3 selection of flowers at 12 locations in the Nowhere metropolitan area And now we are r bringing our friendly service and great selection to your neighborhood 2 une SerialNumber iD ee B00DB I TE en A A B B 2 lal isd a x And that s not all Flower Power abo offers worldwide fliwers by wire service with easy Se Maili FI P P i i and convenient ordering we can get you what you want where and when you want it Ay alingriowerr ower roperties Over 1000 different flower arid plant atrange ments are available online for quick ints Modify the properties of the Element delivery Flower Power stores are open daily from 1000 a m to 8 00 p m All major credit cards F jaosaptad EONCOR NEE peaking Sa ataco
8. Position All Name Page Header Printing Condition Tray 0 Default Pre Evaluation Empty PostEvaluation Empty Type Page Heade Output Area Page Comment Name Name ofthe Band poeme 1 Be 1 he Foe Bee 1 De Foe Be 1 a Tie 14 m DORBE Layout Data N Preview F 4 Ready 0 00 0 00 mm E 159 17 x 10 00 mm a 100 Figure 10 Empty Report for the Serial Letter 5 2 3 Define Datafields Placeholders for Dynamic Data Before we can continue with the design work we must define datafields for the serial letter e g the name of the customer or the customer number Datafield definitions may be created automatically or they may be created manually Here we will use the automatic generation of datafields This method uses the columns names contained in the CSV file and creates equally named datafields Therefore we first have to specify the datasource So TFORMer can read all column names of this datasource and create datafields for each of the columns automatically For detailed information see sections 5 2 4 and 5 2 4 2 Information on how to create datafields manually please refer to section 5 2 5 if required Please note A datafield is a placeholder for dynamic data When printing a layout TFORMer updates the values of datafields with the values provided by a datasource or by the user A datafield may be used in layouts in different ways
9. band A bar code will be inserted and the Expression Builder for the bar code data is opened automatically As bar code data the value of the datafield SerialNumber should be used Therefore double click the datafield SerialNumber It will be inserted in the edit area Then press OK O Tip In order to provide a fixed number of digits in the serial number add leading zeros you can use the Format function For example if you want to receive six digits use the expression Format SerialNumber 000000 In the property window you can adjust all barcode properties e g barcode type color Page 30 of 36 7 2 3 2 Insert the Text Element gt M TEORMer SerialNumbers_1 tff ler A Eile Edit Insert Layout Data Tools View Window Help E a x Deu Bzae lsaa lx s oe Ra esther aR here the ame Atial 12 Bru Frs Aryo vlv amp Base Code128 mo era 89 8 295 8 EN ESSEN ESEHRFEHSESZEEZZSZEIE Repository Design ie mG 53 Detail Detail E l a i a SerialNumber m fe Edit Text o bojem 9 meroma wa ees Essa a E P ln lt lt te i Serial if Expression 1 I Dataf RO gt ke Datafield A al alki SerialNumber 8 112 e ka Il Select Datafield ld 31 kd Expression Description J lt New Datafield gt lt New Datafield gt
10. lt New Dataftel Name list ses Common asvencea watema 2l Print Order Across then Down v Description Orientation Printer Default Datasource Edit manually def PFIFRIPIFFRFRPF ee e HF Lee a B Si amp E Gi B a B a Print Order Specifies in which way TFORMer fills the Record 4a 6 WI von 10 physical page with labels or logical pages la rn Layout Data Preview Ready 0 00 0 00 mm 191 00 x 71 00 mm A 100 Figure 11 Create a new Datasource In our example we want to use the CSV file SerialLetterData csv as datasource Therefore select Flat Text File CSV TSV as datasource type in In enter an appropriate name for the datasource e g SerialLetter_CSV Then confirm with OK The Edit Datasource dialog will appear 5 2 4 1 Specify CSV File In the File tab you have to specify the name and the location of the CSV file CeAit Carisll atta OT EIT s rlaliLett r Us RE Ser ee hal File Field Bindings Text Datasource CSV TSY Please select an existing file If required the file name can be adapted with Expressions and Source Parameters The field separator character as well as the text qualifier can also be set File C ProgramData TEC IT TFORMer6 0 Examples Command Line SerialLetterPDF SerialLetterData csv ecw Field separator Text qualifier A Comma 2 xij v Pa lin
11. CustNr 4711 DateValid 31 12 2007 Name Harry Backoffice O Salutation Mr Zip 4400 Copies ei l Ui j Figure 23 TFORMer QuickPrint Tool The button Common is used to configure serial number printing More details regarding this functionality are available in the TFORMer QuickPrint manual The button Form is used to select the layout to be printed TFORMer offers two different possibilities for organizing layouts Stand alone layouts Per default TFORMer Designer creates layouts which may be used on its own These layouts are stored with the file extension tff Repository based layouts A repository is used for organizing multiple layouts within a structured database A repository is stored on the file system with the file extension tfr When using a stand alone layout just select the appropriate filename in For repository based layouts enter the filename of the repository the project and the name of the layout The button Output is used to select the required printer or output format Table style switches between the default input dialog and a table style input dialog Enter data values in the area and start printing with Print In a preview of the selected layout MailingFlowerPower example is displayed Page 24 of 36 7 Print Bar Code Labels with Serial Numbers This chapter describes how to print bar code labels with serial numbers In contrast to a report see chapter
12. Line Style Radius 0 000 mm Fill Color Fill Color Most Elements support the selection of 14 In j special fill patterns 4 DI Layout Data Preview Ready 2 0 10 0 01 mm ES 53 45 x 50 80 mm A 200 Figure 33 The Resulting Layout 7 2 5 The Print Preview The print preview is opened by pressing the keyboard shortcut Ctr Space or by clicking on the symbol amp in the toolbar TFORMer Designer shows the following output The bar codes are marked with crosses indicating that no data was encoded This is because the datafield SerialNumber is not provided with any data yet Page 32 of 36 Figure 34 Print Preview with Empty Datafield 7 3 Printing Serial Numbers with TFORMer QuickPrint The simplest way to print serial numbers is to use TFORMer QuickPrint TFORMer QuickPrint is able to maintain a pool of serial numbers This even works if multiple users are printing the same layout and are therefore using the same serial numbers TFORMer QuickPrint takes care that serial numbers are always unique For this purpose a simple configuration file must be created This configuration file holds the names of the datafields which should be used as serial numbers 7 3 1 Create a Serial Number Configuration File The configuration file must be named QuickPrint xml It is structured as follows lt xml version 1 0 standalone yes gt OO lt SerialNumber current 1000 stepSize 1 gt lt T
13. No Datafields assigned Double click to edit gt om Date alid lt No Datafields assigne Create Field Bindings automatically SE ow Datafield Name lt No Datafields assiqne Zip lt No Datafields assiqne Field Bindings are missing No field bindings are specified Please adjust the datasource a Show Advanced Options OK i Apply Figure 13 Bind Datafields Automatically Currently no datafields are available only sourcefields So we have to create datafields and bind them to the sourcefields Page 16 of 36 In list you see all sourcefields which are available in the CSV file To create a datafield for each of these sourcefields automatically click on the Auto button TFORMer will prompt you if you want to bind them to datafields automatically see Confirm this dialog with Yes However currently there are no datafields available yet Therefore in the next dialog press Yes to Allto instruct TFORMer to create new datafields for all existing sourcefields As result for each sourcefield in list an equally named datafield is assigned In the Preview tab you can check the bindings If all sourcefields were bound correctly you should see the screenshot below Edit Serial Letter File Field Bindings Preview gt SEN lo beea Preview of the current results The preview shows the values of the actual Datasource including optional computed fields in consid
14. Order f _ Specifies in which way TFORMer fills the tz Wh physical page with labels or logical pages 44 rn Layout Data A Preview Ready 2 5 00 32 00 mm E 96 00 x 13 00 mm A 100 Figure 3 Layout View The VDA 4902 form is now displayed in the layout view You can adapt the layout to your requirements Variable fields in the layout e g the customer spe cific part number are provided via datafields e g PartNumberCustomer Page 7 of 36 Datafields are place holders for dynamic data Dynamic data is usually provided by external applications by external datasources or by the user The content of datafields is provided as described below 4 3 Provide Data Dynamic data is used as content for datafields TFORMer Designer offers multiple ways to provide the dynamic data used in the layout It may be entered manually by the user for test purposes or it may be imported from external datasources ODBC CSV XML To edit the data click on the Data tab at the bottom of the window or use the menu Data Data View In this example we assume that the data should be entered manually Therefore the Manual Datasource is used 4 3 1 Select the Manual Datasource For editing the data manually in the entry Edit manually default must be selected see Figure 4 below 4 3 2 Enter Datafield Values This template already contains one record with test data see line One record provides the dynamic
15. USA JAVASCRIPT is a registered trademark of Sun Microsystems Inc used under license for technology invented and implemented by Netscape Microsoft Windows Microsoft Word Microsoft Excel are registered trademarks of Microsoft Corporation Navision is a registered trademark of Microsoft Business Solutions ApS in the United States and or other countries Oracle is a registered trademark of Oracle Corporation PCL is a registered trademark of the Hewlett Packard Company PostScript is a registered trademark of Adobe Systems Inc SAP SAP Logo R 2 R 3 ABAP SAPscript are trademarks or registered trademarks of SAP AG in Germany and in several other countries All other products mentioned are trademarks or registered trademarks of their respective companies If any trademark on our web site or in this document is not marked as trademark or registered trademark we ask you to send us a short message mailto office tec it com Page 36 of 36
16. and great selection to your neighborhood Our new location is at 456 Cherry Lane in charming Nowhere Please visit us at our Grand Opening on August 16 2006 Come and see our great selection of specialty and seasonal arrangements along with standard fresh flower bouquets gourmet gift baskets and more If you re looking for a specially arranged floral gift for that certain someone this is a great place As a token of our appreciation you ll receive a special gift just for stopping by And that s not all Flower Power also offers worldwide flowers by wire service with easy and convenient ordering we can get you what you want where and when you want it Over 1 000 different flower and plant arrangements are available online for quick delivery Flower Power stores are open daily from 10 00 a m to 8 00 p m All major credit cards accepted Convenient parking Your satisfaction guaranteed Look forward to seeing you at the Grand Opening Cordially Martin Myers Valid until 12 31 2007 Figure 21 Serial Letter PDF Output 5 4 Ready To Use Example The finished example can be opened with the TFORMer 6 0 Examples Demo Repository Flower Power 123 Main Street Nowhere PA 12334 E Mrs Tus Nelda HS654321 Side Street 7 12334 Nowhere 08 11 2007 Dear Mrs Tus Nelda We ve moved to your area Be it Romance Birthday Thank You or Sympathy Flower Power offers the perfect gift for every occas
17. checked The preview allows you to check if the data from the source file is read correctly If no columns are recognized or if any data is shifted to a wrong column the parameters to were not ad justed correctly 5 2 4 2 Specify Field Bindings In the next tab Field Bindings you provide the basis that the data from the source file can be used in the layout In this step you associate all required sourcefields of the external datasource with datafields Only datafields can be used as placeholders within text boxes barcodes images etc Sourcefields are not directly available in the layout Here you set the bindings for all datafields If you do not have created any datafields yet you have the possibility to create them in this dialog automatically Edit SerialLetter_CSV o Ferm Field Bindings Preview General Sourcefield for number of copies Escape sequences in xA3 lt None gt X Translate Escape Sequences Field Bindings Assign the fields available in the Datasource Sourcefields to the Datafields placeholders in the Layout Usually each Datafield is assigned to a Sourcefield Sourcefields Bound Datafields Edit Address lt No Datafields assigned Double click to edit gt 3 Delete Salutation lt No Datafields assigned Double click to edit gt City lt No Datafields assigned Double click to edit gt amp Auto CustNr lt
18. data which is used for printing one VDA 4902 label Datasource Edit manually default 1 v Edit Parameter Reload Filter New Datafield Copies Consigneel NumberOfPackages PartNumberCustomer Quantity QuantityUnit 111 BAYERISCHE MOTORENWERKE AG 2250 0 166 496 10340 Q AUTOMOTIVE SUPPLIER AG 2250 0 166 496 24 ST _ Figure 4 Edit Data Manually For the manual datasource each record can be edited directly To assign a new value to a data field first mark the cell with the mouse see Then type in the required value If you want to change an existing value double click on the cell or press the F2 key The cursor can now be positioned inside the cell To confirm your input press the Enter key Alternatively you can also confirm with Tab and therewith jump to the next cell lf you want to enter data for another label insert a new record in the grid Therefore place the mouse in any cell within the last row which is marked with a and enter the required data If all datafields contain the required values you can continue with printing 4 4 Preview or Print the Form TFORMer uses the term Printing when generating output of any kind In addition to direct printing on a physical printer TFORMer also support the generation of HTML Images PostScript ZPL Il code for ZEBRA printers and even PDF output without the need for any additional software like a PDF printer Open the d
19. goarantea di Description Mail merge letter with bitmaps gt Comment E D Page Footer aT Footer Cordially oH Mannes i Coupon ar Here PERS 2 lh pias avaa ee Description A simple description Only for documentation r purposes I E A Ep gt i T Layout Data Preview age x 0 00 0 00 mm if 199 50 x 266 44 mm Figure 22 Open the Serial Letter In the tree view open the layout MailingFlowerPower located in Projects gt TFORMer Runtime_Ex amples by expanding the tree and by double clicking item Page 23 of 36 6 Quick Print Existing Layouts TFORMer comes with a tool which is named TFORMer QuickPrint This tool allows you to select a layout and to print it on any supported output device Besides simple output functionality it also offers network wide serial number support Start TFORMer QuickPrint with Start gt All Programs TEC IT TFORMer 6 0 Tools Print Tool QuickPrint gt TFORMer QuickPrint requires NET Runtime 2 0 The screenshot below shows how to quick print the serial letter designed in chapter 5 Co E TFORMer QuickPrint MailingFlowerPower qpi C temp lo File Configuration Help TFORMer QuickPrint TEC IT oko 2 Form al OK Demos tfr TFORMer_Runtime_Examples MailingFlowerPower Output j OK Ciittemp MailingFlowerPower pdf Q Table style Address Wagnerstr 6 City Steyr
20. 5 a label is usually printed multiple times on a page of the output The basic layout of the label remains unchanged only the dynamic data in this example the serial number changes from label to label In order to compute a serial number a datafield must be created A datafield is a placeholder for variable data It may be used in computations gt TFORMer is able to perform computations within a layout Such computations utilize data fields for storing intermediate results For more information refer to the TFORMer Designer manual 7 1 Your Requirements 7 1 1 Bar Code Label Layout The layout of the labels in this example is very simple A serial number should be printed as bar code and as text The bar code encodes the serial number with leading zeros 000001 000002 000003 erial 2 erial 3 000004 000005 000006 Serial 4 erial 5 erial 6 000007 000008 000009 erial 7 erial 8 erial 9 000010 000011 000012 Serial 10 Serial 11 Serial 12 000013 000014 Serial 13 Serial 14 Figure 24 Labels with Serial Number 7 1 2 Serial Numbers This example demonstrates how TFORMer can be used to automatically create serial numbers The serial number is computed by TFORMer itself No external programming is required Page 25 of 36 7 2 Create the Bar Code Labels 7 2 1 Start TFORMer Designer See section 4 1 7 2 2 Create the Basic Layout gt TFORMer Designer unifies the generat
21. EF i J Specify the name and the type of the new Datafield When gt 3 Detail Detail manual creating print data the Default Value is used as ME Delete A standard value for this Datafield ee Ai p 7 ll ia New Datafield Name a 2 B Customer H Properties E Properties i ax Type 7 A 7 lad TFORMer1 Properties b DIla EE Modify the properties ofthe Element a ka Page Footer Page Footer Default Value Common Advanced Watermark Posi 4 Sen 4 Columns 1 a u Description Rows 1 1 Column Width auto Row Height auto 5 Column Spacing 0 000 mm Row Spacing 0 000 mm ae gt Document name 3 Comment Columns F The number of columns also named labels or 41 IN j logical pages nextto each other on one page If 4 N Layout Data A Preview Ne Create a new Datafield 0 00 0 00 mm E 205 00 x 71 00 mm A 100 Figure 15 Create a Datafield Manually Right click on the node Datafields or on any existing datafield in the design tree Select New Datafield in the pop up menu Alternatively select Data New Datafield from the menu or Di click on the New Datafield icon in the toolbar The dialog New Datafield appears In this dialog enter the name of the datafield and confirm with OK gt Generally it is recommended to use datafield names which are identical to the column names in the datasource Speaking field names
22. Its content can be printed as text as bar code as picture filename for dynamic logos and it can be used for computations and for controlling the output behavior gt Datafields must be defined before they can be used in a layout 5 2 4 Create New Datasource To create a new datasource switch to the Data tab and select lt Create New Datasource gt from the drop down menu see in Figure 11 unterhalb Alternatively you can right click on the Datasources entry in the design tree and select New Datasource from the pop up menu or click on the New Datasource icon j in the data toolbar The New Datasource dialog will appear Page 14 of 36 Pay Rabie ee one Layout Data Tools View Window Help DGPS saa x o e alelsaeals Bsr i X Repository Design Edit manually default irr Datasources f Datafields New Dataftet _ es Tray Mappings New Datafiet vey Irce D Sr lt New Dataftel A Report Headers Page Headers Group Headers Details lt New Datafiel D Group Footers New Dotaftel i Choose a Type D Bags Footers lt New Dataftel ODBC Database 2 A Report Footers lt New Doataftel a E XML File Specify the name and the type of the new Datasource lt New Dataftel Datasources are used to print layouts with dynamic New Datafiel ae 1 2 3 4 5 6 7 8 9 lt New Dotaftel ax lt New Datafiel e gt
23. OOTS This file contains the name of the datafield SerialNumber along with its current value 1000 The value in stepSize is used for incrementing the value of SerialNumber for one print out Save this file in an arbitrary directory 7 3 2 Start TFORMer QuickPrint Start TFORMer QuickPrint using the start menu of Microsoft Windows Start gt All Programs TEC IT TFORMer 6 0 Tools Print Tool QuickPrint Page 33 of 36 7 3 3 Set up TFORMer QuickPrint Click on the Common button and enter the directory containing the QuickPrint xml file as the serial directory in the following dialog Enter the directory where you want to save the last printed data by default your My Documents folder in Choose an arbitrary username enter it in and close the dialog with OK TFORMer QuickPrint Tutorial gpi C temp File Configuration Help TFORMer QuickPrint OK C ProgramDate TEC IMTFORMer 6 O Examples QuickPrint SerialNumber Serials configured Form Form not specified OK C temp outtutorial pdf Table style 4 Username JohnDoe Serials Directory C ProgramDateiTECITYTFORMen6 Examples GuickPrini Sen Data Directory CATemp Reset to Default Clear Data Figure 35 QuickPrint Common Settings Next click on the Form button and enter the directory where you saved your layout in the Repository field Choose the output format and the filename if you are exporting
24. WWW TEC IT COM TFORMer Designer Label and Report Printing Version 6 0 Tutorial First Steps 22 July 2010 TEC IT Datenverarbeitung GmbH Wagnerstrasse 6 A 4400 Steyr Austria t 43 0 7252 72720 f 43 0 7252 72720 77 office tec it com www tec it com 1 Content 1 Content 1 1 Table of Figures 1 2 List of Tables 2 Disclaimer 3 Introduction 4 Print Ready to Use Industry Templates 4 1 Start TFORMer Designer 4 2 Choose a Layout Template 4 3 Provide Data 4 3 1 Select the Manual Datasource 4 3 2 Enter Datafield Values 4 4 Preview or Print the Form 5 Print Serial Letters 5 1 Your Requirements 5 1 1 Serial Letter Layout 5 1 2 Data to be used in the Serial Letter 5 2 Create the Serial Letter 5 2 1 Start TFORMer Designer 5 2 2 Create the Basic Layout 5 2 3 Define Datafields Placeholders for Dynamic Data 5 2 4 Create New Datasource 5 2 4 1 Specify CSV File 5 2 4 2 Specify Field Bindings 5 2 5 Note for Defining Datafields Manually 5 2 6 Finish the Layout 5 2 6 1 Insert Text Elements 5 2 6 2 Insert the Bar Code 5 2 7 The Finished Serial Letter 5 3 Preview or Print the Serial Letter 5 4 Ready To Use Example 6 Quick Print Existing Layouts 7 Print Bar Code Labels with Serial Numbers 7 1 Your Requirements 7 1 1 Bar Code Label Layout 7 1 2 Serial Numbers 7 2 Create the Bar Code Labels 7 2 1 Start TFORMer Designer 7 2 2 Create the Basic Layout 7 2 3 Create a Datafield to be used as a Serial Number 7 2 3 1 Inser
25. abales iB File Edit Insert Layout Data Tools View Window Help x D6me Hage sam xlo e io i Eg em EEE TIEF Arial iv ve A gt i v7 Base Code128 r 1 x ERBE i 4 E a BEE i ce 8 Eh 13 Repository Design ax I I 5 Dalal Detail Pole 2 SerialNumbers_1 ff C temp rr yy Datasources aD q o Datafields SI lll a Gz SerialNumber BR fer Data ANLAMCA IL IE AL Peake 4 Edit Barcode Data Sees oJ F i E E Datafields Expression Description ders z Constants lt New Datafield gt lt New Datafield gt ers 90 System Datafields SerialNumb 4 cn S Functions a pers Py l2 a C4 Formats 3 B Common Expressions aig alNumber ka I rs rs Y lad sign Please enter an Expression manually You can also add a predefined Expression or Datafield by double clicking it x amp aG A static text must be specified between apostrophes StaticText aea en Text values or Datafields may be concatenated by using E g concatenated text of the Element 3 psition All H th L Insert Data Number ae SerialNumber p126 E ult 12pt 5 i u m Pd using an I Data is specified this u Required type of Expression ANYTHING P 4 rn Layout A 4 Ready S 5 00 5 00 mm E3 40 00 x 15 00 mm A 200 Figure 30 Insert a Bar Code In the layout toolbar select the bar code symbol and click onto the desired position on the detail
26. ail eq Hint Standard Labelis pi BS Linie _ Rechteck D Group Footers Label Printedltems on Page Page amp aN po i l amp Repository E Design Properties Hint Properties gt Modify the properties of the Element Common Advanced Position Margins All Text Standard Labelis printed a Font Arial 10pt a Auto Font Size False 7 Auto FontSize M 50 Auto Font SizeM 200 Fore Color Fill Calar Text Text with embedded Expressions and Datafields 14 hl r GLC BIN Layout a y 5 40 00 x 30 00 mm 200 feq pal den i A A FA A Bi lad p R The standard layout contains some graphical elements Most likely they are not needed so select them with the mouse and press Del gt Please note The screenshot above uses a zoom factor of 200 You can change the viewing zoom factor for your layouts in the menu View gt Zoom 7 2 9 Create a Datafield to be used as a Serial Number As mentioned before we need a datafield to hold the serial number The name of this field should be SerialNumber To simplify computation with this datafield the data type will be set to Long an integer number Page 28 of 36 File Edit Insert Layout Data Tools View Window Help peu Maaalsnax sy e alles am HS SG BEH ein jo zru Frela mr 7 58 Code128 Repository Design SerialNumbers_1 tf C temp H Dat
27. ants City System Datafields CustNr 5 Functions ae 5 Formats te alid B Common Expressions Email JobTitle Name Salutation SerialNumber Zip Please enter an Expression manually You can also add a predefined Expression or Datafield by double clicking it A static text must be specified between apostrophes StaticText Text values or Datafields may be concatenated by using E g concatenated text H K yi 2 Salutation Required type of Expression ANYTHING A Figure 17 Expression Builder In select the datafield to be embedded in the text Insert it into the expression by clicking Confirm the dialog with OK 5 2 6 2 Insert the Bar Code To insert a bar code into your layout select the bar code tool and then click into the suitable area of the layout Because a bar code usually contains no static text TFORMer will open the Expression Builder directly The properties of the bar code element like the bar code type to be used or the rotation can be changed in the property window 1 A TFORMer MailingFlowerPower xmd kaba Eile Edit Insert Layout Data Tools View Window Help BE E l a x D 6 a Ho a EditBarcode Data a aS 5 Arial amp Datafields Expression Description a a Consta
28. asources ta DeM cut P Ba Copy Paste W Delete gt m inl Specify the name and the type of the new Datafield When manual creating print data the Default Value is used as standard value for this Datafield Name SerialNumber Type Long 4 Sell Default Value _ gt Common Advanced Watermark Post Description Print Order Across then Down Orientation Printer Default Datasource Edit manually default ooowooo BOODRE Print Order Specifies in which way TFORMer fills the lt WW z 2 physical page with labels or logical pages iC 4 gt Layout Data Preview Create a new Datafield 2 0 00 0 00 mm EI 49 74 x40 85 mm a 200 Figure 29 Create the Datafield SerialNumber Right click onto Datafields in the design tree and select New Datafield in the pop up menu In the following dialog enter the name of the datafield SerialNumber and select Long as data type Confirm with OK The default data type is String This type is generally suitable for all kinds of applications unless you want to perform computations For computations strings must be converted to numbers e g with CLng or CDbl Alternatively use the data type Long or Double Page 29 of 36 7 2 3 1 Insert the Bar Code EBENEN EIER b
29. cribed above However if you want to use different data you can create additional datasources and switch between them as required To print the serial letter on a printer or to create an output file e g a PDF file open the print dialog Therefore press Ctrl P or use the menu File Print Device Output to Printer Printer gt Microsoft XPS Document Writer Pages Copies All Copies From Pages Data Datasource Filter Advanced Settings Print All pages Start Column J Open output file automatically x DE Figure 20 Printing Page 21 of 36 In choose the required output format e g Printer In select a suitable output device or output file If you want to add a filter click the button The expression builder will appear Now click OK and start the output Er MailingFlowerPower pdf Adobe Reader File Edit View Document Tools Window Help ED 1 6 6 ii ing Flower Power 123 Main Street Nowhere PA 12334 E Mr Jephen Stobs HS12346 Main Street 6 12334 Nowhere 08 11 2007 Dear Mr Jephen Stobs We ve moved to your area Be it Romance Birthday Thank You or Sympathy Flower Power offers the perfect gift for every occasion We pride ourselves on having the freshest highest quality and best selection of flowers at 12 locations in the Nowhere metropolitan area And now we are bringing our friendly service
30. d click Next rauen EI EEE PAS Create New Form Label settings Specify the size and the layout of the page These settings specify how many labels logical pages are printed per physical page The dimension of the physical page depends on the settings of the output device Label Settings Columns Number of Columns 3 T height width Number of Rows 5 Column Width 50 000 mm Row Height auto Printing Order Column Spacing 10 000 mm Down then Across Row Spacing Across then Down Figure 27 Label Specific Settings Adjust the required label settings This example uses 3 columns of labels each 50 mm width and 5 rows of labels per page The horizontal and vertical distance between the single labels is set to 10 respectively 5 millimeters When clicking Finish TFORMer Designer opens a standard layout using the adjusted basic settings Page 27 of 36 fa File Edit Insert Layout Data Tools View Window Help Deu MEARS san x vo Ales athe SSG hehe big eee Arial u v i ws u e ara mr 2 Base Codet28 3 Repository Design mi I im A 1 s 3 I 1 4 1 5 1 6 i om 8 Detail Detail 0000 am TOR MER lj Datasources it Datafields en a n is i er z Tray Mappings EN Layers Standard Label D Bands i A Report Headers Page Headers e P Group Headers is printed once for each data record 5 8 Details a f Det
31. e contains column names Address Salutation City CustNr DateValid Name Zip Main Street 6 Mr Nowhere HS1234 12 31 2006 Jephen Stobs 12334 Side Street Mrs Nowhere HS6543 12 31 2006 Tus Nelda 12334 Some Street5 Mr Nowhere 03342 12 31 2006 Silent Bob 12334 Down Street Mer Nowhere JM1234 12 31 2006 Je Me Hendrix 12334 Left Street 1 Mr Somewhere GB1234 12 31 2006 Gill Bates 12334 Straight Street 1 Mr Elsewhere LT4321 12 31 2006 Tinus Lor Valds 12335 E Show Advanced Options Apply Figure 12 Datafield Import from CSV File Page 15 of 36 In specify the CSV file that want to use Press the button to select the required file from your file system Depending on your operating system you will find the example file in one of the follow ing locations Windows Vista C ProgramData TEC IT TFORMer 6 0 Examples Command Line serialLettcerPpPDE serie rrer Den ames v7 Other Windows versions C Documents and Settings All Users Application Data TEC IT TFORMer 6 0 Examples Command Line SerialLetterPDF SerialLetterData csv In specify the character which is used as column separator in our example a comma In adjust the text qualifier character to match your input file in our example a quotation mark The text qualifier is used to enclose single values within the text file Since the file SerialLetterData csv contains the column names in the first line make sure that the checkbox is
32. element should be printed centered Word wrap should be disabled To do so select the text element and edit its properties in the property window The alignment is adjusted in word wrap is disabled by selecting False in Page 31 of 36 Common Advanced Position Margins All Text serial SerialNumber Font Arial 12pt Auto Fontsize False Auto Fontsize Mi 50 56 Auto FontsizeM 200 Fore Color E O Fill Color Line Color Line Width 0 100 mm Line Style Text Alignment Center Justify False Word Wrap gt 7 Text Rotation 0 0 Figure 32 Properties Window of a Text Element 7 2 4 The Resulting Layout FA TFORM er SerialNumbers_L tff SS A File Edit Insert Layout Data Tools View Window Help Boo 2 ie zu jFr s a mr gt Code128 5 C 7 F l 3 s 7 7 7 Repository Design S SerialNumbers_1 f C temp 9 Datasources ma Datafields 8 Tray Mappings I Layers D Bands P Report Headers Page Headers P Group Headers a Details a f Detail Se ri al N u mb e r E SerialNumber ed SerialNumber Hd Serial SerialNumber __ Rectangle D Group Footers D Page Footers D Report Footers Serial SerialNumber Repository E Design Properties Rectangle Properties Modify the properties of the Element Common Advanced Position Fill Color ha Line Color Line Width 0 100 mm
33. eration of the current field bindings Address City Main Street 6 Nowhere Side Street 7 Nowhere Some Street5 Nowhere Down Street 1 Nowhere Left Street 1 Somewhere Straight Street Elsewhere CustNr HS1234 HS6543 503342 JM1234 GB1234 LT4321 DateValid 12 31 2006 12 31 2006 12 31 2006 12 31 2006 12 31 2006 12 31 2006 Name Salutation Jephen Stobs Mr Tus Nelda Mrs Silent Bob Mr Je Me Hendrix Mr Gill Bates Mr Tinus Lor vYalds Mr Zip 12334 12334 12334 12334 12334 12335 Show Advanced Options Figure 14 Preview of Data Apply JE Z Page 17 of 36 5 2 5 Note for Defining Datafields Manually If you followed the instructions above there is no need to create datafields manually However instead of automatic datafield generation you may also create datafields manually To do this follow the steps below fe TFORMer TFORMerl rer x Y x A Eile Edit Insert Layout Data Tools View Window Help E x Deu Haase RAX Nr Sy an 3e m EHRE d j ME EE Arial 12 ie zulFr s a 7a mr s Bose MERZIEFTEEEEITETETUOSTT BESSERE ei JER Page Header Page Header 5 TFORMert 0 2 Pag g z Datasources 7 oy J Edit manually default BS O SerialLetter_CSV o lH ENEIBE t JIa E New Datafield Ea co Ctrl E Paste Ctrl V SOR
34. ialog Form Print Press Ctrl P or use the menu File Print Page 8 of 36 Device Output to Printer 1 v Options Printer Microsoft XPS Document Writer 2 Pages Copies All Copies From Pages Data Datasource Edit manually default Filter Advanced Settings Print Allpages Start Column Open output file automatically Figure 5 Print Form Select the required output format in e g Printer In choose the appropriate output device e g an available printer on your system By clicking OK the print job is started If multiple identical copies are required adjust the value of Copies in Page 9 of 36 5 Print Serial Letters This chapter demonstrates how to use TFORMer for creating and printing a serial letter 5 1 Your Requirements Let us assume that this serial letter announces a new store of your company and will be sent to existing customers All customer data like customer number name and address is stored in a Microsoft Excel table 5 1 1 Serial Letter Layout Page Header Flower Power 123 Main Street Nowhere PA 12334 Mr Jephen Stobs Detail Area HS12346 Main Street 6 12334 Nowhere 18 05 2006 Dear Mr Jephen Stobs We ve moved to your area Be it Romance Birthday Thank You or Sympathy Flower Power offers the perfect gift for every occasion We pride ourselves on having the freshest highest quality and best selectio
35. ich Template should be used to create the new Form Choose a Template for the new Form Description stom Report gt B m Label gt B 1 Automotive JB 2 Transportation O 3 Business Cards D 4 Telecom oO 5 Labels 5 6 Samples B 7 Overviews oO 8 Medical Figure 7 Create a New Report j i co i The serial letter as outlined above is a report style output therefore choose Custom Report and click Next Create New Form Marg n settings Specify the position of the Form on the page Please specify page margins distances between the edges of the page and the labels and the rotation of the Form Margins Lett 10 000 mm Top 10 000 mm Right 10 000 mm Bottom 10 000 mm Orientation Orientation Printer default v Figure 8 Adjust the Margins of the Report Adjust the page margins as shown below and click Finish TFORMer Designer opens a standard report Page 12 of 36 RA TFORMERTIFORMER i EL File Edit Insert Layout Data Tools View Window Help e D euna xan x ve REBAR er Eee ee be mine Se od Ariel 10 i B2U PyBl Arovity JeE Base ee ee ee Repository Design ax E Fi Report Header Kepor Header A E TFORMer 0 2 i Cut Ctrl X F amp oe Report Header a Report Header Band is printed orice attopofthe Report c i ao
36. ing our friendly service and great selection to your neighborhood N a Dur new location 5 at 456 Cherry li in charming Nowhere Please viit us at our Grand ru Aal t 16 2008 Come and see our ee me at i Vo 1 De TE ee ee gt tee Yo x zu P F ax MailingFlowerPower Properties b Modify the properties of the Element R Advanced Watermark Position gt Flawer Power stores are open URS 1000 a m to 8 00 p m All major credit cards pore Convenient parking Your ERLERNEN guarantend Colurnns 1 en ents es Ben Ranke 1 mie cue g Colurnn Width auto S Row Height auto Column Spacing 0 000 mm Row Spacing 0 000 ram Document name Comment Rotation 0 gs Page Footer Page Footer Cordially Martin Myers pi fouelhr EI I Columns The number of columns also named labels or logical pages nextto each other on one page If using auto TFORMer computes the max number of labels per row mite matinalh inmana an thea nee atthe abant at Peep ep Cyan 10m K I i ic Layout Data A Preview a Ready ti 0 00 0 00 mm E 199 50 x 266 44 mm 950 Figure 19 Finished Serial Letter 5 3 Preview or Print the Serial Letter To get a preview of the resulting output simply click on the Preview tab TFORMer will instantly render the serial letter in the main window This output uses the data from the CSV file as des
37. ion We pride ourselves on having the freshest highest quality and best selection of flowers at 12 locations in the Nowhere metropolitan area And now we are bringing our friendly service and great selection to your neighborhood Our new location is at 456 Cherry Lane in charming Nowhere Please visit us at our Grand Opening on August 16 2006 Come and see our great selection of specialty and seasonal arrangements along with standard fresh flower bouquets gourmet gift baskets and more If you re looking for a specially arranged floral gift for that certain someone this is a great place As a token of our appreciation you ll receive a special gift just for stopping by And that s not all Flower Power also offers worldwide flowers by wire service with easy and convenient ordering we can get you what you want where and when you want it Over 1 000 different flower and plant arrangements are available online for quick delivery Flower Power stores are open daily from 10 00 a m to 8 00 p m All major credit cards accepted Convenient parking Your satisfaction guaranteed Look forward to seeing you at the Grand Opening Cordially Martin Myers fe following steps Start gt All Programs TEC IT Page 22 of 36 ale Edit Insert Se Data Tod View Window Help nDeaMaaa lxsna x s e JB e Ei Ariel 8 i za PrY m a g Demostr C ProgramData TEC IT TFORMe aB Tray Mappings er a
38. ion of reports and labels Only the parameters of the layout are used to differentiate between the two possible output styles This very flexible printing concept allows the generation of simple labels as well as full featured reports For more information please check out the TFORMer Designer user manual Create a new layout Therefore press Ctr N or use the menu File New Form In the appearing dialog you can choose between creating a new report a new label or using one of the pre designed layouts Create New Form Template Which Template should be used to create the new Form Choose a Template for the new Form Template Description B lt Custom Report Sf lt Custom Label gt 1 Automotive 3 Business Cards 4 Telecom 5 Labels 6 Samples 7 Overviews 5 Medical Figure 25 Create a New Label The bar code labels as outlined above are a label style output therefore choose Custom Label and click Next Page 26 of 36 Dr ee Create New Form Margin settings Specify the position of the Form on the page Please specify page margins distances between the edges ofthe page and the labels and the rotation of the Form Margins 9 I Margin top Left 20 000 mm Right 20 000 mm i Sn Margin left Bottom 10 000 mr ko Orientation Orientation Printer default v Figure 26 Adjust the Margins of the Label Set all margins to the values shown above an
39. k A eee emee Tray Mappings P k E Paste Ctrl Y 4 Layers ie Page Header Page Header 7 5 D Bands a Page Header fa Page Header Band is printed atthe top ofeach page gt Report Header l New Band gt RB Page Headers gt _ IF Detail Detail Band Order gt Group Headers i i Ea amp Details A Detail Band Printeditems a Detail Band is printed for each data reci D Group Footers A il Pre Evaluation D Page Foot F To insert additional Bands or Elements e g Report Headers Text Barcodes Images use the p age rooters To deete an Element or Band select it and press Del 3 Post Evaluation D Report Footers eA To fillthe Report withvariable data use Da Fields Right click on Elements or Bands for more options bed BE ee amp Printing Condition Desi Ban Design 3 ad Page Footer Page Footer E Group By g a Page Footer a Page F ooter Band is printed at the bottom of each page Properties t e 5 Properties Report Header b FD Report Footer Report Footer 1 Modify the properties of the Common Advanced Position AI u Report Footer a Report Footer Bandis printed once atthe bottomoftheReport Ton Page Break None v pi e a ee N ee Ze Ze amp R 3 Row Column Bre None Paqe Break gt Specifies that TFORMer should perform a 5 lt Im 2 page break before and or after printing the c OU Layout Data Pre
40. n F r dieses Dokument und den darin dargestellten Gegenstand behalten wir uns alle Rechte vor Vervielf ltigung Bekanntgabe an Dritte oder Verwendung au erhalb des vereinbarten Zweckes sind nicht gestattet 1998 2010 TEC IT Datenverarbeitung GmbH Wagnerstr 6 A 4400 Austria t 43 0 7252 72720 f 43 0 7252 72720 77 http www tec it com Page 4 of 36 3 Introduction Many thanks for your interest in TFORMer Designer This document provides a quick introduction to TFORMer Designer It focuses on the following topics Printing ready to use industry templates Chapter 4 demonstrates how to print a VDA 4902 industry label Generating serial letters Chapter 5 provides a quick introduction for creating letter style documents Tool for simple and fast printing Chapter 6 describes how to use TFORMer QuickPrint a tool for printing layouts instantly Printing bar code labels Chapter 7 is a step by step guide for creating bar code labels Page 5 of 36 4 Print Ready to Use Industry Templates TFORMer Designer is shipped with a large number of predefined industry compliant document templates This chapter demonstrates how to print VDA 4902 industry forms VDA is an abbreviation for Vereinigung Deutscher Automobilzulieferer and is a common standard in the automotive industry 4 1 Start TFORMer Designer Start TFORMer Designer using the start menu of Microsoft Windows Start gt All P
41. n of flowers at 12 locations in the Nowhere metropolitan area And now we are bringing our friendly service and great selection to your neighborhood Our new location is at 456 Cherry Lane in charming Nowhere Please visit us at our Grand Opening on August 16 2006 Come and see our great selection of specialty and seasonal arrangements along with standard fresh flower bouquets gourmet gift baskets and more If you re looking for a specially arranged floral gift for that certain someone this is a great place As a token of our appreciation you ll receive a special gift just for stopping by And that s not all Flower Power also offers worldwide flowers by wire service with easy and convenient ordering we can get you what you want where and when you want it Over 1 000 different flower and plant arrangements are available online for quick delivery Flower Power stores are open daily from 10 00 a m to 8 00 p m All major credit cards accepted Convenient parking Your satisfaction guaranteed Look forward to seeing you at the Grand Opening Page Footer a Flower Power 123 F Main Street Martin Myers Nowhere PA 12334 Cordially Customer ID L UA 12 31 2006 Figure 6 Sample of a Serial Letter The serial letter is divided into three logical areas These areas are marked with red frames in the figure above Page Header The page header in this example contains only static data and is identical for all letters
42. nts ci BRENNEN 6 2 0000 Ai hof gt E E Functions el 2 MailingFlowerPowerxmd C ProgramDat a eg i 5 SOM Formats ge Datasources a gift Common Expressions Fme P ca Datafields A x JobTitle BT 3 S a ray Mappings op ee Layers LJ d And Salutation E Di Bands 1 ax and A P Report Headers 2 I i Om Ove ES Ay Page Headers E lhal D Aali MD Group Headers al deli Returns the value of the Datafield 5 D Details A A af Detail A 14 w Flos D Group Footers allie as i acc Page Footers 15 H o L Insert Data a d Page Footer 25 CustNr y CustNr fail ae A Report Footers Qs g Loo WW bii nn g ll ke Ibe 4g Repository Design ES 17 Properties FD Page Foot m Barcode Properties b 5 Modify the properties of the Element 5 Required type of Expression ANYTHING Cancel Common Advanced Position All 1 Name Barcode a i Printing Condition Ea Layer Basis 2 3 Escape Sequen False S Hex Data False F 3 Am Format Bearer Width 0 000 mm sE Module Width auto 4 Notch Height auto Bar Space Ratio Qunnrace Frear Falco er 5 Name _ n u _ Name ofthe Element f4 im r LIEBE Layout A Data N Preview j Ready Ti 167 00 6 80 mm ES 10 00 x 24 00 mm A 100 Figure 18 Insert a Bar Code Page 20 of 36 5 2 7 The Finished Serial Letter lf all required elements have been inserted then you should see the following layout
43. ppings Layers Flower Power D Bands J 123 Main Street a oi I 18 P Report Headers 2 Nowhere PA 12334 7 A Page Headers D Group Headers us ee rl ad 3 8 Details m fA Detail al eq Salutation Name Addre BD eq Now 0 A eq Dear Salutation Name IF Detail Detail eq CustNr all D Group Footers D 7 2 5 A Page Footers 2 1 Salutation Name CustNr wa Page Footer 2 g Address D Report Footers Zip City oul i g i 4 Repository 3 Design Now O0 Properties x 3 gt 1 Text Properties b E the properties of the Element s 4 z Fa T er aha 7 Dear Salutatio n Sx Edit Text oe Advanced Position Margins all 3 InsertData Arial 2 vv Br us ax Text bndition I 4d Page Footer Page Footer Dear Salutation Name Basis 3 paces True O Blank False 1 ng 0 000 mm 2 4 F Element 514 In lq 4 bl Bl Layout Data A Previe cancel gt gt une Cancel Ready 4 p 00 mm A 100 Figure 16 Serial Letter Design gt Always use the button MsertData to embed a datafield or an expression into your text gt If you enter the expression markers or lt gt directly they will be printed as typed on the keyboard The expression will not be evaluated in such a case When inserting an expression via the Expression Builder appears Page 19 of 36 fi Expression Builder HC Datafields San er Const
44. rograms gt TEC IT TFORMer 6 0 TFORMer Designer 6 0 Edit Insert Layout Data Tools View Window Help Oy Re ee En ET Tonne ee ee Ctrl 0 e a gt m s Jf Ctri S SS Repository Design a Ctrl HA Templates MB Layout View Ctrl L MB Data View Ctrl D MB Preview Ctrl Space Page Setup Printer Setup WB Print Repository El Design 1 CiAtemp Data tff 2 C ProgramData Demos tfr Properties 0000 ooa 3 C temp PickList_10 tff Modify the properties of the Element bj 4 CAtemp PickList_10 tff Exit Create a new Form Figure 1 File New Form 4 2 Choose a Layout Template In order to create a new layout press Ctr N or use the menu File New Form In the appearing dialog you can choose between creating a new report a new label or using one of the ready to use layouts Page 6 of 36 Create New Form Template Which Template should be used to create the new Form Choose a Template for the new Form Template Description o YDA H Belom DA 4902 Version 4 English A VDA_4902_K For Small Charge Carrier Kleinteile A VDA_4902_PT VDA 4902 Version 4 Portuguese VDA_4902_5 For Steel Supplies VDA_4902_V VDA 4902 Version 3 4 German VDA_4902_V VDA 4902 Version 4 German A VDA_4906 Rechnung Invoice DIN 4991 HH Figure 2 Create New Form Template Selection Select the template VDA_4902_EN
45. t the Bar Code 7 2 3 2 Insert the Text Element 7 2 3 3 Format the Text Element 7 2 4 The Resulting Layout 7 2 5 The Print Preview 7 3 Printing Serial Numbers with TFORMer QuickPrint 7 3 1 Create a Serial Number Configuration File 7 3 2 Start TFORMer QuickPrint 3 3 Set up TFORMer QuickPrint 7 3 4 Enter the Printing Data 7 39 Print the Label 7 3 6 Ready To Use Example 8 Contact and Support Information 8 1 Free Support 8 2 How to Unlock the Demo Version 8 3 Company Contact Information 1 1 Table of Figures Figure 1 File New Form Figure 2 Create New Form Template Selection oXOXDOoODDO9 OF A ONN Page 2 of 36 Figure 3 Layout View Figure 4 Edit Data Manually Figure 5 Print Form Figure 6 Sample of a Serial Letter Figure 7 Create a New Report Figure 8 Adjust the Margins of the Report Figure 9 Standard Report Figure 10 Figure 11 Figure 12 Figure 13 Figure 14 Figure 15 Figure 16 Figure 17 Figure 18 Figure 19 Figure 20 Figure 21 Figure 22 Figure 23 Figure 24 Figure 25 Figure 26 Figure 27 Figure 28 Figure 29 Figure 30 Figure 31 Figure 32 Figure 33 Figure 34 Figure 35 Figure 36 Empty Report for the Serial Letter Create a new Datasource Datafield Import from CSV File Bind Datafields Automatically Preview of Data Create a Datafield Manually Serial Letter Design Expression Builder Insert a Bar Code Finished Serial Letter Printing Serial Letter PDF Outp
46. to a file in the dialog accessible via the button Output You can save this configuration if you want to use it later with File Save As With the Save Data button you can save the data which you have entered manually The data is stored in the XML file It is available at the next start of TFORMer QuickPrint The Reset to default button resets all datafields in the current record to their default values The Clear Data button clears the current record Page 34 of 36 7 3 4 Enter the Printing Data Enter the printing data for your label in the input area In this case the label contains only the serial number This field cannot be changed read only fields are marked with gray background color The field Count of Serials specifies how many serial numbers should be created For each serial number one label is printed If you want to print more than one label for each serial number adjust the number of copies Se a RET NENNE File Configuration Help TFORMer QuickPrint OK C ProgramData TEC ITATFORMen6 O Examples QuickPrint SerialNumber Serials configur OK SerialNumbers_2 tff OK C Memp Output pdf Table style SerialNumber Count of Serials Copies Figure 36 QuickPrint Printing Data 7 3 5 Print the Label To start printing simply click the Print button If you are exporting to a file TFORMer QuickPrint opens the file with the linked Windows application e g PDF with Acrobat Reader
47. ut Open the Serial Letter TFORMer QuickPrint Tool Labels with Serial Number Create a New Label Adjust the Margins of the Label Label Specific Settings Standard Label Create the Datafield SerialNumber Insert a Bar Code Insert a Static Text and a Datafield Properties Window of a Text Element The Resulting Layout Print Preview with Empty Datafield QuickPrint Common Settings QuickPrint Printing Data 1 2 List of Tables Table 1 Column Names in the CSV File 10 12 12 13 14 15 15 16 17 18 19 20 20 21 21 22 23 24 25 26 27 27 28 29 30 31 32 32 33 34 35 11 Page 3 of 36 2 Disclaimer The actual version of this product document is available as is TEC IT declines all warranties which go beyond applicable rights The licensee or reader bears all risks that might take place during the use of the system the documentation TEC IT and its contractual partners cannot be penalized for direct and indirect damages or losses this includes non restrictive damages through loss of revenues constriction in the exercise of business loss of business information or any kind of commercial loss which is caused by use or inability to use the product documentation although the possibility of such damage was pointed out by TEC IT We reserve all rights to this document and the information contained therein Reproduction use or disclosure to third parties without express authority is strictly forbidde
48. view oe Delete the selected Bands 5 0 00 0 00mm o 15917x1500mm 100 Figure 9 Standard Report This report contains more printing areas bands than required for our example According to section 5 1 1 we only need a page header a detail band and a page footer Remove all unnecessary bands report header and report footer from this standard report To do this right click on the headline of the band and choose Delete in the pop up menu Now delete all unwanted printing elements from the remaining bands by selecting them with the mouse and pressing the Del key After performing these steps TFORMer Designer displays the following layout Page 13 of 36 E TFORMer TFORMer1 Barca a File Edit Insert Layout Data Tools View Window Help LE el Deg Haqus 4aa x o o a Arial 10 cos 2 FE oe ee a ee amp oe oe BI UFF EA ily J amp Base 3 ooo Le a Sk REL EE GEE 2 m Page Header Page Header B TFORMer a Datasources ita Datafields aB Tray Mappings a Layers Bands P Report Headers 5 A Page Headers P Page Header P Group Headers Gf Details pA Detail D Group Footers a D Page Footers D Page Footer D Report Footers E Design 3 Detail Detail Be poems Ge 4 Page Footer Page Footer x Page Header Properties Modify the properties of the Advanced
49. will help you to identify the use of each datafield when creating the layout gt TFORMer is able to provide standard values for datafields Such default values can be useful as test data during the development process The default values are defined in the New Datafield dialog in or in the property window Once the datafield is inserted you will find the appropriate entry in the design tree Page 18 of 36 5 2 6 Finish the Layout Now start to insert the required elements into the layout To insert an element first select the element type in the layout toolbar and then click on the suitable area of the layout in To change the properties of an element e g color font bar code select it with the mouse and then use the property window 5 2 6 1 Insert Text Elements For text elements TFORMer Designer opens a dialog which allows you to enter the content of the element see You may mix static text with datafields like Dear Salutation Name Datafields are enclosed in square brackets A TFORMer MailingFlowerPower xmd o laz File Edit Insert Layout Data Tools View Window Help a x Ded MEqs s eel x oro Ra i i Tg em a ees a Ail iti Aw Are ees Beis Codet28 TI oF eB MailingFlowerPowerxmd C ProgramData T Ol ing 7 Page SIEBHESPRBS Header A G Datesources ca Datafields S Tray Ma
Download Pdf Manuals
Related Search