OPH-5000i Standard app

Apps whose base functions are "collection" and "matching" output data files. The data file layout depends on the number of items in the app settings, input settings, and data file settings.

Data file layout

The data file layout has the following format:

*() is a column added according to specific conditions.

Terminal ID

This is a terminal ID that can be set on OPH-5000i. Columns added according to options in data file settings.

Input data

This is the data you entered. The number of digits is the number of input digits specified in the app settings.
When the character type in the app settings is "All" or "Number", it is left justified and the missing digits are padded with spaces.
When the character type in the app settings is "Numeric", it is right justified and the missing digits are padded with 0.

Barcode type

This column is added when the input method in the app settings is "Numeric keypad/scan" or "scan only". The number of digits is 12.

Matching result

This column is added when the base function of app settings is "matching". The number of digits is 2.

Input date

Date at the time of input. The format is YYYY/MM/DD (YYYY: Year, MM: Month, DD: Day). The number of digits is 12.

Input time

The time at the time of input. The format is hh:mm:ss (hh: hours mm: minutes ss: seconds). The number of digits is 8.

Delimiter

The delimiter is a comma (,) or a tab. Specify in the file format of data file settings.

Example data file for "Collection"

Example data file for "matching"

Default data file layout

The default data file layout for the standard app is as follows.

• Incoming app file
  The first record is the title record, and the actual data is from the second record onwards.

  Product code	,	Barcode type	,	Quantity	,	Input date	,	Input time	CR	LF
  X(13)	,	X(12)	,	9(4)	,	YYYY/MM/DD	,	HH:MM:SS	CR	LF

• Shipping app file
  The first record is the title record, and the actual data is from the second record onwards.

  Customer code	,	Barcode type	,	Product code	,	Quantity	,	Input date	,	Input time	CR	LF
  X(8)	,	X(12)	,	X(13)	,	9(4)	,	YYYY/MM/DD	,	HH:MM:SS	CR	LF

• Inventory app file
  The first record will be the title record, and the actual data will be from the second record onwards.

  Shelf	,	Barcode type	,	Product code	,	Barcode type	,	Quantity	,	Input date	,	Input time	CR	LF
  X(9)	,	X(12)	,	X(13)	,	X(12)	,	9(4)	,	YYYY/MM/DD	,	HH:MM:SS	CR	LF

• Matching app file
  The first record will be the title record, and the actual data will be from the second record onward.
  Result: “OK”/“NG”

  Code 1

  ,

  Barcode type

  ,

  Code 2

  ,

  Barcode type

  ,

  Result

  ,

  Input date

  ,

  Input time

  CR

  LF

  X(250)

  ,

  X(12)

  ,

  X(250)

  ,

  X(12)

  ,

  X(2)

  ,

  YYYY/MM/DD

  ,

  HH:MM:SS

  CR

  LF

Data file settings

The following items can be changed in the data file settings.

File name:

Specify the file name to save the data.

File format:

Specify the file format (CSV/TSV) to save the data.

Title code:

Specify whether to output a title line indicating the meaning of the column in the first line of the file.

Terminal ID:

Add the terminal ID to the first column of the data file.
In addition, when sending an FTP file, a device ID is added to the sent file name.

Add date and time to FTP sending file name:

Adds the date and time to the destination file name. This setting applies only to FTP file transmission.

Delete files after FTP sending:

Delete files sent via FTP. This setting applies only to FTP file transmission.

Do not output barcode type:

Specify the output of the barcode type of the data file.

Data file layout settings

Set the data file layout order.

Various customization

---