Home

Word Template Design Manual

1. FIGURE AREAS OF THE SPOOLEIEE vetet ett eei eee tee Ote ERG NE e FIGURE AREA TABLE WINDOW ect eee ee ee REEF CAREER I SENI ER ER eU FIGURE AREAS DEFINITION WINDO Ws e We ced eive reete e Deep te vete ERE ERE EODD LE Tee FIGURE PURCHASE ORDER NO AREA DEFINITION WINDOW c ccccesssscecesssscecesessaecescesseaeecessnaeeceseaaseseseenes FIGURE CATALOG NUMBERS AREA DEFINITION WINDOW ssssccccesssesecesssscecessesaecescesseaeecessnaeeceseaaeesenseaes FIGURE PURCHASE ORDER NO AREA DEFINITION WINDOW c ccccesssssecesssscecescessecescesseaeecessnaeecesesasesessnsnes FIGURE CATALOG NUMBERS AREA DEFINITION WINDOW ssssscccesssssecesssececessssaecescesscaeecessnaeeceseaaeesesensaes FIGURE SEARCH OPTION T 6 ina ert eden Eee epe RENE Yee ev ee rne a PETS SERIE ERES FIGURE SEARCH OPTIONN 4 55 aint ed tee tet e emt eee a rette TD cn te Ue eed Dee FIGURE SEARCH OPTIONP E EE E FIGURE SEARCH OPTION Y iran EL FIGURE SPOOL BILE HEADER ioci ete tete et ee ete ra ertet LT ene TEA FIGURE TEMPLATE DOCUMENT HEADER seht FIGURE BIELD RULER WINDOW RH c FIGURE AORDNO FIELD RULER WINDOW cssscssssccescecesseeesseecescecessecesseecscecesseccsseeceececeaaecesseecnseecesaeeensees FIGURE FIRE SIGNATURE ee ace este tete abs R
2. Rd papirus Module Word Template Guide Papirus Template Content INTRODUCTION TO PAPIRUS ccssssssssssssssesssssessssessssessssessssesssssssscsssscsssscessscsssncesssconsaconsassesassesassessseoseseoss INTRODUCTION TO TEMP LATE e eeeen eene nta nto onto ta tonta tonto tosta eats tasas tas sensa tona ton STEP 1 DISPLAYING THE SPOOL FILE eee rete een enntnnann Step DysStepa ct ote e e RR RR RR URN ene S ENTERING PAPIRUS ON THE AS 400 SPOOL PROCESS WINDOW Purpose of ChE WINDOW see Function ad A SA AG TR ean a GE aR Using the window SPOOL LIS W INDOW ae i ee eee Purpose ofthe window braa ed Function shed 5 is Operation Codes eei e ER ee RARIOR TRES ORE E REA aaa USI BANE WING OW EAER AEEA TEA EARTEN EEIE e d i deed yr a teres DISPLAY SPOOLED FILE WINDOW Purpose of the window Function Keys sss ity Using tlie WIRdQW s ue etre o STEP 2 CREATING A LAYOUT DOCUMENT 8 CREATING THE LAYOUT DOCUMENT STEP 3 CREATING A TEMPLATE DOCUMENT ccssssssscssssssssssssnsssssssssssses
3. Design DesignID Dynamic area E End indicator F Formatting string Indicator L Layout document P Package PC server PPW file Section of a spool containing data and indicators Area containing a constant number of lines String of text written after a sign Control variables determine the destination for the output document A queue through which data is transferred from the AS 400 to the PC Links the spool to the corresponding Template document and routs it to the desired output device Name of the design must be identical to the spool userdata Area containing an unknown number of lines Indicates the ending of an area String of text written between brackets Formatting strings apply different filters on the spool text Indicates the location of data in the spool Word document defining the spool width and language code Template documents assigned to the same spool Personal computer on which the Papirus software is installed PC file format that includes a spool sample and its design definitions Used to transfer spool files and designs between AS 400 systems Papirus Template R Ruler S Spool Start indicator I Template document U Output document Userdata V Variable Wild card signs 94 Links areas from the spool to the corresponding variables in the Template document Print output of the AS 400 computer Indicates the be
4. F4 Library F2 Confirm F3 Exit F4 utq list F7 Import from Figure 3 Spool Process Window Function Keys Function keys are located in the bottom of the window The following function keys are available 2 Open a list of spools according to the defined criteria F3 Exit window and return to Papirus main menu F4 Open alist of output queues Active only when the cursor is located in the field Output queue F7 Import spool and formatting parameters from the PC refer to Step 4 for further details Using the window Direct Papirus to the AS 400 user or output queue in which the spool file intended for formatting is stored In order to enter a certain user type the user name in the field User the default is the user s own name Press F2 to confirm and open the list of spools stored under this user as described below In order to enter a certain output queue type the output queue name in the field Output queue Press F2 to confirm and open the list of spools stored under this output queue as described below Papirus Template 9 In order to select a desired output queue from a list press F4 in the field Output queue The output queue list appears Locate the desired queue by using the Page Up and Page Down keys Type 1 next to it and press Enter to select it Press F2 to confirm and open the list of spools stored under this output queue as described below
5. Field and press F4 to open a list of available control variables Select the desired control variable by typing 1 next to it and pressing Enter In the example the control variable is selected Enter the name of the desired output device in the field Formatting String In the example the email address service papirus40 com is entered Type N in the field Text is an object name Type N in the field Clear spool area Field ruler Desi URCHASE Ruler no 1 EMAILTO Fiel EMAILTO Formatting string service papirus400 com Text is an object name Clear spool area Figure 71 EMAILTO Field ruler window Press F2 to save the ruler definition Sending documents to destinations from the spool Step by Step 1 Type PPS in the AS 400 command line prompt and press Enter 2 Type 2 for Spool Design and press Enter 3 Locate the relevant spool design in the list 4 Type 8 next to it and press Enter The Area Table window appears Papirus Template 90 5 Define the area containing the name of the destination 6 Assign a Field ruler to this area 7 in a description for the ruler in the field Description optional 8 Locate the cursor in the field Field and press F4 to open a list of Papirus control variables 9 Select the desired control variable by typing 1 next to it and pressing Enter 10 Enter a formatting string repre
6. Step 1 Displaying the spool file The first step in turning an AS 400 spool into a MS Word document is displaying the spool file Being familiar with the structure of the spool file is required for the next steps Step by Step 1 Type PPS in the AS 400 command line prompt and press Enter Papirus main menu appears 2 Type 1 for Spool Process in the field Select and press Enter 3 Enterthe name of an AS 400 user or output queue in which the spool file intended for formatting is stored 4 Press F2 to confirm and open the list of spools sorted by the selected user name or output queue 5 Locate the desired spool in the list by pressing the Page Down and PageUp keys 6 Type 5 next to the desired spool and press Enter Entering Papirus on the AS 400 Type PPS in the AS 400 command line prompt and press Enter The Papirus main menu appears Papirus V4 0 Spool module 14 10 01 12 21 08 RPIRUS Spool process 2 Spool design 3 Administrator F3 Exit Select gt __ Figure 2 Papirus Main Menu Type 1 for Spool Process in the field Select and press Enter The Spool Process window appears described below Papirus Template Spool Process Window Purpose of the window The Spool Process window directs Papirus to the AS 400 user or output queue in which the desired spool is stored Papirus 4 0 14 10 2001 Spool process PAPI2 QPADEVO012 USER i nv T ES PAPI Output queue
7. The following operations may be performed from this window Create update copy and delete designs Load and save designs into from AS 400 files Sanskrit 2 Edit 3 Copy 4 Delete Design table 14 10 01 12 38 2 Sanskrit System 5 Display 6 Test Prod 8 9 Save to file More Layout Opt Design ID Description Document Test Prod Priority B BP0013 BP Invoice LYDO0CO15 BP0013c BP Invoice LYDO0CO15 BP0013org BP Invoice LYDO0CO15 HBP0014 BP Credit Note LYD0C102 BP0203 BP Combination sheet LYDOC014 BP0203c BP Combination sheet LYDOCO014 BP2104 Quotation LYD0CO12 BP2104 BP Sample Order LYDOC016 BUMBLE design for BumbleBee LYDOC903 BUMBLEBEE design for Bumblebee LYDOC903 _ C s qsheet acum PACKAGE C Sold qsheet acum PACKAGE F3 Exit Fb5 Refresh F6 Neu F9 Load from file Function Keys Figure 13 Function keys are located in the bottom of the window The following function keys are available Exit window and return to previous window F5 Refresh list F6 Createa new design F9 Load design from AS 400 file Fields The following fields appear in the window Opt Design ID Description Layout document Test Prod Priority Design Table Window Operation code to be applied on a design This field is filled in by the user Name of the design must be identical to the spool userdata Free text describing the design Name of the Layout d
8. 0 For end indicator 2 Width 9 Length Rows offset Figure 31 Catalog numbers Area Definition window Note Wild card indicators are designed to capture a wide range of areas They might capture areas you didn t intend to include Make sure your indicator is unique and captures the desired area only Papirus Template 52 Ignoring indicators By default Papirus searches a start indicator throughout the entire spool When the indicator is found its respective data is integrated into the Template document If the indicator is found several times its respective data is integrated into the Template document several times In some cases the data should appear in the output document only once even if its indicator appears several times in the spool file This can be achieved by instructing Papirus searching mechanism to include only the desired indicators Using Papirus searching mechansm Enter the Area definition window of the relevant area Locate the cursor in the field Search option and press F4 The Search options window appears allowing you to control Papirus searching mechanism for the specific start indicator Select Search Option P in order to include all indicators ignoring page breaks in the spool The following figure illustrates the result of search option I for the indicator which represents the quantity Spool File Template document Output document die 4 Turtle Furniture
9. FIGURE A SIGNATURE FIELD RULER WINDOW ccsssccsscecesceeesseecstcecessesesseecsececessecesseecececesseceseccnscecesaeeenaees FIGURE OUTPUT DOCUMENT DANI SHARON ccsssssecesssssecessnseecesenscesescsessaeecsessaeececesauececessaececessaeaecessnsaeeees Papirus Template FIGU FIGU FIGU FIGU FIGU FIGU FIGU FIGU FIGU FIGU FIGU FIGU FIGU FIGU FIGU FIGU FIGU FIGU RE RE RE RE RE RE RE RE RE RE RE RE RE RE RE RE RE RE SPOOL FILES SIGNATURES TEMPLATE SIGNATURE SIGNATURE FILES eere SIGNATURES AREA DEFINITION WINDOW csssssccesssssecescsssececcesssaecceceaaeececessaececesaesecessaeaesesensaeeens aNAME FIELD RULER WINDOW OUTPUT DOCUMENTS SIGNATURES PACKAGE TEMPLATE DEFINITIONS ee PACKAGE e k TEMPLATE DEFINITIONS ee PACKING LIST AREA DEFINITION WINDOW ccccesssececesssececesssececeseeaecessesaecesceaseaeecessaaeeeeseaaeesenenaaes REPLACE TEMPLATE FIELD RULER WINDOW cssssccccssssececesssececessnseecesseaaecesceaaeaeecessaaeeeeseaaeeseseaaes SPOOL FILE ATIN AREA DEFINITION WINDOW EMAIL TO FIELD RULER WINDOW ccccssssececesssececesseececesssesecesssseecescssaeeeecesauaeecessaaeecesenasecesssaees SPOOL FILE EMAIL ADDRESS AREA DEFINITION WINDOW ssssccccssss
10. LINKING VARIABLES TO SPOOL DATA Step bysStep ssepe ete tei eie de ue pede qe See DIVIDING THE SPOOL INTO AREAS ecciesie estie serie ete etie vede devise trei er eee eere eee dede ENTERING PAPIRUS ON THE AS 400 ccscccsssssesssscssessssescesescescssessescsscsssecssescsecsssscnesassecseessecaesesnscaesecneceesecaes AREA TABLE WINDOW ctr ee te te E TE NEAR A ADs a te d Purpose of the window ePi REOR EG HERR REIR Function a t Operation Using the Table Area Wid Ow eet tete iei e eae A eee det euer AREA DEFINITION W INDOW ceeeeeeeeee entente nennnnnn tentent tetas sen Purpose of the WindOW i e dS Function Keys aee ERE o RN e E d aum E eei IU d O Using the window ga WILD CARD INDICATORS eere nennen Defining areas with wild card indicators Defining dynamic areas without end indicators Defining dynamic areas without end indicators IGNORING INDICATORS erret ERG E esee I YER ved Ever EOD ERE EE Ee ERE ER Ede Using Papirus searching me
11. Papirus V4 0 14 10 01 12 55 21 Sanskrit Sanskrit Systems C3034 2 Edit 3 Copy 4 Delete 5 Display 6 Delete ruler 8 Rulers 9 Enable Disable Formatting ruler Opt Description Lines Type Description account 1 Field ACCOUNT _ code 1 Field CODE _ country 1 Field COUNTRY date 1 Field DATE deliver il Field DELIVER _ invoice no 1 Field NO0 _ reference 1 Field REFERENCE _ terms 1 Field TERMS ADDRESS 1 Field ADDRESS RDDRESS1 1 Field ADDRESS COLOR 1 Field COLOR DESCRIPTION 1 Field DESCRIP More F5 Refresh F6 Neu F11 Test Figure 26 Area Table Window The left side of the Area table describes an area of the spool The right side describes the ruler linking the area to a Template variable The window is empty the first time it is entered because no areas or rulers have been defined Function Keys Function keys are located in the bottom of the window The following function keys are available Exit and return to previous window F5 Refresh list F6 Define a new area Fil Activate Microsoft Word Viewer on the Papirus PC server displaying the output Word document Fields The following fields appear in the window Opt Operation code to be applied on an area This field is filled in by the user Area Description Free text describing the area Area Lines Number of lines in the area Ruler Type Type of the rule
12. output document Enter N if it should be included only in certain cases In the example Y is entered for the invoice dot Template and N is entered for the packing dot Template For each Template locate the cursor in the field next page mode in order to select the manner of merging the pages of the output document Press F4 to display a list of available merging modes Select option 00 default to merge with a page break between In this mode each page of the output document stands by itself Select option 01 to merge without any spacing In this mode the pages of the output document are combined without any spaces Select option 02 to merge with one separating line In this mode the page breaks of the output document are replaced with one separating line In the example merge next page mode 00 default is selected for both Templates For each Template locate the cursor in the field Template usage mode in order to select the manner of applying the Template document on the spool Press F4 to display a list of available usage modes For Templates that should always be included in the creation of the output document Papirus Template 82 Select option 0 default to reuse the Template for each of the spool pages In this mode Papirus integrates every spool page into a separate Template page This mode was designed for spool files in which all pages have the same format Sel
13. 08 01 98 silicon moflet for cp 751 sn including the following items Catalog No Description Model Quantity Unit Price Total 4 4 4 4 4 42 501 Sleeping youth nec2000 10 330 00 4 4 4 4 4 4 1 502 101 Seeting comfort nec9995 15 40 600 00 Total Ex Works 930 00 More F3 Exit F12 Cancel F19 Left F20 Right F24 More keys Figure 5 Display Spooled file Window This is a standard AS 400 Display Spooled file window activated by the dspsplf command A ruler indicating the column of each character in the spool appears at the top of the window Function Keys Function keys are located at the bottom of the window The following function keys are available from this window F3 Exit and return to previous window F12 Cancel and return to previous window F19 Move left F20 Move right Using the window Use the ruler and the navigation keys to familiarize yourself with the spool file Determine what is the maximal width of the spool file Compare the structure of the different pages Decide which formatting to apply on each section of the spool 11 Papirus Template 12 Step 2 Creating a lay
14. 1 next to it and pressing Enter Note It is possible to save output documents in graphic formats only if Papirus Image module has been purchased Papirus Template 28 Enter the full path of the desired PC folder in which to save output documents in the field Default output dir The desired path whether local or network must first be recognized by Windows on the Papirus PC server Default path is C Program Files Papirus Output on the Papirus PC server Press F10 to display additional fields Choose whether to delete the spool from the AS 400 output queue in the field Delete spool file Enter Y to delete the spool file from the output queue after printing Enter N to keep the spool file in the output queue after printing Enter S to keep the spool file in the output queue only if its status was set to SAVE Default option is N Choose whether to change spool attributes in the AS 400 output queue in the field Change spool file Enter H to hold the spool in the output queue after printing Enter F to set the spool s Formtype to PAPIRUS after printing Enter N not to change spool attributes in the outq Default option is N Fill in the desired password for email attachments in the field Password By default all email attachments sent by Papirus are Read Only documents In order to modify the attachment a password must be entered in MS Word Default password for all email attachments sent by Papirus i
15. Area definition window for the Purchase Order no area Area definition Design ID E Area ID 1 Description Purchase Order no Start indicator PURCHASE ORDER NO Position 14 Length 18 offset Search option F4 Area attributes 0 For end indicator Width 10 Length Figure 28 Purchase Order no Area Definition window Press F2 to save the area definition Defining dynamic areas The process of defining dynamic areas is demonstrated on the Catalog no area appearing in the spool sample in the beginning of the chapter The process must be repeated for every dynamic area in the spool Fill in a short description of the area in the field Description This description can help you identify the area in the area table If this field remains blank Papirus automatically enters the text of the start indicator as the description Start Indicator Fill in the text of the start indicator in the field Text Make sure the text you enter is identical to text appearing on the spool in both content and form The indicator is automatically searched in the test spool refer to Step 4 If it is not found a warning is displayed In the example the words Catalog No are entered Fill in the position of the start indicator in the spool file The position is the column number of the first letter of the chosen text Papirus Template 47 In the example the column number of the start indica
16. Figure 73 Email address Area Definition window Then assign a field ruler to this area The process of defining rulers was described in the Step 5 as well Further details are given here Using the Field ruler window Fill in a short description of the ruler in the field Description This description can help you identify the ruler in the Area table If this field remains blank Papirus automatically enters the control variable name as the description Locate the cursor in the field Field and press F4 to open a list of available control variables Select the desired control variable by typing 1 next to it and pressing Enter In the example the control variable is selected Enter a formatting string representing the names of all output devices in the field Formatting String In the example the formatting string abcde for general translation is entered Type N in the field Text is an object name Type N in the field Clear spool area Papirus Template 92 Field ruler Design ID URCHASE Ruler no Description EMAILTO EMATLTO Formatting string abcde Text is an object name Clear spool area Figure 74 EMAILTO Field ruler window Press F2 to save the ruler definition Papirus Template 93 Glossary of terms The following terms were introduced in the guide Constant area Control variable D Data queue
17. Invoice dot Template definition Design ID INV567X Template seq 600 Description Packing list Word document Packing Y N next pag FE F4 Template usag ME F4 Copies Packing dot Figure 64 Template definitions For each Template press F2 to save the definition Press F3 to return to the Design definition window Press F2 to confirm Replacing Template documents General Explanation Several different Templates can be assigned to one spool and be replaced dynamically to match the current version of the spool This can be achieved in a four steps process 1 Creating the Template documents in MS Word 2 Assigning the Templates to the spool 3 Defining an area that indicates the need to replace Templates 4 Assigning a Field ruler containing the name of the desired Template to the area The replacement of the Templates is performed automatically Papirus Template 79 Replacing Template documents Step by Step 1 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Type PPS in the 400 command line prompt and press Enter Type 2 for Spool Design and press Enter The Design Table window appears Locate the desired design in the design table Type 2 next to it and press Enter Press F7 to assign the Template document to the design Press F6 to define a new Template document For each Template fill in the desired sequence number in the fi
18. SPOOL TEXT WITH CONSTANT OBJECT S ccccsssssssscsscsscssesscssecsecsecsseseeseseescseeseeseesessesseascasenseneees Step lune ae date E de Using the Field ruler window sss REPLACING SPOOL TEXT WITH VARIOUS Step by Step istoc teet SU AUT OR eee e Uti e dee Using the Field ruler eoe ete e ee STEP 7 USING SEVERAL TEMPLATES eere retenta tento ttn tonta tentus satus snas MERGING SEVERAL TEMPLATE DOCUMENTS esee netten teen nennen Merging several Template documents Step by Step sert Using the Template table window eerte REPLACING TEMPLATE DOCUMENTS esee entrent Replacing Template documents Step by Step se ses REPLACING TEMPLATE DOCUMENTS sccssssssessesessesessescesescescsaessencssensescasescuecasescsecassecaesaenecaeseenecaeaeeneeeeaeease Using the Template table window eese Using the Field ruler window eee eee esee eese eese eset enin STEP 8 ROUTING SPOOLS TO DESIRED OUTPUT DEVICES Papirus Template Copyright 2003 by Sanskrit Software Systems Ltd 58 Moria Street Haifa 34401 Israel All Rights Reserved Information in this
19. Systems Ltd 2 Rachel St Haifa Israel Dear customer Further to your order dated July 1 purchase order 4 we are proud to present the following Sincerely Turtle Furniture Production Figure 69 Spool file Header Assume that the output document from this spool should always be sent by email to the email address service papirus400 com This can be achieved by inserting this email address into the control variable In order to do so define new area that indicates the need to send the spool by email In the example every area from the spool can be defined In this case the area of the word Attn is the defined area The process of defining areas was described in step 5 Area definition Design ID PURCHASE Area ID 2 Description Attn Start indicator Position Length Rows offset Search option Area attributes 0 For end indicator Width 30 Length Rows offset Figure 70 Attn Area Definition window Then assign a field ruler to this area The process of defining rulers was described in the Step 5 as well Further details are given here Papirus Template 89 Using the Field ruler window Fill in a short description of the ruler in the field Description This description can help you identify the ruler in the Area table If this field remains blank Papirus automatically enters the control variable name as the description Locate the cursor in the field
20. attributes set on the AS 400 Page break Whether to preserve the current page breaks of the spool Printer Name of the printer with which to print the output document Save document Whether to automatically save the output document in DOC format Print document Whether to automatically print the output document Save as image file Whether to automatically save the output document in a graphic format Image type Desired graphic format for the output document Default output dir Desired path on the PC in which to save output documents Test spool Spool sample used to test the design Additional Fields appear after pressing F10 Delete spool file Whether to delete the spool file from the AS 400 out queue after printing Change spool file Whether to change spool attributes in the AS 400 out queue after printing Document password Desired password for email attachments sent by Papirus Translation table Whether to replace a character from the spool file with a different character Using the window Fill in the new design name in the field DesignID The design ID must be identical to the spool userdata the spool userdata is one of the fields characterizing the spool on the AS 400 computer usually the name of the program that the spool has created Fill in a description for the design in the field Description This description can help you identify the design in the design table Locate the cursor in the field Layout document
21. etc Note Several control variables can be used in parallel in order to send one output document to various destinations Sending documents to constant destinations Step by Step 1 Type PPS in the AS 400 command line prompt and press Enter 2 Type 2 for Spool Design in the field Select and press Enter 3 Locate the relevant spool design in the list 4 Type 8 next to it and press Enter The Area Table window appears 5 Define the area indicating the need to send the spool to the desired destination 6 Assign a Field ruler to this area 7 in a description for the ruler in the field Description optional 8 Locate the cursor in the field Field and press F4 to open a list of Papirus control variables 9 Select the desired control variable by typing 1 next to it and pressing Enter 10 Enter the name of the output device in the field Formatting string 11 Enter N in the field Text is an object name 12 Enter N in the field Clear spool area 13 Press F2 to save the ruler definition Papirus Template 88 Assume that a copy from all output documents ought to be sent to one constant destination In order to do this define an area indicating the need to send the spool to the desired destination Then assign field ruler containing a control variable and the name of the output device The following figure contains the header of a spool file Attn Sanskrit Software
22. file Please confirm and advise shipping details Dani Sharon Purchasing Department Turtle Furniture Production Printing date 31 12 01 Figure 51 Spool file Signature Papirus Template 68 The signature part of the Template document for the spool might look like this Please confirm and advise shipping details signature Printing date date Figure 52 Template Signature Aassume that the signature should be replaced by an actual picture of this person This can be achieved by inserting the object Danisharon bmp into the variable signature in the Template document sincerely Figure 53 Danisharon bmp In order to do so define the area containing the name Dani Sharon The process of defining areas was described in the previous step Area definition F H 2 Description Signature Dani Sharon Position 48 Length Rows offset Search option Area attributes 0 For end indicator Width 11 Length Rows offset Figure 54 Signature Area Definition window Then assign a field ruler to this area The process of defining rulers was described in the previous step as well Further details are given here Using the Field ruler window Fill in a short description of the ruler in the field Description This description can help you identify the ruler in the Area table If this field remains blank Papirus automatically enters the variable name as the descript
23. from the spool file is integrated The Template determines the look of the output document it includes document settings such as page layout AutoText entries fonts special formatting and styles Each type of spool file intended to be printed by Papirus invoice packing list etc requires a separate Template document Once the Template document is complete Papirus automatically reuses it to produce MS Word documents Step by Step 1 Activate MS Word on the Papirus PC server 2 Openanew document 3 Apply desired page layout and margins settings according to the spool width 4 Leavethe first line of the document blank 5 Enter the constant text which does not change from one spool to another 6 Enter variables with the sign before and after instead of actual spool data 7 Add headers and footers AutoText and other desired features supported by MS Word optional 8 Save the document in DOT format in the library C Program Files VPapirus forms 9 Printthe document and close it Planning the Template document The Template is a Word document into which data from the spool file is integrated In order to plan the Template document you must first analyze the structure of the spool file Examine the following example of a spool file Papirus Template 14 Attn Alain Schmidt Mead Packaging Europe Al Du Bourb 5 Maurepas Cedex 78312 France Tel 331 305 7264 Fax 331 306 7019 PURCHASE ORDER
24. in the start indicator manually increase its length In the example the calculated length is the number of letters in the words PURCHASE ORDER NO which is 18 Fill in the number of separating lines between the start indicator and data in the field Rows Offset In the example the start indicator and the data are located in the same line so the rows offset is 0 Note The rows offset is always calculated from the start indicator downward Ignore the field Search option at this early stage this option is describes later on in the chapter Area Attributes Fill in the number of data lines in the field Lines In the example the number 21672 includes only one line Fill in the position of the data in the field Col The position is the column number of the first character of the data In the example the column number of the data is the column of the digit 2 which is 34 Fill in the maximal width of the data in the field Width Papirus Template 46 In the example the purchase order no is five digits long However a purchase order number is an ascending serial number and might be longer someday This one area definition must apply to all future purchase orders so the longest possible number ought to be entered Assume the longest possible number is 10 digits long End Indicator This part of the window is ignored when defining constant areas The following figure illustrates the
25. layout document by typing their respective number in the field Opt and pressing Enter 1 Select a layout document to be assigned to the design 2 Layout Document Parameters 3 Display Layout Document Parameters Papirus Template 25 Using the window Press to retrieve the names of any new layout documents from the Papirus PC server Only documents with the name lydoc from the folder C Program Files Papirus Forms are retrieved Note In order to perform this operation the Papirus PC server must be running Wait for the completion of the operation then press FS to refresh the list Locate the layout document created in step 2 type 1 next to it and press Enter to select it You may also select a layout document from the default set lydoc001 lydoc010 A default lydoc should be selected according to the spool width and language If itis a new layout document the Layout document parameters window appears The Layout document window The Layout document window appears after selecting a new layout document from the Layout document table window It is also accessed from the Layout document table window by pressing 2 and Enter next to an existing layout document Purpose of the window This window is used to define the spool width and language code 14 10 01 12 45 14 Sanskrit Sanskrit Systems F2 Update F3 Exit F12 Cancel Figure 16 Layout Document Parameters Window Functi
26. of available merging modes Select option 00 to merge with a page break between In this mode each page of the output document stands by itself Select option 01 to merge without any spacing In this mode the pages of the output document are combined without any spaces Select option 02 to merge with one separating line In this mode the page breaks of the output document are replaced with one separating line Default option is 00 The three merging modes are illustrated in the following figure With a page break between With no spacing With one spacing line Sq Turtle Furniture Production qu Turtle Furniture Production qu Turtle Furniture Production Order no 193776 Order no 193776 Order no 193776 Turtle Furniture Production 5 5 50 Please refer to our order number in all the Mm shipping documents and invoice p Sleeping baby Please refer to our order number in all the shipping documents and invoice e Turtle Furniture Production Please refer to our order number in all the shipping documents and invoice Sleeping king Figure 19 Merge next page mode Papirus Template 33 Locate the cursor in the field Template usage mode in order to select the manner of applying the Template document on the spool Press F4 to display a list of available usage modes Select option 0 to reuse the Template for each of the spool pages In this mode Papirus integrates every spool page into a separate Tem
27. the spool sample in the beginning of the chapter cannot be used as an indicator because it is valid only for spool files produced on this day However the structure of the date remains constant it consists of six digits separated by two slashes This structure represented by can be used as a valid indicator for all date fields Example no 2 Model Every item in a table of items has a different model The string nec2000 appearing in the spool sample in the beginning of the chapter cannot be used as an indicator because it is valid for only one specific item However the structure of the model remains constant it consists of three letters and four digits This structure represented by can be used as a valid indicator for all items Example no 3 Item description Every item in a table of items has a different description The string Seating comfort appearing in the spool sample in the beginning of the chapter cannot be used as an indicator because it is valid for only one specific item The structure of the item description is not constant It may consist of letters numbers signs slash hyphen apostrophe and also blanks However there are two constant parameters in the item description its maximal width is 15 characters and its first character is never blank This structure represented by can be used as a valid indicator for all items Papirus Templ
28. 0 files This option enables to export Papirus designs to AS 400 files for backup purposes or for copying designs from one AS 400 computer to another Saving a design to an AS 400 file Enter the Design table window and locate the desired design in the list Type 9 next to it and press Enter to save the design into a file The Save to file window appears Fill in the desired file name in the field file name and the desired library in the field library Press F2 to execute Loading a design from an AS 400 file Enter the Design table window and press F9 to load a design from a file The Load from file window appears Load from file Load design from file File name Library F2 Load F3 Exit Fi2 Cancel Figure 23 Load from file window Fill in the file name in the field file name and the library name in the field library Press F2 to execute Papirus Template 37 Protecting the design All designs in the Design table are in either Test mode or Production mode Designs in Test mode can be changed or deleted Designs in Production mode are Read Only designs that cannot be changed or deleted By default all designs are created in Test mode It is possible to protect a certain design by changing its mode to Production While in Production mode the design cannot be changed or deleted even if the respective operation code is typed Changing Design status Enter the Design table
29. 1 Fill in the maximal width of the data in the field Width In the example the catalog numbers are 9 digits long so their maximal width is 9 End Indicator Fill in the text of the end indicator in the field Text Make sure the text you enter is identical to text appearing on the spool in both content and form The indicator is automatically searched in the test spool refer to Step 4 If it is not found a warning is displayed In the example the words Grand Total are entered Papirus Template 48 Fill in the position of the end indicator in the spool file The position is the column number of the first letter of the chosen text In the example the column number of the end indicator is the column of the letter which is 44 Locate the cursor in the field Length and press Enter Papirus automatically calculates the number of characters in the end indicator In order to include blanks in the end indicator manually increase its length In the example the calculated length is the number of letters in the words Grand Total which is 11 Fill in the number of separating lines between the end indicator and data in the field Rows Offset The offset calculated by Papirus is always directed downward In order to direct the offset upward a negative offset must be entered In the example the end indicator is located one line below the data so the rows offset is 1 Note Only one negative offse
30. Assign the Templates to the spool The process of assigning Templates to spools was described in Step 4 Further details are given here Using the Template table window For each Template fill in the Template sequence number in the field Template seq The sequence number determines the order in which the Templates are used to produce the output document The Template with the lowest sequence number is used to produce the first page of the output document The Template with a higher sequence number is used to produce the second page of the output document and so on It doesn t matter which sequence numbers are entered as long as they consist of 3 digits and represent the correct order It is recommended to assign the number 500 to the most frequently used Template and assign other sequence numbers in relation to it In the example the Template invoice dot is assigned the sequence number 500 and the Template packing dot is assigned the sequence number 600 For each Template fill in a short description of the Template document in the field Description This description can help you identify the Template in the Template table For each Template fill in the name of the document without the DOT extension in the field Word document In the example the names invoice and packing are entered For each Template enter Y in the field Package if it should always be included in the creation of the
31. E RE RONSON bs EROR ie FIGURE TEMPLATE SIGNATURE eer eet La e a EO deve dete teet FIGURE PURCHASING AREA DEFINITION WINDOW cccecssssececesssececesssececesseeecessssaecescesseaeecessaaeeceseaaeesenenenes FIGURE A DEPNAME FIELD RULER WINDOW c ssessssecsscecesseeesseecsececessecesseccscecessecesseccsseecessecesseccssceceaaeeesees FIGURE OUTPUT DOCUMENT M ARKETING DEPARTMENT sssssesessssseecesseaeececesaeececesscececessaececenssaeceseesaecens FIGURE SPOOEEIEBE SIGNATURE 5 05 dee eiim ORE ee FIGURE EEMPLATE SIGNATURES ete eet eee le e i Ee awe aa aa FIGURE TRANSLATION OF THE DATE INTO LETTERS s ccessssesssecessecessecesseecsssecessecesseccssecessecessecesseecsscecesaecesaees FIGURE PRINTING DATE AREA DEFINITION WINDOW cssssccecesssececesssececessnseecescssaecesceaseaeecessaaeeceseaaeeseseeaes FIGURE ADATE FIELD RULER WINDOW s ssccccessscsccossnatecessnssccesenseesescsentceecessscescecsnacececenseececensnceecesenseesens FIGURE OUTPUT DOCUMENT PRINTING DATE ssssssccesssssecesssssecesessscseecssssaeecsessaeececesasececessaececeseaeaecessnnaeeees FIGURE SPOOL FIRE SIGNATURE RO EE le ES Rer eed FIGURE TEMPLATE SIGNATURE aede Eget ve erbe eur Tine baee oce erue ue to ue Ee e PEERS FIGURE DYANISH AR ON BMP AS FIGURE SIGNATURE AREA DEFINITION WINDOW cccsssssecesssssecesesseceecesssaeccscesseececessaececessaesecessasaesesseaaeeees
32. ID PURCHASI Ruler no 1 Description name Formatting string abcd gif Text is an object name Clear spool area Figure 61 name Field ruler window Press F2 to save the ruler definition The signature part of the output documents is illustrated in the following figure Please confirm and advise shipping details Purchase Department Turtle Furniture Production Please confirm and advise shipping details Purchase Department Turtle Furniture Production Please confirm and advise shipping details Purchase Department Turtle Furniture Production Figure 62 Output documents signatures Papirus Template 74 Step 7 Using several Templates The seventh step is assigning several Template documents to the same spool Spool files can be very complex which makes it impossible to create only one Template for them Even simple spool files sometimes require several Templates because every page in the output document should to have a different appearance In these cases several different Templates can be assigned to the same spool and produce one output document The different Templates can all be included or replaced dynamically to match the current version of the spool All Template documents assigned to the same spool are called a Package Merging several Template documents General Explanation Several different Templates can be merged to produce one output document This can be achieved i
33. LES IN THE TEMPLATE DOCUMENT eese eene enne nennen FIGURE TEMPLATE FOR A TABULAR SPOOL AREA sscccsssccsssssessscesssecessecessecessceceesecessecesseeceesecessecenseeceeaeceaeeens FIGURE T YPICAE TEMPEATEDOCUMBNT cess ok ode rette ree RR ska Er EU ERR GRE FIGURE POSSIBEE XGUTPUT DOGUMEN T 2z e eee e EE EN eb ce Napa ola e EN AER FIGURE DESIGN TABLE WINDOW TER ETE VON CO NS RETE FIGURE DESIGN DEFINITION WINDOW cari Peter REGE e rere V AREE FIGURE LAYOUT DOCUMENT TABLE WINDOW ccsssssccesssssccescsssceeecessnseecesenssecesssaecesesssesesceesuaeecseesaeeeseees FIGURE LAYOUT DOCUMENT PARAMETERS WINDOW ccssssssescesssceecesseseeceseaacecessssnecesesesesescseseaeecseesaeeeecnes FIGURE TEMPLATE TABLE WINDOW FIGURE TEMPLATE DEFINITION WINDOW cssssscccssssseececssscececescececessaececessssaesesessaecesceuaeaeccessaaeeceseaaeeseseaaes FIGURE MERGENEXTPAGE FIGURE REUSE FOR EACH OF SPOOLPAGES cssssessssseestcesscesssscecsecescsesesscecsecessesescaeceesecessesecessceceseseeaeeeaeeeenes FIGURE ONCE FOR THE COMPLETE SPOOL ssssscccssssssecesssssecesssssecesensaesescssseaeecsessaeececesauececsssaececesseeesesssuaeeess FIGURE IMPORT EROM PC WIND O Weise E FIGURE EQAD FROM FILE WINDOW ola eit TC EE GELT ER NUR NC FIGURE SPOOL RULE
34. NO 21672 DATE 20 01 98 Further to your order your quotation dd 08 01 98 silicon moflet for cp 751 sn including the following items 4 4 4 Catalog No Description Quantity Unit Price Grand Total 1087 00 4 2 2 4 Figure 7 Spool File This spool includes constant text and variable data The words Attn Purchase order no and Date for example are constant whereas the name Alain Schmidt the number 21672 and date 20 01 98 are different in every spool The distinction between constants and variables in the spool is the key to creating Template documents The constant text is written directly in the Template document in MS Word while the data is taken from the spool Still the Template determines the formatting of the data and its position on the page This is achieved by placing variables in the Template document The variables will later be replaced by the actual data from the spool which inherits their formatting and their location on the page Creating the Template document The Template document is created in MS Word on the Papirus PC server Open a new document and apply the desired page layout and margin settings If the spool is wide consider using a landscape page setup Leave the first line of the document blank then enter all the constant text which
35. Note The field Library refers to the output queue listed above it If this field remains blank Papirus searches the output queue in the available libraries list Spool List Window Purpose of the window This window displays a list of spool files sorted by the user name or output queue selected in the previous window Two types of spool files may appear in the list regular spools and highlighted spools The highlight indicates that formatting parameters for this spool have already been defined The formatting parameters for regular spools are yet to be defined Spool list QPADEVO012 1 Select 2 Edit 5 Display 6 Merge 7 Export to PC Spool Opt File Job Number Userdata Pages MCTO55P MCTO55P hyeshuv LETTRAPRT QSYSPPR QPRDEVOOOS 029409 QSYSPPR QPRDEVOOOS 029409 QSYSPPR QPRDEVOOO6 038383 QSYSPRT QPRDEVOOOS 061317 QPJOBLOG QPADEVO0010 066549 QPJOBLOG QPADEVOO04 066508 QPJOBLOG QPRDEVOOO4 066517 QPJOBLOG QPRDEVOOOS 066720 QSYSPPR DSP16 002938 QSYSPPR DSP16 002938 QPRDEVOOOS TURTLE1 moti D W e e e e e l N l F3 Exit 12 1 F17 Top F18 Bottom Figure 4 Spool List Window This window enables Displaying the spool for initial planning purposes Modifying spool attributes Selecting a spool to be converted into a MS Word document Sending the spool by fax or e mail using the Papirus built in address book Sending a short text message to cellular phones SMS Exporting spool and formatting pa
36. Production aue os e Please confirm and advise shipping details Mark Smith Purchasing Department Turtle Furniture Production Figure 57 Spool files Signatures The signature part of the Template document for these spools may look like this Please confirm and advise shipping details name Purchase Department Turtle Furniture Production Figure 58 Template Signature Assume that a graphic signature should replace the name appearing on the spool The signatures must be replaced dynamically to match the name appearing on the spool This can be achieved by inserting different objects into the variable name in the Template document Different objects can be inserted into one variable by using a formatting string representing the names of all objects Formatting strings include a constant number of characters therefore the names of all objects must consist of a constant number of characters as well In this example the names consist of the first four letters in their respective holder s name The suitable formatting string is abcd gif dani gif mark gif sara gif Figure 59 Signature files In order to replace the names define the area containing their first four characters The area must be defined by a general indicator which is valid for all names The process of defining areas was described in the previous step Papirus Template 72 Area definition Design ID PU
37. Production Turtle Furniture Production Invoice no invoiceno Invoice no 193776 mos Unit Price Sleeping comfort Sleeping king Seating deluxe 33 40 30 20 Ss Turtle Furniture Production Turtle Furniture Production ce invoicen Invoice no invoiceno o il ERE NN 150 150 Order number orderno Order number 656567 Payment Terms terms Order number 656567 Payment Terms 30 days Through bank Payment Terms 30 days Through City Bank NY branch Through City Bank NY branch Figure 32 Search option I Papirus Template 53 Select Search Option N default in order to include all indicators separated by page breaks The following figure illustrates the result of search option N for the indicator which represents the quantity Spool File Template document Output document li ip A Turtle Furniture Production Turtle Furniture Production Invoice no invoiceno Invoice no 193776 a co STeeping youth 33 Sleeping comfort Furniture Production Turtle Furniture Production Invoice no invoiceno Invoice no invoiceno ESSEN Order number orderno Order number 656567 Payment Terms terms Order number 656567 Payment Terms 30 days Through bank Payment Terms 30 days Through City Bank NY branch Through City Bank NY branch Figure 33 Search option N Papirus Template 54 Se
38. RCHASE Area ID 2 Description Signature Start indicator Please confirm Position 1 Length Rows offset Search option F4 Area attributes 0 For end indicator Width 4 Length Rows offset Figure 60 Signatures Area Definition window Then assign a field ruler to this area The process of defining rulers was described in the previous step as well Further details are given here Using the Field ruler window Fill in a short description of the ruler in the field Description This description can help you identify the ruler in the Area table If this field remains blank Papirus automatically enters the variable name as the description Enter the name of the variable from the Template without the signs in the field Field Upper or lower case letters are not important but make you sure the name you enter is identical to name of the variable in the Template document In the example the variable is entered Enter a formatting string representing the names of all objects in the field Formatting String In the example the formatting string is abcd gif is entered Type Y in the field Text is an object name to indicate that the text represents an object If the value N is entered into this field Papirus will simply enter the word abcd gif to the Template document Type N in the field Clear spool area Papirus Template 73 Field ruler Design
39. and press F4 to open the Layout Document Table The layout document defines the language code and the width of the spool Papirus Template 24 The Layout Document Table window Purpose of the window This window is used to assign a layout document to the design Layout document table 14 10 01 12 51 15 Sanskrit Sanskrit Systems 1 Select 2 Edit 5 Display Layout Document Description Rtl Width LYvDOCOO1 80 CHAR English Portrait LYVDO0CO02 132 CHAR English Landscape LVD0CO03 198 CHAR English Landscape LYDOCO04 80 characters LVDOCOOS5 132 CHAR Landscape LYDOCO06 HEBREW 198 LYDOCOO7 ENG 80 LYDOCOO8 A4 page _ LvDO0COO9 198 CHAR LTR Heb Eng Landscape LYD0CO13 200 characters landscape LYDOCO14 170 characters 81 132 198 80 132 198 81 80 198 200 170 More N N N Y Y Y N N Y Y Y F3 Exit F5 Refrsh F8 Retrieve from PC Figure 15 Layout Document Table Window Each name appearing in this table represents a corresponding layout document by the same name The real layout documents are saved in the folder C Program Files Papirus Forms on the Papirus PC server Function Keys Function keys are located in the bottom of the window The following function keys are available from the window F3 Exit window and return to previous window F5 Refresh list F8 Retrieve new layout documents from the Papirus PC server Operation Codes Several operation codes may be applied on each
40. ate 50 Note Wild cards indicators must meet the other requirements of regular indicators They must appear in all versions of the spool They must appear in the same position on the spool They must be located in a fixed distance from the data Defining areas with wild card indicators The process of defining areas based on wild cards indicators is similar to the process of defining regular areas The only difference is that wild cards are written in the field Text in the Area definition window instead of actual letters and numbers The area of the purchase order number 21672 appearing in the spool sample in the beginning of the chapter can be defined by the wild card indicator This indicator represents any five digits The following figure illustrates the Area definition window for this Purchase order number Area definition Design ID E Area ID 1 Description Purchase Order no Start indicator HEHEH Position E 34 Length Search option F4 Area attributes 1 0 For end indicator Width 10 Length offset Figure 30 Purchase Order no Area Definition window Defining dynamic areas without end indicators General explanation The main difference between text indicators and wild cards indicators is their number of appearances in the spool Text indicators are unique and usually appear only once in each page Wild card indicators are more common and can appear several times When an
41. ble in the Template document Papirus Template 57 Papirus V4 0 Field ruler 14 10 01 17 28 1 SSanskF Lt i os oie Sanskrit System Design ID YC1604TEST Ruler no 3 Description Fields nik F4 Formatting string F4 Text is an object name _ Y N Clear spool area _ Y N F2 Update F3 Exit Figure 38 Field ruler window Function Keys Function keys are located in the bottom of the window The following functions keys are available F2 Save definition and return to previous window Return to previous window without saving Fields The following fields appear in the window Design ID Name of the design automatically filled in by the system Ruler no Serial number of the ruler automatically assigned by the system Field Name of the variable in the Template Formatting string Manner of integrating spool data into the Template document Using the window Fill in a short description of the ruler in the field Description This description can help you identify the ruler in the Area table If this field remains blank Papirus automatically enters the variable name as the description Fill in the name of the corresponding variable from the Template without the signs in the field Field Upper or lower case letters are not important but make you sure the name you enter is identical to name of the variable in the Template document In the examp
42. chanism esee eee tentent LINKING AREAS TO VARIABLES sees nettes teste sense testet isis Defining a new ruler Step by Step sssseeseeeeeee eterne tenete enne tenentes DEFINING RU LERS etc e OU ete e E EEUU RM e sabe done YEAR REVUE I The Teese e v Ce e E UR FIELD RULER WINDOW c ccscsscssessesscsscescessssssssssccuscuscuseesessecaecaecsscsecsesseeseeseseesesssssesssscescescesessenaescaesaecaesaeeaeeenes Purpose of the window M F nctlonXKey5 ise eO RE REIR RUE Ue ERREUR GU e OR M Field ORTA RIPE Summary Linking variables to spool data sse tenentes STEP 6 REPLACING SPOOL TEXT eere rete e eret tunes tassa assa ta nenas eae ea ense REPLACING SPOOL TEXT WITH CONSTANT TEXT einen Step by Step ete e de SU UO Rete S Ue eb e e Using the Papirus Template REPLACING SPOOL TEXT WITH FILTERED TEXT seen Step DY Step icd he tUe re ere ED eere eres FORMATTING STRINGS nested e REOR ERE RH ie epe et i ete tede eed eei tr EE ERE Eee eR dedo Using the Field ruler window sss REPLACING
43. d many more First the desired objects are created in a suitable program on the PC and saved in the folder C Program Files Papirus Forms Then the area containing the original text is defined Finally a field ruler containing the names of the desired objects is assigned to the area Step by Step 1 Type PPS in the AS 400 command line prompt and press Enter 2 Type 2 for Spool Design and press Enter 3 Locate the relevant spool design in the list 4 Type 8 next to it and press Enter to open the Area Table window 5 Define the area to be replaced 6 Assign a Field ruler to this area 7 in a description for the ruler in the field Description optional 8 Fillin the name of the variable from the Template without the signs in the field Field 9 Enter a formatting string representing the names of all desired objects including the extension in the field Formatting string 10 Enter Y in the field Text is an object name 11 Enter N in the field Clear spool area 12 Press F2 to save the ruler definition Papirus Template 71 The following figure contains the signatures of several spool files Please confirm and advise shipping details Dani Sharon Purchasing Department Turtle Furniture Production E oa op oer PU MM Please confirm and advise shipping details Sarah Brightman Purchasing Department Turtle Furniture
44. d press Enter Note that the status of the field Test spool in the design definition window is now defined Continue using the Design definition window Press F2 to save the new design definitions and return to the Design Table window Locate the design in the Design Table Window type 2 next to it and press Enter to reopen the design definition window Press F7 to assign the Template document created in step 3 to the design The Template table window appears as described below The Template table window Purpose of the window This window is used to assign Template documents to the design Papirus V4 0 Template table 14 10 01 12 53 15 Sanskrit Sanskrit Systems C3034 2 Edit 3 Copy 4 Delete 5 Display t Seq no Description Word document 600 invoice YC30341 Bottom F3 Exit F5 Refresh F6 Neu Figure 17 Template Table Window Function Keys Function keys appear in the bottom of the screen The following function keys are available from the window F3 Return to previous window Papirus Template 30 F5 Refresh list F6 Assign a new Template document to the design Fields The following fields appear in the window Opt Operation code to be applied on a Template document Template seq Number of the Template document in the package ranging from 001 to 999 Description Free text describing the Template document Word document Name of the Template document Operation Codes Sev
45. d press Enter 10 Fill in the offset downward from the start indicator to the data in the field Rows offest 11 Select the suitable search option for this start indicator in the field Search option 12 Fill in the number of data lines in the area in the field Lines Type 0 if the number is unknown 13 in the position of the data in the field Col 14 the maximal width of the data in the field Width 15 in a unique end indicator whether text wild card signs in the field Text 16 Fillin the position of the end indicator in the field Col 17 Locate the cursor in the field Length and press Enter 18 in the offset downward from the end indicator to the data in the field Rows offest 19 Press F2 to save the area definition For dynamic areas only Papirus Template Dividing the spool into areas The spool must be logically divided into separate areas The division of the spool into areas is performed on one spool sample but should apply to all spool files of the same type Examine this example of a spool file mi exu Attn Alain Schmidt Mead Packaging Europe Al Du Bourb 5 Maurepas Cedex 78312 France 331 305 7264 331 306 7019 PURCHASE ORDER NO 21672 DATE 20 01 98 Further to your order your quotation dd 08 01 98 silicon moflet for cp 751 sn including the following items Catalog No Description Quan
46. document The Template is a MS Word document that includes settings such as page layout fonts AutoText entries special formatting and styles The Template determines the basic structure for the output document The conversion of spool files into Word documents is performed in eight steps Stepl Displaying the spool file in order to plan the desired output document Step2 Creating a Layout document that determins the spool s width and language code Step3 Creating the Template document into which data from the spool is integrated Step4 Assigning the layout and Template documents to the spool Step5 Dividing the spool into logical areas and linking them to the Template Step6 Replacing text from the spool with different text or objects Step7 Assigning additional Template documents to the spool Step8 Routing the spool to a desired output device Steps 6 is required only if the spool text needs to be replaced Step 7 is required only if the spool is very dynamic and has an undefined structure Each step is described in a separate chapter in this guide The work process is first described in a step by step summary at the beginning of each chapter and then thoroughly explained throughout the chapter The windows of the software are introduced in their order of appearance and illustrated by appropriate figures The function keys and operation codes available in each window are described as well Papirus Template
47. does not change from one spool to another You can place the text anywhere on the page and format it in any font size or color This text will appear in all output documents created by Papirus from this type of spool files Papirus Template 15 PURCHASE ORDER NO DATE Figure 8 Constant Text in the Template document Add variables in all the desired positions on the page instead of actual spool data Every section of the spool on which you would like to apply a different formatting must be represented by a separate variable Variables are strings of text with the sign before and after For example name Almost every combination of letters and digits can be used as a variable as long as it is written between two signs and does not include blanks Only the word line cannot be used as a variable because it is reserved for the Layout document Attn name address PURCHASE ORDER NO orderno DATE date Figure 9 Constant Text and variables in the Template document It is highly recommended to write the variables in transparent tables even for non tabular data because it keeps the resulting document in order If the spool data is suppose to be bold and underlined in the output document for example apply this desired formatting on the variable name As you addg the variables into the Template document make sure the entire variable name and signs is written in the same font and size If a c
48. e Template invoice dot is assigned the sequence number 500 and the Template packing dot is assigned the sequence number 600 For each Template fill in a short description of the Template document in the field Description This description can help you identify the Template in the Template table For each Template fill in the name of the document without the DOT extension in the field Word document Papirus Template 77 LT In the example the names cover invoice and packing are entered For each Template enter Y in the field Package to always include it in the creation of the output document For each Template locate the cursor in the field Merge next page mode in order to select the manner of merging the pages of the output document Press F4 to display a list of available merging modes Select option 00 default to merge with a page break between In this mode each page of the output document stands by itself Select option 01 to merge without any spacing In this mode the pages of the output document are combined without any spaces Select option 02 to merge with one separating line In this mode the page breaks of the output document are replaced with one separating line In the example merge next page mode 00 default is selected for all Templates For each Template locate the cursor in the field Template usage mode in order to select the
49. e spool to its corresponding variable in the Template The design also routes the spool to a desired output device Once the design is complete Papirus automatically reuses it to produce MS Word documents Step by Step 1 PPS in the AS 400 command line prompt and press Enter 2 2 for Spool Design in the field Select and press Enter The Design Table window appears 3 Press F6 to create a new design 4 Fillinthe name of the design in the field DesignID The design ID must be identical to the spool userdata 5 in a description for the design in the field Description 6 Press F4 in the field Layout document to display a list of layout documents 7 Press F8 to retrieve new lydocs from the Papirus PC server and F5 to refresh the list 8 Typelnextto the desired layout document and press Enter 9 Fill in a description for the lydoc in the field Description 10 Fill in the language code of the spool in the field RTL Language 11 Fill in the width of the spool in the field Width 12 Press F2 to confirm 13 Type 1 next to the desired layout document and press Enter 14 in all the additional design parameters optional 15 Assign a test spool to the design by pressing F9 optional 16 Press F2 to update design definitions 17 Locate the design in the Design table window 18 Type 2 next to the design and press Enter Papirus Template 19 19 Pr
50. e tentent i aE tR as Continue using the Design definition window eese eee tette netten THE TEMPLATE TABLE WINDOW shna a e E sE EEEa e Re E EE eee tee e b PurposeOf the wind oW ser a eiim EFE RE ERE edet pc tire RENA Function CY t Fieldsisue ducis I UR RED SUN TERI Operation CodeS eirt sd e eR e E IER I R THE TEMPLATE DEFINITION WINDOW Purpose Of the WIndOW iie et er e RUNE REESE EE HUE oe EUER EE TRES A F hctlonKeys eI SOEUR e mt EN E RR II EN D EE Using the Wind OW PD Continue using the Design definition window eese ertet tenete teen tenente SAVING LOADING DESIGNS FROM PC FILE cscsssscssescsscssescsecscsecaesscneceesecaeseesesaesesaesaesesacseesesaeeeeseacesseseesees Exporting spool and design to a PPW file Loading spool and design from a PPW file SAVING LOADING DESIGNS FROM AS FILES ves Saving a design to an AS 400 Loading a design from an AS 400 file eee esses PROTECTING THE DES GN erect te cete re eese Ee eie EE Eee re ER EE E EP EG ri Changing DESL GIS UALS cese eee e RERUM AR ERROR A AR USED STEP 5
51. ececessececessssaecesessaecescesasaeecesnaeeceseaaeesenseaes EMAILTO FIELD RULER WINDOW
52. ect option 1 to use the Template once for the complete spool In this mode Papirus integrates all the spool pages into one Template page This mode was designed for spool files in which every page continues the previous page Select option 3 to use the Template as is In this mode Papirus uses the Template to create the output document but does not integrate spool data into it This usage mode was designed for Templates containing only constant text which suppose to be added to the output document in a fixed position For Templates that should be included only in certain cases Select option 2 not to use the template at all In this mode Papirus does not use the Template to create the output document until instructed otherwise In the example usage mode 0 default is selected for the Templates invoice dot and usage mode 2 is selected for the Template packing dot The following figure represents the Template definition windows Template definition Design ID INV567X Template seq 500 Description Word document Invoice Y N next pag 4 Template usag Ae F4 Invoice dot Template definition Design ID INV567X Template seq 600 Description Packing list Word document Packing Y N next pag aes F4 Template usag D RAN F4 Packing dot Figure 66 Template definitions For each Template press F2 to save the definition Press F3 to return to the Design definition
53. eld Template seq For each Template fill in a description in the field Description For each Template fill in the name of the document without the DOT extension in the field Word document For the Template always included enter Y in the field Package For the Template included only in certain cases enter N in the field Package For each Template select the desired option in the field next page mode For the Template always included select the desired option in the field Template usage mode For the Template included only in certain cases select option 2 in the field Template usage mode For each Template press F2 to save the definition Press F3 to return to the Design definition window Press F8 to open the Area table window Define a new area that indicates the need to replace Templates Assign a Field ruler to this area Fill in a description for the ruler in the field Description optional Enter Papirus control variable TMPL_DOCNAME in the field Field Enter the name of the desired Template including the DOT extension in the field Formatting string Enter Y in the field Text is an object name Papirus Template 80 24 Enter N in the field Clear spool area 25 Press F2 to save the ruler definition 26 Press F2 to save the area definition 27 Press F3 to return to the Design de
54. eral operation codes may be applied on each Template document by typing their respective number in the field Opt and pressing Enter 2 Open the Template definitions for editing 3 Duplicate Template definitions 4 Delete Temp late definitions Press F2 in the dialog box that opens to confirm deleting 5 Display Template definitions Using the window When you first enter this window only the layout document appears in the table Delete it by typing 4 in the Opt field and pressing Enter Press F6 in order to assign a new Template document to the design The Template definition window appears as described bellow The Template definition window Purpose of the window This window is used to define the manner of applying the Template document on the spool file Papirus Template 31 Template definition 14 10 01 12 53 5 Sanskrit Sanskrit System Description invoice Mord document YC30341 Package Y Y N Merge next page mode __ Template usage mode _ F4 Caples i s v F2 Update F3 Exit Figure 18 Template Definition Window Function Keys Function keys are located in the bottom of the window The following function keys are available in the window F2 Update and exit window F3 Exit and return to previous window without saving Fields The following fields appear in the window Design ID Name of the design automatically filled in by t
55. erized archive or the Internet A single Papirus server provides print management and formatting services for the entire organization Alternatively several Papirus servers can be used in parallel to increase the print throughput Printer archiving After definition of the formatting parameters for Q company documents Papirus works behind the scenes and is transparent to the user TAA Figure 1 Papirus output management The only variable elements are the company documents themselves which are produced in a professional and attractive manner This is done in the following way an AS 400 application creates spool files which are placed on the AS 400 output print queue Papirus AS 400 component captures these spools and attaches pre defined formatting parameters fonts colors tables etc to create the final output documents It then sends the spools with their formatting parameters from the AS 400 to Papirus PC component The PC component reformats the spool using MS Word and sends the output document with its full graphic content to the desired output device Papirus can also convert spools into Excel spreadsheets The Papirus Excel module is described in a separate user s manual Papirus Template Introduction to Template Papirus Template module converts AS 400 spool files into formatted MS Word documents The creation of the Word documents is performed by integrating data from the spool into a Template
56. erline B Bold Page break _ Y N Printer F4 Save document N Y N Print document Y V N R Save as image file N Y N Image type __ F4 Default output dir Test spool not defined IF2 Update F3 Exit F7 Package F8 Areas F9 Test define F10 Rdditional parameters Figure 14 Design Definition Window Function Keys Function keys are located in the bottom of the window The following function keys are available in the window F2 Save definitions and return to previous window F3 Return to previous window without saving definitions FA Display a list of available Layout documents Active only when the cursor is located in the field Layout document F7 Enter the Template table window F8 Enter the Area Table window F9 Assign a test spool to the design F10 Display additional fields Fields The following fields appear in the window and may be filled in Design ID Name of the design This field is required Description Free text describing the design This field is required Layout document Name of the Layout document assigned to the design This field is required Data queue Name of the queue through which to transfer data from the AS 400 to the Papirus PC server Priority Spool priority in the data queue which determines the order of processing by tha DO Papirus Template 23 the PC Auto formatting Whether to reproduce formatting
57. erms terms Order number 656567 Payment Terms 30 days Through bank Payment Terms 30 days Through City Bank NY branch Through City Bank NY branch Figure 35 Search option Y L LIJ L l Papirus Template 55 Linking areas to variables Each defined area must be linked to the corresponding variable in the Template document so spool data will appear in the output document instead of variables Areas are linked to variables through rulers The ruler determines the name of the Template variable into which the data from the area is integrated Every area of the spool must be assigned to a separate ruler The following figure contains the header of a spool file Attn Alain Schmidt Mead Packaging Europe Al Du Bourb 5 Maurepas Cedex 78312 France 331 305 7264 331 306 7019 PURCHASE ORDER NO 21672 DATE 20 01 98 Figure 36 Spool File Header The Template document for this spool might look like this Attn name address Tel tel Fax fax PURCHASE ORDER NO orderno DATE date Figure 37 Template document Header The purchase order number 21672 is suppose to be integrated into the variable ordno in the Template document In order to do so a ruler must be assigned to the area Defining a new ruler Step by Step 1 Type PPS in the AS 400 command line prompt and press Enter 2 Type 2 for Spool Design in the field Select and press Enter 3 Locate the d
58. ertain section of the spool is suppose to appear several times in the output document place the corresponding variable in several locations in the Template Headers and footers AutoText WordArt images and other features supported by MS Word may also be added to the Template document see examples in the following pages Creating a Template for tabular spool areas Spool files often include tables which have an unknown number of rows In order to create the Template for such a spool area add a table with two rows one with the headers and the other with variables for the data If the spool table also includes a total add a third row to your Template table Papirus Template 16 Shipping Grand Total _ gtotal Figure 10 Template for a tabular spool area The one row of variables will be duplicated for each line of table data transferred from the spool Note The entire row is duplicated even if just one column contains data Don t place two variables in the same row if one represents a single spool line and the other several spool lines Saving the Template document Save the Template document in the forms directory on the Papirus PC server default is C Program Files Papirus Forms in DOT format document template Any name up to 20 characters may be chosen Printing the Template document Print the document Make sure you can print it without any dialog box appearing fo
59. esired design in the list 4 8 next to it and press Enter The Area Table window appears Papirus Template 56 5 Locate the desired area in the list 6 Type 8 next to it and press Enter The Ruler type window appears 7 Type 1 next to Field and press Enter The Field ruler window appears 8 in a description for the ruler in the field Description optional 9 in the name of the variable from the Template without the signs in the field Field 10 Type the string in the field Formatting string 11 Enter N in the field Text is an object name 12 Enter N in the field Clear spool area 13 Press F2 to save the ruler definition Defining rulers Enter the Area Table window and locate the desired area Type 8 next to the area and press Enter Since a ruler was yet to be defined the Ruler type window appears allowing you to select the desired type for the ruler Select the Field ruler by typing 1 next to it and pressing Enter When creating Template based designs only Field rulers are being used Other types of rulers are being used in rule based designs The Field ruler window appears as described bellow Field ruler window The window is accessed by typing 8 next to an area in the Area table window and pressing Enter or by pressing F8 in the Area definition window Purpose of the window This window links the spool area to the corresponding varia
60. ess F7 to assign a Template document to the design 20 Delete the definition of the layout document by pressing 4 and Enter 21 Press F6 to define a new Template document 22 Fillin the desired sequence number for the Template in the field Template seq 23 Fillin a description for the Template in the field Description 24 Fillin the name of the Template document without the DOT extension in the field Word document 25 Enter Y in the field Package 26 Select the desired option in the field Merge next page mode 27 Select the desired option in the field Template usage mode 28 Press F2 to save the definition 29 Press F3 to return to the Design definition window 30 Press F2 to confirm Entering Papirus on the AS 400 Type PPS in the AS 400 command line prompt and press Enter The Papirus main menu appears Type 2 for Spool Design in the field Select and press Enter The Design Table window appears as described below Design Table Window Purpose of the window This window enables management of all the designs that exist in the Papirus system The first time the design table is accessed it contains only the default and sample designs supplied with the system Note The default designs are empty and do not contain any formatting attributes When they are selected the Papirus output is identical to that of the original spool file Papirus Template 20
61. ext from the spool with different text or objects The new text and objects can be constant or change according to the spool text In order to replace spool text the relevant area must be defined Then a ruler is assigned to the area The ruler determines which text or object will replace the original spool text Replacing spool text with constant text The original text of the spool can be replaced by other predetermined constant text The area containing the original text is defined Then a field ruler containing the new desired text is assigned to the area Step by Step 1 Type PPS in the AS 400 command line prompt and press Enter 2 Type 2 for Spool Design in the field Select and press Enter 3 Locate the relevant spool design in the list 4 Type 8 next to it and press Enter The Area Table window appears 5 Define the area to be replaced 6 Assign a Field ruler to this area 7 in a description for the ruler in the field Description optional 8 Fillin the name of the variable from the Template without the signs in the field Field 9 Enter the desired text in the field Formatting string 10 Enter N in the field Text is an object name 11 Enter N in the field Clear spool area 12 Press F2 to save the ruler definition Examine the following spool and Template example Papirus Template 62 Please confirm and advise shipping details Dani Sharon Purcha
62. f areas can include constant text or variable data In the purchase order number area for example the words Purchase order no are constant whereas the number 21672 is variable In the catalog number area for example the header Catalo No is constant whereas the numbers 1 342 501 and 1 502 101 are variable The constant text was already written directly in the Template document so there is no need to transfer it from the spool Only the data should be transferred from the spool The constant text is merely used as a reference point to locate the data in the spool This constant text is called an Indicator because it indicates the location of the data in the spool Indicators must meet four requirements 1 They must contain constant text 2 They must appear in all versions of the spool 3 They must appear in the same position on the spool 4 They must be located in a fixed distance from the data Papirus Template 41 There are two types of indicators Start indicator that indicates the beginning of the data and End indicator that indicates the ending of the data When an indicator is found by Papirus its respective data is integrated into the Template document If an indicator is found several times its respective data is integrated into the Template at the same number of times All areas indicators and data must be defined in the design Constant areas are defined by a start indicator and by their constan
63. finition window 28 Press F2 to confirm The following figure illustrates the package for a complex spool which always includes an invoice but sometimes includes a packing list as well Each page has a different format and requires a separate Template document Spool file Invoice no 193776 Order number 656567 Payment Terms 30 days Through City Bank NY branch Packing list no 193776 Please refer to our S N in all shipping documents Template document qu Turtle Furniture Production Invoice no invoiceno Total Shipping Order number orderno Payment Terms terms Through bank Invoice dot Turtle Furniture Production Packing list no packingno Please refer to our S N in all shipping documents Packing dot Figure 65 Package Replacing Template documents Output document Turtle Furniture Production Invoice no 193776 Sleeping youth 10 33 Shipping 157 Order number 656567 Payment Terms 30 days Through City Bank NY branch D Turtle Furniture Production Packing list no 193776 Please refer to our S N in all shipping documents Nec9995 First create all desired Template documents in MS Word The process of creating Template documents was described in Step 3 NOTE Do not to place the same variable in two different Templates unless you want the spool data to appear in both pages of the output document Papirus Template 81
64. ginning of an area Word document into which data from the spool file is integrated Formatted Word document created by Papirus from the AS 400 spool file One of the fields characterizing the spool on the AS 400 computer usually the name of the program that the spool has created s4 99 String of text written in the Template document with the sign before and after Variables are replaced by data from the spool Signs representing different characters that can be used to compose indicators Represents any numeric character Represents any alphabetic character Represents any non blank character Represents any characters including blank Papirus Template 95 Table of Figures FIGURE PAPIRUS OUTPUT MANAGEMEN sscccsssccsssscesseecescecessecesseecscecessecesseecsscecessecesseccsseeceasecesseeceseecesaecenses FIGURE 5 NEC EUER E DIR RENE EO aa Sak ETE Bi dese FIGURE SPOOL PROCESS WINDOW is eek sees teet ERE ERRARE NEG E NTC ERE ERE ea FIGURE SPOOL EAST T S FIGURE DISPEAY SPOOEED EILE WINDONM i vete err ht EO EUG EN HE RETE FIGURE LXYOUTIOCUMENT iecit e eR Ee ERO REED ee aks else SERENA FIGURE SPOOL zero ONSE VORIGEN INVE e re NEW E FIGURE CONSTANT TEXT IN THE TEMPLATE eene nennen een nien FIGURE CONSTANT AND VARIAB
65. he field Field Upper or lower case letters are not important but make you sure the name you enter is identical to the name of the variable in the Template document In this example the variable DEPNAME is entered Enter the desired text in the field Formatting String This text will appear in the output document instead of the original spool text In this example the word Marketing is entered Type N in the field Text is an object name Type N in the field Clear spool area Field ruler Design ID Ruler no 1 Description Formatting string Marketing Text is an object name Clear spool area Figure 43 depname Field ruler window Press F2 to save the ruler definition The signature part of the output document is illustrated in the following figure Please confirm and advise shipping details Dani Sharon Marketing Department Turtle Furniture Production Printing date 31 12 01 Figure 44 Output document Marketing Department Replacing spool text with filtered text The original text of the spool can be replaced by a filtered version of this text The area containing the original text is defined Then a field ruler containing a formatting string is assigned to the area Papirus Template 64 Step by Step 1 Type PPS in the AS 400 command line prompt and press Enter 2 Type 2 for Spool Design in the field Select and pres
66. he system Template seq Number of the template document in the package ranging from 001 to 999 Description Free text describing the Template document Word document Name of the Template document Package Whether to always use this Template in the creation of the output document Merge next page mode Manner of merging the pages of the output document Template usage mode Manner of applying the Template document on the spool pages Copies Not in use Using the window Fill in the Template sequence number in the field Template seq The sequence number determines the order in which the Templates are used during the creation of the output document At this step the design is based only on one Template document therefore simply enter any 3 digits number refer to step 7 for further details Papirus Template 32 Fill in a short description of the Template document in the field Description This description can help you identify the Template in the Template table Fill in the name of the Template without the DOT extension in the field Word document Select whether to use the Template during the creation of the output document in the field Package Enter Y to use the Template Enter N to ignore the Template refer to step 7 for further details Locate the cursor in the field Merge next page mode in order to select the manner of merging the pages of the output document Press F4 to display a list
67. iables determine the destination for the output document printer email fax internet cellular phones etc Control variables are constructed of a sign followed by several characters for example EMAILTO The data placed in the control variable is the name of the desired output device The name may be constant or change according to the text of the spool In both cases this data will not appear in the output document itself Once the control variables are added to the design Papirus automatically routes the output document to the chosen destination Papirus control variables are listed in the following table Cancel document transmission by email or fax Email CC destination address list with separator is accepted Email attachment format D doc html T txt gif J jpg P pdf E EMAILP ROF Email sender exchange profile Papirus Template 86 Fax destination number list with separator is accepted Papirus Template 87 TMPL_PAGEUSE Include current page in the output document omit others Papirus can send emails through MS Outlook or directly through SMTP protocol Certain options are available only under SMTP configuration Refer to Papirus Email module user s guide for further details The output document can be saved in various formats Certain options are available only when the output document is saved in a graphic format JPG TIFF GIF BMP
68. indicator is found by Papirus its respective data is integrated into the Template document If an indicator is found several times the data is integrated into the Template at the same number of times This fact becomes useful when having to define dynamic areas without an end indicator available Papirus Template 51 In these cases define a constant area of one line which is based on a wild card indicator The wild card indicator will be found several times As a result the constant area will be duplicated and data from several lines will be integrated into the Template Defining dynamic areas without end indicators The process of defining dynamic areas without end indicators is similar to the process of defining constant areas The only difference is that a wild cards indicator is used as a start indicator Wild cards are written in the field Text in the Area definition window instead of actual letters and numbers The area of the catalog numbers 1 342 501 and 1 502 101 appearing in the spool sample in the beginning of the chapter can be defined by the wild card indicator This indicator represents the structure of all catalog numbers The following figure illustrates the Area definition window for the Catalog numbers Area definition Er Design ID E Area ID 2 Description Catalog no Start indicator HH tt HHH Position 2 Length Rows offset Search option F4 Area attributes 1
69. inition window Papirus Template 66 Then assign a field ruler to this area The process of defining rulers was described in the previous step as well Further details are given here Using the Field ruler window Fill in a short description of the ruler in the field Description This description can help you identify the ruler in the Area table If this field remains blank Papirus automatically enters the variable name as the description Fill in the name of the variable from the Template without the signs in the field Field Upper or lower case letters are not important but make you sure the name you enter is identical to name of the variable in the Template document In this example the name date is entered Enter the desired formatting string in the field Formatting String or press F4 to open a list of predefined formatting strings Select the desired formatting string by typing 1 next to it and pressing Enter In this example the formatting string de ab gh is entered Type N in the field Text is an object name Type N in the field Clear spool area ruler Design ID PURCHASI Ruler no 1 Description date Formatting string de ab gh Text is an object name Clear spool area Figure 49 date Field ruler window Press F2 to save the ruler definition The signature part of the output document is illustrated in the following figure P
70. ion Papirus Template 69 Enter the name of the variable from the Template without the signs in the field Field Upper or lower case letters are not important but make you sure the name you enter is identical to the name of the variable in the Template document In this example the name signature is entered Fill in the name of the desired object including the extension in the field Formatting String In this example the name danisharon bmp is entered Type Y in the field Text is an object name to indicate that the text represents an object If the value N is entered into this field Papirus will simply enter the word Danisharon bmp into the Template document Type N in the field Clear spool area Field ruler Desi PURCHASI Ruler no 1 Description signature Fiel Formatting string Danisharon bmp Text is an object name Clear spool area Figure 55 signature Field ruler window Press F2 to save the ruler and return to the Area table window The signature part of the output document is illustrated in following figure Please confirm and advise shipping details sincerely Printing date 31 12 01 Figure 56 Output document Dani Sharon Papirus Template 70 Replacing spool text with various objects The original text of the spool can be replaced by several PC objects of various formats BMP JPG GIF DOC XLS an
71. l shipping documents Packing dot Figure 63 Package 75 Output document gt Turtle Furniture Production Attn Alain Schmidt Mead Packaging Europe Al Du Bourb 5 Maurepas Cedex 78312 France Dear customer Further to your order dated July 14 we are proud to present the following invoice and packing list Sincerely Turtle Furniture Production Turtle Furniture Production Invoice no 193776 Shipping 1087 Order number 656567 Payment Terms 30 days Through City Bank NY branch Turtle Furniture Production Packing list no 193776 Please refer to our S N in all shipping documents Merging several Template documents Step by Step 1 Type PPS in the AS 400 command line prompt and press Enter 2 Type 2 for Spool Design and press Enter The Design Table window appears 3 Locate the desired design in the design table 4 Type 2 next to the design and press Enter 5 Press F7 to assign the Template documents to the design 6 Press F6 to define a new Template document 7 For each Template fill in the desired sequence number in the field Template seq 8 For each Template fill in a description in the field Description Papirus Template 76 9 Foreach Template fill in the name of the document without the DOT extension in the field Word document 10 For each Template enter Y in the field Package 11 For each Template select the desired option i
72. le the variable name ORDNO is entered Papirus Template 58 At this early stage simply enter the string in the field Formatting String This string instructs Papirus to integrate the data into the Template as it is without conversions for further details refer to Step 6 Enter N in the field Text is an object name Enter N in the field Clear spool area The following figure illustrates the Field ruler window for the purchase order number Field ruler Design ID PURCHASI Ruler no 1 Description ORDNO Formatting string tz Text is an object name Clear spool area Figure 39 ordno Field ruler window Press F2 to save the ruler definition Papirus Template 59 Summary Linking variables to spool data 1 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Type PPS in the AS 400 command line prompt and press Enter Type 2 for Spool Design in the field Select and press Enter Locate the relevant spool design in the list Type 8 next to it and press Enter to open the Area Table window Press F6 to define a new area Fill in a description for the area in the field Description optional Fill in a unique start indicator whether text or wild card signs in the field Text Fill in the position of the start indicator in the field Col Locate the cursor in the field Length and pre
73. lease confirm and advise shipping details Dani Sharon Marketing Department Turtle Furniture Production Printing date 12 31 01 Figure 50 Output document Printing date Papirus Template 67 Replacing spool text with constant objects The original text of the spool can be replaced by objects of various formats BMP JPG GIF DOC XLS and many more First the desired object is created in a suitable program on the PC and saved in the folder C Program Files Papirus Forms Then the area containing the original text is defined Finally a field ruler containing the name of the desired object is assigned to the area Step by Step 1 Type PPS in the AS 400 command line prompt and press Enter 2 Type 2 for Spool Design and press Enter 3 Locate the relevant spool design in the list 4 Type 8 next to it and press Enter to open the Area Table window 5 Define the area to be replaced 6 Assign a Field ruler to this area 7 in a description for the ruler in the field Description optional 8 Fillin the name of the variable from the Template without the signs in the field Field 9 Enter the name of the desired object including the extension in the field Formatting string 10 Enter Y in the field Text is an object name 11 Enter N in the field Clear spool area 12 Press F2 to save the ruler definition The following figure contains the signature of a spool
74. lect Search Option P in order to include only the first indicator in each page of the spool The following figure illustrates the result of search option P for the indicator which represents the quantity Spool File Template document Output document SM ip A Turtle Furniture Production Turtle Furniture Production Invoice no invoiceno Invoice no 193776 a Sleeping youth Furniture Production Turtle Furniture Production Invoice no invoiceno Invoice no invoiceno ie E T sikspuu tis 10 30 Shipping Order number orderno Order number 656567 Payment Terms terms Order number 656567 Payment Terms 30 days Through bank Payment Terms 30 days Through City Bank NY branch Through City Bank NY branch Figure 34 Search option P Select Search Option Y in order to include only the first indicator in the entire spool The following figure illustrates the result of search option Y for the indicator which represents the quantity Spool File Template document Output document a eee qu Turtle Furniture Production Furniture Production Invoice no invoiceno Invoice no 193776 zs Siesping ynuth AlJLI LILI Turtle Furniture Production Turtle Furniture Production Invoice no invoiceno ERR ESTERI Toa Total tota Shipping Order number orderno Order number 656567 Payment T
75. manner of applying the Template document on the spool Press F4 to display a list of available usage modes Select option 0 default to reuse the Template for each of the spool pages In this mode Papirus integrates every spool page into a separate Template page This mode was designed for spool files in which all pages have the same format Select option 1 to use the Template once for the complete spool In this mode Papirus integrates all the spool pages into one Template page This mode was designed for spool files in which every page continues the previous page Don t select option 2 at this stage Select option 3 to use the Template as is In this mode Papirus uses the Template to create the output document but does not integrate spool data into it This usage mode was designed for Temp lates containing only constant text which suppose to be added to the output document in a fixed position In the example usage mode 0 default is selected for all Templates Papirus Template 78 The following figure represents the Template definition windows Template definition Design ID INV567X Template seq 400 Description Cover Page Word document Cover Y N next pag 4 Template usag er F4 Copies Cover dot Template definition Design ID INV567X Template seq 500 Description Invoice Word document Invoice Y N next pag F4 Template usag ous F4 Copies
76. manual is subject to change without notice No part of this publication may be reproduced or distributed in any form or by any means electronic or mechanical for any purpose without the express written permission of Sanskrit Software Systems Ltd Papirus is a registered trademark of Sanskrit Software Systems Ltd AS 400 and IBM Client Access are a registered trademark of IBM Corporation Microsoft Windows Word Excel Office and Outlook are registered trademarks of Microsoft Corporation All other products or services referred to in this manual are the trademarks service marks or product names of their respective holders Papirus Template 5 Introducion to Papirus Papirus is a unique off the shelf software package providing comprehensive output management solutions for AS 400 Papirus offers on line connectivity between AS 400 applications and MS Office applications running under the Windows operating system on a personal computer By integrating the organizational management and data processing capabilities of the AS 400 with the advanced graphic capabilities of the popular Microsoft Word processor Papirus enables the organization to achieve a new level in documents quality In addition to the improvements in printing AS 400 capabilities Papirus enables the routing of the reshaped documents to any of the PC network printers sends them out by a fax or e mail and enables connectivity to other PC applications such as a comput
77. n a two steps process Creating the Template documents in MS Word 2 Assigning the Templates to the spool The merger of the Templates is performed automatically The following figure illustrates the package for a complex spool which always includes a cover page an invoice and a packing list Each page has a different format and requires a separate Template document Papirus Template Spool file Attn Alain Schmidt Mead Packaging Europe Al Du Bourb 5 Maurepas Cedex 78312 France Dear customer Further to your order dated July 14 we are proud to present the following invoice and packing list Sincerely Turtle Furniture Production Invoice no 193776 Order number 656567 Payment Terms 30 days Through City Bank NY branch Packing list no 193776 5 Please refer to our S N in all shipping documents Template document Turtle Furniture Production Attn name company street city country Dear customer Further to your order dated date we are proud to present the following invoice and packing list Sincerely Turtle Furniture Production Cover dot Turtle Furniture Production Invoice no invoiceno e eme Shipping shipping Order number orderno Payment Terms terms Through bank Invoice dot Turtle Furniture Production Packing list no packingno pm Too o E ome om Please refer to our S N in al
78. n the field next page mode 12 For each Template select the desired option in the field Template usage mode 13 For each Template press F2 to save the definition 14 Press to return to the Design definition window 15 Press F2 to confirm First create all desired Template documents in MS Word The process of creating Template documents was described in Step 3 NOTE Do not to place the same variable in two different Templates unless you want the spool data to appear in both pages of the output document Assign the Templates to the spool The process of assigning Templates to spools was described in Step 4 Further details are given here Using the Template table window For each Template fill in the Template sequence number in the field Template seq The sequence number determines the order in which the Templates are used to produce the output document The Template with the lowest sequence number is used to produce the first page of the output document The Template with a higher sequence number is used to produce the second page of the output document and so on It doesn t matter which sequence numbers are entered as long as they consist of 3 digits and represent the correct order It is recommended to assign the number 500 to the most frequently used Template and assign other sequence numbers in relation to it In the example the Template cover dot is assigned the sequence number 400 th
79. nt you have just defined type 1 next to it and press Enter to select it and return to the Design definition window Continue using the Design definition window The rest of the fields in the window are optional If they remain blank the default settings are used Fill in the name of the desired data queue through which to transfer spool data from the AS 400 to the PC in the field Data queue This field should be used only when the Papirus software is running on Papirus Template 27 several PC servers in parallel each monitoring a different queue Default option is to automatically send the spool data to a dataq called PAPII Fill in the desired design priority in the field Priority Designs with the highest priority priority 0 are processed first by the Papirus PC server Designs of the same priority are processed according to their arrival order to the data queue Enter N in the field Auto Formatting in order to ignore the formatting attributes set on the AS 400 Only when using ruler based designs Papirus can re produce Bold and Underline formatting set on the AS 400 by repeated printing on the same line also known as printing by ASA code Default option is N Choose whether to preserve the current page breaks of the spool in the field Page Break Enter Y to preserve the current page breaks of the spool Enter N to ignore page breaks in the spool file Default option is Y Locate the cursor in
80. ocument assigned to the design Status of the design Test Production Processing priority for the design in the data queue Papirus Template 21 Operation Codes Several operation codes may be applied on each design by typing their respective number in the field Opt and pressing Enter 2 Edit design definitions 3 Duplicate design 4 Delete design Press F2 in the dialog box that opens to confirm deleting 3 Display design definitions 8 Enter the Areas table allocated to the design 9 Save the design into an AS 400 file Using the window Press F6 in order to create a new spool design The Design Definition window appears as described below Design Definition Window The Design Definition window appears after pressing F6 in the design table window It is also accessed from the Design Table window by pressing 2 and Enter next to an existing design Purpose of the window The following operations may be performed from this window Assigning a Layout document to the spool Assigning a Template document to the spool Routing the spool to a desired output device Assigning a test spool to the design Papirus Template 22 Papirus V4 0 Design definition 14 10 01 12 39 29 Sanskrit Sanskrit Systems Design ID Description Layout document Data queue Auto formatting Lypoceee F4 22 Fs Priority 0 99 N A ALL N No U Und
81. on Keys Function keys are located in the bottom of the window The following function keys are available in the window Papirus Template 26 F2 Update and exit window F3 F12 Exit and return to previous window without saving Fields The following fields are available from the Layout Document window Layout document Name of the layout document automatically filled in by the system Description Free text describing the layout document Rtl Language Spool language code Width Number of characters in one line of the spool file Character width Estimated width in twips of one character in the output document Using the window Fill in a description for the lydoc in the field Description This description can help you identify the lydoc in the lydoc table Fill in the language code of the spool in the field RTL Language Enter Y for a Right to left language or N for a Left to right language Fill in the width of the spool in the field Width The width is represented by the maximal number of characters in one line of the spool and can be determined in the Display spooled file window refer to Step 1 Leave the field Character width blank The character width is the estimated width in twips of one character in the output document This field is meaningless to a Template based design and can remain blank Press F2 to save the changes and return to the Layout document table Locate the layout docume
82. out document The second step is creating a layout document lydoc in short The lydoc is a Word document serving as a baseline for the formatted output document The lydoc is saved on the Papirus PC server but provides two parameters regarding the spool file on the AS 400 its width and language code Once the layout document is complete Papirus automatically reuses it to produce MS Word documents Step by Step 1 Activate Microsoft Word on the Papirus PC server Open a new document Write the word line in the first line of the document A V N Save the document in the library CAProgram Files Papirus forms in DOT format under the name lydoc 5 Close the document Creating the layout document The layout document is created in MS Word on the Papirus PC server Open a new document and write the word line in the first line of the document This word will later be replaced by the spool text line Figure 6 Layout document Save the document in the forms directory on the Papirus PC server default is CAProgram Files Papirus Forms in DOT format document template The name of the document must consist of the word Lydoc followed by any three digits from 010 to 999 For example Lydoc100 Close the document and exit Microsoft Word Papirus Template 13 Step 3 Creating a Template document The third step is creating a Template document The Template is a Word document into which data
83. pearing in the beginning of this step The process must be repeated for every constant area in the spool Fill in a short description of the area in the field Description This description can help you identify the area in the area table If this field remains blank Papirus automatically enters the text of the start indicator as the description Papirus Template 45 Start Indicator Fill in the text of the start indicator in the field Text Make sure the text you enter is identical to text appearing on the spool in both content and form The indicator is automatically searched in the test spool refer to Step 4 If it is not found a warning is displayed In the example the words PURCHASE ORDER NO are entered Fill in the position of the start indicator in the spool file The position is the column number of the first letter of the chosen text In the example the column number of the start indicator is the column of the letter P which is 14 Note The column number can be read from the ruler at the top of the display spooled file window We recommend opening two AS 400 sessions in parallel The first session for viewing the spool file and determining the position of the areas The second session for defining the areas in the Area table window Locate the cursor in the field Length and press Enter Papirus automatically calculates the number of characters in the start indicator In order to include blanks
84. plate page This mode was designed for spool files in which all pages have the same format This usage mode is illustrated in the following figure Spool file Template document Output document Oa Turtle Furniture Production Turtle Furniture Production Invoice no no Invoice no 575765 gt Turtle Furniture Production x Turtle Furniture Production Invoice no no Invoice no 575765 08 1 Total YT Tovoice no Turtle Furniture Production Turtle Furniture Production java Invoice no 575765 1500 Figure 20 Reuse for each spool pages Select option 1 to use the Template once for the complete spool In this mode Papirus integrates all the spool pages into one Template page This mode was designed for spool files in which every page continues the previous page This usage mode is illustrated in the following figure Papirus Template 34 Spool file Template document Output document Attn Alain Schmidt Turtle Furniture Production a Turtle Furniture Production Mead Packaging Europe Attn name Attn Alain Schmidt Invoice no 575765 Mead Packaging Europe Invoice no no Further to your order Invoice no 575765 Qty Further to y our order Please refer to our order number in all the shipping documents and invoice Sleeping baby Seating deluxe a oa a Item Oty Sleeping queen Sleeping baby Please
85. r assigned to the area Ruler Description Free text describing the ruler Papirus Template 43 Operation Codes Several operation codes may be applied on each spool area by typing their respective number in the field Opt and pressing Enter 2 A Edit area definitions 3 Duplicate area to create a new area 4 Delete area Press F2 in the dialog box that opens to confirm deleting 3 Display area definitions 6 Delete the ruler assigned to the area does not delete the area itself 8 Create new ruler or edit an existing ruler 9 Enable Disable ruler Using the Table Area window Press F6 in the Table Area window in order to define a new area The Area definition window appears as described below Area Definition Window The window is accessed by pressing F6 in the Area table window to define a new area or by typing 2 next to an existing area in the Area Table and pressing Enter Purpose of the window This window is used to define spool areas which will later be linked to variables in the Template document Papirus V4 0 14 10 01 12 56 2 Sanskrit Sanskrit System Design ID VC3034 Area ID 33 Description Start indicator TRE Position ES Length Rows offset __ Lines 90 end indicator Position Width ___ for edit substitute amp cell ruler End indicator A eS Po
86. r example a dialog box saying the margins are out of range The printout will be useful later on Papirus Template Turtle Furniture Production Buffalo NY 14616 Tel 71 8 6564444 Fax 718 6563333 Attn name address PURCHASE ORDER NO orderno DATE date abovetable Shipping ship Grand Total gtotal conditions Please confirm and advise shipping details signature Figure 11 Typical Template document Turtle Furniture Production Buffalo NY 14616 T Tel 718 6564444 Fax 718 6563333 Attn Alain Schmidt Mead Packaging Europe Al Du Bourb 5 Maurepas Cedex 78312 France PURCHASE ORDER NO 21672 DATE 20 01 98 Further to your order your quotation dd 08 01 98 silicon moflet for cp 751 sn including the following items Catalog No Quantity Sleeping youth __ 330 00 1 502 101 600 00 Shipping o nso 1 Delivery by airfreight with Fritz companies 2 Original invoice must be attached to the airwaybil 3 Terms of payment cash against document 4 Through City Bank NY branch Please confirm and advise shipping details sincerely Figure 12 Possible output document Papirus Template 18 Step 4 Assigning Lydoc and Template to the spool The fourth step is connecting the lydoc and Template document created in the previous steps to the spool file This connection is called a design The design links every section of th
87. ram Files Papirus Remote in PPW format This file format includes a spool sample and its design definitions Exporting spool and design to a PPW file Activate Papirus PC component refer to Papirus Word User s Guide for further details Enter the Spool List window refer to Step 1 and locate the desired spool in the list Type 7 next to it and press Enter to save the design into a PPW file The Export to PC window appears Fill in the desired file name without the ppw extension in the field PC file name Press F2 to execute Note The PPW file may be sent by email to be examined by Sanskrit s Technical Support Team It is recommended to compress the file in Winzip before sending in order to protect it Loading spool and design from a PPW file Activate Papirus PC component refer to Papirus Word User s Guide for further details Save the file in the remote directory on the Papirus PC server default is C Program Files Papirus Remote Enter the Spool process window refer Step 1 and press F7 to load a design from a ppw file The Import fro m PC window appears 14 10 01 12 31 38 Import from PC Directory File name F2 Import F3 Exit F12 Cancel Figure 22 Import from PC window Fill in the file name without the ppw extension in the field PC file name Press F2 to execute Papirus Template 36 Saving Loading designs from AS 40
88. rameters to the PC Papirus Template 10 Function Keys Function keys are located at the bottom of the window The following function keys are available from this window F3 Exit and return to previous window F12 Cancel and return to previous window F17 View top of spool list F18 View end of spool list Operation Codes Several operation codes may be applied on each spool by typing their respective number in the field Opt and pressing Enter 1 Send spool to MS Word 2 Change attributes of a spool file in the AS 400 system CHGSPLFA 3 Display spool on screen 6 Merge several spools into one spool that can be sent to Word 7 Export spool and the formatting parameters to the PC refer to Step 4 Using the window Locate the desired spool by scrolling through the list using the Page Up and Page Down keys It is possible to jump to the top of the list by pressing F17 or to the end by pressing F18 Select the desired spool to display by typing 5 next to it and press Enter The selected spool is displayed in the Display Spooled file window Display Spooled file Window Purpose of the window This window displays the spool file allowing prior planning of the desired output document Papirus Template Display Spooled File PLIE 20 QSYSPPR Page Line 1 17 Control e Columns 1 78 Find PURCHASE ORDER NO 21672 DATE 20 01 98 Further to your order your quotation dd
89. refer to our order number in all the shipping documents and invoice Please refer to our order number in all the shipping documents and invoice Figure 21 Once for the complete spool Select option 2 not to use the template at all In this mode Papirus does not use the Template to create the output document until instructed otherwise This usage mode was designed for dynamic spool files which their format is different in every version of the spool refer to step 7 for further details Select option 3 to use the Template as is In this mode Papirus uses the Template to create the output document but does not integrate spool data into it This usage mode was designed for Templates containing only constant text which suppose to be added to the output document in a fixed position For example a Template containing constant general terms which should be added as a prefix at the end of the output document Default option is 0 Press F2 to save the Template definitions and return to the Template table window Press F3 to return to the Design Definition window Continue using the Design definition window Press F2 to update the design definitions Papirus Template 35 Saving Loading designs from PC file This option enables to export Papirus designs to PC files for backup purposes or for transferring designs between AS 400 systems The files are created on the Papirus PC server in the remote directory default is C Prog
90. s 777 Enter a sign to send email attachments unprotected Note It is possible to send spool files as email attachments only if Papirus Email module has been purchased Choose whether to replace a character from the spool file with a different desired character in the field Translation Table Enter the original character in the field From and the desired character below it in the field Assign a test spool to the design as described below Test spool Each design can be assigned a test spool on which formatting definitions are applied The test spool provides two advantages 1 Immediate feedback on design results When a test spool is defined it is possible to automatically activate Microsoft Word Viewer on the Papirus PC server displaying the output Word document 2 Detection of wrong parameters entered during the process of linking Template variables to spool data refer to step 5 for further details Assigning a test spool to the design Press F9 from the Design definition window to open the Select test Spool window Papirus Template 29 Direct Papirus to the AS 400 user or output queue in which the desired spool file is stored and press F2 to confirm Locate the desired spool by scrolling through the list using the Page Up and Page Down keys It is possible to jump to the top of the list by pressing F17 and to the bottom by pressing F18 Select the desired spool by typing 1 next to it an
91. s Enter 3 Locate the relevant spool design in the list 4 Type 8 next to it and press Enter to open the Area Table window 5 Define the area to be replaced 6 Assign a Field ruler to this area 7 Eill in a description for the ruler in the field Description optional 8 Fill in the name of the variable from the Template without the signs in the field Field 9 Enter the desired formatting string in the field Formatting string or press F4 to select the formatting string from a list 10 Enter N in the field Text is an object name 11 Enter N in the field Clear spool area 12 Press F2 to save the ruler definition Formatting strings The original text from the spool can be filtered to create new strings of text Papirus filters are called Formatting Strings Various formatting strings are available each applying a different filter for example Rearranging the order of the characters Mixing spool text with new constant characters Encoding spool text into barcodes Translating lower case letters into upper case letters and vice versa etc Formatting strings are constructed from characters appearing between brackets for example abcde These characters are replaced by the spool text in the following manner an a character within is replaced by the first character from the defined area A b within is replaced by the second character from the defined area and
92. senting the names of all output devices in the field Formatting string 11 Enter N in the field Text is an object name 12 Enter N in the field Clear spool area 13 Press F2 to save the ruler definition The name of the desired output device can be taken directly from the text of the current spool In order to do this the area containing the name of the output device must be defined Then a field ruler containing a control variable and a formatting string must be assigned to that area The following figure contains the header of a spool file Attn Sanskrit Software Systems Ltd 2 Rachel St Haifa Israel Email service papirus400 com Dear customer Further to your order dated July 14 we are proud to present the following purchase order Sincerely Turtle Furniture Production Figure 72 Spool file Header Assume that the output document from this spool should be sent by email to the email address appearing on the spool This can be achieved by inserting the email address into the control variable EMAILTO In order to do so define the area of the email address The process of defining areas was described in Step 5 Papirus Template 91 Area definition Design ID PURCHASE Area ID Description Email address Start indicator Position Length Rows offset Search option Area attributes O For end indicator Width 30 Length Rows offset
93. sesnssessssessssessssessseeseees Step Dy Step aea e ee RBRUM E Re te ERR UTR PLANNING THE TEMPLATE DOCUMENT CREATING THE TEMPLATE DOCUMENT cerent nennen enne then than sensi tes testas Creating a Template for tabular spool areas Saving the Template document esses Printing the Template document STEP 4 ASSIGNING LYDOC AND TEMPLATE TO THE SPOOL eee eenentans StepzbysStep s cese dne Ue TOU ade mee tere ENTERING PAPIRUS ON THE AS 400 ccccccscssssessescssescsscsscscscescsscsscecsscsssecsscsesecsssscsescassecaessssecaesecnscaeeecaecaseesaes DESIGN TABLE WINDOW aneren aeee E daxeatuatestvocess o Purpose of the window Function Keys sss Fields s Operation Codes Usine the Wind ERE DESIGN DEFINITION W INDOW Purpose of FUNCHON Co T Sea ease hese a aa Fields Using the window iss THE LAYOUT DOCUMENT TABLE WINDOW Purpose of the window Function Keys Operation Codes IU TIAM ts THE LAYOUT DOCUMENT WINDOW Papirus Template Continue using the Design definition window eese eese teet TEST 5 4 ect Ot sis sed Dee e eU e ee eR E RU ree EE vei toe Y Assigning a test spool to the design esistente tett
94. sing Department Turtle Furniture Production Printing date 31 12 01 Figure 40 Spool file Signature Please confirm and advise shipping details name depname Department Turtle Furniture Production Printing date date Figure 41 Template Signature The word Purchasing from the spool should be replaced by the word Marketing to create the string Marketing Department This can be achieved by inserting the word Marketing into the variable depname in the Template document In order to do so define the area containing the word Purchasing The process of defining areas was described in the previous step Area definition Design ID PURCHASE Area ID 2 Description Purchase Start indicator Purchasing 48 Length 10 Rows offset _ Search option F4 Area attributes 0 For end indicator Width 10 Length Rows offset Figure 42 Purchasing Area Definition window Then assign a field ruler to this area The process of defining rulers was described in the previous step as well Further details are given here Using the Field ruler window Fill in a short description of the ruler in the field Description This description can help you identify the ruler in the Area table If this field remains blank Papirus automatically enters the variable name as the description Papirus Template 63 Fill in the name of the variable in the Template without the signs in t
95. sition Col Length Rows offset 0 F2 Update F3 Exit F8 Rulers Figure 27 Area Definition window Papirus Template 44 This window is divided into 3 parts Start Indicator Area Attributes and End Indicator The Start Indicator part refers to the constant text indicating the beginning of the data The Area Attributes part refers to the data itself The End indicator part refers to the constant text indicating the end of the data This part is used only when defining dynamic areas Function Keys Function keys are located in the bottom of the window The following function keys are available F2 Save definition and return to previous window F3 Return to previous window without saving F8 Assign a ruler to the area Fields The following fields appear in the window and may be filled in Design ID Name of the design automatically filled in by the system Area ID Serial number of the area automatically assigned by the system Description Free text describing the area Start indicator Constant text indicating the beginning of the data Area attributes Parameters describing the data to be integrated into the Template document End indicator Constant text indicating the end of the data for dynamic areas only Using the window Defining constant areas The process of defining constant areas is demonstrated on the Purchase order no area of the spool sample ap
96. so on up to 7 and subsequently from A to Z Regular characters not appearing between brackets remain constant and are not replaced by spool text The following figure contains the signature of a spool file Papirus Template 65 DIM isc acoso tl srarel atin shane Govan win Please confirm and advise shipping details Dani Sharon Purchasing Department Turtle Furniture Production Printing date 31 12 01 Figure 45 Spool file Signature The signature part of the Template document for the spool might look like this Please confirm and advise shipping details name depname Department Turtle Furniture Production Printing date date Figure 46 Template Signature Assume that the date 31 12 01 in format DD MM YY should be replaced by the date 12 31 01 in format MM DD YY 3 1 12 0 1 abcdefgh Figure 47 Translation of the date into letters This can be achieved by using the formatting string de ab gh and inserting the filtered date into the variable date in the Template document In order to do so define the area containing the date The process of defining areas was described in the previous step Area definition Design ID E Area ID 2 Description Printing date Start indicator Printing date Position 1 Length offset Search option F4 Area attributes 0 For end indicator Width 8 Length offset Figure 48 Printing date Area Def
97. ss Enter Fill in the offset downward from the start indicator to the data in the field Rows offset Select the suitable search option for this start indicator in the field Search option Fill in the number of lines of the data in the field Lines Type 0 if the number is unknown Fill in the position of the data in the field Col Fill in the maximal width of the data in the field Width Fill in a unique end indicator whether text or wild card signs in the field Text Fill in the position of the end indicator in the field Col Locate the cursor in the field Length and press Enter Fill in the offset downward from the end indicator to the data in the field Rows offset Press F8 to assign a new ruler to the area The Ruler type window appears Type 1 next to Field and press Enter The Field ruler window appears Fill in a description for the ruler in the field Description optional Fill in the name of the variable from the Template without the signs in the field Field Type in the string in the field Formatting string Enter N in the field Text is an object name Enter N in the field Clear spool area Papirus Template 26 Press F2 to save the ruler definition 27 Press F2 to save the area definition For dynamic areas only 60 Papirus Template 61 Step 6 Replacing spool text The sixth step is replacing t
98. t is allowed When entering the negative offset type the number before the minus sign The following figure illustrates the Area definition window for the Catalog no area Area definition ny F m 2 Description Catalog no Catalog No Position 2 Length Rows offset Search option F4 Area attributes 0 For end indicator Width 9 Grand Total 44 Length Rows offset Figure 29 Catalog numbers Area Definition window Press F2 to save the area definition Papirus Template 49 Wild card indicators AS was previously mentioned only when Papirus finds the start indicator of an area its respective data is integrated into the Template document In order to be found indicators must contain constant text Certain spool files include only data so constant text indicators are not available In these cases it is possible to use indicators that have a constant structure instead of constant text This type of indicators can be composed from Papirus wild card signs 4 Represents any numeric character 0 9 Represents any alphabetic character A Z a z Represents non blank character Represents any character including blank These wild card signs can be mixed and matched to compose indicators as demonstrated in the following examples Example no 1 Date Most spool files include their production date This date changes on a daily basis The date 20 01 98 appearing in
99. t number of lines The start indicator indicates the beginning of the area The number of lines represents the length of the area The purchase order number 21672 is part of a constant area It is defined by the start indicator PURCHASE ORDER NO and by the fact it includes one line Dynamic areas are defined by a start indicator and by an end indicator The start indicator indicates the beginning of the area and the end indicator indicates the end of the area The catalog numbers 1 342 501 and 1 502 101 are a dynamic area They are defined by the start indicator Catalog No and by the end indicator Grand Total In order to define the areas in the design enter Papirus on the AS 400 Entering Papirus on the AS 400 Type PPS in the AS 400 command line prompt and press Enter The Papirus main menu appears Type 2 for Spool Design in the field Select and press Enter The Design Table window appears refer to Step 4 Locate the relevant design in the list type 8 next to it and press Enter to open the Area Table window as described below Area Table Window The window is accessed by typing 8 next to a design in the Design Table and pressing Enter or by pressing F8 from the Design definition window Purpose of the window This window is used to define new areas in the spool and to edit already existing areas The window is also used to assign rulers to areas Papirus Template 42
100. the field Printer in order to route the output document to one desired printer Press F4 to display a list of available printers Only printers which have been previously defined on the Papirus PC server appear in the list refer to Papirus Word User s Guide for further details Locate the desired printer in the list type 1 next to it and press Enter If the output document is suppose to be printed by several different printers leave this field blank and refer Step 8 for further details Choose whether to automatically save the output document in DOC format in the field Save document Enter Y to save the output document The file name will be assigned automatically with a serial number Enter N not to save the output document Default option is N Choose whether to automatically print the output document in the field Print document Enter Y to automatically print the output document Enter N not to print the output document Default option is Y Choose whether to automatically save the output document in a graphic format in the field Save as image file Enter Y to automatically save the output document in a graphic format the format is determined in the next field Enter N not to save the output document in a graphic format Default option is N Locate the cursor in the field Image type and press F4 to display a list of available graphic formats Select the desired graphic format for the output document by typing
101. tity Unit Price Total 1 342 501 Sleeping yout nec2000 l 502 101 Seating comfort nec9995 Grand Total Figure 24 Spool file This spool can be logically divided into 14 separate areas in the following way l Name Address Telephone number Fax number Purchase order number Date Remarks above the table Catalog no in the table 0 n1 OQ n Boo Dm Description in the table Model in the table EUN Quantity in the table N Unit price in the table Total in the table me e WwW Grand total The following figure illustrates the separate areas of the spool file Papirus Template 40 RAE NER AEN Mead Packaging Europe Al Du Bourb 5 Maurepas Cedex 78312 France Tel 331 305 7264 Fax 331 306 7019 PURCHASE ORDER NO 21672 DATE 20 01 98 1 342 501 Sleeping youth nec2000 1 502 101 Seating comfor nec9995 Figure 25 Areas of the spool file Note Each spool can be divided up to 150 different areas There are two types of areas in the spool 1 Areas with a constant number of lines for example the purchase order number The purchase order number is always composed of one line These areas are called Constant areas 2 Areas with a dynamic number of lines for example the catalog numbers in the table The number of lines in this column changes according to the number of items ordered by the customer These areas are called Dynamic areas Both types o
102. tor is the column of the letter C which is 2 Note The column number can be read from the ruler at the top of the display spooled file window We recommend opening two AS 400 sessions in parallel The first session for viewing the spool file and determining the position of the areas The second session for defining the areas in the Area table window Locate the cursor in the field Length and press Enter Papirus automatically calculates the number of characters in the start indicator In order to include blanks in the start indicator manually increase its length In the example the calculated length is the number of letters in the words Catalog No which is 11 Fill in the number of separating lines between the start indicator and data in the field Rows Offset In the example the start indicator is located two lines above the data so the rows offset is 2 Note The rows offset is always calculated from the start indicator downward Ignore the field Search option at this early stage this option is described later on in the chapter Area Attributes in 0 in the field Lines to represent an unknown number of lines in the area In the example the number of lines is unknown so 0 is entered Fill in the position of the data in the field Col The position is the column number of the first character of the data In the example the column number of the data is the column of the digit 1 which is
103. window Press F8 to open the Area table window Define a new area that indicates the need to replace Templates Papirus Template 83 In the example every area from the packing list can be defined In this case the area of the title Packing list no is the defined area The process of defining areas was described in step 5 Area definition Design ID Area ID 16 Description Packing List Start indicator Packing list no Position 35 Length Rows offset Search option F4 Area attributes 1 O For end indicator Width 16 Length Rows offset Figure 67 Packing list Area Definition window Assign a Field ruler to this area The process of defining rulers was described in step 5 Further details are given here Using the Field ruler window Fill in a short description of the ruler in the field Description This description can help you identify the ruler in the Area table If this field remains blank Papirus automatically enters the variable name as the description Locate the cursor in the field Field and press F4 to open a list of Papirus control variables Locate the control variable TMPL_DOCNAME by pressing the Page Down key and select it by typing 1 next to it and pressing Enter This control variable instructs Papirus to replace the Template document Fill in the name of the desired Template document including the DOT extension in the field Formatting String In the e
104. window and locate the desired design in the list If the field Test Prod is blank the design is in Test mode and can be edited If the word Production appears in the field Test Prod the design is in Production mode and cannot be edited In order to change a design s mode type 6 next to the desired design and press Enter Papirus Template 38 Step 5 linking variables to spool data The fifth step is linking variables in the Template to data from the spool so the data will replace the variables and appear in the output document The linking of variables to data is part of the spool design In order to link variables to data the spool must be logically divided into separate areas Then each area is linked to the corresponding variable in the Template document Spool areas are linked to Template variables through a ruler Step by Step 1 PPS in the AS 400 command line prompt and press Enter 2 Type 2 for Spool Design in the field Select and press Enter 3 Locate the relevant design in the list 4 8 next to it and press Enter The Area Table window appears 5 Press F6 to define a new area 6 Fill in a description for the area in the field Description optional 7 Eill in a unique start indicator whether text or wild card signs in the field Text 8 Fillinthe position of the start indicator in the field Col 9 Locate the cursor in the field Length an
105. xample the name packing dot is entered Type Y in the field Text is an object name to indicate that the text represents an object N in the field Clear spool area Papirus Template Field ruler Design ID x INVOICE Ruler no 16 Description STMPL DOCNAMI Formatting string Packing dot Text is an object name Clear spool area Figure 68 Replace Template Field ruler window Press F2 to save the ruler definition Press F2 to save the area definition Press F3 to return to the Design definition window Press F2 to confirm 84 Papirus Template 85 Step 8 Routing spools to desired output devices Unlike the first seven steps which determine the appearance of the output document the last step controls its distribution The output document created by Papirus can be distributed through several output devices The destinations can remain constant or change according to the text of the spool The routing of the spool to the desired output devices is part of the design It is performed with Papirus control variables Papirus control variables There are two types of variables in the Papirus system 1 Template variables which are defined by the user These variables contain spool data that will appear in the output document Template variables were introduced in Step 3 2 Control variables which are part of the standard system The control var

Word Template Design Manual

Contents

Download Pdf Manuals

Related Search

Related Contents