Modify Equipment Profiles

[sdoughty]

Hi,
We are looking at hving to update our Equipment Profiles (EGI-Component-Modifier build), and this will involve adds and deletes. We have about 100,000 records to update. There are no useful search criteria on the MSO's, so for each EGI we have to step through screens. Our guesstimate is 290 hours worth of Mint scripting to do these updates.

Is there another way (for example Connector or MSQ, not SQL) that will allow us to do these updates quicker?

Thanks in advance.

Steve

 

[alphacoward]

Steve, i believe you've used Connector before?

Load the records into excel, write a connector script that loops through each row, calling the MSO flow as required.

If the MSO's don't exist you may have to use the MSKs instead, which i find are a bit harder. last thing is make sure your MIMS middleware is fully upto date, otherwise connector leaks memory, crashes and leaves processes all over the place

Any reason you choose mint over connector?

 

[AddOnsMR]

We have a program that does exactly what you are looking for. If you would like more info, contact Chris at 775-825-4440

 

[sdoughty]

Thanks for the responses...

AlphaCoward,
We would have to use MSO's because MSKs don't provide a search or modify method. Using MSO610, the only search criteria is EGI, and then you have to step through the results and decide what to do with each component modifier (I should add we are MIMS 4.3.1 with green screens until early next year....mmm...ellipse...).

We're using Mint because we already have a script to do it from years ago (pre-Connector).

AddOns,
We are in Sydney, so do you have a website?

Cheers,

Steve

 

[AddOnsMR]

We do indeed...

http://www.addonsinc.com

or email me at max@addonsinc.com