You’re offline. This is a read only version of the page.
For some reason, integration manager cannot update address id, address 1, Gender, Marital Status, Ethnic, Origin and Deduction:
I have a text source file with all the fields above defined.
I have the destination: Payroll Master
I have a destination mapping that maps the field in the source file with the destination.
I have tried setting the integration to update only and insert and update but nothing works.
The integration runs successfully with no errors and no warning but only the address id updates. The other fields remain blank. I have set the "Employee ID" as IsKey under Source setting.
What is going on here?
*This post is locked for comments
I have the same question (0)
To start with I would say that the Address ID and all address fields need to be in a separate source file (although this could be the same physical file). Integration Manager is weird about the way it handles one to many relationships. If there's a one to many in the database (e.g. multiple address for one employee), you generally need to have different source files.
For the gender, marital status, and ethinic orgin, you probably don't have have valid values in the source file for the import. Since these are drop down lists in GP, the values are numeric from 0 to ... To make sure you have to correct values, you should always translate these fields by using the Translation option. Let me know if you need more info about doing this. Hopefully this is enough to get you started.
Mike
Share
Report
All responses (
Answers (
9
