Try the sample data on Windows

A one-click way to fill your new easy-install with made-up clients (or patients), jobs, invoices and expenses, so you can see how everything works. Your own records are never touched, and you can remove the sample data at any time. (For standard installs see the phpMyAdmin sample-data page.)

The sample records count towards the trial's 10-record limit. Remove the sample data (one click) before you add your own, or delete a record or two, or activate a licence to lift the limit.

Before you start
  1. Extract the zip

    Right-click the downloaded zip and choose Extract All…, then click Extract. Windows can show what's inside a zip without extracting it, but the files won't work from there.

    If you double-click a file and see this box, you're still inside the zip. Click Extract all, then Extract, and use the folder that opens.

    Compressed (zipped) Folders: This application may depend on other compressed files in this folder. Extract all, Run and Cancel buttons.
    Seen this? Click Extract all.

    You can extract it anywhere, for example in Downloads. It doesn't need to go in your software's folder. Keep all the files together in the one folder.

  2. Double-click the Add file, then click Run

    In the extracted folder, double-click Add sample data (…).bat (the name ends with your product's name).

    There are two "Add sample data" files. Windows hides the endings, so pick the one whose Type is Windows Batch File (it has a gear icon). The other one is for Macs: if Windows asks Select an app to open this .command file, you've picked the Mac one, so press Esc and try the other.

    Windows may warn that the publisher could not be verified, the same as when you installed. That's normal for files downloaded from a website. Click Run. (It's like the Mac's "Open Anyway".)

    Open File - Security Warning: The publisher could not be verified. Name: Add sample data (SoleTrader).bat, Type: Windows Batch File. Run and Cancel buttons.
    Click Run.

    If instead you see a blue box saying Windows protected your PC, click More info, then Run anyway.

    There's no need for "Run as administrator".

  3. Press Enter

    A black window opens and tells you what it is about to add. When it says Press any key to continue, press Enter (the Return key). It takes a few seconds, then says Done. Sample data added. along with your software's address. Press Enter again to close the window.

    Command window: Add sample data to SoleTrader. Press any key to continue. Done. Sample data added. Refresh your browser (http://localhost:8081/soletrader). Press any key to continue.
    Press Enter at the first Press any key. When it says Done. Sample data added., press Enter again to close it.

    If it says something else, such as Docker Desktop isn't running, it tells you what to do. Fix that and double-click the file again.

  4. Refresh your browser

    Go back to your software and refresh the page (press F5). The sample clients are there, along with their jobs, invoices, income and expenses.

    The SoleTrader Clients and Projects list showing eight sample clients.
    The client list now has eight sample clients (or sample patients in CrystalSolutions and PraxisClinic).
    The SoleTrader Tax Summary page showing quarterly income and expenditure with an expenditure-by-category breakdown.
    The Tax Summary shows quarterly income and spending, with the category breakdown.

Removing the sample data

When you've had a good look round, double-click Remove sample data (…).bat in the same folder, click Run if Windows asks, and press Enter. Only the sample rows are removed. Anything you've entered yourself stays exactly as it is. You can add the sample data again at any time.

Questions

Is it safe to run?

Yes. The file is a short, plain-text script, and you can read it first: right-click it and choose Edit (or Open with → Notepad). It checks that Docker and your software are running, then adds the rows from the .sql file in the same folder to your database. It doesn't connect to the internet. Windows warns you only because the file came from a website.

It says it can't find the .sql file

The script needs the .sql files in the same folder. Check you extracted the zip (step 1) rather than opening it, and if you moved the .bat file on its own, put it back with the others.

It says "Something went wrong"

It shows the error underneath. If your software has only just started, wait a minute and try again. If it still fails, note the error text and ask on the support forum.

It says my software isn't running

Open Docker Desktop, go to Containers, and start your software if it isn't running (press the play button next to it). Wait for it to show Running, then double-click the file again.

I ran it twice. Do I have duplicates?

No. Running it again removes the earlier sample rows first and then adds them again.

I'm on a Mac, or I'm not using Docker

On a Mac, see Sample data on a Mac. Without Docker (XAMPP or a web server), use the phpMyAdmin sample-data page.

Remember: the sample data is made up. Every name, address and phone number is invented, and it isn't meant for a live practice or business. Remove it before you start entering your real records.