PDI | PHP Dependency Injector , A DI Container | Continuous Deployment library
kandi X-RAY | PDI Summary
kandi X-RAY | PDI Summary
PHP Dependency Injector, A DI Container for PHP. I know, there's Pimple and so many other great DI Containers already, why this one. PDI isn't just a DI Container. It is a COMPLETE Dpendency Injection Container. With PDI, you can completely abstract your program logic from their dependencies. Yes, completely means you don't have to include these dependencies in an array or some file. It means, you just use them without worrying about where they come from or how they serve you.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of PDI
PDI Key Features
PDI Examples and Code Snippets
Community Discussions
Trending Discussions on PDI
QUESTION
I have this JSON response that I get by using GuzzleHttp, this is my controller
...ANSWER
Answered 2022-Mar-19 at 04:12you have returned $news; before returning view.Also you are accessing object but returned array.Here is the complete code
QUESTION
Objective: Set up a connection with PostgreSQL db in PDI. I'm a noob in all this stuff, so each step forward requires long resolution time.
I'm trying to set up the connection to a PostgreSQL database in order to prepare some queries for an ETL process in PDI. But there's no way to succeed with the connection.
I've tried with PostgreSQL connection type and with Generic database connection type and the error is always related with the drivers.
The version of the PostgreSQL db I'm trying to connect is 9.5.25 and I'm working in Ubuntu 20.04 and Java 8 as demands Pentaho Data Integration.
Below the error message after failed connection:
"Connection failed. Verify all connection parameters and confirm that the appropriate driver is installed. Connection to [IP]:[Port] refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections."
I am literally in despair, don't know what I'm doing wrong. Will be very grateful with anyone who can help me.
...ANSWER
Answered 2022-Mar-18 at 11:12You need to add the jdbc driver to connect to postgresql DB in the pdi-installation/lib directory, you just put the *.jar file there and restart spoon to have the library available.
That driver can be downloaded from postgresql downloads. The Community Edition of PDI only comes with a small number of jdbc drivers, for each type of database you need to connect to, you should check if the jdbc driver is available in that directory, and if it's up to date or if you need a more recent version of the driver.
This is a link for the official Pentaho documentation, looking for information in Hitachi Vantara documentation is becoming more and more difficult, they don't always clarify what steps apply only for the Enterprise Edition and are not available for the Community Edition: https://help.hitachivantara.com/Documentation/Pentaho/9.2/Setup/JDBC_Drivers_Reference
QUESTION
I would like to execute the following curl from a transformation using the Execute a process step:
...ANSWER
Answered 2022-Jan-24 at 06:34Everything was decided like this:
QUESTION
I want to build an XML file from a CSV file.
The CSV file has a structure of this kind for each row:
...ANSWER
Answered 2022-Jan-21 at 14:20I got it; I used a Add Column XML step, created the , called for example UT1, then the next step of the PDI is the construction of , where I added as a field UT1, as String. In the next step I used Replace in String and substituted < with <, > with >.
PDI steps:
Step Add Column XML BigTag1:
Char substitution:
QUESTION
I am now need to convert the Google Sheet page to PDF, email to user and save the PDF format straightway to Google Drive.
And i need the Google Drive link after save it to Google Drive.
The steps from convert the Google Sheet to PDF, and i've done but I've stuck at getting the URL to be paste on the specific cells.
i know to get the URL using this code Logger.log(fileUrl)
But how to paste on cell the command ?
ANSWER
Answered 2022-Jan-11 at 09:40I believe your goal is as follows.
- You want to search the file of filename
subjectretrieved from the cell "B3" of "Source Email-Boom" sheet from your Google Drive, and when the value ofsubjectis found from the column "AI" of "BL-Inspection Report" sheet, you want to put the URL of the file to the column "AJ". - For my question of
For example, you want to put the URL of the just created file?, fromYesof your replying, I understood that you wanted to put the URL of the just created file in this script.
In this case, how about the following modification? I thought that in this case, the file URL of the just created file can be directly retrieved from DriveApp.getFolderById(folderID).createFile(response).setName(nameFile). So, how about the following modification?
QUESTION
I am using a trigger for each row come in, it will convert to pdf from excel and send the email straightaway.
In PDF that I need to convert, there's include photo. In order to convert, the time from trigger and convert photo must be like 1 sec or half so the photo turn up half, I believe it not finished converting.
So, I need the script that can pause from running like 3 seconds and continue the script afterward so that the photo are completely load.
...ANSWER
Answered 2021-Dec-29 at 03:27As Cooper pointed out, try Utilities.sleep()
The parameter is stated in milliseconds, so for a 3-second delay, you can add this to your script where the pause is desired:
QUESTION
I encountered a mysterious error in Pentaho Data Integration (PDI, a.k.a. Kettle) log displayed via Jenkins:
org.codehaus.janino.CompileException: SNO: "+=" reconversion failed
The only code that contains "+=" is like this...
...ANSWER
Answered 2021-Dec-14 at 16:01As strange as it may sound for java, the solution was to simply replace...
QUESTION
I have two tables - one is Product and the other is Productimage. In product image table, more than one image can exist of every product. Every image set ISDEAULT 1 or 0. Now I want every product from product table whose all image's ISDEAULT is 0.
I wrote this query
...ANSWER
Answered 2021-Nov-18 at 07:39You can use conditional aggregation to check for IsDefault = 1
This means you are only querying the ProductImage table once
QUESTION
When I try to edit my database connections, I get the "General Error in Dialog" message. Upon clicking details, I get the following:
java.lang.NullPointerException at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:113) at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:61) at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:96) at org.pentaho.di.ui.spoon.Spoon.editConnection(Spoon.java:2725) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141) at org.pentaho.ui.xul.jface.tags.JfaceMenuitem.access$100(JfaceMenuitem.java:43) at org.pentaho.ui.xul.jface.tags.JfaceMenuitem$1.run(JfaceMenuitem.java:106) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89) at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4385) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1512) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1535) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1520) at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1324) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4172) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3789) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1385) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7968) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9350) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:711) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
I'm using Java version 8 update 261. I know that PDI requires Java 8 so I don't understand why I'm having this issue. Currently, I have to delete and then create a new database connection for each job, which is really tedious.
How do I resolve this issue? Or is there another way to set my database connections so that I don't have to create a new one for each job?
...ANSWER
Answered 2021-Nov-12 at 10:22I don't know about your error message, but to share connections IN YOUR PC you have the option in the View tab:
I have an empty transformation, so all the DB connections shown are the shared ones, if I had a new connection in the transformation it would be also shown but the connection name wouldn't be in bold letters.
Beware, the shared connections information are only available in your PC, and the connection information is copied to the transformation or job, so if you change the information in your shared connection, you need to reopen all the transformations and jobs that use it and save them with the new information.
In the .kettle folder in your user folder there's a shared.xml file with the shared connections information.
QUESTION
I have a String in Pentaho Data Integration (PDI) a.k.a. Kettle, in a transformation's UDJC step. So using Java, I need to take that String which contains JSON from MongoDB, and put it into a BasicBSONObject. (I can use import statements but I can't install things as part of a solution.)
I got the String into an org.bson.Document so it seems like the hard part's over, but I still can't figure out how to convert one type of bson to another here, resulting in an object of type org.bson.BasicBSONObject
This errors out on the last line:
...ANSWER
Answered 2021-Oct-05 at 12:50There is a BasicDBObject#parse method in MongoDB Java Driver library, which is most probably present on the classpath of your application. This method, according to the documentation, parses a string in MongoDB Extended JSON format to a BasicDBObject.
You can use it directly and skip the Document parsing step.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install PDI
PHP requires the Visual C runtime (CRT). The Microsoft Visual C++ Redistributable for Visual Studio 2019 is suitable for all these PHP versions, see visualstudio.microsoft.com. You MUST download the x86 CRT for PHP x86 builds and the x64 CRT for PHP x64 builds. The CRT installer supports the /quiet and /norestart command-line switches, so you can also script it.
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page
