I have now reimported into a empty repository and I’m again unable to log in, although I specified that I wanted to import non-existing users added and allowed users to be added to the admin group.
pbakker:
Guess I’m not clear about what I’m asking:
In the repository where you are exporting from, you have usergroups and users.
But in that repository, do you also have settings WITHIN the usergroups?
Like restrictions on form or element or table access?
In other words: is there security configuration within the usergroups?.
If not, Servoy will not export.
No there aren’t any restrictions other than having to log in.
I create all menus and links dynamically and hide the items not accessible by to the user.
I don’t think this behaviour is expected.
Either Servoy has to warn when you export, or should export regardless of there being security configurations or not. I can’t see any advantage of not exporting.
I have wasted a lot of time on this issue, and I’m sure I’m not the only one. :evil:
If you have multiple solutions in your repository you want groups exported with a solution file that are only relevant to that solution (the other groups have no settings to that solution - not exported). Otherwise when you exported your solution file you would export all security groups whether they belong to that particular solution or not. Messy and ugly. This way when you export a solution it will only take the security groups that belong to it.
Hi Chris,
You need to create at least one restriction per each group you want exported, setting a field as viewable nut not editable is enough so if you choose one field that was already set to be read-only from one of your forms you’re set without disturbing any user.
rodneysieb:
If you have multiple solutions in your repository you want groups exported with a solution file that are only relevant to that solution (the other groups have no settings to that solution - not exported). Otherwise when you exported your solution file you would export all security groups whether they belong to that particular solution or not. Messy and ugly. This way when you export a solution it will only take the security groups that belong to it.
There is only the one solution, so this is not a problem.
However, I tried moving the user and groups using 3rd party SQL tool, but Servoy Developer told me it could not work without a pk field in users when I tried to log in.
I think that if you create a small solution with only one dummy table, and with an admin user for it in the new empty repository before importing your solution, it will import also the user.
If there is already a user in the repository before your import, it should run.
I think that if you create a small solution with only one dummy table, and with an admin user for it in the new empty repository before importing your solution, it will import also the user.
If there is already a user in the repository before your import, it should run.
Hope this help.
DomTom.
Thanks for the tip, DomTom.
I have already exported and imported successfully. My users and groups came across ok after I restricted access to some unused table.
The only problem is that Servoy keeps changing my db sequences in servoy sequences
As I have about 100 tables this is a major problem…
This time I imported allowing Servoy to update the sequences and the results were a lot better, except that the users and groups did not import, so I could not log in.
So I created yet another empty repository.
I imported allowing Servoy to update the sequences and allowed it to overwire users and groups completely and to add people to teh admin group.
So now I have both users, groups and sequences – hopefully
pbakker and Nicola pointed this out yesterday, so I restriced access to an unused table. I still think Servoy should give some feedback if it does not export users and groups – I had no idea that I had to restrict access to get users and groups exporting properly.
I find the import options confusing.
Maybe, my system architecture is unusual – I attach a list of allowed screens to each user group and from this I
dynamically build navigation menus
each record has a calculated hyperlink used to go from anywhere to that record. If user is not allowed to go, hyperlink turns into plain text, disallowing access.
Because of this, an admin user can allow or restrict access to screens in Servoy client.
The export is more based on the solution you export and if you say export this solution with the users then everything that is used by that solution (like forms and calculations) are exported and also the users that are used by the solution. So the solution object is the root from which we query.
Same goes for example data, Only example data of the tables that are used by the solution are exported. not every possible table from all the servers…
Maybe we couild improve the feedback when exporting and tell you what groups and users are also exported with the solution.
