Try Free

Data Migration Instruction

Transferring actiTIME data from the Auto-installation package with MS Access database to the Auto-installation package with MySQL database

Introduction

You can transfer your actiTIME data from the Auto-installation package with MS Access database to the Auto-installation package with MySQL database using the conversion tool provided. The tool itself is the Visual Basic script that converts actiTIME data between databases (db_converter.vbs).

The following diagram presents the general data conversion scheme.

auto access auto mysql

The conversion tool (db_converter.vbs) operates via ODBC (Open Database Connectivity) API, so it's necessary to create ODBC Data Source Names (DSNs) for MySQL database and MS Access database backup (that will be created after the source actiTIME instance is uninstalled).

After both databases are ready and ODBC DSNs are created, you will need to start the conversion tool and specify the name of the source DSN and the name of the destination DSN (explained below too).

The conversion script is written on Visual Basic, so you will need the Windows Scripting Host installed and configured to perform the conversion (note: the Windows Scripting Host is usually already present on most Windows systems).

Detailed conversion instructions

  1. If you are going to convert actiTIME data to a newer version of actiTIME Server, you'll first need to upgrade your current installation to the same (newer) version. The Installation Guide can be found at https://www.actitime.com/administration-guide.
  2. Uninstall the source instance of actiTIME. When the uninstallation is complete, you'll find the backup of your database in the '<actitime installation dir>/database/actitime.mdb' file
  3. Install the destination instance of actiTIME.
  4. Start the destination instance of actiTIME.
  5. Download and install the MySQL ODBC Connector driver.
    1. The latest version of the MySQL ODBC Connector driver (also known as MyODBC) can be found here: http://dev.mysql.com/downloads/connector/odbc/.
    2. After the download is complete, run the driver setup on the machine where actiTIME with MySQL database is installed and install the driver using the instructions provided in the setup.
  6. If you installed the destination actiTIME instance to a new machine, move the MS Access database backup (created on step 2) to this new machine.
  7. Configure the ODBC Data Source names.

    1. Navigate to the "Control Panel" --> "Administrative Tools" --> "Data Sources (ODBC)" On your Windows machine with MyODBC driver installed.
      odbc data source
    2. Navigate to the "System DSN" tab. Press Add.
      new data source
    3. Select "Microsoft Access Driver (*.mdb)" and press Finish.
      new data source
    4. Enter the Data Source name (you will need it later as a parameter for the data conversion tool). Press Select and choose your actiTIME MS Access database backup file in the opened dialog window.
      ms_access_db_copy_actitime
    5. The DSN for your MS Access actiTIME database is now configured. Now you will need to configure the DSN for the MySQL database: press Add on the "System DSN" tab, choose the "MySQL ODBC 5.1 driver" option and press Finish.
      select_driver
      mysql_connector
    6. Enter the Data Source name (you will need it later as a parameter for the data conversion tool).
    7. Enter your MySQL database parameters: Server address (localhost), username and password of the actitime database user (they are stored in the '<actitime installation directory>\actitime.config' file - DBuser and DBpassword parameters), and connection port (usually 27351, but you can find it in actitime.config file too - see DBurl parameter). Then select the actiTIME database (usually ‘actitime’) from the "Database" dropdown.
    8. Press "Details" button, open "Misc Options" tab and select utf8 character set. Press OK to finish the DSN configuration.
      mysql_connector_charset
  8. Download and run the conversion tool.

    1. Copy the file db_converter.vbs to your Windows machine where you installed MySQL ODBC Connector driver.
    2. Launch the downloaded tool from the Windows Command Prompt window. The tool has the following launch format:

      cscript db_converter.vbs [/db_source <DB_SOURCE>]

      [/db_destination <DB_DESTINATION>]

      where

      <DB_SOURCE> and <DB_DESTINATION> parameters shall be filled with the source and destination databases' Data Source Names respectively. If not specified, the tool will prompt for them when running.

  9. Check if the data was correctly transferred and perform the cleanup steps.

    1. Run your destination actiTIME instance and ensure that it contains the same data as your source actiTIME instance. If everything is correct, you should perform the following steps:
    2. MS Access database backup can be deleted.
    3. Remove DSNs created on step 7 ("Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" -> "System DSN" tab).

Transferring actiTIME data from the Auto-installation package with MS Access database to the Custom installation package with MS Access database

This conversion is just a matter of copying .mdb files which contain all your data.

  1. If you are going to convert actiTIME data to a newer version of actiTIME Server, you'll first need to upgrade your current installation to the newer version. The Installation Guide can be found at https://www.actitime.com/administration-guide.
  2. Stop the current actiTIME instance (source).
  3. If you are going to install the Custom installation package with MS Access database to the same computer, you need to first uninstall the current actiTIME instance from it to avoid collisions of ODBC Data Source names. After the uninstallation is complete the data is kept in the '<actiTIME dir>\database' directory.
  4. Install the Custom installation package with MS Access database (destination).
  5. Make sure that the newly installed actiTIME web application is not running (your web server is stooped).
  6. Copy the 'actitime.mdb' file located in '<actiTIME dir>\database' folder of your source actiTIME installation to the 'actitime.access97.mdb' file in the same folder.
  7. Replace the '<actiTIME dir>\actitime.access97.mdb' file in your destination installation with the copy created on the previous step. Please note that all the data in your destination actiTIME instance will be deleted.

Transfering of actiTIME data is now complete. Please start the destination actiTIME instance and ensure that it contains the same data as your source actiTIME instance. After that the source actiTIME instance can be uninstalled.

Transferring actiTIME data from the Auto-installation package with MS Access database to the Custom installation package with MySQL database

Introduction

