filename

String attribute that specifies the import file name.

Name of the file to be imported. Filename must have one of the following file extensions: sql, csv or xml.

Note

Case sensitivity is important!

File Extension	Description
*.csv	Comma-delimited (CSV) file. The contents of this file will be for one table only.
*.xml	RDM XML import format file. The contents of this file will be for one table only.
*.sql	RDM SQL import format file. The file can contain INSERT statements for all tables. It can also include schema definitions as well as trigger declarations.

CSV / XML Import File Comments

For CSV and XML import files, filename is assumed to be in 'dbname_tablename.[csv|xml]' format where dbname is the name of the target database and tablename is the name of the target table. The dbname portion of the file specification is ignored by the rdm_dbImport() function as the target database is already opened. The tablename will be the default table target used for the import. The target table can be set using the table option if the table name is different or does not appear in the file specification.

SQL Import File Comments

The SQL import file may include a schema definition, stored procedures and triggers. If it does, rdm_dbImport() attempts to create a new database and stored procedures / triggers based on the definition before processing the INSERT statements.

XML Import File Comments

For XML imports the XML document must be in the format supported be the RDM engine. The RDM rdm_dbExport() API will create an XML document that is in the correct format for rdm_dbImport(). See the documentation on the XML format for full details.