Hi - I'm (still!) trying to import from Google spreadsheets but find that there is a limit on the size I can import. I'm sure where that limit is, but I find a 5 column x 60 row sheet will import, but not a 5 x 600. If it's to big I sometimes get a "DOMDocument cannot parse XML: " error, or just a white page.

Is there any documentation on size limits?

Comments

infojunkie’s picture

infojunkie
Location Vancouver
CreditAttribution: infojunkie commented

Thanks for your report!

According to this post, there seem to be 2 conflicting DOM libraries in PHP: http://framework.zend.com/issues/browse/ZF-3933. Can you please check your phpinfo() and report on the name and version of your DOM extension?

Also, if you can make public the Google Spreadsheet you're trying to import, I can try it here to see how the import goes.

thebeepseal’s picture

thebeepseal CreditAttribution: thebeepseal commented

Hi and thanks for the reply. Here is what phpinfo() tells me:

dom

DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.6.26
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled

I don't really want to make the spreadsheet public - I've shared it with you (you should have the invitation) - will that work?

I's pretty big 1050 rows x 18 cols - maybe that's asking too much anyway. But 600 x 5 should work, surely?

Many thanks

infojunkie’s picture

infojunkie
Location Vancouver
CreditAttribution: infojunkie commented
Assigned: Unassigned » infojunkie
Category: support » bug

I was able to reproduce the error with the sheet you shared with me. I'll be working on it and reporting my progress here.

infojunkie’s picture

infojunkie
Location Vancouver
CreditAttribution: infojunkie commented

It turns out that the Zend Gdata library is memory-hungry. I am planning to rewrite the Google import code using another library instead of Zend Gdata, but I still don't know how long it will take me.

thebeepseal’s picture

thebeepseal CreditAttribution: thebeepseal commented

Ah - ok. Thanks for looking into it. I'll keep an eye out for the new version. Let me know if there's anything I an do to help.

infojunkie’s picture

infojunkie
Location Vancouver
CreditAttribution: infojunkie commented
Status: Active » Fixed

Please try the latest dev release (12 hours from now) and let me know if you're able to open the sheet. It now opens for me.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Shaunikm’s picture

Shaunikm CreditAttribution: Shaunikm commented
Component: Miscellaneous » Core
Issue summary: View changes

I am not getting any additional details regarding size of spreadsheet etc. but getting this error as I am trying to login to google. I have tried 3 different google accounts.
DOMDocument cannot parse XML