Handle csv files with other characters

Description

Overview
If the uploaded csv files contains additional blank lines, or is comma separated, then the export job fails

Acceptance criteria:

  1. Remove blank lines

  2. Handle comma separated entries

Environment

None

Potential Workaround

None

Attachments

5

Checklist

hide

TestRail: Results

Activity

Show:

Andrii Novytskyi October 15, 2020 at 6:01 PM

Verified on rancher:
Use file that the library trying to upload, added one uuid that present in inventory :


Start export process with default profile,
check that export is done, status is completed with error, error logs that showing us that some uuids are invalid is present, and marc file contains 1 record.

Kruthi Vuppala October 15, 2020 at 3:58 PM

Thank you. This is the file that the library was trying to upload, Please test it with this file during validation:

Andrii Novytskyi October 14, 2020 at 7:16 AM

sure, I will do a validation

Kruthi Vuppala October 13, 2020 at 5:47 PM

While you are working on it , can you also please check if you can validate if the line is a UUID. There was a scenario today by a library where they were uploading a file with invalid lines and they did not know about it

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Concorde

Fix versions

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created May 18, 2020 at 6:20 PM
Updated November 6, 2020 at 10:11 PM
Resolved October 16, 2020 at 3:58 PM
TestRail: Cases
TestRail: Runs