TXT Format, CSV Format | Omron CJ1W-ETN21 manual

I/O Memory Data Formats

Section 3-6

TXT Format

When hexadecimal I/O memory data (1234, 5678, 9ABC, etc.) is being copied to an attached file in TXT format, the data is converted to ASCII in one-word fields or two-word fields. The fields (one-word or two-word) are delimited by tabs ([HT]: 09) and a return and line feed ([CR][LF]: 0D0A) are inserted after the specified number of fields.

Example: Tab-delimited words with a return every 10 fields

I/O memory contents

	+0	+1	+2	+3	+4	+5	+6	+7	+8	+9
+0	1234	5678	9ABC	DEF0	1234	5678	9ABC	DEF0	1234	5678
+10	9ABC	DEF0	1234	5678	9ABC	DEF0	1234	5678	9ABC	DEF0

TXT file contents

31	32	33	34	09	35	36	37	38	09	39	41	42	43	09
1	2	3	4	[HT]	5	6	7	8	[HT]	9	A	B	C	[HT]
	35	36	37	38	0D	0A	39	41	42	43	09
	5	6	7	8	[CR] [LF]		9	A	B	C	[HT]

Contents of TXT file when displayed

1234@5678@9ABC@DEF0@1234@5678@9ABC@DEF0@1234@5678@ 9ABC@DEF0@1234@5678@9ABC@DEF0@1234@5678@9ABC@DEF0

The @ character represents a hard tab and is displayed as a tab in text displays.

Note The TXT file format is compatible with the CPU Unit's READ DATA FILE and WRITE DATA FILE instructions (FREAD and FWRIT) set to tab-delimited data.

CSV Format	When hexadecimal I/O memory data (1234, 5678, 9ABC, etc.) is being copied
	to an attached file in CSV format, the data is converted to ASCII in one-word
	fields or two-word fields. The fields (one-word or two-word) are delimited by
	commas (",": 2C) and a return and line feed ([CR][LF]: 0D0A) are inserted
	after the specified number of fields.
	Example: Comma-delimited words with a return every 10 fields
	I/O memory contents
			+0				+1			+2			+3			+4		+5				+6		+7					+8		+9
	+0		1234				5678			9ABC			DEF0		1234			5678			9ABC				DEF0			1234			5678
	+10		9ABC				DEF0			1234			5678		9ABC				DEF0		1234			5678				9ABC			DEF0
	CSV file contents

		31	32		33			34		2C	35		36		37		38		2C		39		41		42		43			2C
	1		2		3		4			,	5		6		7	8		,			9		A		B			C	,
			35		36			37		38	0D		0A		39		41		42		43		2C
			5		6		7			8	[CR] [LF]				9		A		B		C	,

Contents of CSV file when displayed

1234,5678,9ABC,DEF0,1234,5678,9ABC,DEF0,1234,5678,

9ABC,DEF0,1234,5678,9ABC,DEF0,1234,5678,9ABC,DEF0

Note The CSV file format is compatible with the CPU Unit's READ DATA FILE and WRITE DATA FILE instructions (FREAD and FWRIT) set to comma-delimited data.

61

Image 85

Omron CJ1W-ETN21 operation manual TXT Format, CSV Format

Contents

