Profile

Sebastian Lechner

Customer Community General Account

Contact Details

Customer Community General Account

My Content

1 to 14 of 14 total

RE: Jdk-13.0.1 and Jdk-13.0.2 not working for PDI 9

Posted By Sebastian Lechner 04-06-2021 07:56
Found In Community: Pentaho \ view thread
HI Troy, The correct way to comment out a line in a Windows .bat file is to write   REM   in the beginning of the line.

RE: Jdk-13.0.1 and Jdk-13.0.2 not working for PDI 9

Posted By Sebastian Lechner 02-26-2020 11:14
Found In Community: Pentaho \ view thread
Those Warnings were related to plugins and libraries we are not using anyway so I removed them from the PDI directories according to the guide: https://blog.twineworks.com/improving-startup-time-of-pentaho-data-integration-78d0803c559b   After that, all the warnings and error messages disappeared but ...

RE: Jdk-13.0.1 and Jdk-13.0.2 not working for PDI 9

Posted By Sebastian Lechner 02-24-2020 16:34
Found In Community: Pentaho \ view thread
I just tried to get spoon running on my local MacOS with Java 13.0.2. When you start spoon.sh via shell like bash spoon.sh then one gets loads of errors and warnings, although the GUI would start up in the end. Also the marketplace is missing in the menu. Not sure if I wanted to have it like this on ...

RE: Jdk-13.0.1 and Jdk-13.0.2 not working for PDI 9

Posted By Sebastian Lechner 02-12-2020 12:07
Found In Community: Pentaho \ view thread
I was not aware of that, thanks for the update.

RE: Jdk-13.0.1 and Jdk-13.0.2 not working for PDI 9

Posted By Sebastian Lechner 02-12-2020 12:02
Found In Community: Pentaho \ view thread
Everyone but Pentaho

RE: Jdk-13.0.1 and Jdk-13.0.2 not working for PDI 9

Posted By Sebastian Lechner 02-12-2020 10:12
Found In Community: Pentaho \ view thread
You can get the Oracle JDK 8 here: https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

RE: Jdk-13.0.1 and Jdk-13.0.2 not working for PDI 9

Posted By Sebastian Lechner 02-11-2020 12:38
Found In Community: Pentaho \ view thread
According to this article https://support.pentaho.com/hc/en-us/articles/360016233851-Support-Statement-for-Pentaho-Software-Requirements-for-Java-Runtime-Environment-JRE- PDI 8.3 is compatible with Java 8. Compatibility with Java 11 is On the Road Map.

RE: "Google Spreadsheet Input/Output" plugin compatible with Google Sheets API v4?

Posted By Sebastian Lechner 02-11-2020 12:33
Found In Community: Pentaho \ view thread
https://github.com/valdineygomes/pdi-google-spreadsheet-plugin can be compiled and it is working. To me it looks, that Valdiney Gomes made the fork compatible with API v4 by upgrading the pom.xml dependencies to newer version numbers. We will try to replace the deprecated classes and methods by newer ...

RE: "Google Spreadsheet Input/Output" plugin compatible with Google Sheets API v4?

Posted By Sebastian Lechner 02-11-2020 12:26
Found In Community: Pentaho \ view thread
Hi Ana, thanks for your reply. In the meantime I found out that https://github.com/valdineygomes/pdi-google-spreadsheet-plugin can be compiled and that it is working. During compilation, it has a few deprecation warnings for some pentaho classes and for googleapis.auth.oauth2. From my point of view this ...

RE: "Google Spreadsheet Input/Output" plugin compatible with Google Sheets API v4?

Posted By Sebastian Lechner 02-07-2020 16:32
Found In Community: Pentaho \ view thread
I could get more detailed output:   [WARNING] /Users/sl/pdi-google-spreadsheet-plugin/src/main/java/org/ccci/gto/pdi/trans/steps/googlespreadsheet/GoogleSpreadsheetInputMeta.java:[13,31] org.pentaho.di.core.row.ValueMeta in org.pentaho.di.core.row has been deprecated [WARNING] /Users/sl/pdi-google-s ...

RE: "Google Spreadsheet Input/Output" plugin compatible with Google Sheets API v4?

Posted By Sebastian Lechner 02-07-2020 16:21
Found In Community: Pentaho \ view thread
I have used a fork which claims to have updated to use API v4 -> https://github.com/valdineygomes/pdi-google-spreadsheet-plugin I just ran the build process again and saw that I get this warning: [WARNING] .../pdi-google-spreadsheet-plugin/src/main/java/org/ccci/gto/pdi/trans/steps/googlespreadsheet ...

RE: "Google Spreadsheet Input/Output" plugin compatible with Google Sheets API v4?

Posted By Sebastian Lechner 02-07-2020 14:54
Found In Community: Pentaho \ view thread
Hi,   I have checked the forks posted by @Sergio Ribeiro​ and found that they cannot be built because of outdated dependency structure in the pom.xml. It took me a day to refactor the pom.xml updating all dependency artifacts to their latest available version and add missing dependencies. The plugin ...

RE: "Google Spreadsheet Input/Output" plugin compatible with Google Sheets API v4?

Posted By Sebastian Lechner 01-16-2020 15:38
Found In Community: Pentaho \ view thread
Instead of giving an answer to this question, the plugin has been removed from the marketplace although it is still working and it seems to be the only available Google Spreadsheet solution in the Community Edition. Very helpful.

"Google Spreadsheet Input/Output" plugin compatible with Google Sheets API v4?

Posted By Sebastian Lechner 01-07-2020 15:41
Found In Community: Pentaho \ view thread
We are using the Google Spreadsheet Input/Output plugin from the marketplace created by Brian Zoetewey which is no longer maintained. Github repository link. Recently I have received an email from Google with the subject: [Action Required] Google Sheets v3 API is being shutdown on March 3, 2020   Can ...