Skip to content

File Parsing

Chelsea edited this page Nov 25, 2023 · 2 revisions

Home > Features > File Parsing


File Parsing

The Parser Lambda is triggered as soon as a file is dropped into the S3 bucket, and the event records containing the list of new S3 files is passed to lambda.

The parser retrieves the files, parses them, and stores them in an Postgres AWS RDS instance.

Transaction data files from the Ministry-Client are reformatted and then stored in the transaction/payment tables

Deposit data files from Bank and Cash Management are converted from the flat file format and then stored in the pos_deposit table and cash_deposit table (dependent upon the file type)

After parsing is complete the AWS Simple Notification Service sends a message to trigger the Reconciliation Lambda which attempts to match the data

Clone this wiki locally