You can transfer your actiTIME data from the Auto-installation package with MS Access database to the Custom installation package with MySQL database using the conversion tool provided. The tool itself is the Visual Basic script that converts actiTIME data between databases (db_converter.vbs).

The following diagram presents the general data conversion scheme.

auto_access_custom_mysql

According to this scheme both versions of actiTIME (source and destination) should be installed before the actual conversion. After the conversion is complete, the source actiTIME installation can be uninstalled.

The conversion tool (db_converter.vbs) operates via ODBC (Open Database Connectivity) API, so it's necessary to create ODBC Data Source Name (DSN) for MySQL database (please find a detailed description of the steps to perform below).

If you are going to install actiTIME Custom installation package with MySQL database on a new computer, this computer must be accessible from the current one via the network (you should run the conversion tool on the computer where the MS Access database is located). It's also possible to have both databases on the same machine during conversion.

When both databases and ODBC DSNs are ready, you'll need to start the conversion tool and specify the name of the source DSN and the name of the destination DSN (see the instructions below).

The conversion script is written on Visual Basic, so you will need the Windows Scripting Host installed and configured to perform the conversion (note: the Windows Scripting Host is usually already present on most Windows systems).

Detailed conversion instructions

  1. If you are going to convert actiTIME data to a newer version of actiTIME Server, you'll first need to upgrade your current installation to the newer version. The Installation Guide can be found at https://www.actitime.com/administration-guide.
  2. Install the destination instance of actiTIME.
  3. It’s necessary to create a temporary MySQL database user who has the rights to connect to actiTIME database from other computers. To do this:
    1. Run the mysql (<MySQL home>/bin/mysql) client on the destination computer and connect to MySQL server as root user.
    2. Run the following SQL statement:

      GRANT ALL ON <db_name>.* TO ‘<username>’@’%’ IDENTIFIED BY ‘<password>’;

      where

      • <db_name> should be replaced with actual actiTIME database name (usually ‘actitime’);
      • <username> should be replaced with the username of the temporary user (for example ‘tmpuser’);
      • <password> should be replaced with the password of the temporary user.

      Example:

      GRANT ALL ON actitime.* TO ‘tmpuser’@’%’ IDENTIFIED BY ‘secret’;

  4. Back up your actiTIME MS Access databases on the source actiTIME instance using this instruction. Please note that after the conversion all the existing data in your destination database will be lost.
  5. Download and install the MySQL ODBC Connector driver.
    1. The latest version of the MySQL ODBC Connector driver (also known as MyODBC) can be found here: http://dev.mysql.com/downloads/connector/odbc/.
    2. After the download is complete, run the driver setup on the machine where actiTIME with MS Access database is installed and install the driver using the instructions provided in the setup.
  6. Configure the ODBC Data Source names.

    As far as the actiTIME AUTO installation package with MS Access database is already installed, the ODBC Data Source for its MS Access database is already created. Its name is 'actitimedb'. You need to configure the ODBC Data Source for the MySQL database:

    1. Navigate to the "Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" on your Windows machine with MyODBC driver installed.
      odbc_data_source
    2. Navigate to the "System DSN" tab. Press Add.
    3. Choose the "MySQL ODBC 5.1 driver" option and press Finish.
      select_driver
      mysql_connector
    4. Enter the Data Source name (you will need it later as a parameter for the data conversion tool).
    5. Enter your MySQL database parameters: Server address, username and password of the temporary user created on the Step 2, and connection port (optional, available on the "Connect Options" tab). Then select the actiTIME database (usually ‘actitime’) from the "Database" dropdown.
    6. Press "Details" button, open "Misc Options" tab and select utf8 character set. Press OK to finish the DSN configuration.
      mysql_connector_charset
  7. Download and run the conversion tool.

    1. Copy the file db_converter.vbs to your Windows machine with your MS Access database.
    2. Launch the downloaded tool from the Windows Command Prompt window. The tool has the following launch format:

      cscript db_converter.vbs [/db_source <DB_SOURCE>]

      [/db_destination <DB_DESTINATION>]

      where

      <DB_SOURCE> and <DB_DESTINATION> parameters shall be filled with the source and destination databases' Data Source Names respectively. If not specified, the tool will prompt for them when running.

  8. Check if the data was transferred correctly and perform the cleanup steps.

    1. Run your destination actiTIME instance and ensure that it contains the same data as your source actiTIME instance. If everything is correct, you should perform the following steps:
    2. The source actiTIME instance can be uninstalled.
    3. Remove the DSN created on the Step 6 ("Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" -> "System DSN" tab). The DSN for the MS Access database will be automatically removed when the source actiTIME instance is uninstalled.
    4. The temporary database user that was created on the Step 2 should be removed. Run the mysql (<MySQL home>/bin/mysql) client on the destination computer and connect to MySQL server as root user. Then run the following two SQL queries:

      REVOKE ALL PRIVILEGES ON <db_name>.* FROM ‘<username>’@’%’;

      DROP USER ‘<username>’@’%’;

      where

      • <db_name> should be replaced with actual actiTIME database name (usually ‘actitime’);
      • <username> should be replaced with the username of the temporary user (for example ‘tmpuser’).

Transferring actiTIME data from the Auto-installation package with MySQL database to the Custom installation package with MS Access database

Introduction

You can transfer your actiTIME data from the Auto-installation package with MySQL database to the Custom installation package with MS Access database using the conversion tool provided. The tool itself is the Visual Basic script that converts actiTIME data between databases (db_converter.vbs).

The following diagram presents the general data conversion scheme.

auto_mysql_custom_access

According to this scheme both versions of actiTIME (source and destination) should be installed before the actual conversion. After the conversion is complete, the source actiTIME installation can be uninstalled.

