CSV Import Data Mapping Mismatch
I am importing tests from a CSV that was exported from MicroFocus ALM. In the Data Mapping screen, I have aligned each "Current value" to the appropriate "Target value" for "Priorities" and "Statuse...
Forum Discussion
That is some strange behaviour. I've not seen that before. I assume it has to be a file or data issue but I guess it's possible that the import function has a bug. You're probably going to have to raise a ticket with SmartBear support (I've added the link below for you).
I've added some thoughts below on how I'd approach this issue (apologies if this is trying to teach you to suck eggs!)
1) File issue?
You could rule out the file issue (if you haven't already) by stripping out the data from your CSV file and placing it in a clean template, preferably one that you know already works. If the import from a clean file doesn't work, we can assume it's a data issue.
2) Data issue?
You could search your data for carriage returns or special characters which might cause problems (just a guess), look for rows that contain the most characters (LEN() function), NULLS, etc. - temporarily remove those suspect rows and try another import. If the import is still failing...
3) Multiple imports
... you could try importing in smaller batches of, say 50 records, to try and pinpoint when the data issue occurs.
Or... you could contact SmartBear 🙂
