EXCEL DATA STRUCTURE TO IMPORT TCRs:
tcr_import_structure_sample.xlsx
The excel file used for importing TCRs needs to follow a predefined structure. The excel file to be imported must fulfill the following rules:
- The TCRs are on the 2nd sheet
- The TCR definitions start from the 4th row
The columns in the Excel sheet must be used as defined below. Note that only columns relevant for the import are listed. The table has the following structure:
- Column – Column identifier in the Excel file
- Interpretation – Meaning of the column (form the Header row)
- Allowed type– The type of the column
- Constraints / Values – Rules that will be validated during the import and predefined values in the excel. Mandatory fields are marked with Not null.
- Mapping – The name of the field of the TCR form into which the value of the column will be mapped
Column | Interpretation | Allowed type | Constraints / Values | Mapping |
B | IM | Text | Not null; Value must match the name of an Organization Units defined in the TCR-Tool | IM (Organisation Unit) |
C | ID | Text | Not Null; The combination IM (column B) together with ID (column C) must be unique | Reference ID |
D | Section | Text | Not Null; Value must match the section which is computed from the fields ‘Location From’ and ‘Location To’ | Not mapped |
E | Direction | Text | Not null; Value must be in [<, >, < >] | Direction |
F | From location | Text | Not Null; Value must match a Location stored in the TCR Tool topology data | Location from |
G | To location | Text | if null, then the interpretation is that ‘To Location’ is the same as ‘From Location’ if not null, the value must match a Location stored in the TCR Tool topology data | Location to |
H | Year from | Number | Not null | Year From |
I | Year To | Number | Not Null; Must be >= Year From (Column H) | Year To |
J | Week From | Number | Not null; Value must be in [1-52] | Week From |
K | Week To | Number | Not null; Value must be in [1-52] | Week To |
L | Date From | Date | If not null, the date must be in the calendar week as defined by Year From and Week From | Date/Time From |
M | Time From | Time | If not null, then also Date From must be not null; If null and Date From is not null, Time From is interpreted as 00:00 | Date/Time From |
N | Date To | Date | If not null, then also Date From must be not null; shall be equal or later than Date From | Date/Time To |
O | Time To | Time | If not null, then also Date To must be not null; If null and Date To is not null, Time To is interpreted as 23:00 | Date/Time To |
P | Duration | Text | - | Duration |
Q | Time of day | Text | Not null; Value must be in [continuous, periodical, periodical continuous] | Type of TCR |
R | Reason of restriction | Text | -; Value must be in Signal; Switch; Catenary; Track & Rail; Tunnel; Bridge; Miscellaneous*; Maintenance, Others**] | Reason of restriction |
S | Total Closure | Text | -; Value must be in [T, X] | Total Closure (true if value = T or X) |
T | Reduced Track Availability | Text | -; Value must be in [LT, ST, LT+ST] Description: LT - Long-distance trains; ST - short distance trains | Reduced Track Availability LT (true if value in [LT; LT+ST]) Reduced Track Availability ST (true if value in [ST; LT+ST]) |
U | Speed Restrictions | Text | -; Value must be in [S, X] | Speed Restrictions (true if value = S or X) |
V | Weight, Length, Profile | Text | -; Value must be in [W; L; P; W+L; W+P; L+P; W+L+P] | Weight (true if value in [W; W+L; W+P; W+L+P]) Length (true if value in [L; W+L; L+P; W+L+P]) Profile (true if value in [P; W+P; L+P; W+L+P]) |
W | Diesel only | Text | -; Value must be in [Do, X] | Diesel only (true if value = Do or X) |
X | Cancellation | Text | -; Value must be in [C, X] | Cancellation Freight trains (true if value = C or X) |
Y | Re-routing | Text | -; Value must be in [R, X] | Re-routing Freight trains (true if value = R) |
Z | Train replacement | Text | -; Value must be in [B, X] | Train replacement Freight trains (true if value = B or X) |
AA | Delays | Text | -; Value must be in [D, X, or positive integers] | Estimated delays (true if value not null) Define delay minutes (if value represents a positive integer) |
AB | Other | Text | - | Other |
AC | Description | Text | - | Description |
AD | International coordination | Text | -; If entered codes of IMs that are involved in the coordination, those codes should be comma-separated | International coordination |
AE | In yearly timetable | Text | - | In annual timetable (mapping TBD: proposal to change allowed values to [Y] or [Y; N] |
AF | IM project ID | Text | - | IM Project ID |
AG | Last update | Datetime | - | Data status |
AH | Canceled | Text | Not null; Value must be in [Y, N] | If value = Y, the TCR will be canceled |