Increase Hard Limit for DPAS Exports

Warehouse

USMC: DMC

Done

Submitted: 6/19/2015

Description
When exporting data from Defense Property Accountability System (DPAS) that contains more than 25,000 records, the users receive an error message that says the following:
Max Export Limit Reached
The maximum limit for exporting is 25,000 records.
This can affect users who are performing any type of analysis of mass records. It would be best to have no hard limit on an amount or records that can be exported.
I am requesting that we modify the maximum limit. My recommendations are below, in the preferred order (if option 1 can be achieved, then use that. If not, then see if we can use option 2...)

1. Unlimited
2. 1,000,000
3. 500,000
4. 250,000
5. 100,000

Please note that if any of the options are placed in effect, then the generic file format for Excel (.xls) needs to be changed to the following file extension: .xlsx. The current format, .xls, is limited to 65536 rows and 256 columns per sheet; however, the file extension of .xlsx allows 1,048,576 rows and 16,384 columns per sheet.

Recommended
I am recommending that we modify the maximum limit.
My recommendations are below, in the preferred order (if option 1 can be achieved, then use that.
If not, then see if we can use option 2...)

1. Unlimited
2. 1,000,000
3. 500,000
4. 250,000
5. 100,000

Please note that if any of the options are placed in effect, then the generic file format for Excel (.xls) needs to be changed to the following file extension: .xlsx.
The current format, .xls, is limited to 65536 rows and 256 columns per sheet; however, the file extension of .xlsx allows 1,048,576 rows and 16,384 columns per sheet.

Mission Critical
This is mission critical in that it does not allow any type of data mining within DPAS, transitively causing a critical deficiency in the process flow of tasks that require data mining or mass reconciliation.

Benefits

Users
Primarily Supply System Analysts

Tuesday, November 29, 2016:
Marked as included in 3.2 done at a later date and not included in the release letter.