Loading Maximo Routes using MaxQuickLoad

Creating Routes

You can import and update routes in Maximo using MaxQuickLoad.   Loading routes androute stops is a two step process.  You must first create the routesin Maximo using the routes object structure MQLMXROUTE.  After you have created all of your locations the next step is to add the route stops to the route you just created.

Prerequisites:

You must configure the MQLMXROUTES object structure and import it into MaxQuickLoad. See Configure the Route Object Structure section below.

 Step 1: Load Routes

1. Create a new MaxQuickLoad upload spreadsheet using the MQLMXROUTE object structure.
   a. In MaxQuickLoad, select the Excel menu MaxQuickLoad -> New.
   b. Select your server.
   c. Select the MQLMXROUTE object.
   d. Provide a name for your data load.
   e. Click Next >.
   f. Select the method you want to use to upload the data.
   g. Complete the new data load wizard steps.
2. In the Map Maximo Fields form:
   a. Select the ROUTES object.  Map the following columns.
   
   • SITEID
   • ROUTE
   • DESCRIPTION
   • ROUTESTOPSBECOME  (Set to CHILD, MULTI, or TASK)
   
   
   
3. Complete the ROUTE upload using MaxQuickLoad.

 Step 2: Load Route Stops

1. After uploading the Routes, select the Map menu option.
2. Select the ROUTES/ROUTE_STOP object.  Map the following fields
   
   • ROUTES/ROUTE_STOP/ROUTESTOPID
   • ROUTES/ROUTE_STOP/LOCATION
   • ROUTES/ROUTE_STOP/ASSETNUM
   
   
   
3. Complete the upload to Maximo to create the Routes stops.

Configure the Route Object Structure

Prerequisites:

You must have administration level access to Maximo and the rights to the Object Structures application.

Procedure:

To create an object structure to load location hierarchy, complete the following steps:

1. Click the New Object Structure icon in the Object Structures application.
2. Specify a name for the object structure, for example MQLMXROUTE.
3. Specify INTEGRATION in the Consumed by field.
4. Click New Row in the Source Details section and specify the ROUTES object.
5. Click New Row in the Source Details section and specify the ROUTE_STOP object.
6. Specify ROUTES in the Parent Object  field.
7. Specify ROUTE_STOP in the Relationship field.
   
   
   
   
8. Save the MQLMXROUTE object structure.
9. Import the MQLMXROUTE object structure into MaxQuickLoad.
   a. Open MaxQuickLoad.
   b. From the Excel menu, select MaxQuickLoad > Data Objects.
   c. Click the Object Structures... button.
   d. Select the MQLMXROUTE object structure.
   e. Click OK.
   f. Click Close.