When exporting a collections report .csv, if the date range/file size is too large, the export will not contain all requested records. An incorrect/abbrieviated export does not contain malformed records, it just does not include all of them. An incorrect export does not have a constant size, but is always a fraction of the expected size. Perhaps a response chunking issue? The screen display before export does show all of the requested records. Perhaps relevant source: https://github.com/openemr/openemr/blob/master/interface/reports/collections_report.php#L348
Reports->Financial->Collections and Aging->Select All->Export Selected as CSV
Exported .csv contains all selected records.
Working HTTP POST, expected/actual size 556060 bytes 2962 records:
POSThttps://myopenemrserver/interface/reports/collections_report.php
[HTTP/1.1 200 OK 7492ms]
POST
https://myopenemrserver/interface/reports/collections_report.php
Status
200
OK
VersionHTTP/1.1
Transferred376.36 kB (556.06 kB size)
Referrer Policystrict-origin-when-cross-origin
Cache-Control
must-revalidate, post-check=0, pre-check=0
Connection
Keep-Alive
Content-Description
File Transfer
Content-Disposition
attachment; filename=collections_report.csv
Content-Type
application/force-download
Date
Wed, 25 Jan 2023 15:51:38 GMT
Expires
0
Keep-Alive
timeout=5, max=97
Pragma
public
Server
Apache
Strict-Transport-Security
max-age=31536000; includeSubDomains; preload
Transfer-Encoding
chunked
X-XSS-Protection
1; mode=block
Accept
text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8
Accept-Encoding
gzip, deflate, br
Accept-Language
en-US,en;q=0.5
Cache-Control
no-cache
Connection
keep-alive
Content-Length
374526
Content-Type
multipart/form-data; boundary=---------------------------297990782711930969943763489815
DNT
1
Host
myopenemrserver
Origin
https://myopenemrserver
Pragma
no-cache
Referer
https://myopenemrserver/interface/reports/collections_report.php
Sec-Fetch-Dest
iframe
Sec-Fetch-Mode
navigate
Sec-Fetch-Site
same-origin
Sec-Fetch-User
?1
Upgrade-Insecure-Requests
1
User-Agent
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/109.0
Failing HTTP POST, expected size 559399 bytes 2980 records, actual size 72733 bytes 385 records:
POSThttps://myopenemrserver/interface/reports/collections_report.php
[HTTP/1.1 200 OK 7053ms]
POST
https://myopenemrserver/interface/reports/collections_report.php
Status
200
OK
VersionHTTP/1.1
Transferred378.63 kB (72.73 kB size)
Referrer Policystrict-origin-when-cross-origin
Cache-Control
must-revalidate, post-check=0, pre-check=0
Connection
Keep-Alive
Content-Description
File Transfer
Content-Disposition
attachment; filename=collections_report.csv
Content-Type
application/force-download
Date
Wed, 25 Jan 2023 16:05:18 GMT
Expires
0
Keep-Alive
timeout=5, max=100
Pragma
public
Server
Apache
Strict-Transport-Security
max-age=31536000; includeSubDomains; preload
Transfer-Encoding
chunked
X-XSS-Protection
1; mode=block
Accept
text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8
Accept-Encoding
gzip, deflate, br
Accept-Language
en-US,en;q=0.5
Cache-Control
no-cache
Connection
keep-alive
Content-Length
376792
Content-Type
multipart/form-data; boundary=---------------------------386474561223780583923043157833
DNT
1
Host
myopenemrserver
Origin
https://myopenemrserver
Pragma
no-cache
Referer
https://myopenemrserver/interface/reports/collections_report.php
Sec-Fetch-Dest
iframe
Sec-Fetch-Mode
navigate
Sec-Fetch-Site
same-origin
Sec-Fetch-User
?1
Upgrade-Insecure-Requests
1
User-Agent
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/109.0
Pay now to fund the work behind this issue.
Get updates on progress being made.
Maintainer is rewarded once the issue is completed.
You're funding impactful open source efforts
You want to contribute to this effort
You want to get funding like this too