salesagility/suitecrm

SuiteCRM - Open source CRM for the world

SuiteCRM 7.14.3

Website | Demo | Maintainers | Contributors | Community & Forum | Partners | Extensions Directory | Translations | Code of Conduct

SuiteCRM is the award-winning open-source, enterprise-ready Customer Relationship Management (CRM) software application.

Our vision is to be the most adopted open source enterprise CRM in the world, giving users full control of their data and freedom to own and customise their business solution.

Try out a free fully working SuiteCRM demo available here

Contribute

There are lots of ways to contribute to SuiteCRM

• Submit bug reports and help us verify fixes as they are pushed up
• Review and collaborate source code changes
• Join and engage with other SuiteCRM users and developers on the forums
• Contribute bug fixes
• Help translate language packs
• Write and improve SuiteCRM documentation
• Signing CLA - Only needs to be done once for all PRs and contributions.

Code Contributors

This project exists thanks to all the people who contribute and more.

You wanna buy the core team a coffee ☕ or beer 🍺? Then consider a small donation to help fuel our activities ❤️

Security

We take security seriously here at SuiteCRM so if you have discovered a security risk report it by emailing [email protected]. This will be delivered to the product team who handle security issues. Please don't disclose security bugs publicly until they have been handled by the security team.

Your email will be acknowledged within 24 hours during the business week (Mon - Fri), and you’ll receive a more detailed response to your email within 72 hours during the business week (Mon - Fri) indicating the next steps in handling your report.

Roadmap

View the Roadmap and LTS for details on our planned features and future direction.

Support

SuiteCRM is an open-source project. If you require help with support then please use our support forum. By using the forums the knowledge is shared with everyone in the community. Our developer and community team members answer questions on the forum daily but it also allows the other members of the community to contribute. If you would like customisations to specifically fit your SuiteCRM needs then please visit the website.

License

SuiteCRM is published under the AGPLv3 license.

suitecrm's Issues

Missing Modules on Install

When doing a fresh install from a git checkout, many of the modules appear not to be installed. Advanced Open Sales, for example.

This is mentioned on the forums at http://suitecrm.com/index.php/forum/installation-upgrade-help/10-solved-additional-modules-aos-groups-not-activated but the only solutions mentioned there are to grab the tar-ball from suitecrm's website (which doesn't help if you want to contribute patches, etc) or this hack:

To fix the issue I hacked a bit "install/perfomSetup.php" and added this at the beginning of the file (after <?)

include('custom/application/Ext/Include/modules.ext.php');
include('custom/Extension/application/Ext/Include/Advanced');
include('custom/Extension/application/Ext/Include/AdvancedOpenPortal.php');
include('custom/Extension/application/Ext/Include/AdvancedOpenReports.php');
include('custom/Extension/application/Ext/Include/AdvancedOpenSales.php');
include('custom/Extension/application/Ext/Include/AdvancedOpenWorkflow.php');
include('custom/Extension/application/Ext/Include/Google_Maps_20130815.php');
include('custom/Extension/application/Ext/Include/Google_Maps_20131011.php');
include('custom/Extension/application/Ext/Include/Reschedule.php');
include('custom/Extension/application/Ext/Include/SecurityGroups.php');

I'm sure that it is not proper way to solve the issue but I just wanted to highlight the problem.

which doesn't seem like a clean solution.

Failed to add custom scheduler job

http://support.sugarcrm.com/02_Documentation/04_Sugar_Developer/Sugar_Developer_Guide_6.5/02_Application_Framework/Job_Queue/01_Schedulers/01_Custom_Schedulers

The basic custom job failed to show in the create scheduler drop down list even QR&RB is done.

Cannot duplicate role - buttons cannot be seen/clicked

https://suitecrm.com/index.php?option=com_kunena&view=topic&catid=10&id=1685&Itemid=1136

Auto Update Target List

Hello!

It would be nice if you could implement a feature to auto update the target. Like here: http://www.epicom.com/blog/amandas-blog/auto-update-target-lists-in-sugarcrm

Have a nice day!

Upgrade 7.1.3 to 7.1.4 - Files version mismatch Database version

Upgrade to 7.1.4 (via Admin page, Upgrade Wizard) goes without error.
After last step, just as it's about to show the About page, it gives this error instead:
"Sugar CRM 6.5.17 Files May Only Be Used With A Sugar CRM 6.5.17 Database."
How to fix?
Probably will require a re-test and re-release of the upgrade package ?

