ControlLogix 5k error mesaage when importing tags

--------------------------------------------------------------------------------

Anyone experience importing tags from excel CSV after editing the CSV file in excel and then try re-importing them back into Contrologix? I get the following error message...I also printed the excel top 6 lines as well...(see below)



Importing from G:\13-Tags.CSV...
Options: Create Tags=Yes, Overwrite/Discard Tags=Overwrite

Import New Comments=Yes, Overwrite/Discard Comments=Overwrite, Match by Rung Number=No

Error: Line 6: The CSV Schema line or Record line is invalid

Error: Line 6: Syntax error found while scanning import file.

Totals:

0 tag(s) created

0 tag(s) overwritten on collision

0 description(s) imported

0 new comment(s) imported

0 comment(s) overwritten on collision

Complete - 2 error(s), 0 warning(s)

Excel top 6 lines:








remark CSV-Import-Export



remark Date = Tue Mar 08 16:20:18 2005


remark Version = RSLogix 5000 v13.03


remark Owner = xxxxx


remark Company = xxxxx


0.2

Thanks!

I have run across this exact error before as well. Excel changes the CSV - it is still stored in CSV format, but there are added characters that RS5000 does not like. I am not sure what characters they are, or where in the file they are, but it is a very repeatable problem. I have had much better luck modifying the CSV with a text editor like notepad or wordpad.