topic Execute Groovy validators in Job flow in Talend Studio

Execute Groovy validators in Job flow

Anonymous — Sat, 16 Nov 2024 12:30:30 GMT

Hi,
The Excel files that I upload are like snowflakes, no two are alike! To speed up development time, I'd like to access our Groovy/Grails domain class validators prior to the upload of each row.
I've tried many suggestions both on this forum and outside. The most promising is to bind to the globalMap using tGroovyFile and then call it from a tJava component, but tGroovyFile throws a groovy.lang.MissingPropertyException: No such property: globalMap for class: Script1.
The example code in the Groovy file is:
globalMap.put("GroovyObject", new MyGroovyObject())
class MyGroovyObject {
def myMethod(row) {
// Do anything you want with the row
// update the row directly like
row.counter++
row.email = row.email + "_TEST"
}}
It errors out before even getting to the tMap. Is there something I'm missing? (I'm a Groovy noob.) Is there example code somewhere?
Thanks,
Eileen

Re: Execute Groovy validators in Job flow

Anonymous — Wed, 14 Dec 2011 20:56:14 GMT

Hi,
This blog post has a video that shows how to use groovy with Talend:
http://bekwam.blogspot.com/2011/02/tutorial-using-groovy-with-talend-open.html
Here's another post that describes how to get data out of groovy (say a validator result and error messages object).

http://bekwam.blogspot.com/2011/04/passing-variable-out-of-tgroovy-with.html

Re: Execute Groovy validators in Job flow

Anonymous — Thu, 15 Dec 2011 14:23:22 GMT

Thanks for the blog posts Carl!
Best,
Pcoffre.

Re: Execute Groovy validators in Job flow

Anonymous — Thu, 15 Dec 2011 16:41:28 GMT

Hi walkerca,
I have seen the first link, and the issue I have is that tGroovy and tGroovyFile only run once at the beginning of the job, and the code needs to run for every row. The second link looks promising and is one I haven't seen before. I'll work with it to see if it solves my problem.
Thank you for your response!
Eileen