Segmented House File Layouts

File layouts define the file structure of a segmented house file. Most vendors provide segmented house files in a specified format that typically does not change. When you use multiple segmented house files from the same vendor, a file layout eliminates the need to map the segmented house file fields each time you import a segmented house file.

Note: A file layout is associated with a particular record source. If you save a file layout for one source and import a segmented house file into another source, the previously saved file layout will not be available for the new import.

To add a new file layout, a valid *.csv file is required. The first row of the file must contain header fields. After you select the file, the header fields appear in the Field Name column, where you can map to pre-defined program fields or fields you define yourself.

During the mapping process, the program attempts to auto-map fields. The program fields are used throughout the program when you create new marketing efforts or query on segmented house file information. The available fields are:

• System record ID

• Finder number

• Source code

• Lookup ID

• Alternate lookup ID

On the File Layouts tab of the Segmented House Files page, you can view a list of saved file layouts. Select the name of the layout to open a page where you can view a list of all imported segmented house files that use the layout.