topic Re: importing data from excel to mysql workbench in Talend Studio

importing data from excel to mysql workbench

Anonymous — Tue, 09 Apr 2013 10:24:52 GMT

salut je voulais envoyer une table excel vers mysql workbench mais j'ai rencontré ce problem qlq'un a une idée 😕
Duplicate entry '' for key 1 ??????????? c quoi la solution et merci d'avance !

Re: importing data from excel to mysql workbench

Anonymous — Tue, 09 Apr 2013 10:33:17 GMT

Hi,
Which talend product do you used? the version is ? Is your resource file .xls file or .xlsx file? How do you set schema? Screenshots will be appreciated.
In addition, this is an international forum and English is the language we use. Posting in English will allow you to get more visibility and more help. Thanks for your understanding!
Best regards
Sabrina

Re: importing data from excel to mysql workbench

Anonymous — Tue, 09 Apr 2013 10:41:06 GMT

ah okey i'm sorry i forgot that so my version of talend is 5.2.2 and my version of mysql workbench is 5.2 also and when i tried to import my excel file (.csv) i followed the instruction of this video http://www.youtube.com/watch?v=GBC5NETEvPo then when i wanted to execute in the last it made me this error with red color as a conclusion we don't have any new rows in my mysql database
Démarrage du job test22 a 08:50 09/04/2013.
connecting to socket on port 3518
connected
=====>Duplicate entry '' for key 1<======
disconnected
Job test22 terminé à 08:50 09/04/2013.

Re: importing data from excel to mysql workbench

Anonymous — Tue, 09 Apr 2013 10:59:00 GMT

Hi,
Well, the video is not valid for me. I have a demo job as: tFileInputDelimited(.csv file)-->tMySqlOutPut
The input source is:
Id;Name
1;shong
2;Sabrina
Please see my screenshots for details. Hope it will point a light to you.
In addition, if you have any issue, could you upload your job screenshots as I provided into forum so that we can address your issue asap.
Best regards
Sabrina

Re: importing data from excel to mysql workbench

Anonymous — Tue, 09 Apr 2013 12:45:42 GMT

Hi,
there are the instructions that i followed to import my database into mysql workbench
1.i have my excel file (.xls)
2.i save it under (.csv)
3.i created a job the a new delimited file
4. i download my csv file
5. it gives me that , that the picture contain
6.i choose the primary key of table then click on finish
7.now i slip my csv file that i downloaded then i chose tfileimputdelimited
8. i slip tlogrow from logs and errors then execute
9.i chose tmap from tranformation
10. i slip the main line from it to tlog and i execute
11. i take another main line from the csv file to tmap the execute
12.i delete the tlogrow then i do to the connexion i create a new connection my sql then i get the shema on it
13. islip my table from shema on connexion as tmysqloutput
14. i click to auto map
14.and when i executeeee it give the same problem 😕

Re: importing data from excel to mysql workbench

Anonymous — Thu, 11 Apr 2013 06:47:50 GMT

Hi,

1.i have my excel file (.xls)
2.i save it under (.csv)
3.i created a job the a new delimited file
4. i download my csv file
5. it gives me that , that the picture contain
6.i choose the primary key of table then click on finish

Do you create a metadata file delimited? Is so, make sure your step is correct. Please refer to the online user guide Setting up a File Delimited schema

8. i slip tlogrow from logs and errors then execute

Could you upload your screenshot of file schema? So that we can address your issue, I suspect that you get a wrong in yourschema setting
Best regards
Sabrina