Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

0

0
Sonia Fernandes
On 9/22/23, 3:25 PM
  1. Once you have completed the database updates, please ensure that you also restore both databases on the new computer.

  2. After the restoration, kindly search the USERLOGIN table within the database. Verify if the user login of the new computer is present. In case you are unsure of the username, you can easily find it in the Genio IDE. For example, the username in the next figure is "sonia.fernandes."



In case your user login is not found in the database, please use the following query to insert the required user login and user authorization details (please remember to modify the username accordingly):


-- Variable declarations
DECLARE @name varchar(max) = 'example' 
DECLARE @password VARBINARY(MAX) = CONVERT(VARBINARY(MAX), '123')
 
-- Inserting the user login
INSERT INTO USERLOGIN (codpsw, nome, password, zzstate)
VALUES (newid(), @nome,
(SELECT CAST('' AS XML).value('xs:base64Binary(sql:variable("@password"))', 'varchar(max)')),
0)
 
-- Inserting the user authorization
INSERT INTO USERAUTHORIZATION (CODUA, CODPSW, SISTEMA, MODULO, NIVEL, ZZSTATE)
VALUES(newid(), (SELECT codpsw FROM USERLOGIN WHERE nome = @name), 'GEN', 'GEN', '99',0)


3. The next action is to create a new project in Genio with the same name. During this process, please be cautious and make sure to decline the database updation. When prompted for database updation, ensure to select "YES".


Once you have successfully created the new project in Genio, the application will close automatically. You should then reopen Genio to proceed with your project. Upon reopening, you will find the project you created earlier listed in the projects list.

NOTE: Please be aware that the second time you open the project, you need to respond with "YES" to both the project updation and the indexation prompts. This will ensure that any necessary updates and indexing processes are carried out to keep the project synchronized and up-to-date.




4. If you have a "GenCopy_QUIDGEST" folder available, you can go ahead and paste it into the new project folder. This folder likely contains important files needed for your project.

However, if you don't have a "GenCopy_QUIDGEST" folder, there's no need to worry about the old project folder. It won't be necessary for the current project setup.

Regarding the client database (the one with the project name), you can now reference it in the webadmin once it's been generated. The webadmin will allow you to access and manage the client database, ensuring that it's ready for use with the new project.

Remember, if you encounter any issues or have any questions during this process, don't hesitate to seek assistance or clarification.


Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

48 follower(s)

Stats

Asked: 8/22/23, 9:59 AM
Seen: 409 times
Last updated: 9/22/23, 3:25 PM