This launches another window in which you can define the columns for the data. When it refers to the ‘primary key’, this means the reference column which is going to be the same across all the tiers. In this case it will be the Product Code.
- Enter ‘Product Code’ as the column name and click ‘Add Column’. Click the key icon to make this column the primary key.
- Enter ‘Product Name’ as the next column name and click ‘Add Column’.
- Enter ‘Price’ as the last column name and click ‘Add Column’.
- Click the ‘Add Data Object’ button.
The data object has now been created, but at this point it only has one tier (Standard Restaurants) and there are no data items/rows (no meals). The next stage is to add the rows for the Standard Restaurants tier.
- Click the pencil icon on your Data Object row to edit it.
- Click the pencil icon on the ‘Standard Restaurants’ tier.
- Click the plus (+) icon near the top to add a new item/row.
- In the Product Code field, enter 376 (the unique product code for Super Saver Meal).
- In the Product Name field, enter ‘Super Saver Meal’.
- In the Price field, enter ‘3.50’ (there’s no need to include a ‘£’ symbol – that can be added in the sign itself).
- Click ‘Add Row’.
- Repeat the above for the other three products.
Now you have defined a complete pricing tier for the Standard Restaurants. To define a tier for the London Restaurants, the easiest method is as follows:
- Click back to the ‘Meal Prices’ Data Object and select the ‘Standard Restaurants’ tier.
- Click the ‘Duplicate Tier’ icon near the top and enter ‘London Restaurants’ as the name.
- This creates a new tier with the same data as the Standard Restaurants.
- You can now edit the price data (click the pencil icon or double-click the row) to set the higher London prices.
Note that a data object will also accept data from a spreadsheet, which may be more convenient. The top row of the spreadsheet should contain the column headings, with the data rows for a given tier underneath. Save the spreadsheet as a CSV (Comma-Separated Values) file.
Then you can upload it to Director, either when creating the data object (by choosing ‘CSV file’ as the ‘Data source’), or when editing a tier (by clicking the up-arrow icon near the top).
With the data object fully defined, it can now be referenced in a sign as described below.
Using a Data Object in a Sign
To create a price list sign for meals open your sign in Creator.
- Click the ‘Data Object Tool’ button in the Tools panel at the top left.
- Choose the ‘Meal Prices’ data object you prepared earlier. This adds a new layer to the Layers panel.
This new layer has no direct presence on the signage canvas itself, but you can set options on it via the Tool Options panel at the bottom right. Specifically, you can decide which tier you want to use for previewing. For example, when constructing the sign, you can choose whether you want to see Standard Restaurants or London Restaurants pricing.
For now, leave this set to ‘Standard Restaurants’.
- Use the ‘Text Tool’ to add a Text layer.
- In the ‘Tool Options’ panel, click the ‘Content’ tab and set the ‘Content Type’ to be ‘Data Object’.
- Set the ‘Data Object Layer’ to be the ‘Meal Prices’ data object you prepared earlier.
- Set ‘Show Column’ to be ‘Product Name’.
- Set ‘Primary key value’ to be 376, which corresponds to ‘Super Saver Meal’.
- The text layer will now show ‘Super Saver Meal’.
- Add another Text layer as above, but this time position it just to the right of the first layer, and set the ‘Show Column’ to be ‘Price’. Also set the ‘Prefix’ to be ‘£’.
You should now see ‘Super Saver Meal £3.00’ on your sign.
You can add further products by repeating the process above but choosing different values for the primary key (e.g. 432) so that you see the data for a different product.
Save and publish your sign as normal.
Deploying a Data Object
The final step is to deploy your sign and data to your devices, ensuring that the right data tiers go to the right devices.
By default, the base tier data is used across all devices. But you can override this so that devices at a given location adopt a different tier, as follows.
Firstly, as a preparation step, navigate to the Devices page and check that the relevant devices have been assigned to an appropriate location. (In this example, ensure that devices which are physically in London have been put in the ‘London’ location.)
- Assign the sign to your device as described in Deploying a Sign.
- Now navigate to your Data Object.
- Select it and click the pencil icon to edit it.
- Click the locations icon on the ‘London Restaurants’ tier.
- This shows the (empty) list of locations that this data tier applies to.
- Click the plus (+) icon to add a location (i.e. ‘London’) then click ‘Select’ to confirm.
- Press the ‘Deploy’ button to deploy both the sign and the data to your devices.
Your restaurants in London and Cardiff should now be showing the appropriate pricing.