Anyone have any success loading employee bank deta...
# administration
w
Anyone have any success loading employee bank details via CSV to allow us to pay expenses via EFT?
s
few years ago I did load thousands of employee bank information during a migration/implementation. csv headers Employee External ID First Name Last Name Type Payment File Format Bank Account Type Bank Account Number Branch Number Bank Number 1st step: CSV import your your employee banking information using the above header, make sure to use "add" option and advance import to select non - default form, default form might not have all the fields. This will create banking information record for the employee. Note that these records will not be attached to the employees yet, you need to do another import to link them with the employee records. 2nd Step: create a simple load file from saved search of the newly created banking information records - just get the internal id - new load file doesn't need to have all the field just internal ID and one other field. Run a import job again this time use "Update" only - this will cause the records to be updated and saved (technically you are not updating any values), this will trigger a system hidden field that links it to the specific entity record in this case employee record. Once updated all the banking info will be linked properly to it's specific entity record. Make sure to test this in sand box first. Also your employee record should have an external ID for reference.