binSight™

Installation and Upgrade Guide

Version 3.2.8

Open

Open

Table of Contents

Introduction

The installation procedures contained in this document assume that you already have set up one of the supported database management systems (DBMS) and that the database is functioning properly. You can use any of the following DBMS:

Actian Zen™ 14 (formerly known as “Pervasive® PSQL™“)

Microsoft® SQL Server^TM

NEW INSTALL: New Installation Checklist

Print this checklist to assist you in installing and configuring binSight v3.2.8.

UPGRADE: Upgrade Checklist

Print this checklist to assist you in upgrading from a previous version to binSight v3.2.8

IMPORTANT: If you are currently using binSight 2.6.0, you must upgrade to binSight 2.6.1 BEFORE upgrading to binSight 3.2.8

NEW INSTALL: The binSight Database

After you have verified that your computer or computers meet the hardware and software requirements, and you have the database management system you plan to use, you’re ready to set up the binSight database. The following sections contain instructions for setting up the binSight database for each of the supported DBMS.

Important: You only need to create the binSight Database for new installations. If you are upgrading to the current version of binSight, you should skip this section.

Click the name of the DBMS you are using to move directly to the appropriate section:

Pervasive® PSQL™ or Actian Zen^TM 14

Microsoft® SQL Server^TM

Actian Zen™ (formerly “Pervasive^® PSQL™”)

If you already use AGRIS in your agribusiness operation, you may already have an Actian Zen database server available to use. The following information will help guide you through creating a new binSight database on an Actian Zen server and then set up an administrator account for the binSight database.

If you are using the WorkGroup version of Actian Zen, please be aware that Cultura Technologies LLC recommends that the WorkGroup version is installed to run as a Service instead of as an Application. If you need assistance in determining how your WorkGroup is installed contact the Technical Assistance Center.

Creating the binSight Database

The first step to using binSight is to create a place to store your bin transactions and history. Complete the following procedure to create a binSight database on Actian Zen.

To create the binSight database folder:

Open Windows^® Explorer:

Expand the My Computer node on Windows^® 8.1 or This PC on Windows^® 10.

If you have more than one hard disk drive, select the letter for the drive, typically Local Disk (C:) or Local Disk (D:), where you want to create a binSight database folder.

Create a new folder, named apps. Right click on Windows^® (C:)
New >> Folder – Type apps when the new folder appears.

Double-click the apps folder to open it.

Create a new folder under apps, named binSight. Right click in apps.
New >> Folder – Type binSight when the new folder appears.

Double-click the binSight folder to open it.

Create a new folder, named BinDB. Right click in binSight.
New >> Folder – Type BinDB when the new folder appears.

Close Windows^® Explorer.

To create a new database:

Open the Actian Pervasive^® Control Center:

In the left-hand frame, expand the Engines node.

Right-click the name of your server and select New Database.

Note: The server name is typically the Computer Name of the computer on which you are working.

Type BinDB in the Database Name field.

Type, or browse to, the binSight database folder.
<drive>:\apps\binSight\BinDB

Ensure that the following checkboxes are checked:

• Create dictionary files (if they do not exist)

• Relational integrity enforced

• (DSN Options) Create Engine DSN

Click Finish.

Note: If you receive a prompt at this point requesting a username and password then there is a permissions problem with your installation of Actian Zen. If you are using the WorkGroup version of Actian Zen please verify that it is installed as a Service.

To enable security:

Right-click BinDB and select Properties.

Click Security.

Click the Enable Security option.

If you are using Pervasive version 13.0 or higher you need to select the “Enabled (Local database authentication)” option, see figure below.

Type binadmin in the Master Password field.

Type binadmin in the Confirm Password field.

Click Apply.

Click OK.

Setting up the Database Administrator

Once you have created the binSight database, you need to set up a user, for that database, who can maintain the data, create new users, manage user privileges, and perform any other necessary database operations. Complete the following procedure to create the database administrator account for use with binSight.

To create a binSight database administrator:

Expand the BinDB node and right-click Users.

Select New >> User.

Type bin_db_admin in the Name field.

Type binadmin in the Password field.

Type binadmin in the Confirm password field.

Do not select a Group.

Click Finish.

To set up the administrator permissions:

1. Expand the BinDB [Master] node.

2. Expand the User node.

Right-click the bin_db_admin user and select Properties.

Click Permissions.

On the Database tab, mark ALL the options for the selected user.

Click OK.

Microsoft^® SQL Server™

Microsoft SQL Server 2014, 2016, or 2019 Express, Standard, or Professional. As with Pervasive PSQL, there are two parts to setting up the SQL Server database for binSight. Use the information in the following sections to help you set up the database and the binSight database administrator.

