This legacy importer uses ColdFusion scripts. It has been replaced by new functionality in the API Server. See Data Import from CSV for the new documentation.
The data importer provides a range of tools that allow you to import CSV data into custom tables in the iCM database. You can create and delete tables, import new versions of data, purge old data, and index imported data in the platform's search engine.
Data is imported using importer scripts, which are tailored to the data you need to import. As well as creating tables and defining columns and mappings, these scripts can also include row filters and custom functions to transform the CSV data before it's imported.
Database and Importer Details
All functions take a parameter named
<cfmodule template="/icm/admin/dataimport/importer_v1.cfm" name="di" datasource=#ds# databasetype=#dt#>
This is then used in each function as:
<cfset existingTable = di.tableExists(ctx=#di#, tablename=#tablename#)>
All tables created by the data importer are prefixed