Video on creating a secure file storage bucket:
Note: This process creates an Amazon AWS file storage bucket which you can manage from your PeopleGrove site. Once the storage bucket is created, a CSV containing your credentials (i.e. Access Key and Secret Access Key) to the AWS bucket will download. You will only need these if you wish to use your storage bucket with another site as well. We recommend saving your credentials somewhere secure, but you won’t need them to access the bucket from your PeopleGrove site.
Setting up a recurring import:
You'll begin your import process from the set you will be pulling information from and sending to your secure file storage bucket. For more information on the script needed and that process read this article. Note: This article and process is recommended for IT professionals..
1. First create a formatted CSV with the data you wish to import. (based on the formatting you learned in import training)
2. Click Upload the file to your secure file storage bucket.
3. If you have no folders set up yet, you’ll be asked to create and name one now.
4. Then you will need to upload your CSV file.
5. Save the file path (folder name + file name). For example: recurring_syncs/Recurring Student Import.csv
6. Visit the Import Data tool, and create a new Recurring Data Sync.
7. Name the sync, select the import type, and enter the file path.
8. Select the day(s) of the week and the hour at which you want the import to run.
9. Set your import settings.
10. Return to the Recurring Data Sync page to Enable the import.
11. You can edit your import setting by clicking Edit Settings next to the import.
Setting up a recurring export:
1. Visit Explore Users or Data Viewer
1a.If in Explore Users: Filter for the end users you wish to export
- add and/or remove columns to capture the data you wish to export for each end-user.
1b. If in Data Viewer: You may filter even further down for a report that already exists.
2. Click on Reporting
3. Click Save as New Report
4. Name your report.
5. Go to Export Data.
6. Click Setup New Export Job.
7. Name your export with an Export Title
8. From the dropdown menu select the report you wish to export
8. From the dropdown menu select the report you wish to export
9. Choose the Folder for export (where the export goes in your Secure File Storage bucket)
a. You can also add a folder here (Add Folder button) if you have yet to name a folder int eh Secure File Storage for the export.
10. Name your file for the future (Base file name)
11. Set your export settings
a. Choose if you wish to overwrite the file with each export or append the file name to save each
11. Set your export settings
a. Choose if you wish to overwrite the file with each export or append the file name to save each
individual export
12. Choose how frequently and when to run your export.
12. Choose how frequently and when to run your export.
13. Once the export has run, you’ll find a copy of the CSV in your Secure File Storage bucket. Click on the pg_scheduled_export_jobs/ folder, and you’ll see all export files with the time stamp of when the export occurred in the file name.
Comments
0 comments
Please sign in to leave a comment.