Web Analytics Made Easy -
StatCounter How to schedule data extractions based on requirements - CodingForum

Announcement

Collapse
No announcement yet.

How to schedule data extractions based on requirements

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to schedule data extractions based on requirements

    Hello,

    I'd like to SCHEDULE a task to run automatically once per week that would EXTRACT all records from PHPBB_USERS which have either been newly created that week or were edited by the client within the same period.

    The data would extract to a COMMA-DELIMITED file which would then be automatically emailed using the PHP mail command to an intended recipient so that she can MERGE the datafeed into a larger and more complex offline database.

    Not entirely sure how this would be done, but I'm sure CRON would somehow get involved with the task.

    Any ideas or help would be greatly appreciated.

    Thanks!

    PS: my configs:>> RedHat Linux / Apache / PHP / MySQL

  • #2
    do you physically own your server? im not sure but i think youd have to setup a physical program on the server not just a web script if you wanted to do that..
    php & asp tutorials - the birthplace - biorust - photoshop and web technologies

    Comment

    Working...
    X