Design:Program «Size databases»
Contents
- 1 Calling Up the Sizes Database
- 2 Creating a New Sizes Database
- 3 Filling In the Sizes Database Table
- 4 Interpreter
- 5 Changing parameters of a Size database
- 6 Deleting a Size database
- 7 Copying a Size database
- 8 Export/Import of the Sizes Database
- 9 Importing measurement data from Exel format
- 10 Saving size database to files and working with it
- 11 Printing size database
- 12 Sketches of figure measurement diagrams
Work Window of the “Sizes Database” Program
The program is provided with pop-up prompts. If you move the cursor to a menu button, a prompt appears in the screen, explaining what the selected function is like. All the elements of work with the mouse and the keyboard are standard for Windows.
Calling Up the Sizes Database
To call up a certain sized database into the screen you have to fulfill the Data/Open menu items. Then the databases list window will be displayed in the screen:

The required base is chosen either by double clicking the left mouse button on the line with its name, or by selecting the line with a single click and choosing the Yes command.
The sizes database allows one to view and edit data for any size, height, or fullness. To record the changes in separate lines of the table, press the Remember button. To record the introduced changes completely, use the Save button.

Creating a New Sizes Database
To create a new sizes database you have to fulfill the Data/New menu items. Then the database parameters window will be displayed in the screen, where you have to fill in all the data windows:

Using quotation marks in the sizes database name is not allowed. Measure scales are filled in by way of entering data separated by commas. The main, basic size for this measure is provided in the Basic Size field.
In case if the second or third measure is absent, its field has to be filled in with a dash, or it will be inserted automatically when the data are saved.
In the Existing field you can choose an appropriate database table, and create a new empty table on the basis of its parameters, with a different name in the Name field.
Filling In the Sizes Database Table
The sizes database table can be filled in either manually or with the help of special buttons:
- the window for entering values and special functions
- carrying over the values onto the entire table or into the specified line of size or height in the table.
- changing the value sign in the table
![]()
- Saving the table into the buffer and Calling it up from the buffer
When tables with repeating symbols are saved, a warning message will be displayed:
After choosing the No command, you have to change one of the repeating symbols. But if necessary, you can ignore these repetitions. In such a case, the same as in the “Design” program, the data of the table will be used in the projects in the order of their position in the list, from top to bottom.
The table can be filled in quickly with the help of special functions, which are called up by clicking the right mouse button on the area of the window for entering values.
By choosing the Fun4 function you can fill in the entire table at once, from the minimum value to the maximum one, by way of inserting the relevant numbers instead of the Min and Max signs, and clicking the left mouse button on the “All” word in the table head.

By choosing the Fun5 function you can, after filling in the line of basic sizes values for all heights manually, enter the required value of the basic size/height increment by way of inserting the relevant number instead of the Delta sign and clicking the left mouse button on the “All” word in the table head.
To set a jump in the increments of non-uniform grading, you should first fill in the entire table through the use of the Fun4 and Fun5 functions, and then enter the jump value with a “+” or “-“ sign in the window for entering data after the expression with the function, and click on the cell of the required size or height name.
To cancel the last inserted value in the table you can use the “Rollback”
function.
To return the data of a separate cell, press the <CTRL> and <Z> keys on the keyboard at the same time.
Interpreter
The function «Interpreter» allows to fill in the data table at once according to a set algorithm, by using ready programs-examples.

to use this for work:
·Press the button «Interpreter»
at the top panel of the table window, a blank interpreter window is displayed on the screen:

·To open existing programs, select the button «Open from file»
at the lower panel of this window.
A list of example files in the folder «Examples» is displayed on the screen (the folder is stored in the program catalogue of the server, in the folder Julivi )
·Specify a required example. After its name is displayed in the lower box «File name», select the command «Open»

