Contact Us Today! | vcare@wdmtech.com

WDMtech

You can have different profiles with different settings for Data Migration Operation. To manage Profiles, please go to vData => Profiles (or go to Dashboard and click on Profiles link in sub-menu). On the page, you will see list of Profiles which you created and you will be able to add/edit/delete Profiles using the buttons on toolbar. All settings applied to a profile will be used to perform Data Migration Operation ( import / export ). You can also use predefined profiles to Import/Export your Data with just one click through our automated Profile Wizard.

vData Setup Profile

To create a profile, you can simply click on New button in the toolbar and fill-in necessary information.

You will see a few Basic Fields on the form and when you choose or enter values in these fields, some additional fields will load based on your Inputs.

Main Fields

vData Setup Profile

  • Title: Name (title) of the Profile. The Profile name will be needed to import or export the data in other views of vData.
  • Operation Type: Choose the Type of the Profile either "Import" or "Export" type Profile. If you want to create a profile for Data Import Process then choose “Import” option. For Data Export Process, choose the “Export” option from the list. Some additional fields based on this option will load further.

vData Setup Profile

  • Quick Import/Export: Quick Import/Export mode allows you to quickly create profiles with default settings. If you want to create a profile with your custom settings then uncheck the checkbox of Quick Import/Export Mode.

vData Setup Profile

  • Profile: Type to search from available Preset Profiles or create a Custom Profile as per your specific requirements. You can choose “Custom” option to create your own Custom Profile or can choose a Preset Profile from the list. Some additional fields will load further based on your selection.

For Custom Profile #

vData Setup Profile

For Preset Profile #

vData Setup Profile

Additional Fields

vData Setup Profile

  • Table: Choose Database table to which you want to Import the Data or from which you want to Export the Data.

    1 # If you choose only this option, then vData handle the data migration with custom method and simply import the data to the chosen table.

    2 # If you also choose a component from the given list and select related table (i.e “com_content” with “Content” Table) then vData handle the data migration with core method of the selected component. It will automatically manage the asset_id etc.

  • Primary / Unique Key: When you select the table it automatically detects the unique column, Select if not detected.
  • Operation: Insert operation will only insert the records while update operation will update the records with already existing primary key values and insert the remaining new records. Synchronize operation will update the records with already existing primary key values, insert the remaining new records and delete those records from the "Target Table" which are not present in "Source Table or File".
  • Events: Set the Events you want to trigger BEFORE and AFTER a record entry in the database. E.g. onContentBeforeSave, onContentAfter Save etc. (in Import type Profile).

vData Setup ProfilevData Setup Profile

Custom Setting Options for Import Type Profile

vData Setup Profile

If you have unchecked the Quick Import/Export Mode, then you can set all the fields to import your desired columns into database.

  • Columns: All the columns of selected table will be display. You can set your desired option with each column of that table whether you want to include or exclude a particular column of the table in Data Migration Process (Import Type). Description of each option described below:

    vData Setup Profile

    • Skip# Set the dropdown option to “skip” if you don’t want to include a particular column of the table in Data Migration Process (Import Type).
    • Include# Set the dropdown option to “Include” if you want to include a particular column of the table in Data Migration Process (Import Type). Further you will see different types of options e.g. include as String or as Date or as Number etc. if you choose to include the field

      vData Setup Profile

      • String => Set this option if you want to include the column value as String. You can further apply filters like include String “AS it is” or “Strip Tags” or “Char Limit” etc.

        vData Setup Profile

        • Strip Tags: Set this option if you want to strip all the html tags from column data
        • Char Limit: You can limit the column data by applying a Character Limit.
      • Date => Set this option if you want to include the column value as Date. You can also set you desired Date Format e.g. Y-m-d H:i:s

        vData Setup Profile

      • Number => Set this option if you want to include the column value as Number (Integer Type)

        vData Setup Profile

      • URL Safe => Set this option if you want to include the column value as URL Safe. It will remove all white spaces and other special characters and make the value URL Safe (like alias).

        vData Setup Profile

      • Encryption => Set this option if you want to apply the Encryption on the column value. You can choose Encryption method from the given List supported by Joomla e.g. BCRYPT, SHA, CRYPT, MD5-BASE64, SSHA etc. Useful in case of importing Users with plain password.

        vData Setup Profile

        vData Setup Profile

    • As Defined# Set this option if you want to define custom value for the column value. You can also execute some PHP or MySQL function like NOW(), CURDATE(), CURTIME(), time() etc. Choose desired vData prefix to execute php/mysql function (i.e. for mysql function NOW(), you have to select @vdSql and write the function like "@vdSql:NOW()"). Also you can set another column's value for this particular column of the selected table by using @vdLocal prefix.

      vData Setup Profile

      vData Setup Profile

    • Reference To# Set this option if you want to use that column value as Reference to another table. For e.g. if you want to use catid in Articles table as reference to categories table then it will match the given column in categories table and fetch the related ID as catid.

      vData Setup Profile

    • Asset Reference# Set this option if you want to automatically handled the asset_id as Reference to asset table. For e.g. it will automatically manage the asset ids of the content table.

      vData Setup Profile

  • Join Tables: Click on the “Add Table” button to JOIN with another table to fetch some data from other table. You can remove a JOIN table on clicking “Remove” button. You can apply JOIN operation (JOIN, LEFT JOIN and RIGHT JOIN) on multiple tables as per your need. You can also set your desired option with each column of that table which you want to join

    For e.g. To import the custom fields data along with JomSocial User’s data, we have to make a JOIN on Jomsocial User table and Jomsocial Custom Fields Value table. All the custom fields’ data will be imported to Jomsocial Custom Fields Value table related to a particular user of Jomsocial.

    vData Setup Profile

  • Different MySQL JOINs you can use:
      • JOIN: Returns all rows when there is at least one match in BOTH tables
      • LEFT JOIN: Return all rows from the left table, and the matched rows from the right table
      • RIGHT JOIN: Return all rows from the right table, and the matched rows from the left table

    vData Setup Profile

