ITpipes Host Client Install

Prerequisites

1. ITpipes Master SQL Server database has been created.
2. Required information including client-specific details that the client typically sets up and maintains. ITpipes may have a record of this information, but we are unable to track any changes or updates made to this information so we highly recommend having this available from internal sources before installation.
3. SQL Server instance name
4. Individual requirements vary by the AMS system. The requirements are defined in another document.
   
5. SQL Server database credentials
   
6. Database name set during ITpipes master database creation
7. Only applicable if located on a domain. The host is recommended to be installed on a server. ITpipes Sync is to be installed on the mobile units. To install this, administrative access is required.

Installation

1. If a new install:
   
1. Unzip and run the ITpipes Host installation program that was downloaded from Google Drive.
   
2. Download the zip file containing the updated files.
   
3. Unblock the downloaded file.
   
1. Right-click the downloaded file.
   
2. Select Pro​​​​perties.
   
3. Select the checkmark next to unblock.
   
4. Select Ok.
   
4. Unzip the downloaded file
   
5. Copy and paste the files inside the unzipped folder to the correct folder location.
   
1. Server -> C:\Program Files (x86)\Infrastructure Technologies\ITpipes Host
   
2. Manage -> C:\Program Files (x86)\Infrastructure Technologies\ITpipes Host Manager
6. Proceed to setup.
   
2. If updating:
   
1. Make a backup of the folders:
   
1. Proceed to C:\Program Files (x86)\Infrastructure Technologies
   
2. Select ITpipes Host and ITpipes Host Manager.
   
3. Right click on ITpipes Host and select send to compressed zipped folder.
   
4. Rename the file to include the date. For example: ITpipes Host 20220624.bak
2. Download the zip file containing the updated files.
   
3. Unblock the downloaded file.
   
1. Right-click the downloaded file.
   
2. Select Properties.
   
3. Select the checkmark next to unblock.
   
4. Select Ok.
   
4. Unzip the downloaded file
   
5. Copy and paste the files inside the unzipped folder to the correct folder location.
   
1. Server -> C:\Program Files (x86)\Infrastructure Technologies\ITpipes Host
   
2. Manage -> C:\Program Files (x86)\Infrastructure Technologies\ITpipes Host Manager
6. Proceed to setup.

ITpipes Host Setup (ITpipes Host Manager)

1. Before running ITpipes Host Manager, proper permissions will need to be set for the “C:\Program Files (x86)\Infrastructure Technologies” directory. Users will need “Modify” access for the directory for ITpipes Host Manager to function properly.

To open ITpipes Host Manager:

Note: If ITpipes Sync does not start syncing before the end time has been reached. ITpipes Sync will not start the syncing process.

1. Select ITpipes Host Manager through the start menu to launch the stand-alone application.
1. ITpipes Host Manager can also be started by going to “C:\Program Files (x86)\Infrastructure Technologies\Host Manager” and running the Host Manager.exe program
2. Adding Projects [For ITSync Client]:
   
1. Select 
   
2. Project Alias: Nickname for the project that will be displayed and used to differentiate between projects.
   
3. SQL Server: Name of the Server [localhost\SQLEXPRESS for mobile CCTV units]
   
4. SQL DB: Name of the database being referenced. 
   
5. Username / Password: SQL account with database read and write permissions.
   
6. Select “Connect”. If everything was successful, a display will pop up stating “Connection Successful.” The media path will be automatically populated.
   
1. If a UNC path is not populated. Input the UNC path to the media location. For example \\server\folder\Media_Path\.
   
2. [Only if this is a remote SQL server, not needed on a local mobile CCTV project as that should already be created]
   
7. Select “Add Connection” to finish adding the project to ITpipes Host.
3. Editing Projects:
   
1. Editing projects allows the modification to the UNC path and enables S3 upload.
   
2. Select the project that needs to be modified.
   
3. Select  to edit the project.
   
4. Deleting Projects:
   
1. Deleting projects only removes the link to the project, not the project itself.
   
2. Select the project that is needing to be deleted.
   
3. Select  to remove the project link.
   
5. Settings (Gear Icon): 
1. Host Settings - Provide a computer name or IP Address to run the client. ex: localhost. This will need to be able to connect to define the rest of the settings.
2. Sync Initialization Settings - Choose when ITpipes Sync is to automatically start and how often.
1. Frequency - How often ITpipes Sync will automatically start.
2. Time Range - When Sync will try and start the sync process. (Note: If running multiple trucks. ITpipes Host will lock while one truck is syncing. ITpipes Sync will check periodically for Host availability.
3. Email Settings - enabling email alerts will provide the recipients an email of the sync log. Note: This feature requires a Username and Password.
1. Outgoing Server: The SMTP Mail Server.
2. Port: Port with which the SMTP server communicates, this is usually Port “21”.
3. Username: Username of a login to the SMTP Server.
4. Email Address: Email address of the Username
5. Password: Password of the username.
6. Send alerts to: This lists the recipients of the email. To send to multiple people separate the emails by a comma.
4. Sync Settings -
1. Sync Asset Types: Which asset types that ITpipes Sync will sync to and/or from the target database. 
   
2. Data Case Options: If the desire to have all the information coming from the source database will exist in a specific case, i.e. upper, lower, or Formal. For example, if Title is selected. “title” becomes “Title.
3. Match Criteria: The fields that will be matched for sync to merge source information to target information for an inspection.  All fields defined in the match criteria have to match to combine inspections onto another asset. For example, if ML_Name, US_MH, and DS_MH are selected. Sync will not merge the inspection onto the asset unless ML_Name AND US_MH AND DS_MH fields match. To switch between asset types. Select the button next to the desired asset type.
5. Upload Settings - configure what will be uploaded to the target project.
1. Disable: Disables the upload feature of ITpipes Sync.
2. All: Uploads all inspections from the source database.
3. Complete inspections: Only uploads inspections that are marked as “Complete” at the end of an inspection.
6. Download Settings - configure what will be uploaded to the target project.
1. Disable: Disables the download feature of ITpipes Sync.
2. All: Downloads all inspections from the target database.
   
3. Open inspections: Only downloads inspections that are marked as “Open” on the WO_Status field. This setting is mainly used for AMS integrations.
   
7. Upload and Download Settings:
   
1. Match Handling - How ITpipes Sync handles the assets that match assets on the target database to the source database. The options are Update changes, Discard changes, and Add a new record.
   
2. Overwrite Media - If enabled, ITpipes Sync will replace matching media files.
   
3. Check for the file before copying media: This setting will check to make sure the file exists before copying the media over.
   
4. File Types - What file types that ITpipes Sync will copy over.
   
5. Server Media Path - Location of the media path where the python scripts are located. This is for ITpipes Sync python scripting.
   
8. Error Log - Whether the desire is to have a text file and/or the log to be recorded on the Master Database(target database).