A manufacturing company was in search of a method for displaying shift assignment information (on multiple screens) for up to 300 temporary workers a day across 49 resources. After a rapid evaluation of several products, Noventri was chosen as the solution and it blew away many much more expensive solutions.

Digital Signage in a Manufacturing Environment

Mark Anderson for | AVSystemsMag

A manufacturing company was in search of a method for displaying shift assignment information (on multiple screens) for up to 300 temporary workers a day across 49 resources. After a rapid evaluation of several products, Noventri was chosen as the solution and it blew away many much more expensive solutions.

Requirements

A large manufacturing company (whose name must, unfortunately remain confidential) was in search of a solution for displaying shift assignment information (on multiple screens) for up to 300 temporary workers a day, across 49 resources. Before the implementation, shift assignments were carried out by departmental supervisors using Excel, but a shift change operation (or large job change) turned into a very large marshaling exercise.

As data would be entered by several users per shift and over three shifts per day, minimal training was a key factor. Ideally, Excel would remain as the “data-entry” tool.

Although SaaS solutions we not ruled out (several were evaluated), security was a concern. The Corporation undergoes rigorous security audits on a regular basis, so anything that connected to the outside world would be of concern. Keeping Excel as the source data would also involve either automating transfer of the file to, or reading it from, an external server.

Dynamic Content

The data required for the sign was simple:

  • Date
  • ShiftNo
  • ResourceID
  • EmployeeID

Initially, the idea of using a local SQL database was investigated; however, it was soon discounted as an application would have to be designed to allow users to enter and manipulate data, or Excel data would have to be imported on a regular basis. Even though the tools and skills were in place for this, it would have delayed the project and added needless complexity.

Although a database was ruled out, SQL wasn’t. Using ODBC, any Excel sheet or cell range could be treated like an SQL table and queried using SQL. This list of candidate products suddenly expanded from those that could support Excel or delimited text files (such as CSV) to anything that supported SQL and ODBC.

The screen shot below shows the requested Excel sheet layout for entering the (part of the) data.

  • Rows 1 and 9 contained resource names
  • Rows 2-7 and 10-13 contained employee ID’s. (These were preferred over Employee names, and are retrieved from the time and attendance system)

In the screenshot above, we can see the selected area (F9:F15) is a named range called “Attach1”. This is a resource that requires up to 6 staff. As named ranges are used, the Excel sheet layout can be changed without breaking the connection as long as entire ranges are moved.

Querying the Data Source

This was the killer for most SaaS services. Every SaaS product evaluated was unable to obtain dynamic data from an SQL database or an Excel or csv file (even if the file were uploaded to the SaaS server). All the vendors said the same: “just create and RSS feed or an XML web service”; “you could write a script to do it” or “we could build a custom app/widget to do it”

While none of these approaches is rocket science, there are many reasons not to do it:

  1. Longer implementation time
  2. More costly
  3. Introduces unnecessary complexity
  4. Makes every other signage project an IT project.

The chances of rolling out digital signage to many other areas of the business are much higher when the IT department’s involvement is limited to providing the hardware and network. If it’s simple enough for end users to use, they’ll experiment.

In Noventri Suite software, querying the data was a simple three-step process:

  1. Create a text area
  2. Link the Excel sheet
  3. Write a very simple line of SQL

The screen shot below shows this in the Noventri user interface.

Clicking the connect button allows the user to connect to the required data source: in this case, browse to the Excel file. The refresh interval can also be set. In the above example, the Excel files is queried every five minutes.

The select button allows the user to select a table or enter an SQL statement. In the screenshot below, the named ranges appear as tables and the user simply selects the table where the source data is located.

As the user was pretty familiar with SQL, a simple SQL statement sorted out the results and formatting:

The “Cstr()” converted the number to a string (losing the decimals) and the “WHERE [AT-1] is not null” clause filtered out empty cells. (An ORDER BY clause be added to sort the data, but in this application it’s already sorted.)

Final Design

Ultimately, three pages were designed that covered three departmental groups. The source data was split among three Excel spread sheets and the supervisors simply edit the file and copy it to a mapped network drive. The updated information will be displayed on the sign no longer than five minutes after a new version is copied.

