Comments (9)
bplmp
commented on May 30, 2024
Google sheets has a limit of 5 million cells. If you are limiting rows on Metabase, but still getting this error, it might be that the script is interpreting the results of the query differently from what you see on Metabase.
Maybe you have special characters or linebreaks in your data that are breaking the csv, outputted by Metabase?
I would suggest:
- go to your metabase query, on metabase
- download the file as a csv
- try importing it manually in Google Sheets or another program, to check if the csv formatting looks OK
from metabase-google-sheets-add-on.
natea
commented on May 30, 2024
I tried to do the import again and today the report imported with no problem, doing about 6200 rows (not sure about the number of cells).
But thanks for the tip on how to troubleshoot if I get that error again.
Do you know of any way to automate the fetching of data on a schedule (perhaps daily, weekly, monthly)? I'd like to try to avoid having to click the "Import question" button in the Metabase menu.
from metabase-google-sheets-add-on.
bplmp
commented on May 30, 2024
Good thing it worked!
You can probably use this and adapt thr script to schedule executions:
https://developers.google.com/apps-script/guides/triggers/installable#time-driven_triggers
…On Sun, Apr 18, 2021, 14:47 Nate Aune ***@***.***> wrote:
I tried to do the import again and today the report imported with no
problem, doing about 6200 rows (not sure about the number of cells).
But thanks for the tip on how to troubleshoot if I get that error again.
Do you know of any way to automate the fetching of data on a schedule
(perhaps daily, weekly, monthly)? I'd like to try to avoid having to click
the "Import question" button in the Metabase menu.
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#3 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AC2PB2QOFHUKF2QAPELF3CDTJMLKDANCNFSM4256BJ7Q>
.
from metabase-google-sheets-add-on.
natea
commented on May 30, 2024
I'm getting this error again, and I haven't been able to troubleshoot why it's giving the error. "Question 3 failed to import. Exception: This action would increase the number of cells in the workbook above the limit of 5000000 cells."
I'll try your suggestion of downloading the CSV to see if there are any special characters that are breaking the CSV.
from metabase-google-sheets-add-on.
natea
commented on May 30, 2024
The only thing I noticed that could potentially cause problems for the import script were some rows in the CSV that have Japanese characters.
Do you know if your script can handle these character sets?
from metabase-google-sheets-add-on.
natea
commented on May 30, 2024
That seemed to solve the problem When I created a filter on the Metabase report to exclude those rows that have content with Japanese characters, then the import worked correctly. Any chance you can make the script support non-ascii characters?
from metabase-google-sheets-add-on.
bplmp
commented on May 30, 2024
@natea I don't think this is something related to the script... Every part involved seems to support UTF-8 encoding (Metabase, Google Apps Script, etc.).
Again, have you checked if you have line breaks in your data?
from metabase-google-sheets-add-on.
bplmp
commented on May 30, 2024
This confirms it works
from metabase-google-sheets-add-on.
natea
commented on May 30, 2024
Thanks. I'm not sure why it's giving that error then. The error happened with the Japanese characters, and the error went away when I removed them. But since you're clearly able to import text with Japanese characters, it must have been some other reason.
Nate Aune - Founder & CEO, DjangoZoom
http://djangozoom.com | http://twitter.com/djangozoom
+1 (855) DJANGOZOOM
…On Mon, May 03, 2021 at 12:44 PM, Bernardo Loureiro < ***@***.*** > wrote:
jptxt (
https://user-images.githubusercontent.com/11858154/116905593-92ac7b00-ac15-11eb-85c1-766c6eac40a0.gif
)
This confirms it works
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub (
#3 (comment)
) , or unsubscribe (
https://github.com/notifications/unsubscribe-auth/AAA5BSDIWGGUXEVIHTIHW63TL3HFTANCNFSM4256BJ7Q
).
from metabase-google-sheets-add-on.
Related Issues (15)
- DNS error HOT 4
- Exception: Could not parse text HOT 4
- Auto import specific question instead of all questions HOT 2
- Possibility to add variables
- Addressing the metabase from internal server
- Getting this error.
- Error popup
- Update data in real time without import the question HOT 2
- Add on not available anymore? HOT 1
- DNS Error HOT 16
- Metabase Google Auth Login HOT 3
- Could not parse text HOT 3
- Can't see functions after publishing the add-on HOT 1
- Filter by column
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from metabase-google-sheets-add-on.