Schedule Events to Occur According to a Designated Schedule
The Event Scheduler enables you to automate many processes in your database. You can:
-
Import Data |
| Publish Data |
| Download Emails |
| Run a Script |
| Update a Set |
Choose how often you want the Event to run – e.g., every hour, once a day, every Monday, on the first day of the month, etc.
The Event Types
Event Type: Get Emails
In order to use this event type you must first set up at least one email account. (To do this, choose Email Accounts from the Communications menu on the main window.)
- Choose the Mailbox you want to monitor. This should be a mailbox that is dedicated to this function.
- You can run a script after each email is received. Scripts can be written to perform all kinds of functions, such as parsing the contents of an email and performing some function in response to keywords found in the subject line or the message text, for example. Please contact us to discuss your requirements. To run a script, select the Run a script when each email is received check box, then click on the View/Modify Script button to add the script.
Event Type: Import Data
You must set up one or more Import Formats first (click on the Import Data button on the main window and choose Add a new Import Format from the pop-up menu).
- Choose the Import Format you want to use to import data.
- Choose from:
- Import a specific file: Look for a file of the same name, in the same location, each time. For example, each day your company's accounting system creates a report of updated product prices. It saves this report as a CSV file in a shared directory on your server. You could create an Event to open this file every evening and use it to update the product prices in the database.
- Import any files in the folder: you can create a "drop" folder into which files or various names can be dropped at any time. Select this option to monitor the drop folder and import whatever files it finds in there.
- Delete file(s) after successful import: Select this option to delete the files after they have been imported
- Run a script after successful import: Click on the View/Modify Script button to choose a script to run after each file has been imported
Event Type: Publish Data
To use this event type, you must first set up at least one Publishing Project.
Event Type: Run a Script
- Click on the View/Modify Script button to select the script to run.
Event Type: Update a Set
- Select the set to update
- Optionally select the Run a script after successful update check box, then click on the View/Modify Script button to select the script
What's Next?
