Electrical Design Software | Elecdes Design Suite by Scada Systems Ltd

Project Database Template / Structure / Directories

New Cable Scheduler project databases are created from templates. The template used to create the database contains default tables and default configuration data.

File locations / Directories

The database templates, import map files, template DSN files and report templates of Cable scheduler are all located in the <EDS>\CABSCHED directory of the EDS installation.

These are all user customisable files.

Within the directories page of the EDS Setup program, you can select an alternate location for these files. This could be done in the circumstance where these files needed to be shared by several users.

Microsoft Access and SQL Server

Cable Scheduler is supplied with a Microsoft Access project database template, suitable for creating project databases for both Microsoft Access and Microsoft SQL Server. This template is named "Access Template.mdb".

Creating or Modifying Project Database Templates

You may create your own project database templates. The template is copied to the new project database name when you create a new project.

A database template provides a place to make initial configuration, which you would otherwise need to do for every new project.

Cable Scheduler will check the database for certain required tables and columns and the type of those columns. If your existing database is missing something or you have created a new database from a template that is missing something then you will be asked if you wish to fix the errors when you open the project.

Updating Existing Projects with Template Changes

If you have added new tables or added new columns to existing tables in your database template, you can update an existing project database with these changes. Choose Update database from current template from the File menu to start this function. If you have only a single database template then that template will be used automatically. If you have more than one template then you will be asked to choose the template from which to update your database.

Project Database Template Location

Save your database templates in the <EDS>\CABSCHED\DBTemplates directory.

Default Database Template Choice - "Shortcut"

As a shortcut, if there is only a single Database Template provided by your administrator within the <EDS>\CABSCHED\DBTemplates directory then it will be used by default without asking you to choose.

Project Database Load in to Elecdes Project Cache

Under normal operation Cable Scheduler will update the Elecdes project cache with any changes that have been made during the session prior to shut down or creating wiring diagrams or EDS reports.

The data updated in the Elecdes project cache is controlled by the image file templates in the <EDS>\RTEMPLATE directory. (e.g. The file template_$DEVICE.DBF contains all of the columns that can be written into the Elecdes project cache for Devices).

Should you have extra columns of data that you wish to include in the Cable Scheduler database and later output to the various EDS diagrams and reports then you will need to add this column to the appropriate template file.