Forum Discussion
- MisterB
Champion Level 3
There's not a lot of options within the system to control that. You could try these:
- Use custom fields in your test cases, define their value format and if they are required to save a test case
- only import test cases via csv, and create a validator to highlight issues
- Paul90New Contributor
Thanks for the reply. I was afraid that there is no such feature in Zephyr directly. Creating a validator via excel macros for a .csv file is definitely doable, but not exactly elegant nor user-friendly
But maybe there is a plugin (or something of sorts)?
- MisterB
Champion Level 3
I did a quick search and got these recommendations for cleaning CSV files - which is something I have to do often. Some of them might present you with options to control the format or structure of the data: I'm trialling OpenRefine (which is free).
Online Tools
- CSV Lint – Validates and cleans CSV files, checking for structural errors.
- TableConvert – Online CSV cleaner that can remove duplicates, fix formatting, and more.
- Opalytics Data Cleaner – Free online data wrangling tool by Trifacta.
Desktop Software
- OpenRefine – Powerful data-cleaning tool for refining CSVs, removing duplicates, and standardizing data.
- LibreOffice Calc – Free alternative to Excel that allows manual cleanup.
- CSVed – Lightweight CSV editor with cleaning functions.