# Data Issues Common solutions for upload errors, validation failures, broken hierarchies, missing data, and field mapping issues. ## Data Upload Errors **CSV upload fails completely** * Ensure the file is saved as CSV (not .xlsx) and encoded as UTF-8 (Excel: Save As > CSV UTF-8) * Check file size (<50MB) and remove empty rows or columns * Test with a small subset (e.g., 100 rows) to isolate the issue; try a different browser **"Missing required fields"** * Add the missing column (Position ID, Manager ID, or Job Title) * Headers are case-sensitive and must match exactly * Leave Manager ID blank only for the top-level position (e.g., CEO) **"Duplicate Employee ID"** * In Excel: select the Employee ID column > Data > Remove Duplicates * Ensure each ID is unique, then re-upload **"Invalid Manager ID"** * Each Manager ID must match an existing Employee ID in the file * Check for typos, format mismatches (e.g., "001" vs "1"), or managers missing from the dataset **"Circular reporting" or "Self-reporting"** * Trace the reporting chain to identify the loop (e.g., A → B → C → A) * Update a Manager ID to break the loop; an employee cannot be their own manager ## Field Mapping Issues **Wrong fields mapped (data in wrong columns)** * Go to Data Management > Field Mapping (Admin) and update mappings * During upload, use the field mapping screen to map each CSV column to the correct Agentnoon field **Custom fields not appearing** * In Data Management > Field Mapping, add a mapping for the custom CSV column * Select a field type (text, number, date), save, then re-upload or use a partial upload **Date format errors** * Make sure the entire format is in 1 format and you've select that format in Agentnoon when mapping your fields * In Excel: Format Cells > Custom > `yyyy-mm-dd` * Incorrect formats: `02/18/2026`, `18-Feb-2026`, `2026/02/18` ## Missing or Incorrect Data After Upload **Missing employees after upload** * Check the upload report for validation errors (e.g., missing required fields, invalid manager IDs) * Clear all filters and verify employees are within your access scope * Partial uploads only update records included in the file — use a full upload to include all employees **Employee data incorrect after upload** * Verify the source CSV contains correct values and check field mapping * Re-upload a corrected CSV; if issue persists, contact support **Reporting relationships broken** * Look for the orange broken hierarchy indicator in the toolbar * Fix by updating the source HRIS and re-syncing, using a partial upload to correct Manager IDs, or manually editing the position (temporary) **Department / location incorrect** * Check for inconsistent naming ("Engineering" vs "engineering", "SF" vs "San Francisco") * Standardize in source CSV using find-and-replace, then re-upload **Salary showing wrong amount** * Values must be plain numbers only: `150000` not `$150,000` * Verify field mapping points to the salary column; check currency codes (USD, EUR, GBP) ## Data Refresh Issues **Refresh taking too long** * Normal: <5,000 employees = 1–5 min; >10,000 employees = 1–15 mins * If stuck >2 hours: contact support **Data refresh failed / rolled back** * Fix validation errors in source CSV and re-upload **Need to restore previous data** * Re-upload your previous CSV as a full data upload * If unavailable, export from HRIS as of a prior date or contact support for backup restoration * Prevention: save dated CSV copies before each upload ## Validation Warnings **Salary outliers detected** * Review if legitimate (executives, interns, currency conversion errors) * Check for typos (1,500,000 vs 150,000); if all are valid, proceed — it's a warning, not a blocker **Inconsistent naming** * Standardize values in source CSV (one format per field); use find-and-replace in Excel ## Partial Upload Issues **Partial upload not updating records** * Verify the unique identifier (Employee ID or Position ID) in the partial CSV matches exactly — including format (e.g., "001" vs "1") **Partial upload created duplicates** * IDs didn't match, so the system created new records * Fix: run a full upload to replace duplicates, or manually delete the extra positions ## When to Contact Support Contact if: * Uploads fail with unclear errors after the steps above * Data corruption occurs after upload * Live integration stops working completely * Validation errors persist after fixes * A data refresh is stuck for more than 2 hours Include: upload timestamp, exact error message, anonymized sample CSV, screenshots, and organization name. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.agentnoon.com/troubleshooting/data-issues.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.