how do I "select" the dropdown value when using Import Wizard with a custom dropdown

[mcichelli]

NOTE - the real problem was my input data - the values for the dropdown field contained a leading space. I corrected the data and all is working correctly.


I have used the Import Wizard mostly successfully to load both Accounts and Contacts. I have a problem with ONE field however.

This field WAS loaded into the database by the Import Wizard (I checked with SQL statements) and I can see it in the Contacts_cstm table using phpMyAdmin.

1. In Detail view, the data does not show up in the field initially.
2. In List View it DOES (I added it to the fields to be displayed in List View)
3. In Edit View, the field shows up as empty (with the displayed value "NONE'), BUT the appropriate drop-down list is available. If I select a value and save it and then return to Detail View, the proper value DOES appear.

This is not the only field I have loaded using the Import Wizard. The others (in the Accounts module) are fine.

I am willing to hand edit files, but I like the idea that if I use Studio I won't have to worry about redoing the custom fields. Plus, I need a little guidance about what to edit.

I'd appreciate any insights.

I"VE PINNED THE PROBLEM DOWN FURTHER. The problem seems to be that initially SugarCRM does not know which of the dropdown values has been selected. It wasn't actually "selected" of course; it was loaded up with the Import Wizard. Is there a definition or code area I could change to make it search the list of values in my dropdown dom file and "select" the correct value for displaying? Is the list searched each time the html is generated, or is the "selected option" stored away somewhere?

Running V4.5.0F under Windows 2003