SplendidCRM Professional Edition

SplendidCRM Professional Edition

Get Started

SplendidCRM Professional is provided here to allow you to evaluate the software. It is still governed under the SplendidCRM Source Code License, so it is not free. If you use this software in production, you are expected to obtain a license for each user.

The quickest way to get started is to request our installer. The installer will do practically everything you need to get a SplendidCRM site up and running, with the exception of installing SQL Server Express. Or, you can download the latest from GitHub and build the app yourself. Please contact our sales team to license SplendidCRM Professional.

Minimum Requirements

1. Windows 10 or higher, Windows Server 2012 or higher.
2. ASP.NET Framework 4.8. Download ASP.NET 4.8 Runtime
3. Visual Studio 2017 or higher. Download Visual Studio 2019
4. SQL Server Express 2008 or higher. Download SQL Server Express 2019
5. SQL Server Management Studio. Download SQL Server Management Studio 18.10
6. Node version 16.20 for Windows 64-bit. Download Node 16.20
7. Yarn version 1.22. Download using npm: "npm install --global yarn"

Using the Installer

The goal of the installer is to do everything necessary to get the system running on whatever version of windows you are running. We typically include SQL Server Express with the installer to save you that step, but if you already have SQL Server installed on your network, you can use the smaller Upgrade download. The app will do the following:

1. Install all files for the app. This action is performed by the typical InstallShield app.
2. Run SplendidCRM Configuration Wizard to configure Windows. This is where the real work is done.
3. Install IIS if not already installed.
4. Add IIS features that are required for the app.
5. Add SplendidApp application to IIS.
6. Connect to the database. SQL Server can be remote or local, all that is important is that you can connect. The installer includes an initialized database, which will be attached if an existing CRM database is not detected.
7. Create or update all tables, functions, views, procedures and/or data to run the app.

Building Yourself

When building yourself, please note that we prefer to build the ASP.NET code separately from the React code. We do this so that Visual Studio does not take too long to debug as it will attempt to build both every time something small changes. So, we have marked the React files as content and excluded them from the build in the Visual Studio project file. With this in mind, we have included two csproject files, one with the React files exluded from the project (_VS2013), and the other with the React included but as content (_VS2017). This allows use to separate build from development.

ASP.NET Web Site Build

Building should be as simple as loading the SplendidCRM5_VS2017.csproj project file into Visual Studio 2017 or higher. SplendidCRM uses very specific builds of certain external libraries so as to minimize version dependencies across libraries, we do not use package manager. Instead, we have included a BackupBin2012 folder with those libraries.

1. AjaxControlToolkit.dll
2. Antlr3.Runtime.dll
3. Asterisk.NET.dll
4. BouncyCastle.Crypto.dll
5. CKEditor.NET.dll
6. Common.Logging.dll
7. DocumentFormat.OpenXml.dll
8. Google.Apis.Auth.dll
9. Google.Apis.Core.dll
10. Google.Apis.dll
11. ICSharpCode.SharpZLib.dll
12. MailKit.dll
13. Microsoft.AspNet.SignalR.Core.dll
14. Microsoft.AspNet.SignalR.SystemWeb.dll
15. Microsoft.Exchange.WebServices.Auth.dll
16. Microsoft.Exchange.WebServices.dll
17. Microsoft.IdentityModel.dll
18. Microsoft.IdentityModel.Extensions.dll
19. Microsoft.IdentityModel.JsonWebTokens.dll
20. Microsoft.IdentityModel.Logging.dll
21. Microsoft.IdentityModel.Protocols.dll
22. Microsoft.IdentityModel.Protocols.WsFederation.dll
23. Microsoft.IdentityModel.Tokens.dll
24. Microsoft.IdentityModel.Tokens.Saml.dll
25. Microsoft.IdentityModel.Xml.dll
26. Microsoft.Owin.dll
27. Microsoft.Owin.Host.SystemWeb.dll
28. Microsoft.Owin.Security.dll
29. Microsoft.ReportViewer.Common.dll
30. Microsoft.ReportViewer.DataVisualization.DLL
31. Microsoft.ReportViewer.ProcessingObjectModel.DLL
32. Microsoft.ReportViewer.WebForms.DLL
33. Microsoft.SqlServer.Types.dll
34. Microsoft.Threading.Tasks.dll
35. Microsoft.Web.Infrastructure.dll
36. MimeKit.dll
37. Newtonsoft.Json.dll
38. oAuthConnection.dll
39. Owin.dll
40. PayPal.dll
41. RestSharp.dll
42. Spring.Rest.dll
43. Spring.Social.Core.dll
44. Streaminvi.dll
45. System.IdentityModel.Tokens.Jwt.dll
46. System.IdentityModel.Tokens.ValidatingIssuerNameRegistry.dll
47. System.Web.Optimization.dll
48. Tools.dll
49. TweetinCore.dll
50. Tweetinvi.dll
51. Twilio.dll
52. TwitterToken.dll
53. WebGrease.dll
54. Zlib.Portable.dll

React Build

We recommend that you use yarn to bulid the React files. We are currently using version 1.22, npm version 6.14 adn node 16.20. These versions can be important as newer versions can have build failures. The first time you build, you will need to have yarn install all packages.

yarn install

Then you can build the app.

yarn build

The result will be the file ReactdistjsSteviaCRM.js

SQL Build

The SQL Scripts folder contains all the code to create or update a database to the current level. The Build.bat file is designed to create a single Build.sql file that combines all the SQL code into a single Build.sql file. If this is the first time you are building the database, you will need to create the SQL database yourself and define a SQL user that has ownership access. We have designed the SQL scripts to be run to upgrade any existing database to the current level. In addition, we designed the SQL scripts to be run over and over again, without any errors. We encourage you to continue this design. It includes data modifications that are designed to only be applied once. The basic logic is to check if the operation needs to occur before performing the acction.

if ( condition to test ) begin -- then operation to perform end -- if;

If you are wondering why we use "begin -- then" and "end -- if;" instead of simply "begin" and "end", it is so that we can more easily convert the code to support the Oracle PL/SQL format.