...
The only way to configure XYZ-related data elements in ProTrack Warehouse is by building an import file, and importing the elements one at a time. This section refers to the spreadsheet, "SOP “SOP for XYZ Importing.xls"xls”. This is the official document containing import templates for each XYZ component. Each tab of the workbook must be completed prior to importing the data elements.
Coordinate System Origin – Coordinate values cannot be negative, thus the origin should be set with large enough to allow floors to grow in any direction. For example, the origin could be treated as (1000, 1000). When viewing a facility's facility’s layout in ProTrack Warehouse using the Facility Layout Java applet, the coordinate system axes are orientated such that the x-axis points to the right and the y-axis points downward. In other words, the x-coordinates ascend as you move to the right and the y-coordinates ascend as you move downward.
...
Data Element | Naming Convention | Naming Convention Example | Comment |
---|---|---|---|
Facility | FAC | DC1 | Facility ID must match EXACTLY what is configured in ProTrack Warehouse and being sent in the WMS extraction file. |
FAC-FLR | DC1-FLR1 |
| |
FAC-FLR-AISLE | DC1-FLR1-04A | When two or more Aisle Paths are needed for a single rack (i.e. due to a non-passable barriers such as a security cage fence), append lowercase letters to the AISLE element. | |
FAC-FLR-AISLE-1 | DC1-FLR1-04A-1 | The '‘-1' 1’ suffix increments ('‘-2'2’, '‘-3'3’, etc.) with additional Segments on a single Aisle Path. | |
FAC-LOC | DC1-032457 | Must match the 'To Location' ‘To Location’ field EXACTLY being sent in the WMS extraction file. | |
FAC-FLR1-FLR2-1 | DC1-FLR1-FLR2-1 |
|
Table 3537. Naming Conventions
Anchor | ||||
---|---|---|---|---|
|
...
Please refer to the Floor tab of the current "SOP “SOP for XYZ Importing" Importing” Excel spreadsheet.
Floor ID | Floor Name | Description | Start X | Start Y | End X | End Y | Width | Facility ID |
---|---|---|---|---|---|---|---|---|
1-FLR1 | 1-FLR1 | Chicago - First floor | 4000 | 2500 | 8000 | 5000 | 4000 | 1 |
2-FLR1 | 2-FLR1 | Joliet - First floor | 2000 | 2000 | 6600 | 5000 | 4600 | 2 |
Table 3638. Floor Example
Info | ||
---|---|---|
| ||
|
...
Field | Description |
---|---|
Floor Name | Name of the floor. |
Start X | X value of the start co-ordinate of the floor. |
Start Y | Y value of the start co-ordinate of the floor. |
End X | X value of the end co-ordinate of the floor. This value should be equal to start X. |
End Y | Y value of the end co-ordinate of the floor. |
Height | This is for future development, and thus not currently available in this version of ProTrack Warehouse. |
Width | Width of the floor. |
Description | Description of the floor. |
Table 3739. Floor Field Descriptions
...
image | ||||
---|---|---|---|---|
| ||||
...
Please refer to the Aisle Path tab of the current "SOP “SOP for XYZ Importing" Importing” Excel spreadsheet.
Aisle ID | Aisle Name | Start X | Start Y | End X | End Y | Floor ID | Numbering Direction | Numbering Scheme | Travel Rule | path_access_rule |
---|---|---|---|---|---|---|---|---|---|---|
1-FLR1-100 | 1-FLR1-100 | 4200 | 2800 | 4300 | 2800 | 1-FLR1 | ALT_LR_ES | DUB_INC | DIRECT | BD |
1-FLR1-101 | 1-FLR1-101 | 4200 | 3000 | 4300 | 3000 | 1-FLR1 | ALT_LR_ES | DUB_INC | DIRECT | BD |
1-FLR1-102 | 1-FLR1-102 | 4200 | 2800 | 4200 | 3000 | 1-FLR1 | ALT_LR_ES | DUB_INC | DIRECT | BD |
1-FLR1-103 | 1-FLR1-103 | 4250 | 2800 | 4250 | 3000 | 1-FLR1 | ALT_LR_ES | DUB_INC | DIRECT | BD |
1-FLR1-104 | 1-FLR1-104 | 4300 | 2800 | 4300 | 2900 | 1-FLR1 | ALT_LR_ES | DUB_INC | DIRECT | BD |
1-FLR1-104a | 1-FLR1-104a | 4300 | 2910 | 4300 | 3000 | 1-FLR1 | ALT_LR_ES | DUB_INC | DIRECT | BD |
Table 3840. Aisle Path Examples
Field | Description |
---|---|
Path ID | ID of the aisle path. |
Path Name | Name of the aisle path. |
Start X | X value of the start co-ordinate of the aisle path. |
Start Y | Y value of the start co-ordinate of the aisle path. |
End X | X value of the end co-ordinate of the aisle path. |
End Y | Y value of the end co-ordinate of the aisle path. |
Numbering Direction | This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above. |
Numbering Scheme | This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above. |
Travel Rule | This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above. |
path_access_rule | This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above. |
Table 3941. Aisle Path Field Descriptions
...
image | ||||
---|---|---|---|---|
| ||||
...
Please refer to the Travel Path tab of the current "SOP “SOP for XYZ Importing" Importing” Excel spreadsheet.
travel_id | travel_name | description | start_X | start_Y | end_X | end_Y | end_ floor_id | begin_floor_id | barrier | path_access_rule | width |
---|---|---|---|---|---|---|---|---|---|---|---|
DC1-1-2-A | DC1-1-2-A | south stairs | 1005 | 2050 | 1006 | 2050 | FLR2 | FLR1 | N | BD | 0 |
DC1-1-2-B | DC1-1-2-B | east stairs | 1500 | 1910 | 1500 | 1911 | FLR2 | FLR1 | N | BD | 0 |
DC1-2-3-A | DC1-2-3-A | service elev | 1005 | 2050 | 1006 | 2050 | FLR3 | FLR2 | N | BD | 0 |
Table 4042. Travel Path Examples
Field | Description |
---|---|
Travel Path ID | ID of the Travel Path. |
Travel Path Name | Name of the Travel Path. |
Description | Description of the Travel Path. |
Start X | X value of the start coordinate of the Travel Path. |
Start Y | Y value of the start co-ordinate of the Travel Path. |
End X | X value of the end co-ordinate of the Travel Path. |
End Y | Y value of the end co-ordinate of the Travel Path. |
End Floor Id | Floor ID corresponding to the node at the X,Y coordinate specified in the End X and End Y fields. |
Begin Floor Id | Floor ID corresponding to the node at the X,Y coordinate specified in the Start X and Start Y fields. |
Barrier | This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above. |
Path Access Rule | This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above. |
Width | This is for future development, and thus not currently available in this version of ProTrack Warehouse.This is a mandatory field, so populate with the default value from the table above. |
Table 4143. Travel Path Field Descriptions
Tip | ||
---|---|---|
| ||
|
...
image | ||||
---|---|---|---|---|
| ||||
...
image | ||||
---|---|---|---|---|
| ||||
Anchor | ||||
---|---|---|---|---|
|
A Segment contains one or more locations, and thus typically represents racking. However, locations cannot exist outside of a Segment, regardless of whether or not the actual point in the warehouse is at a rack location. Segments are associated to Aisle Paths; no Segment can exist without an Aisle Path.
Please refer to the Segment tab of the current “SOP for XYZ Importing” Excel spreadsheet.
Segment ID | Segment Name | Inset | Offset | Length | Width | Orientation | Bay_Count | Number_Scheme | Number_Direction | Aisle_ID | Floor_ID |
---|---|---|---|---|---|---|---|---|---|---|---|
1-FLR1-100-A | 1-FLR1-100-A | 1 | -2 | 98 | 4 | Left | 0 | DUB_INC | ALT_LR_ES | 1-FLR1-100 | FLR1 |
1-FLR1-104-A | 1-FLR1-104-A | 1 | -2 | 98 | 4 | Left | 0 | DUB_INC | ALT_LR_ES | 1-FLR1-104 | FLR1 |
1-FLR1-104a-A | 1-FLR1-104a-A | 111 | -2 | 88 | 4 | Left | 0 | DUB_INC | ALT_LR_ES | 1-FLR1-104a | FLR1 |
Table 44. Segment Examples
Field | Description |
---|---|
Segment ID | ID of the segment. |
Segment Name | Name of the segment. |
Aisle Name | Name of the aisle path to which the segment is associated. |
Inset | Distance from the aisle starting point to the segment. |
Offset | Distance from aisle axis to the segment. |
Width | Width of the segment. |
Length | Length of the segment. |
Numbering Scheme | This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above. |
Numbering Direction | This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value in from the table above. |
Start Bay Number | This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above. |
Number of Bays | This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above. |
Orientation | Orientation of the Segment as it relates to the Aisle Path. |
Description | Description of the segment. |
Table 45. Segment Field Descriptions
In the example illustrations that follow, the blue shaded area is the segment. Each cell is 2’ by 2’, so the width of the segment is 4’.
image | ||||
---|---|---|---|---|
| ||||
Tip | ||
---|---|---|
| ||
|
To View Segments in ProTrack Warehouse:
image | ||||
---|---|---|---|---|
| ||||
Anchor | ||||
---|---|---|---|---|
|
A Location is any point in the warehouse to which you want to calculate travel to or from. For example, locations may be product slot locations, product staging areas, dock doors, order pickup / drop-off locations, or conveyor drop points. Levels are optional, and represent the various heights (Z coordinate) within a particular location. Thus, levels are associated with specific locations, and so the two are imported together. All Locations must be present inside a Segment.
Please refer to the Location tab of the current “SOP for XYZ Importing” Excel spreadsheet.
Location ID | Location Name | X | Y | Floor ID | Segment ID | Level Specifier | Level Height |
---|---|---|---|---|---|---|---|
1-loc1 | 1-loc1 | 4205 | 2800 | FLR1 | 1-FLR1-100-A |
|
|
1-loc2 | 1-loc2 | 4220 | 2800 | FLR1 | 1-FLR1-104-A |
|
|
1-loc3 | 1-loc3 | 4200 | 2900 | FLR1 | 1-FLR1-104a-A |
|
|
Table 46. Location Examples
Field | Description |
---|---|
Name & ID | Must match. |
X | X co-ordinate of the location. |
Y | Y co-ordinate of the location. |
Floor ID | Must match the Floor ID that is configured in ProTrack Warehouse. |
Level Specifier | This is the To Location Level ID. Must match exactly what is being sent in the WMS extraction file. Each Level Specifier is separated by the pipe symbol . |
Level Height | This is the distance from the floor in inches for vertical travel. Must match exactly what is being sent in the WMS extraction file. Each Level Height is separated by the pipe symbol . |
Table 47. Location Field Descriptions
Info | ||
---|---|---|
| ||
|
To view Locations in ProTrack Warehouse:
image | ||||
---|---|---|---|---|
| ||||