Request: please provide a direct download URL from suitecrm.com for the main source zip

The JavaScript pop-up box for the download on suitecrm.com is all very pretty but is a nightmare for those of us who want to grab the zip directly server-to-server. The preferred method for those of us with real servers is to copy the link to the download, wget from the server and then unzip on the server.

The link provided by the JavaScript box is to a redirect web page, stopping us from using wget. We then have to download the file to a local machine using a graphical browser then ftp/scp it up to our servers. This means that the download/upload cycle runs at our home/work broadband speeds of not a lot.

If you provided a direct download link in the JavaScript pop-up box then we can use our fast server line-speeds to grab the source. The way it is now, it's an incredible waste of time and bandwidth.

Facebook not functioning

I receive an error when saving connector info, "There is no action by that name" and there is no field for Facebook username in contact.

Also, what are the chances of throwing in GOOGLE+ integration with this before final release? There is an implementation on sugarforge that could be adapted.

Tracking calls in nusoap

I have been finding a number of places where details of the site are being tracked. If this tracking was open and clear, I would be ignoring it, but it is obfuscated, so in looks it is up to no good and should be removed.

Here is one in includes/nusoap/nusoap.php around line 9315:

            if($operation== "\x73\x75\x67\x61\x72\x48\x6f\x6d\x65" && substr_count($this->endpoint, "\x3a\x2f\x2f\x75\x70\x64\x61\x74\x65\x73\x2e\x73\x75\x67\x61\x72\x63\x72\x6d\x2e\x63\x6f\x6d\x2f\x68\x65\x61\x72\x74\x62\x65\x61\x74\x2f\x73\x6f\x61\x70\x2e\x70\x68\x70") == 0 ){
                    $c2 = new nusoapclient("\x68\x74\x74\x70\x73\x3a\x2f\x2f\x75\x70\x64\x61\x74\x65\x73\x2e\x73\x75\x67\x61\x72\x63\x72\x6d\x2e\x63\x6f\x6d\x2f\x68\x65\x61\x72\x74\x62\x65\x61\x74\x2f\x73\x6f\x61\x70\x2e\x70\x68\x70", false, false, false, false, false, 15, 15);
                    $ping = $c2->call("\x73\x75\x67\x61\x72\x50\x69\x6e\x67", array());
                    if(empty($ping) || $c2->getError()){
                            $c2 = new nusoapclient("\x68\x74\x74\x70\x3a\x2f\x2f\x75\x70\x64\x61\x74\x65\x73\x2e\x73\x75\x67\x61\x72\x63\x72\x6d\x2e\x63\x6f\x6d\x2f\x68\x65\x61\x72\x74\x62\x65\x61\x74\x2f\x73\x6f\x61\x70\x2e\x70\x68\x70", false, false, false, false, false, 15, 15);
                            $c2->call("\x73\x75\x67\x61\x72\x48\x6f\x6d\x65", $params);
                    }
            }

The hex codes translate to:

sugarHome
://updates.sugarcrm.com/heartbeat/soap.php
https://updates.sugarcrm.com/heartbeat/soap.php
sugarPing
http://updates.sugarcrm.com/heartbeat/soap.php
sugarHome

I can do a pull request, but raising it for confirmation first.

Colour picker issues

Random error messages in logs, also colour does not change on admin menu, sugar action menu and a reset button to reset to factory/defaults is required.

Action lists aren't displayed in default theme

The emails module for example has an option to create templates, but the theme doesn't show that option.

Other themes give you the option in a dropdown menu or something similar.

AOP creating 2 emails on case creation

AOP creates 2 identical emails on creation of a case from the Joomla portal.

On 7.1 Beta 2 Install, Page-Breaks are missing between steps

Multiple Relationships from one module to another

Say you have relationships between Opportunities to Users but have 7 -8 relationships (1 user - Many Opportunities all the same)

when the second relationship is created the label from the first is recreated into the second language file, When the third relationship is created then the first and second label is recreated into the third language file and so on.

when the label is recreated it defaults back to the original value (In this case its "User"). This stops the labels from being updated in studio and resets all the labels to the end user.

AOS contact not populated in record generated via subpanel

See: http://www.salesagility.com/index.php/forum/8-aos-5x/3110-aos-5-3-3-contact-s-subpanel-contract-not-link#5299

[7.1beta2] Contact table not created properly on install

