- Can we bulk-upload these PDFs to Salesforce and associate them with the particular student record? For example, can John Doe Grade Report.pdf get attached to John Doe's record, Jane Doe Grade Report.pdf get attached to Jane Doe's record, etc.
YES - You can use Data Loader to upload attachments to Salesforce. Before uploading attachments, note the following:
If you intend to upload via the Bulk API, verify that Upload Bulk API Batch as Zip File on the Settings | Settings page is enabled.
To upload attachments: Confirm that the CSV file you intend to use for attachment importing contains the following required columns (each column represents a Salesforce field):
- ParentId - the Salesforce ID of the parent record. This will be Salesforce ID of a Student Record.
- Name - the name of the attachment file, such as testPDF.pdf.
- Body - the absolute path to the attachment on your local drive. Ensure that the values in the Body column contain the full file name of the attachments as they exist on your computer. For example, if an attachment named testPDF.pdf is located on your computer at C:\Export, Body must specify C:\Export\testPDF.pdf.
- Can we write a mass-email that pulls in these reports as an attachment. It would look something like this, ideally:
YES- This will involve a apex code.
- If you want to send an email to a Student when attachment is inserted into SFDC then you need to write a trigger code. Trigger code can contain a logic to send an email to Student Record.
- The another possible solution will be to write a Batch apex class, which will run on a daily basis. It will identify all the attachments which are uploaded on that day, It will find out the associated students and send email to those student records along with their PDF as an attachment.