Unable to import tags csv file in ignition 8.1.38

Ignition
1

Hi

I have tried importing csv files having tag info but ignition keep showing below error

Tag errors occurred during tag import Error_Exception("Error importing tags: Unknown CSV Format")

tried uploading the core test file as well but same issue. IS there something changed in newer versions, can inductive please provide the correct csv format and guideline, the link available have been tried as well but no luck

Already tried below link and same error

2

The link you share is for exporting and importing datasets in you application, not for exporting/importing tags.

I think exporting tags as csv is not possible anymore, so I can imagine that importing tags as csv is kind of a depricated feature. I would always try to use json files for export/import.

3

@Muhammad_Awais Is this your first time importing a csv file or have you done it before? What is your tag format in the .csv file?

Also, consider checking out the following link and scroll to "Tag File Formats": Exporting and Importing Tags

5

well i mistakenly put a scripting link which now i replaced by the tag import export article. I think import should work as its mentioned in the updated article

6

this format mentioned in the link doesn't work that is why raising here for inductive experts, even the core test csv provided by inductive doesn't upload. you can check yourself in your ignition environment

7

CSV is very limited in what you can setup for import of tags.
XML is much simpler to use and manage creating tag lists for import outside of ignition.
Below example contains a UDT instance, a memory tag, and an OPC Tag.

<Tags MinVersion="8.0.0" locale="en_US">
   <Tag name="Test" type="UdtInstance">
      <Property name="typeId">AlmCond</Property>
      <Tags>
         <Tag name="AlmTag" type="AtomicTag">
            <CompoundProperty name="alarms">
               <PropertySet>
                  <Property name="mode">10</Property>
                  <Property name="name">Alarm</Property>
                  <Property name="activeCondition" bindtype="Expression">(({[.]Condition1}=1)&amp;&amp;({[.]Condition2}=1))</Property>
               </PropertySet>
            </CompoundProperty>
         </Tag>
         <Tag name="Condition1" type="AtomicTag">
            <Property name="value">0</Property>
         </Tag>
         <Tag name="Condition2" type="AtomicTag">
            <Property name="value">1</Property>
         </Tag>
      </Tags>
   </Tag>
   <Tag name="Bool1" type="AtomicTag">
      <Property name="valueSource">memory</Property>
      <Property name="dataType">6</Property>
      <Property name="value">true</Property>
   </Tag>
   <Tag name="TestOPCtag" type="AtomicTag">
      <Property name="valueSource">opc</Property>
      <Property name="opcItemPath">ns=1;s=[PLCName]Array1[0].ArrayNumValue</Property>
      <Property name="dataType">2</Property>
      <Property name="opcServer">Ignition OPC-UA Server</Property>
   </Tag>   
</Tags>
8

i know about xml and json it works flawlessly but i need to configure and add 400,000 tags and have multiple plants,

with csv i can convert to excel, copy from plc tag files and other data files, and convert back to csv and upload

How to do that with xml and json? i am not much experienced on this

9

You can code using VBA in excel to write it out to a text file (xml)
Just a matter of grabbing the cell values and plug them into the xml file.

The below VBA code is an example you could modify.

Private Sub CommandButton1_Click()
Dim fso As Object
Set fso = CreateObject("Scripting.FileSystemObject")
Dim oFile As Object
Dim Rng As Range, cel As Range, sht As Sheet1
Set oFile = fso.CreateTextFile("c:\data\XMLImport.xml")
oFile.writeline "<Tags>"
Set Rng = Sheets("Sheet1").Range("A2:A1000")
For Each cel In Rng
    oFile.writeline Chr(9) + "<tag name=""" & cel.Value & """ path="""" type=""OPC"">"
    oFile.writeline Chr(9) + Chr(9) + "<Property name=""Value""></Property>"
    oFile.writeline Chr(9) + Chr(9) + "<Property name=""DataType"">" & cel.Offset(0, 6).Value & "</Property>"
    oFile.writeline Chr(9) + Chr(9) + "<Property name=""OPCServer"">" & cel.Offset(0, 16).Value & "</Property>"
    oFile.writeline Chr(9) + Chr(9) + "<Property name=""OPCItemPath"">ns=1;s=" & cel.Offset(0, 1).Value & "." & cel.Offset(0, 3).Value & "</Property>"
    oFile.writeline Chr(9) + Chr(9) + "<Property name=""ScanClass"">Default</Property>"
    oFile.writeline Chr(9) + "</tag>"
Next cel
oFile.writeline "</Tags>"
oFile.Close
End Sub
10

No, csv is by far the easiest way to create and import tags in most systems (just not Ignition). Anything else is a pain unless you are using something to make it easier.