Importing List Values to Sugar DB

[jlabuelo]

Hi all

I need to import 700 values to two multiselect fields and I dont see myself typing those values as it would take me forever.

I was thinking about using ETL to load them, but dont know which table in SugarCRM holds the values of the lists.

I mean if I create a new dropdown list in Studio, where are the values storeded after it? My idea is to use that table and with an ETL tool connect to it and pass it the values.

If anyone can pass me this table I will appreciate it.

Regards

[andopes]

I mean if I create a new dropdown list in Studio, where are the values storeded after it? My idea is to use that table and with an ETL tool connect to it and pass it the values.

The dropdown values can be stored into custom/Extension/application/Ext/Language/en_us.somescript.php~

Go to Admin -> Repair -> Rebuild Extension after populating such file.

Cheers

[jlabuelo]

Hi Andre

Thanks a lot for the answer. I have tried to search for this file but I am not able to find it in the path you are passing me.

I am running SugarCRM 5.2 over IIS and the path I can get to is:

custom / Extension / modules / Accounts / Ext/Layoutdefs

Not able to find the:

en_us.somescript.php

Is there something I am doing wrong?

thanks again

[jlabuelo]

Hi Andre

Dont worry after searching again I found the file in Custom/Include.....

Thanks once more