US and Worldwide: +1 (866) 660-7555
Results 1 to 7 of 7

Thread: Google Analytics - xaction

  1. #1

    Exclamation Google Analytics - xaction

    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!
    Last edited by dulci; 11-06-2011 at 08:30 AM.

  2. #2
    Join Date
    Sep 2009
    Posts
    809

    Default

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

    Cheers
    Slawo
    Do you want to know more? Check out Adventures with Open Source BI

  3. #3

    Default Plugins folder

    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.

  4. #4
    Join Date
    Mar 2006
    Posts
    170

    Default

    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

  5. #5
    Join Date
    Sep 2009
    Posts
    809

    Default

    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
    Do you want to know more? Check out Adventures with Open Source BI

  6. #6

    Exclamation Still doesn't work, but the error is different now.

    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!!!
    Attached Files Attached Files
    Last edited by dulci; 11-22-2011 at 09:24 AM. Reason: New log added

  7. #7
    Join Date
    Mar 2009
    Posts
    112

    Default

    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •