Skip to content


Tech Thursday: Making SmartView and Binary Stream work together

For those of you using Binary Stream, you know that there are SmartLists specially built to pull in the additional data.  These are specifically built by Binary Stream to pull in their additional data as well as take into account the additional security that they add.  Because these lists are built to specifically work with SmartList, you will not see the additional data in SmartView for Binary Stream.

You can use SmartList Builder to build new lists to pull the Binary Stream data into SmartView without too much work. Binary Stream has a document written to help you with that setup.  The one thing that is a little bit harder to integrate into that list is the Binary Stream security for that.

To get the extra security layer into the list for SmartView External, there is a little bit of additional setup to ensure.
  • All SmartView External users need to be linked to a GP User, not role in the SmartView External User setup.
  • All of the SmartView External users need to have something the same.  For example, have them all start or end with ‘SV’.  This is so that we can easily link them to the Binary Stream security setup.

Binary Stream security is setup to use your GP user.  SmartView Internal will always call the data using a special SmartView user.  SmartView External will connect with the users you have specifically setup, but they are different than your GP user.  So, to make it work, there are a few additional steps we have to go through.

1.  We have to add one additional table to the SmartList Builder setup from the SmartView Product called ‘External Users’.  

a.  You will link the table to the list by joining it to the BSSI_User_Facility as seen below.  Select the Security Role ID from the External 

2.  Once the table has been linked, we can setup a Calculated Field so that we can pick out the SmartView user compared to the GP user an only display the data they should see when logged in. 
a.  We setup the calculation to return a ‘1’ if our GP user and the SmartView user match.  If they don’t it will return a ‘0’.  

b.  The text of the calculation is as follows:
WHEN system_user like ‘SV%’ THEN isnull((select 1 where {External Users:User ID} = system_user), 0)
WHEN system_user like ‘%SV’ THEN isnull((select 1 where {External Users:User ID} = system_user), 0)
ELSE isnull((select 1 where {BSSI_User_Facility_Backup_Original:User ID} = system_user), 0)

3.  Once the calculation is in place, we can setup a restriction to just pull out the data where the value is 1.

This is everything that has to be setup. Once it is saved and SmartView updated, it should return the data only for the user that is logged in such as below when I am logged into SmartView as SVTest who is linked to the clerk 1 user in GP.

Leave a Comment


Popdock Data Lake Upload Tool - Free Training on April 5th
eOne Sessions at Directions North America 2023
Connect with eOne Solutions at Directions North America 2023!
Tech Tuesday: Creating a Summarize List by States Between Two Systems
eOne Sessions at Days of Knowledge UK - Live from Birmingham!


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.