Database Tools

This section contains a number of useful database management and optimization tools, which may be accessed via MIDAS Admin Options → Manage MIDAS → Database → Database Tools.

Merge Booking Types

This tool allows you to combine two or more booking types into a single booking type, updating all existing bookings accordingly.

Merge Clients

This tool allows you to combine the bookings & invoices from two or more clients into a single client. For example, is a user adds a new client named "Jo Blogs" and then another user adds the same client but spells it slightly differently as "Jo Bloggs" - these will be seen as two separate clients in MIDAS. The "Merge Clients" tool will allow you to combine these two clients into a single client.

Merge Venues

This tool allows you to combine the bookings from two or more venues into a single venue.

Remove Obsolete Bookings

This tool allows you to remove very old bookings held in your MIDAS, dating back several months or years. Whilst maintaining accurate booking records is important, many organizations don't need to keep track of bookings that took place more than a few years ago. This option allows you to choose to wipe bookings from your MIDAS that are more than either 6 months old, or older than 1-10 years.

Keeping your booking data trimmed by removing old booking data can also increase the performance of MIDAS.

Remove Obsolete Invoices

This tool allows you to remove very old paid-in-full invoices from your MIDAS system, dating back several months or years. Whilst maintaining copies of invoices is important, many organizations don't need to indefinitely retain copies of invoices that were paid many years ago.

Removing old invoices can also increase the performance of MIDAS.

Remove Inactive Clients

This tool allows you to "clean up" the client database by removing obsolete clients who haven't had a booking in MIDAS for a long time. You can choose to remove clients with no bookings in the last 6 months, or in the last 1-10 years.

Remove Inactive Users

This tool allows you to "clean up" the user database by removing obsolete user accounts that haven't been logged into MIDAS for a long time. You can choose to remove users who haven't logged in within the last 6 months, or within the last 1-10 years.

Reset Invoice Counter

Each time a new invoice is created in MIDAS, the invoice number counter automatically increments. For instance, if the first invoice created is "MIDAS0001", the next invoice will be "MIDAS0002" and so forth. Occasionally, you may wish to reset these counters back to 1. The "Reset invoice counter" tool allows you to do this for either the regular, deposit, or cancellation invoice or credit note counters.

"Unfinalize" Invoices

Once an invoice has been printed or emailed to the client, MIDAS considers it to be "finalized", and locks its content from further modification. This is to ensure that what's been sent to your client matches the invoice held in your MIDAS system.

The "Unfinalize" Invoices tool allows you to remove this "lock" on a finalized invoice. However, it's important to note that "Unfinalizing" an invoice does not cancel, delete, recall, or revoke it. Instead, when you "Unfanialize" an invoice, its invoice date is removed, allow full editing of the invoice's content again.

Optimize Database

This tool runs the "OPTIMIZE TABLE" MySQL command on your MIDAS database. This command effectively "defragments" your MIDAS database by reorganizing the physical storage of data. In doing so, it can reduce the amount of storage space and improve overall efficiency of your MIDAS database.