I'm about to start a little project and since I'm new to CMSMS will I try to specify my final product and would be very thankful if someone could guide me to if there are modules that might be suitable to use.
I would like to build a fairly large mysql database that front end users will search within. A module for constructing and presenting such a search would be nice.
The users should also be able to edit single records and those changes should be put on hold until an administrator accepts it.
Users should also be able to upload files containing tables to incorporate in the DB. Validation of data is desirable.
Please, guide me!
Regards
Cognatus
Can CMSMS do the work for me?
Re: Can CMSMS do the work for me?
It sounds like you need a custom solution for your problem. Maybe if you describe it in more detail we can help you finding existing modules that do what you want.
CMS MS won't "do the work for you" but it will surely be a very good base to begin with. It's very easy to make modules for things like this.
CMS MS won't "do the work for you" but it will surely be a very good base to begin with. It's very easy to make modules for things like this.
Re: Can CMSMS do the work for me?
OK, I will try to describe it more in detail.
The mysql database will contain about 30 or more columns of data. The data is collected from several different kinds of sources but some fields are common.
The data derives from transcripts, from old historical documents, done by the users of the webbpage. The data may be text (names, places, sources, etc.), dates, links etc.
----
1.
I want to build a search function to search within the database. The searches may be free text and/or predefined parameters.
I want to present the hit list of that search at the same page as the search function, so another search can be done without stepping back to the search function.
That list shall contain about 10 fields for each record, but with the ability to view the whole record if the user wants to. Sorting records based on column data is preferable.
------
2.
I also want to present predefined lists for the different kinds of sources available in the database. These will be presented at a different place at the web page.
-----
3.
If a users finds a transcription that he thinks is incorrect he shall be able to post a correct version and upload it to the database. But not without approval from an administrator.
-----
4.
The users may transcribe new sources of information, probably into a predefined excel sheet, and from that sheet generate some kind of file that can be uploaded to the database. A function for this upload is necessary.
This data in the file needs to be validated before entered in the database so essential fields are filled in and that data is formatted the correct way.
When a user has made an upload of a valid file it needs to be approved by an administrator.
-------
This is as good as I can describe it since I'm still just planning.
Regards
Cognatus
The mysql database will contain about 30 or more columns of data. The data is collected from several different kinds of sources but some fields are common.
The data derives from transcripts, from old historical documents, done by the users of the webbpage. The data may be text (names, places, sources, etc.), dates, links etc.
----
1.
I want to build a search function to search within the database. The searches may be free text and/or predefined parameters.
I want to present the hit list of that search at the same page as the search function, so another search can be done without stepping back to the search function.
That list shall contain about 10 fields for each record, but with the ability to view the whole record if the user wants to. Sorting records based on column data is preferable.
------
2.
I also want to present predefined lists for the different kinds of sources available in the database. These will be presented at a different place at the web page.
-----
3.
If a users finds a transcription that he thinks is incorrect he shall be able to post a correct version and upload it to the database. But not without approval from an administrator.
-----
4.
The users may transcribe new sources of information, probably into a predefined excel sheet, and from that sheet generate some kind of file that can be uploaded to the database. A function for this upload is necessary.
This data in the file needs to be validated before entered in the database so essential fields are filled in and that data is formatted the correct way.
When a user has made an upload of a valid file it needs to be approved by an administrator.
-------
This is as good as I can describe it since I'm still just planning.
Regards
Cognatus
