Page tree
Skip to end of metadata
Go to start of metadata

Summary

Converts an IDurations table (date/time/time) into a Durations table (date+time/date+time) in order to enable further operations (see table types), as some operators can only be applied to Durations tables, e.g., the operator Scaling 7.0.

Example:

Example: Convert all rows

Situation

The file Import_5.txt with the following structure has already been imported with the operation Import text or CSV file 3.0

  • Condition for the conversion: All rows should be imported. If From-time is identical with To-time, the length shall be 0.


Please note: For information about the settings for the import operations refer to example 1 at Import text or CSV file 3.0.
Do not forget to set the type of the result table to IDurations (conversion necessary).

Settings



Result
TIS Project 

Want to learn more?

 Settings

Converts an IDurations table (date/time/time) into a Durations table (date+time/date+time) in order to enable further operations (see table types), as some operators can only be applied to Durations tables, e.g., the operator Scaling 7.0.

Columns of input table


ParameterValueOpt.DescriptionExample
Date (from)

System.DateTime

-Column for start date-
From time

System.DateTime

-Column for from time-
To time

System.DateTime

-Column for to time-

Parameter


ParameterValueOpt.DescriptionExample
Ignore data sets with 0 minutes length

System.Boolean

-Should data sets whose length equals 0 minutes be ignored?-
Ignore from-time = to-time = 0:00

System.Boolean

-Should data sets in which the start time and the end time are 0:00 be ignored?-
Count as 24 hours if from-time equals to-time.

System.Boolean

-Should data sets in which from time is equal to to time be counted as 24 hours?-

 Examples

Example 2: Ignore rows with From=0:00 hours and To=0:00 hours

Situation

The file Import_5.txt with the following structure has already been imported with the operation Import text or CSV file 3.0.

  • Condition for the conversion: Only those rows should be imported which do not contain "0:00 to 0:00". If From-time is identical with To-time, the length shall be 0 minutes.
Settings
Result→ Missing due to an error in the operator. Ticket

Error rendering macro 'jira'

Unable to locate Jira server for this macro. It may be due to Application Link configuration.


Example 3: If Start time = End time, count 24 hours but ignore the entries From=0:00 hours and To=0:00 hours

  
Situation

The file Import_5.txt with the following structure has already been imported with the operation Import text or CSV file 3.0.

  • Condition for importing: Only those rows should be imported which do not contain "0:00 to 0:00". If From-time is identical with To-time, the length shall be 24 hours.
Settings
Result

The entry of 2007/01/03 is not taken over into the result table, because both the From-column and the To-column values are 0:00. The entry of 2007/01/04 has a length of 24 hours.


 Troubleshooting
ProblemFrequent CauseSolutions
The operator "Conversion" is not available...Often, this is due to a mistake in the preceding import (see Import text or CSV file 3.0)Please check, if in the import operation under Type of the result column you have selected the type IDurations (conversion necessary). See also Tabellentyp (link to old Wiki).

Related topics

Tabellentyp (link to old Wiki)

 

1 Comment

  1. Error rendering macro 'jira'

    Unable to locate Jira server for this macro. It may be due to Application Link configuration.