Cap (Customer) asked a question.
This is my first attempt at reading out an Event Manager Data Base, and changing it in excel, and reading it back in.. It's not reading back in..
In the Excel read of the Data Base, there are 'Lines' that say do not Modify.. Well I'm Adding ~150 Alarms to the Data Base, so the lower line 'Do Not Modify' has to get pushed down about 150 Rows..
What is the trick to getting around this??.. My Excel File looks like I think it should.. The Last Do Not Modify line has three spaces, between the Last Event and it..
When I Import the Excel Modified DB, it comes back as done really soon, and my Org DB is in the Memory.. ?? It's like it did not take, and it did not give any errors either..
It Can't be that difficult.. What am I Missing..
Cap
I noticed a cute little box comes up when Exporting.. It Says " It is recommended to Export and Import Action Types individually"..
What the heak does that mean.. It MIGHT not work?..
I was leaving the Export as SIMPLE(ALARM).. So I re-selected it for Select, Alarm.. Rather than SIMPLE(ALARM)..
The EXCEL file is MUCH more Complicated.. Interleaved Rows.. Wow what a PAIN.. I was finally able to decipher the Coding of what goes where.. And I got (so far) 165 Alarm Events entered using the Re-Interleaving of the Excel Rows..
This is NUTS.. There needs to be a better 'Import/Export' file type..
Again, Am I missing something?..
Cap
First, the reason it is suggested exporting and importing Action types individually is because of how complicated the spreadsheet becomes with multiple actions types. It is much easier to make a mistake.
Seconds, if you have not already, see help files CM499 and CM504.
CM499 says:
Editing Exported Data
Care should be taken when editing the exported file. Many of the fields require a strict syntax for Time, Data, Embedded Data, File Names, etc. Fields such as these should be edited in the Event Manager Database to ensure proper syntax is applied and no errors occur when Importing.
Additional rows must be inserted ABOVE the existing row identified as End of Record
(DO NOT MODIFY THIS ROW). Do not copy and paste this row.
Use the MS Excel Insert command to create additional rows for new Events. Select the row ABOVE the row identified as End of Record (DO NOT MODIFY THIS ROW) to add rows as needed.
If your sheet got broken somehow where it does not know what the name range is. Follow this process.
In Excel: