Search found 16 matches

by madan_clover3
Mon Feb 13, 2017 7:03 am
Forum: CloverETL Support
Topic: Any component to read data from web service
Replies: 1
Views: 289

Any component to read data from web service

Hi,

Is there any component to read data from a web service?
SOAP based or REST based?
Available in community edition or not ?

I could not find anything in docs,
http://doc.cloveretl.com/documentation/ ... /index.jsp

Please suggest available options and alternates,

Thanks in advance,
Madan
by madan_clover3
Mon Feb 06, 2017 7:58 am
Forum: CloverETL Support
Topic: Clover script validation
Replies: 5
Views: 521

Re: Clover script validation

Found some solution. String prefix = "//#CTL2 \n function integer transform() {"; String postfix = " return 0; }"; String expressionValidateFunction = prefix + expression + postfix; ITLCompilerFactory compilerFactory = new TransformFactory.DefaultCompilerFactory(); final ITLCompi...
by madan_clover3
Mon Feb 06, 2017 7:40 am
Forum: CloverETL Support
Topic: Clover script validation
Replies: 5
Views: 521

Re: Clover script validation

Tried below options : Option 1 : String expression = "$field1=$field/2; $field3=str2date($field4, "dd.MM.yyyy");"; ITLCompilerFactory compilerFactory = new TransformFactory.DefaultCompilerFactory(); final ITLCompiler compiler = compilerFactory.createCompiler(getGraph(), recordMet...
by madan_clover3
Mon Feb 06, 2017 5:11 am
Forum: CloverETL Support
Topic: Clover script validation
Replies: 5
Views: 521

Re: Clover script validation

Hi, I am executing transformation in java, not using transform editor. I need to validate clover script as and when user submits to some xyz api so that I can warn user to correct the script then and there. Validating in transformation process is too late to intimate user about script errors. I am l...
by madan_clover3
Tue Jan 31, 2017 9:59 am
Forum: CloverETL Support
Topic: Clover script validation
Replies: 5
Views: 521

Clover script validation

Hi I am trying to validate clover script, For ex., $field1=$field/2; $field3=str2date($field4, "dd.MM.yyyy"); I need to validate the above script for compilations and data type mismatch problems. Is there any way I can do this before even transformation graph is executed. Thanks in advance.
by madan_clover3
Thu Nov 24, 2016 1:43 pm
Forum: CloverETL for Java Programmers
Topic: Reading from mulitple xml files
Replies: 1
Views: 616

Reading from mulitple xml files

Hi, I am trying to read data from 2 xml files and finally writing to one single xml file. Mapping can happen in any combination from 2 source xmls to target xml. Consider below scenario, Source XML1: SourceEntity1 ___SourceEntity11 Source XML2: SourceEntity2 Target XML: TargetEntity1 ___TargetEntity...
by madan_clover3
Tue May 10, 2016 9:16 am
Forum: CloverETL for Java Programmers
Topic: Issue with Xml Reader
Replies: 3
Views: 1005

Re: Issue with Xml Reader

Thanks for explanation. I have tried Xml Extract as well. Problem with Xml Extract(SAX way) is we cannot map one source element to multiple target elements. In such case only last mapped element is getting data. (only fld3, fld4 is getting data in below case) <Mappings> <Mapping element="Datase...
by madan_clover3
Wed May 04, 2016 7:25 am
Forum: CloverETL for Java Programmers
Topic: Issue with Xml Reader
Replies: 3
Views: 1005

Issue with Xml Reader

Hi, Trying to read xml data with XmlReader. Below are data and mapping files, Mapping file 2 and 3 working fine. Mapping file 1 is giving exception (added below). Please clarify me is it expected behavior or issue with component. Data File : <Dataset> <Entity2 attribute21="attribute21value"...
by madan_clover3
Fri Dec 18, 2015 1:18 pm
Forum: CloverETL for Java Programmers
Topic: ExtXmlWriter does not write any thing when there is no data on port 0
Replies: 1
Views: 1003

ExtXmlWriter does not write any thing when there is no data on port 0

Hi, I am writing transformed data to xml file using ExtXmlWriter. ExtXmlWriter has 3 inports say 0,1 and 2. When the records count is 0 on port 0 nothing is written to the output file even if there are records coming for ports 1 and 2. And when I set "setCreateEmptyFiles" to true then it s...
by madan_clover3
Fri Jul 18, 2014 8:14 am
Forum: CloverETL Support
Topic: Evaluate CTL expressions in java
Replies: 4
Views: 1683

Re: Evaluate CTL expressions in java

yeah I see some test*.ctl files. What I am looking for is, public class CustomTransform extends DataRecordTransform { @Override public int transform(DataRecord[] sourceRecords, DataRecord[] targetRecords) throws TransformException { custom logic.. //here I need to update/calculate field values using...
by madan_clover3
Fri Jul 18, 2014 7:23 am
Forum: CloverETL Support
Topic: Evaluate CTL expressions in java
Replies: 4
Views: 1683

Re: Evaluate CTL expressions in java

Thank you for quick response.

I have downloaded "cloverETL.examples.rel-4-0-0-M1" from sourceforge.net. But I do not see any package "test.org.jetel.ctl" .
Can you please provide link or attach examples here.
by madan_clover3
Thu Jul 17, 2014 1:47 pm
Forum: CloverETL Support
Topic: Evaluate CTL expressions in java
Replies: 4
Views: 1683

Evaluate CTL expressions in java

Hi, I am trying to evaluate expressions in java using CTLExpressionEvaluator CTLExpressionEvaluator evaluator = new CTLExpressionEvaluator(); try { evaluator.evaluate("iif ($in.0.quantity < 0) { $out.0.quantity = 0 }"); } catch (ParseException e) { e.printStackTrace(); } it says 'iif' is n...
by madan_clover3
Fri Jun 27, 2014 10:19 am
Forum: CloverETL Support
Topic: read map from json data
Replies: 1
Views: 702

read map from json data

Hi, I am trying to read json element which is like, { element : { "key1" : "value1" , "key2" : "value2" , "key3" : "value3" } } and map it to an xml element. <head> <element> <entry> <key>key1</key> <value>value1</value> </entry> <entry> <k...
by madan_clover3
Sun Jun 22, 2014 12:54 pm
Forum: CloverETL Support
Topic: Need assistance in Templates for nested/recursive data
Replies: 4
Views: 1882

Re: Need assistance in Templates for nested/recursive data

Thank you very much for you time and support. Will give a try with your example.
by madan_clover3
Thu Jun 12, 2014 12:30 pm
Forum: CloverETL Support
Topic: Need assistance in Templates for nested/recursive data
Replies: 4
Views: 1882

Re: Need assistance in Templates for nested/recursive data

Hi, I was trying to convert above json to xml, with expected output is <category> <name>cat1</name> <subcategory> <name>subcat1</name> <category> <name>cat2</name> <subCategory> <name>subcat2</name> </subCategory> </category> </subcategory> </category> Categories does not have unique ids, but can be...

cron