FAQ

Contents

1 How to take Backup of Database
2 My Time Office shows the "Demo" License. How do I rectify?
3 Why am I getting error related to emergencyalarm and regionid while doing the quick configuration?
4 How do I Create the Database and DSNs on platforms other than Windows XP, SP2?
5 How do I do Configurations when I replace the Controller?
6 My current status report takes too much time to execute. What should I do?
7 How to I Optimize the database?
8 How do I remove the DSN entries from ODBC Settings using Windows Registry?
9 Controller E400 or ER40 on reboot sends event of year 2000. Whats wrong? What do I do?
10 How to create port specific CentralStation Server instance?
11 How do I make antipassback work?

How to take Backup of Database

Step 1

Start > Programs > MySQL > MySQL Administrator

Step 2

Host: localhost
Username: root
Password: xxxxxxxxxx
Click OK

Step 3

Click on Back UP on left panel
Click on New Project on Right Panel
Click on Schemata sptodb
Click on > button
Click on Schemata spcsdb
Click on > button
Now you should one of the following actions depending on what are you taking backup of database for

To store backup for future use

Make sure all are selected

To transfer database for support of configuration purpose to Snehapadma

Make sure all tables are selected but do not select following

sptodb.timeevaluation
sptodb.transactionlog
spcsdb.message
spcsdb.messagecard

Click on “Execute back-up now”
Save to correct directory (E.g. Snehapadma\ Back-up\) & appropriate file name without deleting time information click on save
Back-up should be done without errors & Click OK
Close the Windows. (Menu- File Close)

My Time Office shows the "Demo" License. How do I rectify?

Step 1

Start > Programs > MySQL > MySQL Query Browser

Step 2

Host: localhost
Username: root
Password: xxxxxxxxxx
Default Schema: sptodb
Click OK

Step 3

In the SQL Query Area, copy following query. Replace Name of Company with Name of the End User Company.

Update config set spValue = 'Name of the Company' WHERE spParameter = 'CompanyName';

Click on Execute Button.
In the Status Bar, you should see: 1 row afftected by last command.
Close the Windows. (Menu- File Close)

Why am I getting error related to emergencyalarm and regionid while doing the quick configuration?

This might be because you have installed the database from backdated CD. For the version 9.07.01, you need to install the database from the following attached seed database file. Before that, you need to delete the existing database. To do this, follow the instructions as:

Step 1

Start > Programs > MySQL > MySQL Query Browser

Step 2

Host: localhost
Username: root
Password: xxxxxxxxxx
Click OK

Step 3

RightClick on database schema spcsdb and click on Drop Schema to drop it.
Similarly drop schema sptodb

Step 4

Download the file attached below with name SPTOnCSSeed9.07.01.sql or insert the Snehapadma CentralStation 9.07.01 CD
Click on file Open Script to load the downloaded file. If you are running the file from CD, please load it from location Disk\9.07.01\Seed Database
Click on Execute
Close the Windows. (Menu- File Close)

How do I Create the Database and DSNs on platforms other than Windows XP, SP2?

There are two database related jobs done by SnehapadmaDBTool distributed in the CD. Creating the Database Schema, Users, their passwords etc, and creating the DSNs so that the software communicates with the database server. If you have to install the Snehapadma CentralStation on PC with another Windows OS such as Windows 7, Windows Server 2003 or Windows Server 2008, you need to do these things manually. Below are how to instructions for it.

The Database Creation is same as described in the previous FAQ https://sites.google.com/a/snehapadma.com/snehapadma-centralstation-manual/faq#TOC-Why-am-I-getting-error-related-to-e. Here, you have to do step 1, step 2 and step 4. No need to do the step 3 as no schemas are present there.
To create the DSN, please refer to link

How do I do Configurations when I replace the Controller?

When you replace the controller, you need not reconfigure door, areas, access groups etc. All you need to do is

Step 1

Stop the Snehapadma CentralStation Server

Step 2

Give the new controller same IP address, Port No, CentralStation IP address as the controller you are replacing from its web console.
Make sure that you set Controller Door Behavior as necessary from supplementary configuration of the controller from its web console

Step 3

