Skip to main content
This allows users to use data they have acquired outside the floorplan files and import them into objects in the floorplan files.

Why you would use this feature

There are many valuable applications for this automation:
  • Updating floorplan attributes
  • Updating performance data
  • Updating data in floorplans & sections
  • Create and update drawings
  • Create and update fixtures

Feature Options

Data File Options

Data file options allow you to select the file you will be importing and configure various settings, so it will import as expected.

Where is the data file you want to import?

You can select the file you want to use as a data source for your import. CSV and all Excel format files (XLS/XLSX/XLSM/XLSB) are supported. Click on the … button to browse for the file containing the data to be imported.

Which sheet do you want to import?

This will default to the first sheet in your workbook for Excel files. If you want to use a different sheet, you can select from the list of available sheets. Data will be imported from your selected sheet.

Imported data has header rows

If your data has a header row, you can indicate this here. If you have header rows, you will be able to use the data automapping options.

Data starts in row

By default, your data will be imported starting from the first row. If you have a title, blank lines, or anything at the top of your file, you can indicate where your header rows or first row of data starts.

Field Mapping Options

Select any objects you want to use as a matching option or an update location. Adding fields here will increase the selection options when you map fields.

Field Mapping

Folder options image

Create New Object

For sections, drawings (or text boxes), or fixtures, you can create a new object based on the data in your source file. First, a new object will be created for each item in the data source not found in the floorplan. Then, the data from that row in the data source will be populated into the new record.
Unmatched records can only be made for objects you have a match on set in your data source.

Create unmatched planograms

Create new planogram records for any planograms not found in your floorplans. This option is only available when you have selected either Match on/ID(Planogram), Match on/Name(Planogram) or Match on/Key(Planogram) for a column of your data.

Create unmatched fixtures

Create new fixture records for any fixtures not found in your floorplans. This option is only available when you have selected Match on and any fixture field for at least one column of your data.

Create unmatched drawings

Create new drawing records for any drawings not found in your floorplan. This option is only available when you have selected Match on and any drawing field for at least one column of your data. Text boxes are considered drawings in Floor Planning, which can be used to create new text boxes.