Import Issues

Solutions for data import problems.

CSV Import

File Not Recognized

Symptoms: File rejected or not parsed

Solutions:

1. Check file extension is .csv
2. Verify UTF-8 encoding
3. Check for BOM (byte order mark)

Missing Columns

Symptoms: Required columns not found

Solutions:

1. Verify column names match specification
2. Check for extra spaces in headers
3. Compare with sample template

Encoding Errors

Symptoms: Strange characters in data

Solutions:

1. Save file as UTF-8
2. Remove special characters
3. Re-export from source system

Empty File

Symptoms: File appears empty

Solutions:

1. Verify file has data rows
2. Check header row exists
3. Look for hidden characters

API Import

No Data Returned

Symptoms: API returns empty results

Solutions:

1. Verify correct academic year
2. Check SIS has data
3. Review API filters

Partial Data

Symptoms: Some entities missing

Solutions:

1. Check for API pagination
2. Verify all entities are active
3. Review SIS data status

Slow Import

Symptoms: Import takes very long

Solutions:

1. Check network speed
2. Reduce data scope if possible
3. Run during off-peak hours