Hi Malin,
Thank you for your response.
We actually use both methods : Excel add-in with Document templates or for tables not included on standard templates : Excel add-in (by designing from scratch) or Data management > Import > Csv files.
Your blog was very useful to learn about Excel add-in, thank you to share learning on Talent :)
We still not achieve to import past workers. We have tried with employees already assigned to a position (and fill out assignment end) or without assignment.
- Using Document templates : Template display name ''Employees''
Filling field TERMINATION DATE don't have impact on Worker status
- Using Excel add-in from scratch (design > add tables)
Updating table Worker, field WORKER STATUS : Employed to Terminated => read-only field.
Even if we publish by force, error message on Employment detail table.
Updating table Employment detail and simultaneously Employment => error message on value not found in the related table Employment.
- Using Data management > Import > Employees.csv (cf. initial post) => error on data integrity.
How to do it correctly ? Meaning, what are fields required to fill and in which order to specify an employee as a past worker ?
Thank you in advance for help :)
Best regards.
Sarah