The conversion tool (db_converter.vbs) operates via ODBC (Open Database Connectivity) API, so it's necessary to create ODBC Data Source Names (DSNs) for the MySQL database and for the copy of MS Access database (please find a detailed description of the steps to perform below).

When both databases are ready and ODBC DSNs are created you'll need to start the conversion tool and specify the name of the source DSN and the name of the destination DSN (see the instructions below).

The conversion script is written on Visual Basic, so you will need the Windows Scripting Host installed and configured to perform the conversion (note: the Windows Scripting Host is usually already present on most Windows systems).

Detailed conversion instructions

  1. If you are going to convert actiTIME data to a newer version of actiTIME Server, you'll first need to upgrade your current installation to the same (newer) version. The Installation Guide can be found at https://www.actitime.com/administration-guide.
  2. Install the destination instance of actiTIME.
  3. Back up your actiTIME MySQL databases on source actiTIME instance using this instruction. Also, please note that all the existing data in your destination database will be lost after the conversion.
  4. Stop the destination actiTIME instance (shutdown your web server).
  5. Copy MS Access database from your Custom installation package (<actitime home>\actitime.access97.mdb) to the computer where the Auto-installation package with MySQL database is installed. Hereafter this copy will be referenced as <db copy dir>/actitime.access97.mdb. If you installed the Custom installation package to the same computer, there is no need to make a db copy (in this situation <db copy dir> is equal to <actitime home> directory).
  6. Download and install the MySQL ODBC Connector driver.

    1. The latest version of the MySQL ODBC Connector driver (also known as MyODBC) can be found here: http://dev.mysql.com/downloads/connector/odbc/.
    2. After the download is complete run the driver setup on the machine where actiTIME with MySQL database is installed and install the driver using the instructions provided in the setup.
  7. Start the source actiTIME instance (Auto-installation package).
  8. Configure the ODBC Data Source names.

    1. Navigate to the "Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" on your Windows machine with MyODBC driver installed.
      odbc_data_source
    2. Navigate to the "System DSN" tab. Press Add.
      new_data_source
    3. Select "Microsoft Access Driver (*.mdb)" and press Finish
      data_source_setup
    4. Enter the Data Source name (you will need it later as a parameter for the data conversion tool). Press Select and choose your copy of actiTIME MS Access database in the opened dialog window.
      ms_access_db_copy
    5. The DSN for your MS Access actiTIME database is now configured. The next step is to configure the DSN for the MySQL database: press Add on the "System DSN" tab, choose the "MySQL ODBC 5.1 driver" option and press Finish.
      select_driver
      mysql_connector
    6. Enter the Data Source name (you will need it later as a parameter for the data conversion tool).
    7. Enter your MySQL database parameters: Server address (localhost), username and password of the actitime database user (they are stored in the '<actitime installation directory>\actitime.config' file - DBuser and DBpassword parameters), and connection port (usually 27351, but you can find it in actitime.config file too - see DBurl parameter). Then select the actiTIME database (usually ‘actitime’) from the "Database" dropdown.
    8. Press "Details" button, open "Misc Options" tab and select utf8 character set. Press OK to finish the DSN configuration.
      mysql_connector_charset
  9. Download and run the conversion tool.
    1. Copy the file db_converter.vbs to your Windows machine where you installed MySQL ODBC Connector driver.

    2. Launch the downloaded tool from the Windows Command Prompt window. The tool has the following launch format:

      cscript db_converter.vbs [/db_source <DB_SOURCE>]

      [/db_destination <DB_DESTINATION>]

      where

      <DB_SOURCE> and <DB_DESTINATION> parameters shall be filled with the source and destination databases' Data Source Names respectively. If they are not specified, the tool will prompt for them when running..

  10. Now that the copy of the MS Access database contains the converted data, you should replace the original database file with this one in your Custom installation package. The original file is located in actitime directory of your source actiTIME instance.

  11. Check if the data was correctly transferred and perform the cleanup steps.

    1. Run your destination actiTIME instance and ensure that it contains the same data as your source actiTIME instance. If everything is correct, you should perform the following steps.
    2. >MS Access database copy can be deleted (<db copy dir>/actitime.access97.mdb).
    3. The source actiTIME instance can be uninstalled.
    4. Remove the DSNs created on the Step 8 ("Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" -> "System DSN" tab).

Transferring actiTIME data from the Auto-installation package with MySQL database to the Custom installation package with MySQL database

  1. If you are going to convert actiTIME data to a newer version of actiTIME Server, you'll first need to upgrade your current installation to the same (newer) version. The Installation Guide can be found at https://www.actitime.com/administration-guide.
  2. Back up your actiTIME MySQL databases on the source actiTIME instance using this instruction.
  3. Install the Custom installation package with MySQL database (destination).
  4. Start it.
  5. Copy the file 'actitime_data.sql' created on steps 2 to the '<MySQL directory>/bin' directory of your new installation.
  6. Go to the '<MySQL directory>/bin' directory.
  7. Import the data from the 'actitime_data.sql' file to the new installation using the following command:

    mysql -u <username> -p<password> -P <port_number> <db_name> <actitime_data.sql>

    where

    <username> is the username of actitime database user. It is stored in the '<actiTIME dir>/WEB-INF/classes/com/actimind/actitime/AT.properties' file, DBuser parameter.

    <password> is the password of actitime database user. (please note that there should be NO space between '-p' and password). It is stored in the '<actiTIME dir>/WEB-INF/classes/com/actimind/actitime/AT.properties' file, DBpassword parameter.

    <port_number> is the port used by your MySQL (usually 3306).

    <db_name> is the name of actitime database (usually 'actitime'). It is stored in the '<actiTIME dir>/WEB-INF/classes/com/actimind/actitime/AT.properties' file, at the end of the DBurl parameter.

