I have an excel file where each row is a separate page I want inserted into Wordpress. The columns are all of the fields on the "insert page" page on wordpress. Outside of the stock wordpress install, I have added the plugin "WP SEO" and it has some extra fields on the insert page screen that aren't normally there. I have cells for these fields in the excel database as well.
The problem. I created an AutoHotKey script to copy all of the data in a row to separate variables, then open up the browser and go to the insert page screen and paste them all back there. It will run for a little while, then error out when my internet connection hits a dead spot or something doesn't work exactly as according to plan. I need a more simple way of doing this, preferably using the MySql database and PHP.