Uploading Data
Upload your vehicle fleet and department information to start managing recalls with Rikol. This guide walks you through the process using our provided Excel templates.
Download our Excel templates before uploading to ensure proper formatting and prevent errors.
Sample Templates
Upload vehicle information including VINs, departments, and vehicle details
Upload department information and organizational structure
Download Templates
Go to the "Upload" section in the sidebar navigation
Click "Download Assets Sample" or "Download Department Sample"
Open the files to understand the required column structure
Vehicle Data Template
Required Fields
- VIN: 17-character Vehicle Identification Number (must be unique)
- Tag Number: License plate or asset identifier
- Year: Vehicle manufacturing year
- Make: Vehicle manufacturer (e.g., Ford, Chevrolet)
- Model: Vehicle model name
- Department: Department responsible for the vehicle
- County: Geographic location
- Company Code: Your organization identifier
Optional Driver Fields
- Driver First Name, Last Name, Email, Phone Number
- VINs must be exactly 17 alphanumeric characters
- Department names must match your organizational structure
- All required fields must be completed
Department Data Template
Configure your organizational structure with:
- Department names and IDs
- Manager information
- Contact details
- Company codes
Upload Process
Format your data using the sample templates
Click "New Upload" in the Upload section
Browse or drag your Excel file to the upload area
Check the data preview for formatting issues
Click "Confirm Upload" and wait for completion
Supported File Types
- Excel files (.xlsx, .xls) - Recommended
- CSV files (.csv) - For simple data
- File size limit: 10MB maximum
Best Practices
Data Preparation
- Use provided templates exactly as formatted
- Validate all VINs are unique and correctly formatted
- Ensure department names are consistent
- Remove empty rows and extra formatting
Quality Checks
- Test with small batches first
- Verify VIN format (17 characters, alphanumeric)
- Confirm department names match your organization
- Check for duplicate entries
Common Issues
- Duplicate VINs: Each vehicle must have a unique VIN
- Invalid VIN format: Must be exactly 17 alphanumeric characters
- Missing required fields: Complete all mandatory columns
- Department mismatches: Verify department names are exact matches
After Upload
Once uploaded, your vehicle data will be automatically checked against NHTSA recall databases. You can:
- View vehicles in the dashboard
- Monitor recall status updates
- Manage department assignments
- Track recall compliance
Troubleshooting
If upload fails:
- Check file format - Ensure it matches the sample template
- Validate required fields - All mandatory columns must be filled
- Review error messages - Read specific error details
- Contact support - Reach out if issues persist
After uploading vehicles, Rikol automatically monitors for new recalls and updates your dashboard when recalls are found.