ICP DAS USA MDCL-705i Скачать руководство пользователя страница 93

Страница: 93 / 96

∗

E-mail: [email protected] - 93 -

Q6: How to show timestamps with seconds in Excel?

A6: If you open a log file in Excel and see ############ in

DATATIME

line, simply increase the width

of the column to make the data visible.

Excel formats times without seconds by default, so we needs to change the formatting of the
column

DATATIME

according to the pattern “yyyy/m/d hh:mm:ss“ to see the seconds.

Here are the step-by-step instructions.

Содержание MDCL-705i

Страница 1: ...Written by Liam Lin Edited by Sunny Chiu MDCL 705i User Manual June 2021 Version 1 0 0...

Страница 2: ...uent to the use of this product ICP DAS reserves the right to change this manual at any time without notice The information furnished by ICP DAS is believed to be accurate and reliable However no resp...

Страница 3: ...olling Definitions 46 6 4 Application 47 7 Data Logger Configuration record csv 58 7 1 Logging Interval Configuration 59 7 2 Exporting Importing the Record csv File 61 7 3 Logging Channels Configurati...

Страница 4: ...pe from various Modbus RTU slave devices via the concentrator In other words through the help of a MDCL module the Modbus RTU slave devices can be accessed over Ethernet with better read and write per...

Страница 5: ...son the Web based user interface of the MDCL 705i is accessible from a wide variety of devices anywhere Users can configure the module and monitor connection status of each polling definition through...

Страница 6: ...es can be imported or exported from the module via a simple mouse click action One of the polling definitions may not be executed due to invalid parameters is given in the imported config csv file The...

Страница 7: ...Time Protocol and it is a networking protocol for clock synchronization between computer systems It is used to synchronize computer clock times in a network In order to ensure the data logged with cor...

Страница 8: ...its clock with the time of your local PC or an NTP server 2 Generate filename with creation date and time MDCL provides a consistent name format for log files that allows you to identify them The file...

Страница 9: ...f three MDCL modules are enabled to log data with different starting time and the same Maximum Logging Period of 6 hour is applied the log files will seem to start logging at the same time among these...

Страница 10: ...Import config csv Configure COM Port No No Yes Set logging time interval Export Edit record csv Log channel settings Yes Import record csv End No MDC configuration config csv Logger Configuration reco...

Страница 11: ...5 min 30 min 1 hr 6 hr Max Records 120 points per record Display Type 5 Digit 7 Segment LED Display display system information LED Indicators Status 1 x System to display heartbeat COM Port RS 232 1 c...

Страница 12: ...dbus TCP slave HTTP Socket Connections 8 Modbus TCP Power Input Range 10 VDC 48 VDC non regulated Consumption 2 W Mechanical Casing Metal Dimension 97 mm x 120 mm x 42mm W x L x H Installation DIN Rai...

Страница 13: ...CL 705i is equipped with a RJ45 port for Ethernet LAN connection When 100BASE TX is operating the 10 100M LED is lit orange When 10BASE T is operating or the machine is not connected to the network it...

Страница 14: ...dule as below 11111 1 192 2 168 3 255 4 1 22222 502 001 33333 1 1152 2 1152 44444 1 801 2 801 55555 00 The IP address for the MDCL 705i 192 168 255 1 Modbus TCP communication settings Port 502 Net ID...

Страница 15: ...l Rights Reserved E mail service icpdas com 15 Reset Shorting the RESET pin to GND pin over 3 seconds can reset the IP Subnet Mask Gateway addresses to the factory default settings Over 3 seconds to r...

Страница 16: ...16 2 3 Pin Assignments Terminal No Pin Assignment E1 COM2 01 D2 02 D2 03 GND 04 CTS 05 RTS 06 RxD 07 TxD 08 RESET COM1 09 D1 10 D1 11 R Vs 12 B GND Terminal No Pin Assignment COM5 26 DATA 25 DATA 24 2...