After install, database table for contacts was not created correct. Creating a contact resulted in an error. Quick repair does repair it:

/* Table : cases /
/COLUMNS/
/MISSING IN DATABASE - state - ROW/
/ INDEXES /
ALTER TABLE cases add COLUMN state varchar(100) DEFAULT 'Open' NULL ;
/ Table : contacts /
/COLUMNS/
/MISSING IN DATABASE - joomla_account_id - ROW/
/MISSING IN DATABASE - portal_account_disabled - ROW/
/MISSING IN DATABASE - portal_user_type - ROW/
/ INDEXES */
ALTER TABLE contacts add COLUMN joomla_account_id varchar(255) NULL , add COLUMN portal_account_disabled bool DEFAULT '0' NULL , add COLUMN portal_user_type varchar(100) DEFAULT 'Single' NULL ;

Print this page prints full page including header, which is cut off

https://suitecrm.com/index.php?option=com_kunena&view=topic&catid=10&id=2253&Itemid=1136

Add custom variable for email templates

Hello,

We would like to add custom variable for quotes when creating email template in AOW. The aims is pursuing the following points:

• When quote (invoice) change status send the email to accountant with links in suitecrm to the quote details
• In order to achieve this requirements we think we need to insert the id of the quote into the email template.

How can we achieve the requirement above? We can do the modification of the source code and contribute back to suitecrm. Please let us know which point we can attack and solve the issue asap.

Best regards,
Phuc

after update 7.1.x-> 7.1.3: package not listed correctly

after installing Upgrade 7.1.x->7.1.3 I get a wrong list of installed modules

it was perfectly listed during installation

path to css is hardcoded in modules/AOR_Reports/controller.php

The action downloadPDF in modules/AOR_Reports/controller.php has a harcoded path to a css file in:

$stylesheet = file_get_contents('themes/Suite7/css/style.css');

Here is a patch:

http://linkode.org/B4GLT1f1U1DnYlLwUvGA

I use $sugar_config... but may be we should use user preferences...

Some duplicate files that differ only in letter case

These files cause a problem when extracted to a case-insensitive OS. Example is:

custom\themes\images\icon_jjwg_Maps.png
and
custom\themes\images\icon_Jjwg_Maps.png

Both of these are in the 7.0.2 full install zip file. There are others, and could probably all be dug out with a scan of all the files and folders. If the intention is that SuiteCRM is not going to be compatible or supported on Windows, then this should not be a problem, but I suspect these are more likely erroneous files (e.g. renamed before pushing to git after git add and without using a git mv first).

Cannot Add New Tab on Home Page

Hi,

I think there might be a problem with the add tab functionality. I am getting the following error in my PHP log file when I try to add a tab:

[Mon Apr 14 06:22:19 2014] [error] [client 124.150.160.81] PHP Notice: Undefined variable: pages in /var/www/html/custom/modules/Home/AddDashboardPages.php on line 85, referer: http://crm.absolutevalue.co.nz/index.php

I will continue to search for a solution, but perhaps you could look into it.

Cheers,
NB

Portuguese Translation

hello,

I want to collaborate with Brazilian Portuguese translation of SuiteCRM. How can I help with that?

contactlist as subpanel

Hi!
This is just a feature request, I would be nice If in Contacs, Accounts and Leads would be a subpanel "Contact List". This would be doing things, like connect a account with an Campagne, much easier.
I just found a solution in German, but maybe you can build this in by default:
http://forums.sugarcrm.com/f48/kontakte-einer-kampagne-zuordnen-und-doppelte-zuteilungen-vermeiden-58261/
http://forums.sugarcrm.com/f48/kontaktlisten-als-subpanel-bei-interessenten-kontakten-zielkontakte-einblenden-85403/#post296704

Have a nice day

Initial Install, says Welcome to 7.0.2 in the 7.1 Beta Install

Error with spanish translation

Hi,

I have lot of cases when use the CRM who i see a "undefined" message when i'm using CRM on Spanish. As i can see, the js file with strings lacks some of them (They have one array empty).

Tested on latest version.

[PATCH] Bad CSV export on Reports module

