Quick reference for deploying trader services on Windows server.
:: Verify TRADER.FDB exists and is accessible
dir C:\traderftp\Technocore\TRADER.FDB
:: Check Firebird service is running
sc query FirebirdServerDefaultInstance
:: Download fbexport for Windows
:: https://sourceforge.net/projects/fbexport/files/
:: Extract fbexport.exe to:
C:\Program Files\fbexport\fbexport.exe
:: Add to PATH
setx PATH "%PATH%;C:\Program Files\fbexport"
:: Test database connection
fbexport -D C:/traderftp/Technocore/TRADER.FDB ^
-U SYSDBA ^
-P INT7753931 ^
-Q "SELECT COUNT(*) FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG = 0"
:: Expected output: Should show count of tables (320)
:: Install Python 3.12+ from python.org
:: Create virtual environment
cd C:\path\to\axion
python -m venv venv
:: Activate
venv\Scripts\activate
:: Install dependencies
pip install -r resource.config\requirements.txt
:: Edit config.yaml and verify these paths:
notepad config.yaml
:: Check these sections:
:: trader.location_windows: C:/traderftp/Technocore/TRADER.FDB
:: trader.sql_folder_windows: C:/traderftp/Technocore/sql
:: traderftp.host: 102.36.24.130
:: traderftp.port: 7000
:: Create SQL output folder
mkdir C:\traderftp\Technocore\sql
:: Verify write permissions
echo test > C:\traderftp\Technocore\sql\test.txt
del C:\traderftp\Technocore\sql\test.txt
axion directory to Windows server.git directory is included if using version controlvenv\Scripts\activate
python factory.service\package.fullhouse\ObjServiceTrader.py run
Expected: Downloads ZIP files from FTP server
:: Extract a small table first
fbexport -D C:/traderftp/Technocore/TRADER.FDB ^
-U SYSDBA ^
-P INT7753931 ^
-Si ^
-Q "SELECT * FROM ALIAS_TYPES" ^
> C:\traderftp\Technocore\sql\test_extract.sql
Expected: Creates SQL file with INSERT statements
venv\Scripts\activate
python factory.service\package.fullhouse\ObjServiceFullhouseAgent.py extract
Expected: Extracts all priority tables (from def_tablemeta)
venv\Scripts\activate
python factory.service\package.fullhouse\ObjServiceImportSql.py scan
Expected: Imports extracted SQL files into MySQL/MariaDB
:: Check SQL folder for generated files
dir C:\traderftp\Technocore\sql\*_extract.sql
:: Check file sizes
dir C:\traderftp\Technocore\sql\*_extract.sql /s
:: Spot-check content of a file
type C:\traderftp\Technocore\sql\ALIAS_TYPES_extract.sql | more
:: Test MySQL/MariaDB connection (verify config.yaml settings)
python factory.core\ObjData.py preflight
Expected: Shows successful connections to all configured databases
:: Add to system PATH permanently
setx PATH "%PATH%;C:\Program Files\fbexport"
:: OR add to session PATH
set PATH=%PATH%;C:\Program Files\fbexport
:: Verify
where fbexport
:: Check Firebird service
sc query FirebirdServerDefaultInstance
:: Check database file exists
dir C:\traderftp\Technocore\TRADER.FDB
:: Check fbclient.dll is accessible
where fbclient.dll
:: Test network connectivity
ping 102.36.24.130
:: Test port 7000
telnet 102.36.24.130 7000
:: OR use PowerShell:
Test-NetConnection -ComputerName 102.36.24.130 -Port 7000
:: Verify virtual environment is activated
echo %VIRTUAL_ENV%
:: Should show: C:\path\to\axion\venv
:: If not activated:
venv\Scripts\activate
:: Reinstall dependencies
pip install -r resource.config\requirements.txt
:: Verify you're running from project root
cd
:: Should be: C:\path\to\axion
:: Check working directory in Python
python -c "import os; print(os.getcwd())"
:: Create scheduled task for daily extraction
schtasks /create /tn "Trader Extraction" ^
/tr "C:\path\to\axion\venv\Scripts\python.exe factory.service\package.fullhouse\ObjServiceFullhouseAgent.py extract" ^
/sc daily ^
/st 02:00 ^
/ru SYSTEM
:: Create scheduled task for hourly sync
schtasks /create /tn "Trader Import" ^
/tr "C:\path\to\axion\venv\Scripts\python.exe factory.service\package.fullhouse\ObjServiceImportSql.py scan" ^
/sc hourly ^
/ru SYSTEM
For issues:
WINDOWS_SETUP.md for detailed setup instructionsTRADER_SERVICES_SUMMARY.md for architecture overviewlocal.documents/trader/ directoryconfig.yaml are correct for Windows:: Activate environment
venv\Scripts\activate
:: Test extraction
python factory.service\package.fullhouse\ObjServiceFullhouseAgent.py extract
:: Test FTP download
python factory.service\package.fullhouse\ObjServiceTrader.py run
:: Test import
python factory.service\package.fullhouse\ObjServiceImportSql.py scan
:: Show CLI help
python factory.service\package.fullhouse\ObjServiceFullhouseAgent.py --help