H TEMPLATES AND NORMSHEETS
H.4. CREATE FORMS/TEMPLATES FOR GRAPHICAL LISTS
Exercise 9 Exercise 9 Exercise 9
Exercise 9----12:12:12:12: Create templates for graphical lists.
1. Open the Graphical lists area by clicking on the plus sign "+" on the left to "Graphical lists" in the Workspace tree.
2. Select the graphical list you wish to create a template for.
3. Right-click with the mouse.
4.M Select the Load Page TemplateLoad Page TemplateLoad Page Template function from the context menu.Load Page Template
The just now created form can be loaded and changed. After you delete this form, it is possible to create a new form. (The form opens in its own window, i.e. it does not exist as a page in the Workspace tree).
It was described in the Normsheet Normsheet Normsheet chapter how to delete an available standard sheet (Edit Normsheet Edit Edit Edit menu > Select All,
menu > Select All, menu > Select All,
menu > Select All, right-click > Delete Delete Delete Delete). Now, you must change the available normsheet.
5.M Edit 6.M Select All 7. Right-click
8.M ExplodeExplodeExplodeExplode from the context menu
After ungrouping the symbol, all the elements become accessible again.
9. You can add lines, erase lines, and move lines as needed.
10. Edit texts, erase texts or add texts. There is a difference
between unchangeable texts and texts that have to be entered with data from the database lists.
All of the texts in a form for graphical lists have the "Normal Text" attribute.
Texts to be filled in with data from the database lists, must be presented always in the format
#<number>, such as #120010 for page number. You can find a list of available numbers for text placeholders at the end of this section or in the "List Construction Set.CPS" symbol library.
11. A special text placeholder "#Lines 30 7.5" must be presented in
the template in order to state the number of lines available in the template (for example 30) and the line-distance (for example 7.5).
• Enter the text exactly in the format
#Lines <number of lines> <line-distance>
The point is required as a decimal delimiter in the line-distance.
COPYRIGHT © 2006 IGE+XAO. All rights reserved 12.M Edit
13.M Select All 14. Right click
15.M Select Block Block Block from the context menu Block 16.> Drawing sheet
17.> OK
Exercise 9 Exercise 9 Exercise 9
Exercise 9----13:13:13:13: Save the form.
1. In the Workspace tree, select the current page under Graphical lists.
2.M File
Exercise 9----14:14:14:14: Select a template for a graphical list as follows:
.M Properties
You can select the template for the graphical list in the PropPropPropPropertiesertiesertieserties dialogue box....
1. In the Workspace tree, select the graphical list, which you would like to select a new template for.
2. Right click 3.M Properties
4.> Select your new template.
• Click on the icon to select the desired template. A pop-up list appears including all of the templates for graphical lists.
• Select the template.
5.> OK
The setting for the template has been saved within the workspace.
If you create a new workspace template, you can select new templates for graphical lists, too.
Examples f Examples f Examples f
Examples for text placeholders from database lists:or text placeholders from database lists:or text placeholders from database lists:or text placeholders from database lists:
You will find detailed information about all the lists in the User manual in the chapter Graphical lists.
List of products
COPYRIGHT © 2006 IGE+XAO. All rights reserved 165151 Free text 02
12000170 Manufacturer
H.4.1. FORMATTING GRAPHICAL LISTS
The format of graphical lists (except for Terminal matrix/Terminal plan with graphics, Terminal row picture plan and cable plan with graphics) can be customized by using: sorting, filtering, defining first page, page break after changing the defined values.
The control is realized via the page template using some keywords defined with the sign "#":
#PageBegin <page number> The graphical list will start from the defined page number.
Example (for List of Products):
#PageBegin 100
The first graphical List of Products begins automatically always from page number 100.
#PageBegin ?
Each time you generate the List of Products, a question about the start page number will appear.
#PageBreak <value> A new page will begin, if the defined value changes.
Example (List of Products):
#PageBreak 140020, 140050
Each time the Function (140020) or Location (140050) changes, a pagebreak is inserted and the list continues on a new page.
The list can be sorted by the function in this way.
#LineBreak <value> An empty line is inserted if the defined value changes.
#OrderBy <values> The graphical list is sorted according to the defined values whoseCodes (#number) are stated after the keyword #OrderBy.
Example (List of Products):
#OrderBy 140020, 140050, 160010
The List of Products is ordered, at first, by Function of the products Ascending, then by Location of the products Ascending, and then by Component Names Ascending.
You can sort the List of Products according to types, #OrderBy 160040
or according to Component Names
#OrderBy 160010.
Sorting in Descending order is also possible:
#OrderBy 140050 DESC, 160010
The List of Products is ordered at first by Function of the products Descending, then by Component Names Ascending.
#Where [argument] Records in the list are filtered according to the defined value.
Example (List of Products):
#Where [140050] = "+P1" AND [120010]>10
The List of Products will contain only components with Location "+P1"
and placed on page number >10.
Or
#Where [160040] = "M10" OR [160040] = "M20"
The List of Products will contain only components with types M10 and M20.
Example (List of Documents):
#Where [180010] <> "List of Documents"
The List of Documents contains all of the diagrams without the pages of the graphical List of Documents.
Example (List of Parts)
#Where NOT [160040] IS NULL or
#Where [160040] IS NOT NULL
Filtering out (not displaying) of all the records without type.
You can use Access Standard SQL Syntax.
Arguments must be enclosed in square brackets ([ ]).