Problem with importing companies

[cilla]

Hi!
I have made a own multiselect dropdown, but when i import my companies and select the fields everything works except my new label field, I choose right in the import but the information dont show up when i go to company when i´m in company and select from the list it stays on the information so my problem is how to import the information so it stays after the import if you guys know what i mean.

is there something i missed when i created the multiselect? i can select the field in the import function but the info dont saves on the company.

regards cilla

[cilla]

Nobody know how to change so it works to save the information?

/Cilla

[JVWay]

It does work as I have achieved what you are trying. I think that it is case sensitive so be sure that the data you are importing is exactly the same as what you have in the drop down. Also, be sure that the key and the label are correct. I believe that the data imported needs to be the same as the key value. I've always made mine the same value but I would think that's the way it would be.

What this means is that you could have key values of 1,2,3 and label values of Red, Green, Blue. Your imported data would be 1,2 or 3 but the drop down would show Red, Green or Blue. Now there's no reason to do this as Sugar supports textual keys I'm just showing that this could be the problem and your incoming data may be of this type.

Also, be sure you are using a CSV text file. If you are exporting from Excel or Access or something it's always a good idea to open the file in notepad++ or something and save it to get rid of any formatting that might be fouling your import.

[wichard]

also keep in mind if it is a multiselect dropdown and you import multiple values the format will be like "key1^,^key3" this way it represents selecting key1 and key3 for the multiselect field

[roblaus]

jvway is right. You must import the key values. It's easy in English but tricky in other languages because your import file must be "translated". E.g. key value "trade fair" / en "trade fair" / de "Messe" -> I must import "trade fair". Would be easier to understand if the key values were indeed numeric as jvway says.

rgds

[cilla]

Hi guys!
I give it a try

I come back and tell

/Cilla

[cilla]

No i have tryed it all dont work it saves everything except the value for multiselect

here is the products_list:
$GLOBALS['app_list_strings']['products_list']=array ( '' => '',
'key1' => 'Affärssystem',
'key2' => 'Arbetsbord',
'key3' => 'Bandningsmaskiner',
'key4' => '',

here is my csv file:
9696867036 Actima Montörgatan 1 302 60 HALMSTAD www.actima.se 035-214602 key1
5509109053 Arkstäd Tylövägen 21 302 70 HALMSTAD 035-32371 key2


i have put in company.nr at the first value and that field saves the value when i import but dont save the value for the multiselect that is last value

anymore idea´s boys how i can manage to do his

[roblaus]

That looks very Swedish to me...

Will try to replicate later today. Stay tuned. BTW - what version are you using?

rgds
rl

[cilla]

SugarCE 5.0.0g

[roblaus]

Hi,

Confirmed. Doesn't work.Tried it with an exported file so structure and content is ok.
You need to do it directly in the database. But for this field only. Use your company no as identifier and run update accounts_cstm set...

rgds