Installs

Owned by Melissa Girtz
Last updated: Nov 10, 2017
3 min read

Installation ZIP file contents

  • RtROW directory - contains the RtROW website
    • May be website.zip instead, unzip it to get RtROW directory
  • database.sql - script for creating the RtROW database
    • May be database.bak instead, a database backup for you to restore
  • RtROW-template.dot - Microsoft Word template for exporting data to Word documents

SQL Database

  • From database.sql
    1. Download database.sql to the SQL Server
    2. Create a database named RtROW
    3. Review the database.sql script
      • If a password of RtVision violates your password policy, you may change it
        • For an an alternate password, you could modify database.sql, changing the N'RtVision' in these lines
          • exec sp_addlogin N'RtAEC', N'RtVision', @logindb, @loginlang
          • exec sp_addlogin N'RtAEC_Admin', N'RtVision', @logindb, @loginlang
        • Alternatively you could add the RtAEC and RtAEC_Admin users manually before running database.sql
        • Please let support@rtvision.com know any alternate passwords
    4. Run the database.sql script
  • From database.bak
    1. Add these logins to your SQL Server
      • Logins
        • RtAEC, password of RtVision
        • RtAEC_Admin, password of RtVision
      • If a password of RtVision violates your password policy, you may change it
    2. Download database.bak onto the SQL Server
    3. Restore the database backup file (right click the databases entry and select all tasks, restore database). The name of the database is RtROW and browse to locate the bak file from the device.
    4. Open Query Analyzer (or New Query in SQL 2005+) and type and run the following 2 lines (against the RtROW Database). This will fix the 2 users of the RtROW database (you should get a message stating that it fixed 2 logins).
      • EXEC sp_Change_users_login 'Auto_Fix', 'RtAEC'
      • EXEC sp_Change_users_login 'Auto_Fix', 'RtAEC_Admin'

Intranet Website

  1. Download the RtROW directory file to the Intranet Web Server
  2. Move (or unzip) the file to the directory of the website (default is C:\Inetpub\wwwroot).
    • You should then have a folder called RtROW in this path (C:\Inetpub\wwwroot\RtROW)
  3. Edit the sql.config file in the root of the RtROW website and change the localhost to the IP Address of the SQL Server (ex.data source=10.10.30.61;).
    • If the SQL Server is running on a different port other than the default (1433), it can be entered after the IP Address separated by a comma (ex. data source=10.10.30.61,4433;)
  4. Open Internet Services Manager (IIS). Navigate to the RtROW folder in the treeview on the left hand side (under default website). Right click the RtROW folder and select properties.
    1. Click the Create button on the front tab.
    2. On the documents tab, verify or add that default.aspx is listed as a default document.
    3. On the Directory Security tab, click the edit button on the Authentication and Access Control and only select the Anonymous access option (uncheck all other options).
    4. On the HTTP Header tab, check the Enable Content Expiration and select the Expire Immediately option.
    5. On the ASP.NET tab, choose the 2.0.507217 entry from the drop down list.
    6. Click Apply or OK to exit all screens.

Template File for Reports

  1. Download the RtROW-template.dot to the file sharing machine. 

    ftp://ftp.rtvision.com/products/row/rtrow-templates-2015.zip


    1. For Office 2007+, you should use the RtROW-template.dotm instead.
  2. Put it in a network path that will be accessible to all users of Rt/ROW.
  3. This path will need to be updated in the Administration Section of the software, under General >> Software Settings (ex. \\Server\RightOfWay\Templates)
    1. See #2 in Update the Settings in the software
  4. Get started by importing a mailing label template at:    ftp://ftp.rtvision.com/products/row/RtROW-Avery-Mailing-Labels.docx

Test the software

  1. Open up Internet Explorer and navigate to the website (ex. http://localhost/RtROW/)
  2. Log in using the following account (User Name: Admin Password: Admin)

Update the Settings in the software

  1. After logging in, click the Administration tab at the top of the page.
  2. Click the Software Settings link under the General menu.
    1. Click the Edit button (on each record in turn) and change the Current Value to the network path where you placed RtROW-template.dot.
      • Base Template: ex. \\Server\RightOfWay\Templates\RtROW-template.dot
      • File Path: ex. \\Server\RightOfWay\Templates
  3. Click the System Connections link under the System Tables menu.
    1. Click the Edit button (on each record in turn) and change Server to the IP Address of the SQL Server for each database. You can also use the ,portnumber syntax if needed when entering the IP Addresses (ex IPAddress,port)
      • Word Template
        • This is how RtROW-template.dot will connect to the RtROW database.
      • OneOffice
        • This is used to pull project information from OneOffice as you enter the project number in RtROW
        • If you do not have OneOffice, or to disable this feature, set Server to 'DISABLED' (this is case sensitive)

Send information to RtVision

  1. Please send application install location to RtVision
  2. Please send base template download location to RtVision

This information is necessary for training.