Search found 49 matches

by twaller
Wed Dec 07, 2011 1:56 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: My First Clover Join has me up against the wall
Replies: 1
Views: 2501

Re: My First Clover Join has me up against the wall

Hello ShawnHarmon, I studied your graph and found a serie of misunderstandings. I did not have your original files, but I could use the files you attached to your question on Forum. I noticed that your PrimaryKey values were not identical in either edges. Maybe in your original files they are identi...
by twaller
Mon Nov 21, 2011 4:18 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: dbExecute and alter database statements
Replies: 6
Views: 5754

Re: dbExecute and alter database statements

Hello dnrickner,

could you let me know what your stored procedure was?

Best regards,

Tomas Waller
by twaller
Mon Jan 17, 2011 3:40 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Problem Writting output xml to a file in Cloveretl
Replies: 2
Views: 2770

Re: Problem Writting output xml to a file in Cloveretl

Hello Karan, You can get the desired output: <?xml version="1.0" encoding="ISO-8859-1"?> <TranxRequest> <NetworkID>50427</NetworkID> <Details> <CustomerName>XXXX</CustomerName> <CustomerID>YYYY</CustomerID> </Details> <Details> <CustomerName>aaaaa</CustomerName> <CustomerID>asasa...
by twaller
Tue Oct 26, 2010 4:04 pm
Forum: CloverDX for Java Programmers
Topic: Custom component as plugin for Clover ETl Designer
Replies: 8
Views: 9081

Re: Custom component as plugin for Clover ETl Designer

Hallo Jana, In addition to your component Java code, the plugin.xml file, you also need to create another xml file, which serves to integrate the component into CloverETL Designer. (For more details see the following link: http://www.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.gui.docs...
by twaller
Fri Oct 01, 2010 12:54 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Concatenate Node Clarification
Replies: 2
Views: 3451

Re: Concatenate Node Clarification

Dear Ann, As regards the Concatenate component, it starts reading the records from any port only after all records from all previous ports (those with lower numbers) have been read successfully, without any error. Thus, this component does not start reading any record through the port 1 if there sti...
by twaller
Fri Oct 01, 2010 12:37 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: UNIX Server Connection and data extraction
Replies: 3
Views: 3606

Re: UNIX Server Connection and data extraction

You can also use only one SystemExecute with another script (maybe this is a better solution): open scp://myusername:mypassword@myhostname call ls -l exit And the graph will be as follows: <?xml version="1.0" encoding="UTF-8"?> <Graph author="cloveruser" created="T...
by twaller
Fri Oct 01, 2010 12:23 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: UNIX Server Connection and data extraction
Replies: 3
Views: 3606

Re: UNIX Server Connection and data extraction

Dear Sureshsbhatia, You need to download and install WinSCP application. After that, you need a script which will be executed by CloverETL. Suppose you will install your WinSCP into C:/Program Files/WinSCP folder. There is a WinSCP.com command line tool in it. You need to create a graph consisting o...
by twaller
Fri Sep 17, 2010 10:06 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Assigning byte value - is this a bug?
Replies: 2
Views: 2581

Re: Assigning byte value - is this a bug?

Dear ruof.fael,


We've created a bug report in our bug tracking system
(http://bug.cloveretl.com/view.php?id=5151) for the issue.

Best regards,

Your CloverETL Support team

Tomas Waller
by twaller
Tue Mar 09, 2010 10:14 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Non-Matched Port in ExtMergeJoin
Replies: 1
Views: 2216

Re: Non-Matched Port in ExtMergeJoin

Hello, This is my mistake. ApproximativeJoin has output port 2 for non-matched master records, output port 3 for non-matched slave records. Ports 0 and 1 for transformed records. DBJoin and LookupJoin have output port 1 for non-matched master records. Port 0 is for transformed records. ExtHashJoin a...
by twaller
Tue Feb 16, 2010 8:50 am
Forum: CloverDX (formerly CloverETL) Support
Topic: merge data flows based on row order
Replies: 3
Views: 2730

Re: merge data flows based on row order

For information about the right pane of Metadata Editor (where Autofilling functions are described) see:
http://www.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/details-pane.html?path=0_4_2_6_2_1#field-details

Regards,

Tomas Waller
by twaller
Tue Feb 16, 2010 8:37 am
Forum: CloverDX (formerly CloverETL) Support
Topic: merge data flows based on row order
Replies: 3
Views: 2730

Re: merge data flows based on row order

Hello, To join these records as requested, you need to create Join key. It can be done in Readers or in Reformats. In Readers, you can use one of the autofilling functions - global_row_count. Create an integer field in metadata (in addition to those existing) and set this field to Autofilling - glob...
by twaller
Fri Feb 12, 2010 11:29 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Diffrence between designer pro.designer
Replies: 1
Views: 2179

Re: Diffrence between designer pro.designer

Hello,

For comparison of Designer Pro and Designer see:
http://www.cloveretl.com/cloveretl-designer/comparison/

Best regards,

Tomas Waller
by twaller
Tue Jan 12, 2010 4:01 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to read mapping with same xmlFields using XMLExtract
Replies: 15
Views: 8081

Re: How to read mapping with same xmlFields using XMLExtract

Hello, I have an input file with attributes: <?xml version="1.0" encoding="UTF-8"?> <Rows> <Row> <Item_Number> <ID myattribute="valueItem1">Item 1</ID> </Item_Number> <GTIN_Number>00erer013616</GTIN_Number> <Mill_Code>03</Mill_Code> <Mill_Description> <ID myattribute=&q...
by twaller
Thu Dec 17, 2009 3:23 pm
Forum: CloverDX for Java Programmers
Topic: URGENT: remove duplicate records and sorting in DEDUP??
Replies: 4
Views: 8580

Re: URGENT: remove duplicate records and sorting in DEDUP??

Hello Achan, You can click inside the left pane of the Edit key dialog (Fields pane), then click Ctrl+A (after which all Fields will be selected and turned blue) and click the Right arrow key. This way all the fields will be moved to the pane on the right. You only need to confirm this by clicking O...

cron