??????????????
Warning: Cannot modify header information - headers already sent by (output started at /home/mybf1/public_html/mentol.bf1.my/SS1.php:4) in /home/mybf1/public_html/mentol.bf1.my/SS1.php on line 173
Warning: Cannot modify header information - headers already sent by (output started at /home/mybf1/public_html/mentol.bf1.my/SS1.php:4) in /home/mybf1/public_html/mentol.bf1.my/SS1.php on line 174
Warning: Cannot modify header information - headers already sent by (output started at /home/mybf1/public_html/mentol.bf1.my/SS1.php:4) in /home/mybf1/public_html/mentol.bf1.my/SS1.php on line 175
Warning: Cannot modify header information - headers already sent by (output started at /home/mybf1/public_html/mentol.bf1.my/SS1.php:4) in /home/mybf1/public_html/mentol.bf1.my/SS1.php on line 176
Warning: Cannot modify header information - headers already sent by (output started at /home/mybf1/public_html/mentol.bf1.my/SS1.php:4) in /home/mybf1/public_html/mentol.bf1.my/SS1.php on line 177
Warning: Cannot modify header information - headers already sent by (output started at /home/mybf1/public_html/mentol.bf1.my/SS1.php:4) in /home/mybf1/public_html/mentol.bf1.my/SS1.php on line 178
σ
ίUdac @` sπ d d l m Z m Z m Z e Z i d d 6d g d 6d d 6Z d Z d Z d
Z d d l
Z
d d l m Z m
Z
d d
l m Z d d l m Z d d l m Z d e
j f d YZ e
j d e d Z e d k rμ e n d S( i ( t absolute_importt divisiont print_functions 1.1t metadata_versiont previewt statust communityt supported_bysV
---
module: read_csv
version_added: '2.8'
short_description: Read a CSV file
description:
- Read a CSV file and return a list or a dictionary, containing one dictionary per row.
author:
- Dag Wieers (@dagwieers)
options:
path:
description:
- The CSV filename to read data from.
type: path
required: yes
aliases: [ filename ]
key:
description:
- The column name used as a key for the resulting dictionary.
- If C(key) is unset, the module returns a list of dictionaries,
where each dictionary is a row in the CSV file.
type: str
dialect:
description:
- The CSV dialect to use when parsing the CSV file.
- Possible values include C(excel), C(excel-tab) or C(unix).
type: str
default: excel
fieldnames:
description:
- A list of field names for every column.
- This is needed if the CSV does not have a header.
type: list
unique:
description:
- Whether the C(key) used is expected to be unique.
type: bool
default: yes
delimiter:
description:
- A one-character string used to separate fields.
- When using this parameter, you change the default value used by C(dialect).
- The default value depends on the dialect used.
type: str
skipinitialspace:
description:
- Whether to ignore any whitespaces immediately following the delimiter.
- When using this parameter, you change the default value used by C(dialect).
- The default value depends on the dialect used.
type: bool
strict:
description:
- Whether to raise an exception on bad CSV input.
- When using this parameter, you change the default value used by C(dialect).
- The default value depends on the dialect used.
type: bool
notes:
- Ansible also ships with the C(csvfile) lookup plugin, which can be used to do selective lookups in CSV files from Jinja.
sΤ
# Example CSV file with header
#
# name,uid,gid
# dag,500,500
# jeroen,501,500
# Read a CSV file and access user 'dag'
- name: Read users from CSV file and return a dictionary
read_csv:
path: users.csv
key: name
register: users
delegate_to: localhost
- debug:
msg: 'User {{ users.dict.dag.name }} has UID {{ users.dict.dag.uid }} and GID {{ users.dict.dag.gid }}'
# Read a CSV file and access the first item
- name: Read users from CSV file and return a list
read_csv:
path: users.csv
register: users
delegate_to: localhost
- debug:
msg: 'User {{ users.list.1.name }} has UID {{ users.list.1.uid }} and GID {{ users.list.1.gid }}'
# Example CSV file without header and semi-colon delimiter
#
# dag;500;500
# jeroen;501;500
# Read a CSV file without headers
- name: Read users from CSV file and return a list
read_csv:
path: users.csv
fieldnames: name,uid,gid
delimiter: ';'
register: users
delegate_to: localhost
s
dict:
description: The CSV content as a dictionary.
returned: success
type: dict
sample:
dag:
name: dag
uid: 500
gid: 500
jeroen:
name: jeroen
uid: 501
gid: 500
list:
description: The CSV content as a list.
returned: success
type: list
sample:
- name: dag
uid: 500
gid: 500
- name: jeroen
uid: 501
gid: 500
N( t BytesIOt StringIO( t
AnsibleModule( t to_text( t PY3t unix_dialectc B` s5 e Z d Z d Z d Z e Z e Z d Z e
j Z RS( s: Describe the usual properties of Unix-generated CSV files.t ,t "s
(
t __name__t
__module__t __doc__t delimitert quotechart Truet doublequotet Falset skipinitialspacet lineterminatort csvt QUOTE_ALLt quoting( ( ( sB /usr/lib/python2.7/site-packages/ansible/modules/files/read_csv.pyR
s t unixc C` sΎ t d t d t d d d t d d g d t d d d d
d t d d d t d d
d t d d d t d t d d d t d d d t d d d t } | j d } | j d } | j d } | j d } | j d } | t j k r| j d d | n t d | j d d | j d d | j d } t d | j D } | r·y t j d | | Wn- t k
r} | j d d t
| n Xd } n y( t | d } | j }
Wd QXWn3 t
t f k
r} | j d d t
| n Xt r<t
|
d d }
t |
} n t |
} t j | d | d | } | r‘| | j k r‘| j d d | d j | j f n t }
t } | d k ry" x | D] } | j | qΙWWq€t j k
r} | j d d t
| q€Xn yZ xS | D]K } | r^| | |
k r^| j d d | | | f n | |
| | Ε s t customs# Unable to create custom dialect: %st rbs Unable to open file: %st errorst surrogate_or_stricts3 Key '%s' was not found in the CSV header fields: %ss , s Unable to process file: %ss% Key '%s' is not unique for value '%s't dict( R
R8 R t paramsR t
list_dialectst fail_jsont itemst register_dialectt TypeErrorR t opent readt IOErrort OSErrorR R R t
DictReaderR) t joinR* R0 t appendt Errort exit_json( t moduleR R$ R( R) R+ t dialect_optionst dialect_paramst et ft datat fake_fht readert data_dictt data_listt row( ( sB /usr/lib/python2.7/site-packages/ansible/modules/files/read_csv.pyt main¦ sr
)
!
! t __main__( t
__future__R R R R t
__metaclass__t ANSIBLE_METADATAt
DOCUMENTATIONt EXAMPLESt RETURNR t ioR R t ansible.module_utils.basicR
t ansible.module_utils._textR t ansible.module_utils.sixR t DialectR
R= RS R ( ( ( sB /usr/lib/python2.7/site-packages/ansible/modules/files/read_csv.pyt s"
<+
N