Search found 127 matches

by bartonv
Tue Mar 19, 2019 12:46 pm
Forum: CloverDX Server
Topic: Missing CloverETL Server Project option in Eclipse
Replies: 1
Views: 494

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: 5
Views: 665

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: 429

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: 477

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: 778

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: 383

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: 718

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: 2826

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: 548

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: 981

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: 388

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: 932

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: 445

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: 932

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...
by bartonv
Wed Feb 06, 2019 11:46 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Pull Underlined Text With Spreadsheet Reader
Replies: 6
Views: 932

Re: Pull Underlined Text With Spreadsheet Reader

Thank you, Andras, for the reply. We appreciate your input!
Best regards,