Need help/guidance setting up a cron job that will import data from an excel file into wordpress db (publications/blogposts)

[ad_1]

Hi,

I do front end but sometimes have to deal with this kind of stuff im not very good at. The company I work at right now needs a website refresh, and they publish a huge number of scientific articles and projects.

To keep it short, they keep track of projects, publications and multiple other data points in excel, and this excel program can generate a file that is uploaded to a web server (manually), and a cron job takes this data and feeds it into the database. The old website uses Typo3 and is mad buggy (aka i suck at php). I looked up cron jobs and have been reading about them for a while, but my lack of familiarity with anything mildly complex in WP will be my downfall (I’m a vuejs/design guy).

Any way to do this? The Publications on wordpress will be displayed as cards which when you click on just show a simple description.

*To recap*

**Excel file with all publications (title, authors, location, etc) -> upload to host -> cron job shoves the data from this excel file into db on a weekly basis -> new posts available on website.**

Thanks for any sugestions.

[ad_2]