Search found 841 matches

by avackova
Thu Jan 10, 2008 9:00 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Number of records in XML File through structured Writer
Replies: 3
Views: 7438

I thought to write the header by java code in finish method; I don't have better idea. Graph: <?xml version="1.0" encoding="UTF-8"?> <Graph created="Wed Jan 09 08:56:52 CET 2008" guiVersion="1.8" id="1199880496440" licenseType="Evaluation licens...
by avackova
Wed Jan 09, 2008 1:49 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Number of records in XML File through structured Writer
Replies: 3
Views: 7438

Hi, problem is that the Structured Data Writer (and any other writer component as well) doesn't know how many records it will get. Number of processed records is known after processing all records already. My solution is to count records in Reformat component. In its finish method write header of th...
by avackova
Wed Jan 09, 2008 9:26 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Identifying error in input file
Replies: 5
Views: 6682

If you use Universal Data Reader you can save to file more info about unparseable records.
by avackova
Wed Jan 09, 2008 9:17 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Filter Ext : Referring to parameter index
Replies: 2
Views: 3955

Hi, in the meantime you can use Reformat instead of ExFilter. Eg. with transform function: import java.util.Properties; import org.apache.commons.logging.LogFactory; import org.jetel.component.CustomizedRecordTransform; import org.jetel.component.DataRecordTransform; import org.jetel.data.DataRecord...
by avackova
Mon Jan 07, 2008 1:03 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Filtering nodes do not support multi-language character sets
Replies: 9
Views: 8320

I've found that such regex does not throw an exception:
"^[0-9]{8}[\\p{InHanzi}]*"
by avackova
Mon Jan 07, 2008 10:12 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Transformation Language for Reformat
Replies: 2
Views: 4341

Hi, function str2num is part of Transformation Language, not Lite Transformation Language. The last one should be used for simple mappings only. If you write transformation using Transformation Language you need to give it into the body of transform function: function transform(){ nt gender = str2nu...
by avackova
Fri Jan 04, 2008 1:26 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Transformation Language does not support BLOB type
Replies: 3
Views: 4321

This feature is not implemented yet, but it will work in the future.
by avackova
Thu Jan 03, 2008 11:45 am
Forum: CloverDX (formerly CloverETL) Support
Topic: decimal separator
Replies: 2
Views: 3676

Hi,
decimal separator depends on locale settings. Haven't you change the locale settings on your computer or on metadata?
by avackova
Fri Dec 21, 2007 8:52 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Batch Mode setting for database writer
Replies: 6
Views: 6465

I don't thing that infinite number of errors could be useful, because, usually, only small per cent or records are wrong and not loaded to database. Another case is when all records are wrong and then, probably, user would like to stop after first error to correct query.
by avackova
Thu Dec 20, 2007 10:42 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Batch Mode setting for database writer
Replies: 6
Views: 6465

I'm sorry, I've written wrong answer above: when maxErrors is set -1 errors are completely ignores, even not logged. To send error records to output, maxErrors has to be greater then 0. If you want only to log errors, set maxErrors greater then expected number of errors.
by avackova
Thu Dec 20, 2007 10:38 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Batch Mode setting for database writer
Replies: 6
Views: 6465

As written above connect writer node to 0 (zero) output port of DBOutputTable and set maxErros = -1
by avackova
Mon Dec 17, 2007 9:38 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Error in clover 2.2.1 but not on clover 2.1
Replies: 5
Views: 5818

Hi,
try to use WinZip or jar command.
by avackova
Mon Dec 17, 2007 9:18 am
Forum: CloverDX (formerly CloverETL) Support
Topic: class extends DataRecordTransform
Replies: 2
Views: 3650

Hi, it could work: Node reformat = (Node)getGraph().getNodes().get("reformatId"); DataRecord record = new DataRecord(targetMetadata[0]); record.init(); SetVal.setString(record,"field1","hello"); try { reformat...
by avackova
Fri Dec 14, 2007 11:08 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Error in clover 2.2.1 but not on clover 2.1
Replies: 5
Views: 5818

Hi,
aren't your data very large. I suppose that your record is greater then expected size. Pls check http://wiki.clovergui.net/doku.php?id=c ... _constants
by avackova
Fri Dec 14, 2007 10:41 am
Forum: CloverDX (formerly CloverETL) Support
Topic: has been shut down stream
Replies: 4
Views: 5146

Hi, I thing that problem is in jdbc oracle driver: after calling method getBytes or getBlob can't be called other type call method. I've found workaround to solve your problem: change field's order in metadata and in sql queries - that means: <Record name="T1" recordSize="-1" typ...

cron