How to revert Studio customizations for Opportunities module

[djg]

Some of my custom fields have persisted in my installation, even after I have deleted them. This is probably related to my trying out changes by cloning a field and then deleting the unused variant.

The problem is that this was defined as a mandatory field, and when I now try to import Opportunities form a .cvs file, thereare now two custome mandatory fields, even though there is nominally only one custom field.

Q: How can I revert everything to the original state of the Opportunities module, and just re-enter my custom field from scratch?

My environment is:

» OS MS Windows XP Pro v. 2002 SP 2
» Sugar Suite version v. 5.0.0f
» Webserver Apache v. 2.0.59
» PHP version v. 5.2.1
» MySQL server v. 5.0.24-community-nt-log

thanks in advance to all who reply

d.

[eggsurplus]

It's in the fields_meta_data table. You can probably even just update the required column:

update fields_meta_data
set required = 0
where custom_module = 'Opportunities'
and name = 'mycustomfield_c'

Just change the mycustomfield_c to the name of your custom field.

[djg]

eggsurplus,

thanks for your suggestion. Unfortunately, it doesn't resolve the problem.

My problem custom field is named

contract_type_cc

- the strange thing is that on import, the supefluous mandatory field shows up as

LBL_CONTRAT_TYPE_CC

So as you can see, things are pretty messed up. I am planning on re-installing everything on a production server in a month or so, with the expectation that I'll have to re-import all Opportunities, but if you have any more ideas, please don't hesitate.

thanks again for your help,

d.