Format for CSV Files
- The character encoding and line break codes for CSV files are indicated below.
- Character encoding: UTF-8 (without OBM), UTF-8 (with BOM), or Shift-JIS
- Line break code: CL, LF, or CRLF
- When including line breaks or commas, enclose the value with double quotation marks.
- To include a double quotation mark in a string enclosed with double quotation marks, add an extra double quotation mark before the double quotation mark to include.
For [Single (with extension)]
| Item | Description |
|---|---|
| File name | Specify this to upload one file with one CSV file. The CSV parameters are registered for the job that is uploaded. If a file to upload is in the same monitored folder as a CSV file, the file is deemed to be the target file for uploading. If the name of the CSV parameter file is "a.tif.csv", then the target file for uploading is "a.tif". If the name of the CSV parameter file is "a.csv", then the target file for uploading is "a". |
| Format | Specify the data as a two row table featuring a header row with an arbitrary number of columns separated by commas and the parameter values. {parameter name 1},{parameter name 2},{parameter name 2},... {value 1},{value 2},{value 3},... |
For [Single (without extension)]
| Item | Description |
|---|---|
| File Name | Specify this to upload one file with one CSV file. The CSV parameters are registered for the job that is uploaded. If a file to upload is in the same monitored folder as a CSV file, the file is deemed to be the target file for uploading. If the name of the CSV parameter file is "a.csv", then a file named "a" with any file extension is the target file for uploading (such as "a.jpg" or "a.tif"). Files without a file extension are not uploaded. If there are multiple target files, then the file with the oldest update date/time is the target file for uploading. Other files are moved to the error folder. |
| Format | Specify the data as a two row table featuring a header row with an arbitrary number of columns separated by commas and the parameter values. {parameter name 1},{parameter name 2},{parameter name 2},... {value 1},{value 2},{value 3},... |
For [Multiple]
| Item | Description |
|---|---|
| File Name | Specify this to upload multiple files with one CSV file. The CSV parameters are registered for the job that is uploaded. The following file name is used for the CSV parameter file. captureParams_{arbitrary string}.csv |
| Format | Specify the data as a multiple row table featuring a header row with an arbitrary number of columns separated by commas and parameter values for each file to upload. fileName,{parameter name 1},{parameter name 2},{parameter name 3},... {file name A},{value A1},{value A2},{value A3},... {file name B},{value B1},{value B2},{value B3},... Specify the name of the file to upload in the fileName column. The value specified in the same row is used as the registration process parameter corresponding to the specified file. Specify a name with a file path as the value of the fileName column. Absolute file paths are supported. If only the file name is specified, the file is deemed to be a file in the monitored folder. Paths on a local PC or paths to a Windows shared folder on a network (paths in the UNC format starting with "\") are supported. However, NAS is not supported. Either backslashes (\) or forward slashes (/) can be used for the path separator character. When files outside the monitored folder are moved to the Success folder or Error folder, they are placed at the root of the folder. The fileName column is not retained as a parameter. |