basxconnect

A core implementation of a CRM system for non-profit organizations.

Documentation at readthedocs

Vision

Providing non-profit organizations with a code framework that helps to build tools for managing their data.

Mission

Create and maintain a django-based framework which implements:

A standardized UI concept based on IBM's carbon design system
CRM-like core data models which are open to extension
Code building blocks and shortcuts which allow easy customization and extension

Core values

Open source development (this, however does not include free support)
Use of existing and proven technology where possible while minimizing external dependencies
Focus on workflows and tasks for Non-Profit organizations (User experience)
Writing code and APIs for developers, not for website administrators (Developer experience)
Development does not center around a final product but around the tools to create a product (because every product is different)

What we have so far

Integration of the core parts of carbon design in django ("like bootstrap for django")
CRUD-framework ("Quick generation of create/read/update/delete views")
HTML-layout framework which allows a more flexible hooking-in than the standard HTML-rendering mechanisms ("DOM on the server side")
Core model to manage people, communication and relationships
Additional modules for:
- Generating reports
- Generating documents and PDFs from word templates
- Custom add/edit forms
- Data import from PDFs with form-fields
- Customiable Database triggers to send notification emails
- Invoicing module
Demo project which implements a bare-bone version of a product (this repository)

What we still need to do

Improving the existing code base to have better support for extendability
Write documentation where necessary and add code-examples and how-to's
Implement revisions completely to allow going to a certain date and maybe display diffs

Other TODOs:

Explain more why basxConnect is necessary and the difference to alternative solutions

We would like to thank the following projects for their work, they provide a valuable base for basxConnect:

Translation: https://weblate.org/
Design System: https://www.carbondesignsystem.com/

Duplicate entry 'associationtype' for categories

I get this error in my nightly test build:
https://lbs.solidcharity.com/package/basx/basxconnect/basxconnect-test#main_centos/8/amd64

Applying core.0017_category_association_type...Traceback (most recent call last):
[00:05:34]   File "/home/django/basxconnect_demo/.venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
[00:05:34]     return self.cursor.execute(sql, params)
[00:05:34]   File "/home/django/basxconnect_demo/.venv/lib64/python3.6/site-packages/django/db/backends/mysql/base.py", line 73, in execute
[00:05:34]     return self.cursor.execute(query, args)
[00:05:34]   File "/home/django/basxconnect_demo/.venv/lib64/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute
[00:05:34]     res = self._query(query)
[00:05:34]   File "/home/django/basxconnect_demo/.venv/lib64/python3.6/site-packages/MySQLdb/cursors.py", line 319, in _query
[00:05:34]     db.query(q)
[00:05:34]   File "/home/django/basxconnect_demo/.venv/lib64/python3.6/site-packages/MySQLdb/connections.py", line 259, in query
[00:05:34]     _mysql.connection.query(self, query)
[00:05:34] MySQLdb._exceptions.IntegrityError: (1062, "Duplicate entry 'associationtype' for key 'slug'")

The reason is this commit: 37c2cdb#diff-ce51dd213b60c06bc89425fe749aa3807a3d17bb7084e4ae77d145604ab5411a

The category associationtype is now already added in migration 0006_preload_categories.py.
The category associationtype does not need to be added anymore in https://github.com/basxsoftwareassociation/basxconnect/blob/main/basxconnect/core/migrations/0017_category_association_type.py

I am not sure if the commit was a mistake, or if 0017_category_association_type.py should be adjusted.