Profile

Gert Wieland

Contact Details

My Content

1 to 20 of 45 total
Posted By Gert Wieland 01-21-2022 10:21
Found In Egroup: General Discussion
\ view thread
Which Hitachi Vantara software resources do you use to continuously improve your knowledge and skills? ------------------------------ Gert Wieland ------------------------------
Posted By Gert Wieland 11-09-2021 09:22
Found In Egroup: General Discussion
\ view thread
Which resources do you use to find solutions to specific challenges? Best,  Gert ------------------------------ Gert Wieland ------------------------------
Posted By Gert Wieland 07-04-2021 22:01
Found In Community: Pentaho
\ view thread
I gave up since then and moved to another provider (mailbox.org), and I never looked back. (Im not MS-bashing here, I just felt that for my personal purposes, an O365 mailbox wouldnt work for me.)
Posted By Gert Wieland 01-04-2021 04:37
Found In Community: Pentaho
\ view thread
I sorted it out, so if somebodys interested, please find attached the transformation and the sample data source in Excel.    Maybe somebody finds this helpful.
Posted By Gert Wieland 12-30-2020 07:37
Found In Community: Pentaho
\ view thread
I have an issue that I think is probably easy to solve in PDI, but although I tried for a couple of hours now, Ive not been able to sort it out.   Heres a simplified summary: I have a table with millions of records (journal entries from an accounting software). Each record has a financial cost centre ...
Posted By Gert Wieland 08-14-2020 15:58
Found In Community: Pentaho
\ view thread
Hi Xin, Thanks so much! Right now, I dont have karaf chache I could work with (sigh... ;) ), but Im in the midst of reinstalling everything. Ill report back here how things go.   Thanks again for your thoughtful feedback, I already learned a huge lot from you!
Posted By Gert Wieland 08-14-2020 15:22
Found In Community: Pentaho
\ view thread
Hi Xin, thank yo u very much for your detailed instructions. Ill install it right now, and Ill report back later. You just opened another door, I really appreciate your help.
Posted By Gert Wieland 08-14-2020 12:49
Found In Community: Pentaho
\ view thread
Hi Xin, Thank you very much for your reply. I made a mistake on my server and literally killed it, so I need to set it up from scratch now. I have a backup of my repository, and no important data was on it, so while annoying, its not a disaster.   I think Im fairly experienced with using PDI - but frankly, ...
Posted By Gert Wieland 08-11-2020 21:50
Found In Community: Pentaho
\ view thread
Hi community,   Im getting an error when trying to run a job via command line. Not sure what happened, it worked before, and it still works for transformations.   So heres the part of the log where the error occurs 2020-08-11 17:32:36.869:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory ...
Posted By Gert Wieland 08-06-2020 18:09
Found In Community: Pentaho
\ view thread
Hi community,   I try to connect the Email messages input step to my Office365 account, but authentication keeps failing (but sending emails works).   My settings are: Source host: outlook.office365.com Use SSL: Yes Port: 993 Username: my.email@domain.com (I use my own custom domain) Password: I set ...
Posted By Gert Wieland 08-05-2020 18:20
Found In Community: Pentaho
\ view thread
Thanks Marvin, and my apologies for only getting back to you today! You were right, my problem was with the repositories.xml file. I wasnt sure how to fix it, but I just transferred and edited the one that was automatically created on the server where I first created the transformations and jobs. Et ...
Posted By Gert Wieland 08-05-2020 18:14
Found In Community: Pentaho
\ view thread
Ive seen this error when using a java script step to modify an existing value, like   Counter = Counter + 5   Then, in the lower part of the step, you select the variable, but forget to set the Replace parameter to yes. In this case, the Counter variable wont change, and the new value will be stored ...
Posted By Gert Wieland 08-05-2020 18:02
Found In Community: Pentaho
\ view thread
Am I understanding it correctly and you get this error when trying to set up the connection to the database? My first hunch would be that you might be using the wrong jdbc driver (because it states syntax of connection URL is invalid, but as users, we dont have control over that syntax).   Are you sure ...
Posted By Gert Wieland 06-21-2020 02:17
Found In Community: Pentaho
\ view thread
I set up a Ubuntu Server (18.04 LTS) and I managed to get the Pentaho Server (CE 9) up and running.   I also installed a LAMP stack. From my developer machine, I configured a MySQL Repository, and I can connect from my local Spoon. So far so good.   I created a very simple job, and I tried to run it ...
Posted By Gert Wieland 04-12-2020 17:14
Found In Community: Pentaho
\ view thread
My biggest problem was that I got confused between Parameters and Variables. Im still not sure if I understood it 100 percent, but I got it to work, and it works very well. Below screenshot shows the steps.   In a nutshell: 1) You need a transformation that creates the list through which you want to ...
Posted By Gert Wieland 04-08-2020 21:07
Found In Community: Pentaho
\ view thread
I guess Im about to figure it out... It will require a job executor to execute a job once for each line of a list that feeds into it. And it needs a data grid to configure the variables inside the transformation thats being run by the executor.   Will post a final solution here once I get there.
Posted By Gert Wieland 04-08-2020 18:39
Found In Community: Pentaho
\ view thread
Hi Community,   I have a very urgent need at work. Usually Id spend more time trying to figure it out, but right now Id really appreciate some urgent help.   My scenario is fairly simple (I believe).   I have an Excel file with hundreds of lines. One or more lines belong to one person. I can also create ...
Posted By Gert Wieland 09-17-2019 21:13
Found In Community: Pentaho
\ view thread
Last update, just in case someone comes across this post. I switched to a local MariaDB repository (WampServer), and so far, this seems to run just fine. Probably it wasnt such a good idea to use a cloud database (Azure) as a repository.
Posted By Gert Wieland 09-17-2019 19:08
Found In Community: Pentaho
\ view thread
Unfortunately, Im still getting the same errors :( Ill try switching to a local database (i. e. local on the VM). (By the way, Im running CE 8.3)   But nonetheless, thanks again for your time and the input!
Posted By Gert Wieland 09-17-2019 18:53
Found In Community: Pentaho
\ view thread
Hi David,   Thank you very much, thats great information. Im running a Windows VM on Azure, and I just made the registry changes. Ill post an update later once I worked for a while.   But Id say this is a very promising approach :)   Much appreciated,   Gert