Profile

Dean Flinter

This individual is no longer active. Application functionality related to this individual is limited.

Contact Details

My Content

1 to 20 of 37 total

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

Posted By Dean Flinter 02-07-2020 16:37
Found In Community: Pentaho \ view thread
All look like Pentaho deprecations   If it is working, then great but it is possible Pentaho will eventually retire these too

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

Posted By Dean Flinter 02-07-2020 15:35
Found In Community: Pentaho \ view thread
Perhaps make your own fork with the updated pom.xml.   However are you absolutley sure that it is 100% API v4 compatible? If some parts of it still reference v3, it will break on 4th March

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

Posted By Dean Flinter 01-21-2020 13:07
Found In Community: Pentaho \ view thread
It is v3 unfortunately

RE: What is the best way to count the number of files in a folder that start with a particular letter (P)?

Posted By Dean Flinter 10-29-2019 16:11
Found In Community: Pentaho \ view thread
The attached will do it. If you need it to be case sensitive, then remove (?i) in the regex and change the p to whatever case you are looking for   Dont forget to change the path to what folder you are looking at

RE: Does PDI (8.3) support REST authentication Bearer method?

Posted By Dean Flinter 10-18-2019 08:24
Found In Community: Pentaho \ view thread
I have certainly used a bearer token in PDI before (for typeform API) so I know it does work   I used a Data Grid step to inject it into the REST step but it can be done several different ways

RE: PROBLEM WITH GET MAILS with BATCH FILE in WINDOWS SERVER 2012 R2

Posted By Dean Flinter 10-04-2019 14:38
Found In Community: Pentaho \ view thread
Hi Moises   Yeah, CSV input does not work with UNC.   Try Text File input as that does work with UNC

RE: PROBLEM WITH GET MAILS with BATCH FILE in WINDOWS SERVER 2012 R2

Posted By Dean Flinter 10-03-2019 11:04
Found In Community: Pentaho \ view thread
I had a look back at when I had this issue and actually, the fix is simpler than the above. Just specify the UNC path in your job/transformation and it should work without having to edit the .bat file   The reason I needed to edit the .bat file was because I was reading data from an Excel file and the ...

RE: I was able to export data from a web service to an XML file. But when using the Get Data from XML step, it return my records as null. Has anyone run into the same problem?

Posted By Dean Flinter 10-03-2019 10:55
Found In Community: Pentaho \ view thread
Would be easier to help if you could upload the XML and the transformation. If any sensitive data, just anonymise it. If its a lot of data, just give a couple of rows   Also, what version of PDI are you using?

RE: PROBLEM WITH GET MAILS with BATCH FILE in WINDOWS SERVER 2012 R2

Posted By Dean Flinter 10-03-2019 08:53
Found In Community: Pentaho \ view thread
Youre very welcome!   Glad you got it working. When I faced this issue it was very frustrating!!

RE: PROBLEM WITH GET MAILS with BATCH FILE in WINDOWS SERVER 2012 R2

Posted By Dean Flinter 10-03-2019 07:56
Found In Community: Pentaho \ view thread
Hi Moises   Assuming this is the issue, the only things I can think of are:   Is the path correct? If you copy and paste that path in explorer, will it get you to the correct place? My .bat file has a space between the drive letter and server details so use q: \\esfs01\q instead of q:\\esfs01\q   Thanks ...

RE: PROBLEM WITH GET MAILS with BATCH FILE in WINDOWS SERVER 2012 R2

Posted By Dean Flinter 10-02-2019 15:37
Found In Community: Pentaho \ view thread
Based on your original post, you are saving attachments down to Q:\Product Setup\Extracciones. Did you specify that drive location in your batch file (assuming it is a network drive)? Make sure to put it first in the script.   For example, in our organisation the shared drive is a folder on the server ...

RE: Having Issues Passing Basic Auth in Rest Client or HTTP

Posted By Dean Flinter 10-02-2019 15:20
Found In Community: Pentaho \ view thread
Would make more sense if you made a typo above and meant to say a 403 error?   If so then the issue appears to be with your api key

RE: PROBLEM WITH GET MAILS with BATCH FILE in WINDOWS SERVER 2012 R2

Posted By Dean Flinter 10-01-2019 13:39
Found In Community: Pentaho \ view thread
Does your job reference a file(s) on a network drive or is the job itself on a network drive? If so, then I had the same problem. Task Scheduler does not respect mapped network drives so you need to specify it in the bat file   Adding something like the below to your bat file should fix it   net use ...

RE: run report designer in PDI

Posted By Dean Flinter 08-27-2019 07:41
Found In Community: Pentaho \ view thread
Attached is a very basic example of how to set it up. If your report has no parameters or you dont want to pass anything to them, then ignore/delete the section with them   For a lot of steps, they have to be initialised by feeding them a stream of data so in this example I am feeding the report output ...

RE: run report designer in PDI

Posted By Dean Flinter 08-23-2019 14:47
Found In Community: Pentaho \ view thread
Yes there is the Pentaho Reporting Output step   You create the report in PRD, then in PDI you pass the report location and output location to the step. Then select the output format   If the report contains parameters you can pass those also

RE: Convert table input result to verbose output to use in mail body

Posted By Dean Flinter 07-25-2019 09:53
Found In Community: Pentaho \ view thread
There are 2 ways of doing this that I am familiar with The first is to export the result as an XML file and then use an XSL transformation to output it to a html file. You then need to process the HTML file by grouping it into a single line and setting the result to a variable. You can then reference ...

RE: PDI performance degradation

Posted By Dean Flinter 06-25-2019 08:50
Found In Community: Pentaho \ view thread
Unfortunately I cant help specifically but going from 5.4 to 8.0 would also require a change in Java version (version 7 I believe?) If there was no specific change to PDI that causes this for you, perhaps it is an issue with Java itself

RE: REST API Put requests always return 403

Posted By Dean Flinter 05-01-2019 13:26
Found In Community: Pentaho \ view thread
Error 403 suggests that the request is properly formed and credentials are correct but that this user does not have the appropriate permissions I know you said it is for an admin account but perhaps double check the permissions

RE: Unable to use CSV Input with file on a UNC (network path)

Posted By Dean Flinter 05-01-2019 13:21
Found In Community: Pentaho \ view thread
From reading your error I think the issue is that you need 2 back slashes before the server So \DevServer\Dev\test.csv should be \\DevServer\Dev\test.csv

RE: PDI pentaho reporting output parameter issue

Posted By Dean Flinter 09-25-2018 13:45
Found In Community: Pentaho \ view thread
I would also turn off validate values in the PRD, just in case