Documentation
CREATE CSV (Excel)
usage
<CREATE>
<CSV [template=""]>
<QUERY>
<SEARCH>...</SEARCH>
</QUERY>
</CSV>
</CREATE>
retourne
The path to a CSV file
In the QUERY node, you can place the NQL searches of which you want export the results.
Using the RETURN node, you can specify which informations (columns) you want to export in you CSV file (INFO, CATEGORIES, DESCRIPTIONS). Every field returned by your NQL query will have a dedicated column in the CSV file.
Download here a script and a template generating a generic CSV file from the contacts of a specific category.
CSV Command only exports lists, not trees! If you need to export a tree (a website for example), use the SEARCH/element/ANCESTOR command, or the GETDESCENDANT command.
exemples
<QUERY>
<CREATE>
<CSV>
<QUERY>
<SEARCH>
<CONTACT>
<INFO>
<ID>1857</ID>
<ID>2</ID>
</INFO>
</CONTACT>
<RETURN>
<INFO/>
<CATEGORIES/>
</RETURN>
</SEARCH>
</QUERY>
</CSV>
</CREATE>
</QUERY>
Voir aussi :
ANALYSE CSV
Get a XML description of a CSV file (headers and content)
IMPORT CSV
Import a CSV (Comma Separated Value) file in you Nectil Database