Versions Compared

Old Version 1

changes.mady.by.user Angelica Domingo

Saved on

compared with

New Version Current

changes.mady.by.user Angelica Domingo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

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.

Floor

FAC-FLR

DC1-FLR1

 

Aisle Path

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.

Segment

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.

Location

FAC-LOC

DC1-032457

Must match the 'To Location' ‘To Location’ field EXACTLY being sent in the WMS extraction file.

Travel Path

FAC-FLR1-FLR2-1

DC1-FLR1-FLR2-1

 

...

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

...

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

...

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

...

Tip
titleTips
  • Travel Paths must have some "length" “length” to them. I.e. the start and end coordinates cannot lie on the same point.
  • The start and end points specified in the Travel Path import file should intersect with Aisle Paths, thus linking two Aisle Paths on two different floors.
  • Like Aisle Paths, Travel Paths MUST be either horizontal or vertical. They cannot be diagonal. This means that the Start and End coordinates must be either above or below one another, or side-by-side.

...

Please refer to the Segment tab of the current "SOP “SOP for XYZ Importing" 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

...

In the example illustrations that follow, the blue shaded area is the segment. Each cell is 2' 2’ by 2'2’, so the width of the segment is 4'4’.

image
imageOrientation.jpg
titleFig.215 Segment Orientations

...

Please refer to the Location tab of the current "SOP “SOP for XYZ Importing" 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

...