S
S
Shultc2014-12-19 09:02:03
CRM
Shultc, 2014-12-19 09:02:03

Database of people and events with webface. Are there ready-made solutions?

I’ll make a reservation right away: I reviewed many CRMs and basically they are an overkill for my tasks - I’m not going to sell anything. I wouldn’t want to write from scratch myself, because I don’t like bicycles.
There are a small number of people, let's say, for starters, up to a thousand. Now information about them is stored in Excel files, which is very irrational. I would like to hammer them into a small database so that it would be easy to manipulate information about them further.
Suppose this is a school, and I want to have a list of students and teachers to call them periodically on excursions and so on. This is a hobby, so I would like to have access both from work and from home, so I want to have a convenient page with access to information. It turns out a fairly simple Database, but it will be very dreary to cut a web-face for it for easy access. And it's not mine at all.
Are there any off-the-shelf solutions that aren't as overwhelmed as the CRMs I've looked at?
PS I imagine this as a simple combination of SQL + ServerSide (php?) + FrontEnd (JS).

Answer the question

In order to leave comments, you need to log in

3 answer(s)
A
asd111, 2014-12-19
@asd111

in theory, in the php yii framework, you can generate models from tables, then generate crud - i.e. webmord for adding, deleting and viewing elements and you're done.
Let's say you have tables students, teachers, excursions.
In Yii, you will need to go to the generic (Gii) to write the names of the tables or put * to generate all the models at once. Then generate CRUD for models and voila got at
/students - list of students
/teachers - list of teachers
/excursions - list of excursions
with the ability to change, delete, create
An example from the documentation
1. Creating a database and model, controller, view manually.
www.yiiframework.com/doc-2.0/guide-start-databases.html
2. Creating a model, controller, view automatically for the database from the previous example.
www.yiiframework.com/doc-2.0/guide-start-gii.html

V
Vit, 2014-12-19
@fornit1917

phpmyadmin :)

W
WordPress WooCommerce, 2014-12-20
@maxxannik

here is casepress.org/skaz-o-tom-kak-my-dvizhok-dlya-blogo...
1. we have secretaries to set up fields and categories for classifying persons, organizations or processes
2. we involve programmers only when some kind of horror is necessary fasten to the system
It will be difficult to find an alternative in terms of flexibility and coverage of all kinds of different spheres of life and detail of organizations.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question