Open source CRM
Splendid App Builder Get Started
The quickest way to get started is to request our installer. The installer will do practically everything you need to get a Splendid App Builder 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.
Minimum Requirements
Using the Installer
This is the same installer that we have been using for the last 15 years with our other SplendidCRM products. 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 we have decided not to do that with this product. The app will do the following:
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.
ASP.NET Web Site Build
Building should be as simple as loading the SplendidApp.csproj project file into Visual Studio 2019 or higher. If this is the first time you are building the app, then you will need to use the NuGet package manager to download all required packages. We don't use a lot of packages, the following is the current list:
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 12.18. 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 React\dist\js\SteviaCRM.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.
Twice a month we will interview people behind open source businesses. We will talk about how they are building a business on top of open source projects.
We'll never share your email with anyone else.