Search found 17 matches

by bartonv
Tue Aug 15, 2017 11:49 am
Forum: CloverETL Support
Topic: How can you include form-data in an HTTPConnetor PATCH request
Replies: 1
Views: 45

Re: How can you include form-data in an HTTPConnetor PATCH request

From reviewing the curl request, I presume that you intend to update a certain data resource with the duns.txt content while the Content-Disposition header is expected to be form-data. Is that correct? If so, this can be achieved with the following HTTPConnector setup: ⋅ URL: https://plus....
by bartonv
Mon Aug 14, 2017 3:13 pm
Forum: CloverETL Support
Topic: Generate JSON file from CCD
Replies: 3
Views: 79

Re: Generate JSON file from CCD

Hi Rajesh, there is indeed an easier way in case you simply need to transform the XML code to JSON as is. It can be achieved by performing the following steps: ⋅ Use the XMLExtract component to read the entire CCD file content into a single field. ⋅ Push this field through a Refo...
by bartonv
Fri Aug 04, 2017 2:21 pm
Forum: CloverETL Support
Topic: Generate JSON file from CCD
Replies: 3
Views: 79

Re: Generate JSON file from CCD

Hi Rajesh, let me break this down into 2 separate issues: reading the CCD file and writing into a JSON file: 1. I understood that the CCD file is basically a file containing some XML code. We have 3 different components that can read XML code: XMLExtract, XMLReader and XMLPathReader. Since you are n...
by bartonv
Fri Jul 28, 2017 3:02 pm
Forum: CloverETL Support
Topic: Left Join with like
Replies: 4
Views: 126

Re: Left Join with like

Hi filipebevi, the answer to your first question depends on the fact whether you would need to calculate subtotals. In other words, if there was the level 1, level 11 and a new level 111, the question would be whether you intend to calculate a subtotal amount for the level 11 as well. If the answer ...
by bartonv
Fri Jul 21, 2017 7:59 am
Forum: CloverETL for Java Programmers
Topic: How to parse large XML file using custom XMLExtract in Java and store it in database
Replies: 3
Views: 137

Re: How to parse large XML file using custom XMLExtract in Java and store it in database

Hello Sai, thank you for the detailed explanation. I understand why you don’t want to use Clover GUI for your projects. However, running the jars outside of the GUI by copying them and running them elsewhere is not what they have been designed for. In fact, such manipulation is in contradiction with...
by bartonv
Fri Jul 21, 2017 7:45 am
Forum: CloverETL Support
Topic: Left Join with like
Replies: 4
Views: 126

Re: Left Join with like

Hello filipebevi, from your sample data, I dare to state the following assumptions: ⋅ There are only 2 levels of the COD costs (parent: e.g. 1 – Administration and child: e.g. 11 – Paper, 12 – Water). ⋅ The total value of the parent level COD cost is always a sum of its child lev...
by bartonv
Tue Jul 18, 2017 11:43 am
Forum: CloverETL for Java Programmers
Topic: XLS_WRITER throwing java.lang.ArrayIndexOutOfBoundsException
Replies: 1
Views: 58

Re: XLS_WRITER throwing java.lang.ArrayIndexOutOfBoundsException

Hi kreddy, the ArrayIndexOutOfBoundsException error message is typically thrown to indicate that an array has been accessed with an illegal index. The index could be either negative or greater than or equal to the size of the array. Given the fact that XLSWriter is a deprecated component in the 4.3 ...
by bartonv
Tue Jul 18, 2017 8:08 am
Forum: CloverETL Support
Topic: Performance issue with processing large csv files with joins
Replies: 1
Views: 52

Re: Performance issue with processing large csv files with joins

Hi Eric, there is no easy way to force the FlatFileReader component to break records down and process them in batches. However, from looking at your graph I would like to suggest a few tips that might help you resolve the memory overflow issue caused by the ExtHashJoin component. ⋅ As you ...
by bartonv
Thu Jul 13, 2017 12:06 pm
Forum: CloverETL Support
Topic: Flat File Reader Error - Bad Quote Format?
Replies: 2
Views: 91

Re: Flat File Reader Error - Bad Quote Format?

Hi Heather, thank you for the detailed explanation of the issue. When it comes to matching your example with the examples in our documentation, however, I beg to differ. The string that causes the parsing error in your graph ("Coaching in the Moment" Workshop/Lunch) looks a lot like the &q...
by bartonv
Wed Jul 12, 2017 3:16 pm
Forum: CloverETL for Java Programmers
Topic: How to parse large XML file using custom XMLExtract in Java and store it in database
Replies: 3
Views: 137

Re: How to parse large XML file using custom XMLExtract in Java and store it in database

Hello Sai, there are many sources of information on how to create graphs that would read and parse the content of a XML file such as the one you reported. To name a few: • The Help documents describing the basics of creating and running graphs in CloverETL Designer are available here and here . • Th...
by bartonv
Mon Jul 10, 2017 12:17 pm
Forum: CloverETL Support
Topic: move/copy files very slow when overwriting
Replies: 3
Views: 113

Re: move/copy files very slow when overwriting

Hi wills__aperio, thank you for the provided details. After a close inspection, it appears that Clover keeps listing the entire target directory content every time there is a file that is supposed to be overwritten. Such behavior, however, does not seem to be correct. I have logged the following iss...
by bartonv
Fri Jun 30, 2017 3:27 pm
Forum: CloverETL Support
Topic: move/copy files very slow when overwriting
Replies: 3
Views: 113

Re: move/copy files very slow when overwriting

Hello Will, the way how the MoveFiles component actually moves files to a remote location via SFTP heavily depends on the SFTP utility and CloverETL version that you are using. Could you please get back to us with more details so that we can suggest the most suitable resolution? 1. What is your SFTP...
by bartonv
Tue Jun 20, 2017 8:08 am
Forum: CloverETL Server
Topic: Query Jobs on Server
Replies: 1
Views: 90

Re: Query Jobs on Server

Hello hneff1, querying the CloverETL Server database for a list of all enabled scheduled jobs heavily depends on the type of the database you are taking advantage of (Microsoft SQL Server, MySQL, Derby etc.) Nevertheless, the database structure for storing this information, such as server scheduled ...
by bartonv
Thu Jun 15, 2017 10:06 am
Forum: CloverETL Support
Topic: Partition Component
Replies: 3
Views: 113

Re: Partition Component

Hello pintail, as you rightly said, the Partition component does assign the filtered records to the output ports randomly when using the Partition key as the only property definition. This is, in fact, the easiest way how this component can be used to get the data forked into multiple output ports. ...
by bartonv
Mon Jun 05, 2017 12:14 pm
Forum: CloverETL Support
Topic: XMLExtract V 4.4 issue in reading elements
Replies: 1
Views: 95

Re: XMLExtract V 4.4 issue in reading elements

Hello Sriram, From the snippet of the XML input file and from your description of the situation I understand that you mapped the output of the <Person_Education> element to populate the parent record (the “ABC” person). Since the <Person_Education> element has multiple instances within the parent el...

cron