Documentation for ProTrack Warehouse 7.5.

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Refer to Data Import to learn how to configure ProTrack Warehouse in order to import each XYZ component data.

Info

  • Remove the "header" row(s) on each worksheet.
  • Save each worksheet as its own separate CVS format file.
  • Do not comingle floor related data elements within the same file (i.e., locations for Facility 1 and Floor 1 should be in the same file, and should not include locations for Facility 1 and Floor 2).
  • Each data element (Floor, Aisle Path, etc.) needs to have its own Directory to import. Cannot import Floor data in the same Directory in which Aisle Paths are being imported. These must be configured even if specific data elements are not going to be imported.
  • Importing locations requires that ProTrack Warehouse is idle (no background processing) during the import process.


Preparing ProTrack Warehouse for XYZ Import

Locations should be imported into a Test Environment, and then use the Location Move Process to move the locations from Test to Production Environments. The process of moving data from Test Environment to Production should be completed by a database admin (DBA), and is described in the ProTrack Warehouse Technical Guide.

The location data elements can only be imported when ProTrack Warehouse is idle and there is no background processing. Again, this importing should be done into a Test Environment, and then moved into the Production Environment. The following process describes preliminary procedures to prepare the Test Environment for import:

  1. If WMS files are also imported into the Test Environment (uncommon), one-hour prior to importing locations set WMS Import process to No
    1. Ensure there are no WMS files ready to process
      1. The main and Scheduled WMS directories should be empty
    2. Via the ProTrack Warehouse UI go to Configuration - System - Scheduled Tasks
    3. Set Topic WMS Import to No, and Save
  2. Allow background processing to complete
    1. Via the ProTrack Warehouse UI go to Monitor - Scheduled Request.
    2. Search by ALL Topics. Ensure all Topics are in one of these Statuses (if they are not then do not proceed with location import)
      1. WMS Import in RFP only
      2. All others
        1. IGN
        2. ERR

Once these processing queues have been emptied, proceed with importing of XYZ data elements.

After all location data elements have been imported and changes have been validated, restart the ProTrack Warehouse background processing.

  1. Re-start the WMS Import process.
    1. Go to Configuration > System > Scheduled Tasks.
    2. Set Topic WMS Import to Yes, and .
  2. Go to Monitor > Scheduled Request.
    1. Search by ALL Topics.
    2. Ensure that the Topic WMS Import is moving from RFP to INP.
  • No labels

Copyright © 2008 - present - TZA Tom Zosel Associates. All rights reserved