Opened 3 years ago

Closed 3 years ago

#2227 closed defect (fixed)

Incorrect progress percentage when importing from Excel file

Reported by: Nicklas Nordborg Owned by: everyone
Priority: minor Milestone: BASE 3.17.1
Component: core Version:
Keywords: Cc:

Description

While importing data that was in an Excel file I noticed that the progress percentage got as high as almost 400% before the import was finished.

The reason seems to be that the progress is based on the number of bytes that are parsed from the file compared to the total file size. In the case of Excel file there is an implicit conversion to CSV which of course gives a different virtual file size.

In this case the Excel file was 145Kb in size and the corresponding CSV file turned out to be 557Kb. Thus, the reported percentage was 100 * 557/145 = 380%.

It would be nice if it was possible to fix this.

Change History (1)

comment:1 by Nicklas Nordborg, 3 years ago

Resolution: → fixed
Status: new → closed

In 7876:

Fixes #2227: Incorrect progress percentage when importing from Excel file

Added support for using a "scale factor" when parsing input streams. We can choose from a linear scaling when we know the final size of the CSV or a curved scaling that adapts itself so that the actual file size of the Excel file is never passed.

Note: See TracTickets for help on using tickets.