Importing Large Number of Element Names & Descriptions

[allenrogers]

I have an XCEL spreadsheet with tag names and descriptions for about 3200 V-Memory and C-coil.  Is there an easy way to import this information into the project documentation files?  It is not obvious (to me)if there is.

Thanks,

[franji1]

Use the File->Import->Element Documentation dialog.  It expects one "element" per line, comma separated as follows:
PLC Element, NickName, WiringInfo, Description

So

X0, Pump 1, C4Red1, Momentary switch that starts Pump 1

Line up your columns as above then save as a .CSV file (comma separated variable).  If any data contains a comma, you'll need to include double quotes around it.  Excel may have an option when saving as CSV to put double quotes around everything

DirectSOFT can handle the above line as
"X0","Pump 1","C4Red1","Momentary switch that starts Pump 1"

If you are missing any pieces, just leave it blank or terminate the line.

For example, if you just had the nickname for X0,
X0,Pump 1
would work fine

If you just had the description for X0,
X0,,,Momentary switch that starts Pump 1
would work for that

You'll get detailed error info if there are any issues with the text being imported (e.g. duplicate nickname, invalid PLC element).