LOADFILE:
Attributes


DEFAULTFILENAME

Default filename to be used

Value(s)

CDATA

Default Value

#IMPLIED

DELETERECORDS

Deletes all the records in the table before importing new data

Value(s)

Default Value

false

DELIMITERS

The file delimiter to be used when reading a csv file. ,' will work with commas in the csv file

Value(s)

CDATA

Default Value

#IMPLIED

DESTINATIONTABLE

Table to save the data into taken from the csv file

Value(s)

CDATA

Default Value

#IMPLIED

DROPTABLE

Drops the table before creating a new one.

Value(s)

Default Value

false

GLOB

The file glob used to show files, ie *.csv

Value(s)

CDATA

Default Value

#IMPLIED

MIMETYPE

Mimetype for loading the file

Value(s)

CDATA

Default Value

#IMPLIED

NAMEDCOLUMNS

Use the first row of the file to be used as the names of the fields in the table created.

Value(s)

Default Value

false

NONINTERACTIVE

Value(s)

Default Value

false

SKIPLINES

Number of lines to skip before reading data

this number of lines will be ignored

Value(s)

CDATA

Default Value

#IMPLIED

TEMPORARY

Creates a temporary table if set true. See postgresql for more information on temporary tables

Value(s)

Default Value

true

TYPE

How to handle the file loading (ie as a table (delimited) / as a chunk (binary), etc)

'null' here will cause the file to be opened and then closed without being read, any filename widget will still be updated but not database operations (create/drop etc) will be carried out

Value(s)

Default Value

#REQUIRED

USECONFIG

Look at the bondfrontend.conf and use the key mentoned in here to find out what delimiter to use for the file.

Value(s)

CDATA

Default Value

#IMPLIED
Back to LOADFILE


bond-2.1 DTD