Import Tool

---

Stafftrends's powerful import tool helps you import your data quickly into Stafftrends 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 Stafftrends, 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