Forums

Greetz,

Can anyone tell me if I have chosen the right tools here for my task:

1. I needed a user management system so I am trying out Joomla.
2. My users need to fill out 3-5 forms depending on what I am helping them with. I want this information in mysql tables so I can query it for reports and overal stats.
3. The users also need the abiltity to upload audio/video files.
4. Users need to be able to later edit this information.
5. The information must be private and protected from other users.
6. At some point the information has to freeze and they can no longer change it.

What do you think?

Hi techmiester ,

Yes, all this can be done*. It will need some PHP and Joomla! knowledge though.

Bob

* with the possible limitation on very large file uploads - that may need some alternative uploader.

Thanks for repying.

I have a little experience with php/mysql/ajax. None with Joomla.

1. My first question is how does (or would) Chrono link the Joomla's user id to the data, some might call this a foreign primary key. I assume there is an API call in Joomla for this if Chrono does not already handle this?

2. What is the maximum upload file size? Where are the files stored?

3. Is there a way to turn off/on certain forms to each user? Or perhaps grant permission via a group that has access to the form?

Hi techmiester,

My best suggestion is that you build a very simple form or two and test out some of your ideas.

1. If you Use the ChronoForms Create table command then the table will contain a cf_user_id column in which ChronoForms will save the user id of the current user (0 if they aren't logged in). Joomla! has a User Object that you can access to get current user info.

2. The limits on File Upload sizes are set by your ISP and the PHP configuration. ChronoForms can save them anywhere that it, i.e. the Joomla! user on the server, has write permission.

3. Yes. But Joomla! 1.5 has only a limited number of built in groups. Joomla! 1.6 is much more flexible in this area.

Bob