Ethernet Units Construction of Applications Revised November  Omron Omron Product ReferencesPage Table of Contents FTP Server Index 207 Revision History 215 Table of Contents Information on how to manage and use IP addresses Information on setting communications using CX-ProgrammerCommands Section Contents Relevant Manuals Manual Model Name Contents Number Xiii Xiv Read and Understand this Manual Application Considerations Disclaimers Xviii Notation of Unit Versions on Products Unit VersionsConfirming Unit Versions with Support Software Lowing table Unit Version Notation Precautions Safety Precautions General PrecautionsIntended Audience Safety Precautions Application Precautions Operating Environment Precautions Application Precautions Applicable Directives Conformance to EC DirectivesConcepts EMC Directives Section Service Main functions Counterpart device Reference Ethernet Unit Communications ServicesFunctions Listed by Purpose Acquired for the Ethernet Unit Unit setting tag Communications Protocol used Situation when used ReferenceTable of Protocols Section Contents Default Common Protocol SettingsSmtp 2 POP 3 DNS Section Section Mail Send Function Introduction Mail Send Function OverviewAdvantages Description Comparison with the Earlier Mail Send Function Mail Send Function DetailsMail Send Functions Compatibility with Earlier Models Contents of E-mail Body Trigger condition Text entered as subject Following header information is included Ethernet Unit Information Words value has changed Channel data has changed from XX toEthernet Unit information is always included in the e-mail Optional Information Extension Content Error Log Information Status InformationAttached File Details Memory Data 6,000 Words Max File Data 1 MB Max Summary of E-mail Body Information and Attached FilesData sent Body/Attached file Mail body Function Specifications Mail Send Function SpecificationsSpecifications Procedure Using the Mail Send FunctionDetails of the Available Mail Triggers Classification Trigger type Transferring the settings data Settings Required for the Mail Send FunctionSetting Setting requirement Reference Unit Setup Using the Mail Send Function Mail Address Set up to 2 destination mail addressesSend Mail Mail Address Specification Required Send Mail Condition SettingsData Sent by Mail When Required Data Sent in E-mail Body Data Sent in an Attached File Attached File Name Send Mail Trigger Type Setting Required Send Mail Status Mail Send Function StatusSend Mail Status Mail Send Switch Bit 03 of n Mail Send Switch, Accessing Memory/Sending Mail FlagBit numbers Status Memory Data Formats Accessing Memory/Sending Mail Flag Bit 01 of n+17IOM Format TXT Format CSV Format Attached File Transfer Times Identifying and Correcting Mail Send Function Errors Mail Send Function ErrorsAccess Times for CS1 and CJ1 CPU Units Access Times for CS1-H and CJ1-H CPU Units Error Log Error Codes for the Mail Send Function Troubleshooting Mail Send Errors with LED IndicatorsError Meaning Detailed error code Correction Probable cause Correction Initial Settings Example Make the Unit Setup Settings from the CX-ProgrammerInitial Server Settings Example Application Send Condition Setting Destination Mail Address Setup Automatic Transmission when Send Condition is Satisfied Transfer the CPU Bus Unit Setup SettingsExample Send e-mail when W300 bit 00 goes from OFF to on Send when there is a Change in the CPU Units Status Receive Mail Function Mail Receive Function Overview Configuration of the MailAdvantages Description Command Parameters Table of Remote Mail CommandsCommand Execution Results Attached File Data Specification Mail Receive Function SpecificationsReceived E-mail Response E-mail Using the Mail Receive Function Tion Settings Required for the Mail Receive Function Receive Mail Tab Posting Mail Address Protection Setting Receive Command Setting Receive Attached File Setting Command Format Remote Mail Command DetailsFormat Response Format FileWrite File Write Command FormatFunction Mounted in the CPU Unit FileRead File Read Card mounted in the CPU Unit FileDelete File Delete EM file memory or a Memory Card mounted in the CPU Unit FileList File List ReadResponse Format Details Command Format Details UMBackup User Memory BackupMemory or a Memory Card mounted in the CPU Unit Or a Memory Card mounted in the CPU Unit PARAMBackup Parameter Area Backup Units I/O memory. The data is written in word units IOMWrite I/O Memory Write Subject Body Units IOMRead I/O Memory Read ReIOMRead Changes the CPU Units operating mode ChangeMode Operating Mode Change Bus Unit or Special I/O Unit ErrorLogRead Error Log Read ErrorLogClear Error Log Clear MailLogRead Mail Log Read Since power was turned on or the mail log was cleared Net Unit MailLogClear Mail Log Clear Test Mail Test Response List FinsSend Fins Command SendResponse Response Status Description Code Accessing Memory/ Receiving Mail Flag Bit 02 of n+17 Accessing Memory/Receiving Mail FlagMail Receive Function Status IOM Format CSV Format TXT Format Access Times for CS1-H CJ1-H CPU Units Access Times for CS1 CJ1 CPU Units Identifying and Correcting Mail Receive Function Errors Mail Receive Function ErrorsTroubleshooting Mail Receive Errors with LED Indicators Hex 1st byte 2nd byte Error code Meaning Detailed error code Correction Initial Settings for the Mail Receive Function DNS Server IP Address Setting DNS Tab, When RequiredItem name Example Reading Data from a CPU Unit Data Area Send Remote Mail CommandsBacking Up the CPU Units User Program Memory Card FTP Server Overview Specifications FTP Server Function Details Connecting to the FTP ServerFile Types FTP File Transfer Mode Using the FTP Server Function Setup Tab List of Settings Required for the FTP Server FunctionCX-Programmer Settings Setting conditions Tab Setting Details Default value Confidential FTP Server Application Example Table of Commands Using FTP CommandsUsing the Commands Open Dir UserRename Rmdir MkdirPwd Cdup Get TypeMget Put Mdelete DeleteClose Bye Error Messages Error Messages and FTP StatusMessage Meaning FTP indicator Meaning FTP IndicatorChecking FTP Status FTP Status Flag File Memory Using File MemoryFile Names Directories File Names Handled by CPU Unit File type File name Extension Contents DescriptionUnit 4 I/O Memory Data Format Initializing File MemoryMemory Initialization method Data format Use of CRs and CR position Section 9ABC CS1 CPU Units/CJ1 CPU Units FTP File Transfer TimeCS1-H CPU Units/CJ1-H CPU Units File system Memory Card EM File Memory Unix Application Example Enter the login name Change data type to binary Change to the Memcard directoryTransfer the file RESULT.IOM to the workstation Write the file PLAN.IOM to the Memory Card Section Automatic Clock Adjustment Function CPU Unit Conditions Overview Using the Automatic Clock Adjustment Function Settings Setting conditions Reference Settings Required for Automatic Clock Adjustment Function Auto Adjust Time Automatic Clock Adjustment Error Processing Automatic Clock Adjustment SwitchAutomatic Clock Adjustment Sntp Errors Automatic Clock Adjustment Switch Bit 04 of n Automatic Clock Adjustment Error Processing CPU Unit error Socket Services Page Overview of Socket Communications from Ethernet Units Using Sockets with the Ethernet UnitWhat are Sockets? Socket Port Numbers Differences between TCP and UDP Protocol OverviewOpening TCP Sockets TCP Communications Passive Open and Active Open TCP Communications Procedure Fragmentation of Send Data Socket Service Functions Protocol Socket Service Request CMND490 Using Socket Services with Socket Service Request Switches Specific Socket Service Functions Using Socket Services with CMND490Command code Name Protocol Socket service request Differences with Previous Models Socket Service Function GuideManipulating Dedicated Control Bits Executing CMND490 Settings Required for Socket Service Function Using Socket Service FunctionsCX-Programmer Setting Setting requirements Unit Setup Tab Manipulating Dedicated Control Bits Details Default value Setup 109 CIO Area Allocations Socket Service StatusUDP/TCP Socket Status Ethernet Unit to CPU Unit DM Area Allocations Bit Switch Status Manipulated Unit operation Procedure Application ProcedureTCP Connection Status Ethernet Unit to CPU Unit Number Status Meaning Precautions Socket Services and Socket Status Program Flow Error Evaluation Socket Service Parameters Use of the parameters by the socket service Parameter SettingsUDP Socket Services TCP Socket Services Socket Option ParametersUDP/TCP Socket No Local UDP/TCP Port No Remote UDP/TCP Port No Following specifications can be usedTime Out Time Number of Bytes to Send/Receive Following diagram Socket Service Request Switches UDP Socket Open Request Response CodesUDP Socket Receive Request Response Meaning Code UDP Socket Close Request UDP Socket Send Request TCP Socket Active Open Request TCP Socket Passive Open Request Drinuse TCP Socket Receive Request TCP Socket Send Request TCP Socket Close Request Timing ChartsClosing during Other Processes Force-close Switch Close Request Switch 8 TCP/IP Communications Programming Example System ConfigurationData Flow Basic Operations DM Area Program Memory MapCIO Area TCP Passive Open Programming Example 130 9 UDP/IP Communications Programming Example Programming example uses the following system configuration CIO 000000 is turned on to request opening a UDP socket from Tion on errors 133 134 135 Using Socket Service Using Socket Services with CMND490 137 Command Code Basic Fins Command FormatSocket Number Results Storage Area Communications Timing Chart Response Codes in the Command ResponseSocket Service Timing Chart Response Codes in the Results Storage Areas 140 Close Request during Receive Request System Configuration Basic Operations Data Flow Are structured Program Memory Maps 144 145 146 147 148 149 150 151 152 153 154 UDP and TCP Socket Services Precautions in Using Socket ServicesUDP Socket Service TCP Socket Service Precautions in Using Socket Service Request Switches TCP Socket Services Using CMND490 CS/CJ CPU Units Maximum Transmission Delays Ignoring other Network DelaysCS-H/CJ-H CPU Units Calculation Using Fins Communications to Create Host Applications Communications On an Ethernet Network Overview of Fins Communications Fins Communications Service Specifications for Ethernet Using the FINS/UDP and FINS/TCP Methods Fins Frames Fins Command Frame FormatFins Response Frame Format Fins Header Information FINS/UDP Method FINS/UDP Features FINS/UDP FINS/UDP Frame Format UDP Port Numbers for Procedure for Using Designating Remote Addresses Sending Commands from a Host ComputerCommunications Parameters Used by Host Computer Mand, the command will be resent By sending a Fins command Memory Area READ, command codeFINS/UDP Sample Program Operation Overview 15 * FINS/UDP Communications Sample Program Sample Program 169 170 FINS/TCP Method FINS/TCP Features TCP Port Number for FINS/TCP Frame FormatFINS/TCP Connection Numbers FINS/TCP Connection Status Word n+23 CommunicationsAge them in an internal table Automatic Allocation Fins Node Addresses Automatic Allocation Procedure 175 FINS/TCP Tab Setup Tab Fins Node Address Data Send Client to Server Command FINS/TCP Mode SpecificationsFins Node Address Data Send Server to Client Command FINS/TCP Headers Following table shows the list of error codes Fins Frame Send CommandError code Details Hexadecimal Command Fins Frame Send Error Notification Command Normal Operation Connection Sequence ACK FIN Error Connection Sequence 182 183 Host computer Remote node From onwards, the connection is established again FINS/TCP Sample Program 186 187 188 189 190 191 Write Command Delay Time Maximum Transmission Delays Writing/Reading to CPU UnitTransmission Delay Receive Processing Command CPU Bus Unit Service Cycle Transmission Processing Read Command Delay Time704 ms Response 194 Parameter Value Description Ethernet Network Parameters Appendix a Appendix B Buffer Configuration Network Memory Status Meaning TCP Status Transitions Appendix C Space Ascii Characters Appendix D Settings after Replacing an Ethernet Unit MaintenanceSettings After Replacing a CPU Replacing an Ethernet Unit Appendix E Items InspectionsTools Required for Inspection Appendix F Numerics Index 209 210 211 212 213 214 Revision History Revision code Date Revised content Revision History Regional Headquarters Omron Corporation Control Devices Division H.Q Authorized Distributor