> ## Documentation Index
> Fetch the complete documentation index at: https://docs.gocrisp.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Export Data

> 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

> [!TIP]
>
> 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.

![Folder options image](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/fp_export_data/fp_add_data_export.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=b835263a5e5860ab2fe4532da2e64e00)

***

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/1.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=1d6ed169143a636c5f4525966967614f) 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.

> [!NOTE]
>
> 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.

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/2.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=c3e5beb246e7871550c37ea4c09f8eef) 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.

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/3.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=e3bc67ceab892288710996ffc3d09324) 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.

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/4.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=957b491a87ac5465ed026e7e5bd7dfa6) 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.

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/5.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=aee7533a7cfe5f520502ab10b7c75777) 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.

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/6.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=652dc593c6e4b1f4ac82733bbfdfc285) 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.

#### ![](https://mintcdn.com/crispinc/BhWWiYvsoitb8WXT/mission-control/images/numbers/7.png?fit=max\&auto=format\&n=BhWWiYvsoitb8WXT\&q=85\&s=37d5df58429a87bd6cd5bcc29d803ce4) 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.
