Load Manual Data

Before you begin

Manual data loading, or initial one-time data loading is, as its name suggests, a one-time process that loads all the necessary configuration data. This task must be performed for each node separately.

Note: Prior to loading data, ensure that all the services are configured as mentioned in the topic Configuring Data Upload and Import Services.

Perform the following steps to carry out one-time data loading:

Procedure

  1. Run the integration server or servers associated with the Sterling Warehouse Management System data upload services.
  2. Set the values for the following environment variables as specified in this list:
    • YFS_RT must point to the installation directory of the Sterling Warehouse Management System.
    • ANT_HOME must point to the ANT installation directory.
    • JAVA_HOME must point to the Java™ installation directory.
  3. Run the following ant script from the <INSTALL_DIR>/bin directory:

    ant -f ynw_entity_uploader.xml -Dnode=Node

    Here, Node refers to the ship node.

    Notes:

    • For each entity that is uploaded, the entity uploader utility creates a restart file. The restart file has the key of the last entity record processed. This key is used for subsequent data uploads when the records that are already uploaded have to be ignored. The restart files are created in the <INSTALL_DIR>/bin folder.
    • Install the following third party jars for the Websphere application server:

         - j2ee.jar

         - com.ibm.ws.sib.client.thin.jms_7.0.0.jar

         - com.ibm.ws.ejb.thinclient_7.0.0.jar

         - com.ibm.ws.orb_7.0.0.jar

         - com.ibm.ws.wccm.jar

      After the installation is complete, the AGENTDynamicclasspath.cfg file will be updated.

  4. Run the readSterlingDataLoadFiles.bat file from the <Voxware Install Folder>/vlp_core/voxconnect_build/bin/ directory. This file invokes the following VLP Data Import events:
    • VLP_WAREHOUSE_LOAD
    • VLP_ZONE_LOAD
    • VLP_LOCATION_LOAD
    • VLP_EQUIPMENT_LOAD
    • VLP_REASON_LOAD
    • VLP_WORKTYPE_LOAD
    • VLP_PRODUCT_LOAD

      Notes:

    • Sterling Warehouse Management System provides only one batch file for all the events. However, it is recommended that the user create separate batch files for individual events.
    • The user must manually verify the log files to keep track of data load failures, if any.