Linx Training Resources

Tutorial
1

This post contains the details to be used in the in-person Linx training.

Resources:

Here are the resources that you will need during the training:

CSV

Here is the CSV file that you will need during the training:
clients.csv (5.0 KB)

Database:

Here is the SQLite database:
TrainingDB.zip (899 Bytes)

Unzip it and place it somewhere - this is the database you will be setting up in the ODBC connection.

API

Setup

Before you start building in Linx, you need to set up your database environment. You can use any database technology you want, however in the tutorial video a specific SQLite database is used. You will need to set up the ODBC connection to connect to this database. This can be done with the following steps:

  1. Download and install the SQLite ODBC driver from: [SQLite ODBC Driver (ch-werner.de)](SQLite ODBC Driver)

  2. Specifically, you will need to download sqliteodbc_w64.exe: http://www.ch-werner.de/sqliteodbc/sqliteodbc_w64.exe

  3. Download the database from above and unzip the file into a folder on your computer

  4. You can now connect to the SQLite database in Linx by using a properly configured connection string. The connection string will have the following format:

Driver={SQLite3 ODBC Driver};Database=MyFilePath;

MyFilePath will be the full file path of the database, so if you placed it in C:\Training\DB\ you will have a connection string that looks like this:

Driver={SQLite3 ODBC Driver};Database=C:\Training\DB\TrainingDB.db;

See Connection Editor for more details.