Google Analytics - xaction

[dulci]

Hi! I´m a newbie using kettle and google analytics. I have the community version of Pentaho and I downloaded the plugin to extract data from Google Analytics from http://type-exit.org/adventures-with...in-for-kettle/ . This is really good and after install java JRE is working fine in kettle. The thing is that when I try to make a. xaction with a job created with this plugin it doesn´t work....The error is as follows:

Unable to load the class pass / extension with id [TypeExitGoogleAnalyticsInputStep]. Make sure the extension is available in the extensions subdirectory of the distribution of Kettle.

but....how I should add this extension? when I generate the xaction ? Can someone please help me ? I need the data for Monday .
Thank you very much!

[slawomir.chodnicki]

Kettle plugins go into pentaho-solutions/system/kettle/plugins in your BI Server.

Cheers
Slawo

[dulci]

Hi Slawo,
First of all, I want to thank you for the fast response. I did what you told me...but unfortunately it doesn't work yet.
I didn't have the plugins folder inside pentaho-solutions/system/kettle/plugins so I create it and I added the folder GoogleAnalytics, so the path is pentaho-solutions/system/kettle/plugins/GoogleAnalytics and inside that folder I have the .jar file and a folder named lib.
It's giving me the following error "Class not Found" ...maybe I'm doing something wrong...sorry...please someone help me! Thanks .

2011/11/10 05:49:02 - GA - Extract Data from GA - Loading transformation from XML file [file:///C:/Archivos de programa/Pentaho/biserver-ce/pentaho-solutions/PDI/GA - Extract Data from GA.ktr]
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.pentaho.di.core.exception.KettleException:
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : Unexpected error during transformation metadata load
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) :
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : Error leyendo transformación desde el fichero XML
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) :
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : No se ha podido leer la información del paso desde XMLorg.pentaho.di.core.exception.KettlePluginException:
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : Class not found
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.typeexit.plugin.google.analytics.GaInputStepMeta
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) :
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) :
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : Class not found
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.typeexit.plugin.google.analytics.GaInputStepMeta
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) :
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) :
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) :
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1142)
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:594)
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.pentaho.di.job.Job.execute(Job.java:471)
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.pentaho.di.job.Job.execute(Job.java:600)
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.pentaho.di.job.Job.execute(Job.java:600)
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.pentaho.di.job.Job.execute(Job.java:344)
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.pentaho.di.job.Job.run(Job.java:282)
2011/11/10 05:49:04 - GA - Initial Load Job - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.pentaho.di.core.exception.KettleException:

Thanks in advance for the quick response.

[kandrews]

If you are running using Spoon .. make sure you shut it down and restart it now that you added something into its path.

Might work!

Kent

[slawomir.chodnicki]

You need to replicate the spoon plugins directory. The GA plugin is a step, so the complete path would be (analogous to Spoon) pentaho-solutions/system/kettle/plugins/steps/GoogleAnalytics

Cheers
Slawo

[dulci]

I replicated the structure but still it doesn't work...and the thing is that I don't have nothing that could point me to the error. Find below the errors and I attached too al the logs that I have, please anyone who can help me with this ?

2011/11/22 14:23:35 - Google Analytics.0 - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : Unexpected error :
2011/11/22 14:23:35 - Google Analytics.0 - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : java.lang.NoSuchFieldError: log
2011/11/22 14:23:35 - Google Analytics.0 - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.typeexit.plugin.google.analytics.GaInputStep.getNextDataEntry(Unknown Source)
2011/11/22 14:23:35 - Google Analytics.0 - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.typeexit.plugin.google.analytics.GaInputStep.processRow(Unknown Source)
2011/11/22 14:23:35 - Google Analytics.0 - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
2011/11/22 14:23:35 - Google Analytics.0 - ERROR (version 4.1.2-GA, build 14760 from 2011-01-26 13.31.23 by buildguy) : java.lang.Thread.run(Thread.java:662)



Thank you!!!

[jsanta]

java.lang.NoSuchFieldError: log
The GA plugin isn't familiar to me, your logs say you're pointing to a not found field (called log). Perhaps if you share your transformation to have a look at it someone may help a bit more (just delete any compromising data from it).

Best regards,
José Ignacio Santa Cruz G.