Transfering of actiTIME data is now complete. Please restart the destination actiTIME instance (by restarting your web server) and ensure that it contains the same data as your source actiTIME instance. After that the source actiTIME instance can be uninstalled. If you don't need the 'actitime_data.sql' file, you can delete it.

Transferring actiTIME data from the Custom installation package with MS Access database to the Custom installation package with MySQL database

Introduction

You can transfer your actiTIME data from the Custom installation package with MS Access database to the Custom installation package with MySQL database using the conversion tool provided. The tool itself is the Visual Basic script that converts actiTIME data between databases (db_converter.vbs).

The following diagram represents the general data conversion scheme.

custom_access_custom_mysql

According to this scheme both versions of actiTIME (source and destination) should be installed before the actual conversion. After the conversion is complete, the source actiTIME installation can be uninstalled.

The conversion tool (db_converter.vbs) operates via ODBC (Open Database Connectivity) API, so it's necessary to create the ODBC Data Source Name (DSN) for MySQL database (please find the detailed instructions below).

If you are going to install the Custom package with MySQL database on a new machine (not the one with the current installaton of actiTIME), the computer with the new installation must be accessible from the current one via the network. It's also possible to have both databases on the same machine during conversion.

After both databases and ODBC DSNs are ready, you will need to start the conversion tool and specify the name of the source DSN and the name of the destination DSN (you will find instructions on how to do it below as well).

The conversion script is written on Visual Basic, so you will need the Windows Scripting Host installed and configured to perform the conversion (this is usually already done on most Windows systems).

Detailed conversion instructions

  1. If you are going to convert actiTIME data to a newer version of actiTIME Server, you will first need to upgrade your current installation to the same (newer) version. The Installation Guide can be found at https://www.actitime.com/administration-guide.
  2. Install the destination instance of actiTIME.
  3. It is necessary to create a temporary MySQL database user who will have the rights to connect to actiTIME database from other computers. To do this:
    1. Run the mysql (<MySQL home>/bin/mysql) client on the destination computer and connect to MySQL server as root user.
    2. Run the following SQL statement:

      GRANT ALL ON <db_name>.* TO ‘<username>’@’%’ IDENTIFIED BY ‘<password>’;

      where

      • <db_name> should be replaced with actual actiTIME database name (usually ‘actitime’);
      • <username> should be replaced with the username of the temporary user (for example ‘tmpuser’);
      • <password> should be replaced with the password of the temporary user.

      Example:

      GRANT ALL ON actitime.* TO ‘tmpuser’@’%’ IDENTIFIED BY ‘secret’;

  4. Back up your actiTIME MS Access database on the source actiTIME instance using this instruction. Please note that all the existing data in your destination database will be lost after the conversion.
  5. Download and install the MySQL ODBC Connector driver.
    1. The latest version of the MySQL ODBC Connector driver (also known as MyODBC) can be found here: http://dev.mysql.com/downloads/connector/odbc/ .
    2. After the download is complete run the driver setup on the machine where actiTIME with MS Access database is installed and install the driver using the instructions provided in the setup.
  6. Configure the ODBC Data Source names.

    As far as the actiTIME Custom installation package with MS Access database is already installed, the ODBC Data Source for its MS Access database is already created. Its name is 'actitimedb'. Now you need to configure the ODBC Data Source for the MySQL database:

    1. Navigate to the "Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" on your Windows machine with MyODBC driver installed.
      odbc_data_source
    2. Navigate to the "System DSN" tab. Press Add.
    3. Choose the "MySQL ODBC 5.1 driver" option and press Finish.
      select_driver
      mysql_connector
    4. Enter the Data Source name (you will need it later as a parameter for the data conversion tool).
    5. Enter your MySQL database parameters: Server address, username and password of the temporary user created on the Step 2, and connection port (optional, available on the "Connect Options" tab). Then select the actiTIME database (usually ‘actitime’) from the "Database" dropdown.
    6. Press "Details" button, open "Misc Options" tab and select utf8 character set. Press OK to finish the DSN configuration.
      mysql_connector_charset3
  7. Download and run the conversion tool.
    1. Copy the file db_converter.vbs to your Windows machine with your MS Access database.
    2. Launch the downloaded tool from the Windows Command Prompt window. The tool has the following launch format:

      cscript db_converter.vbs [/db_source <DB_SOURCE>]

      [/db_destination <DB_DESTINATION>]

      where

      <DB_SOURCE> and <DB_DESTINATION> parameters should be filled with the Data Source Names of the source and destination databases respectively. If these parameters will be left unspecified, the tool will prompt for them when running.

  8. Check whether the data was transferred correctly and perform the cleanup steps.
    1. Run your destination actiTIME instance and ensure that it contains the same data as your source actiTIME instance. If everything is correct, you should perform the following steps.
    2. The source actiTIME instance can be uninstalled.
    3. Remove the DSN created on the Step 6 ("Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" -> "System DSN" tab).
    4. The temporary database user created on the Step 2 should be removed. Run the mysql ( <MySQL home>/bin/mysql) client on the destination computer and connect to MySQL server as 'root' user. Then run the following two SQL queries:

      REVOKE ALL PRIVILEGES ON <db_name>.* FROM '<username>’@’%';

      DROP USER '<username>’@’%';

      • <db_name> should be replaced with actual actiTIME database name (usually ‘actitime’);
      • <username> should be replaced with the username of the temporary user (e.g. ‘tmpuser’).

Transferring actiTIME data from the Auto-installation package with MySQL database to the Auto-installation package with MS Access database

Introduction

You can transfer your actiTIME data from the Auto-installation package with MySQL database to the Auto-installation package with MS Access database using the conversion tool provided. The tool itself is the Visual Basic script that converts actiTIME data between databases (db_converter.vbs).

The following diagram presents the general data conversion scheme.

auto_mysql_auto_access

According to this scheme both versions of actiTIME (source and destination) should be installed before the actual conversion. After the conversion is complete, the source actiTIME installation can be uninstalled.

The conversion tool (db_converter.vbs) operates via ODBC (Open Database Connectivity) API, so it's necessary to create ODBC Data Source Names (DSNs) for the MySQL database and for the copy of MS Access database (please find a detailed description of the steps to perform below).

After both databases are ready and the ODBC DSNs are created, you'll need to start the conversion tool and specify the name of the source DSN and the name of the destination DSN (see the instructions below).

The conversion script is written on Visual Basic, so you will need the Windows Scripting Host installed and configured to perform the conversion (note: the Windows Scripting Host is usually already present on most Windows systems).

Detailed conversion instructions

  1. If you are going to convert actiTIME data to a newer version of actiTIME Server, you'll first need to upgrade your current installation to the same (newer) version. The Installation Guide can be found at https://www.actitime.com/administration-guide.
  2. Install the destination instance of actiTIME on other machine with Windows OS (later you will be able to install the destination instance on the same computer, but on this step it's necessary to install it on another machine since the Auto-installation package doesn't allow installing more than one actiTIME instance on one computer).
  3. Back up your actiTIME MySQL databases on source actiTIME instance using this instruction. Also, please note that all the existing data in your destination database will be lost after the conversion.
  4. Stop the destination actiTIME instance.
  5. Copy MS Access database from your destination installation (<actitime home>\database\actitime.mdb) to the computer where the Auto-installation package with MySQL database is installed. Hereafter this copy will be referenced as <db copy dir>/actitime.mdb.
  6. Download and install the MySQL ODBC Connector driver.

    1. The latest version of the MySQL ODBC Connector driver (also known as MyODBC) can be found here: https://dev.mysql.com/downloads/connector/odbc/.
    2. After the download is complete, run the driver setup on the machine where actiTIME with MySQL database is installed and install the driver using the instructions provided in the setup.
  7. Start the source actiTIME instance (Auto-installation package).
  8. Configure the ODBC Data Source names.
    1. Navigate to the "Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)"on your Windows machine with MyODBC driver installed.
      odbc_data_source
    2. Navigate to the "System DSN" tab. Press Add.
      new data source
    3. Select "Microsoft Access Driver (*.mdb)" and press Finish.
      new data source
    4. Enter the Data Source name (you will need it later as a parameter for the data conversion tool). Press Select and choose your actiTIME MS Access database backup file in the opened dialog window.
      ms_access_db_copy_actitime
    5. The DSN for your MS Access actiTIME database is now configured. Now you will need to configure the DSN for the MySQL database: press Add on the "System DSN" tab, choose the "MySQL ODBC 5.1 driver" option and press Finish.
      select_driver
      mysql_connector
    6. Enter the Data Source name (you will need it later as a parameter for the data conversion tool).
    7. Enter your MySQL database parameters: Server address (localhost), username and password of the actitime database user (they are stored in the '<actitime installation directory>\actitime.config' file - DBuser and DBpassword parameters), and connection port (usually 27351, but you can find it in actitime.config file too - see DBurl parameter). Then select the actiTIME database (usually ‘actitime’) from the "Database" dropdown.
    8. Press "Details" button, open "Misc Options" tab and select utf8 character set. Press OK to finish the DSN configuration.
      mysql_connector_charset
  9. Download and run the conversion tool.

    1. Copy the file db_converter.vbs to your Windows machine where you installed MySQL ODBC Connector driver.
    2. Launch the downloaded tool from the Windows Command Prompt window. The tool has the following launch format:

      cscript db_converter.vbs [/db_source <DB_SOURCE>]

      [/db_destination <DB_DESTINATION>]

      where

      <DB_SOURCE> and <DB_DESTINATION> parameters shall be filled with the source and destination databases' Data Source Names respectively. If not specified, the tool will prompt for them when running.

  10. Now that the copy of the MS Access database contains the converted data, you should replace the original database file with the new one in your new Auto-installation package. The original file is located in <actitime installation dir>\database> directory of your source actiTIME instance.

  11. Check if the data was correctly transferred and perform the cleanup steps.

    1. Run your destination actiTIME instance and ensure that it contains the same data as your source actiTIME instance. If everything is correct, you should perform the following steps.
    2. MS Access database copy can be deleted (<db copy dir>/actitime.mdb).
    3. The source actiTIME instance can be uninstalled.
    4. Remove the DSNs created on the Step 8 ("Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" -> "System DSN" tab).
  12. Optional: If you would like to move the new installation to the old machine (were your previous actiTIME instance was installed), you can install the same actiTIME package to the old machine and just copy the 'actitime.mdb' file with your data to this installation.

Transferring actiTIME data from the Custom installation package with MS Access database to the Auto-installation package with MS Access database

There is no conversion required because the Auto-installation package can copy actiTIME data from an external actiTIME MS Access database during its installation:

  1. Back up your current actiTIME data using this instruction.
  2. Uninstall the current actiTIME instance to avoid collisions of ODBC Data Source names.
  3. Run the Auto-installation package installer.
  4. Choose Microsoft Access database on the 'Choose database' screen.
  5. When you reach the 'actiTIME Database Configuration' screen, choose 'Copy data from the existing database', press the 'Browse...' button, and select the backup file created on step 1.
  6. Complete the installation.

Now your new actiTIME instance should contain the data copied from your custom actiTIME installation.

Transferring actiTIME data from the Custom installation package with MS Access database to the Auto-installation package with MySQL database

