You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Data Management - Excel table limit of 10k rows

Laserfiche Cloud Business Processes
Updated November 14, 2023
posted on November 1, 2021

Hi All,

a Cloud customer we're working with was trying to upload an Excel spreadsheet to the Data Management section as a lookup table. However, they ran into an error that mentioned a 10k row limit for the spreadsheet, see attached screenshot.

Does anyone have a solid workaround to this limit?

The customer prefers not to have to breakdown the spreadsheet into multiple ones, as this would create extra work due to some 'repeating values' that they mentioned.

Data Mgmt - spreadsheet limit error.JPG
Data Mgmt - spreadsheet limit error.JPG (90.28 KB)
Download
1 0
replied on November 3, 2021

There is no workaround to the limit.

I would check this document out - https://doc.laserfiche.com/laserfiche.documentation/en-us/Subsystems/ProcessAutomation/Content/Resources/Service-Limits.htm

Cloud has many limitations which are really important to consider when determining what projects to do.  The data limits and starting rules alone rule out quite a bit.

2 0
View 1 previous reply
replied on November 11, 2021

Thanks Chris. We decided to split the field into 4 separate ones, A-F, G-L, M-R, S-Z. We split the Excel spreadsheet into 4. Each of the 4 fields will lookup from the corresponding 4 tables in Data Management.

0 0
replied on November 11, 2021

FYI, LF Support emailed us back today and mentioned that they're aware of the requests about this and are considering adding the ability to do live lookups in external db's from within a Biz Process form. There is no timeline at the moment.

1 0
replied on November 9, 2023

As of the November Release, we have raised the limits for Lookup Tables according to your license tier.

1 0
replied on November 14, 2023

Thanks Tesia, I'll keep these new limits in mind.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Attachments
Related Posts
Loading ...