...
- Widoki można doimportować do istniejącego już użytkownika w bazie bez konieczności zaznaczania go w drzewku. Uprawnienia do widoku również zostaną doimportowane do istniejących użytkowników/grup w bazie bez konieczności zaznaczania ich.
- Prywatne – jeżeli widok użytkownika istnieje już w systemie, to zostanie pominięty
- Publiczne - jeżeli widok użytkownika istnieje już w systemie, to zostanie pominięty. Publiczne widoki użytkownika, którego nie importujemy i użytkownik nie istniał prędzej w bazie zostaną przypisane do admina.
- W wyróżnieniach widoku, jeżeli ścieżka do obrazu jest bezwzględna, to zostanie zmieniona na '{plusworkflow.home}/distinguish/plik' dzięki czemu katalog z obrazami wyróżnień zostanie utworzony w katalogu domowym PlusWorkflow/distinguish. Zmiana ta i możliwość edycji ścieżki pojawi się w drzewku tylko przy tych widokach, które posiadają ścieżkę do obrazu i ta ścieżka jest bezwzględna.
Błąd podczas importu
Jeżeli import z jakiegoś powodu nie powiedzie się, to dane z bazy zostaną automatycznie wycofane.
| Warning | ||
|---|---|---|
| ||
Wyjątkiem jest baza Oracle. Tutaj nie wszystkie dane zostaną wycofane w przypadku niepowodzenia (spróbujemy to naprawić w kolejnej wersji). Niżej umieszczone zostaną zapytania do wyczyszczenia bazy. |
Usunięcie zaimportowanych danych
W celu ręcznego usunięcia wszystkich zaimportowanych danych do nowego systemu można wykonać zapytania:
| Warning | ||
|---|---|---|
| ||
Jeżeli w systemie przed importem były już dane, to zostaną usunięte. |
PostgreSql
| Code Block | ||
|---|---|---|
| ||
DELETE FROM usergrouptable ut WHERE ut.userid <> (SELECT objectid FROM usertable WHERE userid = 'admin') or ut.groupID <> (SELECT objectid FROM grouptable WHERE groupid = 'Administrators'); DELETE FROM grouptable gr WHERE gr.groupid <> 'Administrators'; DELETE FROM pm_activityredirection_users; DELETE FROM pm_activityredirection_groups; DELETE FROM pm_activityredirection; DELETE FROM pm_userdata; DELETE FROM pm_substitutions; DELETE FROM pm_domainservers; DELETE FROM pm_position_role; UPDATE pm_positions SET organizationalunitid = NULL; UPDATE pm_organizationalunits SET directorpositionid = NULL; DELETE FROM pm_organizationalunits; DELETE FROM pm_positions; DELETE FROM userTable us WHERE us.objectid <> (SELECT objectid FROM usertable WHERE userid = 'admin'); DELETE FROM pm_actions; DELETE FROM pm_linkconnection; DELETE FROM pm_indexpattern; DELETE FROM pm_indecies; DELETE FROM pm_processdef_docclass; DELETE FROM pm_docclasses; DELETE FROM pm_docclassconditionprotection; DELETE FROM pm_docclassprotection; DELETE FROM pm_linkindecies; DELETE FROM pm_links; DELETE FROM pm_directories; DELETE FROM pm_devices; DELETE FROM pm_substitutions; DELETE FROM pm_document_views; DELETE FROM pm_processData; DELETE FROM pm_documenttemplate; DELETE FROM pm_notificationdef; DELETE FROM pm_notificationprocact; DELETE FROM pm_notificationrecipient; DELETE FROM pm_change_user_repl; DELETE FROM pm_advancesearchvariables; DELETE FROM pm_usersearchviewsprotection; DELETE FROM pm_usersearchviews; DELETE FROM pm_userdata WHERE userid <> (SELECT objectid FROM usertable WHERE userid = 'admin'); DELETE FROM pm_rights r WHERE r.resource_id <> 'admin'; DELETE FROM pm_variable_distinguish; |
Oracle i MSSQL
| Code Block | ||
|---|---|---|
| ||
DELETE FROM usergrouptable WHERE userid <> (SELECT oid FROM usertable WHERE userid = 'admin') or groupID <> (SELECT oid FROM grouptable WHERE groupid = 'Administrators');
DELETE FROM grouptable WHERE groupid <> 'Administrators';
DELETE FROM pm_activityredirection_users;
DELETE FROM pm_activityredirection_groups;
DELETE FROM pm_activityredirection;
DELETE FROM pm_userdata;
DELETE FROM pm_substitutions;
DELETE FROM pm_domainservers;
DELETE FROM pm_position_role;
UPDATE pm_positions SET organizationalunitid = NULL;
UPDATE pm_organizationalunits SET directorpositionid = NULL;
DELETE FROM pm_organizationalunits;
DELETE FROM pm_positions;
DELETE FROM userTable WHERE oid <> (SELECT oid FROM usertable WHERE userid = 'admin');
DELETE FROM pm_actions;
delete from pm_file_versions;
delete from pm_files;
DELETE FROM pm_linkconnection;
DELETE FROM pm_indexpattern;
DELETE FROM pm_indecies;
DELETE FROM pm_processdef_docclass;
DELETE FROM pm_docclassconditionprotection;
DELETE FROM pm_docclasses;
DELETE FROM pm_linkindecies;
DELETE FROM pm_links;
DELETE FROM pm_directories;
DELETE FROM pm_devices;
DELETE FROM pm_substitutions;
DELETE FROM pm_document_views;
DELETE FROM pm_processData;
DELETE FROM pm_documenttemplate;
DELETE FROM pm_notificationdef;
DELETE FROM pm_notificationprocact;
DELETE FROM pm_notificationrecipient;
DELETE FROM pm_change_user_repl;
DELETE FROM pm_advancesearchvariables;
DELETE FROM pm_usersearchviewsprotection;
DELETE FROM pm_usersearchviews;
DELETE FROM pm_userdata WHERE userid <> (SELECT oid FROM usertable WHERE userid = 'admin');
DELETE FROM pm_rights WHERE resource_id <> 'admin'
|