Installing Typica on Windows

While Typica can work without any additional software, the functionality of the software is severely reduced without two other important pieces of software. One is the PostgreSQL relational database management system which Typica uses as its primary data store and the other is a driver used for communicating with a device that takes thermocouples from the roaster and provides a USB interface that a computer can use to obtain temperature measurements. This driver must be installed on the same computer running Typica if that computer will be connected to a coffee roaster. Machines that are only used for cupping or reporting features do not need this. PostgreSQL can be installed on any computer on your network. These instructions will assume that everything is being installed on the same machine and that the machine is running Windows.

Step 0: Turn off any anti-virus software.

This is a common first step before installing any software. Anti-virus software will at best slow down installation and at worst prevent the software from working. Once Typica is up and running, you should turn such protections back on.

Step 1: Install and Configure PostgreSQL

PostgreSQL downloads for Windows are available from For these instructions, we will be using the one click installer. Click the link to download the one click installer and select the most recent version of PostgreSQL for Windows. At the time of this writing, this was version 8.4.3-1, however no changes that would cause Typica to stop working are anticipated so if there is a more recent version available, go ahead and get that. This will download a file named such as "postgresql-8.4.3-1-windows.exe".

Run the installer downloaded above. If you get a security warning for attempting to run an executable file downloaded from the Internet, click the Run button to allow the installer to run. After a moment, you will see the PostgreSQL Setup Wizard.

Click Next.

The default installation directory is usually a good choice. Click Next.

The default data directory is usually a good choice. Click Next.

Next you'll need to choose a password for the database superuser. Pick something that you'll be able to remember later as you'll need this to finish setting up the database to work with Typica. Enter the password of your choice into both password fields and then click Next.

The default port number is expected. Click Next.

The defaults for the advanced options are also fine. Click Next.

Click Next. PostgreSQL will now be installed. This takes a little while, so enjoy a nice hot cup of coffee while waiting for this to finish.

Typica doesn't need anything from Stack Builder, so the check box can be unchecked before clicking Finish. You can always start Stack Builder later if you want something from that. Of particular interest are things like the ODBC and JDBC drivers which can be used to allow other applications to access the data Typica stores.

Congratulations. You have just installed PostgreSQL. PostgreSQL will now have a user named postgres and a database named postgres. Typica can use these if you would like, but you may want to create your own database user and a database specifically for use with Typica. Creating a new database is a good way to ensure that the database is properly installed and running. For more details, please consult the excellent PostgreSQL documentation.

From the Start menu, select All Programs, PostgreSQL 8.4, SQL Shell (psql). This will prompt you for a server. The default (localhost) is correct for these instructions. Press the Enter key on your keyboard. At this time, postgres is the only database set up, so press the Enter key again. The default port number is correct, so press the Enter key again. The only user that currently exists is postgres, so press the Enter key again. You will then be prompted for the password. Type the password you chose earlier and press the Enter key.

You may now enter SQL statements. For these instructions we will assume that you will continue to use the postgres user and you will create a database named, "inventory". Type the following statement and then press the Enter key.


Note the semicolon at the end. This is important. You should see the response:


You have now set up a new database for Typica to use. Next, type the following and press the Enter key.


This will disconnect you from the database. Press any key to close the window.

Step 2: Install Driver Software

Typica uses a library called NI-DAQmx Base to communicate with a device that is connected to the thermocouples in your coffee roaster and to your computer. Different devices require different versions of the software. The appropriate version should have come with the hardware, but it can also be downloaded from National Instruments. However you get it, run the installer. The following screenshots come from the NI-DAQmx Base 2.1 installer which is used for the older NI USB-9211. If you're using the newer NI USB-9211 A, there will be minor differences. You can probably just keep clicking Next.

The default destination directory is fine. Click Next.

Make sure that you are installing NI-DAQmx Base and its sub-item C Support. These should be selected by default. Click Next.

Click the radio button to accept the license agreement. Click Next.

Click Next. The software will now be installed. This would be a good time to enjoy another cup of coffee.

Click Finish. You will now be instructed to restart your computer. Go ahead and do that now.

When you connect the device, the hardware will be detected and Windows will prompt you to download a driver for the USB carrier. It should be able to complete this task automatically. It will then prompt to do the same for the thermocouple interface. Once again, it can take care of this automatically. Only after all of that has been done can Typica successfully communicate with the device.

Download and Extract Typica for Windows.

Typica for Windows is distributed as several files in a Zip archive. Download this archive and extract it anywhere you like. The program is Typica.exe. You can open this to start Typica. You may want to create a shortcut to this file for more convenient access such as from the Start menu or the desktop.

Now you are all set to start using Typica. Please see the Typica User Guide for more information on making the most of Typica.