Updating database with CSV file automatically?

  • Resolved henrya94

    (@henrya94)


    7 years, 6 months ago

    Hello, I really like this plugin, but I have a need to update the database automatically when the uploaded CSV file changes. I know I can import a new CSV file manually through the admin and have the records update, but is there a way to automate this so PD checks the upload directory for the new CSV and updates the database that way?

    Specifically, I want to run a script on a schedule that imports a new CSV file to the /uploads/participants-database folder and have PD do what it would normally do when I uploading a file in the admin.

    Thanks for any help.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Roland Barker

    (@xnau)

    7 years, 6 months ago

    I don’t know of any way to automate the importation of a CSV file using the plugin’s CSV import functionality.

    I have seen people set this up on their server as a cron that imports the CSV via the database server directly. This doesn’t have anything to do with your WordPress or Participants Database, is all done on the server. This can be a bit tricky, however, as the some of the field types have specific data storage formats that need to be respected.

    If you’re not familiar with how to set this kind of thing up, you can ask your hosting provider.

    Thread Starter henrya94

    (@henrya94)

    7 years, 6 months ago

    Updating the table through the command line worked lovely. Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Updating database with CSV file automatically?’ is closed to new replies.