The csv export do not escapes quotes ("), do not support new lines on field content, and can't be oppened without problems on excel. Also the http headers do not set the filename ok.

Here is a patch for the build_report_csv function on modules/AOR_Reports/AOR_Report.php

    function build_report_csv(){

        ini_set('zlib.output_compression', 'Off');

        ob_start();
        require_once('include/export_utils.php');

        $delimiter = getDelimiter();
        //text/comma-separated-values

        $user_agent = isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : '';
        if ($GLOBALS['locale']->getExportCharset() == 'UTF-8' &&
            ! preg_match('/macintosh|mac os x|mac_powerpc/i', $user_agent)) // Bug 60377 - Mac Excel doesn't support UTF-8
        {
            //Bug 55520 - add BOM to the exporting CSV so any symbols are displayed correctly in Excel
            $BOM = "\xEF\xBB\xBF";
            $csv = $BOM;
        }
        else
        {
            $csv = '';
        }

        $sql = "SELECT id FROM aor_fields WHERE aor_report_id = '".$this->id."' AND deleted = 0 ORDER BY field_order ASC";
        $result = $this->db->query($sql);

        $fields = array();
        $i = 0;
        $first_item = true;
        while ($row = $this->db->fetchByAssoc($result)) {
            $field = new AOR_Field();
            $field->retrieve($row['id']);

            $path = unserialize(base64_decode($field->module_path));

            $field_module = $this->report_module;
            if($path[0] != $this->report_module){
                foreach($path as $rel){
                    $field_module = getRelatedModule($field_module,$rel);
                }
            }
            $label = str_replace(' ','_',$field->label).$i;
            $fields[$label]['field'] = $field->field;
            $fields[$label]['display'] = $field->display;
            $fields[$label]['function'] = $field->field_function;
            $fields[$label]['module'] = $field_module;


            if($field->display){
                if(!$first_item)
                    $csv .= $delimiter;
                else
                    $first_item = false;

                $csv.= '"'.preg_replace("/\"/","\"\"", $field->label).'"';
            }
            ++$i;
        }

        $sql = $this->build_report_query();
        $result = $this->db->query($sql);

        while ($row = $this->db->fetchByAssoc($result)) {
            $csv .= "\r\n";
            $first_item = true;
            foreach($fields as $name => $att){
                if($att['display']){
                    if(!$first_item)
                        $csv .= $delimiter;
                    else
                        $first_item = false;

                    if($att['function'] != '' )
                        $csv .= '"'.preg_replace("/\"/","\"\"", $row[$name]).'"';
                    else
                        $csv .= '"'.preg_replace("/\"/","\"\"", trim(strip_tags(getModuleField($att['module'], $att['field'], $att['field'], 'DetailView',$row[$name])))).'"';
                }
            }
        }

        $csv= $GLOBALS['locale']->translateCharset($csv, 'UTF-8', $GLOBALS['locale']->getExportCharset());

        ob_clean();
        header("Pragma: cache");
        header("Content-type: text/comma-separated-values; charset=".$GLOBALS['locale']->getExportCharset());
        header("Content-Disposition: attachment; filename=\"{$this->name}.csv\"");
        header("Content-transfer-encoding: binary");
        header("Expires: Mon, 26 Jul 1997 05:00:00 GMT" );
        header("Last-Modified: " . TimeDate::httpTime() );
        header("Cache-Control: post-check=0, pre-check=0", false );
        header("Content-Length: ".mb_strlen($csv, '8bit'));

        print $csv;

        sugar_cleanup(true);
    }

AOP Status Drop Down Menu

https://suitecrm.com/index.php?option=com_kunena&view=topic&catid=10&id=825&Itemid=1136

New install fails when creating new user

It looks like dbConfig_a.php line 219 is spurious. When I remove it all works well. Please see this link for confirmation that this was also a problem in SugarCRM.

AOE tracking delegate acceptance

https://suitecrm.com/index.php?option=com_kunena&view=topic&catid=10&id=2118&Itemid=1136#8719

Too many error Strict standards on master branch, is it normal

And on fatal on install process ather click on next (choose english, click next)

( ! ) Fatal error: Call to a member function error() on a non-object in /home/bobby/Eclipse/workspace/SuiteCRM/include/utils/sugar_file_utils.php on line 87
Call Stack

Time Memory Function Location

1 0.0001 235008 {main}( ) ../install.php:0
2 0.0089 3584256 require_once( '/home/bobby/Eclipse/workspace/SuiteCRM/jssource/minify.php' ) ../install.php:69
3 0.0092 3613568 ConcatenateFiles( ) ../minify.php:62
4 0.0093 3649256 mkdir_recursive( ) ../minify_utils.php:142
5 0.0094 3650792 sugar_mkdir( ) ../dir_inc.php:119

Language bug - AOS

Chinese language not outputting correctly when PDF is produced from a record in an AOS module. Outputs [] instead of characters.

order_by DESC does not work via webservice

http://forums.sugarcrm.com/f6/need-help-how-sort-records-order_by-descending-order-84127/

JotPad with ampersand(&)

When a user saves data within the jot pad dashlet with any ampersand '&' symbols, any/all data is truncated/stripped out of the dashlet. Looks to be the way the URL is built in the dashlet.

Background image in PDF

Background image in mPDF doesn't show when the PDF is printed/generated.

Pipeline Dashlet duplication on homepage.

Changing/configuring dashlet sometimes causes dashlet to appear twice on the page and cover other dashlets. The dashlet cannot be closed, so the page needs to be refreshed to clear.

Ubuntu 12.04

Hello

May anybody has an list of additional packages, which i need for the install process of suitcrm?

The install process already failed!

thank in advanced, Frank

AOP update when case is created

AOP updates a case with the initial case message/email when sent via email.

Missing Viewdefs in Advanced Security

To reproduce:

Install 7.1.1
Go to: Security Groups Management: Configure
Click "Create" or "+" on top-right
Error is:
Error: File [modules/Home/metadata/editviewdefs.php] is missing. Unable to create because no corresponding HTML file was found

Missing Dashlet "MyActivity Stream" dashlet

Users cannot add the "My Activity Stream" dashlet to their homepages. This seems to be missing in Suite 7.1 but is available in previous editions. The dashlet is on the homepage by default but cannot be re-added if removed.

AOS Contracts delete issue

On deletion of a Contract, associated line items are not set to deleted. When creating a new contract, line items from the deleted Contracts show within the product/service groups.

7.1RC Top menu doesn't scroll sideways with page

In 7.0.2 you could make effective use of the main navbar when viewing on mobile device (eg iphone) however when you zoom in to page and drag right to select e.g. The admin menu, the top nav remains static on the page and you cannot access the right side of the nav bar

really easy, but

Hello

I have some issues to install suitecrm on vm (ubuntu).
so i try to find out, how i can start a installation again, without to delete and copy the files again.
do i didn`t find where i can set the installer of unlocked.
whcich file(s) i have to modify?

thank in advanced, Frank

Menus resetting on upgrade

On upgrade of SuiteCRM, module menus reset. Some disabled modules are enabled and group menus are sometimes reset.

Support pthreads

Can you make use of pthreads (PHP) in suitecrm? This would be make SuiteCRM a lot fast if you do for example a big "mass update" or running log queries.

Have a nice day!

Use tags and releases

There are no releases defined in this repository yet. They are a very handy way to create versioned releases that you can go back to, compare, and track. I recommend you make use of them, starting with the launched release.

At the moment all I see are work files, and have no idea whether the master branch is in a production usable state or not. Once a release is made, github automatically creates a downloadable zip file of that release.

Also README.md is empty. Use that as the introduction to this repository, including links to external documentation, and that will help put things into context.

A document that helps us to understand the development workflow wrt branches (master, dev, others) would also help people who wish to contribute.

please log ip adress

Hello!

Please support to log the IP Adress in the logfile. We can use this for fail2ban.

Email buttons stack in theme

https://suitecrm.com/index.php?option=com_kunena&view=topic&catid=10&id=2009&Itemid=1136

Bug and possible fix suggested.

SuiteCRM7.0.2 Installation Fail

Hi Everyone
I am having difficulty installing SuiteCRM7.0.2 on localhost as well as on my server.
Whenever i try to run the installation it says install.php not found.
Everything is right there at place.
Seem to lost
Trying to install a fresh SuiteCRM, never used SuiteCRM or SugarCRM before .
Any help would be highly appreciated.
Localhost runs on windows environment with wampserver with
Apache: 2.2.21
Php: 5.3.10
Sql: 5.5.20
Need Help.

after updating 7.1.x->7.1.3: undefined pop-ups

After updating 7.1.x->7.1.3:
when loading the home page I get a pop-up showing:

{"content":"

and I get "undefined" in many pop-up dialogs e.g.
for creating new tabs. Also buttons are labeled "undefined"

case assignment don't work

As in "least busy" as in round robin, case assignament don't work, and cases will assign always to admin (first user of suite crm)