Hi Bruno - firstly, great work on MxLoader - especially adapting it for REST / oslc, I know it can't have been easy!
As promised here's a few bits of feedback:
- After clicking the 'MxSheet Wizard' it might be useful to have a progress indicator? Depending on the target Maximo system this can sometimes take a little while
You could show the number of object structures loaded? or maybe a log/list of what has been loaded? Also I found that if you're using ServerXMLHTTP60 then you can set the Async flag to true on the .open method... this means you can loop for readyState <> 4. If you use this approach then excel doesn't hang on long HTTP requests and you don't get the 'application is not responding' stuff.
- When choosing the Object Structure, I think it would be better to use some slightly different options on the combobox (allow typing). As often there are lots to choose from and it's useful to use keyboard input to jump down the list
- Would be really good to have a 'redirect to file' option on the Run List feature. You could use the batch size from the config to split the files, numbering them 001, 002 etc.
- One of the things I implemented that I received a lot of positive feedback on was the 'tooltip' on the column headers that showed the data type, length and description (truncated to 254). I did this using the input message on cell validation (cell.Validation.InputTitle and cell.Validation.InputMessage)
- I think a right click menu on the worksheet tabs at the bottom would make a very good addition (i.e. add MxSheet / MxWizard)
This can be done using Application.CommandBars("Ply").Controls.Add(Type:=msoControlButton, temporary:=True)
- I got an error using the wizard (see below)
------------------------------
John Green
Peacock Engineering LTD
------------------------------