Omron Forums Support Posted March 14, 2022 Posted March 14, 2022 This procedure intends to provide a very simple way to read output values from Microscan Smart Cameras into an Excel spreadsheet (CSV format).If the output value from the camera contains a comma (as part of a string, for example) it will be treated as a separator and not as part of the read value. In this case, please, use the “Reading Values in Excel (TXT File)” . 1. Reading Text Files in Excel Usually, there are two ways to import data from text files into Excel: delimited text file (.txt) and comma separated values text files (.csv).This procedure presents the use of comma separated values text files (.csv), with the comma character (,) used as the separator of each field of text.Attention: If the output value from the camera contains a comma (as part of a string, for example) it will be treated as a separator and not as part of the read value. In this case, please, use the “Reading Values in Excel (TXT File)” document. 2. PuTTY Software This simple solution use PuTTY (http://www.putty.org/) to read output values from Microscan Smart Cameras: PuTTY is an SSH and telnet client, developed originally by Simon Tatham for the Windows platform. PuTTY is open source software that is available with source code and is developed and supported by a group of volunteers.You can download PuTTY here. 3. Simple Example A simple example is used to demonstrate this functionality: reading output values from two Count Tools (Number of Parts) in AutoVISION and FrontRunner: Microscan - Excel_CSV_AV.avpMicroscan - Excel_CSV_FR.avp Both AutoVISION (Microscan - Excel_CSV_AV.avz) and FrontRunner (Microscan - Excel_CSV_FR.avz) files are available. 4. Defining Output Format TCP/Serial Output (AutoVISION) and Formatted Output (FrontRunner) accept the following special characters: \a bell\b backspace\f form feed\n new line\r carriage return\t horizontal tab\v vertical tab\’ single quote\” double quote\? question mark\ooo octal ASCII value (\145 = 'e')\xhh hexadecimal ASCII value (\x4C = 'L')4.1 Defining Output Format – AutoVISION The comma character ( , ) must be inserted between each value to be transmitted (as many as needed). At the end of the transmission, a Carriage Return (\r) and a New Line (\n) must be also inserted (\r\n). 4.2 Defining Output Format – FrontRunner With much more flexibility, the Output Format can be defined in the same way as in AutoVISION (just one output string for all information) or in separate output string for each information.Anyway, the comma character ( , ) must be inserted between each value to be transmitted (as many as needed) , and a Carriage Return (\r) and a New Line (\n) must be also inserted (\r\n) at the end of the transmission.Defining Output Format in FrontRunner (just one line for all information) – Step Tree Editor ViewFormat: %d\t%d\r\nAdditional information is available into “Visionscape Tools Reference” (Chapter 1, “Formatted Output”). 5. Connecting PuTTY Into Session Category, enter the IP Address of the Smart Camera (for Emulator mode, enter ‘127.0.0.1’), the TCP Port defined in the JOB to send out the information (the above examples use the port ‘49211’) and select Telnet as the Connection Type:Moving to Logging (into Session Category), select All session output option (Session logging) and define the Log file name as CSV extension.Click on Browse… to define the path for this file:Click on to connect to the device / emulator.PuTTY window is updated as soon as the data is sent out by the device / emulator (the CSV file is also updated):6. Opening CSV file in Excel When finished the acquisition (or even during the operation), double click on the CSV file:All data will be into the spreadsheet (the CSV file can now be saved as an Excel file):The first row contains PuTTY log info Operating System Any Quote
Recommended Posts
Top Posters In This Topic
1
Popular Days
Mar 14
1
Top Posters In This Topic
Omron Forums Support 1 post
Popular Days
Mar 14 2022
1 post