Страница 17: ...l Rights Reserved E mail service icpdas com 17 2 4 Wiring Connections RS 232 wiring 3 wire Connection Wiring Console port for connection with PC only RS 485 wiring MDCL 705i Modbus Device 1 Modbus Dev...

Страница 19: ...the Hardware Wall panel mounting Step 1 Install the four mounting screws into the 4 keyhole mounting holes Step 2 Fasten the screws securely DIN Rail mounting Step 1 Align the screw holes of the DIN r...

Страница 20: ...ight 2021 ICP DAS Co Ltd All Rights Reserved E mail service icpdas com 20 Step 2 Hook upper tab over upper flange of DIN rail Step 3 Tilt the module toward DIN rail until it snaps securely to DIN rail...

Страница 21: ...the MDCL module to the same network as your computer and power on all the devices You can also connect the module to PC directly with an Ethernet cable STEP 2 Set the IP configuration on your compute...

Страница 22: ...login Upon initial login through the web interface you will be prompted to create your user name and password as an administrator Both user name and password must be at least four characters they can...

Страница 23: ...password to log in to the MDCL module STEP 6 Confirm the connection status icon is open on the status bar 1 Enter your user name 2 Enter your password 3 Click LOGIN Denotes the connection between the...

Страница 24: ...255 0 0 Required Default Gateway Enter the Gateway address for the module 192 168 0 1 Required DNS Server 1 Enter the primary DNS server address IPv4 If a domain name is set for the NTP server or the...

Страница 25: ...art the module when your settings were completed Error message If an invalid setting is specified an error message will pop up after the SAVE button is clicked The field in error will be highlighted w...

Страница 26: ...interface is mainly divided into the following parts Item Description Title Displays the MDCL model number Navigation menu Houses text links to the section for configuring and managing the module s s...

Страница 27: ...o factory defaults The IP Subnet mask Gateway modified in a MDCL 700 can be reset to factory defaults by shorting the RESET pin to GND pin over 3 seconds The LED display will show RESET as below and t...

Страница 28: ...Enter a valid IP address 192 168 255 1 Required Subnet Mask Enter the Subnet Mask address 255 255 0 0 Required Default Gateway Enter the Gateway address 192 168 0 1 Required DNS Server 1 Enter the pr...

Страница 29: ...Restart Later an icon with label RESTART will be added on the status bar for restart the module later You can restart the module while your settings were completed Error message If an invalid setting...

Страница 30: ...m 30 4 2 User Management ongoing In order to protect the module from accidental modification while deployed on site the MDCL module allows you to create a view only user without the ability to change...

Страница 31: ...the button to synchronize the system time with the PC s clock Time zone Select the time zone from Time Zone dropdown menu Clock synchronization over network Network Time Server 1 Enter the IP address...

Страница 32: ...t the modules later Restart later If you click Restart Later an icon with label RESTART will be added on the status bar for restart the module later You can restart the module when your settings were...

Страница 33: ...Required FTP Server Enter the domain name or IP address of the FTP server Required FTP Control Port Enter the control port number on the FTP server 21 Required Login User Name Enter the user name for...

Страница 34: ...Restart Later an icon with label RESTART will be added on the status bar for restart the module later You can restart the module when your settings were completed Error message If an invalid setting i...

Страница 35: ...you can search log files by date and download or delete them by clicking on the corresponding icons in the log file list Specify a record created date for the search Enter Date in the format yyyy mm d...

Страница 36: ...date for search and then click SEARCH the search result will be displayed on the page as the chart below shows Download file Click the DOWNLOAD icon for a file to download it Get the file in the defau...

Страница 37: ...Copyright 2021 ICP DAS Co Ltd All Rights Reserved E mail service icpdas com 37 Delete file Click the DELETE icon for a file to delete it Click DELETE on pop up message to complete the process...

Страница 38: ...igure the parameters for Modbus communication connection between MDCL and Modbus RTU slave devices The configuration interface is provided on MODBUS page STEP 1 Select MODBUS from the navigation menu...

