# How to add alarms from a file into Alarm System? \[SOLVED\]

**URL:** <https://forum.inductiveautomation.com/t/how-to-add-alarms-from-a-file-into-alarm-system-solved/33838>\
**Category:** General Discussion\
**Tags:** ignition79, ignition80\
**Created:** [April 10, 2020, 6:51am UTC](https://forum.inductiveautomation.com/t/how-to-add-alarms-from-a-file-into-alarm-system-solved/33838 "2020-04-10T06:51:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gomez](https://avatars.discourse-cdn.com/v4/letter/g/d78d45/32.png) [@Gomez](https://forum.inductiveautomation.com/u/Gomez)\
**Post date:** [April 10, 2020, 6:51am UTC](https://forum.inductiveautomation.com/t/how-to-add-alarms-from-a-file-into-alarm-system-solved/33838/1 "2020-04-10T06:51:14Z")

</div>

Hi,  
is there any way to add alarm from an external source (text file), to Ignition alarm system? I.e. like system.tag.storeTagHistory() but for external alarm event?  
Thank!

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 10, 2020, 4:21pm UTC](https://forum.inductiveautomation.com/t/how-to-add-alarms-from-a-file-into-alarm-system-solved/33838/2 "2020-04-10T16:21:57Z")

</div>

You can manually insert records into the alarm journal - it’s just two database tables. There’s no equivalent function because external alarm history is a lot less common than external tag history.

---

<div class="post-metadata">

**Author:** ![Gomez](https://avatars.discourse-cdn.com/v4/letter/g/d78d45/32.png) [@Gomez](https://forum.inductiveautomation.com/u/Gomez)\
**Post date:** [April 14, 2020, 7:31am UTC](https://forum.inductiveautomation.com/t/how-to-add-alarms-from-a-file-into-alarm-system-solved/33838/3 "2020-04-14T07:31:26Z")

</div>

Thank you @paul-griffith.  
Adding a row in “alarm\_events”, autogenerate the “id” field. What about the “eventid”? It can be left empty but I suppose the “focus” function in Alarm Journal i.e. will not work. How can I can generate one without conflicting with the Ignition generated ones?  
Is preferrable add the external file alarms to the tables with Ignition scripting or can I use an external program ( or DeadLock problem can rise up )?  
Thanks!

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 14, 2020, 3:00pm UTC](https://forum.inductiveautomation.com/t/how-to-add-alarms-from-a-file-into-alarm-system-solved/33838/4 "2020-04-14T15:00:05Z")

</div>

Any SQL insert will work. The IDs are UUIDs - specifically v4, meaning they’re random. Different DBs have different built-in support for generating them, but because it’s a 128 bit value collisions are _extremely_ unlikely - apparently, you’re mathematically expected to hit a collision around the 2.7 _quintillion_ record mark: [https://en.wikipedia.org/wiki/Universally\_unique\_identifier#Collisions](https://en.wikipedia.org/wiki/Universally_unique_identifier#Collisions)

---

<div class="post-metadata">

**Author:** ![Gomez](https://avatars.discourse-cdn.com/v4/letter/g/d78d45/32.png) [@Gomez](https://forum.inductiveautomation.com/u/Gomez)\
**Post date:** [April 16, 2020, 4:42am UTC](https://forum.inductiveautomation.com/t/how-to-add-alarms-from-a-file-into-alarm-system-solved/33838/5 "2020-04-16T04:42:50Z")

</div>

Great! Thank you @paul-griffith