Creating the binSight Database

The first step to using binSight is to create a place to store your bin transactions and history. Complete the following procedure to create a binSight database on Microsoft SQL Server.

To create the binSight database (BinDB):

Open the SQL Server Management Studio.

When the Connect to Server window displays, type <servername>\<instancename> in the Server name field.

Select SQL Server Authentication in the Authentication list.

Type sa in the Username field.

If you have not already set up a password for the administrator account, leave the Password field blank.

Note: This step assumes you have not set up a SQL server administrator password prior to this point. If you have already set up an administrator password, type that password in the Password field.

Click Connect.

Right-click the Databases node and choose New Database...

In the Database Name field, type BinDB

In the Owner field, accept the value of <default>.

Click OK.

Setting up the Database Administrator

Once you have created the binSight database, you need to set up a user, for that database, who can maintain the data, create new users, manage user privileges, and perform any other necessary database operations. Complete the following procedure to create the database administrator account for use with binSight.

To create the binSight administrator (bin_db_admin):

1. Continue using the same SQL Server Management Studio session from the previous Creating the binSight Database procedure.

2. Expand the Security node.

Right-click the Logins folder and select New Login…

When the Login – New window displays, type bin_db_admin in the Login name field.

Select the SQL Server Authentication option.

Type binadmin in the Password field

Type binadmin in the Confirm password field.

Uncheck the following options:

Click the Server Roles page.

Click ALL the Server Roles options.

Click the User Mapping page.

Click the BinDB option.

In the Default Schema column, click the Browse button to open the Select Schema window.

Click Browse…

Click the [dbo] schema.

Click OK.

Click OK.

Click OK.

Close the SQL Server Management Studio window.

Enabling TCP/IP

Open the SQL Server Configuration Manager.

1. Expand the SQL Server Network Configuration node.

2. Click on Protocols for <instancename>

3. Right-click on TCP/IP and choose Properties

4. Select Yes for Enabled

5. Click on the IP Addresses tab

6. Scroll down to the IPAll section

7. Set the TCP Dynamic Ports value to 1433

8. Click OK, then click OK again on the Warning message that indicates that the change will not take effect until the service is stopped and restarted.

9. Click on SQL Server Services

10. Right-click on SQL Server (<instancename>) and choose Restart

11. Close the SQL Server Configuration Manager

Installation of the binSight v3.2.8 Server

Installing or Upgrading the Server Software

The first part to completing the server installation is to load the application followed by settings configuration. Complete the following steps to install the application on your server.

Go to the Downloads Tab – then Click on the binSight Tab and then 3.2.8 link

1. Under Download – Click the Version 3.2.8 link to download and install the Service Pack.

   1. After downloading the service pack, unzip it (Right click on the zip file >> Extract all…)

   2. Double-click on the binsight_3_2_6.exe file to start the installation process

      1. After all the files finish installing you will see a Welcome to the binSight Setup window

The Welcome to binSight Wizard Window

Click Next to display the Select Destination Directory window.

The Select Destination Directory Window

The Destination Folder will default to c:\apps\binsight. To change the Destination Folder, type the desired folder path or use the Browse button to select a folder.

Click Next to display the Select Additional Tasks window. Leave the Install Server Services checkbox checked.

The Select Additional Tasks Window

Click Next to display the Server URL and Port Configuration. The URL will default to http://localhost:8080. Insert the binSight server name in place of localhost or use the binSight’s server IP address.

Click Next to display the Select Start Menu Folder window

The Select Start Menu Folder Window

The Start Menu folder will default to binSight. To change the Start Menu folder, type the desired folder name. Leave the Create Start Menu Folder and Create shortcuts for all users checked.

Click Next to start the installation process. The installer indicates the progress of the extraction and installation process.

The Installation Progress Bar

The binSight services are installed in a Command Prompt window, and then a web browser windows displays the binSight™ Database Configuration page. If this page does not immediately display, refresh the browser by pressing the F5 function key.

The Command Prompt window

Refresh browser by pressing F5 function key

The Database Configuration Sign-In Page

Type admin in the User Name field.

Type admin in the Password field.

Click Sign In to display the binSight Database Configuration page.

IMPORTANT: At this point you will either upgrade the existing binSight database, or, if this is a new install you will create/complete a new binSight database.

UPGRADE: To upgrade an existing binSight database:

Click the Edit Current Configuration link

The Database Type defaults to Pervasive. Select the type that you are using: Pervasive or SQL Server.

