Migrate Data from TCMSv2 to TCMSv3 Easily

Tuesday, October 18, 2016 FingerTec 33 Comments

INTRODUCTION
TCMS V2 is FingerTec’s bundled software since 14 years ago and over the years we have made progress on the software front. Earlier this year we have introduced the latest and more powerful bundled software TCMS V3 designed for time attendance purpose. Now, you can migrate your data from TCMS V2  to TCMS V3 software easily. Learn how.

BENEFITS
You neither need to redo the clocking schedule setup, nor do you need to insert employee biodata into the TCMS V3 software. The types of data to migrate are as follow:

1. Company hierarchy (names of departments and sections)
2. Attendance rules and calculations (clocking schedules, group duty roster, holiday, leave types)
3. Employees’ biodata (name, address, phone, designation etc.)
4. Employees’ verification credentials (ID, fingerprints, password, card ID)

However, please note that the manually edited data in your TCMS V2’s attendance will not be migrated because the data migration only takes the raw clocking in your Audit list, and generate a new attendance sheet in TCMS V3.

Note : We are strongly recommending user to do housekeeping before migration process for large scale database so that it can decrease migration time and enhance migration process.You can refer here on how to do housekeeping in TCMS V2.

PROCESS
1) Backup your TCMS V2 software database at TCMSv2 > System Settings > Backup/Restore Database > Backup Database.

Note: You must make sure that you are using TCMS v2.2.027 to make the backup. If you are using an older version of TCMS v2, please first update your software to v2.2.027. The installer of TCMS v2.2.027 can be downloaded here 


2) Now, go to the TCMS V3 software > Click v3 icon > Migration Wizard > FingerTec TCMSv2.

3) Click browse and choose your TCMSv2 backup database and click upload.


4) Select all employees and tick all options that you want to migrate such as devices / user / schedule & roster / leave,holiday,remark. After done, click import selected.

5) The migration process is finished when the zip file has been imported successfully.

AFTER MIGRATION
1.  Please ensure you activate your device in TCMS V3 so that you will have full access to all tabs. Before activating any device, only these selected tabs: System Settings, Users and Devices are accessible. Monitoring, Scheduling & Attendance and Reports are initially disabled.
2.  Go to Devices, select the device > click Activate Device. System will automatically activate the old device with the TCMS V3 software through online activation.
3.  However, if you need to activate the device manually (Activate Device > select Offline) you can always retrieve the TCMS V3 key from the following link:
4.  TCMS V2's and TCMS V3's license keys are different, so you will not be able to use the previous activation key.
5.  It is advisable for users to disconnect device from TCMS V2 once you successfully connect device to TCMS V3 software. Once you have downloaded data into TCMS V2 software, it will automatically delete transaction data from the device and you will not be able to download that data into TCMS V3. 
6.  If you are testing attendance and reports after the migration, firstly, please generate attendance for all users to ensure relevant data enters the attendance sheet (Scheduling & Attendance > Attendance Sheet > Generate > Select User ID and Date Range> Ok). Also, check user Issuance Date and ensure that it is prior to the date selected for generating attendance.

For more guidance on TCMS V3 such as user manual, video guides and training slides, please visit our website at www.fingertec.com/software/ and select TCMS V3 or click here.

You can also find links to other tips available for TCMS V3 at the following page:
http://user.fingertec.com/technical-tips-software-tcmsv3.html

Related Posts:
Common Issues in TCMS V3 / Ingress Software After Database Migration
15 TCMS V3 Most Common Technical Questions Answered

