This guide outlines the essential requirements and system limitations you must follow when importing property data into your 8020REI domain. Adhering to these guidelines ensures a smooth, accurate, and conflict-free data import experience.
Required Fields for Import
To successfully match, update, or create property records, your import file must include the following fields:
Field Name | Description |
---|---|
Folio | Unique identifier from the county or data source |
Property Address | Full street address of the property |
Property Zip | 5-digit ZIP code associated with the property |
These fields are used to generate internal identifiers:
FID
= Folio + Property ZipPID
= Property Address + Property Zip
If any of these fields are missing or malformed, the row will be skipped during import.
File Format
Make sure your file is saved in the following format:
File Type:
.CSV
(Comma-Separated Values)Tools like Excel or Google Sheets allow you to export as CSV
Avoid using .XLSX, .TXT, or any other format for importing data.
Row Limit Guidelines
To maintain performance and ensure system stability, import files are subject to the following row limits, based on the number of columns:
Columns in File | Max Row Limit |
---|---|
More than 5 columns | 20,000 rows |
5 columns or fewer | 50,000 rows |
If your file exceeds these limits, break it into smaller parts before uploading.
Import Process Rules
8020REI only allows one active import at a time to prevent data conflicts.
If another import is in progress, please wait until it finishes before uploading a new file.
Before You Import: Data Validation Tips
Use “Remove Duplicates” to clean duplicate entries
Ensure no empty values in the required columns
Check for special characters that could break address formatting
Confirm column headers are spelled correctly (no typos or extra spaces)
Recommended Best Practices
Separate imports by type (e.g., skip trace updates, vendor enhancements, DNC tags)
Always preview a small batch (e.g., 10–20 rows) before bulk importing
Use tagging fields to help track the origin or purpose of the import
Need Help?
If you're unsure how to format your file or encounter any issues during the import process:
Contact your Customer Success Manager, or
Email our support team at support@8020rei.com
We’ll help you verify your file and ensure a successful upload.