CAMAlot Installation Procedure

Note: All downloads can be made from our Web site: www.camalot.ca

- On workstation computers:
1.	Create a shortcut pointing to 'CAMAlot.exe' on your server.
2.	Make sure the screen resolution is at least 600 x 800, and the display font size is normal.
4.	Make sure there is a default printer installed (this is required by the QuickReport engine).
6.	Make sure any firewall/security software allow 'CAMAlot.exe' access to the internet.
Also, if the computer will be used to make releases,
'CAMAlotRelease.exe' and port 3050-outbound should be allowed to access our server (Internet IP: 96.53.215.132).
8.	Right-click on the CAMAlot shortcut, and select 'Run As Administrator'.
Do this the first time, even if logged into Windows using an Administrator account.
CAMAlot will then have sufficient privileges to download local Marshall & Swift Estimator files.
9. Log in, to make sure the database is accessible and start the download process.
10.Install Apex, if needed.
Run Apex once outside CAMAlot to create the configuration files by right-click on the shortcut and selecting 'Run As Administrator', even if logged into Windows using an Administrator account.

 - On offsite computer / tablet:
1.	Log in Windows as Administrator.
2. Setup databases.
a) Download & install Firebird (use the same version as your server)
b) Restore the database using SQL Manager or IB Expert.
3.	a) Create an empty 'CAMAlot.INI' in the CAMAlot folder.
b) Add these entries and change the values appropriately:
[Offsite]
Server Program Path=\\server\CAMAlot

[Compass]
Login=
Count=1

Name 1=CAMAlot (Offsite)
Location 1=localhost:C:/CAMAlot/Data Files/CAMAlot.fdb
Blob 1=localhost:C:/CAMAlot/Data Files/CAMAlot Blobs.fdb
Server Connection Number 1=1

5.	Check that 'CAMAlot.INI' on the server has the following entry (with the correct value):
[Offsite]
Server Offsite DB Path=\\SERVER\CAMAlot Offsite

6.	CAMAlotRelease.exe
-Download www.camalot.ca/release/CAMAlotRelease.exe to the CAMAlot folder.
-Run it.
It will download and install all necessary files to run CAMAlot.
It will also update the databases if needed.
7.	Run CAMAlot and login as SYSDBA.
a) In the Offsite Manager, sync the databases.
b) Run the Summary report from the Property Manager to make sure there are no problems.
c) Add users using roles REMOTEUPDATE & UPDATEDATA:
- Compass
- Offsite users

- On a server or stand-alone computer:
1.	Log in Windows as Administrator.
2.	Setup a way to connect remotely to the server so we can offer support when needed.
3. Here are two possible folder tree organizations.
Note: Any folder can be moved to suite your needs.
(1) Only one base folder:
	\CAMAlot
	+--Program 	(Shared R/W)
	+--Data Files
	|	+--Offsite 	(Shared R-O)
	+--Backups
	|	+--Log 	(Shared R-O)
	+--History 	(Shared R/W for most users)
 	+--Attachments	(Shared R/W for most users)
(2) Another option; everything that needs to be backed up is on a separate drive:
	C:\CAMAlot	[Binaries]
	+--Program 	(Shared R/W)
	+--Data Files
		+--Offsite 	(Shared R-O)

	D:\CAMAlot	[Backed-up data drive]
	+--Backups
	|	+--Log 	(Shared R-O)
	+--History 	(Shared R/W)
	+--Attachments 	(Shared R/W)

4.	Share the folders on the LAN, as described above.
5.	Start copying History reports, if needed.
6.	Setup databases.
a) Download & install Firebird. http://www.firebirdsql.org
b) Download & install SQL Manager or IBExpert. http://www.camalot.ca/downloads.html
c) Restore the database [with the converted data] using CAMAlotServer/SQL Manager/IBExpert.
d) Create an ODBC alias for the database, if needed.
7.	Configure the server INI file.
8.	Download CAMAlotRelease to the CAMAlot folder and run it. http://www.camalot.ca/release/CAMAlotRelease.exe
9.	Make sure there is a default printer installed (required by the QuickReport engine).
10.Make sure any security software allow 'CAMAlot.exe', 'CAMAlotServer.exe', and 'CAMAlotRelease.exe' 
to access our cloud server (camalot.munisight.com).
Also, open the following ports:
-3050 inbound (for CAMAlot local DB) 
-3050 outbound (for CAMAlot Release DB) 
-211 inbound (for CAMAlotServer).
12. Run CAMAlot.
a) Make sure there are no problems.
	Especially, run the Summary report from the Property Manager.
b) Get the latest release. (menu/Help/Check for new release)
c) Add the users:
- Compass
- Guest
- All other users
d) Update path to History reports using Special Ops/CAMAlot.
13. Setup database backups using CAMAlotServer.

DONE !