Страница 39: ...it or 2 Stop Bits Required Delay Between Polls ms Defines the Poll Delay between each scan for Modbus RTU communication Default value 1000 ms Available range 20 to 6000 ms Required Timeout ms Defines...

Страница 40: ...Restart Later an icon with label RESTART will be added on the status bar for restart the module later You can restart the module when your settings were completed Error message If an invalid setting...

Страница 41: ...tus of a channel by writing command to the register assigned for the channel in the MDCL module Modbus RTU polling definition in config csv is used to define Modbus RTU commands for reading data from...

Страница 42: ...P DAS Co Ltd All Rights Reserved E mail service icpdas com 42 Export the config csv STEP 1 Click EXPORT on Modbus page STEP 2 Obtain the file from the download directory configured in the web browser...

Страница 43: ...Click IMPORT MDCL will validate the imported file and present the result as success or error message with line and position information of invalid parameters as shown below A definition with invalid p...

Страница 44: ...inition The MDCL will assign local register for data defined in the definition but not poll data It can be applied where one or more devices are not used in different scenarios but reserving the mappe...

Страница 45: ...record data included in these polling definitions The available range is 1 to 12 ASCII characters Description 4 The comment or description of a polling definition It will be displayed on the web inter...

Страница 46: ...ions of each COM port will be listed below the configuration section You can click the tab for every COM port to verify the parameters in polling definitions imported in the MDCL module STEP 1 Click t...

Страница 47: ...he CL 213 devices This section will explain how to set the MDCL 705i to collect temperature humidity CO CO2 and PM2 5 concentration information and their high alarm status from CL 213 devices Function...

Страница 48: ...ber MDCL COM Modbus ID Function Code Start Address Quantity Lobby 101 1 1 1 4 0 5 1 1 3 452 1 1 1 1 304 5 Journal Room 102 2 1 2 4 0 5 1 2 3 452 1 1 2 1 304 5 Reading Room 103 3 1 3 4 0 5 1 3 3 452 1...

Страница 49: ...the config csv STEP 4 Click the tab for a COM port on MODBUS page and verify the parameters in polling definitions Polling definitions for reading data from lobby journal room and reading room on COM...

Страница 50: ...OM port You can get the connection status of each definition indicates that the connection is normal ID and register address of an RTU device Mapped register address in the MDCL module MAX MIN and cur...

Страница 51: ...L 213 devices have been arranged in consecutive addresses Using function code 0x04 to read the data addresses from 30000 to 30024 the remote Modbus master can read data from multiple CL 213 devices wi...

Страница 52: ...in MDCL with function code 0x06 will be written to the CL 213 in the lobby to change the temperature offset setting in it 4 Writing data to MDCL to force multiple coils in the CL 213 device with Modbu...

Страница 53: ...nation values in each room in the config csv file and imported it Room Model Number MDCL COM Modbus ID Function Code Start Address Quantity Lobby 101 CL 213 1 1 4 0 5 1 1 3 452 1 1 1 1 304 5 iSN 201 E...

Страница 54: ...ter Data Unit 0x04 Read AI 300005 Ambient light 1lux Data Location Data Address on MDCL Data Contents Lobby 300000 300004 CO CO2 PM2 5 Temperature Humidity Journal Room 300005 300009 CO CO2 PM2 5 Temp...

Страница 55: ...00004 of CL 213 3 Read AI from 300000 to 300004 of CL 213 4 Read AI from 300000 to 300004 of CL 213 5 Scan sequence COM1 Read AI 300000 300004 300005 300009 300010 300014 300015 300019 300020 300024 S...

Страница 56: ...register space Read AI from 300000 to 300004 of CL 213 4 Read AI from 300000 to 300004 of CL 213 5 Read AI from 300110 to 300199 Definition for reserved register space Scan sequence COM1 Scan sequence...

