Uploading is used to reload data which has been transferred to history tables using the Purging option. If for some reason, data pertaining to closed work orders is required in the existing database, it can be done using Uploading.
Before Uploading, make sure all users have logged out and Backup has been taken of the database.
Select File/Uploading from the Main Menu. The screen for selection of the database from which data has to be uploaded (i.e. Purged database) is displayed.
For Access Database : Select database with extension .mdb.
For Oracle Database : Select database extension .dmp.
For SQL Server Database: All devices on which purged databases are taken will be shown in the list. For any selected device uploading will be carried out. Before uploading, the original device file should be on the same location from where it was taken. If the device files are copied to storage devices and deleted from the hard drives, they should first be restored to the hard drives and then uploading should be carried out.
After this has been done, the message "Make sure all users are logged out" is displayed. Click OK after ensuring that all users are logged out.
The question "Are you sure backup is taken of the database?" is then displayed. On confirmation, the Uploading process begins.
After completion, the message "Uploading is completed." is displayed.
If an attempt is made to upload data from the same database more than once, the message "Data has been already uploaded for the selected file" is displayed.
Steps In Uploading
Data to be uploaded is transferred to intermediate tables within the database.
Data is transferred to the actual tables after data integrity is verified.
Data is deleted from the intermediate tables.
Some related data might have been deleted after Purging and this would cause a problem at the time of Uploading. If at any stage during the Uploading process, an error is encountered, it is displayed on the screen and written into a logfile. This logfile will list all errors encountered. The message "Uploading not successful. Refer to the logfile" is displayed along with the name and location of the logfile.
The Administrator must view this file, enter related data and then execute the process once more. The log file will be created in the same directory where the Purged database exists. The name of this file will be ProqmsUploading with the current date appended to it. It will have the extension .log.
In case of any error, the database is maintained at the state in which it was before the Uploading process began.