Introduction

You can transfer your actiTIME data from the Custom installation package with MS Access database to the Auto-installation package with MySQL database using the conversion tool provided. The tool itself is the Visual Basic script that converts actiTIME data between databases (db_converter.vbs).

The following diagram represents the general data conversion scheme.

auto_mysql_custom_access

According to this scheme both versions of actiTIME (source and destination) should be installed before the actual conversion. After the conversion is complete, the source actiTIME installation can be uninstalled.

The conversion tool (db_converter.vbs) operates via ODBC (Open Database Connectivity) API, so it's necessary to create the ODBC Data Source Names (DSNs) for the MySQL database and for the copy of MS Access database (please find the detailed instructions below).

After both databases are ready and ODBC DSNs are created, you will need to start the conversion tool and specify the names of both source and destination DSNs (you will find instructions on how to do it below as well).

The conversion script is written on Visual Basic, so you will need the Windows Scripting Host installed and configured to perform the conversion (this is usually already done on most Windows systems).

Detailed conversion instructions

  1. If you are going to convert actiTIME data to a newer version of actiTIME Server, you will first need to upgrade your current installation to the same (newer) version. The Installation Guide can be found at https://www.actitime.com/administration-guide.
  2. Install the destination instance of actiTIME.
  3. Stop the source actiTIME instance (shutdown your web server)
  4. Back up your actiTIME MS Access database on source actiTIME instance using this instruction. Also, please note that all the existing data in your destination database will be lost after the conversion.
  5. Copy MS Access database from your Custom installation package (<actitime home>\actitime.access97.mdb) to the computer where you installed the Auto-installation package with MySQL database. Hereafter this copy will be referenced as <db copy dir></actitime.access97.mdb>. If you installed the Auto-installation package to the same computer, there is no need to make db copy (<db copy dir< is equal to <actitime home< directory in this situation).
  6. Download and install the MySQL ODBC Connector driver.

    1. The latest version of the MySQL ODBC Connector driver (also known as MyODBC) can be found here: https://dev.mysql.com/downloads/connector/odbc/.
    2. After the download is complete, run the driver setup on the machine where actiTIME with MySQL database is installed and install the driver using the instructions provided in the setup.
  7. Start the target actiTIME instance (Auto-installation package).
  8. Configure the ODBC Data Source names.

    1. Navigate to the "Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" on your Windows machine with MyODBC driver installed.
      odbc_data_source
    2. Navigate to the "System DSN" tab. Press Add.
      new_data_source
    3. Select "Microsoft Access Driver (*.mdb)" and press Finish
      data_source_setup
    4. Enter the Data Source name (you will need it later as a parameter for the data conversion tool). Press Select and choose your copy of actiTIME MS Access database in the opened dialog window.
      ms_access_db_copy
    5. The DSN for your MS Access actiTIME database is now configured. The next step is to configure the DSN for the MySQL database: press Add on the "System DSN" tab, choose the "MySQL ODBC 5.1 driver" option and press Finish.
      select_driver
      mysql_connector
    6. Enter the Data Source name (you will need it later as a parameter for the data conversion tool).
    7. Enter your MySQL database parameters: Server address (localhost), username and password of the actitime database user (they are stored in the '<actitime installation directory>\actitime.config' file - DBuser and DBpassword parameters), and connection port (usually 27351, but you can find it in actitime.config file too - see DBurl parameter). Then select the actiTIME database (usually ‘actitime’) from the "Database" dropdown.
    8. Press "Details" button, open "Misc Options" tab and select utf8 character set. Press OK to finish the DSN configuration.
      mysql_connector_charset
    9. Download and run the conversion tool.

      1. Copy the file db_converter.vbs to your Windows machine where you installed MySQL ODBC Connector driver.
      2. Launch the downloaded tool from the Windows Command Prompt window. The tool has the following launch format:

        cscript db_converter.vbs [/db_source <DB_SOURCE>]

        [/db_destination <DB_DESTINATION>]

        where

        <DB_SOURCE> and <DB_DESTINATION> parameters should be filled with the Data Source Names of the source and destination databases respectively. If these parameters will be left unspecified, the tool will prompt for them when running.

    10. Check whether the data was transferred correctly and perform the cleanup steps.
      1. Run your destination actiTIME instance and ensure that it contains the same data as your source actiTIME instance. If everything is correct, you should perform the following steps.
      2. MS Access database copy can be deleted (<db copy dir>/actitime.access97.mdb).
      3. The source actiTIME instance can be uninstalled.
      4. Remove the DSNs created on the Step 4 ("Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" -> "System DSN" tab).

Transferring actiTIME data from the Custom installation package with MySQL database to the Auto-installation package with MS Access database

Introduction

You can transfer your actiTIME data from the Custom installation package with MySQL database to the Auto-installation package with MS Access database using the conversion tool provided. The tool itself is the Visual Basic script that converts actiTIME data between databases (db_converter.vbs).

The following diagram represents the general data conversion scheme.

custom_mysql_auto_access

According to this scheme both versions of actiTIME (source and destination) should be installed before the actual conversion. After the conversion is complete, the source actiTIME installation can be uninstalled.

The conversion tool (db_converter.vbs) operates via ODBC (Open Database Connectivity) API, so it is necessary to create the ODBC Data Source Names (DSNs) for MySQL database and MS Access database (please find the detailed instructions below).

If you are going to install the customized package with MS Access database on a new machine (not the one with the current installaton of actiTIME), the computer with the current installation must be accessible from the new one via the network. This is important because the conversion tool should be run on the same computer where the MS Access database is located. It's also possible to have both databases on the same machine during conversion.

