Importing problem mapping "Account Names" to Leads - Sugar 5.00b

[fedir]

Hi there,
I found a very strange bug, which I could not understand by simple logic.
I'm making mapping of my leads and during import process blocks, import is not possible, without any message of error. I made mapping of Account Name to Title and it works, but I want to make direct mapping to Account Names, because it's much more easy to convert Leads to Accounts after.
Why I couldn't import my Accounts Names directly to the field Account Name's field in the leads?
Thanks for Your answers and advices.

» Operating system type and version Debian 4
» Sugar Suite version 5.00b
» Webserver type and version Apache 2
» PHP version PHP 5
» MySQL server version 5.045

[clint]

There is a bug in 5.0.0 around the field definition for the Account Name vardef. See bugs 19293 and 18988 which are symptoms of the same problem.

I will work with the dev team to get this addressed in the next patch. In the meantime, the workaround is the following:

Open the ./modules/Leads/vardefs.php file for editing.

1. Replace the following array:

'account_name' =>
array (
'name' => 'account_name',
'rname' => 'name',
'id_name' => 'account_id',
'vname' => 'LBL_ACCOUNT_NAME',
'join_name'=>'accounts',
'type' => 'relate',
'link' => 'accounts',
'table' => 'accounts',
'isnull' => 'true',
'module' => 'Accounts',
'dbType' => 'varchar',
'len' => '255',
),

with:

'account_name' =>
array (
'name' => 'account_name',
'vname' => 'LBL_ACCOUNT_NAME',
'type' => 'varchar',
'len' => '255',
'unified_search' => true,
'comment' => 'Account name for lead'
),

2. Save the file.

3. Rebuild your module relationships by click on Admin->Repair->Rebuild Relationships. Note: Updated post with this step.

4. Rebuild your SugarCRM cache by going to Admin->Repair->Quick Repair and Rebuild and clicking Repair. Note: Updated post with this step.

5. Refresh your SugarCRM connection by logging out and back in.

[fedir]

Thank You a lot, Clint.
I think, it's the most professional and complete answer I had ever receive on OpenSource systems.

The solution worked fine, just in my case I made "fast repair" on the admin page to make it work.

Thanks again,
Fedir, Lyon

[clint]

Also for anybody else, be sure that you are on 5.0.0b. There is a list view bug in 5.0.0a that has many of the same symptoms around issues with export, mass update and list view delete. Between patch B and the code changes above, your Leads list view actions should work fine.

[ryanweeks]

Got this after applying fix:

Version 5.0.0b (Build 3150)

after applying per instructions, there is a general failure on log in:

Query Failed: AND users.id = '1'::MySQL error 1064:

log shows:

Fri Apr 4 03:28:16 2008,589 [2607] FATAL SugarCRM - Error fetching relationship from cache contacts_users
Fri Apr 4 03:28:16 2008,592 [2607] FATAL SugarCRM - MySQL error 1064:


Had to restore db and cache.

Any ideas?

[clint]

Got this after applying fix:

Version 5.0.0b (Build 3150)

after applying per instructions, there is a general failure on log in:

Query Failed: AND users.id = '1'::MySQL error 1064:

log shows:

Fri Apr 4 03:28:16 2008,589 [2607] FATAL SugarCRM - Error fetching relationship from cache contacts_users
Fri Apr 4 03:28:16 2008,592 [2607] FATAL SugarCRM - MySQL error 1064:


Had to restore db and cache.

Any ideas?

Looks like you missed the Rebuild Relationships step.

Rebuild your module relationships by click on Admin->Repair->Rebuild Relationships. Note: Updated post with this step.