Smartstaff, administrator
686
edits
Changes
no edit summary
* Funds
* Budgets
'''Example:'''
For example, a common guideline would be the below.
* All contacts must on one worksheet with a unique identifier for each contact and a matching identifier for their organization (for those associated with organizations)
* All organizations must be on one worksheet with a unique identifier for each organization.
* All grants must be on one worksheet with a unique identifier for each grant and a matching identifier for the applicant contact and organization for the grant.
* If there are multiple contacts associated to a grant (e.g. applicants, reviewers), this must be provided on a separate worksheet with the grant unique identifier, the contact unique identifier, and the role of the contact association.
* If there are multiple organizations associated to a grant (e.g. payees), this must be provided on a separate worksheet with the grant unique identifier, the organization unique identifier, and the role of the organization association.
* All payments must be on one worksheet with a unique identifier for each payment and a matching identifier for the grant against which the payment is made.
* All progress reports for import must be on one worksheet with a unique identifier for each progress report and a matching identifier for the grant against which the progress report is made.
'''Constraints:'''
* A zipped file of all files attachments to be uploaded.
* A mapping file to match files to records. This will simply be CSV sheets that describe which record each file should be uploaded to. The CSV should contain columns for the unique identifier of the record to upload to, the record type (e.g. organization, contact), and the relative file path for each file.
'''Example:'''
For example, given a zip file whose contents look like the below.
