@BEGIN GLOBAL SEPARATOR ; ESCAPE @ @END GLOBAL @BEGIN MODULE MODULE @ @END MODULE value_1;value_2 value_1;value_2
Use | Possible? |
---|---|
Source module | No |
Pool module | No |
Target module | Yes |
Parameter | Function |
---|---|
filepath |
Path to the file to be exported. It can either be in relation to the server directory or be an absolute path on the server. |
delimiter |
The separator within the CSV file. |
escapechar |
Character used to escape the delimiter within a value. |
encoding |
Codec with which the file is encoded |
overwrite |
Defines whether an already existing file is to be overwritten upon export |
quoting |
Defines whether the values are to be written/read in inverted commas. Possible values can be found in the Python Documentation |
Use | Possible? |
---|---|
Source module | Yes |
Pool module | No |
Target module | Yes |
Parameter | Function |
---|---|
sorted |
Values
|
da_name |
Python ID of the data area to which you want to import or export. If the MtsModule is set as a target module, the parameter can remain empty. This implies that all data areas in the module are used as import targets. |
Use | Possible? |
---|---|
Source module | Yes |
Pool module | No |
Target module | Yes |
Parameter | Function |
---|---|
sorted NEW |
Values
|
da_name |
Python ID of the data area to which you want to import or export. If the MtsModule is set as a target module, the parameter can remain empty. This implies that all data areas in the module are used as import targets. |
Use | Possible? |
---|---|
Source module | Yes |
Pool module | No |
Target module | Yes |
Parameter | Function |
---|---|
da_name |
Python ID of the data area to which you want to import or export. If the MtsModule is set as a target module, the parameter can remain empty. This implies that all data areas in the module are used as import targets. |
Use | Possible? |
---|---|
Source module | Yes |
Pool module | No |
Target module | Yes |
Parameter | Function |
---|---|
da_name |
Python ID of the data area to which you want to import or export. If the MtsModule is set as a target module, the parameter can remain empty. This implies that all data areas in the module are used as import targets. |
Use | Possible? |
---|---|
Source module | Yes |
Pool module | No |
Target module | Yes |
Parameter | Function |
---|---|
sorted |
Values
|
da_name |
Python ID of the data area to which you want to import or export. If the MtsModule is set as a target module, the parameter can remain empty. This implies that all data areas in the module are used as import targets. |
auto_task_id |
The Python ID for automatic creation of a task (e.g. to import costs to it). If the parameter is not filled, no task is created. The parameter is only available if the module is used as a target module in import. |
auto_task_name |
Name for the automatically created task. The parameter is only available if the module is used as a target module in import. |
Use | Possible? |
---|---|
Source module | No |
Pool module | Yes |
Target module | No |
Parameter | Function |
---|---|
da_name |
See MtsModule Note:
|
sending_da NEW |
Data area from which the data is loaded in the Pool -> Target step |
receiving_da NEW |
Data area in which the data is stored in the Source -> Target step |
l_var |
The number to be filled with the current interface configuration in the pool module. Allows you to restrict the pool table to the records of the current transaction. |
Use | Possible? |
---|---|
Source module | Yes |
Pool module | No |
Target module | Yes |
Parameter | Function |
---|---|
archive_dir NEW |
Path to a directory to which the file is to be moved after successful import. It can either be in relation to the server directory or be an absolute path on the server. If the parameter is empty, the server directory is used. If the directory does not exist, it is created |
filepath |
Path to the file to be imported or exported. It can either be in relation to the server directory or it can be an absolute path on the server. NEW Wildcards like * can be used in the name. If several files are found, an error is displayed. |
delimiter |
The separator within the CSV file If a tab is to be used as a separator, you have to enter /t . |
escapechar |
Character used to escape the delimiter within a value. |
encoding |
Codec with which the file is encoded |
writeheader |
Defines whether a title line is written upon export |
readheader |
Defines whether the first line or the source mappings display the column names in the CSV file |
overwrite |
Defines whether an already existing file is to be overwritten upon export |
quoting |
Defines whether the values are to be written/read in inverted commas. Possible values can be found in the Python Documentation |
archive_dir
.
filepath
parameter in order to format a time stamp. The possible placeholders can be found in the Python documentation. Parameter | Function |
---|---|
filepath |
Path of the file to be imported or exported. This path can either be in relation to the server directory or be an absolute path on the server |
delimiter |
Separator within the CSV file |
escapechar |
Character used to escape the delimiter within a value. |
encoding |
Codec with which the file is encoded |
writeheader |
Defines whether a title line is written upon export |
readheader |
Defines whether the first line or the source mappings display the column names in the CSV file |
overwrite |
Defines whether an already existing file is to be overwritten upon export |
quoting |
Defines whether the values are to be written/read in inverted commas. Possible values can be found in the Python Documentation |
encoding | Used by |
---|---|
latin-1 | Default Microsoft Excel encoding on German computers |
windows-1252 | Default Microsoft Excel encoding on English computers |
utf-8 | UTF-8 encoded file without BOM |
utf-8-sig | UTF-8 encoded file with BOM |
filepath
and archive_dir
parameters do not exist here.
Use | Possible? |
---|---|
Source module | Yes |
Pool module | No |
Target module | Yes |
Parameter | Function |
---|---|
da_name |
See MtsModule |
Use | Possible? |
---|---|
Source module | No |
Pool module | Yes |
Target module | No |
Parameter | Function |
---|---|
da_name |
See MtsPoolModule Note: is replaced by sending_da and receiving_da . |
sending_da NEW |
See MtsPoolModule |
receiving_da NEW |
See MtsPoolModule |
l_var |
See MtsPoolModule |
sorted NEW |
See MtsModule |
Parameter | Function |
---|---|
da_name |
See MtsPoolModule |
l_var |
See MtsPoolModule |
SAP connection parameters |
---|
client |
user |
passwd |
lang |
trace |
ashost |
sysnr |
mshost |
msserv |
sysid |
group |
Parameter | Function |
---|---|
calendar |
ID of the calendar to which is to be imported |
start_year |
Year from which on holidays are to be imported |
end_year |
Year up to which holidays are to be imported |
state |
Federal state for which holidays are to be loaded. Permitted values: HB, NI, NW, HH, SN, MV, BW, SL, SH, ST, BE, RP, BB, BY, HE, TH |
Absence reason | Value |
---|---|
Absence | 46 |
1/2 day absence | 45 |
Special vacation | 48 |
Vacation | 44 |
1/2 day of vacation | 43 |
Maternity leave/parental leave | 47 |
On- and off-the-job training | 113 |
Sickness | 399 |
Parameter | Function |
---|---|
da_name |
See MtsModule |
date_format |
The format of the date values in the start_date and end_date columns. For possible values, see Python documentation. |
project_definition
where the SAP project ID must be entered to import the WBS structure for this module.
project_definition
where the SAP project ID must be entered to import the WBS structure for this module. Parameter | Function |
---|---|
true | Defines whether true or false is to be returned. possible values: 0 (false) and 1 (true) |
Parameter | Function |
---|---|
variable | Variable to be read out, e.g. @1 or @G123. Supports all variable types. |
Parameter | Function |
---|---|
start |
Index to begin at |
step |
Step width at which to cut off |
end |
Index to stop at |
Parameter | Function |
---|---|
old_value |
Partial string to be replaced |
new_value |
Value by which the partial string is to be replaced |
Parameter | Function |
---|---|
value |
By specifying a sign, it is stripped. If nothing is specified: all types of spaces/tabs |
Parameter | Function |
---|---|
chars |
The sign that is to be cut off If no sign is specified here, all types of spaces/tabs are cut off. |
Parameter | Function |
---|---|
chars |
The sign that is to be cut off If no sign is specified here, all types of spaces/tabs are cut off. |
Parameter | Function |
---|---|
project |
Technical project ID of the project |
task |
Technical task ID of the task |
res_id |
Resource ID |
python_id |
DI Python ID of the DI that is to be returned |
ConvertResourceIdToPersonId
validator Parameter | Function |
---|---|
text |
Text that is to be added to the input value |
left |
Determines whether the text on the left of the string is to be added; possible values are 0 and 1 |
right |
Determines whether the text on the right of the string is to be added; possible values are 0 and 1 |
Parameter | Function |
---|---|
digits |
A number greater/equal to 0; Defines the number of digits to which the input value is to be rounded. If the parameter cannot be converted to any number, the default value 2 is used. |
Parameter | Function |
---|---|
resource |
Resource ID |
python_id |
DI Python ID of the DI that is to be returned |
Parameter | Function |
---|---|
fillchar |
Signs by which the string is extended |
width |
Entire length of the string with extension |
Example
- Input string: "foo"
- fillchar: \s
- width: 5
- Output string: " foo"
Parameter | Function |
---|---|
fillchar |
Signs by which the string is extended |
width |
Entire length of the string with extension |
Example
- Input string "foo"
- fillchar: x
- width: 5
- Output string: "fooxx"
Parameter | Function |
---|---|
uuid | UUID of the record from which the data item is to be read |
datatable | SQL ID of the record from which the data item is to be read |
dataitem | SQL ID of the data item to be read |
Parameter | Function |
---|---|
system | Code of the external system (e.g. 728 for PLANTA pulse) |
type | Type of object which has this ID (e.g. 'workload' for loads from PLANTA pulse) |
Parameter | Function |
---|---|
datatable | SQL ID of the record from which the data item is to be read |
dataitem | SQL ID of the data item to be read |
Parameter | Function |
---|---|
round |
Configures whether the value is to be rounded first |
Parameter | Function |
---|---|
format |
Format of the date. For possible values, see Python documentation. |
Parameter | Function |
---|---|
format |
Format to be used for the date. For possible values, see Python documentation. |
Parameter | Function |
---|---|
encoding |
Encoding to which the input text is to be converted. By default, this parameter is preset with the coding of the server and does not have to be changed. |
Parameter | Function |
---|---|
conversion_factor_id | Conversion factor ID, saved in DI000341 |
format | Date format for the incoming value (like e.g. PLANTADateToString) |
Parameter | Function |
---|---|
python_id | The Python ID of the DI from DT461 Project |
Parameter | Function | Default value |
---|---|---|
format | Format of the json value (must contain the '{input}' placeholder) | {'id': '{input}'} |
Parameter | Function |
---|---|
type | Type of the external object (as saved in the DT597ExternalSystemObjectMapping table) |
Parameter | Function |
---|---|
table | SQL ID of a PLANTA project table |
dataitem | SQL ID of a data item from the specified table |
child_when_invalid
string is ignored.
Parameter | Function |
---|---|
table_num |
Table number in PLANTA to be checked |
Parameter | Function |
---|---|
values |
A list of values that must be separated with the configured separator |
separator |
Separator for separating the list into separate values |
ComparesTo
validator Parameter | Function |
---|---|
value |
Value to be available |
Parameter | Function |
---|---|
project |
The technical project ID of the project to be checked |
Parameter | Function |
---|---|
project |
The technical project ID of the project to be checked |
task |
Technical task ID of the task to be checked |
create_if_not_exists |
In case the resource assignment does not exist and this parameter is at 1, the resource assignment is created |
Parameter | Function |
---|---|
value |
Specifies, against what to compare |
operator |
Specifies, how to compare: ==, !=, <, >, <=, >= |
type |
Specification of the type, possible values: TEXT, INTEGER and FLOAT. Prior to the comparison, the validator converts the values of the value parameter and the input value to this type. |
Parameter | Function |
---|---|
project | Specifies the technical project ID of the project in which the check is to be done. |
cost_type_group | Specifies the cost type group subject to the check. |
create_if_not_exists | Specifies whether the yearly tranche is to be created if it does not exist. Valid values: 1 or 0 |
Parameter | Function |
---|---|
HostnameConditional |
Compares the parameter value to the host name of the application server |
PortConditional |
Compares the parameter value to the port entered in globals.conf of the PLANTA server |
WorkDirConditional |
Compares the parameter value to the work directory of the PLANTA server |
IPAddressConditional |
Compares the parameter value with the IP address of the application server |
See also: Here you can find an overview of all PLANTA link contents |