Страница 57: ...the MDCL will assign local registers for data defined in the definition but not poll data Refer to sec 6 2 Use the reserved registers in subsequent applications Edit new polling definitions for readin...

Страница 58: ...Excel or other analysis tools for further analysis The data logger configuration is divided into two parts logging time settings and logging channel settings Logging time settings are configured from...

Страница 59: ...te a new file to store new data at every interval on the hour starting at midnight For example if the Maximum Logging Period parameter is set to 6 hours the MDCL 705i will create a new file at 0 00 00...

Страница 60: ...efines the action when log space becomes full Stop logging when memory is full only this mode is supported now Required Automatic File Update Enable Disable the schedule for uploading log files to the...

Страница 61: ...el or other data analysis tools The data log files are saved in microSD card you can copy files from microSD card to local computer download them from the web interface or set to send log files to rem...

Страница 62: ...can help users to validate the imported file and present the result as success or error message with line and position information of invalid settings as shown below A channel will not be recorded if...

Страница 63: ...e parameters for log channels be sure to confirm the data type the GroupName set in the config csv file of a channel and the index address starting from 0 in its group The file name record csv cannot...

Страница 64: ...roupName entered here must be in line with the GroupName used in config csv for the specified channel If not the setting becomes invalid and the data on this channel will not be recorded Required Inde...

Страница 65: ...ata Available range up to 8 ASCII characters Optional Prefix 1 Defines the prefix of the channel name in the log file The name of a channel in log files consists of the text in the Prefix and Alias fi...

Страница 66: ...e reserved according to the number of registers used by the data type of the specified channel Setting Number Data Type Register Count Available Range 0 Boolean 1 0 1 1 16 bit Signed Integer 1 32 768...

Страница 67: ...formula is used to calculate scaling Actual value Modbus Reading Scale Offset The scale slope is the rise over the run that is how much the line rises vertically compared with how much it runs horizo...

Страница 68: ...hrenheit Input type K type thermocouple 0F Data Format Modbus Reading Actual Temperature Actual Temperature High 13600 2480 F 1360 C Low 2700 454 F 260 C Scale Offset Actual value Modbus Reading Scale...

Страница 69: ...M 7018 Input type 4 mA 20 mA 07 Data Format Modbus Reading Corresponding current Actual Pressure High 20000 20 mA 1000 bar Low 4000 4 mA 0 bar Scale Offset Actual value Modbus Reading Scale ReadingHig...

Страница 70: ...rs including numeric 0 9 and alphabetic case sensitive or a combination of these except the reserved characters and The name of a channel in log files consists of Prefix and Alias Prefix can be used t...

Страница 71: ...r the record csv file is imported the valid log channel settings will be listed below the log properties configuration section STEP 1 Scroll down the DATA LOGGER page to see the log channel list STEP...

Страница 72: ...12 00 00 18 00 00 The time for the first file to record data may be less than 6 hours This design can help users compare and analyze data from multiple modules more quickly MDCL will automatically re...

Страница 73: ...21 ICP DAS Co Ltd All Rights Reserved E mail service icpdas com 73 STEP 2 Select the date of the log files and click SEARCH STEP 3 Click the DOWNLOAD icon for a file to download it 2 Select a month Se...

Страница 74: ...header and log entries as shown below The first 4 lines are header information including the MDCL firmware version IP address MAC address module name and data type unit and name for each channel Afte...

Страница 75: ...Copyright 2021 ICP DAS Co Ltd All Rights Reserved E mail service icpdas com 75 Delete file STEP 1 Click the DELETE icon for a file to delete it STEP 2 Click DELETE on pop up message...

Страница 76: ...uce the steps for logging data collected in the environmental monitoring application in section 6 4 1 Configuring log channel record csv The following table shows polling definitions for reading tempe...

Страница 77: ...hannel of a CL 213 device including temperature humidity CO CO2 and PM2 5 concentration are shown below Address in Group Data Range Unit Data Type 0 CO 0 1000 1ppm 2 U16 1 CO2 0 9999 1ppm 2 U16 2 PM2...