After both databases and ODBC DSNs are ready, you will need to start the conversion tool and specify the name of the source DSN and the name of the destination DSN (explained below too).

The conversion script is written on Visual Basic, so you will need the Windows Scripting Host installed and configured to perform the conversion (this is usually already done on most Windows systems).

Detailed conversion instructions

  1. If you are going to convert actiTIME data to a newer version of actiTIME Server, you will first need to upgrade your current installation to the same (newer) version. The Installation Guide can be found at https://www.actitime.com/administration-guide.
  2. It is necessary to create a temporary MySQL database user who will have the rights to connect to actiTIME database from other computers. To do this:

    1. Run the mysql (<MySQL home>/bin/mysql) client on the source computer and connect to MySQL server as root user.
    2. Run the following SQL statement:

      GRANT ALL ON <db_name>.* TO ‘<username>’@’%’ IDENTIFIED BY ‘<password>’;

      where

      • <db_name> should be replaced with actual actiTIME database name (usually ‘actitime’);
      • <username> should be replaced with the username of the temporary user (e.g. ‘tmpuser’);
      • <password> should be replaced with the password of this temporary user.

      Example:

      GRANT ALL ON actitime.* TO ‘tmpuser’@’%’ IDENTIFIED BY ‘secret’;

  3. Install the destination instance of actiTIME.
  4. Back up your actiTIME MySQL databases on the source actiTIME instance using this instruction. Please note that all the existing data in your destination database will be lost after the conversion.
  5. Download and install the MySQL ODBC Connector driver.

    1. The latest version of the MySQL ODBC Connector driver (also known as MyODBC) can be found here: https://dev.mysql.com/downloads/connector/odbc/.
    2. After the download is complete run the driver setup on the machine where actiTIME with MS Access database is installed and install the driver using the instructions provided in the setup.
  6. Configure the ODBC Data Source names.

    As far as the actiTIME Auto installation package with MS Access database is already installed, the ODBC Data Source for its MS Access database is already created. Its name is 'actitimedb'. Now you need to configure the ODBC Data Source for the MySQL database:

    1. Navigate to the "Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" on your Windows machine with MyODBC driver installed.
      odbc_data_source
    2. Navigate to the "System DSN" tab. Press Add.
    3. Choose the "MySQL ODBC 5.1 driver" option and press Finish.
      new_data_source
      mysql_connector
    4. Enter the Data Source name (you will need it later as a parameter for the data conversion tool).
    5. Enter your MySQL database parameters: Server address, username and password of the temporary user created on the Step 2, and connection port (optional, available on the "Connect Options" tab). Then select the actiTIME database (usually ‘actitime’, but you could change it during the installation) from the "Database" dropdown.
    6. Press "Details" button, open "Misc Options" tab and select utf8 character set. Press OK to finish the DSN configuration.
      mysql_connector_charset
  7. Download and run the conversion tool.

    1. Copy the file db_converter.vbs to your Windows machine with the Auto-installation package with MS Access database.
    2. Launch the downloaded tool from the Windows Command Prompt window. The tool has the following launch format:

      cscript db_converter.vbs [/db_source <DB_SOURCE>]

      [/db_destination <DB_DESTINATION>]

      where

      <DB_SOURCE> and <DB_DESTINATION> parameters should be filled with the Data Source Names of the source and destination databases respectively. If these parameters will be left unspecified, the tool will prompt for them when running.

  8. Check whether the data was transferred correctly and perform the cleanup steps.
    1. Run your destination actiTIME instance and ensure that it contains the same data as your source actiTIME instance. If everything is correct, you should perform the following steps.
    2. The source actiTIME instance can be uninstalled.
    3. Remove the DSN created on the Step 6 ("Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" -> "System DSN" tab).
    4. The temporary database user created on the Step 2 should be removed. Run the mysql ( <MySQL home>/bin/mysql) client on the destination computer and connect to MySQL server as 'root' user. Then run the following two SQL queries:

      REVOKE ALL PRIVILEGES ON <db_name>.* FROM '<username>’@’%';

      DROP USER '<username>’@’%';

      where

      • <db_name> should be replaced with actual actiTIME database name (usually ‘actitime’);
      • <username> should be replaced with the username of the temporary user (e.g. ‘tmpuser’).

Transferring actiTIME data from the Custom installation package with MySQL database to the Auto-installation package with MySQL database

  1. If you are going to convert actiTIME data to a newer version of actiTIME Server, you'll first need to upgrade your current installation to the same (newer) version. The Installation Guide can be found at https://www.actitime.com/administration-guide.
  2. Back up your actiTIME MySQL databases on the source actiTIME instance using this instruction.
  3. Install the Auto-installation package with MySQL database (destination).
  4. Start it
  5. Copy the 'actitime_data.sql' file created on the Step 2 to the '<actiTIME folder>/database/MySQL/bin' folder of your new installation.
  6. Open CMD.
  7. Go to the '<actiTIME folder>/database/MySQL/bin' folder.
  8. Import the data from the 'actitime_data.sql' file to the new installation using the following command:

    mysql -u actitime -p<password> -P <port_number> actitime <actitime_data.sql

    where:

    <password> is the password of actitime database user. (please note that there should be NO space between '-p' and password). It is stored in the '<actiTIME dir>\actitime.config' file, DBpassword parameter.

    <port_number> is the port used by MySQL. It is stored in the '<actiTIME dir>\actitime.config' file, you can find it in the DBurl parameter which has the following format:

    DBurl=jdbc:mysql://<host>:<port_number>/<dbname>

Transfering of actiTIME data is now complete. Please restart the destination actiTIME instance and ensure that it contains the same data as your source actiTIME instance. After that the source actiTIME instance can be uninstalled. If you don't need the 'actitime_data.sql' file, you can delete it.

