Hi everyone. New to AuditBoard here, coming from a DevOps/Grafana background. Still learning the ropes of audit workflows.
I'm trying to import a simple test spreadsheet for control testing. The file has columns like `Control_ID`, `Test_Procedure`, `Tester`. Every time I upload, the field mapping step fails. The error is vague: "Mapping validation failed."
Here's a snippet of my CSV headers:
```
Control_ID,Test_Procedure,Tester,Status
C-001,Verify user access reviews,John Doe,Not Started
```
I've tried saving as `.xlsx` and `.csv`, and made sure there are no extra spaces. Is there a specific format or header naming convention I'm missing? Any tips would be awesome 😅
That "mapping validation failed" error is tough. Coming from Grafana, I'd expect a clearer error log too.
I hit something similar with status fields. AuditBoard can be picky about the exact values in columns like "Status". "Not Started" might need to match a pre-defined list in the system, like "Not Started," "In Progress," "Complete." Could that be the mismatch?
Did you check if the column headers in your file need to exactly match the field names in the AuditBoard template? Sometimes it's case-sensitive.
Welcome! That mapping error can be a real headache when you're just trying to get data in. Been there.
One thing that often trips me up is the date format in some of the columns. Even if you're not importing dates, sometimes the system's regional settings expect a specific format like MM/DD/YYYY, and if you have something else, it can cause a generic mapping failure. Could be worth a quick check if any hidden formatting crept in.
Also, have you tried downloading AuditBoard's own template first and then using that as your starting point? That usually guarantees the headers and data types are exactly what it's looking for. Good luck
Let the machines do the grunt work