Search found 27 matches

by jandikovae
Thu Sep 07, 2017 8:38 am
Forum: CloverETL Support
Topic: Split string into new lines
Replies: 2
Views: 165

Re: Split string into new lines

Hi, In case you don't insist on splitting the text into an array, you can simply replace the comma with a "\r\n" or any other line separator suitable for your operating system (e.g. \r\n for Windows, \r MacOS or \n for Linux). In a Reformat component it would then look as follows : $out.0....
by jandikovae
Wed Sep 06, 2017 12:33 pm
Forum: CloverETL for Java Programmers
Topic: Custom CTL Development
Replies: 2
Views: 267

Re: Custom CTL Development

Hi,
A new article has been published today regarding the Custom CTL functions. Please review the following link:

http://blog.cloveretl.com/extending-ctl-with-java-functions

Best Regards, Eva
by jandikovae
Mon Sep 04, 2017 1:03 pm
Forum: CloverETL Server
Topic: How to turn off direct memory
Replies: 1
Views: 284

Re: How to turn off direct memory

Hi, I can confirm that you have done everything correctly. As long as you can see USE_DIRECT_MEMORY set to "false" in the Configuration -> CloverETL Info -> Engine Properties section, the Direct Memory is disabled for CloverETL Server. The "Direct Memory" attribute in the Monitor...
by jandikovae
Tue Aug 22, 2017 7:48 am
Forum: CloverETL Support
Topic: How do you export a CloverETL project as jar file?
Replies: 1
Views: 197

Re: How do you export a CloverETL project as jar file?

Hi, Although I am not sure that I fully understand your questions, I am afraid that it is not possible to convert a CloverETL project to a JAR file. You can run each part of the project (e.g. graph or jobflow) separately within the CloverETL Designer or you can convert it to a Server project and run...
by jandikovae
Wed Aug 09, 2017 12:55 pm
Forum: CloverETL for Java Programmers
Topic: Athena API access
Replies: 1
Views: 264

Re: Athena API access

Hi Rajesh, Although I am not familiar with Athena API requirements, I believe that you can use a component called HTTPConnector. It can send HTTP requests to a web APIs and receive responses. For more information about this component, please see the documentation: http://doc.cloveretl.com/documentat...
by jandikovae
Thu Aug 03, 2017 8:39 am
Forum: CloverETL for Java Programmers
Topic: Custom CTL Development
Replies: 2
Views: 267

Re: Custom CTL Development

Hi, Please accept my apologies for the delayed response. As the article is from January 2014, I wanted to review first if it is still up to date. Let me start with answers to your questions: 1. Yes, it is necessary to keep the projects separate. As you can see in the detailed description, one of the...
by jandikovae
Wed Jul 12, 2017 12:03 pm
Forum: CloverETL Support
Topic: How to read delimited files with header and footer
Replies: 1
Views: 130

Re: How to read delimited files with header and footer

Hi, Yes, you are right. For data like this, we would usually recommend ComplexDataReader. However setting up this component might sometimes be a little tricky and whether this is the best solution depends on the exact structure of your data. For example: 1. Is there always just one header, some numb...
by jandikovae
Fri Jun 02, 2017 10:16 am
Forum: CloverETL Support
Topic: Display Graph Parameters in Event Listener Email
Replies: 1
Views: 256

Re: Display Graph Parameters in Event Listener Email

Hi, I suppose that you are referring to Send an email and Placeholders chapters in the documentation that seem incomplete to you. And you are right, passing the graph parameters is not literally mentioned there and it is definitely a good idea to improve that. If you want to display a graph paramete...
by jandikovae
Thu Jun 01, 2017 12:40 pm
Forum: CloverETL Support
Topic: XMLExtract Issue
Replies: 4
Views: 377

Re: XMLExtract Issue

This question has been answered in a support ticket. Resolution: If an XMLExtract or JSONExtract component receives a file with a specific type of syntax error, it might happen that the component fails (as expected) but the XML/JSON files are not unlocked properly for further transactions. This issu...
by jandikovae
Mon May 29, 2017 7:31 am
Forum: CloverETL Support
Topic: XMLExtract Issue
Replies: 4
Views: 377

Re: XMLExtract Issue

Hi Ricardo,
We are currently working on this issue in a support ticket with your colleague Madeline. We will update you with our findings then.
Thanks Eva
by jandikovae
Fri May 19, 2017 7:23 am
Forum: CloverETL Support
Topic: Workspace and subdirectories
Replies: 1
Views: 210

Re: Workspace and subdirectories

Hi, Unfortunately, this behavior is not supported by Eclipse. You can create subfolders, however, the structure won't be visible in the Navigator pane. If the projects are completely independent, I would suggest you organize them by workspace. You can then switch between workspaces (File -> Switch W...
by jandikovae
Wed May 10, 2017 8:04 am
Forum: CloverETL Support
Topic: Parameter on UniversalDataWriter stopped working
Replies: 2
Views: 274

Re: Parameter on UniversalDataWriter stopped working

Hi, Thank you for your question. The reason why this solution doesn‘t work anymore is that since version 4.5.0 CloverETL doesn't support old CTL1 code anymore. In CTL2 you can actually achieve the same thing using a dynamic parameter. In order to do that, please edit your parameter TODAY and instead...
by jandikovae
Tue Apr 25, 2017 7:39 am
Forum: CloverETL Server
Topic: Setting number of executors to a jobflow
Replies: 5
Views: 426

Re: Setting number of executors to a jobflow

Hi, You are right, this is definitely one of the options. This way you can use the "Number of Executors" to control a number of simultaneously running instances of the child graph. However, similarly to the "Number of Executors", you can also setup maximum number of running insta...
by jandikovae
Fri Apr 21, 2017 10:52 am
Forum: CloverETL Support
Topic: If Statement in Reformat Component
Replies: 1
Views: 210

Re: If Statement in Reformat Component

Hi, In the CloverETL tool, the only thing you should keep in mind is the way how you refer to the variables in all transformations. I mean, you should define what input/output port and field name you are referring to. Your code in Reformat component would then look as follows: function integer trans...
by jandikovae
Fri Apr 21, 2017 9:49 am
Forum: CloverETL Server
Topic: Setting number of executors to a jobflow
Replies: 5
Views: 426

Re: Setting number of executors to a jobflow

Hi, Actually, the "Number of Executors" attribute is applied to a situation when a single ExecuteGraph component executes one child graph multiple times. For example, you can have a ListFiles component at the beginning and the ExecuteGraph then starts a child graph for each file (for each ...