MAM 7.6.1.2; MxLoader 5.7.1:

I thought I'd share some specific lessons learned when loading data via MxLoader:


Classifications that have a custom GL field:

1. Open the MXLoader spreadsheet
2. Update the configuration tab to point to the correct environment
3. Load the Spec Attribute sheet
4. Classifications sheet - when loading NEW classifications where there is a custom GL field in CLASSSTRUCTURE:
   1. Add a blank column to the left of CGCLASSGL.
      1. Any columns to the right of a blank column name will be ignored by MxLoader.
      2. Reason: We do this to avoid an issue where NEW classifications error-out due to the GL.
      3. 
      4. 500 DoPost : Internal Server Error
         Error 500: BMXAA4198E - The GL attribute CGCLASSGL on object {1} requires an organization. Specify a value in the Organization field.
   2. Load the Classifications sheet (with the blank column in place).
   3. Remove the blank column. Now, the GL column will load properly because we are UPDATING classifications.
      1. Explanation: The GL only errors out when the classifications we're loading are NEW. The GL values won't cause an error when UPDATING classifications.
   4. Load the Classifications sheet a second time
5. Load the ClassSpecUseWith sheet
6. Complete

Don't click in Excel while MxLoader is running:

7. Don't click anywhere in Excel while MxLoader is running (don't even click in a different Excel file). The cursor/VBA code will lose focus and cause an error.


Password:

8. Hardcoding the password isn't necessary. We can leave the password blank in the Excel table -- and enter it dynamically into a popup dialog instead. I didn't realize that was possible until recently.





Feel free to comment or share other tips.

#AssetandFacilitiesManagement
#Maximo

Good morning,

I hope that all is well with you and yours. In item # 8 by looking at the server address and containing 'meaweb.os/' tells me that you are not using the most up to date version of MxLoader = 8.1 because at  7.5.1 Bruno made the "Passwords and registration info are now stored globally in a configuration file" see https://bportaluri.com/mxloader/mxloader-changelog   
Somewhere around that update the ''meaweb.os/'' is dropped from the server address.



​

------------------------------
Colin Aitchison
------------------------------