180 likes | 190 Views
How can I Import IO Variables from Excel sheet to IO Module. Problem. To Drag and Drop IO_PLC variables from the Various Control Modules to Specific Channel of a IO Module. Pre-Requisite. To List of IO Variables need to be present in Excel Sheet in a Specific format.
E N D
Problem • To Drag and Drop IO_PLC variables from the Various Control Modules to Specific Channel of a IO Module.
Pre-Requisite • To List of IO Variables need to be present in Excel Sheet in a Specific format. • Also the corresponding variables should be already present in UAG Project as a Scod Variable of Connection Type IO_PLC or Free Variable of connection type IO_PLC. • Data type of the variable should match with the Data type of the Module. • UAG_ExportMacro.xls is available.
Solution • Use of Export Import Tool obtain a Format for IO Variable in Excel, Modify the Excel file with the required IO List, Save the file to Text format using macro and then Re-import the file in UAG.
Steps to be followed • In UAG add the required IO Modules( 1 for each type like Analog Input/Output, Digital Input/Output etc). • Create the required Control Modules and Free Variables of type IO_PLC. • Export the IO Modules (each type of IO Module) from UAG in the Text format as displayed
Steps to be followed…continued • Filter all the IO_PLC variables in the project.
Steps to be followed…continued • Open the Attached UAG_ExportMacro.xls Excel file. • From the menu Select Open file, in file type select ALL FILES and select the IO Module Exported text file.
Steps to be followed…continued • Select Delimited. Next
Steps to be followed…continued • Select Tab and Semicolon Finish.
Steps to be followed…continued • The exported text files opens in Excel as shown below. • Furnish the details in the format displayed below
Steps to be followed…continued • Once the data required are furnished Run the Macro to save this excel file to UAG compatible Text file.
Steps to be followed…continued • Select the Macro UAG_ExportMacro.xls!CMModify and Click RUN.
Steps to be followed…continued • Click Export button a New window to specify the New Text file Name (without File format ie txt and location). • The file gets saved at the same location of the UAG_ExportMacro.xls
Steps to be followed…continued • Open UAG project in Exclusive mode. Select File Import and browse the modified Text file that need to be imported. Click Open to start Import.
Steps to be followed…continued • The Import action should result in assigning of the IO_Variable to the IO Channel.