Čarovnik za uvoz podatkov

Import Wizard

With the Data Import Wizard, advanced users can import records into Pantheon from an Excel file.

This instruction is made on the case of importing Items (although the window can be opened from different Pantheon forms).

In the next window, we define the excel file by clicking on three dots in the "Import File" field.

In Import Settings window set your SQL select statement based on your Excel file in correct column order.

In the "Field Transformation" window, we connect columns in Excel = External source and Pantheon fields. Enter External Source manually as there are Columns in Excel import file.

In the next window we get a preview of the data that will be imported:

In the next window we get a confirmation of imported data: