Automation

Need some direction.

I get a csv file twice a day, some times more with new content items. Some items are duplicates. Currently, I have to import this data manually into WP using a csv importer. It has custom fields, images, categories, tags, content, ect.

What I would like to do is be able to auto pilot these actions on a schedule, So I can take a vacation. I would like to have the csv file downloaded automatically then it goes straight into WP or the database and automatically populate it with the items. I’m not sure if I should look into a cron job, myphpadmin or what. I would also need to be able to overwrite any duplicate entries. Hopefully this made sense and any help or direction would be appreciated.

Thanks