OPC to EXCEL in automation


1

2. It is necessary to select the necessary variables from the Data Editor list and export the selected fragment to a file with the XVM extension (for further use by the OPC server);

3. Run OFS Configurator (Schneider Electric). Load the XVM and set it as shown in the figure. I did not go into the parameters. To create communication this is enough;

2


4. In order to receive data in MS Excel we need OPC Client to download from the Internet Cogent DataHub - //www.opcdatahub.com/Download.html

5. After installing Cogent DataHub, launch the shortcut on the desktop. The service appears in the tray;

3


6. Right-click the properties of the Cogent DataHub and set these options;

4


7. Configure OPC DA;

5


8. After clicking on OK, the OFS server will start automatically;


9. Using the Drag & Drop function, drag the selected data from the View Data list to the Excel (previously opened window). The variables on the server came from a list previously saved in the XVM file.

6


Data is updated fairly quickly with a cycle of no more than 500ms. With the data writing to the controller did not understand, but such a task and did not set. The task was to download the data from the controller's memory to the Excel table for later analysis. OFS itself, despite the absence of a license, has been working for a long time, I have never observed a connection failure, while I was experiencing it. Cogent DataHub operates in real time for an hour, after which it asks for a reboot.


7

#PLC,#SE, #ModbusTCP,#server,#OFS ,#OPCDA,#EXCEL

