- PHP
- MySQL or MariaDB
- TradeTracker API credentials
Create a file /config/db.ini and enter your database credentials in the following format:
hostname=your_hostname
databasename=your_databasename
username=your_username
password=your_passwordImport all SQL files from the database directory into your database:
mysql -u your_username -p your_databasename < /path/to/database/file.sqlInsert a new row into the config table with your TradeTracker API credentials:
INSERT INTO config (name, configuration) VALUES ('tradetracker', '{"customerID":"######","passphrase":"########################################","sandbox":"","locale":"nl_NL","demo":""}');Transfer all files to your server.
Schedule importTradeTrackerData.php to run periodically to import your TradeTracker account data into your database. You can use a cron job for this:
# Example cron job to run the script daily at midnight
0 0 * * * /usr/bin/php /path/to/importTradeTrackerData.phpOpen tradetracker.php in your browser to view the TradeTracker dashboard.