CloverETL is now CloverDX - Learn Why

Search found 87 matches

by bartonv
Fri Apr 27, 2018 2:59 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: ListFiles doubling explanation required.
Replies: 1
Views: 422

Re: ListFiles doubling explanation required.

Hi GavC, a simple change that would resolve the issue that you encountered is to remove the edge between the ExecuteScript component (called "Unzip") and the second ListFiles component and push the second ListFiles component to a later phase (for example, phase #1). The ListFiles component...
by bartonv
Wed Apr 18, 2018 10:03 am
Forum: CloverDX (formerly CloverETL) Support
Topic: EmailReader
Replies: 3
Views: 689

Re: EmailReader

Hi Adrian, I was trying to replicate the behavior of the EmailReader component with JRE 1.8 that you reported but I never ended up in an infinite loop during the testing. This leads me to believe that the core issue might be related to your specific setup. In order to pinpoint the problem, please ge...
by bartonv
Thu Apr 12, 2018 9:53 am
Forum: CloverDX Server
Topic: No CPU load
Replies: 3
Views: 882

Re: No CPU load

Hello Hewills, thank you for the heads up. After a closer look at this topic, it appears that the issues you were experiencing were most likely caused by this bug in the 4.5 version of CloverETL Server UI. The fact that you no longer have this issue in the 4.8 version coincides with the fact that th...
by bartonv
Wed Apr 11, 2018 8:02 am
Forum: CloverDX (formerly CloverETL) Support
Topic: MongoDBReader formatting issues
Replies: 1
Views: 409

Re: MongoDBReader formatting issues

Hi Shubha, unfortunately, extracting nested elements as json objects (map[string,string]) is currently not supported in CloverETL. We do plan to incorporate such feature in the future but due to its complexity and resource demandingness, it has not been developed yet. However, there are a couple of ...
by bartonv
Thu Apr 05, 2018 2:42 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Creating unique hash
Replies: 2
Views: 537

Re: Creating unique hash

Hello Shubha, it appears that your question has already been answered. Nevertheless, let me mention another option for the sake of approach diversity. If you did not insist on using a hash function, you could take advantage of the persistent sequence functionality in Clover. A persistent sequence ge...
by bartonv
Tue Mar 13, 2018 3:07 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Looking for a better error output
Replies: 4
Views: 673

Re: Looking for a better error output

Hello Jcatoe, there are a couple of different options that you can choose in this situation. However, they can be summed up in these 2 general approaches basically: ⋅ Converting the XLS(X) file into a CSV file and then reading the CSV file using the FlatFileReader component (as demonstrate...
by bartonv
Tue Mar 13, 2018 1:45 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to read XLSB
Replies: 3
Views: 664

Re: How to read XLSB

Hi Apostolos, feel free to review the attachment (an older version of the same sample graph) which should be compatible with older versions of CloverETL Designer. Another option would be to simply replace the FlatFileReader component with its predecesor - UniversalDataReader. Finally, a recommended ...
by bartonv
Wed Mar 07, 2018 2:41 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to read XLSB
Replies: 3
Views: 664

Re: How to read XLSB

Hello Aposkala2, unfortunately, reading XLSB files is not supported in CloverETL Designer. However, there are a couple of workaround solutions how to handle this situation. Attached is an example graph which demonstrates one of the possible options that involves converting the XLSB file to a CSV fil...
by bartonv
Mon Mar 05, 2018 4:16 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Str2Date problem
Replies: 2
Views: 645

Re: Str2Date problem

Hello Mike, I have tried to manufacture a situation when I would get the same error message but I did not manage to do that. In my case, the code in the Reformat component works as expected and no error is thrown by the system. I am attaching a graph showing my data transformation along with a demon...
by bartonv
Mon Mar 05, 2018 3:19 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Delimited FlatFile reader - Question from New User
Replies: 4
Views: 4086

Re: Delimited FlatFile reader - Question from New User

Hi Mukunku, I have noticed your post concerning this topic and it appears that this thread is more than 10 years old. The good news is that Clover has evolved since then and the functionality that handles RFC 4180 compliant CSV files is now there. Feel free to review the attached example graph as a ...
by bartonv
Mon Mar 05, 2018 2:02 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: ExecuteGraph giving errors when trying to move from CloverETL Server version 4.1 to 4.7
Replies: 5
Views: 1048

Re: ExecuteGraph giving errors when trying to move from CloverETL Server version 4.1 to 4.7

Hi Sid, I would like to follow up on this post to see if we could take a closer look at the answers to the aforementioned questions. Furthermore, I was wondering if you could perform a simple test of running your job in Clover version 4.8.x. There was a known bug discovered in version 4.7.x that dem...
by bartonv
Mon Mar 05, 2018 1:26 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Denormlizer Help For New User
Replies: 1
Views: 487

Re: Denormlizer Help For New User

Hello Jcatoe, as you rightly indicated, such transformation would require a bit more complex CTL coding. However, the component that would ‘do the trick’ is called Normalizer as the input data shown in your post is, in fact, denormalized. Attached is an example graph demonstrating the usage of the N...
by bartonv
Fri Mar 02, 2018 4:05 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: ExecuteGraph giving errors when trying to move from CloverETL Server version 4.1 to 4.7
Replies: 5
Views: 1048

Re: ExecuteGraph giving errors when trying to move from CloverETL Server version 4.1 to 4.7

Hi Sid, I agree with the_goat that it does look like a mapping issue so a general advice I could provide is to look for a solution by inspecting the ExecuteGraph component in terms of input, output and/or error mapping. However, if you would like to have us inspect it on our end, please provide us w...
by bartonv
Fri Mar 02, 2018 2:47 pm
Forum: CloverDX Server
Topic: No CPU load
Replies: 3
Views: 882

Re: No CPU load

Hi Hewills, as you rightly anticipated, the answer to your question would be rather extent in its scope. First of all, let me clarify that there is no simple direct or indirect proportion between CPU and memory usage. In other words, you cannot substitute the usage of memory by the usage of CPU as b...
by bartonv
Fri Feb 23, 2018 9:43 am
Forum: CloverDX (formerly CloverETL) Support
Topic: EmailSender ignore send fail
Replies: 3
Views: 753

Re: EmailSender ignore send fail

Hello Hewills, as you rightly said, the ‘Ignore send fail’ property only applies to certain types of failures. The designed logic of this property in the code is applied only after a successful connection to the SMTP server is established. Therefore, if the connection is not established successfully...

cron