How to change the db-entries to export?

[mccon1]

Hi,

I am running SugarCRM Community Edition Version 5.2.0i (Build 5757).

When I click on "Export" in the Contacts section, I get a .csv which I open with MS Excel. But in the File are 46 rows which I mostly don't need (like ID, date_entered, date_modified, modified_user_id...). How can I change the system to export only first_name, last_name, department, account_name and assigned_username?

I looked at the /export.php and at the /includes/export_utils.php, but when I comment out the stuff I don't need in the $contact_fields - array, it doesn't change anything.

Any ideas?

regards,
mccon1

[salesagility]

The simplest way, rather than hack the code in a way that almost certainly will not be upgrade safe, is to load Zucker Reports from the SugarForge (http://www.sugarforge.org/forum/?group_id=30) and to do a simple report using the fields that you need. This can be exported to .csv.

[mccon1]

Thanks for the advice! But I couldn't install the module:

I uploaded the ZuckerReportsCE_1.11_module.zip with the Module loader. I think the upload went fine, because I see a ZuckerReports CE line in the buttom frame. When I click on "Install" and then on "Commit", the status bar moves to 100% and the log says this:

Display Log
Installing Images
Installing menus
Rebuilding Menus...
Removing Sugar Dashlets cache and scanning known directories for Sugar Dashlet files.

Sugar Dashlets cache file rebuilt.Installing Relationships
Rebuilding Vardefs...
Rebuilding Layoutdefs...
Rebuilding administration Section...
Installing Language Packs
Rebuilding Language...en_us
Rebuilding Language...ge_ge
Rebuilding Language...es_es
Rebuilding Language...fr_FR
Installing Bean : ZuckerReports
Installing Bean : ZuckerReportContainer
Installing Bean : ZuckerReportModuleLink
Installing Bean : ZuckerReportParameter
Installing Bean : ZuckerReportParameterLink
Installing Bean : ZuckerReportTemplate
Installing Bean : ZuckerWordTemplate
Installing Bean : ZuckerQueryTemplate
Installing Bean : ZuckerListingTemplate
Installing Bean : ZuckerListingTemplateFilter
Installing Bean : ZuckerListingTemplateOrder
Installing Bean : ZuckerRunnableReport
Rebuilding Relationships
Complete
Including: /srv/www/htdocs/MyDBName/cache/upload//upgrades/temp/MXIxG2/scripts/post_install.php
Query Failed:INSERT into zucker_reportcontainer set id='bca6cf17-e41c-6241-7dde-4acc53004274', deleted='0', date_entered='2009-10-07 08:40:27', date_modified='2009-10-07 08:40:27', modified_user_id='1', created_by='1', name='2007', team_id='none', assigned_user_id='1'::MySQL error 1146: Table 'MyDBName.zucker_reportcontainer' doesn't exist

Although is says 100% and "Complete", it doesn't show up in the Module Loader on the top frame as an installed module. Whats wrong? Isn't the module supposed to create its own table "zucker_reportcontainer"?

Any Ideas? I also posted this question on the SugarForge ZuckerReports Forum.

regards,
mccon1

[mccon1]

Hi,

I think I can't install ZuckerReports, on the SugarForge ZuckerReports Forum I also didn't get a response.

Now I'd like to know again how to change the db-entries to export in the code directly. I don't care if it is not upgrade safe, since the installation will be for a short term project.

Any help would be much appreciated!

regards,
mccon1

[mccon1]

Ok, since that doesn't seem possible, I know like to create an extra page with a export of the data. I already managed it to display a list of the contacts, but I now like to display also the corresponding activities. But I don't find them in the database, can anyone tell me where I can find them? And maybe someone already has a SQL query for that...

regards,
mccon1