SIEMENS
4/43
Siemens CR 1 · 2015
4
■
Function
(continued)
SIMOCRANE CMS Crane Management System
SIMOCRANE RCMS
Microsoft SQL data retrieving and reporting using Excel
From the version V4.3 of SIMOCRANE CMS the possibility to
easy extract the data from Microsoft (MS) SQL for CMS and
RCMS is offered by using standard Microsoft programs such as
Excel. The MS Excel can be installed on any office PC in the ter-
minal. The PC should have access to the CMS or RCMS stations
in the network. No installation of CMS or RCMS on the office PC
is required, only a plug in for data access on the MS SQL data-
base in order to facilitate the connection from a remote PC to the
local MS SQL database. The Excel reporting tool needs to be
configured in the beginning, regarding the name of the PC and
the IP address. The operational data (moves, counters, timers,
etc.) and other data stored in the archive tags on CMS or RCMS
can be easily accessed remotely from an office PC. Fault mes-
sage scan be retrieved as well as statistical analysis can be per-
formed from different message groups.
Microsoft Excel tool for data retrieving and data representation/reporting from MS SQL databases on CMS and RCMS
G_CR01_EN_00370
LAN
Office PC (no installation of CMS/RCMS)
Microsoft
SQL
SIMOCRANE CMS Lean or
SIMOCRANE CMS Basic
SIMOCRANE CMS Lean or
SIMOCRANE CMS Basic
SIMOCRANE CMS Lean or
SIMOCRANE CMS Basic
SIMOCRANE RCMS
Crane #n
Crane #2
Crane #1
MS Excel 2010
(xls)
© Siemens AG 2015