The Database

The Database

Previous pageReturn to chapter overviewNext page

CHPS stores all the machinery information in a database, the initial installation of CHPS populates the database with commercial Yarders, Carriages and Cables specifications. You can add custom machinery (Yarders, Carriages and Cables) to this database through a CHPS interface so you can run Profiles with your custom machinery.

 

The application needs to interact with the database constantly, a valid connection must be provided in order to make this interaction possible.

 

There are two database connection options;

 

SQL Express / SQL Enterprise

If you use SQL Express or enterprise SQL and would like your CHPS users using the same database then use this option and enter the valid connection properties into the Database Connection. Note that SQL Express needs to be installed on the machine prior to installing CHPS.

 

The advantage of using Enterprise SQL is the ability to share custom machinery between users.  If this is not a requirement, then using SQL compact (see below) is much easier.

 

To improve performance objects from the Database are cached and are updated every five minutes or when a change is made by the user. Therefore if another user adds something to the Database it might not appear right away.

 

This Database must be created before it can be used. See Creating a New CHPS Database for more information.

 

SQL Compact

SQL Compact 3.5 needs to be downloaded and installed if you would like to go with this option. The SQL Compact option is different to SQL Express / SQL Enterprise in that any edits you make in the database (ie adding custom machinery) will only be available to other CHPS users if they use the same PC.

 

SQL Compact will have you up and running with CHPS faster, and it is a good idea to use this option if you are trialling CHPS or have no need to share custom machinery across multiple users.

 

Disclaimer

The information included in this database is based on either the specification plate on the hauler or the wire rope which is being used on these machines.  This information is supplied to provide the planner a starting place, from which to investigate and verify the suitability of any particular combination of wire ropes for the machine being considered.  The planner is solely responsible for verifying that the particular machine that he/she is planning for is using or can use the ropes which are used in their analysis.  The authors of the analysis program cannot accept responsibility for the choice of wire rope which is used on any particular machine or the suitability of that rope to that machine.

 

http://cableharvesting.com/help//3-Accessing_CHPS_in_ArcMap.Setup_your_database_connection.The_Database.htm                                                                                                                                        

 

Topic Last Updated: Tuesday, 13 September 2016