Sync data between Maximo and Excel

This article is outdated! Checkout MxLoader tool.

This is the last step toward a complete integration between Maximo and Excel. In the previous article we have learned how to use Integration Object Service and HTTP calls from Excel to populate a spreadsheet with data retrieved from a Maximo server.
In this new article I will show how to synchronize (create and update) data between a Maximo and Excel. First of all you have to complete all the configuration steps described in the previous article.

In the sample Excel spreadsheet you just have to click on the second sheet called "Sync" and click on the "Query" button. The spreadsheet will be automatically filled with all the people whose name starts with the letter A.
Now try to change one of the names listed and click on the "Sync" button. In my example I have just changed the display name of Allan Ball.



Now go to Maximo and you will see the updated entries.
You can also try to insert new rows and click on the "Sync" button to create new entries in the PERSON table.

Labels: , , , ,