<autoImport> Element

This element defines an automatic table import task.

Parent Elements

autoImports

Attributes

Name	Type	Description	Required
importType	string	The type of import to perform: Replace or Update	Yes
inboxPath	string	The full path to the inbox for data import files. This is a directory name with an optional wildcard file pattern.	Yes
processedFolder	string	The full path to the folder in which to place processed data import files.	Yes
headers	string	The column header names, separated by commas, if the import data files will not contain a header line.	No
keyColumn	string	The name of a column in the data import file, which should match a column in the table.	If importType is Update

Child Elements

None.

Remarks

The inbox directory specified by inboxPath will be monitored for new files. When new files appear in the directory (and that match the optional wildcard pattern if one is specified), they will automatically be imported into the specified table (per the logic defined by the other attributes) and then moved to the processed directory specified by processedFolder.

The importType attribute causes the import to behave as follows, depending on its value:

Value	Behavior
Replace	The content of the data file will replace the entire table.
Update	The content of the data file will update the existing data in the table. keyColumn specifies which column is used to match rows. Rows in the table with the same key column value as that of rows in the import data file will be updated, and when key column values in the import data file do not already exist in the table, rows will be added.

See the <table> Element remarks for the list of supported file formats.