Export / import settings
Everything that is configured through the studio, I suggest doing export / import, if for someone else this option is relevant.
Perhaps it will be a paid module.
-
-
Hi LeonidS
I have 2 UNA installations. I exported the sys_options table and I have the file sys_options.sqlIn the other UNA installation, should I first remove the sys_options table and then import from sys_options.sql or how should I do the procedure?
Thanks. -
Hello Claudio Acosta !
If you sys_options.sql file contains the lines like
CREATE TABLE
Then yes, you'd better delete / rename the current sys_options table(s). But backup this DB first too.
-
- · Claudio Acosta
- ·
Hi LeonidS
In order to copy the configuration from one installation to another, in the destination installation I deleted the mentioned tables here: https://unacms.com/page/view-discussion?id=5773 and then imported those from the other installation.I am not understanding why the names of the lists are not displayed in Form-Datalists as they are in the other installation.
Do I need to configure something or copy another table?
-
You were talking about sys_options deal. The mentioned part depends from the sys_localization_* tables.
-
Hi LeonidS
I imported all the tables mentioned in https://una.io/page/view-discussion?id=5773 (settings, page, menu, forms, datalists, search, permissions, grids). I also imported the sys_localization_ * tables.
Then when I wanted to create a profile it gave me the error error: database query error. Since I did not find the solution, I am now installing UNA from scratch.
With the import of the mentioned tables I had managed to replicate the configuration of my other UNA installation (which is working correctly), but surely I will have done something wrong.
Regards. -
Hi LeonidS
Is what I did correct or should I only have imported the sys_options_ * tables?
-
It looks correct, but it's better to know what the error was there.
-
- · Claudio Acosta
- ·
Hi LeonidS
I came in handy with the new install until I imported the tables: sys_objects_form, sys_form_displays, sys_form_inputs and sys_form_display_inputsThe forms to add Person and Organizations stopped working (database query error).
The reason I think is because the bx_persons_data table in the new installation does not have the new fields that the add person form refers to.
How should I proceed? would i also need to import the bx_persons_data table? or is there some other way for the table to update?
Attached error received by email.
Thanks.
-
Yes, if you made new fields in some forms then better to check if *data table contains them too and add those columns there.
-
Hi LeonidS thanks. I have done that. So far I'm doing fine with configuration migration.