General Page
In order to let Spatial know which (and where) GIS attributes are to be saved in Maximo from our Feature Class and vice versa, we need to use the JSON Mapping application.
To make things shorter, we'll be showing how to make this configuration in a Maximo environment with an already configured Map Manager record. So, first of all, please make sure that you have a Map Manager record with all the basics set up (such as Map Services, Service Layers etc).
1. Open your JSON Mapping application and create a new record.
2. Fill out the following fields:
- Give it a name that makes it easy to identify your record later. It is good practice to name the record so you can easily identify the type of records you will be working with. I will be naming it “WATER_MAIN_INBOUND”
- In Map Manager, the records I am working with are configured as locations, so I'll populate the Object Structure field as ARCGISLOCATION
- Leave the direction as Inbound.
3. Now, in order to fill the JSON Data field, we'll need to get a query URL from our Map Service, so let's open our Map Service and get to the layer which will be mapped.
5. We just need to produce a query capable of returning at least one JSON object, which will allow our JSON Mapper to get its attribute structure. Fill out the following fields:
a. Where: OBJECTID<10
b. Out Fields: *
c. Format: JSON
d. Leave the other fields as they are.
e. Click the Query(GET) button.
9. Now we'll have to drill down through the data layers until we get to the attributes, so click Map More Objects.
10. In the Select More Objects dialog, select the LOCATIONS object.
11. Now, click on the magnifying glass next to the Property Path field of the second line that was just created.
12. In the Select Value dialog, select the "//features" item.
13. We need to go down one more layer in order to get to our object attributes. So click Map More Objects again, select the LOCATIONS object and then click on the magnifying glass. Now you'll have to select the "//features/attributes" item.
14. Your JSON Object Mapping section should now look like this:
15. Now let's map our attributes from the JSON object to our Maximo object by clicking New Row under the "JSON Properties Mapping for Process Order 3" section (please note that you need to have the third row from the first section selected).
16. We will add the following properties to the JSON Mapping record. When using locations records the required fields are the following:
- PLUSSISGIS, to specify it is a GIS record.
- PLUSSFEATURECLASS, which will the GIS Object identification used in your Map Manager.
- SITEID that is being used.
- TYPE to specify which type of location is being used.
- Location to specify the location of the storeroom.
- Although it is not required, I will add a DESCRIPTION attribute to more easily identify the record.
17. Click Save.
18. Go to Map Manager and open your map record which contains the Layer you are configuring, then open the Service Layer which corresponds to the feature class we are mapping.
19. Expand its line and scroll all the way down to the JSON Map Names section.
20. So now let's put our inbound JSON mapper in the Inbound JSON Mapper Name field.
21. Your inbound JSON mapper is created and properly configured in your Map Manager record.
Was this topic helpful?
Document Information
Modified date:
01 April 2021
UID
ibm16437023