Transferring actiTIME data from the Custom installation package with MySQL database to the Custom installation package with MS Access database

Introduction

You can transfer your actiTIME data from the Custom installation package with MySQL database to the Custom installation package with MS Access database using the conversion tool provided. The tool itself is the Visual Basic script that converts actiTIME data between databases (db_converter.vbs).

The following diagram represents the general data conversion scheme.

custom_mysql_custom_access

According to this scheme both versions of actiTIME (source and destination) should be installed before the actual conversion. After the conversion is complete, the source actiTIME installation can be uninstalled.

The conversion tool (db_converter.vbs) operates via ODBC (Open Database Connectivity) API, so it is necessary to create the ODBC Data Source Names (DSNs) for MySQL database and MS Access database (please find the detailed instructions below).

If you are going to install the customized package with MS Access database on a new machine (not the one with the current installaton of actiTIME), the computer with the current installation must be accessible from the new one via the network. This is important because the conversion tool should be run on the same computer where the MS Access database is located. It's also possible to have both databases on the same machine during conversion.

After both databases and ODBC DSNs are ready, you will need to start the conversion tool and specify the name of the source DSN and the name of the destination DSN (explained below too).

The conversion script is written on Visual Basic, so you will need the Windows Scripting Host installed and configured to perform the conversion (this is usually already done on most Windows systems).

Detailed conversion instructions

  1. If you are going to convert actiTIME data to a newer version of actiTIME Server, you will first need to upgrade your current installation to the same (newer) version. The Installation Guide can be found at https://www.actitime.com/administration-guide.
  2. It is necessary to create a temporary MySQL database user who will have the rights to connect to actiTIME database from other computers. To do this:
    1. Run the mysql (<MySQL home>/bin/mysql) client on the destination computer and connect to MySQL server as root user.
    2. Run the following SQL statement:

      GRANT ALL ON <db_name>.* TO ‘<username>’@’%’ IDENTIFIED BY ‘<password>’;

      where

      • <db_name> should be replaced with actual actiTIME database name (usually ‘actitime’);
      • <username> should be replaced with the username of the temporary user (e.g. ‘tmpuser’);
      • <password> should be replaced with the password of this temporary user.

      Example:

      GRANT ALL ON actitime.* TO ‘tmpuser’@’%’ IDENTIFIED BY ‘secret’;

  3. Install the destination instance of actiTIME.
  4. Back up your actiTIME MySQL database on the source actiTIME instance using this instruction. Please note that all the existing data in your destination database will be lost after the conversion.
  5. Download and install the MySQL ODBC Connector driver.
    1. The latest version of the MySQL ODBC Connector driver (also known as MyODBC) can be found here: https://dev.mysql.com/downloads/connector/odbc/ .
    2. After the download is complete run the driver setup on the machine where actiTIME with MS Access database is installed and install the driver using the instructions provided in the setup.
  6. Configure the ODBC Data Source names.

    As far as the actiTIME Custom installation package with MS Access database is already installed, the ODBC Data Source for its MS Access database is already created. Its name is 'actitimedb'. Now you need to configure the ODBC Data Source for the MySQL database:

    1. Navigate to the "Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" on your Windows machine with MyODBC driver installed.
      odbc_data_source
    2. Navigate to the "System DSN" tab. Press Add.
      new_data_source
    3. Select "Microsoft Access Driver (*.mdb)" and press Finish
      data_source_setup
    4. Enter the Data Source name (you will need it later as a parameter for the data conversion tool). Press Select and choose your actiTIME MS Access database in the opened dialog window. The MS Access database is located in actiTIME directory
      selectdb
    5. The DSN for your MS Access actiTIME database is now configured. The next step is to configure the DSN for the MySQL database: press Add on the "System DSN" tab, choose the "MySQL ODBC 5.1 driver" option and press Finish.
      select_driver
      mysql_connector
    6. Enter the Data Source name (you will need it later as a parameter for the data conversion tool).
    7. Enter your MySQL database parameters: Server address, username and password of the temporary user created on step 2, and connection port (optional, available on the "Connect Options" tab). Then select the actiTIME database (usually ‘actitime’, but you could change it during the installation) from the "Database" dropdown.
    8. Press "Details" button, open "Misc Options" tab and select utf8 character set. Press OK to finish the DSN configuration.
      mysql_connector_charset
  7. Download and run the conversion tool.
    1. Copy the file db_converter.vbs to your Windows machine with your MS Access database.
    2. Launch the downloaded tool from the Windows Command Prompt window. The tool has the following launch format:

      cscript db_converter.vbs [/db_source <DB_SOURCE>]

      [/db_destination <DB_DESTINATION>]

      where

      <DB_SOURCE> and <DB_DESTINATION> parameters should be filled with the Data Source Names of the source and destination databases respectively. If these parameters will be left unspecified, the tool will prompt for them when running.

  8. Check whether the data was transferred correctly and perform the cleanup steps.
    1. Run your destination actiTIME instance and ensure that it contains the same data as your source actiTIME instance. If everything is correct, you should perform the following steps.
    2. The source actiTIME instance can be uninstalled.
    3. Remove the DSN created on the Step 6 ("Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" -> "System DSN" tab).
    4. The temporary database user created on the Step 2 should be removed. Run the mysql ( <MySQL home>/bin/mysql) client on the destination computer and connect to MySQL server as 'root' user. Then run the following two SQL queries:

      REVOKE ALL PRIVILEGES ON <db_name>.* FROM '<username>’@’%';

      DROP USER '<username>’@’%';

      where

      • <db_name> should be replaced with actual actiTIME database name (usually ‘actitime’);
      • <username> should be replaced with the username of the temporary user (e.g. ‘tmpuser’).