Caliach Ltd - 30th July 1998

Alternative Method of Upgrading a Datafile from CaliachMRP V2.28 to V2.50 or Later

Abstract

This upgrade is significant as it means moving from Omnis 7 V1 to Omnis 7 V3. Omnis 7 V3 has a slightly different data structure to Omnis 7 V1. Omnis 7 V3 can operate on V1 datafiles but performance is not as good as when used on converted data. The normal method of upgrading causes CaliachMRP to automatically convert the data using an internal Omnis 7 V3 utility. This however can fail if there is internal damage to the datafile structure. The following method of upgrade avoids this difficulty and leaves creates a new datafile copy with the added benefit of full internal de-fragmentation.

(** indicates that it may take some time.)

Stage 1

  1. Choose a fast terminal with lots of RAM and spare disk space to do the upgrade on and exit any other programs running.
  2. Do not uninstall Omnis 7 V1.x. You will need the design version.
  3. Install the latest Omnis 7 V3.x.x design copy.
  4. Install the latest CaliachMRP (from CD or from the internet ftp site).
  5. Backup your Datafile (we will call it OLDDATA from now on).
  6. Copy any custom file formats from your old CalMRP Options [CALOPTON.APP] into V2.28 - V2.50 Upgrade application [UP28-50.APP]. This is important, otherwise loss of data will result.
  7. With Omnis 7 V1.x run the "V2.28 - V2.50 Upgrade" application [UP28-50.APP] in Single User Mode.
  8. Select OLDDATA.
  9. You will be asked if you have Re-organised the data. Answer No.
  10. Confirm your intention to re-organise and let it run without interruption **.
  11. When complete, select Change Data File from the Upgrade V2.28-V2.50 menu.
  12. Select your OLDDATA again.
  13. When the same "Have you re-organised?" message appears, answer Yes.
  14. If all is well, you will receive a message telling you that you are ready for upgrade to V2.50.
  15. Quit [Exit] Omnis 7 V1.x.
  16. OLDDATA is now internally set at V2.4000 and will not run with CaliachMRP V2.28.

Stage 2

  1. Using Omnis 7 V3.x.x upgrade any customisation you may have had in your old CalMRP Options [CALOPTON.APP] into the new CalMRP Options [CALOPTON.LBR], particularly any special files or file format changes, such as 3 decimal places for part prices. Copy any customised file formats into the new CaliachMRP [CALMRP.LBR] and CalMRP Data Fix [CALDAFIX.LBR]. This is important, otherwise loss of data will result.
  2. Open Omnis 7 V3.x.x and you should be viewing the Format Browser.
  3. With the Browser, open CalMRP Data Fix [CALDAFIX.LBR].
  4. Open the menu STARTUP.
  5. In procedure 0, select the lines from "While not(#F)|(MCDVERS<M_VERSION)" up to and including the line "End while".
  6. Press Ctrl-; to comment out the selected lines.
  7. Close the STARTUP design window.
  8. Now install the STARTUP menu to run the program.
  9. Select OLDDATA first,
  10. Then create a new data file (we will call it NEWDATA).
  11. Operate the menu function Datafile Re-Creation>>Test and Recover.
  12. If you have custom file formats you must operate the "Re-build Code" button.
  13. If you have many Graphics in the Engineering data you will need to adjust one values in the TESTREPAIR menu, if not skip the next 5 steps.
  14. Move back to the Format Browser and open TESTREPAIR menu design.
  15. Select the GRAFILE procedure in or around procedure 320.
  16. Select the line some way down that reads "If #LN=5000"
  17. Change the 5000 to 50 in the calculation box below.
  18. Close the TESTREPAIR design window and return to the Test and Recover "File List" window.
  19. Select all list lines.
  20. Click "Check Selected" ** and let it complete.
  21. See the Data File Repair section of the Reference Book if any problems are identified.
  22. Click "Copy Selected to New" **. This will build a completely new data file populating it with your data with Omnis 7 V3.x.x internal structure.
  23. When complete exit Omnis 7.

Stage 3

  1. Launch the latest version of CaliachMRP [CALMRP.LBR].
  2. Select NEWDATA when it asks for a data file (not OLDDATA!).
  3. Log in with your ID and password.
  4. CaliachMRP will now go through an automatic upgrade sequence, including adjustments to sales history invoices and the general ledger. Let it proceed unhindered. It will take a few minutes.
  5. Now you have a datafile upgraded to the latest version. Check it thoroughly before permitting other users to work on it.