Russian version
Array
(
    [ID] => 45
    [IBLOCK_ID] => 1
    [NAME] => OPC to EXCEL in automation
    [IBLOCK_SECTION_ID] => 
    [IBLOCK] => Array
        (
            [ID] => 1
            [~ID] => 1
            [TIMESTAMP_X] => 14.10.2021 23:54:30
            [~TIMESTAMP_X] => 14.10.2021 23:54:30
            [IBLOCK_TYPE_ID] => EN
            [~IBLOCK_TYPE_ID] => EN
            [LID] => s2
            [~LID] => s2
            [CODE] => articles
            [~CODE] => articles
            [API_CODE] => 
            [~API_CODE] => 
            [NAME] => Articles
            [~NAME] => Articles
            [ACTIVE] => Y
            [~ACTIVE] => Y
            [SORT] => 10
            [~SORT] => 10
            [LIST_PAGE_URL] => /articles/
            [~LIST_PAGE_URL] => /articles/
            [DETAIL_PAGE_URL] => /articles/#ELEMENT_CODE#.html
            [~DETAIL_PAGE_URL] => /articles/#ELEMENT_CODE#.html
            [SECTION_PAGE_URL] => 
            [~SECTION_PAGE_URL] => 
            [CANONICAL_PAGE_URL] => https://lapshinvr.com/articles/articles.html
            [~CANONICAL_PAGE_URL] => https://lapshinvr.com/articles/articles.html
            [PICTURE] => 
            [~PICTURE] => 
            [DESCRIPTION] => 
            [~DESCRIPTION] => 
            [DESCRIPTION_TYPE] => html
            [~DESCRIPTION_TYPE] => html
            [RSS_TTL] => 24
            [~RSS_TTL] => 24
            [RSS_ACTIVE] => Y
            [~RSS_ACTIVE] => Y
            [RSS_FILE_ACTIVE] => N
            [~RSS_FILE_ACTIVE] => N
            [RSS_FILE_LIMIT] => 
            [~RSS_FILE_LIMIT] => 
            [RSS_FILE_DAYS] => 
            [~RSS_FILE_DAYS] => 
            [RSS_YANDEX_ACTIVE] => N
            [~RSS_YANDEX_ACTIVE] => N
            [XML_ID] => 
            [~XML_ID] => 
            [TMP_ID] => 
            [~TMP_ID] => 
            [INDEX_ELEMENT] => Y
            [~INDEX_ELEMENT] => Y
            [INDEX_SECTION] => N
            [~INDEX_SECTION] => N
            [WORKFLOW] => N
            [~WORKFLOW] => N
            [BIZPROC] => N
            [~BIZPROC] => N
            [SECTION_CHOOSER] => L
            [~SECTION_CHOOSER] => L
            [LIST_MODE] => 
            [~LIST_MODE] => 
            [RIGHTS_MODE] => S
            [~RIGHTS_MODE] => S
            [SECTION_PROPERTY] => N
            [~SECTION_PROPERTY] => N
            [PROPERTY_INDEX] => N
            [~PROPERTY_INDEX] => N
            [VERSION] => 1
            [~VERSION] => 1
            [LAST_CONV_ELEMENT] => 0
            [~LAST_CONV_ELEMENT] => 0
            [SOCNET_GROUP_ID] => 
            [~SOCNET_GROUP_ID] => 
            [EDIT_FILE_BEFORE] => 
            [~EDIT_FILE_BEFORE] => 
            [EDIT_FILE_AFTER] => 
            [~EDIT_FILE_AFTER] => 
            [SECTIONS_NAME] => 
            [~SECTIONS_NAME] => 
            [SECTION_NAME] => 
            [~SECTION_NAME] => 
            [ELEMENTS_NAME] => Элементы
            [~ELEMENTS_NAME] => Элементы
            [ELEMENT_NAME] => Элемент
            [~ELEMENT_NAME] => Элемент
            [REST_ON] => N
            [~REST_ON] => N
            [EXTERNAL_ID] => 
            [~EXTERNAL_ID] => 
            [LANG_DIR] => /
            [~LANG_DIR] => /
            [SERVER_NAME] => lapshinvr.com
            [~SERVER_NAME] => lapshinvr.com
        )

    [LIST_PAGE_URL] => /articles/
    [~LIST_PAGE_URL] => /articles/
    [SECTION_URL] => 
    [CANONICAL_PAGE_URL] => https://lapshinvr.com/articles/opc-to-excel.html
    [SECTION] => Array
        (
            [PATH] => Array
                (
                )

        )

    [IPROPERTY_VALUES] => Array
        (
            [ELEMENT_PREVIEW_PICTURE_FILE_NAME] => opc to excel in automation
            [ELEMENT_META_TITLE] => OPC to EXCEL
            [ELEMENT_META_KEYWORDS] => OPC to EXCEL, OFS
            [ELEMENT_META_DESCRIPTION] => It is necessary to select the necessary variables from the Data Editor list and export the selected fragment to a file with the XVM extension (for further use by the OPC server)
            [ELEMENT_PAGE_TITLE] => OPC to EXCEL in automation
            [SECTION_META_TITLE] => Automation articles 
            [SECTION_META_KEYWORDS] => Automation, Articles 
            [SECTION_META_DESCRIPTION] => I met something worthy of attention during the work. It is difficult to assess the necessity of posting this or that article, I tried to clean up the obvious garbage
            [SECTION_PAGE_TITLE] => Here I published articles that may be useful to someone in the production of work
        )

    [TIMESTAMP_X] => 16.11.2021 06:31:46
    [META_TAGS] => Array
        (
            [TITLE] => OPC to EXCEL in automation
            [BROWSER_TITLE] => OPC to EXCEL
            [KEYWORDS] => OPC to EXCEL, OFS
            [DESCRIPTION] => It is necessary to select the necessary variables from the Data Editor list and export the selected fragment to a file with the XVM extension (for further use by the OPC server)
        )

    [PREVIEW_TEXT] => Read variable values from any SE controller via ModbusTCP through the OFS OPC DA server.
    [PREVIEW_PICTURE] => Array
        (
            [ID] => 371
            [TIMESTAMP_X] => Bitrix\Main\Type\DateTime Object
                (
                    [value:protected] => DateTime Object
                        (
                            [date] => 2021-11-16 06:31:46.000000
                            [timezone_type] => 3
                            [timezone] => Europe/Moscow
                        )

                )

            [MODULE_ID] => iblock
            [HEIGHT] => 535
            [WIDTH] => 635
            [FILE_SIZE] => 53112
            [CONTENT_TYPE] => image/png
            [SUBDIR] => iblock/7f4
            [FILE_NAME] => opc_to_excel.png
            [ORIGINAL_NAME] => opc-to-excel.png
            [DESCRIPTION] => OPC to EXCEL
            [HANDLER_ID] => 
            [EXTERNAL_ID] => 2d00d57d59c907b642b86d86de714944
            [~src] => 
            [SRC] => /upload/iblock/7f4/opc_to_excel.png
            [UNSAFE_SRC] => /upload/iblock/7f4/opc_to_excel.png
            [SAFE_SRC] => /upload/iblock/7f4/opc_to_excel.png
            [ALT] => OPC to EXCEL in automation
            [TITLE] => OPC to EXCEL in automation
        )

    [DETAIL_PAGE_URL] => /articles/opc-to-excel.html
)
Ваш комментарий добавлен

Возврат к списку