Search found 12 matches

by jus
Wed Aug 01, 2012 9:53 pm
Forum: CloverETL Support
Topic: Determine success or failure of a graph from shell script
Replies: 2
Views: 2142

Re: Determine success or failure of a graph from shell script

Hi there, Is there a way to return "success" messages to the caller? something like the raiseError() function? Right now I am calling raiseError() with custom messages and then check ERROR_MESSAGE when the graph finishes. But this is only for error conditions. How can I do this for success...
by jus
Thu Apr 26, 2012 6:57 pm
Forum: CloverETL Support
Topic: Bug with decimal datatype?
Replies: 3
Views: 1785

Re: Bug with decimal datatype?

Cool! Thanks guys!
by jus
Wed Apr 25, 2012 7:17 pm
Forum: CloverETL Support
Topic: Bug with decimal datatype?
Replies: 3
Views: 1785

Bug with decimal datatype?

Hi there, Is there a bug with converting to/from the "decimal" datatype? I'm dividing a "long" integer by 100.0 to convert it from cents to dollars, but in some cases it loses one cent?? Fortunately we have a workaround right now: use the "number" datatype instead of &q...
by jus
Tue Mar 27, 2012 6:01 pm
Forum: CloverETL for Java Programmers
Topic: Global static variables
Replies: 12
Views: 9978

Re: Global static variables

I guess it's the same problem with the XlsDataWriter? Will it also be fixed in 3.3.0-M2?
Thanks again Jaroslav!
Jus
by jus
Fri Mar 23, 2012 8:28 pm
Forum: CloverETL for Java Programmers
Topic: Global static variables
Replies: 12
Views: 9978

Re: Global static variables

Thanks Jaroslav for your prompt reply! I really appreciate it. I now have a question about closing file handles. I am using ComplexDataReader to read in a flat file. After processing is finished, I'm using SystemExecute on the next phase to move the file into an archive or reject folder. But I get t...
by jus
Thu Mar 22, 2012 10:08 pm
Forum: CloverETL for Java Programmers
Topic: Global static variables
Replies: 12
Views: 9978

Re: Global static variables

Hi Jaroslav, thanks for your answer.
My next question is, how should we handle those workflow things meanwhile?
Should we use external scripts? Do it in the server? How do people do it usually? and what's your suggestion?
Thanks!
Jus
by jus
Thu Mar 22, 2012 9:11 pm
Forum: CloverETL for Java Programmers
Topic: File Locking not released
Replies: 4
Views: 4640

Re: File Locking not released

Hi there, I'm encountering a similar issue (using version 3.2.1). I'm using ComplexDataReader to process SourceFile.txt . And then, on a subsequent phase in the same graph, I am using SystemExecute to move SourceFile.txt to an archive folder. But it's giving me this error: ERROR [SYS_EXECUTE1_0] - T...
by jus
Thu Mar 15, 2012 5:18 pm
Forum: CloverETL for Java Programmers
Topic: Global static variables
Replies: 12
Views: 9978

Re: Global static variables

Hi Jaroslav, thanks for your help. I can continue working with the SystemExecute example. Though I'm not sure what to do with the XLSDataWriter, since the filename that I am writing to will be dependent on the output from the ComplexDataReader I'm using. Is there any way at all to do this besides pa...
by jus
Wed Mar 14, 2012 5:14 am
Forum: CloverETL for Java Programmers
Topic: Global static variables
Replies: 12
Views: 9978

Re: Global static variables

Hi Jarek,

How do I use dictionary entries in the FileURL field of XLSDataWriter? I tried the examples from here and here but it didn't work.
Also, how can I use the dictionary in a commnd field of SystemExecute?

Thanks!
Jus
by jus
Wed Mar 14, 2012 1:08 am
Forum: CloverETL for Java Programmers
Topic: Global static variables
Replies: 12
Views: 9978

Re: Global static variables

Hi Jarek,

How can I use dictionary in the FileURL field of XLSDataWriter? I've read the docs here and here, but couldn't seem to get it to work.
Also, I tried to use the dictionary in the command field of SystemExecute, and it didn't work. Please help.

Thanks!
Jus
by jus
Tue Mar 13, 2012 11:42 pm
Forum: CloverETL Support
Topic: ComplexDataReader help
Replies: 2
Views: 1378

Re: ComplexDataReader help

Awesome! Thanks Jaroslav!
by jus
Thu Mar 01, 2012 9:04 pm
Forum: CloverETL Support
Topic: ComplexDataReader help
Replies: 2
Views: 1378

ComplexDataReader help

Hi there, How do we read a flat file that has multiple types, but the data is specified on each row, not on the next rows? I was trying to follow the example from http://blog.cloveretl.com/processing-heterogeneous-data-with-complexdatareader , but that example uses a "batch" row that tells...