CSV Import

Import all the entries of a CSV file into one or more Nectry tables.

Outline Display: Importing a CSV file into tables: {{import}}.

Requirements

I know that, when inventing a new table to receive results of CSV imports, you yearn deeply to add an extra integer primary key to the schema – resist that urge and DO NOT ADD AN EXTRA PRIMARY KEY IF THE USER HAS NOT ASKED FOR IT. In general, try to be conservative in marking ANY column as a key, only doing so when it is clear the creator of the file intended for that field to be used in such a way. DO NOT assign an integer type to a numeric column that contains at least one period in sample data; choose one of float, decimal, or money, depending on context. ALWAYS choose an optional type for a column that includes at least one empty value in sample data. ALWAYS, for a column of Boolean type (optional or required), use an explicit ingredient to explain which text value stands for “true”.

Settings

Optional

• import : ingredient slot of csvImportTableIngredients (many)
  The table(s) to put the CSV data into

• label : constant value (type: text; optional)
  A label to describe what this does to the user