Setting Up Scheduled Exports
An exciting feature in EverTrue is the ability to schedule exports! Customers have the ability to schedule daily export files at a time they choose and have them delivered to them via secure FTP.
The following files are available via a scheduled export:
- Interactions
- Volunteer Interactions
- Relationship Management Assignments
- Volunteer Assignments
- Proposals
The ability to schedule an export allows a customer to “set it and forget it", which minimizes the amount of time a Data Administrator needs to spend doing manual work.
EverTrue's scheduled exports run daily at the time set by your institution (see below). All exported CSV files are delivered to the exports directory via SFTP. If you do not have access to your institution's directory with EverTrue, we recommend you reach out to your team's data administrator.
Note: Constituent data exports via the Browse section of EverTrue cannot be automated at this time.
How to Set Up Scheduled Exports
- If enabled, a customer will see a Scheduled Export section located in Settings > Export Data.
- Here, you can customize your scheduled export to a time that works best for your institution. First, click the gear icon next to the file type.
- Next, choose a time zone (this defaults to your current time zone) and set the time you want the export to run. Time options are separated into 30-minute increments from 12:00 AM-11:30 PM.
- Once saved, you have the option to cancel the export or edit the previous settings at any time.
- Exported CSV files will be delivered to your institution's EverTrue /exports directory via SFTP and can be picked up at any time. All exports are timestamped for each recognition. Our export process rechecks every ten minutes to see that the file has been delivered to your SFTP server, and if it’s not there, we recopy it. The copy check will continue to happen until the next scheduled export is run. It would be best if files were not deleted but rather moved into sub-directories, since we will delete your files automatically after 90 days.
What Timeframe is Included in an Export File?
The scheduled export feature pulls interactions that have been written since the last time an export was run. So, if you are turning on scheduled exports for the first time, your first file will contain all interactions written in EverTrue. On a nightly basis, this will contain interactions written since the previous export.
If an interaction is written close to the time of export, it will most likely not make it into that import file but will come out in the file for the next day. For example, if your export runs at 7 am EST, an interaction logged at 6:59 am EST will most likely not be included in that day's file. EverTrue will always catch interactions that have not been exported yet and include them the next day.
- Note: Please keep in mind that files will arrive within approximately 10 minutes of their scheduled time.
In the case your file contains no new data (no new interactions were entered/no interactions were edited) since the last export, we will still export your scheduled file. The file will contain the same headers as would be included in a file that contained data but will not contain any data below the column headers.
A note on File Naming:
EverTrue includes a date in the name of every export file. This date is in GMT time which means that it will differ from the date in your local time.
Ready to set up your scheduled exports? Let us know! For any other questions reach out to EverTrue Support at genius@evertrue.com.
Reply
Content aside
- 2 yrs agoLast active
- 1202Views
-
1
Following