csvimport

CSV files should have a header line that lists columns. Headers can also be appended with :type to indicate the type of the field. escaped is the default, though it can be overridden by the importer. Supported types:

:python:

A python expression, run through eval(). This can be a security risk, pass in allow_python=False if you don't want to allow it.

:int:

Integer

:float:

Float

:str:

String

:escaped:

A string with backslash escapes (note that you don't put quotation marks around the value)

:base64:

A base64-encoded string

:date:

ISO date, like YYYY-MM-DD; this can also be NOW+days or NOW-days

:datetime:

ISO date/time like YYYY-MM-DDTHH:MM:SS (either T or a space can be used to separate the time, and seconds are optional). This can also be NOW+seconds or NOW-seconds

:bool:

Converts true/false/yes/no/on/off/1/0 to boolean value

:ref:

This will be resolved to the ID of the object named in this column (None if the column is empty). @@: Since there's no ordering, there's no way to promise the object already exists.

You can also get back references to the objects if you have a special [name] column.

Any column named [comment] or with no name will be ignored.

In any column you can put [default] to exclude the value and use whatever default the class wants. [null] will use NULL.

Lines that begin with [comment] are ignored.