The purpose of this article is to walk a program administrator through duplicating their existing Fabshop or SheetMetal database to have a completely independent new database.

Some principles to understand first:

There are three critically important parts to the QuoteSoft Legacy database

The Data Files, Item Option Files, Pressure Files, are all stored in the DataFile folder within the Fabshop or Qserver folder
The Jobs are stored in the JobFiles folder in the Fabshop or Qserver folder
1. In Fabshop it is Customers with Jobs
2. In SheetMetal it is Jobs with Zones
The JOBINDEX.mdb indexes the Customers/Jobs for proper display within the program

To create a new Database for QuoteSoft

Copy the Fabshop or Qserver Folder and rename it to your desired new name
1. Do not use a space in the name, for example Fabshop New would be an invalid name, instead use FabshopNew
2. This may take a while as you are copying all customers, jobs, zones, spreadsheets, plan files, pressure files, etc
Copy the local workstation folder and rename it
1. Fabshop workstation folder is named Fab. Example new name is FabNew
2. SheetMetal workstation folder is named Quote. Example new name is QuoteNew
Copy the desktop shortcut and rename as well

The files are now created, we now need to connect the new icon to the new workstation folder and then to the new data files

I. First the desktop icon

Right click your new desktop icon and choose properties
On the Shortcut tab, modify the path listed in the Target and Start In boxes as shown below

II. Now connect the new workstation to the new database

Double click your new desktop icon and login to the program with an administrator level of permissions
Click on Administration on the Main Menu
Lower right, Location of Database, click into the box
Click Browse button and navigate to your new Fabshop or Qserver folder
Click on the JobIndex.mdb and hit Open
The program will close and on reopen you will be connected to the new database

III. Archive Jobs and Zones to start with an empty Job or Customer File

Make sure no other users are in the program
Log into the program with administrator level permissions
Click on the Administration button on the Main Menu
Click on the Archive Old Jobs/Bids button
After clicking OK to proceed do not be alarmed if it takes a while to present the next screen, the more Jobs you have the longer it will take to show
In the Archive Jobs Older Than box select todays date and click Archive
This process will take quite a long time as it archives each job individually

IV. Deleting the archived Jobs and Zones

On Administration page click the button that says Delete from Archive by Date
This process will also take quite a while to complete
1. Almost exactly the same amount of time the Archive process took
When completed you should have an empty Customer List in Fabshop and no jobs in SheetMetal

Browser not supported