ymhadjou asked a question.
Hello,
We want to create a business adapter with a csv source file with comma delimiter. Unfortunately, the tool doesn't seems to identify the column name.
Could you please help us ?
Thank you
My guess it's about the file's encoding. Try opening the csv file in notepad++ and check if the encoding is set to utf-8.
Hello,
Thanks it's a little bit better But first column is not showing and column name is to recognized.We have instead F3,F3,F4
We had this issue a while back and mfranz had the solution (which is the same as above). Are you sure your schema.inf is correct?
https://community.flexera.com/s/FlexNet-Manager-Forum/CSV-Import-error124995/highlight/true
I had issues with some older versions of the Business Adapter Studio, so maybe you can update that.
If that does not help, I found it a good workaround to set the Column delimiter to "None" and use a schema.ini file.
We don't have this option
CSV file is now encoded on UTF8 it's a little bit better, but column name is not recognized. We have instead F2,F3,F4. and First column is empty
May I ask you to remove all but header + 1 row from that csv and share?
I'll try it on my end.
Hi,
@mfranz So I tried with schema.ini, but it doesnt change the final result
@ppyrzynski We also tried this option, and this is where we had F2,F3,F4 column header
OK, Opened your file in Notepad++ and checked encoding. It still shows UTF-8-BOM.
Changed the encoding to pure UTF-8 and saved. Now the column names show.
Please check wit attached csv file.
OK, Opened your file in Notepad++ and checked encoding. It still shows UTF-8-BOM.
Changed the encoding to pure UTF-8 and saved. Now the column names show.
Please check wit attached csv file.test (1)-Utf8