Documentation for WEB Report System PSIM 1.0.1.

Previous page Next page

WEB Report System PSIM is installed as an extension to Axxon PSIM. For the information on the compatibility of WEB Report System PSIM with Axxon PSIM versions, see General information about product releases and versions compatibility.

Attention!

WEB Report System PSIM must be installed only on Server/Administrator's workplace (for details, see Axxon PSIM software. Administrator's Guide).

To install WEB Report System PSIM, do the following:

  1. In the root directory of the distribution package, run the setup.exe file.
  2. To continue the installation process, click the Next button.
  3. Read the terms of the license agreement carefully. Then select I accept the terms of the License agreement and click the Next button.

  4. Select MS SQL Server and set the connection parameters (for details, see Installation of Axxon PSIM as a Server/Remote Administrator's workstation).

  5. To continue the installation process, click the Next button.

    Note

    The WEB Report System PSIM database is created on the selected SQL server.

    Later, you can move the database of WEB Report System PSIM to another SQL server.

    After that, it is necessary to make changes to the <Axxon PSIM installation directory>\Modules\Wt2\Web.config file by correcting the connection string ReportSystemConnectionString:

    <add name="ReportSystemConnectionString" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ReportSystem;Data Source=(local)\SQLEXPRESS2014;" providerName="System.Data.SqlClient"/>


  6. Specify the connection strings to the main Axxon PSIM database and the POS PSIM receipt database. The connected databases serve as a data source when you create reports.


  7. To set the connection string to the main Axxon PSIM database, do the following:

    1. Click the Connection to the main PSIM DB button.
      As a result, the Data Link Properties window opens.

    2. In the Provider tab, select Microsoft OLE DB Provider for SQL Server.

    3. Click the Next button.
      The Connection tab opens automatically.

    4. In the 1. Select or enter a server name section, select from the drop-down list or enter manually the name of the SQL server where the main Axxon PSIM database is stored.

    5. To log on to the SQL server, enter authentication parameters.

      1. For this, in the 2. Enter information to log on to the server section, select Use a specific user name and password.

      2. In the User name and Password fields, enter the username (login) and password in order to connect to the SQL server.

      3. Set the Allow saving password checkbox.

    6. To check the connection to the SQL server, click the Test Connection button.

      1. In case the connection is successful, the window with the Test connection succeeded message will be displayed. Click the OK button to close the window.

      2. If the name of the SQL server and/or authentication parameters that are used in order to connect to it were set wrong, then the corresponding message is displayed.

        Click the OK button to close the window. Then correct the data and check the connection to the SQL server once again.

    7. If the check of the connection to the SQL server is successful, select from the Select the database on the server drop-down list the name of the connected database.

    8. Click the OK button in the Data Link Properties window. As a result, the window closes.
      The setup of the connection string to the main Axxon PSIM database is completed.

  8. In the same way, set the connection string to the POS PSIM database of receipts (the default database name is pos).
  9. Click the Next button to proceed to setting up the connection to the Auto PSIM databases.
  10. In the same way, set the connection string to the Traffic Detection database (the default database name is traffic_db).

  11. In the same way, set the connection string to the License Plate Recognizer database (the default database name is lprex).

  12. Click the Next button to proceed to configuring the connection to the DetectorPack PSIM databases.

  13. In the same way, set the connection string to the DetectorPack PSIM database (the default database name is detectorpack).

    Note

    If you install POS PSIM, Auto PSIM, and DetectorPack PSIM after the WEB Report System PSIM, it is necessary to connect the WEB Report System PSIM database to the corresponding modules. To do this, start the repairing mode of the report system and specify the corresponding connection strings (see Repair).

    You can also set the connection strings to all databases through the <Axxon PSIM installation directory>\Modules\Wt2\Web.config file. Examples of connection strings are given below:

    • <add name="PSIMDB" connectionString="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Axxon PSIM;Data Source=(local)\SQLEXPRESS2014" />
    • <add name="PosDB" connectionString="Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=pos;Provider=SQLOLEDB.1" providerName="System.Data.SqlClient" />
    • <add name="TrafficDB" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=traffic_db" />
    • <add name="DtDB" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=dt" />
    • <add name="ReportSystemConnectionString" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ReportSystem;Data Source=(local)\SQLEXPRESS2014;" providerName="System.Data.SqlClient" />
    • <add name="Analytics" connectionString="Server=localhost;Port=15432;User id=postgres;Password=Analytics_default_DB_4;Database=analytics;CommandTimeout=600;" providerName="Npgsql" />
    • <add name="lprex" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=lprex" />
    • <add name="detectorpack" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=detectorpack;"/>
  14. To continue the installation process, click the Next button. As a result, the copying of the necessary WEB Report System PSIM components to the hard disk starts.

    After the     WEB Report System PSIM components are successfully copied, a message about the completion of the installation process is displayed.
  15. Click the Finish button.

The installation of WEB Report System PSIM is completed.

  • No labels