Time Tracker™ Advanced User Manual V 2.0.5
Contents
1. Server Info Session One Session Two Session Three Total Other i Service Name Fe Database Type MSSQL Active No Database Name Fe User Name be Password be Server Pa Table Name Fe Interval Sec gp Report Date Personnel Nr n fe SMA TimeTracker Advanced User Manual V2 0 5 18 Page sma This screen has 6 tabs and each tab has to be filled In server info tab first you have to give a name to the service you are creating writing on the field Service Name Then select the Database type from the drop down option select the activation status of the service Yes or No from the drop down Enter the interval time in second so the service runs automatically after certain second Write the address IP of the server in the server field for creating connection to the server Enter the name of the Database where you want to export the report Enter the user name amp password which the database user use to logon to the database in respective field then enter the table name where you export the records enter the report date column in the Report Date enter the personnel Nr field name of the destination table in the Personnel Nr field enter the Remark field name of the destination table in the Remark field If you have only one company then select yes else No select the company name from the list then go to session one link Server Info Session One Session Twa Session Three Total Othe2. Time Tracker Advanced User Manual V 2 0 5 SMA TimeTracker Advanced User Manual V2 0 5 1 Page TABLE OF CONTENTS eL 9 L 8 8 RFFENEYNFRF NENN EY OY NA EFANS FEN E E E E T SEF CAF FYNENT FFF FN FEN 3 LLE Ya NE SN _ R NF E T FF AY HN HEFFER FARF NR FFF EEF 4 PTO FET CCS oe _ e RC RF Y FN HE A EF YF PN RF NFYFC FT FE FF FFYN FF 5 3 1 Prora CS cic E E E E E E T E A N 5 3 1 1 FES FGI OG AE E EE IR CR CF FF A IE EF FT E E 5 3 1 2 ACUE DE CTO ann i E E E UA i OUD CDU 6 3 1 3 COR UI O e E anne E E O E 7 3 2 Eia RHENT RUN NEFYN ee E HEN DY RW E ee ee 7 3 3 DAE AAS SCI VICE 5 ei aposncineceneh A E A E E E E E iantanameptannianeane 8 3 4 E COS EE Pr E EIEE CAR CA E E YY RE YY A RF RF NN EF YA 10 3 4 1 PU OCC SS O S o E E E SF UED UU ESF DARFU 10 3 4 2 RODT OCOS Seoane r n E HT A CR A HA AY A Y RI I AU Y Y YC NR 11 3 5 ARGONNE ET __ Y RE THAN FFA Y FE HF RF XR A Y RY FE HE HR FR TYR FD es 12 3 5 1 ST t VIC FA gt u 0 _ CR FAU NF FARF CYN RF RF FN NF CEFN RI RYW 13 3 5 2 BM o O Y Y YO REN RTNEN CH PG HN RW YH ARE FTP DWF FA Y FFF EF FFYN EFA ANS FE TN 14 3 5 3 OVS OWING ST r HAN YF FEE FN HEFY CY NF HI EA Y Y SE FA HD 15 3 5 4 NN EA E emcee v lt FR WNA A RW FR NR RW HR FN RYN 16 3 5 5 PHONY FE FYN NEF FFAN FY FR END EDN NHU AN HT NN FERF FR MU FAND 16 3 5 6 HR Log TOF Exception Handling scesc
3. tables 3 2 License If you click on License then the following screen will open in front of you Browse gt Upload x Clean License Key 00 1A 6B 5D 19 83 Client Name SMA Demo v2 0 1 Client ID TTDOOOO Start Date Tue May 20 00 00 00 AST 2008 Personnel 800 System Users 2 HR Integration 1 Email Service 1 SMA TimeTracker Advanced User Manual V2 0 5 7 Page sma In this screen you will know what kind of license you have How many Employee you can add into the system Do you have HR Integration Module Do you have Email Services and so on e Click Browse Select the location you put the license jar file in e The file will then appear on the box Click Upload Button to upload that file into the system e Log out from the system e Restart the TimeTrackerST services e Login again amp check the license detail you will find the updates there 3 3 Database Services e Click on Preferences Database Services gt New then the following screen will open in front of you This screen has three Tabs Database Information Column Information amp General Information Database Services Database Column Name suprema TYPE MSSQL v Active Yes a IP 192 168 1 1 Port 1433 Database bpioadmin Username ttuser Password seeccccce Output Table Name TimeEventlog e Provide name of the service General vx e Select the database source such as MS SQL ORACLE MYSQ
4. all the issues regarding personnel Employees Schedule link is used to deal all the issues regarding Shifts Schedules session SMA TimeTracker Advanced User Manual V2 0 5 4 Page sma 3 _ Preferences In this section you can do tune the system The entire database Services Event Log Function 8 l Keys and System Policy all can be treated in this section Click on main Menu it will show side menu choose the respective option you want to use 3 1 Preferences If you click on Preferences then you will find there are some options such as Free Field Active Directory and Key Code etc select the option you like to use 3 1 1 Free Fields By using Free Fields you can add more fields while defining the personnel details in Personnel Personnel New such as Car Registration No Nationality and National ID etc e Click on Preferences gt Preferences Free Field user Definable Fields then the following screen will appear No of Free Fields g e Select the Number of New Fields you want on the Personnel Screen The following window will appear on the screen No of Free Fields 3 w Free Field 1 Nationality Free Field Arabic 1 Nationality Free Field 2 Driving License oo _ Free Field Arabic Driving License e Enter the Caption Name of the field you like to give for these fields in English as well as Arabic SMA TimeTracker Advanced User Manual V2 0 5 5 Page e Press the Submit button to save
5. any company you define in the company section e Press submit button to save the changes you made 3 4 Services 3 4 1 Process Services e Click on Preferences gt Services gt Process Services then the following screen will appear SMA TimeTracker Advanced User Manual V2 0 5 10 Page Process Service 20 RPService 01 01 1900 Active RRService 04 02 2009 Active Gantner aa 01 01 1900 Service GAT FingerTem Active Device Failure 01 01 1900 Deactive FKService y 01 01 1900 Deactive v Archive Service 01 01 1900 Deactive RPExtService S 01 01 1900 Deactive This screen gives you picture that which service is active or inactive how much time interval of each service you can manually start the service any time by clicking start Process and you can also activate amp deactivate any service by selection the Activation status from the drop down list and press update to save the changes Please note that the RRService should always show the current date in start date column 3 4 2 Reprocess Through reprocess you can reprocess the records of employees in a case where you have created a schedule with some parameter e g where you have mentioned that late grace time as 10 mins and now you want to change it to 15 mins However previous records have already been processed with the grace time of 10 mins and and will not get affected by the new change In that case you can reprocess those records from this screen e Click
6. column name of Total Missed in the field Total Missed Enter the destination table column name of Total Hours in the field Total Hours Enter the destination table column name of Total Overtime in the field Total Over Then click on other tab Server Info Session One Session Two Session Three Total Other Schedule Name Schedule Hours Actual Hours Policy Late Policy Overtime Company Id Search String SMA TimeTracker Advanced User Manual V2 0 5 20 Page ye sma In this section you have to map the general information about the schedule amp policy Enter the destination table column name of Schedule Name in the field Schedule Name Enter the destination table column name of Schedule total Hours in the field Schedule Hours Enter the destination table column name of Actual Hours in the field Actual Hours Enter the destination table column name of Policy Late in the field Policy Late Enter the destination table column name of Policy Overtime in the field Policy Overtime and company ID in Company ID 3 7 Event Import Service This is the facility to Import the Event In amp Out of other system into Time Tracker System of the employees e Click on Preferences Event Import Service gt New then the following screen will appear So A seen Interval Sec Function Key Eventtime Hint dd MM yyyy HH mm Company Id lo Hint COMPANY_NAME e Enter the Name of the Service you wish to create in
7. keep the history of Holiday data from Holiday History e Provide the name of the view created for holiday details e Map the fields accordingly e Leave Holiday where and search as blank Press submit after filling out the details 3 5 6 HR Log for Exception Handling The HR service log has been provided for the purpose of exception handling e Click Preferences gt HR Services gt HR Log the following screen will appear SMA TimeTracker Advanced User Manual V2 0 5 17 Page From 09 04 2009 F TO 09042009 F TYPE ERROR vw Show Report Datetime Function Description Thu Apr 16 VERIFY 13 22 40 DEPARTMENT com microsoft sglserver jdbc SOLServerException Invalid column name REMOVAL DATE GST 2009 QUERY Thu Apr 16 13 22 42 PROCESS LEAVE com microsoft sqlserver jdbc SQLServerException Invalid object name taview_leave_personnel GST 2009 Thu Apr 16 13 22 42 PROCESS HOLIDAY com microsoft sqlserver jdbc SQLServerException Invalid object name taview_calendar_department GST 2009 Thu Apr 16 1299943 PROCESS ram mirrnenfr colenanine idhe CAL CArunrEwrnntinnms Tranlid ahiact nama teaser narcannaol z e Select the dates to provide the dates you wish to see the log e Select the Log type e Click Show report Report Export If you click on Report Export then you will find some option below click on the desired one If you click on New then the following screen will appear
8. the Name Field e Select the file by clicking the Browse button e Interval reflects the time period the service runs itself like after 5 second this service will run amp import the event e Select Function Key Yes if you are using system with function keys otherwise No e Select the file type you have the system supports MS Excel amp CSV format e Enter the column No of each field in the respective filed such as in the file you have is an excel sheet the column A is 1 column B is 2 and so on column A have personnel number and column B SMA TimeTracker Advanced User Manual V2 0 5 21 Page Ne sma have Event code so enter the 1 in the Personnel No field and enter the 2 in Event code field In the Hint Field you will find the Format of the data to be filled e Press Submit If you click on Preferences gt Event Import Service Modify then the following screen will appear Name Type Interval Sec File Path Process ad 1 500 C Program Files KSAFone INSTALL LOG Click on the Name of the Service you wish to modify it will open the previous screen with the saved information made you changes then press submit button to keep save the changes You can also manually run the service by clicking Start Process button 3 8 Report Export Summary If you click on Report Export Summary then you will find there are some options such as New Modify and Search etc select the option you like to use If you click on New
9. the changes e Go to Personnel2 Personnel New Modify e Search an existing person or register a new personnel e Click Others tab and see the new fields will be available e Provide the data and press Submit Others l Fersonnel Grade gradei2 Card Number 373 4 Hiring Date w Email Password ees Nationality rndian Driving License 12345673 3 1 2 Active Directory If you click on Active Directory then the following screen will appear IP dap 192 168 100 250 385 Base pc smapps DC com Use SSL No In the IP field write the IP of the Domain server if you don t know then contact you Network Administrator If your base is e g smapps com then type DC smapps DC com in base However your Active directory administrator can confirm it to you If you want to logon using SSL then select yes else No then press submit Button to save your changes SMA TimeTracker Advanced User Manual V2 0 5 6 Page 3 1 3 Configuration If you click on Configuration then the following screen will appear Archive Events Months 3 Archive Reports Months 3 Archive Personnel leave Months 3 Cut Off Date 14 w Cut Off Override Date 0 r Single Key No This Screen helps the system to maintain the speedy response to the client By keep doing Archive the system responds faster In this Screen you have to define the period Month that after how many months the system take the archive of Events Reports amp Personnel Leave
10. then the following screen will appear Server Info Table Total Other Database Type MSSOL v Active Notification Time O Notification Day From Day To Day SMA TimeTracker Advanced User Manual V2 0 5 22 Page ye sma This facility help the Admin user to Export the report of employees to other system such as HR system Payroll system etc To create this facility some information has to fill All the fields marked with are mandatory enter the name of the service you are creating then select the database type where you want to transfer the data like MSSQL of Oracle etc Then select the status of the service yes means Active No means Inactive Enter the Database Name in the field on Database Name where the data will store then enter the user name amp password of the database which you use to login into Database in their respective fields Write the IP address of the server where the database is installed in the field Server Enter the time of Notification in the field of Notification Time and enter the number of Notification Day in Notification Day and provide the range to from to till day after filling these info click on the TABLE tab it will open the following screen Server Info Table Total Other a M A5 OE Ss _ _ a In this section you have to fill the information of the Table where you are going to export the data Enter the table name in the field Table Name then enter the personnel num
11. L SMA TimeTracker Advanced User Manual V2 0 5 8 Page sma e Select Yes No from the Active field Yes means the service will active No will make it inactive e Provide the IP of the database server e Provide the Port number on which it communicates with database e Enter the name of the database in the field database e Enter the username amp password which you use to connect to the database e Click on the Column Information tab it will open a new form as follows Database Services Database Column General Table tbh reportslist Timestamp dtDateTime Personnel No UserID Direction ngvent Row ID nIndex Access Point npeviceID Event Code nTNAEvent Company Name e n this tab you have to map the field of system that you using such as LG IrisAccess Nedap AEOS Suprema and Keri Systems Eclipse 700 e Provide the table view name where you have the data to pull e Map the other fields with the ones you have it in the table view Please contact SMA for different mappings for different systems SMA TimeTracker Advanced User Manual V2 0 5 9 Page Database Column General System Query For Suprema v System Query Interval Sec 10 Company Name Company v e Click General tab e Select the system query e g AEOS Suprema etc e Then enter the Interval which is the time period in seconds that the system use to run this query e Select the Company from the drop down list if there is
12. V2 0 5 Page 15 e Leave personnel where and search as blank Then click on the Vacation Information tab to enter the vacation information 3 5 4 Vacation Parameter Department Personnel Vacation Holiday 4 Extra Leave Delete Leave Table taview_leave_personnel Leave Track Id FAVETRACKID Leave Start Date LEAVESTARTDATE Leave End Date FAVEENDDATE Leave Personnel PER SONNELNE Leave TYPE EAVETYPE Leave History 3 Months Removal Date REMOVAL_DATE Leave Where Search e Click on Preferences gt HR Service gt New Vacation e If you want to keep the history of the leave data then select Ignore in Extra Leave Should you want to delete them then select the period to keep the history of leaves from Leave History e Provide the name of the view created for vacation details e Map the fields accordingly e Leave vacation where and search as blank 3 5 5 Holiday SMA TimeTracker Advanced User Manual V2 0 5 16 Page Parameter Department Personnel Vacation Holiday l gt Holiday Table taview_calendar_department Track Id HOLIDAYTRACKID TYPE HOLIDAYTYPE Department DEPARTMENTID Department Type Default Holiday History 3 Months Removal Date REMOVAL_DATE Holiday Where Search e Click on Preferences gt HR Service gt New gt Holiday e If you want to keep the history of the holiday data then select Ignore in Extra Holiday Should you want to delete them then select the period to
13. ber column name of destination table in the field Personnel Nr enter the date from which you need the data to be exported in the field From Date enter the date till you want the data in the To date field then enter the company id column if you have else leave it blank or write 0 then click on TOTAL tab it will open the following screen SMA TimeTracker Advanced User Manual V2 0 5 23 Page Server Info Table Total Other In this section you have to enter the fields name of the table where you export the total of each of his record such as enter the name of the total hours field of the table in the Hour field Missed hours field in Missed total late in field Late total over time field in Over if you have different kind of over time such as normal day over time amp holiday over time amp you calculate it in different pattern then enter the normal over time filed in normal over amp holiday over time in field of Premium Over After completing this tab click on OTHERS tab it will open the following screen Server Info Table Total Other In this screen you have to enter the column name of the table where you want to store the total late Absent and Present of the employees Enter the name of absent column in absent field Enter the name SMA TimeTracker Advanced User Manual V2 0 5 24 Page sma of present column in present field and Enter the name of late column in late field After comple
14. gt New Parameter e Provide the name of the service in Service Name e Select the Database type of your HR database e Select service type o HR database gt system will pull the data from HR views o HR Import gt HR source will push the data to TimeTracker Import tables e Select the Activation as Yes to make the service Active e Enter the interval time in minute so the service runs automatically after certain minutes e Provide the Date format e Provide the start time of the service e g 01 00 e Provide the stop time of service e g 03 00 e Provide the name or IP of the server where your HR database is located SMA TimeTracker Advanced User Manual V2 0 5 13 Page e Provide the name of the HR database e Provide the user name of the database server e Provide the password for that database server e Select the company name e n company in search filed Type the column name of the Company or Business Unit which is uniform across all views E g UNITID 3 5 2 Department Parameter Department Personnel Vacation Holiday 4 Extra Department Ignore Department Table tayiew_department Department Id DEPARTMENTID Department Parent pEPARTMENTPARENTID Department Name En pEPARTMENTNAME_EN Department Name Ar pEPARTMENTNAME_AR Department Type DEPARTMENTTYPE Removal Date REMOVAL_DATE Department Where Search FI e Click on Preferences gt HR Service gt New Department e If you want the manually added departments to stay in the sy
15. nsesasctneesoucecdesancosedeanecdasasvanesonnnnieavauubesteaboenaboctaneatewseennds 17 3 6 RE DOL UE DOLUR DENAU CN O FAU EAR AELF 18 3 7 Event IMPON Sy 5 YN HN ENOC FER AU EEN 21 3 8 Report Export SUMIMALPY cccccsccssccsscesccssccsccsscesscsecesscesscsecessesecesseseceesessesecesstsecesstsecessteseeases 22 SMA TimeTracker Advanced User Manual V2 0 5 2 Page 1 Introduction TimeTracker Advanced User Manual is for the Administrators of the system This is about the configuration settings of the system and not for every user Preferences can be hidden from a normal user s role Please be careful about the settings you do in this section and consult SMA should you reguire some more information SMA TimeTracker Advanced User Manual V2 0 5 3 Page 2 Main Menu The following picture contains all the major links of the system 9 amp a 8 en O pA Intranet Preferences Admin Organization Personnel Schedule Report Suprema Gantner Aeos Logout For more detail check the below table to know which Link is used for what Preference this link is used for tuning the system Here you can define services view event log HR integration Finger print device key codes etc Admin this link is used for administration purpose Here you can define system user Role of the User Holidays etc Organization link is used to deal all the issues regarding Department Company Personnel link used to deal
16. on Preferences gt Services gt Reprocess the search screen will appear e Choose the person you want to reprocess the records You can reprocess a day s record as well as the records between two dates Similarly you can choose more than 1 employee for the reprocessing in this case all selected employees records will be reprocessed for the dates you will provide in From amp To SMA TimeTracker Advanced User Manual V2 0 5 11 Page Reprocess From 94 12 2008 g 9 31 12 2008 9 Name Job Title Personnel No Organization Mare Joy Cleaner 5199 Housekeeping Select Unselect All Start Process e Click Start process e Check reports to see the changes 3 5 HR Service Through HR service you can import organization data and employees details in the TimeTracker software so that you don t need to enter data in your HR software and in TimeTracker twice HR service will automate this process e Click on Preferences2 HR Service gt New then the following screen will appear This screen has 5 tabs SMA TimeTracker Advanced User Manual V2 0 5 12 Page Parameter Department Personnel Vacation Holiday Service Name HRSMA A Database Type MSSOL Service Type HR Database Active No Intervel Min g Date Format gd MMM yyyy HH mm Service Start 57 09 Service Stop 03 00 HR Server HRSERVER HR database yon User Name za Pa om i 3 5 1 Service Parameter e Click on Preferences gt HR Service
17. r In Session One Out Session One Early Session One Late Session One Missed Session One Total Session One Over Session One In this tab you have to map the column of the Session of the destination table In session one field enter the name of IN of session one column of destination table out session one field enter the name of OUT of session one column of destination table early session one field enter the name of Early Time of session one column of destination table late session one field enter the name of Late of session one column of destination table enter the name of the destination table field for Missed hours in the Missed Session One field enter the name of the destination table field for Total hours in the Total Session One field enter the name of the destination table field for Over time hours in the Over Session One field Then click on Session two and Session three tabs and repeat the same for them SMA TimeTracker Advanced User Manual V2 0 5 19 Page Then click on Total tab to enter the information for Total Server Info Session One Session Two Session Three Total Other i Total Early Total Late Total Missed Total Hours Total Ower k In this tab you have to enter the summary columns of the report Enter the destination table column name of Total Early in the field Total Early Enter the destination table column name of Total Late in the field Total Late Enter the destination table
18. stem even if they are not found in HR view then select Ignore in Extra Department otherwise select delete which will delete any extra departments upon synchronizing with HR database e Provide the name of the view created for department details SMA TimeTracker Advanced User Manual V2 0 5 14 Page e Map the fields accordingly e Leave department where and search as blank After completing the department information tab click personnel information tab you will find the following screen 3 5 3 Personnel Parameter Department Personnel Vacation Holiday 2 Extra Personnel Jgnore Personnel Table tayiew personnel Personnel No pep coNNELNR Personnel Name En peRSONNELNAME EN Personnel Name Ar PERSONNELNAME AR Personnel Job Title En Personnel Job Tille Ar Personnel Department Id Department Type Gender Personnel Type Badge TITLEEM TITLEAR DEPARTMENTID Default GENDER TYPE REMOVAL DATE e Click on Preferences gt HR Service gt New gt Personnel e If you want the manually added personnel to stay in the system even if they are not found in HR view then select Ignore in Extra Personnel otherwise select delete which will delete any extra departments upon synchronizing with HR database Selection of In Active will make extra personnel Inactive in the system e Provide the name of the view created for personnel details e Map the fields accordingly SMA TimeTracker Advanced User Manual
19. ting all the tabs press submit button to save the export summary you created SMA TimeTracker Advanced User Manual V2 0 5 25 Page
Download Pdf Manuals
Related Search