topic Re: Restriction of number of rows from import of Web file (Gogle docs)? in QlikView

Restriction of number of rows from import of Web file (Gogle docs)?

Anonymous — Tue, 17 Mar 2015 08:21:05 GMT

Hi,

I discovered that there seems to be an restriction of the number of row you can import by Web files from Google docs (spread sheet).

It only imports the first 100 rows...

I don't think I had the problem before (a year ago) and maybe this has accured after Google has upgraded their spreedsheets to a new version

Anybody else that has encoutered the same problem?

// Peter

Re: Restriction of number of rows from import of Web file (Gogle docs)?

jonathandienst — Tue, 17 Mar 2015 08:40:24 GMT

This might be a restriction imposed by Google on the free version of Google Docs. You may need to convert to a paid subscription to load more rows.

Just a thought, I may be wrong....

Jonathan

Re: Restriction of number of rows from import of Web file (Gogle docs)?

Anonymous — Tue, 17 Mar 2015 09:49:35 GMT

It is an paid subscription so it should not be any restrictions... But a good thought though...

// Peter

Re: Restriction of number of rows from import of Web file (Gogle docs)?

Ralf-Narfeldt — Tue, 17 Mar 2015 10:43:10 GMT

Without digging deep into it, my suspicion is that it has to do with browser compatibility. I think Google Docs spreadsheet had a 100 row limitation when launched.

There is a connector called QVSource which reads Google Docs spreadsheets.

Re: Restriction of number of rows from import of Web file (Gogle docs)?

Anonymous — Tue, 17 Mar 2015 12:16:59 GMT

I have had a look at the QVSource and it manages to read all the rows, but it does not do it smart enough. My spreadsheet starts with template format row and continues headlines, instructions, etc.

My actual data starts att row 5 or 6 and Qlikview handles this nicely by deleting the top rows in the import function.

This is not possible with QVSource (what I can see) and it only makes a mess of the data... it supposes that the top row is the headline.

And yes I could possible restructure the data, but I wont do that... 🙂

// Peter