·The window will be filled in with the algorithm text. The user must input required parameters in the text instead of default parameters displayed as * or ?
·Select the command «Perform»
. The table of the measurement parameter will be filled in.
·To save the table of a given parameter, use the command «Remember» of the lower panel of a general program window, to save the entire size database, select the command «Save».
Similar programs can be compiled by a user. For this, minimal skills and knowledge of programming language are required.
Set increment value by sizes (for example – 1,5cm), heights (0,2cm) and corpulence values (0,2cm). Gradation by size to be performed with a leap FROM THE BASE SIZE (4,4cm) in two next-to-last sizes:

Changing parameters of a Size database
If necessary, parameters of a created size database can be edited. To do so, open a required database and select the menu point Data/Parameters.
The window with database parameters is displayed on the screen, in this window some parameters can either be deleted, or a scale can be expanded, by adding lists (separated by a comma). Empty cells, which will need to be filled in, will be added to the table.

Deleting a Size database
To delete a size database, follow text menu point Data/Delete. A list is displayed on the screen, where the line with the name of a required database must be selected with a left mouse click, then press the Yes button.
Size database, currently opened on the screen, will not be displayed in the list of databases to be deleted.
Projects on the basis of a deleted Size database will be executed only in one, base size.
Copying a Size database
To copy a current data base with a different name, follow menu points Data/Save as. The window with database copy parameters is displayed on the screen, in this window all boxes are blocked except the line «Name». Write the database copy name and press the button Yes.

Export/Import of the Sizes Database
The created Sizes Database can be saved in electronic format and transferred into another database.
To export the Sizes Database into a previously created folder on any computer disc, you have to fulfill the item of the Data/Export menu. A query window for the path where it will be stored is displayed in the screen. Choose the relevant disc and folder name, “open” the folder by double-clicking the left mouse button, and then type the name of the file to be saved in the “File name” field. The created files are of OXP type:

The folder for storing the database can also be created directly in the window open for saving, through the use of the pop-up menu after clicking the right mouse button anywhere in the internal area of the window.
When the Data/Import command is performed, a reverse process of rewriting the database from the folder into the program takes place. Choose the Data/Import menu item for this purpose.
A window will be displayed where you have to locate the file that the database is imported from:

The database being imported will be displayed on the screen. Here you have to save it by way of fulfilling the items of the Data/Save menu.
Importing measurement data from Exel format
The program has an option to read data of measurement parameters or measurement table, created in Excel format. If you have a measurement table in such a format, you can import it to the Size database of the Design program data and plot a project on the basis of this data.
To do so:
·Select Data/Import files *.xls . The following window is displayed on the screen

·Open file in Excel format, which contains information to be read. Press
and in a displayed window specify a path where the initial document is saved, and open it.

·Set cell compliance for reading data according to an opened document in the window «Import of measurement data from Excel» :
- number of the line, which contains size range. This data will be input to the Size database
- Name of the column, which contains name of a measurement (measurement parameter)
- name of a column, which contains measurement symbol. If the initial file does not have such data, select a dash.
- starting column for reading table data
- last column for reading table data
- umber of a line, from which reading of table data begins
·Set the last line for reading table data.

If the initial file has a table border, a thick line can be a sign of document end (switch on a corresponding option). If there is no border, switch to
, copy text from the window (
) and insert it in the initial file in the line of data end.
·Input name of a new data table
.
·Press
. A new size database will be created in the data Size database and all data will be transferred from Excel.
Other settings during import:
- an option is switched on if the initial file contains information, which is not located in order by lines, but when a cell divided into two
(measurement table for pieces and a product). In this case, select which line in the divided cell must be read: first or second.
- an interval is set if, for example, data should be read not from each line, but from every other line.
- digit divider is set if data is not given as an integral number, but as a decimal data.
- measurement units of reference data.
Saving size database to files and working with it
With the help of the button
it is possible to save data from the table in an electronic format (Measurement data, additions, variables, identifiers) with an opportunity to send data to print.
Window for selecting a path for saving is displayed on the screen. A previously created folder must be selected, open it with a double click of the left mouse button, name a file with a table by filling in the box «File name» in the lower part of the window:

Folder for saving the table can be created right in the open window with the help of a floating window. To display a menu, right click a mouse in any area inside the window.
By using the button
it is possible to read table data, saved to a particular file (folder) and use this data in a different table.




