List Manager Forum
create internal survey lists on our site
Hi,
that kind of survey list can be configured creating a list with all required columns, and as you say, load data from csv to create the 'empty' records. Now you can remove these 3 fields from the new/edit form so they won't be modified by users.
From this point, we'd need more info to decide how to configure the 'access' for edition. Every user will see the whole list, then search for 'himself' and edit the proper record? Or will you need some strict control only allowing users to access their own records? In this case, you will need to have a different joomla user for each one, or have a way to identify the person introducing data. If you can provide more details on how you'll need to work we can give you the rest of the configuration steps.
Best regards
Silvia Martín
Moonsoft Team
Hi, thank you very much for the suggestions!
I think for normal cases, the first version – where every user can view and edit all data – is sufficient.
For specific cases, strict control where users can only edit their own data would be desirable.
The whole thing runs in the members’ area of our website. This means every user must be logged in and could be identified via their unique Joomla user ID. (We use Community Builder for user data, as we have fields – e.g. ‘Vocal range’ – that Joomla cannot handle.)
(The source of the CSV data is, of course, an SQL query, and it is no problem to enrich it with the user ID (..comprofiler.id or ..users.id))
best regards Karlheinz
Hi,
ok, the first option would be quite straightforward then, you only need to enable the 'inline' row edition for the editable columns, or remove from the input form the ones you don't want users to modify.
For the strict access, you would need to add to your new table an extra column with the joomla user_id, type it at the fields configuration as
Other-> 'user', and select at the page configuration 'display' -> Show only user records =Yes. That way the list will autofilter automatically to access only user records according to the current logged-in user. Of course you can publish this same table without this setting to show all records for your admin, for ex.
Hope this helps, please let us know if you need more detail about any of the steps.
Thanks, regards
Silvia Martín
Moonsoft Team
Hi Silvia,
thank you very much for the explanations regarding “strict access”. I’ve now tested it and it works very well. I’ve added the field `users.id` (in “numeric” format) to the existing user table (or rather, the database view for it). I have also added the ID to the actual survey table, in the ‘User’ format; this ensures that when importing data from the CSV export of the user table, the numeric IDs are interpreted as Joomla IDs in the target table and displayed as such.
Thank you once again for your help. Please feel free to close the ticket.
best regards
Karlheinz Bothmann
Perfect, thank you very much for the feedback. We close the ticket with that solution, please open a new one in case you have further questions.
Kind regards
Silvia Martín
Moonsoft Team
Hello,
I have a question about ListManager (it’s not urgent, but I haven’t been able to find an answer on my own)
We (a church choir) regularly need to create survey lists.
Typically, this means there are 3 columns generated by the administrator (via CSV import) from the membership database (Surname, First name, Voice) and X additional columns into which the choir members can then enter data. Example: ‘Concert 1’, ‘I’m singing in this’, ‘Concert 2’, ‘No’ etc...
It would also be nice if the three fixed columns could be set to ‘read-only’, but this isn’t absolutely essential.
Could you offer me some advice on this?
Many thanks
Kind regards
Dipl.-Ing. Karlheinz Bothmann