You can export the search results to a CSV file. The exported file contains the values of fields that are set to be searchable and the values of fields that appear as filters. The exported search results don't contain dynamic fields.
1 Select a business entity and use the search box to search for the records.
The Search Results page appears.
2Select the records that you want to export.
3Click Selected > Export.
The Export Selected Records dialog box appears.
4Click Export.
The export process doesn't consider space as a value. When you export records that contain blank data for a particular field, the export process excludes the blank data for that particular field in the exported file.
If the field has value along with spaces in between, the export process considers the space. For example, ABC corporation is exported as ABC corporation.
Sample exported search results file
The exported search results file includes the field details in the following format:
•The first row includes all the root field values. The root field values appear in all the rows.
•A separate row includes all the source record details.
•If the system fields are searchable, additional columns are included for these fields.
•Additional rows are included for every entry of field group and nested field group. All the field values in a field group or nested field group for an entry appear in a single row.
Also, you can view additional columns that contain the ID of the field groups and nested field groups.
•If records contain validation errors, the file contains a row for each validation error type. For example, if a field in a field group contains three validation error types, such as warning, information, and error, the exported file contains three separate rows for the field.
Additional columns display details, such as severity and error message.
•If the file contains deleted records, an additional States_Record State Indicator column indicates whether a record is active or deleted.
The following table lists a sample of the exported search results file that includes separate rows for the records with nested field groups that contain validation errors:
meta_id
Created By
Brand Name
Category_id
Category_Sector
Category_Cam_Camera_idBrand_id
Category_Cam_Camera
Category_Brand_Price_id
Category_Brand_Price_Price
Severity
Error Message
655f51a
Tom
Focus Studio
7ff4b5
INFO
Brandname: This is a mandatory field.
655f51a
Tom
Focus Studio
7ff4b5
Photography
87gh6
ERROR
Camera: You can't proceed to the next step without entering a value for this field.
655f51a
Tom
Focus Studio
7ff4b5
Photography
87gh65r
Sony
ldw829
Sony ZV
ERROR
Price: Invalid data. Enter an integer.
655f51a
Tom
Focus Studio
7ff4b5
Photography
87gh65r
Sony
ldw829
INR 1,92,990
WARNING
Price: Calculate festive discounts and enter the price.
The following table lists a sample of the exported search results file that contains deleted master records: