Talend community forum / how to mysql table fields and excel fields combined into sing node

indira · 2012-05-09 07:47:43

how to mysql table fields and excel fields combined into sing node and that node mapping and connected into postgresql table ?

pedro · 2012-05-09 07:51:11

Hi

Welcome to Talend Community!

For a quick start, you might read tutorials here.
Here is a scenario about your requirement.
tMysqlInput--main-->tMap--main-->tPostgresqlOutput
|
look up
tFileInputExcel--main--|

Regards,
Pedro

indira · 2012-05-09 12:30:19

Hi,

Yes i did as you said but when i run the job getting below error .
and one more issue excel columns names stoted in output file?

[statistics] connecting to socket on port 3814
[statistics] connected
Batch entry 0 INSERT INTO "c_country" ("c_country_id","ad_client_id","ad_org_id","isactive","created","createdby","updated","updatedby","name","description","countrycode","hasregion","regionname","expressionphone","displaysequence","expressionpostal","haspostal_add","expressionpostal_add","isdefault","ad_language","c_currency_id","ibannodigits","ibancountry") VALUES (AD,Key,key1,NULL,NULL,NULL,NULL,NULL,AND,NULL,AD,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,key3,key4,NULL,NULL) was aborted. Call getNextException to see the cause.
[statistics] disconnected

pedro · 2012-05-10 03:43:00

Hi

Please send me an email and attach this export job.
I will test it for you. There must be some wrong settings in your job.

Regards,
Pedro

indira · 2012-05-11 07:10:59

Hi Pedro,

I sent mail ,please verify that doc What do I do wrong ?

indira · 2012-05-14 06:40:20

Hi,

When I run this Query I am getting syntax error how to resolve this issue?

ERROR: syntax error at or near "AND"
LINE 1: ...country") VALUES (AD,0,0,NULL,NULL,NULL,NULL,NULL,AND,NULL,A...
^

********** Error **********

ERROR: syntax error at or near "AND"
SQL state: 42601
Character: 389

statistics] connecting to socket on port 3397
[statistics] connected
Batch entry 0 INSERT INTO "c_country" ("c_country_id","ad_client_id","ad_org_id","isactive","created","createdby","updated","updatedby","name","description","countrycode","hasregion","regionname","expressionphone","displaysequence","expressionpostal","haspostal_add","expressionpostal_add","isdefault","ad_language","c_currency_id","ibannodigits","ibancountry") VALUES (AD,0,0,NULL,NULL,NULL,NULL,NULL,AND,NULL,AD,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,us_eng,100,NULL,NULL) was aborted. Call getNextException to see the cause.
[statistics] disconnected

pedro · 2012-05-14 06:49:42

Hi

Sorry. I haven't received your email. And the error above can't point out what caused this error.

So please upload some screenshot about your job.
Usually this is due to the schema of tPostgresqlOutput. Please recheck it.

Regards,
Pedro

indira · 2012-05-14 08:35:00

Hi Pedro,

Ok, When I run this job I am getting this error and it wil nt insert row in out put file.

I upload the image.

Last edited by indira (2012-05-14 08:36:53)

pedro · 2012-05-14 08:39:07

Hi

Please note Limits: 20 images per post, each image must be less then 1024x768 pixels and 200 KB.

Regards,
Pedro

indira · 2012-05-14 08:56:00

OK

Last edited by indira (2012-05-14 14:17:35)

indira · 2012-05-15 06:40:17

Hi Pedro,

I upload the images ,but it wil nt preview plz send ur mail id

pedro · 2012-05-15 06:43:27

Hi

You will see my email from my forum signature.
xhuo@talend.com

Regards,
Pedro

indira · 2012-05-15 06:56:30

Hi Pedro,

Ok, I sent the mail
got my mail?

pedro · 2012-05-15 06:59:38

Hi

I have received your email.
I will try to find the root reason.

Regards,
Pedro

indira · 2012-05-15 07:02:51

thanks a lot pedro

pedro · 2012-05-15 08:24:06

Hi

Now I upload the images I got from your email.

The usage of tUnite is totally wrong here. Please delete it.
Besides, in tMap, you can't leave the expressions of some columns empty.

Regards,
Pedro

Uploaded Images

indira · 2012-05-15 10:15:10

Hi Pedro

