PC Repair Tracker

Move your customers, work orders, invoices, payments and inventory from PC Repair Tracker (PCRT) into RAD Repairs by uploading a copy of its database.

Before You Start

PC Repair Tracker has no online connection to read from, so the import works from an export of its MySQL database. Only the account owner or an admin can run it, from App Center > PC Repair Tracker.

PC Repair Tracker import page in App Center

The PC Repair Tracker page: export instructions, what comes across and what never does, the upload box, the list of what was found in the file, and the import progress with a result for each step.

Step 1: Export Your PCRT Database

Export the whole database as one .sql file, or better, a compressed .sql.gz file. A compressed export is usually 5 to 10 times smaller and uploads that much faster.

Step 2: Upload the File

Choose the file. The page shows its size and an estimate of how long the upload and the reading will take. Click Upload and read. The file is sent in pieces, then read once on the server. The list under Check what was found and import shows how many customers, work orders, invoices and so on were found. If the file is not a PCRT database, or it is cut off, the page says so.

The file itself is deleted as soon as it has been read. The rows needed for the import are kept until you click Delete uploaded data, upload a new file, or 14 days pass.

Large Databases

From the Welcome Wizard

A new shop can do the same from the last step of the Welcome Wizard: Data Migration → PC Repair Tracker. Upload the file there, tick the two options, and click Import and Complete Setup; the import starts and keeps running in the background. Setup cannot be completed while the file is still uploading. While it is being read you can wait, or click Skip & Finish and start the import from this page later.

Step 3: Import

Two options come first:

Click Start import. The progress bar and the step name update as it runs, and you can Pause, Resume or Stop it. When it finishes, the page lists how many records each step imported, updated or skipped, and any record that could not be imported with the reason.

What Comes Across

What Is Never Imported

These columns are removed while the file is read, before anything is saved.

Running It Again

You can upload a newer export later - for example on the day you stop using PCRT - and run the import again. Records already imported are not duplicated. New customers, work orders, notes, invoices and payments are added; work order statuses, paid or voided invoices and stock counts are brought up to date. Changes you made in RAD Repairs to imported records are kept, except a work order whose PCRT status changed since the last import.

Check before you switch: after the import, open a few customers, tickets and invoices and compare them with PCRT. When you are happy, click Delete uploaded data.