On a nightly basis, our Human Resources system will create a CSV file of 'Contacts'. The file contains a custom unique field [EmpID]. The vTiger system needs to import the CSV file and either INSERT the record into Contacts tables if the [EmpID] does not already exist or UPDATE the data if the [EmpID] already exists.
I can code a script to be run via cron nightly to import CSV into the database either updating existing record or insert a new one. I don't require a payment until it is working properly. Thank you.