Export to CSV Doesn't Work for Tasks

[datablueprints]

If I click on Activities, and then click on Tasks to view a task list, and I select the a bunch of tasks and click on Export, I receive an empty CSV file. The column headings appear, but the tasks do not.

This also happens when exporting Accounts to a CSV file. But, exporting Contacts and Leads works just fine.

Is there a fix for this?



PHP Version 5.2.5
Version 5.0.0b (Build 3150)
FreeBSD 6.2
MySQL 5.0.45
Apache 1.1

[dpatech]

You may want to check the sugarcrm.log logfile and see if there was an error running the query for the exports that are faliing.

[datablueprints]

You may want to check the sugarcrm.log logfile and see if there was an error running the query for the exports that are faliing.

Thanks. I looked at the log ... it's empty.

My gut feeling is it may have something to do with the fact that I've changed the layout of the list view for Tasks, but I'm only speculating.

[heta]

hi datablueprints,

i made changes in my list view & found that problem exists for me too..

then i found that if u change the layout of any module it will not export the data.

the problem exists because the checkbox doesnt carry the id of the record...

then i tried to change the code @ include/ListView/ListViewGeneric.tpl

i changed

$rowData[$params.id] to $rowData.id (on line no 99 for me.)

then it worked fine..

i dont know the side effect of the change as it is a general layout..

but for time being i havent found any problem...

i hope it helps

[datablueprints]

Thanks! That worked for me.

[shelzmike]

Heta -

Not to hijack a post here, but you mentioned something that may be related to a problem that I have. I am unable to export my accounts from the list view. (I am also unable to mail merge, or merge duplicates). However, this problem is only in Accounts, I can export others (such as Leads). You mentioned that you are unable to export if you change the layout of any module. Well, I did change the layout of the Accounts List View, so could that be my problem. Now, before you answer, I have also changed the layout of my Leads (Detail, List, and Edit Views) yet I CAN export those.

As far as the Accounts export, I should clarify - I actually CAN export but ONLY if there is no assigned user. If there is an assigned user, no mater how many Accounts I check, I get a pop up that says "Please select at least 1 record to proceed".

I have 100% verified this is the problem. Here is how - I had account X that had an assigned user. Tried to export - I get the pop up/no-go. I go in to edit it, clear the assigned user, save it. I select it and hit Export and voila! It lets me.

This is weird. Obviously, I need to not have to remove the assigned users just to export. Any thoughts on this?

Thanks!
Mike

[sheetalM]

Thanks heta,

My problem is solved bcoz of your solution.
Actually I am getting popup "Please select atleast one record",when I am selecting one or two records from list.
Now it is solved.
Thanks

[clint]

As far as the Accounts export, I should clarify - I actually CAN export but ONLY if there is no assigned user. If there is an assigned user, no mater how many Accounts I check, I get a pop up that says "Please select at least 1 record to proceed".

Hi Shelzmike -

This is a bug that is getting fixed in an upcoming 5.0 patch. If you have the user or team column as the last column in the list view, then none of the list view functions (export, mass update, delete) works.

The workaround is to move these clickable columns out of the final column position in the list view.

Clint

[clint]

then i tried to change the code @ include/ListView/ListViewGeneric.tpl

i changed

$rowData[$params.id] to $rowData.id (on line no 99 for me.)

then it worked fine..

Hi Heta -

I think we are already tracking this issue for the 5.0 Colombia patch. But to be sure that we track the fix you kindly provided, I have created bug 21108 which includes your fix.

Thanks!
Clint

[shelzmike]

Clint -

Fantastic! I am just glad that it is a known issue and not something that I have done. These functions are not something that I need to use everyday, so I could just move the column out, do what I need to, then move them back. THAT I can deal with for now. Thanks everyone for the help I was staring to pull my hair out a bit! Have a good one.


Mike