Collect Tool is used to configure access to Forms on Fire and where SQL data resides.

Collect Service is used to run scheduled jobs the either send data to Forms on Fire or retrieve data from Forms on Fir

Collect Tool

Step 1: Copy Aeros Collect Database to SQL Server

CollectSetting table holds the connection information to Forms On Fire

CollectConnection table holds the connection information to the local databases 

Note: These configuration are accessed from within the Collect Tool

Step 2: Copy Aeros Collect to Client Server.

Note: This package currently does not have an installer.

Step 3: Set Collect Tool Database Configurations

From within the Aeros Collect folder edit the CollectTool.exe.config file using Notepad

Change the CollectEntities and the quartz..dataSource.default.connectionString configurations for the client's SQL database name and connection information.

Note: When you save the changes you may be prompted for a save location. Save the modified file to the desktop then move the file back to the original location.

Step 4: Create Shortcut on Desktop of Collect Tool

Right click on Collect Tool Application to create shortcut.

Rename shortcut to Collect Tool

Then set Collect_Logo as Icon for Collect Tool Shortcut

Step 5: Collect Tool Configurations

Configure Settings tab to access Forms On Fire

Note: Company ID and Integration Key are unique to each client

Configure Connections tab to access local SQL database data

Note: Data Sources and Form Data tabs use these connections to send data to Forms On Fire and save data from Forms On Fire locally.

Step 6: Test Forms on Fire Form Data Connection

Once a Forms On Fire form is created and associated with a table in a local database the data can be manually retrieved using the Form Data tab.

Choose Form Data Tab, then choose Sync Log tab and click the Sync button at the bottom of the form.

Note: The sync process will insert a row into the CollectSyncLog table of the COLLECT database. This database table gets very big and performance of the Collect Tool suffers as a result. Old sync log data should be purged regularly.

Collect Service

Step 7: Copy Aeros Collect Service to Service Server.

Note: This package currently does not have an installer.

Step 8: Set Collect Service Database Configurations

From within the Aeros Collect Service folder edit the CollectService.exe.config file using Notepad

Change the CollectEntities and the quartz..dataSource.default.connectionString configurations for the client's SQL database name and connection information.

Note: When you save the changes you may be prompted for a save location. Save the modified file to the desktop then move the file back to the original location.

Step 9: Install Collect Service

To install Collect Service right click and choose Run as administrator

Next run Task Manager then navigate to Services tab.

Click on Open Services, locate Aeros Collect, right click and choose Properties.

Set Startup type to Automatic (Delayed Start)

Click Start button to run the service

Click Ok button to exit the Properties form