I have removed the tunite , I have created remaining columns in excel , I have joined excel and tmap but i am getting same issue?

Last edited by indira (2012-05-15 12:49:33)

indira · 2012-05-16 09:04:48

Hi,

Is't correct?

pedro · 2012-05-16 09:07:01

Hi

It should be correct. But I think still there are some wrong settings in your job.

Regards,
Pedro

indira · 2012-05-16 09:10:20

Hi

plz tell me What I do wrong in my job ?

indira · 2012-05-22 13:01:50

Hi Pedro,

Thanks for your prompt replies for my issue with mysql & postgre data integration. As simple i am creating the job with one mysql table, postgre sql table & using tmap between two tables. The same error i am getting.
How to send a job file here for you reference.

I have sent a mail from another mail address & uploaded job file also.

please give me your suggestions on the job file.

Thanks
Indira

pedro · 2012-05-23 04:34:58

Hi Indira

Sorry. I think you'd better download the document [TalendOpenStudio_Components_RG_50b_EN] here and read instructions, scenarios.

I notice that you leave 'schema' on tPostgresqlOutput empty which you should get from postgresql DB.
Besides, in tMap the length of input column 'ISO3' is 3 while the length of related column 'country code' is 2.
Maybe the schema of tPostgresqlOutput is against the structure of this table at DB side.

Regards,
Pedro

indira · 2012-05-24 12:07:51

Hi Pedro,

I passed the string "100" like this, How to pass fixed date value in the expression field.

Last edited by indira (2012-05-24 12:10:09)

indira · 2012-05-24 12:13:24

Hi,

Type mismatch: can't convert from string to date how to resolve this issue?

Last edited by indira (2012-05-24 12:20:13)

pedro · 2012-05-24 13:16:34

Hi

You might use TalendDate.parseDate() method.

Regards,
Pedro

Uploaded Images

Announcement

Unanswered posts

#1 2012-05-09 07:47:43

how to mysql table fields and excel fields combined into sing node

#2 2012-05-09 07:51:11

Re: how to mysql table fields and excel fields combined into sing node

#3 2012-05-09 12:30:19

Re: how to mysql table fields and excel fields combined into sing node

#4 2012-05-10 03:43:00

Re: how to mysql table fields and excel fields combined into sing node

#5 2012-05-11 07:10:59

Re: how to mysql table fields and excel fields combined into sing node

#6 2012-05-14 06:40:20

Re: how to mysql table fields and excel fields combined into sing node

#7 2012-05-14 06:49:42

Re: how to mysql table fields and excel fields combined into sing node

#8 2012-05-14 08:35:00

Re: how to mysql table fields and excel fields combined into sing node

#9 2012-05-14 08:39:07

Re: how to mysql table fields and excel fields combined into sing node

#10 2012-05-14 08:56:00

Re: how to mysql table fields and excel fields combined into sing node

#11 2012-05-15 06:40:17

Re: how to mysql table fields and excel fields combined into sing node

#12 2012-05-15 06:43:27

Re: how to mysql table fields and excel fields combined into sing node

#13 2012-05-15 06:56:30

Re: how to mysql table fields and excel fields combined into sing node

#14 2012-05-15 06:59:38

Re: how to mysql table fields and excel fields combined into sing node

#15 2012-05-15 07:02:51

Re: how to mysql table fields and excel fields combined into sing node

#16 2012-05-15 08:24:06

Re: how to mysql table fields and excel fields combined into sing node

#17 2012-05-15 10:15:10

Re: how to mysql table fields and excel fields combined into sing node

#18 2012-05-16 09:04:48

Re: how to mysql table fields and excel fields combined into sing node

#19 2012-05-16 09:07:01

Re: how to mysql table fields and excel fields combined into sing node

#20 2012-05-16 09:10:20

Re: how to mysql table fields and excel fields combined into sing node

#21 2012-05-22 13:01:50

Re: how to mysql table fields and excel fields combined into sing node

#22 2012-05-23 04:34:58

Re: how to mysql table fields and excel fields combined into sing node

#23 2012-05-24 12:07:51

Re: how to mysql table fields and excel fields combined into sing node

#24 2012-05-24 12:13:24

Re: how to mysql table fields and excel fields combined into sing node

#25 2012-05-24 13:16:34

Re: how to mysql table fields and excel fields combined into sing node

Board footer