Custom Setting Option for Export Type Profile

vData Setup Profile

If you have unchecked the Quick Import/Export Mode, then you can set all the fields as per your requirements to Export your desired columns from database.

  • Columns: All the columns of selected table will be displayed. You can set your desired option with each column of that table whether you want to include or exclude the particular column of the table in Data Migration Process (Export Type). Description of each option described below:

    vData Setup Profile

      • Skip# Set the dropdown option to “skip” if you don’t want to include a particular column of the table in Data Migration Process (Export Type).
      • Include# Set the dropdown option to “Include” if you want to include a particular column of the table in Data Migration Process (Export Type).
      • As Defined# Set this option if you want to define custom value for the column value. You can also execute some PHP or MySQL function like NOW(), CURDATE(), CURTIME(), time() etc.
      • Reference To# Set this option if you want to use that column value as Reference to another table. For e.g. if you want to use catid in Articles table as reference to categories table then it will match the given column in categories table and fetch the related ID as catid. In asset_id case, you can either skip or give a reference to another table. If you choose “skip” option for the asset_id field, then it will set default rules for asset_id but if you give reference to assets table and select the rules then it will set your given rules for assets table

    vData Setup Profile

  • Filters: Click on the “Add Filter” button to apply your custom filters on the table data from which you want to perform Data Migration Process (Export). You can remove a filter from table on clicking “Remove” button. You can also set “Order By” and “Group By” filters on the table. You can apply a filter condition using different operators like “OR”, “AND”, “XOR” etc. You can also use Further operators in your query to filter records like “=”, “!=”, “<”, “>”, “IN”, “NOT IN”, “BETWEEN”, “NOT BETWEEN”, “LIKE”, “NOT LIKE”, “REGEXP” etc.

    vData Setup Profile

    vData Setup Profile

  • Join Tables: Click on the “Add Table” button to JOIN with another table to fetch some data from other table. You can remove a JOIN table on clicking “Remove” button. You can apply JOIN operation (JOIN, LEFT JOIN and RIGHT JOIN) on multiple tables as per your need.

    You can also set your desired option with each column of that table which you want to join.

    For e.g. To export the custom fields data along with JomSocial User’s data, we have to make a RIGHT JOIN on Jomsocial User table and Jomsocial Custom Fields Value table. All the custom fields’ data will be exported related to a particular user of Jomsocial.

    vData Setup Profile

  • Different MySQL JOINs you can use:
      • JOIN: Returns all rows when there is at least one match in BOTH tables
      • LEFT JOIN: Return all rows from the left table, and the matched rows from the right table
      • RIGHT JOIN: Return all rows from the right table, and the matched rows from the left table

    vData Setup Profile