I'm accessing data from Spreadsheets through Secure Data Connector. Data is
in CSV format. Most of the time it works fine, like this:
Row 1 ["colheader1"] ["colheader2"] ["colheader3"]
Row 2 ["data1"] ["data2"] ["data3"]
Sometimes - with nothing else changing - all columns show up in a single
column of the spreadsheet, like this:
Cell A1 ["colheader1", "colheader2", "colheader3"]
Cell A2 ["data1", "data2", "data3"]
This kills the chart.
Usually, updating the URL with a nonsense parameter fixes the problem. Then
it looks normal again.
Cell A1 contains a formula such as
=ImportData("http://server.domain.com/report/page.aspx?r=MyParam)<about:blank>
or, with workaround for more frequent updating:
=ImportData("http://server.domain.com/report/page.aspx?r=MyParam&workaround='&INT(NOW()*1E3)&REPT(GoogleFinance('GOOG');0)")<about:blank>
How do I prevent this? I contacted Google Apps for Business support and
they sent me here.
Thanks!
