Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MIMS quick overview
- Thread starter 1794
- Start date
Business Object Connector Script is Visual Basic script probably using ALT-F11 within an Excel Spreadsheet or a Word document. You can load external data into the MIMS system using values in a Spreadsheet, via the MSO's (green screen online programs) or MSK's (back-end business object methods WorkOrder.Create e.g.).
MINT Scripts are PC-based load scripts used as a simple way of loading data into MIMS using the on-line screens (MSO's) basically screen-scraping, so all the screen fields have to have a corresponding data entry value in your script.
Both methods are slow to run, but validate as though the user was entering into the screen, so are safe entry methods.
A faster run method can be achieved via a Batch Conversion program, but this costs more to develop and requires a programmer. If you have a large volume of data which you wish to load on a regular basis this is the method to choose.
If you have a smaller volume of data, and you wish to load the data yourself, try MINT scripts.
I prefer Connector but about 10'000 records can take 4-5 hours to load (MINT is worse).
MINT Scripts are PC-based load scripts used as a simple way of loading data into MIMS using the on-line screens (MSO's) basically screen-scraping, so all the screen fields have to have a corresponding data entry value in your script.
Both methods are slow to run, but validate as though the user was entering into the screen, so are safe entry methods.
A faster run method can be achieved via a Batch Conversion program, but this costs more to develop and requires a programmer. If you have a large volume of data which you wish to load on a regular basis this is the method to choose.
If you have a smaller volume of data, and you wish to load the data yourself, try MINT scripts.
I prefer Connector but about 10'000 records can take 4-5 hours to load (MINT is worse).
Just a point to note about the 10,000 records to load... from our experience the time to load depends on the type of transaction, speed of the PC, size of the backend server and database setup... eg, in our environment, if we were to load a journal with 2500 items, load a 996 item Non-Order invoice or validate 4000 project numbers via Excel using VBA and BOC (MSO and MSK) only takes between 5 and 15 minutes.
There are also restrictions in our environment with the database setup... i.e. there is only so many transactions that can be stored at the database level before a commit has to be executed.
Drew
There are also restrictions in our environment with the database setup... i.e. there is only so many transactions that can be stored at the database level before a commit has to be executed.
Drew
- Status
Similar threads
- Locked
- Question
- Locked
- Question