Import/export data with UR30

 

UR30 data is stored in a SQLite database. It is located in folder database of the installation folder:

 

 

The database name is: SlotCar30.db. Its structure is described here.

 

This data can be exported from this database with any ODBC compliant software. SQLite ODBC drivers can be downloaded here.

 

Create a data source on UR30 database when the ODBC driver is installed. Example:

 

 

The DSN can be used in any software when configured.

 

Caution: before doing any changes in UR30 database, take care of the table relationships to avoid to break data consistency integrity.

 

Example: import driver list from UR30 database into an Excel spreadsheet

 

1 – start Excel

2 – select: Data -> New database query

3 – follow up the wizard query build steps to query the UR30 database

 

 

4 – build the query you need. Here: extract all drivers:

 

 

5 – click on "OK"

6then close the query window and confirm import into Excel

 

Then all drivers are imported into the Excel spreadsheet.

 

This method can be used to extract all data from ur30 to build advanced statistics, or export them into another Race Management System or anything else.

 

It's up to you!