Documentation
IMPORT CSV
usage
<IMPORT>
<CSV module="{contact,media,group}" path="" [separator="{tab,;}"]>
[<COLUMNS>
<COLUMN>xpath</COLUMN>
...
</COLUMS>]
</CSV>
</IMPORT>
parameters
module, path
returns
the path to a NQL file equivalent to the CSV
Import a CSV (Comma Separated Value) file in you Nectil Database
CSV is a rudimentary file format, supported by Access, Excel and most databases.
examples
<IMPORT>
<CSV module="contact" path="/media/imports.csv"/>
</IMPORT>
If no columns are indicated, column names found in the csv will be used.
<IMPORT>
<CSV module="contact" path="/contact/1857/imports.csv">
<COLUMNS>
<COLUMN>INFO.FIRSTNAME</COLUMN> first column will be the firstname
<COLUMN>INFO.LASTNAME</COLUMN>
<COLUMN>INFO.EMAIL1</COLUMN> third column will be the email
<COLUMN>DESCRIPTIONS.DESCRIPTION[@languageID='fre']/TITLE</COLUMN> fourth column will the title of the description in french
<COLUMN>CATEGORIES.CATEGORY[1].@path</COLUMN>
<COLUMN>CATEGORIES.CATEGORY[2].@path</COLUMN>
<COLUMN>DEPENDENCIES.DEPENDENCY[@type='contactWork'].CONTACT.@ID</COLUMN>
</COLUMNS>
</CSV>
</IMPORT>