Hi Marios, I think Magnolia would be a very good match for what you are doing.
Some thoughts about your questions: · Integrating LDAP should present no major difficulties · JCR should have no difficulty storing your data - unless you introduce your own node-types (which you could, if you wanted) to constrain the permissible values JCR is basically a big hierarchical "entity attribute value" model. · It should also be quite easy to import data from existing sources, either using simple "Loader-Programs", or via XML as an intermediary format · I would be careful about storing "large tables" in JCR - e.g. storing departments, courses and staff will present no problems, but storing students might be more tricky if you have 30000 students, and storing student-to-course mappings is probably better done in a relational DB. · Modeshape represents a possible solition to storing larger datasets and integrating external datasources into JCR (but the magnolia integration of Modeshape is fairly new, so I would test that carefully) · Your Forms can be easily created, either building on magnolia's forms module, or by creating your own forms with accompanying model classes, or by using blossom or possibly some other integration · You'll have to think about how to build your architecture: content is normally created on an author instance, and published to the public instances. Forms are usually filled by users on the public instance. Where should the data be stored? Do you need a clustered JCR repository so author and public can see some of the same data? Things like that... Regards from Vienna, Richard Von: [email protected] [mailto:[email protected]] Im Auftrag von Marios Skounakis Gesendet: Sonntag, 22. Jänner 2012 20:57 An: [email protected] Betreff: [magnolia-user] Is Magnolia suitable for this scenario? Hi all, I have not had any experience with Magnolia but I have been looking at it for a couple of days as a candidate for basing a new system that I have to develop. The system's requirements are as follows: - The application must model a university at a basic level - schools, departments, courses, programmes, teaching staff, students. - The goal of the application is that the content managers must be able to create forms for gathering data about courses, professors, departments, etc. They need to be able to change these forms by adding or removing fields. Examples of forms - a professor information sheet that contains info such as publications, research, other activities, etc) (one such form to be completed per professor) - a course evaluation form to be filled in by students (one such for per course and student) - a programme statistics form with statistics such as the number of graduates, average tuition duration, etc (one such per programme). - Users must be able to log on to the system and fill in the forms for which they are responsible (e.g. a professor to fill in his information sheet, a student to fill in evaluations for his courses, a secretary to fill in the programme statistics sheet). I was originally planning to implement this application with the Spring Framework and a MySQL database. The data would be stored in a typical relational model, except for the form data which would follow a variation of the Entity-Attribute-Value model. Then we decided that it would be useful to have some simple CMS functionality such as the ability to create pages with static html content, manage news, have a simple FAQ section, maybe a feedback form, maybe forums. So we started wondering whether it may be better to use a CMS as the basis of the application and extend it with the university data modeling and our forms functionality. It seems to me that Magnolia is suitable for this system. I am thinking that I can get the basic CMS and user functionality from Magnolia and then find a way to integrate into Magnolia the part that handles the forms (perhaps by implementing a module or by using Blossom or some other way). So I would like to ask the list if Magnolia can be easily used for this kind of task, or if, for someone not familiar with Magnolia, will it be very hard to master it and integrate it with a custom application? I also have some more questions: - Would it be possible to use the JCR to store the university data? Normally I'd use a standard relational model for these. Are there efficient mechanisms for updating and querying the JCR? A lot of the university data will be migrated from other systems - is this easy to do with the JCR? Is it possible to use Magnolia to provide a basic interface for managing this data using the dialog functionality? - If not, is it possible to use MySQL for Magnolia's data and add some SQL tables to the same database to handle the university data? - For storing the form data I was originally planning to use a variation of the Entity-Attribute-Value model. Can this be handled by the JCR or is it better to use a SQL table? - There is a requirement that all components used must be GPLv3. This excludes the LDAP module which is proprietary. Will it be very hard to implement LDAP integration from scratch? Assuming that the part of the system where users fill in the forms can be a separate page and not part of a page, what would be the easiest/most clean way to implement it? Thank you very much in advance. Marios Skounakis ________________________________ ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]<mailto:[email protected]>> ---------------------------------------------------------------- ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
