Contact Us Today! | vcare@wdmtech.com

WDMtech

Data has a way of accumulating in various formats, files, and locations, which makes it hard to actually get any use out of it. If you have data in a CSV, JSON, XML, or some other format like MySQL, you can import it into your database with just a few steps, making it much more, well, Accessible. Also, you can simultaneously import multiple CSV files with same column structure. To Import Data, please go to vData => Import (or go to Dashboard and click on Import link in sub-menu).

vData Data Import

  • Profile: Choose the Profile from dropdown using which you want to import the Data. You can either select a profile from the list or can create a profile with your desired settings in the Profile section which we have discussed earlier.

Importing Data from a File

  • Data Source Format: vData gives you the ability to import your Data from multiple Data Source Formats.

vData Data Import

    You can Import the Data from the file type listed below:
  • CSV File (you can simultaneously import multiple CSV files with same column structure.)
  • JSON File
  • XML File
  • Database
  • Data Source: Click to browse and upload Data Source File straight from your local machine.

vData Data Import

OR

  • Enter Path: A new feature of vData allows you to read the file either from your Local Server or from Remote Server for importing your Data. You just need to enter your Data Source File Path into the input box after selecting the option “Local Server”. In case of “Remote Server”, you have to enter FTP details of remote server like FTP Host, FTP Port, FTP User, FTP Password, FTP Directory and File Name.

vData Data Import

vData Data Import

Click on “Continue” Button for the Final step. You will be redirected to a layout where you can map the Fields in Data source with your Database table columns.

If you want to set default rules for asset_id field in assets table, then do not select the rules for asset_id field but if you want to override the rules for the asset_id field in assets table then choose the new rules from the Rules dropdown list. You can also set a Custom Node Path for a field in XML/JSON Data Source Format case.

Set the category extension and category title for catid field.

vData Data Import

Click on “Import Now” Button to start the Import Process after setting fields to the right column.

A progress bar helps you to check the progress of the process If the Data you are importing is huge.

Importing Data from a Database

vData Data Import

  • Data Source: Set this option to “Database” If you want to perform import operation from other Database either from “Local Server Database” or “Remote Server Database”. If “Database” option selected by you then some additional fields will be display to take further information.
  • Local Database: Check this option if you want to perform import process from your local database table. But if you want to connect to Remote Server Database then uncheck this checkbox and fill the necessary information to connect with Remote Server Database.
  • Driver: The Server Database Driver e.g. mysql or mysqli etc.
  • Host Name: The Host name running Database Server or use the Server IP address.
  • Database User: The username accessing the Database on Server.
  • Password: The password you entered for that Database user.
  • Database Name: The Database Name on Server.
  • Database Prefix: The Prefix of Database Tables if any e.g. jos_ etc.

vData Data Import

Click on “Continue” Button for final step of Import Process. You will be redirect to a layout where you can map the Data Source File fields with your Table columns. You will have to choose a table from which you want to import Data from Database.

If you want to set default rules for asset_id field in assets table then do not select the rules for asset_id field but if you want to override the rules for the asset_id field in assets table then choose the new rules from the Rules dropdown list.

Set the category extension and category title for catid field after making a join on category table on the basis of colum1 and colum2.

You can also set the value of a particular field by “Reference Value” option from the list.

vData Data Import

To get a value by reference, choose “Reference Value” option then select the table to join and then select column on which you want to join and the then select the desire column of the joined table.

vData Data Import


vData Data Import

Click on “Import Now” Button to start the Import Process after setting fields to the right column.

A progress bar helps you to check the progress of the process if the Data you are importing is huge.