Documentation
ANALYSE CSV
usage
<ANALYSE>
<CSV path="filepath" [separator="char"]/>
[<RETURN>
<INFO>
[<STATS/>]
[<COLUMNS>
[<COLUMN i="number"/>]*
</COLUMNS>]
[<ROWS/>]
</INFO>
</RETURN>]
[<PAGINATE display="number" page="number"/>]
</ANALYSE>
paramètres
filepath: the path of the CSV file you want to analyse (structure and datas)
separator : (not mandatory, if not mentionned auto-detection is operated) the character separating every column. Usually a comma , or a semicolon ;
display: the number of rows returned
page: the page you want to return. If page is 2 and display is 20, you will receive the 21th to the 40th line.
retourne
If STATS is asked, returns the number of columns and rows in the file.
If COLUMNS is asked, returns the name of the columns in the file. Columns names are on the first line of the file. You can also specify which columns you want by adding COLUMN nodes with the number of the column in the i attribute.
If ROWS is asked, return every lines of data contained in the file.
exemples
<ANALYSE>
<CSV path="/contact/1857/imports.csv"/>
</ANALYSE>
<ANALYSE>
<CSV path="/contact/1857/imports.csv"/>
<RETURN>
<INFO><STATS/></INFO>
</RETURN>
</ANALYSE>
<ANALYSE>
<CSV path="/officity:libitem/3592/countries.csv"></CSV>
<PAGINATE display="10" page="1"></PAGINATE>
<RETURN>
<INFO>
<ROWS/>
</INFO>
</RETURN>
</ANALYSE>
Voir aussi :
CREATE CSV (Excel)
Generate Excel files
IMPORT CSV
Import a CSV (Comma Separated Value) file in you Nectil Database