Страница 78: ...Co Ltd All Rights Reserved E mail service icpdas com 78 2 Importing record csv STEP 1 Click CHOOSE FILE on DATA LOGGER page and then select your record csv file STEP 2 Click IMPORT See success message...

Страница 79: ...com 79 After the record csv is imported into the MDCL scroll down the DATA LOGGER page and check the channel settings Channel configuration for logging data from the lobby and journal room Channel con...

Страница 80: ...the DATA LOGGER page to the configuration section STEP 2 Select Enable from the Logging Active drop down menu and fill the required fields STEP 3 Click SAVE and restart the MDCL module After restartin...

Страница 81: ...rved E mail service icpdas com 81 4 Downloading log files STEP 1 Click FILE MANAGER on GENERAL SETTINGS page and click on the calendar icon STEP 2 Select the date of the log files and click SEARCH Cli...

Страница 82: ...All Rights Reserved E mail service icpdas com 82 STEP 3 Click the DOWNLOAD icon for a file to download it STEP 4 Get the file in the default download directory of web browser File name T_031700 creat...

Страница 83: ...w The first 4 lines are header information including the MDCL firmware version IP address MAC address module name and data type unit and name for each channel After that are logged entries with timest...

Страница 84: ...connect the slave device to the COM port number defined in the polling definition or fix the UseComPort parameter to the virtual COM port number that the slave device is connected to Solution Exchang...

Страница 85: ...us page are the same as the configuration of the slave device If not fix the difference between the settings on the web interface and the device configuration Solution Check and fix the ID number in t...

Страница 86: ...Reserved E mail service icpdas com 86 Solution Lengthen the Delay Between Polls or Timeout setting until it is suitable for communication with the slave device Situation 6 The value set for Delay Bet...

Страница 87: ...L 705i is 250 each definition can access up to 125 registers Each of the four tables DI DO AI DO can store up to 9600 registers of data Q2 What is the maximum number of registers can be accessed in on...

Страница 88: ...02 03 04 can be used in the polling definition section in config csv 01 Read Coil Status Read DO 02 Read Input Status Read DI 03 Read Holding Registers Read AO 04 Read Input Registers Read AI Use the...

Страница 90: ...I from 300000 to 300004 of CL 213 2 Read AO from 400452 of CL 213 2 Read DO from 000304 to 000308 of CL 213 2 Read AI from 300000 to 300004 of CL 213 3 Read AO from 400452 of CL 213 3 Read DO from 000...

Страница 91: ...to 300004 of CL 213 1 Read AO from 400452 of CL 213 1 Read DO from 000304 to 000308 of CL 213 1 Read AI from 300000 to 300004 of CL 213 2 Read AO from 400452 of CL 213 2 Read DO from 000304 to 000308...

Страница 92: ...ing table 0 indicates the connection status is good and 0xFFFF indicates that the connection is timeout The value of status 0 Good 0xFFFF Timeout 0x8XYY Exception response X Modbus Function Code YY Ex...

Страница 93: ...If you open a log file in Excel and see in DATATIME line simply increase the width of the column to make the data visible Excel formats times without seconds by default so we needs to change the forma...

Страница 94: ...Co Ltd All Rights Reserved E mail service icpdas com 94 Step 1 Mark the DATATIME line and select Format Cells option on the right click menu Step 2 Click Custom in the Category field and select yyyy m...

Страница 95: ...Copyright 2021 ICP DAS Co Ltd All Rights Reserved E mail service icpdas com 95 Step 3 Add ss at the end of yyyy m d hh mm and click OK Now the seconds are displayed in the timestamps...

Результаты поиска

Содержание MDCL-705i

Отзывы:

Бренды по названию

Популярные бренды

ICP DAS USA MDCL-705i, Руководство пользователя

Результаты поиска

Содержание MDCL-705i

Отзывы:

Бренды по названию

Популярные бренды