Search found 34 matches

by bartonv
Thu Nov 30, 2017 4:58 pm
Forum: CloverETL for Java Programmers
Topic: Problem in extracting the XML extract
Replies: 3
Views: 88

Re: Problem in extracting the XML extract

Hello Girish, from the snippet of your XML, I would suggest using the XMLExtract component to generate the XSD schema and take advantage of its visual mapping feature. Moreover, I would recommend using the ‘Populate parent record’ functionality as the fundamental concept of your data extraction as i...
by bartonv
Thu Nov 30, 2017 3:26 pm
Forum: CloverETL Support
Topic: Stopping a graph midway
Replies: 5
Views: 822

Re: Stopping a graph midway

Hi Mukunku, the fail component is designed in a way that it can abort the parent jobflow or graph with a user-specified error message and at the same time return some results through the dictionary. Having said that, you could use the Fail component for both purposes. Let me present you with an exam...
by bartonv
Mon Nov 13, 2017 1:03 pm
Forum: CloverETL Support
Topic: Don't Save Run Record When Triggering Graph from Simple HTTP API
Replies: 1
Views: 84

Re: Don't Save Run Record When Triggering Graph from Simple HTTP API

Hi Sal, there are a couple of options that you can take advantage of when trying to achieve a lower amount of log data: ⋅ As you rightly indicated, it can be achieved by adding a log level parameter directly to the URL when calling a ‘graph_run’ operation. By default, the logging level is ...
by bartonv
Mon Nov 13, 2017 1:01 pm
Forum: CloverETL Support
Topic: UniversalDataReader SFTP issue
Replies: 8
Views: 227

Re: UniversalDataReader SFTP issue

Hello gch, in order to troubleshoot this issue, I would suggest focusing on the following items first before we dig any deeper: ⋅ Try adding the proper port number to the URL: sftp://[username]:***@[servername]:[port]/home/oraclesftp/StatusLink.csv ⋅ Try checking the URL for any ...
by bartonv
Fri Nov 10, 2017 1:27 pm
Forum: Cookbook
Topic: Send data to an HTML table
Replies: 1
Views: 123

Re: Send data to an HTML table

Hi Paul,
thank you for the useful solution. I trust CloverETL users will appreciate your work.
Kind regards,
by bartonv
Wed Nov 01, 2017 1:47 pm
Forum: CloverETL Support
Topic: Join two FlatFileReader/UniversalDataReader
Replies: 5
Views: 176

Re: Join two FlatFileReader/UniversalDataReader

Hello Ricardo, thank you for the feedback. Moving your data transformation to a jobflow is certainly a more elegant and straightforward way to go. Having said that, let me provide 2 additional recommendations that might be worth implementing as they are considered to be a best practice with potentia...
by bartonv
Tue Oct 31, 2017 4:20 pm
Forum: CloverETL Support
Topic: Connection Keep-Alive for SQL Temp Table
Replies: 2
Views: 106

Re: Connection Keep-Alive for SQL Temp Table

Hi Jesse, in CloverETL, there is indeed a way how to achieve what you described in your update. By default, each thread gets its own connection instance, thus avoiding issues when multiple components read/write from/to a DB using the same connection definition. However, this behavior can be changed ...
by bartonv
Thu Oct 26, 2017 12:30 pm
Forum: CloverETL Support
Topic: Join two FlatFileReader/UniversalDataReader
Replies: 5
Views: 176

Re: Join two FlatFileReader/UniversalDataReader

Hello Rickymartin06, based on your attached screenshot, I would suggest an approach of making the UniversalDataReader components read an empty file in case the original file was not found, thus avoiding a potential graph fail on the reader and/or the join component. This can be achieved by placing a...
by bartonv
Tue Oct 24, 2017 12:01 pm
Forum: CloverETL Support
Topic: JSON Nested Elements
Replies: 1
Views: 106

Re: JSON Nested Elements

Hello Mybludrunsorange, please find the attached solution based on your example. The main idea is to extract the data to 2 output ports by using JSONExtract and outputting them with JSONWriter by using the parent key concept. Below is a more detailed explanation of the key setup: ⋅ I used ...
by bartonv
Fri Oct 20, 2017 1:46 pm
Forum: CloverETL Support
Topic: Normalizer Cols to Rows
Replies: 9
Views: 1630

Re: Normalizer Cols to Rows

Hi Pintail, yes, Normalizer is the component you are looking for. Below, you can review an example code (in Normalizer) that is based on your sample data: //#CTL2 string[] fields; function integer count() { fields = [$in.0.Field1,$in.0.Field2,$in.0.Field3,$in.0.Field4]; return length(fields); } func...
by bartonv
Tue Oct 17, 2017 3:06 pm
Forum: CloverETL Server
Topic: Event Listener sends email three times
Replies: 2
Views: 177

Re: Event Listener sends email three times

Hi Pro7, I would suggest reviewing the following settings in order to narrow the issue down: ⋅ Check the setup of the Event Listener, specifically the CC, Bcc and Reply-to section (which is hidden by default). Make sure that the email address in question is indeed listed only once. ⋅&...
by bartonv
Wed Oct 04, 2017 3:20 pm
Forum: CloverETL Support
Topic: Dynamic Join/Sort keys
Replies: 4
Views: 277

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

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

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

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