Installation

Welcome to the setup process for Genio. Whether you're looking to embark on Genio Backoffice installation or develop applications in GenioWeb, the journey begins with a common set of steps to prepare your environment for development. This unified starting point ensures that the foundational elements necessary for a smooth installation are in place, regardless of the path you ultimately choose.

Contents

Preparing the Environment for Development

The initial phase of setting up Genio is identical for both installation methods. It involves preparing your system to meet the prerequisites that are crucial for the tool's optimal performance. These steps typically include:

This phase is designed to ensure that your environment meets the minimum requirements necessary for the successful deployment of the tool. Follow these steps diligently to prepare your system:

  1. Check minimum system requirements;
  2. Enable necessary Windows Features;
  3. Install necessary tools;
  4. Setting the Database Management System (DBMS);

Minimum System Requirements

For optimal functioning of Genio, it should be installed on a computer with the following characteristics:

  • Microsoft Windows 10
  • 8GB RAM
  • I5 or equivalent
  • 40GB free disk space
  • Internet connection

Windows Features

To optimize performance, Windows 11 ships with various features turned off by default, as the typical user may not require them for everyday tasks. However, to fully harness the capabilities of Genio, you may need to activate certain components. Below, we outline the steps to ensure your system is configured correctly:

Accessing Windows Features: Start by navigating to the features settings of your system. You can do this by typing “Turn Windows features on or off” into the search bar. This action will bring up a list of Windows features that can be enabled or disabled.

Comparing and Enabling Required Features: In the Windows Features window, you'll find a list of optional components. Cross-reference this list with the features we've marked as necessary for Genio. Tick the checkboxes next to the required features to enable them.

feat1.png

feat2.png

feat3.png

feat4.png

Restart Your Computer: After validating and installing all the necessary features, it's important to restart your computer. This ensures that the changes take effect and the system is fully prepared.

Necessary tools

Visual Studio

Genio generates source code and project files that are fully readable and compatible with a variety of Integrated Development Environments (IDEs), tailored to the specific technologies employed in your development process. When building MVC applications, Microsoft Visual Studio (VS) is the required IDE.

For those engaging in educational or testing activities, the Community Edition of Microsoft Visual Studio is readily accessible and can be downloaded from the official website https://visualstudio.microsoft.com/vs/.

This edition provides a comprehensive suite of tools and features suitable for such purposes, ensuring a robust and efficient development experience.

.NET

.NET unifies the SDK, base libraries, and runtime across mobile, desktop, IoT, and cloud apps. The download is available at: https://dotnet.microsoft.com/en-us/download/dotnet/thank-you/sdk-8.0.204-windows-x64-installer

For versions beyond 338.14, it is recommended to utilize .NET 8. Further details can be found at here.

NodeJs

Node.js is an open-source and cross-platform JavaScript runtime environment. It is a popular tool for almost any kind of project! Genio needs NodeJs to compile all libraries of the project.

Go to https://nodejs.org/ and choose the LTS version.

pnpm

The pnpm (Performant NPM) is a forward-thinking package management solution designed to address the challenges posed by traditional package managers. In simple terms, pnpm downloads all project dependencies during the project compilation.

To install pnpm via npm (Node.js) on Windows:

  • Open the command line from the Start menu.
  • Check if pnpm is already installed by typing pnpm.
  • If the command is not recognized or the version is outdated, enter npm install -g pnpm to install the latest version.

Essential libraries and dependencies

This installation program developed by Quidgest installs some dependencies necessary to run our applications. The installation program can be downloaded at https://quidgest.net/DownloadFiles/Setups_3.0.10.zip

Before beginning installation: Ensure you have administrator privileges (local or network).

  • Once the file has been downloaded, it must be unzipped. Make sure you do not make any changes to the folder structure.
  • Run the file “QuidSetups.exe”.

For versions beyond 338.14, it is recommended to follow the next steps:

  1. Select "Custom" for the installation mode.
  2. Select both options (“Client” and “Server”).
    1. Client machines: Only for customers with solutions using native Windows applications.
    2. Server machines: To run on servers where Quidgest solutions are installed.
  3. Check the next options on the list:
    1. Client -> Other: Crystal and its children.
    2. Server ->Web: Crystal and its children.
    3. Server ->Other: Reporting Services and its children
  4. Based on our previous selection it will be given a detailed listing of the components that will be installed on our server. Check if everything is all right and you can start the installation process by clicking on the “Install” button.