33 comments:

  1. REDA AHMED2 March 2017 at 18:37

    Hi
    how are you sir
    i have an old machine it's R2
    can i use this machine with the TCMS V3
    because i already migrate every thing from TCMS V2
    but i couldn't active R2 machine on the new software
    i think it doesn't sopport this kind of machines
    please can you tell me if i am right.
    your faithfully.

    ReplyDelete
    Replies
    1. Sharul Azmi Natnan2 March 2017 at 20:41

      Hi Reda Ahmed,

      For your information, R2 is the access control device. So in this case we would like to recommend you connect and use the Ingress software instead of TCMSv3 software. It is because, the TCMSv3 software was developed to work as Time Attendance system only and cannot support any door access features like Ingress software.

      You can refer to the following tips and newsletter on how to migrate the TCMSv2 database to Ingress software.
      http://www.fingertectips.com/2015/10/migration-wizard-smoothen-data.html

      Regards

      Delete
  2. REDA AHMED4 March 2017 at 07:49

    Hi
    i use R2 device as Time attendance system only with TCMS v2
    i don't have any door connected to your device
    and i don't wan't you to tell me how too immigrate the data from terminals
    please don't tell me other information if you don't understand my question
    i already asked you a question
    Do i can connect R2 device to TCMS v3?
    Do you have answer ?
    your faithfully.

    ReplyDelete
    Replies
    1. The growing path to Billiionaire4 March 2017 at 11:18

      Dear Reda Ahmed,

      You can connect R2 device to TCMS V3 by using offline activation. Kindly send an email to support@fingertec.com together with the serial number of your device for us to generate TCMS V3 offline activation product key for you.

      Regards

      Delete
  3. REDA AHMED5 March 2017 at 05:13

    Thank you very much for your reply
    now you give me the answer that i want to know
    it means i can use it
    but i already have disk with the software and the product key and the activation key
    i already use it with the TCMS v2
    is it necessary to regenerate activation key again?
    anyway i will send the email to support@fingertec.com
    please accept my apology for much questions
    your faithfully

    ReplyDelete
    Replies
    1. Mohamad yusri5 March 2017 at 08:21

      Dear Reda Ahmed,

      For your information, TCMSv2 and TCMSv3 license is a different, so you cannot use the same activation key used in TCMSv2 to activate the device in TCMSv3 Software.

      Please send your device serial number to support@fingertec.com , so we can generate TCMS V3 offline activation product key for you.

      Delete
  4. yudi28 March 2017 at 15:42

    Hi,
    My client currently using TCMS V2 and want to upgrade to TCMS V3. Do they need to buy upgrade license? The latest TCMS is bundled with TA200 Plus reader

    ReplyDelete
    Replies
    1. Sharul Azmi Natnan28 March 2017 at 16:55

      Hello Yudi,

      Referring to your query, no need to buy a new license for TCMSv3. If you want to migrate the TCMSv2 database to TCMSv3, system will automatically activate the old device with the TCMSv3 software. However if you want to add or activate the device manually you can always retrieve the TCMSv3 key from the following link:

      http://user.fingertec.com/retrieve_key_user.php

      Our system will automatically generate the product key and activation code.

      Delete
  5. LB28 April 2017 at 10:53

    Hi,

    i try to install from CD, also download v3 installer, but both giving me such error.

    "windows cannot access the specified device, path or file. You may not have the appropriate permission to access the item"

    tested in win7 & win10

    ReplyDelete
    Replies
    1. Tengku Sulaiman28 April 2017 at 11:35

      Hi Sir,

      Good day.

      Please turn off your antivirus and window firewall during installation. Please uninstall the software( delete the TCMSv3 folder in program file ) and install it back using the latest version.

      You can get the Installer from here:
      https://s3.amazonaws.com/files.fingertec.com/Software+Releases/TCMSV3/9-TCMSv3+v2.1.0.9/TCMSv3+v2.1.0.9.zip


      Thanks and best regards,
      Tengku Sulaiman

      Delete
    2. LB10 May 2017 at 00:01

      Hi Tengku,

      thanks for the files, able to install into win7/win10.

      do you have any installer for winXP ? it is due somehow not able to install into XP OS using the CD? probably you have another version for WinXP SP3?

      Delete
    3. Athirah Liyana Mohmad10 May 2017 at 00:16

      Hello Sir,

      Good day to you.

      As mentioned by Mr Tengku on reply above, you can copy this whole link :
      https://s3.amazonaws.com/files.fingertec.com/Software+Releases/TCMSV3/9-TCMSv3+v2.1.0.9/TCMSv3+v2.1.0.9.zip

      Then paste it into your browser (Google chrome, internet explorer,etc) and enter. It will automatically download a new installer which is the latest version of TCMCSv3 that can be used in Windows XP.

      Best regards,
      Athirah Liyana Mohmad

      Delete
  6. Unknown11 September 2017 at 20:30

    really want to upgrade to v3 i have 6 devices in total with around 800 employees and around 5 years worth of data. can you migrate it for me i will send back up file from v2.

    ReplyDelete
    Replies
    1. Husna Ahmadjuani11 September 2017 at 23:02

      Dear Sir,

      Good day to you,

      In regards to your inquiry, kindly follow all the guidance provided above to perform the migration as you need to do the housekeeping steps too. Is advisable for you to perform housekeeping first before backing up your database, so that the database will not be too heavy, which will require a lot of time to be migrated. Please follow every steps in order to migrate the database successfully.

      You may refer below for the latest version of TCMSv3 software installer:

      https://s3.amazonaws.com/files.fingertec.com/Software+Releases/TCMSV3/16-TCMSv3+v2.1.1.9+(31-08-2017)/TCMSv3.zip



      Delete
  7. Swordfishii Catfishii12 September 2017 at 18:49

    yes sir,

    what is the password for back up data base

    ReplyDelete
  8. Swordfishii Catfishii12 September 2017 at 19:21

    I can't use this new software for now there are features in v2 that is really required for us.
    like department and section we use this one for custom reports.
    exporting to excel also not working

    ReplyDelete
  9. Unknown11 October 2017 at 16:33

    Hi There, I am trying to perform the migration from TCMS v2.2.027 to the new TCMS V3 using the migration Wizard.

    I have successfully performed the backup on the old platform as a zip.
    When importing the file, the wizard successfully imports the zip. I can see all existing users.

    When selecting all users and then Import, "A crash has been detected by TCMSV3.

    Exception reason:
    TCMSv3.exe caused UNKNOWN_ERROR in module "C:\WINDOWS\System32\KERNELBASE.dll" at 0023:76F3B832, RaiseException()+98 byte(s)

    Can anyone advise me with a workaround/solution please.

    Thanks - Rogan

    ReplyDelete
    Replies
    1. Mohamad yusri11 October 2017 at 17:08

      Hi Rogan,

      Good day to you.

      May I know, what is the current TCMSv2 Version installed in your PC? You can click the system settings and click what's new in this release. (The latest version is v2.2.027 24-05-2017 )

      Then regarding on the crash issue during migration process, kindly provide us the TCMSv2 backup database. you can send to support@fingertec.com , so we can check and migrate TCMSv2 database into TCMSv3 database.

      Delete
  10. Rogan Endres11 October 2017 at 17:27

    Hi Thanks for the speedy response. I managed to update the TCMSv2 yesterday using the check for updates feature. It is running 2.2.027 - 02-02-2015

    I have emailed the backup database to support@fingertec.com

    Look forward to your response.

    Best Regards
    Rogan

    ReplyDelete
    Replies
    1. Syed Mohd Firdaus11 October 2017 at 17:55

      Hi Mr. Rogan,

      Good day to you.

      We have checked and re-backup your TCMS V2 database by using latest version of TCMS V2 (version v2.2.027 19-10-2016). The issue you've encountered is because of your TCMS V2 software is not the latest version. I'll reply your email and send you the database that have been re-backup by latest software version of TCMS V2. We also have tested the database by migrating it to the TCMS V3 and it is working fine.

      Delete
    2. Rogan Endres11 October 2017 at 17:57

      Hi Syed,

      Thank you very much for the help. Greatly appreciated.

      Regards
      Rogan

      Delete
  11. Raymond Tauro16 December 2017 at 07:41

    I have been using TCMSv2 for over two years and about 6 months ago when I inquired about V3 I was advised NOT to install V3. Can I install now? Thanks.

    ReplyDelete
    Replies
    1. Sharul Azmi Natnan16 December 2017 at 12:02

      Hi Mr Raymond,

      With regards to your query, yes you can install the TCMSv3 software and migrate your TCMSv2 database to this new software. You also can download the latest version of TCMSv3 software from the following link.

      https://s3.amazonaws.com/files.fingertec.com/Software+Releases/TCMSV3/19-+TCMSv3+V2.1.2.10+Special+Release/TCMSv3.zip

      Regards.

      Delete
  12. Chris Mordi9 July 2018 at 11:13

    Helle sir,
    I have a problem with my ingress time attendance report sheet and my clients are not satisfied with my report. I'm using R2/R2c as slave n master. In my users movement analysis. "O" should OUT, while "1" is IN.but this not so in my reports. The O and 1 appears indiscriminately.
    I was told that user must press the IN/out button in the R2 to get correct in or out register but my clients wouldn't have the time or patient to press IN/OUT button before flashing their cards or finger prints.
    Pls is there any way to set the system to write O when the R2 master is used and 1 whenever the R2c is used. With don't want to be pressing the in/out button on the R2 before clocking in or out.

    ReplyDelete
    Replies
    1. Tengku Sulaiman9 July 2018 at 15:22

      Hello Sir,

      Good day to you.

      Regarding your query, please make sure you set the anti-passback setting from the device, to use this function. To set the anti-passback, please refer here:

      Go to the device menu > sys option > adv option > antipassback > NoA.

      After you set this, please check again whether the result still same or not.

      Best regards,
      Tengku Sulaiman

      Delete
  13. Ahmed9 May 2019 at 03:36

    Hi sir
    Can i move the data from history to attendenc sheet?
    Plz send me back

    ReplyDelete
    Replies
    1. Syafa9 May 2019 at 05:51

      Dear Mr Ahmed,

      Good day to you,

      Referring to your inquiry, yes, the data from history can be transferred to the attendance sheet. To do so, go to History > click on 'To Current' function > Select Employee ID & Date > click on 'To Current' (refer http://prntscr.com/nm758q)

      Thanks & Best Regards,
      Nursyafawani Kasram binti Mohd Hisham

      Delete
  14. Unknown3 July 2019 at 03:49

    I would like to determine how I can obtain TCMS V3 License, I tried to activate online, but mentioned that serial was not recognized. I bought this device many years ago from Fingertec USA. Please advice.

    ReplyDelete
    Replies
    1. Liyana3 July 2019 at 04:54

      Hello Sir,

      Regarding your issue, kindly contact our partner in USA, Fingertec USA, by referring to the following contact details:

      For help with support you can email them at: Support@FingerTecUSA.com
      Call/Fax: Toll Free 1-800-921-4270
      Phone 1-646-898-0505 Fax: 1-646-786-4714
      Mailing Address: FingerTec USA Inc768 Bedford Avenue Brooklyn NY 11205

      Delete
  15. Quasha28 July 2019 at 14:57

    Hello Sir,
    Last time i take backup TCMSv2 hole folder. Newly I setup my computer. I successfully Instal the software. After long time I download data from terminal. now How can I marge previous data and new download data?

    ReplyDelete
    Replies
    1. Husna Juani28 July 2019 at 15:42

      Dear Quasha,

      Good day to you,

      Kindly check if you still have the etcom file from the previous TCMSv2 folder? If yes, you may follow the steps provided below

      - From the old TCMSv2 folder > find the etcom folder and copy the _etcom file
      - Paste the _etcom file into the "remote" folder inside the existing TCMSv2 folder computer that you want to merge with.
      - Start up the TCMSv2 software, go to Attendance and click Download ( make sure that you had device linked to the software via TCP/IP )
      - The system will download the raw clocking data from the _etcom file.
      - After the process is completed, the system will delete the file that you paste in the remote folder.

      Delete
  16. Peerzada1 August 2019 at 20:04

    Dear Sir,
    we are using TCMS v2 software soon we are going to migrate to TCMS v3. before migrate i am changing emp ID through change ID i am select two ID's and it change successfully but when ever i am changing bulk ID's about 60 emp and in software its showing that ID's has been change and updated successfully and i ask employee to mark your attendance still old ID showing. please guide me.
    thanks

    ReplyDelete
    Replies
    1. Syafa1 August 2019 at 23:24

      Dear Sir / Ma'am,

      Good day to you,

      Referring to your issue, please try to migrate the data from TCMSv2 to TCMSv3 first and then change the User IDs from TCMSv3 and upload them to your device. See whether the issue persists or not.

      If the issue persists, please send email to support@fingertec.com as our team can assist you further.

      Thanks & Best Regards,
      Nursyafawani Kasram binti Mohd Hisham

      Delete

Have any questions or inquiries about FingerTec? Drop your input here.

Subscribe to: Post Comments (Atom)