Media4Display and MediaContact variables and metadata

Media4Display and MediaContact variables and metadata


List of variables used in MediaContact and Media4Display

Company variables

  1. %COMPANY%: User's company identifier.
  1. %AliasServerCompany=AliasCompany%: Company Alias value (where AliasCompany refers to a Company Alias) 
  2. %T_COMPANIES.property%: a user's company property: a field from the company table or one of the tables associated with companies.
  1. User
  1. %USER%: user identifier (unique in a company).
  1. %AliasServerUser=AliasUser%: User Alias value (where AliasUser refers to a Server Alias)
    This is used for Media4Display metadata.
  1. %AliasStation=AliasUser%: User Alias value (where AliasUser refers to a Station Alias)
  1. %T_USERS.property%: a user property: a field from the user table or one of the tables associated with users.
  1. %StationComputerName%: short name of the remote machine.
  1. %StationFullComputerName%: full DNS name of the remote machine.
  1. %StationLoginName%: name of the authenticated user.
  1. %SDCardName%: name of the SD card. If the station has several SD cards, you can create an empty mediacontact.sdcard file on the root of the card of which you want to take account (Windows Mobile only).
  1. %ExternalSDCardName%: name of the external SD card (Android only).
  1. %StationMobileNetworkCode%: code of the mobile network to which the station is connected (Windows Mobile only).
  1. %StationMobileCountryCode%: country code of the mobile network to which the station is connected (Windows Mobile only).
  1. %IPV4%: LAN IP address of the device (Android only)


Date

%LASTSQLEXECUTE% is only used in SQL export for import tasks. It designates the date on which, for this task, for a user, for a target table, a SELECT command has been executed. If the source table contains a last update field, it allows the following type of SELECT command:
SELECT * FROM Clients WHERE VendorCode = %AliasServerUser=Salesperson% AND UpdateDate > #%LASTSQLEXECUTE%#

Standard folder variables

Folders belonging to each user (station variables, or if server variables, their names contain the %COMPANY%\%USER% variables). They designate the standard exchange folders used in the Standard transfer task or standard station folders:
Server standard exchange folders
  1. Departure: %ServerXOut%
  1. Arrival: %ServerXIn%
  1. Station standard exchange folders
  1. Departure: %StationXOut%
  1. Arrival: %StationXIn%
  1. Other standard station folders
  1. %StationBackup%: Standard station backup folder
  1. %StationSoftwareIn%: Standard station software distribution arrival folder

Internal MediaContact variables independent of users

Use of these variables, as for variables associated with the user, is suggested by the Administration Console at various stages in the definition of tasks. It is not necessary that the process is associated with a population for them to be used. These are:

Non-specialized variables:
  1. %DATE%: Execution date in the form YYYYMMDD (year in 4 figures, month in 2 figures and day in 2 figures)
  1. %DATEYYYY%: Execution year in 4 figures
  1. %DATEYY%: Execution year in 2 figures
  1. %DATEMM%: Execution month in 2 figures
  1. %DATEDD%: Execution day of month in 2 figures
  1. %WEEKDAY%: Number of day in week, 1 to 7 (Sunday is the first day)
  1. %YEARDAY%: Number of day in year
  1. %HOUR%: Time of execution in the form HHMMSS (hours, minutes and seconds in 2 figures respectively)
  1. %MILLISECOND%: Milliseconds of the current hour in 3 figures
  1. %DATE(format)[+n|-n]%: Date formatted according to specifications (see below)
  1. +n: add n days to the current date
  1. -n: subtract n days to the current date
  1. Example: %DATE(dd/MM/yyyy HH:mm:ss)-1%
  1. Folders that are not individualized (their names do not contain a user or company variable):
  1. %ServerBackup%: Standard server backup folder
  1. %ServerSoftwareOut%: Standard server departure software distribution folder
  1. %InstallFolder% : Installation folder for MediaContact (C:\Program files...\bin\)

d
Day as 1 digit, if <=9
1
dd
Day as 2 digits
01
ddd
Day (short)
Sat
dddd
Day (long)
Saturday
M
Month as 1 digit, if <=9
2
MM
Month as 2 digits
02
MMM
Month (short)
Feb
MMMM
Month (long)
February
yy
Year as 2 digits
03
yyyy
Year as 4 digits
2003
h
Hours of 12-hour clock as 1 digit, if <= 9
4
hh
Hours of 12-hour clock as 2 digits
04
H
Hours of 24-hour clock as 1 digit, if <= 9
4
HH
Hours of 24-hour clock as 2 digits
04
m
Minutes as 1 digit, if <=9
5
mm
Minutes as 2 digits
05
s
Seconds as 1 digit, if <= 9
6
ss
Seconds as 2 digits
06
tt
AM/PM as 2 characters
AM

The format may also be a key word from those defined below. In this case, the resulting value depends on the language selected from the regional and linguistic options.

SHORTDATE
Short date using the local format
01/02/2003
LONGDATE
Long date using the local format
Saturday, February 1st, 2003
SHORTTIME
Short time using the local format (without seconds)
16:05 or 4:05 PM
LONGTIME
Time using the local format
16:05:06 or 4:05:06 PM

Environment variables external to MediaContact

An environment variable used in MediaContact is written as:
%$variable% to be interpreted by the scheduler at the execution location.
Example: %$TEMP%

    • Related Articles

    • How to retrieve Media4Display diagnostic logs using MediaContact on Android

      The easiest way to retrieve Media4Display diagnostic logs on Android is simply to create a process in MediaContact. In a custom process folder, create a new process. Process trigger initiative: Server Population: create and select the population you ...

    • How to backup (and restore!) your Media4Display system?

      Backing up Media4Display In order to keep your Media4Display system running and to make sure that it will keep running even after a minor or major hardware issue, you need to back up your data, configuration and settings. Backing up your cloud ...

    • Configuring M4D for Teamviewer remote access

      → https://ds.oomnis.com/media4display/Help/en/media4display-help.html#M4DSetupRemoteViewer In order to setup the "remote access" shortcut in Media4Display, the remote access tool must first be retrieved on the concerned player. You must then prepare ...

    • Change FlexO Server IP Address on Windows

      In the event one needs to change the IP address of the FlexO server, this can be achieved by updating the Windows Environment Variables, then restart FlexO service. Open System panel and click on Advance system settings. Click on Environment ...

    • ファイル転送はと遅い時

      M4DとMediaContactでTCPプロトコルを使う時にプロトコルの最適化を行わなければなりません。 Configuration > Communication Settings > Protocol Sliding WindowsとData block sizeとDisk access buffer sizeを全部一番高い値に変える必要があります。 その後、MediaContactのサービスを再起動して、同期を再びかけたら、早くなります。