Kentico Import Toolkit

Kentico Import Toolkit is an external utility which enables you to import data from external sources into Kentico. As a source of data, you can use:

  • MS SQL database
  • XML file
  • CSV file
  • XLSX file

Data from these sources can be imported as:

  • Pages
  • Page attachments
  • Objects
  • Object attachments (metafiles)
  • Custom table items
  • On-line form items
  • Resource strings

Launching Kentico Import Toolkit

You can launch Kentico Import Toolkit from the Windows Start menu -> All programs -> Kentico <version> -> Utilities. Kentico Import Toolkit is installed automatically on your computer with Kentico.

Using the utility to import data

There are two ways how you can import data from external sources to Kentico:

  • Using the wizard - a step-by-step guide through the import process. Also necessary to create an import profile for the command line mode.
  • Using the command line (see the following section)

You can also make use of these practical examples:

Importing data from the command line

You can run the Import Toolkit utility from the command line by executing the ImportToolkit.exe file located in <Kentico installation folder>\Bin (typically C:\Program Files (x86)\Kentico\<version number>\Bin) using a special syntax.

To perform the actual import:

  1. Create an import profile file in the last step of the wizard.
  2. Run the utility (located in the <Kentico installation folder>\Bin folder) using the ImportToolkit <profile file name> syntax.
    • You can launch the utility with an optional -i parameter, which ignores errors during the import.
    • You can specify either a relative or an absolute path to the .iprofile file.
    • Make sure you use proper quotation when entering an absolute path containing special characters, e.g., blank spaces.

ImportToolkit my_profile.iprofile -i

ImportToolkit "C:\Temp\ImportToolkit\my_profile.iprofile" -i

After executing the command, the tool will import the data to your Kentico instance based on the settings contained in the specified import profile.