The screenshot below shows the final design of one of the pages (branding removed). UPDATE IMAGE

Sequencing

The sequence for the initial roll-out of this application was very simple: display each of the three screens for 15 seconds.

Schedules

Like the sequence, the schedule is initially very simple: play the same sequence 24/7. In the future, the shift assignments will be display 30 minutes either side of shift change and job performance information (from the ERP system) will be displayed during the shift.

Serving it Up

The Noventri software also includes a free server component (Windows-based). This allows projects to be retrieved for editing and uploaded for deployment. It also manages communication with the players. The workflow is very simple:

  1. Create/update the project (pages design and sequence)
  2. Deploy to server
  3. Create a schedule (which sequence plays when)
  4. Activate the schedule on the selected player (or groups of players)

Hardware

The hardware used for the project was a Noventri SF-100e player connected via 100BaseT.

http://www.noventri.com/images/SF100/SF100-Tech-Specs/Tech-Specs-Size.jpg

The display selected was a commercial grade Samsung 46” LCD (460UX-3) connect via HDMI.

A Peerless freestanding display mount (FPZ-600) was used to mount the test installation. Ultimately the monitors will be suspended from the ceiling.

Surprises

There were several surprises for the client along the way. The three biggest ones were:

  • Most of the software is free. Unless you’re looking for high-end integration/metrics, there’s a free software package (or low-cost SaaS service for many players).
  • SaaS falls down quickly in areas where dynamic data is not available in XML format.
  • Many editing tools are very poor: they either look like they were ported from an Atari or have a level of functionality below PowerPoint v1.0. (No alignment or distribution tools, no multiple object copy and paste, no step and repeat, no multi-object property editing, little use of context sensitive menu, very strange user interfaces, etc.)

Future

Further players have been ordered for additional screens in the manufacturing plant, and another player has been ordered to replace a PC and PowerPoint slide show in reception. Currently, the receptionist updates this every day with visitors and current weather. I future, visitor will listed in an Excel file (or possibly retrieved from Outlook) and the weather will be populated automatically from an RSS feed. With the software being so easy to use and central management of the players, many other projects will follow.

Conclusion

At the start of the project, the client envisaged a several thousand dollar software/player combination. They were amazed at how much was possible with such a small, low power (3W), inexpensive ($599) player. Bang for the buck with Noventri was amazing. Several much higher end products were evaluated and didn’t come close to Noventri, especially when considering the amount of integration that would have been required and the total cost of ownership. The cost of entry and skill level required to enter into digital signage is within the grasp of any business (big or small). Being so inexpensive and easy to use will make digital signage much more pervasive, which, at the end of the day, is what everyone wants: better, more focused communication.


Comments (0)

This post does not have any comments. Be the first to leave a comment below.


Post A Comment

You must be logged in before you can post a comment. Login now.

Featured Product

PureLink - HCE III TX/RX: 4K HDR over HDBaseT Extension System w/ Control and Bi-Directional PoE

PureLink - HCE III TX/RX: 4K HDR over HDBaseT Extension System w/ Control and Bi-Directional PoE

The HCE III Tx/Rx HDBaseT™ extension system offers full HDMI 2.0 compliance supporting HDR (High Dynamic Range) and 4K@60Hz with 4:4:4 chroma sampling. Featuring PureLink's proprietary Pr©cis codec, a light compression technology, the HCE III can transport Ultra HD/4K, multi-channel audio, and High Dynamic Range (10 bits support) content over a single CATx cable. The HCE III provides HDMI extension up to 130 feet (40 meters) at Ultra HD/4K and up to 230 ft. (70 meters) at 1080p over category cable with embedded multi-channel audio, CEC pass-through, bi-directional RS-232 and IR control, and PoE - all with zero loss and zero noise. The HCE III Tx/Rx also supports Dolby TrueHD, Dolby Digital Plus and DTS-HD Master Audio plus LCPM (up to 192 kHz). Additionally, the low profile "slim box" enclosure design make the HCE III ideal for limited space installation environments, such as behind flat panel displays and video walls.