Previous Year AFR Parsing Process¶
This document provides a high-level sequence diagram of how the NGSB application extracts general ledger information from a previous year’s AFR file. This process can be kicked off by system administrators by uploading the Previous Year AFR through the school district files page.
Note: At this time the system does not support parsing Excel files that have a password. Please remove the password before submitting any files to this process.
sequenceDiagram
participant gcs
participant worker
participant db
activate db
critical process
option try
critical upsert ledger
worker ->> db: upsert general ledger for previous fiscal year
end
critical download ledger file
worker ->> gcs: file.download(tmp)
activate gcs
gcs ->> worker: tmp
deactivate gcs
end
worker ->> db: delete previous normalized<br/>records by year & account id
par process records
worker ->> db: update job progress
worker ->> worker: normalize record
worker ->> db: save normalized record
end
worker -->> db: refresh chart data based on normalized records
worker ->> db: update ledger with "completed" status
option catch
worker ->> db: update general ledger with error details and statuses
worker ->> worker: exit process
end
deactivate db