24fretslater
Member
Hello there! I believe this is my first thread on here so bare with me.
I'm using a CompactLogix L35E with a Panelview 1250+.
As I opened the Alarm Setup I realized there are over 200 alarms that I need to add and trigger. I've always just clicked till my fingers and eyes screamed of tedium; and that was with less than half of the alarms I have this time!
I found the alarm import/export wizard by right clicking the Alarm Setup. Grinning, i adventurously delved into the unfamiliar (to me) world of XML.
I exported the alarms to an XML File and then exported it to an excel file where I then modified and added alarms by referencing an old project that I'd exported in the same way.
Satisfied and with all my alarms in place, I tried to export back to XML. Optimism in my pocket I hoped for the best.
BAM. That horrid error tone that Microsoft has so well tuned to make you cringe, filled my distraught ears...
"Cannot save or export XML data. The XML maps in this workbook are not exportable"
I've tried everything that help files have attempted to show me, but i fear my lack of XML knowledge and time has kicked my a$$.
So i come for help, to ask the elite! HELP!!!
How can I efficiently import my alarms? If I need to import this XML file, how do i make it so?
I read some things about denormalized data and mapping to a single cell. How doo I do this!? I appreciate any response, sorry for the novel. Thanks.
I'm using a CompactLogix L35E with a Panelview 1250+.
As I opened the Alarm Setup I realized there are over 200 alarms that I need to add and trigger. I've always just clicked till my fingers and eyes screamed of tedium; and that was with less than half of the alarms I have this time!
I found the alarm import/export wizard by right clicking the Alarm Setup. Grinning, i adventurously delved into the unfamiliar (to me) world of XML.
I exported the alarms to an XML File and then exported it to an excel file where I then modified and added alarms by referencing an old project that I'd exported in the same way.
Satisfied and with all my alarms in place, I tried to export back to XML. Optimism in my pocket I hoped for the best.
BAM. That horrid error tone that Microsoft has so well tuned to make you cringe, filled my distraught ears...
"Cannot save or export XML data. The XML maps in this workbook are not exportable"
I've tried everything that help files have attempted to show me, but i fear my lack of XML knowledge and time has kicked my a$$.
So i come for help, to ask the elite! HELP!!!
How can I efficiently import my alarms? If I need to import this XML file, how do i make it so?
I read some things about denormalized data and mapping to a single cell. How doo I do this!? I appreciate any response, sorry for the novel. Thanks.