Search found 23 matches

by bartonv
Wed Oct 04, 2017 3:20 pm
Forum: CloverETL Support
Topic: Dynamic Join/Sort keys
Replies: 4
Views: 87

Re: Dynamic Join/Sort keys

Hi jblythe99, as you rightly indicated, CloverETL is currently not designed in a way that would enable sorting by dictionary values. Even though your post poses a lot of additional questions, I dare to presume you could take advantage of the dynamic parameter functionality to fulfill the same purpos...
by bartonv
Fri Sep 29, 2017 11:29 am
Forum: CloverETL Support
Topic: Missing java class files in server project
Replies: 1
Views: 58

Re: Missing java class files in server project

Hi Codehoper, thank you for your question. Upon reviewing the information you reported, I would like to provide the following suggestions: ⋅ In the custom Java component, try replacing the Transform Class reference with a Transform URL reference where you would refer to the .java file inst...
by bartonv
Tue Sep 26, 2017 2:18 pm
Forum: CloverETL for Java Programmers
Topic: XLS_WRITER throwing java.lang.ArrayIndexOutOfBoundsException
Replies: 2
Views: 232

Re: XLS_WRITER throwing java.lang.ArrayIndexOutOfBoundsException

Hello kreddy, there might be another reason for the issue to occur non-deterministicly. The error message that you reported has been seen in situations where a JXL library version newer than 2.6.9 is used when writing to Excel. The JXL is a library of JExcelAPI, which is an open source Java API that...
by bartonv
Mon Sep 18, 2017 1:42 pm
Forum: CloverETL Support
Topic: Dynamic metadata with unknown column type
Replies: 3
Views: 111

Re: Dynamic metadata with unknown column type

Hello jblythe99, unfortunately, ARRAY type fields are currently not supported in the dynamic metadata generating process. However, this issue is currently being discussed within our development team so I will let you know as soon as the decision is agreed upon. As for any potential workaround, I wou...
by bartonv
Mon Sep 11, 2017 3:04 pm
Forum: CloverETL Support
Topic: Input Port 0 still contains some unread records
Replies: 1
Views: 46

Re: Input Port 0 still contains some unread records

Hello KMac21, I have tried replicating your scenario from my end but I was unable to recreate the error message (all my graph run attempts finished successfully). Having said that, I trust this approach of yours seems to represent a legitimate way of achieving your goal. We just need to inspect your...
by bartonv
Mon Sep 11, 2017 12:08 pm
Forum: CloverETL Support
Topic: Metadata to insert decimal at specific location
Replies: 1
Views: 86

Re: Metadata to insert decimal at specific location

Hello wkerr, from your example, it seems that it is not possible to read the string “00001” directly into the decimal 0.0001. As you rightly indicated, you would have to take advantage of the Reformat component to achieve the desired format. I would suggest taking this path: ⋅ Read the inp...
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: 94

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

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

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

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

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

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: 2
Views: 232

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

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

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...