When importing assets in bulk, it’s important to format the CSV correctly. Here are common mistakes and how to resolve them.
| Error Type | Cause | Solution |
|---|---|---|
| Date Format Mismatch | Date fields don’t match format selected during upload | Use consistent format (e.g., dd-mm-yyyy) and match it during import |
| Missing Mandatory Fields | Title, category, or code left blank | Ensure all required columns are filled |
| Invalid Employee Names | Employee name in file doesn’t match system records | Use exact spelling as in the employee master |
| Wrong Category Name | Category doesn't exist or misspelled | Use leaf-level category names exactly as listed in the system |
| File Not in CSV Format | Uploaded file is Excel, not CSV | Save file as .csv before uploading |
| Extra Commas or Special Characters | Causes column mismatch | Clean data to avoid extra commas or characters like &, %, etc. |
Pro Tips:
- Always download and use the sample CSV provided.
- Open and save your file using tools like Google Sheets or Excel with CSV format selected.