I have updated the plugin because I have faced the following scenario:
- When I use Google SpreadSheet, as an initial step, I select a SpreadSheetId, then I select a WorkSheetId.
When I administer a long Google SpreadSheet, in many I download in XLSX and update the data and then import it with the option to replace Sheet, that is where my ETL is broken and the WorkSheetId code is lost so my ETL no longer works.
I have implemented a solution to this problem, the GoogleSpreadsheetInput.java class and in the INIT method, I have added a validation method that does the following: Verifies that the WorkSheetId exists in the SpreadSheet, in case it does not exist by default it selects the sheet in zero position.
With this solution I have been able to solve the import problem by replacing Google SpreadSheet data time
Analyze the viability of adding this functionality in the project and then send it to the Pentaho MarketPlace
In case the project is not maintained, I can take charge of the project pdi-google-spreadsheet-plugin to add features that improve the integration with Google SpreadSheet.
Good afternoon.
I have updated the plugin because I have faced the following scenario:
- When I use Google SpreadSheet, as an initial step, I select a SpreadSheetId, then I select a WorkSheetId.
When I administer a long Google SpreadSheet, in many I download in XLSX and update the data and then import it with the option to replace Sheet, that is where my ETL is broken and the WorkSheetId code is lost so my ETL no longer works.
I have implemented a solution to this problem, the GoogleSpreadsheetInput.java class and in the INIT method, I have added a validation method that does the following: Verifies that the WorkSheetId exists in the SpreadSheet, in case it does not exist by default it selects the sheet in zero position.
With this solution I have been able to solve the import problem by replacing Google SpreadSheet data time
Analyze the viability of adding this functionality in the project and then send it to the Pentaho MarketPlace
In case the project is not maintained, I can take charge of the project pdi-google-spreadsheet-plugin to add features that improve the integration with Google SpreadSheet.
Best regards.