We run an online contacts database that can export in csv format. The online database allows users to update their details. I need a copy of those details in a PanX database. What’s the best way to set up the PanX database so I can easily overwrite the contacts from the online export? I want to be able to refresh the contacts information every couple of months.
The PanX database does more than the online database, it’s a HR database and needs the core information from the online database. In building out the PanX HR database I want a simple and easy mechanism to refresh the contacts data and update/add/delete data from the online source.