search

usdigitalresponse / arpa-reporter

Web app to aid government agencies in reporting on ARPA grants.
Apache License 2.0
3 stars 0 forks source link

[Partner submission] [Audit Report] Testing this early - Some issues with the mapping beyond my understanding. #429

Closed usdr-grants closed 2 years ago

usdr-grants commented 2 years ago

Submitted Description: Hi,

Medium priority as this is obv the last step in the reporting process, but wanted to test it out early so I can upload the UST portal and see whether it takes.

  1. For FY22Q4, I have the following files for test aggregation (see pic_1).
  2. I then click 'Download Treasury Report' and extract the zipped files to my local desktop
  3. See attached files for what I get.

(Optional) Uploaded file - click to download: https://www.jotform.com/uploads/grants.dev/212695501572052/5335335914521500745/expendituresGT50000BulkUpload.csv https://www.jotform.com/uploads/grants.dev/212695501572052/5335335914521500745/pic1.PNG https://www.jotform.com/uploads/grants.dev/212695501572052/5335335914521500745/project18_229233BulkUpload.csv https://www.jotform.com/uploads/grants.dev/212695501572052/5335335914521500745/project215218BulkUpload.csv https://www.jotform.com/uploads/grants.dev/212695501572052/5335335914521500745/subawardBulkUpload.csv

jcomeau1 commented 2 years ago

It looks like this is a CR/LF issue. Using the subawardBlukUpload as the example, you can see something happens with Col G where the guidance ends up on A8 and then things continue from there. The root cause for all of these templates is likely the same.

trumanc commented 2 years ago

I believe this issue was fixed in https://github.com/usdigitalresponse/arpa-reporter/pull/418 We've just deployed that fix to main, so it should be fixed for partners now.

trumanc commented 2 years ago

Closing this as we believe it is fixed. If you're continuing to see the problem, please re-open!