Imported leads exist in DB, invisible everywhere

[nyaconis]

Hello,
I'm using Sugar CE 5.1 and have imported 788 Leads using the import module. I imported the leads as Admin. I an see the 788 records in the database, all are assigned to user_id 1, admin. When in the dashboard, or the lead module, there are no leads listed.

Another note, even when creating a lead through the editor saves the lead and brings up the edit screen, but after saving and closing lead does not become visible.

What are some things I cacn check or why wouldn't these be appearing in the list?

I've attempted to debug this to see if anything is even being pulled into a list. Here is the generated sql for the list_view function:
SELECT leads.*, users.user_name assigned_user_name,leads_cstm.* FROM leads LEFT JOIN users ON leads.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel eabl ON eabl.bean_id = leads.id AND eabl.bean_module = 'Leads' and eabl.primary_address = 1 and eabl.deleted=0 LEFT JOIN email_addresses ea ON (ea.id = eabl.email_address_id) LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c where leads.deleted=0;

This works fine and pulls in all the records when running against the db. When i add error logging to functions that actually build the lists, i'm not seeing anything fire other than generating the query.

[nyaconis]

Ok i found the issue.

Having more than 4 custom integer fields with a Lead module, the leads will dissapear from display.

to reproduce, add more than 4 custom integer fields of any size.

[roblaus]

I may add here: The same "feature" works in accounts - more than 4 custom fields (tried it with text and integer) make the list view disappear. Once you delete the 5th field the list view is back in all its glory.
Did you file a bug?

rgds

[tuitai]

Hello,
I have same problem with leads; any update or link to a bug filed?
Thanks,
-Tige

[roblaus]

Not yet. Will check an file one if there isn't any yet

[barrettp]

Dang,

What is the workaround. I have a database I am trying to import but I need more than 4 or 5 custom fields to make SugarCRM worthwhile.

And it appears the data is there.

[barrettp]

Version 5.1.0 (Build 4732) Complete Stack Install

Created about 8 custom fields in "Clent" module with Studio

Then select "Client" tab to go to Clent section

Click "Import"

Selected "Tab" import

Browsed to data text file

Matched fields with respective import field

Ran import

No errors, 3,900 records imported

Click on "Clients" to view imported

No records visible

Try search for known record

No record shows

I think it may be related to this thread's problem but not sure. I really need those custom fields.

Any ideas?

Thanks,
Barrett

[roblaus]

Filed a bug - No. 24954

rgds
rl

[enrashid]

This is just to make sure that it is not just the Sugar import tool that is causing the problem:

If you create a lead record through the interface as different users, can the records be seem appropirately based on the all the visibility and permission rules you have set up.

If the answer is yes (which is good), I would then look at the underlying database tables to find out what tables/fields got touched and you may have to import data into those tables NOT using the Sugar import tool, but using SQL or some equivalent tool that imports directly to the tables.

I had to do this with the out of the box Contract module since there was no import facility at all and link it with the Account module. All is good.

Now to do a simple test to simulate using an SQL import, access the database tables effected and manually put in entries in the tables/fields that were somehow missed by the Sugar Import tool.

[barrettp]

My short fix was to import the database using fewer than 4 custom fields and then add the fields once imported. Also, for the record, I was able to import 39,000+ contacts at one time.