Migrate Data from TCMSv2 to TCMSv3 Easily

Tuesday, October 18, 2016 TimeTec 48 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

48 comments:

  1. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. yes sir,

    what is the password for back up data base

    ReplyDelete
  8. 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. 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. 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. 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. 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. Hi Syed,

      Thank you very much for the help. Greatly appreciated.

      Regards
      Rogan

      Delete
  11. 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. 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. 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. 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. Hi sir
    Can i move the data from history to attendenc sheet?
    Plz send me back

    ReplyDelete
    Replies
    1. 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. 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. 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. 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. 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. 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. 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
  17. Hi can TCMSv3 program co-exist with TCMSv2?

    ReplyDelete
    Replies
    1. Hello..

      If you are using TCMSv3, you need to uninstall or disconnect device from TCMSv2 to avoid issue of losing data since if you mistakenly download data into TCMSv2 software, you wont be able to download into TCMSv3 software since data will be deleted from device once you download into TCMSv2 software.

      Delete
  18. Hi does administrative rights required to run TCMSv3? I'am currently installing it to a WinServer(2012R2) and end-users will access the server via RDP and use TCMSv3.

    ReplyDelete
    Replies
    1. Hello..
      Yes, you need to install TCMSv3 by running the installer as an administrator, and also run this software as an administrator when you launch the software.

      Delete
  19. Hello.

    I've been working with TCMSv2 and I want to migrate all to TCMSv3.

    I've installed TCMS V3, and with the wizard I've try to migration from zip file, and I selected all users and devices but, when I want to see all users, I don't see anything, just I can see the devices.

    Why happen this?

    ReplyDelete
    Replies
    1. Hello Sir,

      Referring to the issue, please check the current TCMSv2 software version that you have use and installed. You need to update your TCMSv2 software with the latest version (v2.2.027) before you can backup the database file and migrate to TCMSv3 software. If you still using the older version, you can download the latest TCMSv2 installer file from below link.

      http://www.fingertec.com/download/FingerTecTCMSv2Setup.zip

      However if the problem still persist, kindly send to us your TCMSv2 backup file by email to support@fingertec.com, we will help you migrate the database file to TCMSv3 software.

      Best Regards

      Delete
  20. I want to upgrade to the TCMSv3, but i see it says here:
    "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."
    the issue is that i have a lot of edited hours and Remarks, will i lose this info?

    ReplyDelete
  21. i migrate from tcms v2 to tcmsv3 but the attendance not shown old years but in audit data is exist

    ReplyDelete
    Replies
    1. Dear Sir,

      Good day to you.

      In regards to your inquiry, the attendance sheet will only be able to show you the previous attendance data for year 2020 and current attendance data for year 2021. It is because the software will only allowed you to configured the group duty roster for year 2020, 2021 and 2022 (refer https://prnt.sc/1r0thvx).

      Delete
  22. Hi sir, Im so happy to find this site to help people like us who has difficulty on installing TCMS ver 3. MY computer is under repair last month and when it returns my FinfertecTCMSver3 is no where to found on my computer and we thought maybe its affecte when they reformat my computer.and sadly yes, all log sheet/data are back to zero. so now We are badly needed an assistance on how to install or update our TCMS ver 2 to ver 3. When we are tyring to install the ver 3 and error is detected it says "Error 1920. Service TCMS ver 3 Service (TCMC V3 Service) failed to start. Verify that you have sufficient privileges to satrt syytem services." Looking forward to your kind assisatnce. Thank you. -CJ

    ReplyDelete
    Replies
    1. Hello Sir,

      Upon installing the software, please make sure your pc fulfill the minimum requirement to install TCMSv3 as follows:
      1) Windows 7 64- bit (with Microsoft .NET Framework 4.6.2 installed) or higher
      2) Disable antivirus and firewall before proceed to install the software
      3) Extract the installer, then run the Setup file as an administrator.
      4) Reboot pc once installation complete.

      If above guide failed to solve your issue, please do not hesitate to contact our support team at support@fingertec.com for further assistance.

      Delete
  23. This comment has been removed by the author.

    ReplyDelete
  24. there is problem when i migrate from tcms v2 to tcms v3 when user written in arabic language

    ReplyDelete
  25. Is there a way to allow installation to a shared drive on the server as we did with V2? I was only able to install locally to the C:\ drive. Then we can back up data base on the server rather than a local machine?

    ReplyDelete

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