FAQ

Contents

  1. 1 Installation Issues
    1. 1.1 I get run time error while opening Manpower Planning for because of COMCT232.OCX is not found. How do I solve it?
  2. 2 Report
    1. 2.1 I do not see the Report at all. What has gone wrong?
    2. 2.2 I do not see the reports as expected. What could have gone wrong?
    3. 2.3 Salary Slip Data report gives ODBC Error. How do I rectify it?
    4. 2.4 Leave Balance report gives ODBC Error. How do I rectify it?
    5. 2.5 Detail Report gives ODBC Error unknown column 'timeevaluation.Remark'. How to I rectify it?
  3. 3 MySQL
    1. 3.1 How to set the group_concat_max variable in MySQL Server?
    2. 3.2 How to run the MySQL Script using MySQL Query Browser

Installation Issues

I get run time error while opening Manpower Planning for because of COMCT232.OCX is not found. How do I solve it?

You need to download and register this OCX. Please follow the following steps:
  1. You need to download the COMCT232.OCX from link http://centralstation.snehapadma.com/Home/software-installation/COMCT232.OCX?attredirects=0&d=1 to your desktop.
  2. Copy it to system32 directory. Typically this directory is C:\Windows\System32.
  3. Click on Start -> Run
  4. Run command REGSVR32 C:\WINDOWS\SYSTEM32\COMCT232.OCX to register the OCX
This should resolve this issue.

Report

I do not see the Report at all. What has gone wrong?

You are seeing report of the person for two reasons.
  1. The date for which you are seeing report is not within the Joining Date and Leaving Date of the employee.
  2. The manpower planning for the person is not done. Please refer to Manpower Planning to understand how to do it. After you do the manpower planning, process the data to see the reports. Easiest way to process data is close and open Snehapadma TimeOffice again.

I do not see the reports as expected. What could have gone wrong?

This can happen if time events are received after the processing for the day is already done. To rectify this, you need to Reset Processing for the concerned employee(s) and then process the data again to see the report.

Salary Slip Data report gives ODBC Error. How do I rectify it?

This may be related to group_concat_max variable setting of the MySQL Server. Please refer to How to set the group_concat_max variable in MySQL Server for more details.

Leave Balance report gives ODBC Error. How do I rectify it?

This may be related to group_concat_max variable setting of the MySQL Server. Please refer to How to set the group_concat_max variable in MySQL Server for more details.

Detail Report gives ODBC Error unknown column 'timeevaluation.Remark'. How to I rectify it?

Please download the SQL Script DetailedAttendance.sql from the bottom of the page and run it using MySQL Query Browser. Please refer to How to run the MySQL Script using MySQL Query Browser for more details.

MySQL

How to set the group_concat_max variable in MySQL Server?

Please follow the instructions as below:
  1. Close all the MySQL based applications. This may include Snehapadma CentralStation Server, Configurator, TimeOffice, Visitor Management System etc.
  2. Open the MySQL Administrator from Start -> Programs -> MySQL -> MySQL Administrator Menu
  3. Login as root
  4. Click on Service Control tab from the left panel
  5. Click on Stop Service to stop the MySQL Server
  6. Click on Startup Variables tab from the left panel
  7. Click on Advanced tab from the right panel
  8. Go to bottom of the page and check on property "Group concat max"
  9. Set it to 256 k
  10. Click on Apply Changes
  11. Click on Service Panel from the left panel
  12. Click on Start Service to run the MySQL Server again.
  13. Now open the Time Office.

How to run the MySQL Script using MySQL Query Browser

Please follow instructions as given on page Run Script.
ċ
DetailedAttendance.sql
(12k)
Harshal Baviskar,
Apr 11, 2010, 10:42 PM
v.3
Comments