»

• Welcome
  

• Download COMPOSE
  

COMPOSE Programming

Recreation 2024 710q:

• Delphi 2010 Architect
• JEDI Debug
  

• GExperts
  
  Programming infrastructure:
  

• Delphi 2010 Architect
• MS SQL 2008 R2 for remote data
• SQL 2008 Native Client
• Microsoft Access 2007 File Format ACCDB for local data
• Microsoft Access Database Engine 2007 Redistributable
• Filezilla FTP Server Remotely
• Optimax.dll - license required for non-academic users
• Open Source Solvers: CoinMP.dll, LPSOLVE.dll, GLPK - integration with CPLEX and GUROBI with custom parameters.
• Mathwave SDK for statistical analysis and risk distributions
• Woll2Woll InfoPower
• Raize Components
• ScrewTurn integrated WIKI
• TMS Flexcel for non-OLE spreadsheet handling
• TMS Diagram Studio
• JEDI Debug
• TurboPower Abbrevia for compressed file handling.
• DCPCrypt for password handling.
  

Supporting infrastructure:

• IDE Fix Pack
• CnPack IDE Wizards
• GExperts
• AutomatedAQ's AQTime and Build Studio
• InnoSetup Quickstart Pack with ISTool script editor and InnoSetup Preprocessor
• RedGate SQL Compare and SQL Data Compare
• Camtasia - so far, for COMPOSE TV
• Adobe Connect - for webinars
• Service Manager on Server
• WMware Workstation for testing on Windows 8/10
  

Server Requirements:

• Microsoft SQL Server as default instance on port 14016 allowing remote IP (Setting default instance).
• FTP server on port 21 with write access to c:\ftps\compose
  

Flowdiagram:

• Build CBs
• Build Demands
• CalcProcesses
• Optimize Project
• CalcResults
  

Server Setup

• Install SQL server, mixed authentication
• Rename sa account
• Firewall inbound 14016
• Router port forward 14016 to host
• Set SQL Server Configuration Manager Login as Network Service
• Set SQL Server Configuration Manager TCP/IP protocals port 14016
• Copy backups and restore cdb, cdbid, energyinteractive
• Run autofix on users on ALL three databases
  

USE EnergyInteractive
GO
EXEC sp_change_users_login 'Auto_Fix', 'username', NULL, 'password'
GO

• Make user bulk admin
  

• Install filezilla server
• Copy the two zilla xml files to server folder
• Open firewall for filezilla program
• create folder ftps/compose
• Copy test.dll to ftp folder
• Copy networktest.sql to ftp folder
  

• install, source, backup not beskrevet
• Copy COMPOSE folder minus cdb? Location important?
• Setup webserver EnergyInteractive?
• MSSQLSERVER must have read access to bulkfolder, either FTP folder or user temp folder for local operation "c:\Users\pc\AppData\Local\Temp\COMPOSE\"