setupchecklist.png

For versions under 338.14, it is recommended to follow the next steps:

  1. Select "Typical" for the installation mode.
  2. Select both options (“Client” and “Server”).
  3. Check all options: Other, Backoffice, MVC and Web.
    1. Other: Requirements for all platforms such as Microsoft Report Viewer
    2. Backoffice: Windows Applications.
    3. MVC: Web applications that use MVC technology.
    4. Web: Other web applications.
  4. Based on our previous selection it will be given a detailed listing of the components that will be installed on our server. Check if everything is all right and you can start the installation process by clicking on the “Install” button.

Microsoft SQL Server Management Studio

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. We use SSMS to query, design, and manage your databases and data warehouses on your local computer. In other words, to have access to the local server database, it is necessary to have this tool installed locally.

You can find the download of Microsoft SQL Server Management Studio (SSMS) at https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

Database Management System (RDBMS)

SQL Server

Microsoft SQL Server is a relational database management system (RDBMS). Applications and tools connect to a SQL Server instance or database and communicate using Transact-SQL (T-SQL).

The Database Engine component of SQL Server is the core service for storing, processing, and securing data. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data-consuming applications in your enterprise.

(https://learn.microsoft.com/en-us/sql/sql-server/what-is-sql-server?view=sql-server-ver16, 2023)

Genio is compatible with SQL Server 2008 R2 or later. However, it is advised always to use the latest version of SQL Server. You can get a free Developer edition of Microsoft SQL Server here: https://www.microsoft.com/en-gb/sql-server/sql-server-downloads Scroll down on the page and select the Developer option to download.

Main steps:

  1. Run the SQL2019-SSEI-Dev.exe file
  2. Select the Custom option.
  3. Keep media location as C:\SQL2019 and press install.
    1. This may take a few minutes. Then, the SQL installation center window will open.
  4. On the top left menu, click on the installation tab and select New SQL Server stand-alone installation.
  5. When installing SQL Server, use the default setup options except when noted below.
    1. You don't need the Azure extension, so please uncheck the "Azure Extension for SQL Server".
  6. Feature Selection:
    1. There are many features you can add to your server instance, but for this installation, just select the “Database Engine Services” option.
  7. Instance Configuration:
    1. By default, a computer does not have any server instance installed, in this case, you should maintain the “Default instance” option selected.
      • Selecting the default instance name will assume the same name as the computer [COMPUTERNAME] (E.g., CURIOSITY).
    2. If you already have a server instance previously installed, choose the “Named Instance” option, and type a new name.
      • The suggestion is “SQL[YEAR]” (E.g., SQL2023). In the end, the full name of your server is “[COMPUTERNAME]\QUIDGEST[YEAR]” (E.g., CURIOSITY\SQL2023)
  8. Server Configuration / Collation
    1. SQL Server collation refers to a set of characters and character encoding rules. Genio uses "SQL_Latin1_General_CPI_CI_AI”, which means:
      • Latin makes the server treat strings using ASCII.
      • CPI uses the Code Page 1252.
      • CI is case-insensitive (“ABC” is equal to “abc”).
      • AI is accent-insensitive (“á” is equal to “a”).
    2. Make sure that you choose the correct option. This setting makes it easy to search for data because data entry is subject to many accentuation errors.

collation1.png

collation2.png

  1. Database Engine Configuration
    1. Server Configuration: In the first tab, “Server Configuration”, you should select in the Authentication Mode area, the Mixed Mode option, so that third-party SQL applications can access the databases created therein.
      • The password here is based on the default user "sa" - it must have fifteen characters, including capital and small letters as well as numbers (don’t use special characters). This is only for configuration and installation, not for normal use.
      • Also, add yourself (Add Current User) as SQL Server administrator.

dbconfigurationsql.png

  1. Filestream: In the “FILESTREAM” tab of this form, select the technologies to be used for document recording.
    • You should select all the options and make sure you do not change the Windows share name.

filestream.png

Creating an SQL Server Account

  1. After you've completed the installation, proceed to create a new user account using SQL Server authentication.

    • This account is crucial as it will be utilized in both SSMS and Genio. While you have the option to alter the password at a later stage, it's important to set it up carefully now.
      • Username: Avoid using numbers or special characters.
      • Password: Ensure that your password meets the following complexity requirements:
        • 10 characters long.
        • At least one capital letter and one small letter.
        • At least one number.
        • At least one special character.
        • IMPORTANT NOTE: do not use any of the following special characters (to avoid errors on Genio): < (less than sign); > (greater than sign); & (and sign); ' (apostrophe or single quote); " (double quote).
    1. If you've added the "current user," log in using Windows authentication.
      1. Alternatively, use the 'sa' credentials provided here SQL Server - Step 9 for login.

    2. There are two ways to create your account: by query or manually:

      1. Account creation by query:
        USE [master] GO CREATE LOGIN [set_Username] WITH PASSWORD = N'<set_Password>', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF; GO

      2. Account creation manually:

        1. On the "Object Explorer" window (a bar on the left side), expand the instance name.
        2. Right-click on the Security section and choose the option “new” followed by “new login”.
        3. In the General section, type a Login name (Username) and change the authentication type from “Windows authentication” to “SQL Server Authentication”.
        4. Then, type a Password and Confirm with the same Password.
          • Note: create a password according to the conditions of complexity mentioned before.
        5. The options to enforce the password policy should be unchecked.
        6. At the end of the window, confirm the default language is “English – us_english”.
        7. In the Server Roles section, it is mandatory to give more permissions to this user. For that, you should select the “sysadmin” option.
  2. Testing credentials: Ensure you can log in with the credentials created previously.

Enabling Named Pipes and TCP/IP

For optimal and adaptable connectivity between the system and the database, enabling protocol bindings is essential.

  1. Open SQL Server Configuration Manager:
    • You can find this in the Start Menu or by searching for it in Windows.
  2. In the SQL Server Configuration Manager, click on "SQL Server Network Configuration" on the left pane.
  3. In the list of SQL Server instances, select the instance for which you want to enable the protocols.
  4. In the right pane, you'll see a list of protocols.
  5. Right-click on the chosen protocol and select "Enable" from the context menu.
  6. You should enable all protocols (Shared Memory, Named Pipes and TCP/IP).
  7. For the changes to take effect, you need to restart the SQL Server service.
    1. Go to the "SQL Server Services" section in the left pane.
    2. Right-click on your SQL Server instance (it should be listed as SQL Server (instance_name)) and choose "Restart".

protocols1.png

protocols2.png

Testing

In the end of full nstallation, you can test with a test project. Just to ensure everything is well-installed. You can use one of yours downloaded project, or you can use this one.

Please follow these steps to set up and run the Project_Test solution:

  1. Begin by extracting the contents of the Project_Test.zip folder.
  2. After extraction, navigate to the Webadmin folder.
    • Open the solution in Visual Studio.
      • Configure the startup projects:
    • Go to the solution properties.
    • Select "Multiple startup projects."
    • Set the action to start for both the Administration and ClientApp projects.
    • Apply these configuration changes and then start the solution.
    • If the setup is successful, you should see our Webadmin page open in your browser.

webadmin_configurate_startup

  1. Navigate to the MYAPP folder.
    • Open the solution in Visual Studio.
    • Configure the startup projects:
    • Go to the solution properties.
    • Select "Multiple startup projects."
    • Set the action to start for both the GenioMVC and ClientApp projects.
    • Apply these configuration changes and then start the solution.
    • If the setup is successful, you should see our Myapp page open in your browser.

Note: During the first launch, you may encounter SSL certificate prompts. Please accept these prompts as necessary.

Installing Genio Backoffice

Download the Genio setup and License file

It is recommended to run the GENIO installer as an administrator.

  1. Start by creating a folder on your Local Disk (C:) to save Genio in.
  2. Within this folder, create a new folder and name it, Projects.
    • This is necessary because the Projects folder cannot be set as the same folder where GENIO will be installed.
  3. To get access to the Genio Setup (.exe) file (used to install Genio), you must first Go to https://quidgest.net/genio/login and click on register now.
  4. Then, log in to QuidNet using the credentials you just registered.
  5. Click on the GENIO tab and press download on the most up-to-date version of Genio (the most recent date).
  6. Please save this Genio version inside your Quidgest folder.
  7. Then go to the "MY LICENSES tab" to request or download the license:
    1. Requesting the license:
      • Please give a brief explanation as to why you want to install Genio.
      • Choose the 3-month option from the dropdown menu.
      • Then click on the request license button to submit your request.
      • You will receive an approval email if your request is accepted by Quidgest.
    2. Downloading the license:
      • Go to the "MY LICENSES tab" on QuidNet to download the license.
  8. Please save this license file in the folder created on your Local Disk (C:).

Installation

The "Genio Requirements" window, which will appear before installation, will show if any other software is needed to install GENIO. If any of the required software is not found, details will be given on how to install it.

Note: Nothing will prevent you from proceeding with the installation, even if the required software is not installed.

  • DBMS Access Configuration and Privileges

You should use the server instance name created in the SQL Server section and the account created in the Creating an SQL Server Account section.

  • Configuring Genio

Make certain that the paths for both the destination Project Folder and the License File are well-defined.

Reset Genio credentials

If you encounter the error message 'An error has occurred when opening the Database for version verification!' while attempting to open Genio, it indicates that Genio is unable to establish a connection with the database. To resolve this, follow these steps to reset your login credentials in Genio:

  1. Open Command Prompt: Search for 'cmd' in the Windows search bar and open the Command Prompt interface.
  2. Navigate to GEN Folder:
    1. Type cd followed by a space.
    2. Type or paste the path of the GEN folder (e.g., ...Genio/GEN) and press Enter.
  3. Reset Credentials:
    1. Type GENgenio.exe /setini and press Enter. This command will allow resetting the login credentials.

Should the issue persist after resetting your credentials, further checks are necessary:

  • Check Server Status: Ensure that the server hosting the database is active and running.

  • Confirm Server Instance: Double-check that you are connecting to the correct server instance.

Additionally, to further diagnose the issue, try logging into the SQL Server Management Studio with the same credentials. A successful login confirms that the credentials are correct. If you cannot log in, it suggests an issue with the credentials or server accessibility.

Installing GenioWeb Hybrid

(internal purpose)

Follow here.

Access GenioWeb Portal

To access GenioWeb, please navigate to GenioWeb Portal. Once there, log in using your designated credentials.

NOTE: If you don't have any credentials, please contact support.genio@quidgest.com

geniohub

For more assistance, please contact support.genio@quidgest.com.



FAQ

How can I get the Genio tool?

Genio, the powerful software development tool, can be obtained through different channels based on your specific needs and interests. Here are two avenues through which you can acquire Genio:

1. As a Partner via QuidNet: QuidNet is a partnership program offered by Quidgest. As a partner, you can access Genio and leverage its capabilities to build innovative solutions for your clients. Becoming a QuidNet partner grants you exclusive benefits, including training, support, and access to the latest Genio features and updates. By joining forces with Quidgest through QuidNet, you can expand your business opportunities and deliver high-quality software solutions using the Genio platform.

Join the Quidgest Partner network and create more value for your customers. QuidNet

2. As a Student in Quidgest Academy: Quidgest Academy provides an educational platform where students can learn and develop their skills in various fields, including software development. As a student in the Quidgest Academy, you can gain hands-on experience with Genio and enhance your understanding of its capabilities. The academy offers specialized courses and training programs focused on Genio's usage, enabling you to become proficient in its features and functionalities. By enrolling in the Quidgest Academy, you can acquire valuable knowledge and practical skills to kickstart your career in software development.

Find out what type of GENIO you are and sign out for a Genio Training! Quidgest_Academy

How can I get the Genio License?

  1. You can schedule a meeting with one of our Account Managers for more personalized consulting through a demo (2/3h) in our GenioLab (in person) where you can try Genio, explore, and make your assessment.

  2. You can apply for one of our training courses!

Applying for the course will give you access to:

  • Three months of Genio license.
  • Technical support for questions regarding Genio during this period.
  • Full access to the Genio Community forum.

For further information, please visit our Quidgest webpage.