Some Cells Blank? Loading csv file from other than google docs

Resolved mouschi
(@mouschi)

8 years, 7 months ago

2 Questions:

1) In the year column at http://www.cansecocollector.com/my-have-list there are several fields at the beginning that are blank, but there is data in the csv file. Here is the code I’m using:

[gdoc key=”https://docs.google.com/spreadsheets/d/1qM-Csy4mjOz9hkVnLErI5mukwKZRShglEGWyPr29ORE/edit?usp=sharing” datatables_paging=”false” query=”select B, C where A = ‘x'”]

What can I do to get these to show?

2) Using the code:
[gdoc key=”http://cansecocollector.com/cansecototal.csv” datatables_paging=”false” query=”select B, C where A = ‘-‘”]
I cannot get the data to show at all. It just says “[gdoc Error requesting data: Operation timed out after 5 seconds with 0 bytes received]” What am I doing wrong?

Many thanks in advanced!

https://wordpress.org/plugins/inline-google-spreadsheet-viewer/

Viewing 7 replies - 1 through 7 (of 7 total)

Thread Starter mouschi
(@mouschi)

8 years, 7 months ago

Update for #1 above – It looks like the ‘year’ is not displaying whenever it is not showing a 4 digit number. They will show if it says, say, 1989 but not 1989-90 or ????. Why would this be?

Update for #2 above – the data still does not show, but now it does not show any error after restarting my browser.

Thread Starter mouschi
(@mouschi)

8 years, 7 months ago

I guess I’m not going to worry about retrieving a sheet not in google docs. if you wouldn’t mind letting me know about why the cells are blank for me when i don’t just have a 4 digit number though, it would be greatly appreciated.
Plugin Author Meitar
(@meitar)

8 years, 7 months ago
It looks like the ‘year’ is not displaying whenever it is not showing a 4 digit number. They will show if it says, say, 1989 but not 1989-90 or ????. Why would this be?

Because “1989” is a number but “????” is a string. When returned from a query, Google returns data of the first type, in this case number, and since “????” is not a number, it gets cast to null. See the GQL documentation:

Supported data types are string, number, boolean, date, datetime and timeofday. All values of a column will have a data type that matches the column type, or a null value.

You also asked:

It just says “[gdoc Error requesting data: Operation timed out after 5 seconds with 0 bytes received]” What am I doing wrong?

You may be trying to load more data than your server can load within the default 5 second timeout. To increase the timeout, use http_opts and pass in a JSON object that increases the timeout value. For instance, to 20 seconds:
```
[gdoc key="ABCDEFG" http_opts='{"timeout":20}']
```
Thread Starter mouschi
(@mouschi)

8 years, 7 months ago

Thanks so much for your response. So I guess my real question is, how do I get all the cells to display then?

Plugin Author Meitar
(@meitar)

8 years, 7 months ago

how do I get all the cells to display then?

Don’t mix types. Either treat all the cells as numbers or treat them all as strings.

Thread Starter mouschi
(@mouschi)

8 years, 7 months ago

Forgive my ignorance on this – how do I treat them all as strings? I’d be happy to, but I guess I’m not sure how treat them as all strings. For instance, in my csv here is an example of each in my csv:

x,????,Broder The Press Box #20
x,1993,Red Foley Stickers #16

What would I do differently?

Thanks again

Plugin Author Meitar
(@meitar)

8 years, 7 months ago

Replace all occurrences of ???? with a number, like 0.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Some Cells Blank? Loading csv file from other than google docs’ is closed to new replies.