FAQ

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.

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
  1. Go to folder 
    1. for Windows 7: C:\Program Files (x86)\Snehapadma Software Technologies Pvt Ltd\Snehapadma CentralStation™\
    2. for Windows XP: C:\Program Files\Snehapadma Software Technologies Pvt Ltd\Snehapadma CentralStation™\
  2. Right click on CentralStation Server.exe
  3. Create shortcut to desktop
  4. Create folder 4071
  5. Cut and paste the shortcut from desktop to folder 4071
  6. Rename Shortcut as "4071 CentralStation Server.exe"
  7. Right click on shortcut and change following properties
    1. Set Start In as 
      1. For Windows 7: "C:\Program Files (x86)\Snehapadma Software Technologies Pvt Ltd\Snehapadma CentralStation™\4071"
      2. For Windows XP:  "C:\Program Files\Snehapadma Software Technologies Pvt Ltd\Snehapadma CentralStation™\4071"
    2. Set Target as 
      1. For Windows 7: "C:\Program Files (x86)\Snehapadma Software Technologies Pvt Ltd\Snehapadma CentralStation™\CentralStation Server.exe" 4071 1 2 3 4
      2. 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:
  1. In Area definition please ensure
    1. In area and Out area of a door must be defined separately. 
    2. 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.
  2. 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
ċ
SPTOnCSSeed9.07.01.sql
(266k)
Harshal Baviskar,
Mar 15, 2010, 2:47 AM
Comments