Importing Data

Conrep's powerful import tool helps you import your data quickly into Conrep application modules. It provides flexible data migration facilities supporting ETL architecture. Data can be edited directly in the tool prior to being imported into the database.

Define Imports in five easy steps and use each import definition repetitively.

Define Source structure
Define Fields and Transfer Rules
Choose one or multiple target modules
Define Update Rules for each target module
Define duplicate records logic, if any, for each target module

Once you define your import, you can choose to perform one step at a time or execute all steps sequentially with a single-click. While importing data into Conrep, it goes through following steps:

Data extraction and staging in raw format
Make any manual updates or execute data cleansing functions on staged data
Data Transformation using Transfer Rules
Make any manual updates or execute data cleansing functions on transformed data
Load data into target application modules as per the defined update rules
Fix erroneous records, if any, and re-upload only those records

Your users can import their data (their clients, vendors, contacts etc) with a single-click. All they need to do is choose appropriate import, supplying the data file and execute the import. That's it. All steps in import process will be executed automatically as per that import definition.

Find Import process diagram below: