Contact Us Today! | vcare@wdmtech.com

WDMtech

Using the Profile Wizard, you will be able to choose and load setting from our predefined profiles of Users, Menus, Modules, Categories, Articles etc. and most of the 3rd Party Extensions(i.e. Virtuemart, K2, JoomShopping, DJ Classified, PayPlans, JomSocial, EasyBlog, ZOO, Kunena, JEvents etc.) to perform Import/Export Operation with just one click.

Profile Wizard

Simply click on one of the predefined profile of famous joomla extension to load its setting and update it as per your need and save it. You can also create your custom Profile by clicking on Custom (first) icon on the Grid. vData Allows you to apply search and filter operation to find a particular profile.

You can filter predefined profiles based on a particular joomla component or import/export type profile.

Profile Wizard

Profile Wizard

Custom Setting Options for Import Type Profile

Custom Setting Options for Import Type 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 Columns

  • 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 Skip and Include

  • 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 String

  • 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 Strip Tags, Char Limit and Date

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

vData Number

  • 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 URL Safe

  • 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 Encryption

vData Encryption

  • Email => Set this option if you want to validate this column value as Email. It will be includ only if validation result is success otherwise it will not include.

vData Email

  • 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 As Defined

vData As Defined

  • 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 Reference To

  • 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 Asset Reference

  • 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 Join Tables

    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 Different MySQL JOINs

Custom Setting Option for Export Type Profile

vData Custom Setting Option for Export Type 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 Custom Setting Option for Export Type 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 skip, Include, As Defined and Reference To

  • 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 also apply a filter on a Referenced Table column. 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 Filters

vData Filters

  • 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 Filters

    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 Different MySQL JOINs