Host Engineering Forum

General Category => DirectSOFT => Topic started by: allenrogers on August 08, 2007, 01:51:51 PM

Title: Importing Large Number of Element Names & Descriptions
Post by: allenrogers on August 08, 2007, 01:51:51 PM

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,

Title: Re: Importing Large Number of Element Names & Descriptions
Post by: franji1 on August 08, 2007, 04:33:19 PM

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).