I am new to Glide and am trying to create a simple database-based app to browse newspaper article content.
I am experiencing a recurring error when importing a long table (happens both with Excel and CSV, and also when linking to a Google Sheet) with ~25.000 rows.
After the import, random rows seem to be missing.
To illustrate this most easily, I created an Excel file with 25.000 rows and a single column, numbered from 1 to 25.000. After importing, you can see on the screenshot that e.g. the rows 2, 4, 11, 16, 17, 23, 24, 27, 32 etc. are missing.
This is really strange, what is going on?
Which plan are you on?
If you are on a plan that has a 25k row limit, then importing a 25k row CSV file is probably bumping you over the limit, which may explain the behaviour.
What happens if you try it with a smaller number of rows? Say around 10,000 for example.
I have upgraded to the Business plan, to make sure I do not run into these kinds of issues. Also, if I ran into a row limit, why would random rows be missing throughout the table? (I would expect the table to just cut off at the row limit?)
I don’t think the behaviour when you hit the limit is well defined, and anecdotal evidence seems to suggest that it’s pretty random.
But anyway, even on a Business Plan you are still limited to 25k rows for native (regular) Glide Tables. So it’s a still a possibility that you’re hitting the limit.
My suggestion: try the same with a Big Table. If that doesn’t work as expected, submit a support ticket.
I am trying this on a Big Table, and I am getting the same mistake. Generally, I am having a lot of trouble importing large data sets, which I find extremely frustrating. So I will probably just cancel my account.
Okay, your earlier screenshot indicated a regular table, not a Big Table.
It should work, and I’ve done it myself with datasets of up to 250k rows without issue, which is why I’m a little surprised that you’re having problems - and also why I suggested submitting a support ticket. If there is an issue there, then it’s in all of our interests to get it in front of Glide Engineering.
1 Like
