LANCOM Support Knowledgebase Document No. 1804.0514.3755.RHOO - V2.80

Transfer information to a LANCOM Wireless ePaper Display using Microsoft Excel



Description:

To make it easy to manually transmit information to a LANCOM Wireless ePaper Display, LANCOM Systems has provided Excel macros and display templates for the following scenarios:
  • Visitor badges
  • Room signs
  • Scheduling information for conference rooms

This document describes how to use the Excel macros to manually update information on the LANCOM Wireless ePaper Displays.


Requirements:
  • Installed and registered LANCOM Wireless ePaper Server as of version 1.40 (download latest version)
  • Registered and ready-to-operate ePaper displays
Excel macro files and display templates

Excel Makro - Visitors_EN.zipExcel Makro - Visitors_EN.zip Excel Makro - Meeting_EN.zipExcel Makro - Meeting_EN.zip
  • Microsoft Excel as of version 2007


Procedure:

1) Unpack the ZIP archive to any directory on your PC. Each folder contains an Excel macro file and one or more display templates (* .xsl).

You can tell which size of display the templates can be used for from the file name of the respective template (e.g. the.

2) Copy the template files that you want to use to the directory \data\template located in the installation directory of the LANCOM Wireless ePaper Server.

In this example, a 2.7” display is to be used as a badge for a visitor or employee.

3) Start the Excel macro file. A security warning will be displayed if the use of macros in Excel has been disabled. Click on Activate content to use the macro file.

4) Fill in the form with the data of your Wireless ePaper Server.
  • In the Server field you enter the local IP address where the ePaper server can be reached.
  • There is usually no need to change the value for the port unless the configuration of your ePaper server differs from the default settings.
  • In this example we retain the default setting used in the template. Enter the name of the template here if it is different to the standard name.
  • In the drop-down field Display ID you select the ID of the display where the contents should be displayed.

    The Excel file contains a second sheet named 2.7” Displays. Here, you enter the IDs of all of the displays that you have registered in the Wireless ePaper Server.

5) In the lower area you enter the contents to be shown on the 2.7” display. This example creates an employee badge.

The fields have the following sizes:
  • Status 30x254 Px Recommended number of characters: 11
  • Name 25x254 Px Recommended number of characters: 11
  • Company 25x254 Px Recommended number of characters: 17
  • Responsible 25x254 Px Recommended number of characters: 14
In the text fields Name, Company and Responsible, the font is automatically adjusted if you use more than the recommended number of characters. Depending on the number of extra characters, the text can appear rather cramped.

6) Click on Send to transfer the content to the 2.7” display.

7) If the content was successfully transferred to the display, the Transaction ID field displays a message, which includes the transaction ID for the transfer that was just performed.

The content appears on the display.

Catchwords: excel; sheet; epaper; display; template; manual
Please review this document! This document was helpful This document was not helpful