Allows you to quickly extract data from one or more project files in Floor Planning.
This automation allows users to export data using Floor Planning Tables. The number of files/DB keys to be processed is not limited by opening them into a project. Any data included in a table can be exported with this feature. Multiple tables can be set up simultaneously and processed in a list.
Why you would use this feature
Reporting:
Any Table you can build can export data from .pfa files for reporting
Count of specific Fixtures from specific Floorplan
List of sections that fail specific objectives such as Space to Sales goals
Floorplan level Space and Sales metrics by Department, Category, etc
Department information by Floorplans
Bill of materials
Validating:
Floorplan-specific planogram list
Section size overrides
Section changes between multiple floorplans
Underfilled and overfilled floorplan fixtures
Creating an input file for another feature in MissionControl
Exporting any data that is needed from batches of floorplans
To use Export Data as a validation tool, you can apply a filter to your report. The filter will allow you only to show records where it fails. If you export the project file name or DB Key with the report, once you have
exported the data, you will have a list of only the floorplans that need to be reviewed because they failed the
filter.
Feature Options
Add Export
Clicking the Add Export button will allow you to add a table to be exported. Using the displayed dialog, you can
configure how you would like to export your table.
Which table would you like to use to export the data?
Selecting a table here will use that table with each floorplan and export the data.
Generally, any table file will work; however, keep in mind the following things:
Table files should have Span All Projects turned off. Your data output may have duplicated results if this setting is left on.
Table files should also have their scope set to All floorplans. If the scope is set to Single Floorplan or Multiple Floorplans, your data output may be missing some floorplans.
If you need to alter either of the above settings, check the file against some floorplans to verify that the data looks how you expect it to appear. For example, changing the scope could cause data to no longer be appropriately grouped and may require modifying the table’s sorting and grouping to correct.
How would you like to export the table data?
Select the option for how exported data will be stored.
Export all floorplans to a single file
Exported data for all floorplans/projects within the batch is processed into one data file.
Export each project to its own file
Creates an output file for each project that is exported.
How would you like to export the table headers?
Select an option to determine how table headers will be handled.Include all headers - Include each export in the same data structure as the table, and titles or header lines will also be exported for each project.Include only the first header - Include any headers with the first project exported, but any subsequent exports will
not include the headers.Do not include any headers - Headers will not be included for any of the exported projects.
How many header rows does your table use?
Select the number of header rows your table contains within Floor Planning. Header rows include titles, blanks and object headers.
Where would you like to save the exported data?
Select an output location for the exported data files. Depending on what was selected in How would you like to export the table data,
the entry will allow you to specify a single output file or folder containing all the output files created.
How would you like to name the exported data files?
This option only appears if you are exporting projects into multiple files.Select the method you’d like to use to name the data files created during the export.Use the filename of DB Key of the floorplan - will use the file name of the project for floorplans stored in PSA
files, or the DB key for floorplans stored in a CKB database.Use a value from the first floorplan in the project - allows a formula to be used to determine the file name to use.
The formula will be evaluated against the first floorplan in the project.
Which data fields do you want to use to create the name?
This option is only enabled if you use Use a value from the first floorplan in the project to name the
exported data files.Enter a field or formula that will be evaluated against the first floorplan in the project. The result of the
evaluation will be used as the file name for the exported file.
Was this page helpful?
Assistant
Responses are generated using AI and may contain mistakes.