CodedUI test does not read data from CSV input file

by

Some text files start with a Byte Order Mark (BOM). The CSV reader within Coded UI does not handle the BOM and treats it as part of the first field name. The screen shot below shows the debug trace of a CSV file with a BOM and that same file shown in Notepad++. The DataRow.ItemArray[...] values are as expected. The DataRow.Table.Columns.ResultsView[...] shows the field names, but the first field name includes the BOM.

This CSV file with a BOM was created in Visual Studio using Solution Explorer => Add => New item => C# => General => Text file. Previously I have created a spread sheet with Microsoft Excel and saved it as a CSV file, that file did not have a BOM. I have also created files with Notepad++ and saved as CSV and they did not have a BOM. It appears that Visual Studio creates files with a BOM but when editing CSV files it does not add a BOM.

enter image description here

Visual Studio can create files with the correct encoding. Within “Step 2 – Create a data set” of this Microsoft page it states the text below. (Thanks also to Holistic Developer for providing very similar details in a comment.):

  1. It is important to save the .csv file using the correct encoding. On the FILE menu, choose Advanced Save Options and choose Unicode
    (UTF-8 without signature) – Codepage 65001 as the encoding.

More Related Contents:

  1. import csv file to sql database in c# window application without header row [duplicate]
  2. Stop Excel from automatically converting certain text values to dates
  3. Import data in MySQL from a CSV file using LOAD DATA INFILE
  4. Properly escape a double quote in CSV
  5. Ruby on Rails – Import Data from a CSV file
  6. csv to array in d3.js
  7. How can you read a CSV file in R with different number of columns
  8. How to properly escape a double quote in CSV?
  9. Can you encode CR/LF in into CSV files?
  10. Import .csv file to Sqlite in Android
  11. What MIME type should I use for CSV?
  12. Encoding Error in Panda read_csv [duplicate]
  13. import text to pandas with multiple delimiters
  14. Remove BOM () from imported .csv file
  15. Import CSV file with mixed data types
  16. How can I correct MySQL Load Error
  17. Importing data from multiple csv files in D3
  18. Reading multiple csv files from a folder into a single dataframe in R [duplicate]
  19. Parse a csv using awk and ignoring commas inside a field
  20. How to check if CSV file has a comma or a semicolon as separator?
  21. Importing CSV data into C# classes
  22. VBScript to loop through all files in a folder
  23. Preserving large numbers
  24. Sort CSV file by multiple columns using the “sort” command
  25. Import CSV to Update only one column in table
  26. Trying to merge multiple csv files in R
  27. UnicodeDecodeError: ‘charmap’ codec can’t decode byte 0x8d in position 7240: character maps to
  28. How I can Import data from CSV to MySQL?
  29. Process very big csv file without timeout and memory error
  30. Import CSV to Update rows in table

Leave a Comment