Geocoding of Stock Locations in MMS010

Here is a video that illustrates the process to set the Geo Codes XYZ of Stock Locations in MMS010 in Smart Office, i.e. to set the latitude, longitude, and altitude of Stock Locations, a.k.a. geocoding. In my example I determined the coordinates based on an 3D model built in Google SketchUp and geo-located in Google Earth; a GPS receiver with good indoor accuracy would work as well. With geocoded information, we can present data from the Warehouse Management System in a graphical way. This is important for applications such as showing Stock Locations on a map, or finding the shortest path for a picking list.

Demo video

How to proceed

These are the steps I followed in the video to geolocate the Stock Locations in MMS010:

1. I used this SketchUp model of a 3D warehouse that I had previously geo-located:
   
2. I also used this other SketchUp model of the Stock Locations that I had previously uniquely identified:
   
3. Then, I used this Ruby script to get the geocoding of the floor plan:
   
4. Then, I used this other Ruby script to get the geocoding of each Stock Location:
   
5. The result is this CSV file of the floor plan’s geocodes and each Stock Location’s geocodes:
   
6. Then, I used this Lawson Web Service of type Display Program to set the values for the fields Geo Code X (GEOX), Geo Code Y (GEOY), and Geo Code Z (GEOZ) in MMS010/F for a specified Warehouse (WHLO) and Stock Location (WHSL):
   
7. Then, I used a Visual Basic macro for Microsoft Excel to call the Web Service for all Stock Locations:
   
8. Finally, I used this script to display the Geo Codes XYZ in MMS010/B1:
   

Result

The result is the list of Stock Locations in MMS010/B1 displaying all the Geo Codes XYZ:

Resources

• Download the SketchUp model of the geo-located 3D warehouse.
• Download the SketchUp model of the uniquely identified Stock Locations.
• Download the Ruby script to get the geocoding of the floor plan.
• Download the Ruby script to get the geocoding of each Stock Location.
• Download the resulting CSV file of all Stock Locations and their Geo Codes.
• Download the Lawson Web Service to set the Geo Codes XYZ of a Stock Location.
• Download the script to display the Geo Codes XYZ in MMS010/B1.
• Watch the video of the entire process.

Related articles

• Warehouse 3D demo
• M3 + Augmented Reality (idea)

UPDATE

2012-09-28: I had a bug in the Ruby script that miscalculated the Y and Z geocodes for the Stock Locations. I corrected the script and the resulting CSV file and I updated the links above.