search

Autodesk-Forge / bim360appstore-model.derivative-nodejs-xls.exporter

BIM360 data to Excel: Let you export the Revit data, hosted on BIM360, into an Excel file
MIT License
23 stars 23 forks source link

Downloading large files #40

Open ko-ogundowole opened 2 years ago

ko-ogundowole commented 2 years ago

Does anyone have a suggestion regarding export of significantly large files?

The service works wonderfully, but when a file approaches 250Mb is size, the download is stuck on 'Preparing {filename}.xlsx' and 'Reading project information...'.

Is there, perhaps, a way to divide large files into categories of objects, and download several smaller sized .xlsx files?

K3ph4s commented 1 year ago

Hey, i had the same issue about it. i talked to Augusto and he told there is a restriction in the file size. am trying to develop a similar app through ACC to extract all the data without restrictions.

xiaodongliang commented 1 year ago

first, this sample uses the endpoint /properties which has default limit with volume of model metadata (20MB). When the properties of this model exceeds the default 20MB, it will throw 413. You could add the query param forceget=true when fetching the properties. e.g. https://aps.autodesk.com/en/docs/model-derivative/v2/reference/http/metadata/urn-metadata-guid-properties-GET/#query-string-parameters in the sample source code, this line can be: https://github.com/autodesk-platform-services/aps-extract-spreadsheet/blob/master/public/js/ExportXLS.js#L60

IF you know the filter which objects 's properties to be download, you could migrate the code with other endpoint: https://aps.autodesk.com/blog/advanced-query-model-derivative-api which supports downloading in pagination.