User manual
10. Ignore this step if your current version is F7 or later. Version is seen on the top edge of "Time
and Attendance Screen" (check FAQ above for what is Time and Attendance Screen, if you don't
know). If your current version is F6 or older, click on "Show Duplicate..." (step 1) to take care of
duplicates. Edit time by 1 second to convert duplicate into non-duplicate.
11. Click on "Upgrade" button (step 2). It will first confirm with you that old and new
TASQLCOM.MDB and TASQLDAT.MDB files have been copied to their respective folders.
After this, data will be migrated from old to new files, one table at a time. It may take 5 minutes to
30 minutes, depending on CPU power and data quantity. Keep pressing OK for each table. The
tables ORPEPD, SCANDATA and Actual.... take relatively more time than other tables
(sometimes a lot more). Don't kill the job thinking system is hanging!
12. After this step is successful and you get a message telling you to copy files, it is advised that
you first click on "Cleanup" button. This step is mandatory if you upgrade to version 9 or later. It
may delete some superfluous records.
13. After "Cleanup" is done, exit from Update and Upgrade.
14. Copy C:\SMETMP\NEW\TASQLCOM.MDB and C:\SMETMP\NEW\TASQLDAT.MDB
files to the folder from where OLD files were copied (Over-write old files).
15. Copy ALL files from C:\SMETMP (not the folders), except TASQLCOM.MDB and
TASQLDAT.MDB to C:\PROGRAM FILES\TAS2KSQL folder.
16. Start Operations. If required, enter Path of files as indicated in dialog box. In multi-user
installation, enter path as UNC (like \\server name\shared folder name\).
17. Start Interface To Post Data. If required to enter TAS2000 data files path, enter Path of files as
indicated in dialog box. If path of iGuard is required enter as "C:\progra~1\iGuard~1\".
18. Once everything is found ok, in multi-user environment, copy the file C:\PROGRAM
FILES\TAS2KSQL\TASQLFRM.MDB file to the C:\PROGRAM FILES\TAS2KSQL folder of
other users’ PCs too.
Remember, your old files are safely kept in C:\SMETMP\OLD and also in your backup. In case
after step 14 or 15 you face problems, you can always go back to them.
We have started using Night Shift feature and created C1 shift. But when we try to take any of the
Absentee/IN/OUT/Incomplete status, we get “Please enter correct date and shift.”
This happens when C1 shift is not used right from beginning of system installation (like A1). To
resolve this, in “Initialize” form (see import above), use “Select a Table or Query” and open the
table ReCalFlag. Now do the following:
1. Go to “new record” (end of table, blank record with * on left side) to create a new record.
2. Enter: DOA = one day BEFORE you created C1 shift (ensure year is 4 digits), Shift=C,
Recal_ORPEPD=No
3. If a record for DOA=day you created C1 shift and Shift=C does not exist, then create that also,
with Recal_ORPEPD=Yes. Create similar records for all days till today (if not existing).
How can we change Employee Ids of all employees from 5 digits to 7 digits long?
This mass change of employee ids is a very non-standard requirement and needs all references of
old Ids be to be converted to new references in all the tables in the database. Contact Softools
Middle East or the reseller with details.
We have several sites where there is no connection to head office (telephone or network). How
can we get attendance data from such places?
You can use a reader that has a USB port for flash (also called pen) drive. Alternatively you can
take a portable device like laptop/notebook and connect for transferring data. You may also use a
Part 8