This blog was great and ultimately gave me enough info to get this done, however, it wasn’t for a rookie in MYSQL since the whole part about ‘deleting rows’ assumes you know how to delete a row. It looks like I also wrote a cpanel version of the same need a few years back. Also I elected to turn off…
Tag: SuiteCRM
Changing or Fixing the Site URL for SuiteCRM
Recently I moved my SuiteCRM from a slow shared host over to a Digital Ocean droplet to speed things up. It worked very well, by the way. So fast, and probably I save 10 minutes per day just not waiting for server, haha. Anyways, everything went pretty well except one thing: the emails that were sent out from the Workflow…
How to Change Discount Type (Amount, Percent) Default Value in SuiteCRM
Sadly this wasn’t easy. In the Quotes / Line items module, when you are entering the type of discount there are two types by default: Amount (Amt) and Percent (Pct). Someone asked me to change the default from Pct to Amt. I logged in as admin, went into Studio, went to the Line Items module, went to ‘Fields’ and, like…
How to Make a SuiteCRM Production Subdomain on Digital Ocean Ubuntu Server
I thought this specific tutorial might help others who have the same set up as me: in need of setting up a test environment for trying custom SuiteCRM code before deploying it. A developer may wish to give you some code, log in and patch it themselves for testing, etc, or, you might want to try something without breaking something.…
How to make SuiteCRM Localhost Test Environment
Somehow I got pretty far in life in age and suffering, managed to figure out how to install SuiteCRM on an ubuntu server and basically maintain it (even back it up) but one day I needed to test some custom code on a non-production machine. This is when I realized that I didn’t know (at all) how to make Apache2…
HOW TO INSTALL SUITECRM ON UBUNTU SERVER
Suitecrm is absolutely awesome, free and open software to run your organization or business. I’ve messed around with various crm’s like Salesforce but SuiteCRM is just so flexible. Oh, and it doesn’t cost any money. Oh, and if you need help or other stuff you can just pay people to build what you need. I haven’t explored all sectors but…
SuiteCRM Post-Installation Housekeeping
If you’ve been following along any of my other SuiteCRM (“SCRM” from hereon in) blog posts, you’ll know that I’m a big fan of this free and open SuiteCRM software project. As such, I do my best to document things that are either easily forgotten or difficult to find online. Hopefully some of this is valuable to you. 1 –…
HOW TO MODIFY THE DISPLAY OF SUITECRM PRODUCT LINE ITEM ROWS IN QUOTE MODULE
It seems like I’m writing a series here on these SuiteCRM (‘SCRM’ moving forward) topics these days so I might as well keep going! If you haven’t read them, these might be of interest: How to change the Row Headers in SuiteCRM Line Items in Quotes Module How to Back up your SuiteCRM stuff on Ubuntu Server For this one,…
HOW TO CHANGE THE ROW HEADERS IN SUITECRM LINE ITEMS IN QUOTES MODULE
PRE-CHAT As always, SuiteCRM is one of my favourite business tools in the free and open software world. I like to describe it as ‘Sales Force on steroids’ because you can do whatever you want with it, basically, since the code is open and community supported. However, once in a while you will hit a road block. This literally took…
How to Back Up your SuiteCRM Stuff on Ubuntu Server
Been a big fan and user of SuiteCRM for years. Never really did learn how to properly back up from my own server so yeah. Time to do it! Backing up your SuiteCRM MYSQL Database This is not for saving the files (ie. the custom settings you have made to SuiteCRM over the years and all the PDF templates, workflows,…