Re: Load files in a BLOB field of a database

2023-11-08 Thread hans . van . akelyen
Hi Chris, The only thing that function does is create a new byte[size]. You should be able to replace it by Var content = new byte[file.length()] Cheers, Hans On 8 Nov 2023 at 15:24 +0100, ch...@radical-airlines.com, wrote: > Hello ! > > Once upon a time in the old PDI archive we had a sample KT

Load files in a BLOB field of a database

2023-11-08 Thread chris
Hello ! Once upon a time in the old PDI archive we had a sample KTR showing how to load some files in a BLOB field of a DB (General - Load images and stores into database table.ktr). It's not really up to date, however I'm backporting some old transforms to HOP and would like - as a first ste

Re: How to create an array of String in Apache Hop

2023-11-08 Thread hans . van . akelyen
Hi Michel, I think you can have the desired result by using the “JSON Fragment” option in the Enhanced JSON Output Transform. See following sample:  https://drive.google.com/file/d/1qlJOCUE29eqZ73JHRzSVTT4FIwWKodIR/view?usp=sharing Cheers, Hans On 8 Nov 2023 at 13:04 +0100, M , wrote: > > "myS

Re: How to create an array of String in Apache Hop

2023-11-08 Thread Bart Maertens
Hi Michel, This looks like ticket 3287 [1], which unfortunately is still open. Can you let us know if this is what you are looking for? Feel free to comment on this ticket if your use case is similar but slightly different. [1] https://github.com/apache/hop/issues/3287 Regards, Bart On Wed, No

How to create an array of String in Apache Hop

2023-11-08 Thread MHeyd
Hello Apache users, We have been trying to create an array of strings but without success, in the example below the property "myStringArray" is from type array of string [ { "myJson": [ { "name": "a property", "my