Blank Rows in My Leads Dashlet

[cramermp]

Hey all. I'm working with SugarCRM CE 6.1.0.

I created a custom dashlet called "aging leads" that displays unconverted leads over 30 days old, sorted descending by age (which is a custom field calculated nightly with a SQL routine). I created the dashlet by copying the MyLeadsDashlet and modifying the values and file names and such.

The thing works great. Loads up with all the columns I specify and sorts great, filters appropriately by age, everything.

The problem is, when I add in the "My Leads" dashlet, either one or the other (My Leads or Aging Leads, whichever one comes last) loads up with blank rows. It doesn't behave consistently, though: sometimes, it loads up with no links. Sometimes a column is just missing. If I click the refresh dashlet button in the top right, the dashlet loads properly and displays like it should. Pretty annoying for my users, though.

Any advice on how to make these two dashlets work in harmony?

[kbrill]

I dont use CE as much as I should so I might be wrong on this but what I would do it to build a module with module builder that matches your module (fields, layouts and such) and then deploy it and then copy in your custom code. It should create a dashlet for you that should work.

[cramermp]

Forgive me for being ignorant, but isn't what you're describing essentially what I'm doing by copying and modifying the copy of the existing MyLeads dashlet?

To be more clear, I'm not using a custom module at all, just a custom dashlet for a default module that comes packaged with the product: "Leads."

I'll give it a try anyway; I have a module I built into the system a while back; I could grab its dashlet, but the idea is to use the information in the Leads module.

[kbrill]

Not as much as you might think. It should like somehow your two dashlets are getting confused as they think they are the same dashlet (it might be something else, without looking its just an educated guess). If you use a dashlet created for a custom module this can't happen.

I could probably go into the code and figure it out if you want to send me your code, I am sure its something easy but hard to find, it always is.

[cramermp]

After futzing with this stuff for hours...

I discovered that this problem is not limited to my custom code. In fact, it seems I have a bigger problem: Multiple dashlets of the same type break each other!

I added two "My Accounts" dashlets, two "My Leads" dashlets, etc. The error is consistent, but it's different for each dashlet. If I have two My Accounts dashlets, there are no columns displayed at all on the second dashlet. If I use my "aging leads" dashlet I get a couple of custom columns to display.

So one of the pieces of base functionality broke. I have no idea how. Any idea on where I can start looking for where this error is? I have another install of the same version and the problem does not occur there.

[davidboris]

Hello,

Let me know the SugarCRM version you are using.

If it is <= 6.1 version, change following line in include/Dashlets/DashletGeneric.php in function loadCustomMetadata

 //require_once($customMetadate);
require($customMetadate); 
  

[cramermp]

I'm running 6.1 CE.

Amazing! This works great! Thanks for the help! That's a huge monkey off my back.

I can't believe it was that simple. And then again, I can.