Dear Adrian

Are you able to help me with problems that I am having with RGoogleData? I
would greatly appreciate it if you could give me some general trouble
shooting ideas or better yet if you could fix the problem.

I believe that I updated to the latest version of RGoogleData as evidenced
by
>  packageDescription("RGoogleData")
Package: RGoogleData
Type: Package
Title: An R interface to Google Data (Docs, Calendar, Contacts, Finance,
etc.)
Version: 0.2.0
Date: 2009-12-11
Depends: rJava
Author: Adrian A. Dragulescu
Maintainer: Adrian A. Dragulescu <adrian.dragulescu@gmail.com>
Description: Provide R access to Google Data API.
License: GPL-3
Repository: R-Forge
Repository/R-Forge/Project: rgoogledata
Repository/R-Forge/Revision: 6
Date/Publication: 2009-12-13 21:43:52
Packaged: 2009-12-14 21:05:13 UTC; rforge
Built: R 2.10.1; ; 2009-12-14 23:02:39 UTC; windows

-- File: C:/PROGRA~2/R/R-210~1.1/library/RGoogleData/Meta/package.rds

But Alas

My previous script has stopped working.

library(RGoogleData)
ps <-readline(prompt="get the password in ")
con <-googleConnect("fjbuch@gmail.com",ps)
allXls <- getSpreadsheets(con)
xls <- allXls[[which(sapply(allXls, slot, "title") == "OnCall")]]
allWks <- getWorksheets(xls)# get the worksheets
Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl,  :
  java.lang.ClassCastException: com.google.gdata.data.TextContent cannot be
cast to com.google.gdata.data.OutOfLineContent


I also tried:

target <-downloadDocument(doc="OnCall",
filepath="C:/Users/fbuchinsky/Documents/My Dropbox/OnCalltrial.csv",
fileformat="csv", sheetIndex=1)
Error in regexpr("%3A", doc@key) :
  trying to get slot "key" from an object of a basic class ("character")
with no slots

Farrel Buchinsky


Sent from Pittsburgh, Pennsylvania, United States

On Thu, Dec 10, 2009 at 10:38, Adrian Dragulescu <adrian_d@eskimo.com>wrote:

>
> I will try to have something in place by Monday to allow you to download a
> specific sheet not default to the first.  I will let you know.
>
> Adrian
>
>
> On Thu, 10 Dec 2009, Farrel Buchinsky wrote:
>
>  Thank you Adrian. Your response was very informative.
>>
>> ?downloadDocument filled me with excitement untill I read, "If you try to
>> download a spreadsheet with multiple worksheets into a 'csv' or 'tsv'
>> format, only the first worksheet will be downloaded."
>>
>> So now there is a convenient fast way to read data under two circumstances
>>
>>  1. if the spreadsheet has been
>> published<
>> http://blog.revolution-computing.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html
>> >
>>  2. if one only wants the first sheet (RGoogleData's downloadDocument()).
>>
>>
>>
>> Farrel Buchinsky
>> Google Voice Tel: (412) 567-7870
>>
>> Sent from Pittsburgh, Pennsylvania, United States
>>
>> On Thu, Dec 10, 2009 at 09:32, Adrian Dragulescu <adrian_d@eskimo.com
>> >wrote:
>>
>>
>>> Farrel,
>>>
>>> Please read the manuals.  On the RGoogleData package page you can read:
>>> "The package provides R access to Google services through the Google
>>> supported Java API.
>>>
>>> [...]
>>>
>>> A package with very similar functionality is maintained by Duncan Temple
>>> Lang at \url{http://www.omegahat.org/RGoogleDocs/}.  The approach taken
>>> there is to use \code{RCurl} and \code{XML} to interact with the lower
>>> level Google HTML protocol.  You should check it out too."
>>>
>>> Regarding the questions you have about speed.  Google spreadsheets is
>>> labeled Labs, mabye there are performance issues on Google side.  The
>>> approach for both RGoogleDocs and RGoogleData is to make requests to the
>>> Google servers and parse the XML results.  RGoogleDocs parses using a C
>>> library, RGoogleData uses a Java library.  Going through the Java
>>> interface
>>> is an extra step, so that might explain the speed difference.
>>>
>>> Check ?downloadDocument if you want to download the entire document.  It
>>> should be fast.  You can load it into R after that.
>>>
>>> Best,
>>> Adrian
>>>
>>>
>>>
>>> On Wed, 9 Dec 2009, Farrel Buchinsky wrote:
>>>
>>>  Both of these applications fulfill a great need of mine: to read data
>>>
>>>> directly from google spreadsheets that are private to myself and one or
>>>> two
>>>> collaborators. Thanks to the authors. I had been using RGoogleDocs for
>>>> the
>>>> about 6 months (maybe more) but have had to stop using it in the past
>>>> month
>>>> since for some reason that I do not understand it no longer reads google
>>>> spreadsheets. I loved it. Its loss depresses me. I started using
>>>> RGoogleData
>>>> which works.
>>>>
>>>> I have noticed that both packages read data slowly. RGoogleData is much
>>>> slower than RGoogleDocs used to be. Both seem a lot slower than if one
>>>> manually downloaded a google spreadsheet as a csv and then used read.csv
>>>> function - but then I would not be able to use scripts and execute
>>>> without
>>>> finding and futzing.
>>>>
>>>> Can anyone explain in English why these packages read slower than a csv
>>>> download?
>>>> Can anyone explain what the core difference is between the two packages?
>>>> Can anyone share their experience with reading Google data straight into
>>>> R?
>>>>
>>>> Farrel Buchinsky
>>>> Google Voice Tel: (412) 567-7870
>>>>
>>>> Sent from Pittsburgh, Pennsylvania, United States
>>>>
>>>>
>>>>
>>

	[[alternative HTML version deleted]]