The Schema Name defaults to BinDB. For most users this is the correct name, however if you are using a binSight database with a name that is not BinDB then type that name for the Schema Name.

The Port defaults based on the selected Database Type. Do not change the default.

The Server Name defaults to localhost. If you are on the binSight server, you do not need to change this. If you are on a machine other than the binSight server then type the binSight server name or the IP Address of the binSight server.

The Database User and Password default to bin_db_admin and binadmin, respectively. For most users these are the proper settings and defaulted in.

Click the Save Changes button.

After saving changes, your Current Configuration will display. Below is a screenshot example of a Pervasive database.

Click the Upgrade tab.

The Upgrade dialog screen (above) allows the user to select to Back Up their current database before the software Upgrade. If you do not want your DB to be backed up, simply uncheck the checkbox sown on the screen.

Click the Upgrade button.

Depending on the size of your binSight database, the process can take several minutes to complete. The process is complete when the browser indicates the binSight Version of 3.2.8, as in the following screenshot where <version> would indicate 3.2.8.

Click the Sign Out link

Close the Internet browser window.

Close the Command Prompt window.

Select Finish button on Setup Wizard

Proceed to Stop binSight Service

Proceed to Start BMS Production-Admin

NEW INSTALL: To create a new binSight database:

1. To create a new binSight database:

On the Create tab, assign your new binSight database options:

Note: Changing the selection in the Database Type will automatically set the port number to the default value for the selected DBMS. You can change the port number, as appropriate for your network configuration.

The binSight Database Configuration Page

Click Create New Database to refresh the Database Configuration page and display your new Current Configuration settings. This can process can take up to a minute to complete and refresh the browser. The binSight Version in the upper panel should read 3.2.8 when finished.

The binSight Database Configuration Page

Close the Internet browser window.

Close the Command Prompt window.

NEW INSTALL: Install the binSight machine id license file

If this is a new installation of binSight, you will need to install the binSight license. If you do not have a binSight license for this installation, contact the Technical Assistance Center. This license file is typically delivered via email.

1. Open the folder or CD that has the binSight.lic file.

2. Right-click on this file and select Copy

3. Open the binSight installation folder. This folder is typically c:\apps\binsight.

4. Open the tomcat64 folder

5. Open the conf folder

6. Right-click in this folder and select Paste

Starting the BMS binSight Production-Admin Service

The BMS has several services, the two main ones are: The BMS Web Configuration-Admin, which is used for database configuration, and the other is the BMS binSight Production-Admin, which is used to switch BMS to Production mode.

Switching binSight to Production mode after software installation:

1. Click on the Windows Start icon (Lower left for Windows 10)

2. Open the binSight folder to display all the BMS services, see above figure.

3. Click the Start BMS Production-Admin service

Run the binSight client on the binSight Server

At this point in the installation, the binSight server and client have been installed and configured to run on the binSight server; however, if you wish to install the binSight client on a different workstation, go to section 4.

Installation of the binSight v3.2.8 Client

NOTE: The “silent” client installation of binSight is provided for administrators wanting to manage the installation or upgrade of multiple clients without having to monitor each client installation. To do a silent client installation:

1. Open a Command prompt window

2. Navigate to the folder where the binSight software was downloaded

3. Type the following command-line arguments:

Note: -q is required for arguments to take effect

Examples:

binSight_3_2_8.exe –q –VFirstRunConfig=true

(Will update the existing client or install a new client to the new release and will set the server to “localhost”)

binSight_3_2_8.exe –q -VServerUrlArg=http://yourServerURL:8080

(Will install a new client where “yourServerURL” is the name of your server’s name, IP Address, or URL)

binSight_3_2_8.exe –q -VFirstRunConfig=true -VServerUrlArg=http://yourServerURL:8080

(Will install the client using the “First time” installation mode and will set the server to “your Server URL”)

To install the client:

1. Log on to the binSight Client PC as a system administrator.

2. Open the folder where you downloaded or installed the binSight release software.

3. Click the binSight_3_2_8.exe link or, directly from the CD, run binSight_3_2_8.exe.

Note: If a File Download message appears, click Run >> Open, or click Yes, depending on the buttons presented. The Welcome to the binSight Setup Wizard window displays.

The Welcome to binSight Wizard Window

If the installer detects a previous version on binSight, Click Next if you wish to have the server connection be set to the current server; If this is a new client installation then select the “No, Install into a different directory” option and Click Next to continue to display the Select Destination Directory window.

The Choose Install Location Window

The Destination Folder will default to c:\apps\binsight. To change the Destination Folder, type the desired folder path or use the Browse button to select a folder.

Click Next to display the Select Additional Tasks window. Uncheck the Install Server Services checkbox.

