Import Set

[G Balaji]

First time I started working import sets I was looking out for resources on best practices but I came across only one after posting the question in community. So, I decided to write one with what I've worked/learnt. It's quite little and this is my first article as well, but I believe this'd be a start.

Folks, please share your knowledge about import set which you'd faced in your projects and the solution for the same. 

Few of the pointers to consider while defining transform maps are as follows, 

1. When you're working with user data, importing user name from the excel might cause unintended users mapped because user name may not be unique. In this case, it'd better to take email as the input from the business  and use transform scripts to derive the user name.

2. When data is imported for columns with datetime data types, set the date format field value as empty so that default date format for that instance is applied.

3. If the excel sheet has empty values for the fields and target table has a non-empty value, non-empty value will not over-written unless "Copy empty fields" is checked.

4. Use transform scripts to glide another table and update field values in another table.

5. Enforce mandatory fields as per your requirements.

Thanks.