Table of Contents

1.0 Cimplicity Interface Introduction
1.1 Install
1.2 Updating Cross References
1.3 Importing Cimplicity Data
1.4 Cimplicity Trending Files

 
1.0 Cimplicity Interface Introduction

The JOB PLUS/CAL - Cimplicity Interface software is used for transfer of daily values from the Cimplicity historical database to JOB PLUS/CAL.  The Cimplicity, a software package by GE, trends real time data to a historical database (Microsoft Access Database).  Data is read from the Cimplicity historical database, summarized based upon the specified statistic and the resulting value is placed into the Meter table in the JOB PLUS/CAL database.
1.1 Install
To install JOB PLUS/CAL Cimplicity Interface, follow these steps:

1. Select the Cimplicity Node the software is to be installed on.  The JOB PLUS/CAL Cimplicity Interface software must be installed on a Cimplicity Node that also has JOB PLUS/CAL installed.
2. Place the floppy Cimplicity Interface Disk in drive A or the Interface CD in your CD Rom drive.
3. In Windows, close all programs that are currently running.
4. Choose [Start], [Run] from the Start Bar.  Windows will prompt for the Command Line, type a:setup or d:setup (where d: is your CD ROM Drive) and click OK. Follow the instructions on the screen and the installation program displays the following box:
    
   Figure 1
   
5. Click Finish to proceed.  Install the program in the same directory that you installed JOB PLUS/CAL (usually C:\JOB\).

1.2 Updating Cross References

In order for the transfer of data to occur, you must first setup a cross reference between Cimplicity Table Name:Column Name and JOB PLUS/CAL equipment.  See your Cimplicity documentation for more information on Table Names:Column Names.

To update cross-references, bring up the Equipment Record and click  .  The following form
will be displayed
 
Figure 2

The example shown cross-references the Cimplicity signal tag (LIFT1: L1_FLOW_VAL0) with the Cimplicity LIFT1 table and the column L1_FLOW_VAL0 with the JOB Plus/Cal equipment Pump. A colon (:) separates the table name and the column name.

Field Descriptions

Signal Tag 

The Cimplicity Table NAME:Column Name to import data from.  For example, LIFT1:L1_FLOW_VAL0 would cross reference the Cimplicity datapoint from the LIFT1 table and the column L1_FLOW_VAL0. A colon (:) separates the table name and the column name.
 

Statistic 

The statistic to perform on the Cimplicity data.  The following options are available from the drop down list box:

Last Good Reading – Takes the last reading for the day and places it in the Meter Reading Table.

Add to Previous – Takes the last reading for the day and adds it to the last meter reading in JOB Cal/Plus for the equipment.  Add to Previous is typically used when the value to be transferred is the daily runtime and is reset everyday. 

Accumulate Difference – Takes the last reading for the current day minus the last reading for the previous day and adds that value to the last meter reading.  Detects if the meter reading has rolled over.  For example:
Date       Last Reading     Meter Reading Stored
12/13/99   950                   14000 
12/14/99   985                   14035 (14000 + (985 – 950))
12/15/99   10                     14060 (14035 + 25 (Rollover assumed at 1000))
12/16/99   42                     14092 (14060 + (42 – 10))

If there is no value for the previous day, the current days last reading will be added to the last meter-reading value found in JOB Cal/Plus. 

Scale Factor 

Used as a multiplier to scale the statistic before placing the value in the database.  For example, if Cimplicity is storing the number in tenths of hours use a scale factor of .1 to convert the reading to hours.  If Cimplicity is storing the runtime in minutes, use a scale factor of 0.0167 (1/60) to convert the reading to hours. 

1.3 Importing Cimplicity Data

You can create an icon on your desktop which can be used to start the program.  To do this:

1. Open Windows Explorer and find the directory where cimplicity.exe is located which is usually C:\Job
2. Right click on the executable and select Send To/Desktop (Create Shortcut).
3. Click on the JOB Cimplicity Interface icon to start the import program.

The Interface main form will display:
 
Figure 3
 
Using OPS Cimplicity Interface

Fill in the Start and End Dates.  Enter the Source Access File and click OK.   The start date defaults to the last date imported plus one day.  The End Date defaults to yesterday.   Data will be imported from the Cimplicity historical files for the date range for the JOB PLUS/CAL variables that are cross-referenced. 

Field Descriptions

Start Date 

The beginning date to collect data.  The Start Date will default to the last date that was successfully imported plus one day. 

End Date 

The ending date to collect data for.  The End Date will default to yesterday.

Cimplicity Historical File

The Access file that is linked to the Cimplicity database.  See section 1.1.1 for more information on linking to the Cimplicity database.

Buttons
. . . - Used to browse for the Source Access File.
OK - Perform the import.
Exit - Exit the program.

1.4 Cimplicity Trending Files

Cimplicity trends real time data to a Microsoft Access historical.  Data can be trended to a variety of tables in the access database.  Your database should be similar to the following:

Figure 4

Figure 5

Running the interface automatically

Method 1 (This is the recommended method).
To run the interface on a scheduled basis use the Autorun settings.  Each setting is described below.

To run the interface every day at a set time:

1. Select the “Daily” option button.
2. Enter a time of day to run.
3. Click Start.

To run every hour:

1. Select the “Hourly” option button.
2. Enter a Run every hour time.
3. Click Start.
   

Reduce the interface by clicking on the minimize button to reduce the interface to the taskbar.  The interface will now run on the scheduled basis. 
NOTE: YOU MUST LEAVE THE INTERFACE RUNNING TO ALLOW THE INTERFACE TO AUTORUN.  If you shutdown the program the interface will not run.  You should add the CIMPLICITY.exe program to your start group in windows to allow the interface to run if the computer is restarted.

Method 2 (Method 1 is the recommended method).

The interface can be run automatically on a scheduled basis using command line arguments.  There are several programs on the market that allow you to run a program on a scheduled basis including Microsoft System Agent (older Microsoft Operating Systems, Windows95), Microsoft Task Scheduler (newer Microsoft Operating Systems, including 98, 2000 and XP), WIN NT AT command, Norton Program Scheduler, and several others. If you invoke the interface with a command line argument the program will perform the import for the default dates and exit the program. The start date will be set to the day after the last date the interface was run and the end date will vary according the command line argument, if it is 1 the end date will be set to yesterday and if it is 2 the end date will be set to today.

Understanding Task Scheduler (newer Microsoft Operating Systems, including 98, 2000 and XP).

Task Scheduler starts each time you start Windows. It runs in the background starting programs at the scheduled times. You can schedule a new program or change the schedule for a program that is already scheduled. To use Task Scheduler, click the Start button, point to Programs, point to Accessories, point to System Tools, and then click Scheduled Tasks

Figure 6

Double click on Add Scheduled Task to bring up the Schedule Task Wizard.

Figure 7

Click on the browse button in order to find Cimplicity.exe

Figure 8

Cimplicity.exe is usually located at C:\Job\

Figure 9

Select how often you want to run the task.

Figure 10

Select at what time to run the task.

Figure 11

Enter your logon name and password.

Figure 12

Check the Open advanced properties checkbox and then click Finish.

Figure 13

Remember to enter either a 1 or 2 for the command line argument as explained above.  Click Apply.

Figure 14

Using Windows NT AT command to autorun interface.

The AT command is an NT service used to autorun windows applications.  It can be used to autorun the interface.   The SERVICE “Schedule” must be running for the AT command to work. See “Schedule service” in WINNT HELP for more details. To setup the AT command, go to the Command Prompt. Enter the following command line to autorun the interface at 1:15 AM.

AT 1:15 /EVERY:M,T,W,TH,F,S,SU “C:\Job\JobCimplicity.exe” 1

NOTE: The parameter 1 is OUTSIDE the quotes.

Figure 15

Understanding System Agent (older Microsoft Operating Systems, Windows95 where it is included on the Microsoft Plus!  For Windows 95 CD-ROM).  System Agent starts each time you start Windows.  It runs in the background, checking your computer for low disk space and starting programs at the scheduled times.  You can schedule a new program or change the schedule for a program that is already scheduled.  When System Agent is running, this icon appears next to the clock on the taskbar: If the System Agent is not running, click the Start button, point to Programs, point to Accessories, point to System Tools, and then click System Agent.

Log Files

This program generates log files that are used for troubleshooting.  They are located in the Logs subdirectory beneath the directory where cimplicity.exe is located on the users local computer, in most cases it will be C:\Job\Logs.  The name of the files have the following format: JobCimplicityLogmmddyyyy.txt where mm is the month, dd is the day and yyyy is the year (example JobCimplicityLog10172002.txt).