Start the Snehapadma CentralStation Configurator from menu Start > Prgram > Snehapadma > Snehapadma CentralStation > Snehapadma CentralStation Configurator
Go to Detailed Control Configuration using menu Configurations > Detailed Configuration > Controller
Select the controller you want to replace
Edit the controller information
Change the MAC Address of this controller to MAC Address of new controller
Save the Information.
Close this application

Step 4

Start the Snehapadma CentralStation Server from Start > Prgram > Snehapadma > Snehapadma CentralStation > Snehapadma CentralStation Server
Do Initial Provisioning of the new controller.
This should also push all the credential data to the new controller.

My current status report takes too much time to execute. What should I do?

The current status report contains analyzing current transaction logs, which can be very time consuming if the transactionlog table is not optimized or is having large number of entries. You need to optimize database as explained below in order to take care of this.

How to I Optimize the database?

You need to log into MySQL query browser and run the script Optimize_spcsdb_sptodb.sql attached below as explained in Time Office FAQ.

How do I remove the DSN entries from ODBC Settings using Windows Registry?

We have found that the ODBC entries can not be updated or removed in two situations:

After creating ODBC in Windows 7 using ODBC driver 3.51
If you delete and reinstall the ODBC Driver without removing DSN entry

This is how you rectify it:

For 32 bit systems:

Launch RegEdit
Browse to Registry Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
Remove entries dsnspcsdb and dsnsptodb from here.
Also remove

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\dsnspcsdb
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\dsnsptodb

For 64 bit systems:

Launch RegEdit
Browse to Registry Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources
Remove entries dsnspcsdb and dsnsptodb from here.
Also remove

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\dsnspcsdb
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\dsnsptodb

Controller E400 or ER40 on reboot sends event of year 2000. Whats wrong? What do I do?

The issue is due to the battery on the E400 controller. You can change the battery to resolve the issue . Lithium battery 3V, CR2032. Please find the location of battery in the image below:

Remove the back panel and the plastic label to find the battery. Carefully lift and remove the battery and replace with a new one .

How to create port specific CentralStation Server instance?

The following steps show an example of how to create server instance specific to port 4071 for controllers with id 1, 2, 3 and 4

Go to folder

for Windows 7: C:\Program Files (x86)\Snehapadma Software Technologies Pvt Ltd\Snehapadma CentralStation™\
for Windows XP: C:\Program Files\Snehapadma Software Technologies Pvt Ltd\Snehapadma CentralStation™\

Right click on CentralStation Server.exe
Create shortcut to desktop
Create folder 4071
Cut and paste the shortcut from desktop to folder 4071
Rename Shortcut as "4071 CentralStation Server.exe"
Right click on shortcut and change following properties

Set Start In as

For Windows 7: "C:\Program Files (x86)\Snehapadma Software Technologies Pvt Ltd\Snehapadma CentralStation™\4071"
For Windows XP: "C:\Program Files\Snehapadma Software Technologies Pvt Ltd\Snehapadma CentralStation™\4071"

Set Target as

For Windows 7: "C:\Program Files (x86)\Snehapadma Software Technologies Pvt Ltd\Snehapadma CentralStation™\CentralStation Server.exe" 4071 1 2 3 4
For Windows XP: "C:\Program Files\Snehapadma Software Technologies Pvt Ltd\Snehapadma CentralStation™\CentralStation Server.exe" 4071 1 2 3 4

Now you are set. When you run the new shortcut from folder 4071 it will create an instance of Snehapadma CentralStation Server with port 4071 and will connect to controllers with id 1, 2, 3 and 4.

How do I make antipassback work?

For antipassback to work please ensure following:

In Area definition please ensure

In area and Out area of a door must be defined separately.
i.e. you can not have same area with "In" checkbox checked and "In" checkbox unchecked for a door in the list of associated doors of the area.

If you want to have global antipassback (multiple doors on same antipassback group) you must use V1000-V100 combination. At maximum you can have 32 doors on antipassback.

Optimize_spcsdb_sptodb.sql

(0k)

Harshal Baviskar,

Oct 21, 2011, 10:14 PM

v.1

SPTOnCSSeed9.07.01.sql

(266k)