4.12.4 Get CSV data
Function
This plugin acquires data from CSV files and sets it in output properties. It supports text files with an extension of csv.
Set the specified columns (up to 5) of data, separated by commas, in the output properties.
State the column name in the first line of the CSV file. State the data starting in the 2nd line.
(Example 1)
Host name
hostVM001
hostVM002
(Example 2)
Host name, comment
hostVM001,#Comment1
hostVM002,#Comment2
The fields read are checked for the following conditions. If any of these conditions are met, the plugin fails.
(a) Are there any blank (null) fields or lines?
(b) Do any fields exceed 256 characters in character string length?
(c) Do any fields contain the following special characters?
, < > | ; & * ? ` % or a double quote (") not at an end of a field, or a backslash (\) at the end of a field
(d) Does any field contain a control character (0x00 through 0x1f)?
The output information is output for each specified column. An error results if, in any of the strings,
(Total value of field character strings) + Data line count
exceeds 1,017 characters.
Use situation
Data can be acquired from managed CSV files and then used as the input values of the server.
Prerequisites
For the latest support information about [Required product in the System]/[Required products on the execution target system]/[Prerequisite product OS running on the execution target server], see the release notes.
[Required product in the System]
Job Management Partner 1/Automatic Operation 10-50 or later
[Required products on the execution target system]
None.
[Prerequisite product OS running on the execution target server]
(1) Windows Server 2003,Standard Edition/Enterprise Edition (x86/x64) SP1 or later,Windows Server 2003 R2, Standard Edition/Enterprise Edition (x86/x64)
(2) Windows Server 2008 Standard/Enterprise (x86/x64),Windows Server 2008 R2 Standard/Enterprise/Datacenter
(3) Windows Server 2012 Standard/Datacenter, Windows Server 2012 R2 Standard/Datacenter
[Usage conditions for required products on the execution target server]
None.
Cautions
Due to ODBC driver restrictions, the following characters cannot be used in CSV file names: [ ] !
Execution privilege
Windows: Administrator permission
Version
01.12.00
Category
OperatingSystem/Windows/Basic
Plug-in name displayed in the task log
osReadSpreadSheet
Return code
0: Normal
12: Error (user error) Invalid property
14: Error (user error) File access disabled
41: Error (error detected in plugin) Missing property (error detected in plugin script)
42: Error (error detected in plugin) Internal error (error detected in the plugin script)
Property list
The following table lists the properties:
|
Property key |
Property name |
Description |
Default value |
I/O type |
Required |
|---|---|---|---|---|---|
|
plugin.destinationHost |
Host name of the execution target server |
Specify the host name or IP address of the server on which this plugin will be executed. IPv6 addresses are not supported. |
-- |
Input |
R |
|
common.fileName |
File name |
Specify the file name. |
-- |
Input |
R |
|
odbc.Column1 |
Column number 1 |
Specifies the column number of the data to acquire. |
-- |
Input |
R |
|
odbc.Column2 |
Column number 2 |
Specifies the column number of the data to acquire. |
-- |
Input |
O |
|
odbc.Column3 |
Column number 3 |
Specifies the column number of the data to acquire. |
-- |
Input |
O |
|
odbc.Column4 |
Column number 4 |
Specifies the column number of the data to acquire. |
-- |
Input |
O |
|
odbc.Column5 |
Column number 5 |
Specifies the column number of the data to acquire. |
-- |
Input |
O |
|
odbc.OutputValue1 |
Data 1 |
Specifies the acquired data. |
-- |
Output |
R |
|
odbc.OutputValue2 |
Data 2 |
Specifies the acquired data. |
-- |
Output |
O |
|
odbc.OutputValue3 |
Data 3 |
Specifies the acquired data. |
-- |
Output |
O |
|
odbc.OutputValue4 |
Data 4 |
Specifies the acquired data. |
-- |
Output |
O |
|
odbc.OutputValue5 |
Data 5 |
Specifies the acquired data. |
-- |
Output |
O |
|
common.returnValue |
Return value for the plugin |
The return value of this plugin stored. |
-- |
Output |
O |