List Manager Forum
questions / problems with editing data
Hi again,
I just reactivated your supadmin account.
See private data.
I urgently need to be able to add new records be it from the front or from the back-office : for now, it's impossible from either.
The console just throws me a bunch of errors.
Thanks,
--
Pascal
Hi,
regarding the first question, about how to configure different permissions for front or back-end, you need to configure a 'manager' for you that will only be accessed through the backend. Select your list, press 'copy', and introduce your manager options (edit, delete...etc) at this new layout. We already did this (you will see a new Manager annuaire... )and added the 'new' button. Now you have one layout/set of options that you have published for front end, and your backend manager with all rights and different options if required, while both handle the same database table.
Then we tried to create a new record, and we got a server error 403 Forbidden- Access to this resource on the server is denied!
This means your server is rejecting the calls due to any restriction/wrong permissions setting. We suggest to check your server error log to find out more details about which is the origin of the issue, and ask for help to your server support to fix, because it can be any server firewall, wrong htaccess file, any security plugin,wrong file permissions...., that is wrongly stopping valid requests (it may be of help mentioning those calls are ajax calls, it can be useful to identify the security rule to be adjusted).
Let us know if we can be of more help.
Best regards
Silvia Martín
Moonsoft Team
OK. Thanks Silvia.
I figured it would be something like that. It's all right for the back end but I also need that some users with appropriate permissions may edit / add / delete records from the front-end. Is your solution doable for front too ? I sure hope so.
Sorry for bothering you with my stupid second question, I should have known it would be the damn firewall again.
Thanks anyway, I just deactivated one of its rules and could indeed save a new record.
Best regards,
--
Pascal
Hi,
perfect, great it worked :)
In order to set different permissions for certain users at the front-end, you can use a combination of different layouts together with the default Joomla permissions. Let's say you want 2 groups of users, one 'read-only' group, and a set of 'managers' able to edit data.
You'd need to create one read only layout, and and another one with the required options (using the copy option explained above).
Then publish the 2 modules at the page, but configuring the 'access' parameters for different access levels (you can create your own access levels, from this point the configuration will follow default Joomla access features). Users assigned to the 'read-only' group will see one of the layouts, while the others will see the 'managers' layout with extra options.
If you don't use modules but a direct menu item, Joomla also allows you to configure which Joomla group(s) will be seing each item, so it would work the same way, linking one different item to each layout, and then restrict the access using default Joomla acl settings.
Hope this helps, please update again in case you need more details.
Best regards
Silvia Martín
Moonsoft Team
OK Silvia, I get it.
Thank you so much !
I think this will be no problem.
Something else though : I tested uploading a csv file and it did not work.
Here is what i did :
- In the back-end, I exported the table lm_countrylanguage from the Manage Data page with Export to CSV
- I then edited the csv file : modified one entry, deleted some, added one
- I used Add data from csv file and uploaded my modified file
- I got the error :
Une erreur est survenue
1136 Column count doesn't match value count at row 1
I tried different things to try and mitigate the error but to no avail :
- removed the titles line
- removed the line I added
- verify my edit to make its values match with existing values
I always get the same error.
NB : I did verify my firewall history, and no, it's not the culprit.
I need to update my data, so I would like to know what I did wrong and what is the correct way to update with CSV file please.
Thanks,
--
Pascal
Hi,
the data to be added needs to match exactly with the columns present at your database table, you can see them at your fields/columns configuration, for your country languages table the list would be
id, CountryCode, Language, IsOfficial, Percentage
so a csv file with this content
1000,XXX,Test,F,9.5
should do the work.
However, when you export the csv, there is a column not being included, which is the internal ID. If you want to use this export as a template, you can open it with excel, add this first column (it's just a counter) and then export to csv. Please note the internal ID should be unique across the records, you can add new records using different ids, or, if your goal is to replace the whole table reusing same ids, you can remove all its contents first (empty table option) and then reload all records from the csv.
We suggest to try first with an addition of a single record, to ensure file format, columns and values are ok before proceeding with a full refresh.
Hope this helps,
Regards
Silvia Martín
Moonsoft Team
Thanks Silvia for the explanation : import does not work without an ID column…
But, I can't check already used IDs because there is no way to display them in LM (or I did not find it), so if I have to update my table on a regular basis, I'm somewhat stuck and have to guess new IDs series for each upload. Am I right ?
--
Pascal
Hi,
in fact you can display this column, because it shows at your fields/columns configuration. Just check its Display->visible in table option to show it together with the other data, maybe only for your backend admin view.
Regards
Silvia Martín
Moonsoft Team
OK. I succeeded with LM_countries. So far, so good
So I tried to update my table with a very simple, one line, csv file.
Same error "Column count doesn't match value count at row 1"
I verified my record :
- ID column added,
- ID value unique
- comma separated
- 12 columns in database = 12 columns in my csv file
- every value inside double-quote,
- no new line character in the values.
What's wrong please ?
File is joined
I don't understand anything anymore (and it was not that brilliant already!)
I continued with my experiments and eventually succeeded with the following content in my csv file :
68,"","","","","","","","","",""
A first numeric value equal to the last ID count + 1 followed by 10 empty columns.
This one got accepted by LM and when I checked in Manage data, here is what I saw :
69,68,"","","","","","","","","",""
Sooo LM auto-incremented the ID column and filled the first column with 68…
I'm lost.
No need to add a first ID column after all ?
Well, I gave up and did my import from phpMyAdmin.
It ended well.
Thanks anyway.
--
Pascal
Hi,
ok. Please note you need to add only the columns you can see at your form fields list, these are the real columns at your database (so there's not always an autoincrement id AND an unique id, it will depend on each table structure).
Great it worked with your workaround anyway. We close the ticket, please open a new one in case you have other questions.
Thanks, regards
Silvia Martín
Moonsoft Team
Hi,
I may finally finish with this hellish site migration but still some problems with List Manager :
- today, I wished to delete some old records… No way to do it from the backOffice ? Ok, I just added a "delete" button to the data layout and was able to delete my old record. So far, so good… sort of. I then worried that this delete button would appear on the front-end too and indeed that's what it did as intended.
- Then I rightfully worried that this button may be accessible to anyone, so I logged out and wen to the front-end : and indeed the delete button appears to anyone even not logged in !
- So I searched the LM back-office for rights management : no luck. I may have looked in the wrong place but if it existes, I did not find it.
- Then, I tried to add a new record : same problem, no button in the back-end unless I edit the data layout to add one. That's what I did but alas, when I tried to add a new record, my button did open a new record form but when I tried to save it : nothing happened when I hit the save button.
…
please guys…