Click Next to display the Server URL and Port Configuration. The URL will default to http://localhost:8080.

The Server URL and Port Configuration Window

Enter the binSight’s server computer name, or IP address in the URL path replacing “localhost”; you can use the server’s name but is recommended to use the server’s IP address.

Click Next to display the Select Start Menu Folder window

The Start Menu folder will default to binSight. To change the Start Menu folder, type the desired folder name. Leave the Create Start Menu Folder and Create shortcuts for all users’ checkboxes checked.

Click Next to start the installation process.

The installer indicates the progress of the extraction and installation process.

The Installation Progress Bar

This process also creates a desktop shortcut for the binSight client. This shortcut starts the binSight bin management interface.

Optional Integration Configuration

If you have purchased a license to use AGRIS v9.5.0 Service Pack 15 or later, and oneWeigh, you can integrate oneWeigh and binSight to communicate data with each other, making for a more robust commodity management environment. Use the following sections to establish a connection between oneWeigh and binSight and enable binSight to use oneWeigh Transfer Tickets.

Integrating binSight and oneWeigh

By default, binSight will use the gross quantity on tickets exported by oneWeigh. To configure binSight to use the net quantity on tickets exported by oneWeigh, please contact the Technical Assistance Center.

Setting Up binSight to Use oneWeigh Transfer Tickets

If you intend to transfer tickets through oneWeigh, perform this procedure prior to using binSight. The following sections guide you through setting up binSight to use oneWeigh transfer tickets.

Note: For the application to function properly while performing these setup tasks, you must first set the oneWeigh Ticket mode to Add.

Setting Up oneWeigh Extended Options

The first task you need to complete is to set up the extended options in AGRIS for oneWeigh to communicate with binSight. Complete the following steps to turn on the extended options.

To set up the oneWeigh extended options:

1. Start AGRIS.

2. Choose the dataset and location you want to use and click Select.

3. Type your User ID and Password.

4. Click Sign On.

5. Open the oneWeigh Extended Options window.
   Maintenance >> Dataset Maintenance >> select a dataset >> Extended Options >> ONE

6. Type Y in the binSight Interface (#10) field.

7. Click Save.

8. Click Back.

9. Click OK.

10. Click Back.

Setting Up oneWeigh Workstation Options

Complete the following procedure to set up your oneWeigh workstation options for communicating data to binSight v3.2.8.

To set up the oneWeigh workstation options:

1. Start AGRIS.

2. Choose the default dataset and location you want to use and click Select.

3. Type your User ID and Password.

4. Click Sign On.

5. Open the Station – oneWeigh Scale Automation System window.
   ONE >> Setup Information >> Workstation Information

6. Click the binSight Tab.

7. Check the binSight Integration option.

8. Ensure the URL value is correct:
   http://localhost:8080/agris/services/BinManagement

Note: The localhost default only works when binSight and oneWeigh are installed on the same workstation. If the two applications are on separate workstations, you must change “localhost” to the name of the workstation on which binSight is installed and running.

1. To use the Bin Assignment on the Ticket Entry screen check, Enable Ticket Entry Bin Select AND Sizable Ticket Grid on the General Tab

2. It is recommended to check Suppress Inbound Reservations unless there are steel bins that are hard to measure

3. To use the Default Bin(s) per Commodity feature, check the Use Default Bins option.

4. If you can use the bulkWeigh feature to transfer grain around your facility using the bulkweigher, check the Allow Bin Transfers option.

5. Check Send Blank Grade Factors

6. If you are running binSight in multiple locations, click the name of the facility you want to associate with the current workstation in the Facility list.

7. Click Save.

Setting Up oneWeigh Workstation Defaults

The final piece to integrating oneWeigh and binSight is to set up the default grade factors sent from binSight to oneWeigh if desired. Complete the following steps to set up the workstation defaults.

To set up the oneWeigh workstation defaults:

1. Open the Station – oneWeigh Scale Automation System window.
   ONE >> Setup Information >> Workstation Information

2. Click the Commodities/Discount tab.

3. Select a Default Outbound Grade Factors from Bin option.

4. Select the appropriate method for sending Average Grade Factors from binSight to oneWeigh Outbound Tickets, based on your intended system use:

Always (No Override) automatically sets the grades from binSight on each Outbound ticket.

Yes (Allow Override) asks, during each Outbound ticket, if you want to set the grades from binSight.

No does not send the average grade factors from binSight into oneWeigh.

Note: Both the Always and Yes options allow you to edit the default values before printing the ticket. Generally, this option is set to No.

Click Save.

¹

^I