Grant Import File

File Name	Import Date	Status Message	Imported By	Comments
{{grantImportFileListModel.fileName}}	{{grantImportFileListModel.importTimestamp \| sparsDateTime: "hh:mm a":"Local"}}	{{grantImportFileListModel.statusMessage}}	{{grantImportFileListModel.importedBy}}	{{grantImportFileListModel.comments}}
Click "+ Import File" button to Import a file.

Grant Import File

Only one file can be imported at a time. Select the file you wish to import, enter any comments about your data (optional), then click the 'Submit' button at the bottom of the page to send your file to CSAP. Note, the system can only accept files in .csv format and in the standardized templates.

Grant Import File

Program*

Funding Opportunity Announcement*

Reporting Period Type

FOA Reporting Period Start Date

FOA Reporting Period End Date

First Progress Report Name*

First Progress Report Start Date*

First Progress Report End Date*

Grant End Date

First PLD Reporting Period Date*

Outcome Period Year*

Comments

File Errors:

Row	Field	Error Text
{{error.rowNumber}}	{{error.field}}	{{error.errorMessage}}

Summary List

Program: {{model.editItemModel.edit.program.description}}
FOA: {{model.editItemModel.edit.fundingOpportunityAnnouncement.description}}
Reporting Period Type: {{model.editItemModel.edit.reportingPeriodType.description}}
Reporting Period: {{model.editItemModel.edit.reportingPeriod.startDate}} - {{model.editItemModel.edit.reportingPeriod.endDate}}
First Progress Report Name: {{model.editItemModel.edit.progressReportName}}
First Progress Report Period: {{model.editItemModel.edit.progressReportStartDate}} - {{model.editItemModel.edit.progressReportEndDate}}
Grant End Date: {{model.editItemModel.edit.grantEndDate}}

Please see the list below for the information imported.

Row	Grant number	Grant name	Grantee org. name	Grantee org. city	Grantee org. state	Grantee org. zipcode	GPO email	GPO first name	GPO last name	GPO phone	PD email	PD first name	PD last name	PD phone	PD phone ext.	eRA award number.	Applicant type code.	Applicant type.	Congressional district.
{{grantImportFileStagingListModel.rowNumber}}	{{grantImportFileStagingListModel.grantAwardNumber}}	{{grantImportFileStagingListModel.grantAwardName}}	{{grantImportFileStagingListModel.granteeOrganizationName}}	{{grantImportFileStagingListModel.granteeOrganizationCity}}	{{grantImportFileStagingListModel.granteeOrganizationState}}	{{grantImportFileStagingListModel.granteeOrganizationZipcode}}	{{grantImportFileStagingListModel.projectOfficerEmailAddress}}	{{grantImportFileStagingListModel.projectOfficerFirstName}}	{{grantImportFileStagingListModel.projectOfficerLastName}}	{{grantImportFileStagingListModel.projectOfficerPhoneNumber}}	{{grantImportFileStagingListModel.granteeContactEmailAddress}}	{{grantImportFileStagingListModel.granteeContactFirstName}}	{{grantImportFileStagingListModel.granteeContactLastName}}	{{grantImportFileStagingListModel.granteeContactPhoneNumber}}	{{grantImportFileStagingListModel.granteeContactPhoneNumberExtension}}	{{grantImportFileStagingListModel.eraAwardNumber}}	{{grantImportFileStagingListModel.applicantTypeCode}}	{{grantImportFileStagingListModel.applicantType}}	{{grantImportFileStagingListModel.congressionalDistrict}}

Error List

Please see the list below for rows with error information. Use the Export List button to export the current error list.

Row	Error	Grant number	Grant name	Grantee org. name	Grantee org. city	Grantee org. state	Grantee org. zipcode	GPO email	GPO first name	GPO last name	GPO phone	PD email	PD first name	PD last name	PD phone	PD phone ext.	eRA award number.	Applicant type code.	Applicant type.	Congressional district.
{{grantImportFileStagingListModel.rowNumber}}	{{grantImportFileStagingListModel.statusMessage}}	{{grantImportFileStagingListModel.grantAwardNumber}}	{{grantImportFileStagingListModel.grantAwardName}}	{{grantImportFileStagingListModel.granteeOrganizationName}}	{{grantImportFileStagingListModel.granteeOrganizationCity}}	{{grantImportFileStagingListModel.granteeOrganizationState}}	{{grantImportFileStagingListModel.granteeOrganizationZipcode}}	{{grantImportFileStagingListModel.projectOfficerEmailAddress}}	{{grantImportFileStagingListModel.projectOfficerFirstName}}	{{grantImportFileStagingListModel.projectOfficerLastName}}	{{grantImportFileStagingListModel.projectOfficerPhoneNumber}}	{{grantImportFileStagingListModel.granteeContactEmailAddress}}	{{grantImportFileStagingListModel.granteeContactFirstName}}	{{grantImportFileStagingListModel.granteeContactLastName}}	{{grantImportFileStagingListModel.granteeContactPhoneNumber}}	{{grantImportFileStagingListModel.granteeContactPhoneNumberExtension}}	{{grantImportFileStagingListModel.eraAwardNumber}}	{{grantImportFileStagingListModel.applicantTypeCode}}	{{grantImportFileStagingListModel.applicantType}}	{{grantImportFileStagingListModel.congressionalDistrict}}