Search found 113 matches

by bartonv
Wed Mar 20, 2019 10:15 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Question regarding Normalizer
Replies: 4
Views: 26

Re: Question regarding Normalizer

Hi Andras,
thank you for the elaborated example. We really appreaciate your contribution to this topic, especially because of the complexity of using RollUp.
Best regards,
Vladi
by bartonv
Tue Mar 19, 2019 12:46 pm
Forum: CloverDX Server
Topic: Missing CloverETL Server Project option in Eclipse
Replies: 1
Views: 11

Re: Missing CloverETL Server Project option in Eclipse

Hello, as a quick remedy, I would suggest a complete reinstallation of the Designer by following these detailed steps: ⋅ If there are existing projects in your current workspace, please back up all its directories by copying the whole content to a new previously unused directory. ⋅&nb...
by bartonv
Tue Mar 19, 2019 10:53 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Question regarding Normalizer
Replies: 4
Views: 26

Re: Question regarding Normalizer

Hi Peter, I have attached a sample solution to your data challenge. Worth noting are these component settings: ⋅ FlatFileReader: Trim Strings = true (to remove redundant space characters); ⋅ 'input' metadata: when extracting metadata, Extract Names = true (to get the actual metad...
by bartonv
Tue Mar 19, 2019 9:54 am
Forum: CloverDX Server
Topic: Prevent "ERROR : Worker is unavailable too long. The worker will be restarted." When worker heap memory hits max?
Replies: 2
Views: 17

Re: Prevent "ERROR : Worker is unavailable too long. The worker will be restarted." When worker heap memory hits max?

Hello, there are a couple of different approaches that you can take to prevent this issue from happening. As you rightly said, revising the configuration of the FastSort component is one of these options that goes right to the bottom of the problem. However, the configuration is quite complex in ter...
by bartonv
Tue Mar 12, 2019 4:05 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Question regarding a transformation
Replies: 2
Views: 28

Re: Question regarding a transformation

Hello Evangeloslef, I might be missing some crucial parts of your use case but from what you described, it seems there might be an easier way of how to approach this challenge. I am also a little bit on the fence as to how exactly the input data looks like. Therefore, I took the liberty of manufactu...
by bartonv
Wed Mar 06, 2019 2:28 pm
Forum: CloverDX Data Profiler
Topic: How to count the number of files found by the ListFile component.
Replies: 2
Views: 37

Re: How to count the number of files found by the ListFile component.

Hello Davis, from looking at your screenshots, it appears that CloverDX Designer, in fact, works as expected in this particular case. The reason why the EmailSender component does not send out an email is that no input records flows into it. Then, the reason why no input records flow into EmailSende...
by bartonv
Wed Feb 27, 2019 3:59 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Set Jobflow Execution Label
Replies: 1
Views: 41

Re: Set Jobflow Execution Label

Hi Jon Liang,
you can set the execution label on the parent jobflow in the CloverDX Designer by navigating to the 'Properties' tab (next to the 'Console' tab below the graph visualization) and populating the 'Execution label' property.
Kind regards,
by bartonv
Wed Feb 27, 2019 12:47 pm
Forum: CloverDX for Java Programmers
Topic: Custom autofilling fields for metadata
Replies: 1
Views: 56

Re: Custom autofilling fields for metadata

Hello Rifttech, unfortunately, there is no easy way to create additional custom autofilling fields (either in the Designer or Engine). Having said that, the answer to your second question is, I am afraid, that the sheet_id cannot be obtained as well because it is not part of the existing list of aut...
by bartonv
Fri Feb 22, 2019 4:14 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Reader and Writer component for Cassandra
Replies: 3
Views: 1919

Re: Reader and Writer component for Cassandra

Hello, there are 3 options of how to connect to Cassandra from CloverDX: ⋅ Using a dedicated JDBC driver ⋅ Using the Datastax Java library ⋅ By calling a script The first option is not recommended as it appears that no one is actively maintaining or supporting JDBC conn...
by bartonv
Fri Feb 08, 2019 3:42 pm
Forum: CloverDX for Java Programmers
Topic: JsonExtract could not read second record of root array
Replies: 2
Views: 94

Re: JsonExtract could not read second record of root array

Hello, in order to extract both fields from the array, try using this mapping: <Mappings> <Mapping element="json_array"> <Mapping element="json_array" outPort="0" xmlFields="{}id;{}name" cloverFields="id;name"> </Mapping> </Mapping> </Mappings> Attac...
by bartonv
Fri Feb 08, 2019 3:14 pm
Forum: CloverDX for Java Programmers
Topic: CloverETL Engine, graph edges
Replies: 4
Views: 243

Re: CloverETL Engine, graph edges

Hi Rifttech, I am a little bit on the fence as to what exactly you are looking for. Typically, when it comes to debugging data within the CloverDX framework, the data can be either viewed directly in the Designer or as Eva mentioned previously, the edge debug data can be pulled from the debug files....
by bartonv
Fri Feb 08, 2019 1:10 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Partition data
Replies: 1
Views: 58

Re: Partition data

Hi Mohamad, yes, there are a couple of different options on how to separate data into different outputs. Choosing the right one depends on some of the specific use case details, namely, whether there is a known number of the possible column values and then, also the number itself. In other words, if...
by bartonv
Fri Feb 08, 2019 11:46 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Pull Underlined Text With Spreadsheet Reader
Replies: 6
Views: 136

Re: Pull Underlined Text With Spreadsheet Reader

Hi Hesske, unfortunately, there is nothing else in CloverDX we can offer to handle this specific use case. Nevertheless, I have done some further research and found this interesting article about how to identify bold cells in Excel directly. I tried the third option (using VBA) which is pretty strai...
by bartonv
Fri Feb 08, 2019 10:36 am
Forum: CloverDX for Java Programmers
Topic: XMLExtract - copying parent fields to child when parent fields are present after child element
Replies: 1
Views: 66

Re: XMLExtract - copying parent fields to child when parent fields are present after child element

Hello, as you rightly indicated, using the XMLExtract in this use case is not an ideal solution due to the way SAX parsing of XML files works. I have attached an example graph and 2 input files to demonstrate the following: ⋅ phase 0 - using XMLExtract to push the 'D001' value into the 'de...
by bartonv
Wed Feb 06, 2019 11:53 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Pull Underlined Text With Spreadsheet Reader
Replies: 6
Views: 136

Re: Pull Underlined Text With Spreadsheet Reader

Hi Hesske, I am afraid there is no native function that would be able to extract this type of Excel string format within CloverDX. However, there might be a different approach that we could take to parse this Excel file of yours. Would you mind providing us with a snippet of it? If it contains sensi...

cron