Download settings has been added to allow modifications to your ‘Download using sheet data’ functionality. Each Wizard will vary with what settings are available.
Our latest Wizards have the ‘Sheet Filter Batch Size’ setting. This setting can be utilized in the scenario where downloading using sheet filters is timing out.
We do not recommend using this setting unless timeouts have occurred.
By setting this value, it will ‘Batch’ your download criteria based on the value you have set. This setting will have no value by default.
As a small-scale example, the following image depicts 18 row filters:
By providing a ‘Sheet Filter Batch Size’ of ‘10’, the download would use the first 10 filters, perform the download, then proceed to use the following filters until all filter criteria has been downloaded.
Recommendation: Only when timeouts are occurring, we suggest setting this value to 200. Results may vary depending on your number or filters and where in the data structure they reside. If timeouts still occur, reduce the batch size and reattempt the download.
Warning: When using the ‘Sheet Filter Batch Size’ setting, duplicates may be returned. We recommend using the'Denormalise' ribbon option on your downloaded data, sorting the sheet contents, then use the 'Normalise' ribbon option action to remove any duplicates.
