Meanings

The list features the possible meanings that a field can have in ORTIMplan. Double-clicking with the mouse on a meaning allows you to assign it to the selected field.

You use the meaning to define how the data fields of the import/export file (transfer file) relate to the data fields of the ORTIMplan data objects (work plan, working process). The mapping rule is created via the meaning.

Import

During import, the import field contents are entered into the corresponding ORTIMplan field.

If you choose the meaning user field, the user field is identified by the field name.

Identification

You can use some meanings to identify existing data in the database. To do this, you have to select the Identification option in the bottom right corner of the file configurator.

Import without record sign

You can use the following meanings for identification.

Identification of work plans

•Work plan: name

•Work plan: code

•Work plan: status

•Work plan: user field

Identification of workstations on work plans

•Work plan: workstation name

•Work plan: workstation code

•Work plan: workstation user field

Identification of material on work plans

•Work plan: material name

•Work plan: material code

•Work plan: Material user field

Identification of working processes

•Working process: position

•Working process: Name

•Working process: code

•Working process: status

•Working process: user field

Identification of jobs at working processes

•Working process: workstation name

•Working process: workstation code

•Working process: workstation user field

Identification of material in working processes

•Working process: material name

•Working process: material code

•Working process: Material user field

Export

During export, the data are read from the ORTIMplan field and written into the export file.

Possible meanings

1.Object fields (object properties e.g. name, code, description)

2.User fields of the objects

3.System fields (e.g. date, time)

4.Settings (e.g. settings: unit)

S-record and C-record and without record sign (only import)

Work plan: Remove material connection

Working process: Remove material connection

This removes a connection between work plan and material and a working process and material.

All material fields that do not carry the identification feature are ignored when the field Remove material connection is filled (eg. with 1, x, yes, true). A non-filled field is not evaluated and does not remove the connection.

T-record

Table: Row

Identifies the line, in which the data is imported.

Table: Column (export only)

The column is specified, in conjunction with the row (Table: Row) indicating the cell that is the source of the exported value.

M-record (import only)

Material: Folder

A material folder with the given name is applied under the root folder. On this folder the material is appended.

If the first character of the given name is a #, the name is entered not directly, but determined by a rule.

Material folder rules

#{Keyword}={Orientation}{Length}|{Range}

Keywords are: name, code,
date, DMY, DMy, YMD, yMD,
time, HMS, HM
Orientations are: L or R
Length: a length between 1 and n
Range {Begin}-{End}: Begin to end of the range between 1 and n

Example:
Rule = #name=L3,code=L2-4
Materialname = Material 123
Materialcode = m123

Material folder name = Mat123

More examples are printed in chapter Examples, Material import.

Material: Unit

Herewith the unit for all prices (manual price, standard price and floating price) is determined.

Material: Currency

Herewith the currenc for all prices (manual price, standard price and floating price) is determined.

Material: Price sign

The price tag determines which price is active. Possible tags are M, S and V. M activates the manual price, S activates the standard price, V activates the floating price.

Material: Amount All

Herewith the amount for all prices (manual price, standard price and floating price) is determined. The amount of individual prices can be passed individually.