ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Introduction for Archiving/Restoring

The Archiving and Restoring Utility will allow users to Archive their unused files,  which should help speed up the response time for users with large databases.  These files will be removed from your Live Manex System and placed in the archive directory setup by the user performing the archiving.  (We strongly recommend that you do not remove this directory once it is setup or you will loose all files for restoring).  Only supervisor or user with "EDIT" rights in System Utility can run archiving/restoring programs.  When the archiving or restoring is loaded, it will open database exclusively.  Therefore, no user can run any other programs at the same time.  This program will have "Back" and "Next" buttons to lead you to what you should do next, you also can go back to change whatever you selected before you click the "Archive" button.  The program will create a spreadsheet of what's going to be archived, if you click "OK" then it will continue to archive those records.

The Archiving features will not affect accounting in any way, because once the transactions are created within the system from regular ManEx that information is retained in different accounting tables.

"ResetArcLock.exe" is in your ManEx Root Directory.  This is in case user interrupts the program or reboots the machine during archiving, the system will still think the user is doing the archiving.   This program will clear out the flag, and at the end, this program will also ask user to re-run datamaintenance.exe to keep data integrity.

NOTE:  For those users who have archived data, when user finds a record, let's say a PO.  The program will go to check current ManEx database to see if the part numbers of all PO items exist.  If not, the program will tell user that one or more items are "removed".  It might be deleted or archived, and the program will ask user if he/she wants to check the archived part number list.  If user selects "Yes", the message also tells user it will take a while to find the archived information.  If user selects "No", then the program will not go to archived database to check, and user can find another PO to continue.  When processing a new inventory part and depressing the "Save" record icon, the system will only check the "Live" database for duplicate part number.  When user restore part numbers from archived database, for now, those duplicate old part numbers will be filtered out and  won't be restored to current database.

 

Article ID: 1618