Resolving Common Bulk Upload Errors in EveryAction

1. Double Quotes:  

   • Issue: Double quotes are ignored when parsing data and do not prevent commas from being treated as delimiters.  

   • Resolution: Remove double quotes or replace them with single quotes for text fields.  

2. Single Quotes:  

   • Issue: Single quotes cause no issues and can remain.  

   • Resolution: No action required.  

3. Ampersands (&):  

   • Issue: Ampersands cannot be used.  

   • Resolution: Replace ampersands with the word "and" or another suitable character.  

Common Field Requirements and Limitations  

 File Formatting  

1. Maximum Number of Columns:  

   • Limit: A file can have up to 50 columns.  

   • Resolution: Reduce columns by consolidating data where possible.  

2. Unique Values in Fields:  

   • Limit: Fields like Activist Codes can have no more than 60 unique values in one file.  

   • Resolution: Split files into smaller batches, ensuring each has fewer than 60 unique values for these fields.  

Data Field-Specific Issues  

1. Address:  

   • Limit: Cannot exceed 500 characters.  

   • Resolution: Shorten addresses by using abbreviations or removing unnecessary details.  

2. Email:  

   • Limit: Must include “@” and be fewer than 100 characters.  

   • Resolution: Validate email addresses before uploading.  

3. Employer/Occupation:  

   • Limit: Cannot exceed 50 characters.  

   • Resolution: Use abbreviations or simplify employer/occupation names.  

4. First/Last/Middle Name:  

   • Limits:  

     • First Name: 75 characters max.  

     • Last Name: 150 characters max.  

     • Middle Name: 75 characters max.  

     • Resolution: Shorten names if needed.  

5. Gender:  

   • Requirement: Values must start with “M” or “F”. 

   • Resolution: Ensure all gender fields use these values.  

6. Phone Numbers:  

   • Requirement: Numeric values only, limited to 10 digits.  

   • Resolution: Remove non-numeric characters (e.g., parentheses, dashes) and ensure the length is 10 digits.  

7. State:  

   • Requirement: Must be a valid US state or territory.  

   • Resolution: Correct any typos or invalid entries.  

8. Suffix:  

   • Limit: 5 characters max.  

   • Resolution: Shorten long suffixes if applicable.  

9. Zip Code:  

   • Requirement: Numeric values only, max 10 characters.  

   • Resolution: Ensure zip codes are valid, removing any non-numeric characters.