topic Re: Map ENUM field from CSV to MySQL in Talend Studio

Map ENUM field from CSV to MySQL

Anonymous — Fri, 14 Mar 2014 11:29:01 GMT

Hi,
I have a CSV like this.
"Mobile","Home Phone","Email","Languages Spoken"
2564589658,4589653259,support@gmail.com,English;Spanish;Russian
The field "Languages Spoken" has a multi-enum drop-down list.
I am using basic tMap to import the data.
If I select type as List in CSV it does not work.
Can someone please help.
Thanx in advance.
John

Re: Map ENUM field from CSV to MySQL

Anonymous — Fri, 14 Mar 2014 12:19:21 GMT

Hi John,
After looking at your data, I found that columns are ","separated. And your enum data is ";" separated. If you execute with same configuration and read the metadata, automatically the column "Languages Spoken" would contain all the enum fields.
Keeping the datatype for "Languages Spoken" column to string would solve your purpose.
Thanks
Vaibhav

Re: Map ENUM field from CSV to MySQL

Anonymous — Sat, 15 Mar 2014 07:09:09 GMT

Hi Vaibhav,
Firstly thanx for the reply and my apologies; I've not mentioned the full scope of import.
Basically it's a CSV to SugarCRM import.
Therefore the (input) CSV fields are ';' separated (for "Languages Spoken"). However the output needs to be in another format - as below:
"Mobile","Home Phone","Email","Languages Spoken"
2564589658,4589653259,support@gmail.com,^English^,^Spanish^,^Russian^
So it's basically a conversion of the string that is needed. I'm presuming an additional filter step is required?
Thanx in advance.
John

Re: Map ENUM field from CSV to MySQL

Anonymous — Sat, 15 Mar 2014 13:46:40 GMT

A MySQL ENUM field is a field which contains one string and in the metadata of the table are declared so called ENUMs - which means actually a fix list of possible values. A enum column does not hold more than one value at once!
Your use case, storing a list of languages the customer (?) speaks has nothing to do with enums. You should simply write the languages comma separated and thats it.

Re: Map ENUM field from CSV to MySQL

Anonymous — Tue, 18 Mar 2014 06:03:35 GMT

Hey Jan,
Thanx for the reply.
Actually it's a multi-enum field in SugarCRM.
I got the answer here.
https://community.talend.com/t5/Design-and-Development/How-to-Replace-quot-quot-with-null-or-Character/td-p/75747
Thanx all for your help.
Regards,
John