Search found 19 matches

by jausperger
Wed Sep 09, 2009 10:03 am
Forum: CloverETL Support
Topic: How to read mapping with same xmlFields using XMLExtract
Replies: 15
Views: 4906

Re: How to read mapping with same xmlFields using XMLExtract

Try this, there was wrong id and maybe something else: EngineInitializer.initEngine("plugins", null, null); EngineInitializer.forceActivateAllPlugins(); GraphRuntimeContext runtimeContext = new GraphRuntimeContext(); TransformationGraph graph = new TransformationGraph(); graph.setDebugMode...
by jausperger
Fri Jun 05, 2009 9:38 am
Forum: CloverETL Support
Topic: XML xsi types with the XML Path Reader
Replies: 7
Views: 3568

Re: XML xsi types with the XML Path Reader

Try this: <Context xpath="/OLife" outPort="0" namespacePaths="'http://mike.com/services/1.0/';xsi='http://www.w3.org/2001/XMLSchema-instance';xsd='http://www.w3.org/2001/XMLSchema'"> <Context xpath="Party" outPort="1"> <Mapping xpath="ID" c...
by jausperger
Thu Jun 04, 2009 11:47 am
Forum: CloverETL Support
Topic: XML xsi types with the XML Path Reader
Replies: 7
Views: 3568

Re: XML xsi types with the XML Path Reader

Hi, namespaces are supported by the XML Path Reader. An examaple: <xml xmlns:xsi="http://www.xxx.org/p/"> <test xsi:type="a:IntlAddress">test data</test> </xml> <Context xpath="/xml" outPort="0" namespacePaths="xsi='http://www.xxx.org/p/'"> <Mapping ...
by jausperger
Tue May 05, 2009 2:07 pm
Forum: CloverETL Support
Topic: Multi-valued fields
Replies: 4
Views: 1755

Re: Multi-valued fields

What about sending these 'bar' to another output port? Each record would contain just one 'bar' and a key to 'foo'.
by jausperger
Tue May 05, 2009 10:39 am
Forum: CloverETL Support
Topic: Multi-valued fields
Replies: 4
Views: 1755

Re: Multi-valued fields

You can use: <Mapping xpath="concat(foo/bar[1]/text(), '@!@', foo/bar[2]/text())" cloverField="bar"/> if you want to write the values to one Clover field. Both possibilities are right.
by jausperger
Wed Feb 25, 2009 4:32 pm
Forum: CloverETL for Java Programmers
Topic: File Locking not released
Replies: 4
Views: 4652

Try universal data reader, that is ok. I found out deprecated delimiter data raeder don't close the files... in version 2.6
by jausperger
Tue Jan 20, 2009 10:25 am
Forum: CloverETL for Java Programmers
Topic: File Locking not released
Replies: 4
Views: 4652

Hello, could you send more information, all graph or describe your use case? I suppose you have tried this on Windows. What reader does it?
by jausperger
Wed Oct 22, 2008 10:37 am
Forum: Cookbook
Topic: How to use incremental reading?
Replies: 0
Views: 7231

How to use incremental reading?

What is and how to use incremental reading? --------------------------------------------------------- If you have a file (url) that you want to process but at once you suppose the file is not complete (additional data will be appended at the end of file) then it is suitable to use the incremental re...
by jausperger
Tue Sep 09, 2008 3:00 pm
Forum: CloverETL Support
Topic: XSLT support
Replies: 4
Views: 2238

You can use whatever reader (JMS, Universal, DBInputTable,...) and get whole xml into a field. I don't know how big is your xml file and it can cause memory problem. If you have simple file, you can use ie UniversalDataReader and metadata: <Metadata id="Metadata0"> <Record name="recor...
by jausperger
Tue Sep 09, 2008 8:32 am
Forum: CloverETL Support
Topic: XSLT support
Replies: 4
Views: 2238

Hello, I believe you can use the first use case. The first component reads a xml file (last matadata field must use eofDelimiter if you use UniversalDataReader..), the second component is XSLTTranformer and the last component is XMLXpathReader. There is one condition you must set up appropriate fiel...
by jausperger
Thu Sep 04, 2008 9:05 am
Forum: CloverETL Support
Topic: multiplying output
Replies: 6
Views: 3072

If you want to get only file name I suppose to use SystemExecute component. Something like dir -... > fileNames.txt and then use a reader.
by jausperger
Thu Sep 04, 2008 8:43 am
Forum: CloverETL Support
Topic: multiplying output
Replies: 6
Views: 3072

I checked up your graph file and I didn't find a metadata file. I suppose you have autofilling for all metadata. Ie: <Record fieldDelimiter="|" name="recordName1" recordDelimiter="\n" type="delimited"> <Field auto_filling="source_name" name="fie...
by jausperger
Tue Dec 11, 2007 9:58 am
Forum: CloverETL Support
Topic: log4j output ends after a Trash node
Replies: 1
Views: 1819

debugging

Hello, if the Trash component has debugPrint="true" and debugFilename doesn't exist, the Trash sets WritableByteChannel to system output for a StructureWriter. I'm afraid the WritableByteChannel reserves the output for itself. This 'problem' is known, it has to exist only one Trash for thi...
by jausperger
Mon Dec 10, 2007 1:57 pm
Forum: CloverETL for Java Programmers
Topic: Running CloverETL from Java
Replies: 14
Views: 15419

two ways

Hello, there are 2 ways how to import clover etl project without gui. The site "http://www.cloveretl.org/download/clover-etl/" contains some releases and source codes. 1) If you want to use or re-extend clover etl faetures, please use the release. There are jars files which add to your pro...
by jausperger
Wed Nov 07, 2007 11:57 am
Forum: CloverETL Support
Topic: Reading and Writing XML files in CloverETL
Replies: 1
Views: 2264

Hi, try http://wiki.clovergui.net/doku.php for documentation. You can use structure formatter class (StructureFormatter.class) that can create also a xml file or a WritableByteChannel via setDataTarget method. The Reformat component can use java code directly. Xml file or a stream can be read by XML...