Operation Educate: Supervisor Tools (Mac version)

POSIM Diamond saves all of your daily activities to a single database on a server computer. After a few years of running your successful business this database will eventually become very large with a lot of history. It will cause your program and computer to run slower. For this reason, and many others (ease of reporting and faster access to historical data) there are advantages to keeping your Point of Sale database well managed.

Supervisor Tools:

Supervisor Tools is the back end program that has all the tools for database management. Supervisor Tools can be found in the POSIM Diamond folder on your hard drive.


Show File Sizes:

This window shows the number of records each table in your database contains. This is useful when deciding whether or not to purge or consolidate history or other data in your database.

Rebuild Database:

If you have been instructed by Technical Support to rebuild your database, you will be brought to this screen to complete the task. This is similar to doing a defragment on a hard drive.

Click on Rebuild All and it will ask you where to save the new database. Once it is complete you will need to copy and replace the new rebuilt database into the data folder in the POSIM Diamond folder.

This should only need to be done once a year. Every time we release a new version of POSIM we require a rebuild of the database. So if you are on the latest version of POSIM then you will not need to do this manually.

Consolidate History:

If your database has become very large and slow over the years, consolidating history is the first option to reducing the size and increasing speed. Consolidating history means taking all the lines from the invoices in a month and moving them to a single invoice with all the inventory and sales information on it. You will still be able to run reports for these periods of time - just not on a daily basis.

Purge History:

If you have data in your database from 4 or more years ago, you may consider removing it if it is no longer relevant. This will increase the speed of everything from reports to daily operation in POSIM. The Purge window will allow you to remove history such as Invoices, Purchase Orders, Receiving Logs, etc.

Erase Files:

The Erase Files option will delete an entire file in your database. To clear out all vendor or customers and start from scratch, select each one invidually and click "Erase."

It's important to understand that there is not an undo button here. If you accidentally erase something there is no way to recover that information unless you have a backup of your database.