Inloggen Registreren

Login to your account

Username *
Password *
Remember Me

Create an account

Fields marked with an asterisk (*) are required.
Name *
Username *
Password *
Verify password *
Email *
Verify email *
Captcha *

ODBC connection

Zorg dat de server is geinstaleerd en installeer de (firebird/postgres/mysql) odbc driver

Ga dan naar de odbc administrator en voeg een nieuwe ODBC systeem verbinding toe.

 

 

 

In excel create a new database query.

The flowing screen will appear. Pres the sql button and past the sql below this screen shot to see all transaction input in the database.

 

SELECT V_TRANSACTASBATCHWITHTRANSID.SREFERENCE, V_TRANSACTASBATCHWITHTRANSID.DDATE, V_TRANSACTASBATCHWITHTRANSID.SACCOUNT, V_TRANSACTASBATCHWITHTRANSID.SDESCRIPTION, V_TRANSACTASBATCHWITHTRANSID.SCONTRAACCOUNT, V_TRANSACTASBATCHWITHTRANSID.STAX, V_TRANSACTASBATCHWITHTRANSID.FAMOUNT, V_TRANSACTASBATCHWITHTRANSID.FDEBIT, V_TRANSACTASBATCHWITHTRANSID.FCREDIT, V_TRANSACTASBATCHWITHTRANSID.FTAXAMOUNT
FROM V_TRANSACTASBATCHWITHTRANSID V_TRANSACTASBATCHWITHTRANSID

Now save the SQL and go to the menu to add a datasource again.

 

Select import data and select the query you just saved.

The data will be imported and you can see the list in excel.

 

if data changes you need to refresh the external source.

you can us the data in excel reporting like charts. This way you can create your own view on the osFinancials or Turbocash data using your Favourite tool.