jbotas

Members
  • Content Count

    16
  • Joined

  • Last visited

Community Reputation

0 Neutral

About jbotas

  • Rank
    Member
  1. jbotas

    Alarm New Features

    Possibility to put a TimeOffset in the alarms log timestamp.
  2. jbotas

    Alarm Log Timestamp

    I'm using version 5.91 build 2203. Another thing that i saw is that the value of the time in the databases is always caped to 6 decimal digits. ex: 1234.1234560000000 I made a script convert the time fired of one alarm with the to excel type (hours since.%day -> ex:1234.1234567890123456), caped to 6 decimal digits (1234.12345600000000), and then returned to epoch time (seconds since.milliseconds). The time now is only different in 1 to 3 milliseconds (probably because of 64 bit float scope versus the conversion made by the databases). Before i did this transformation it was 30 to 40 milliseconds different.
  3. jbotas

    Alarm New Features

    Possibility to chose the format of the Timestamp of the alarms in the Log. Some types The current (Hours since.%day) Epoch (seconds since. milliseconds) Text (YYYY-MM-DD HH:mm:ss.xxx)
  4. jbotas

    Alarm Log Timestamp

    I tested this with mysql and firebird. The problem exists in every Database with ODBC connection. The real problem is even if i hide the milliseconds, sometimes the alarms enter near the second. The logged second and the alarm time is in a different second.
  5. jbotas

    Alarm New Features

    - Possibility to delete multiple Alarms - Maybe delete all. We can export all alarms, edit in excel , delete all alarms, and import the ones we want
  6. jbotas

    Delete Multiple Alarms

    Is there a way to delete more than one alarm at a time? If i have to delete 30 Alarms i need to delete one by one, and every time the tree of alarms is refreshed. It takes a lot of time to delete.
  7. jbotas

    Alarm Log Timestamp

    Today i did some testing about this problem. I used a MDB (Acess) database and the problem with the milliseconds is present.
  8. jbotas

    Alarm Log Timestamp

    I don't have a problem with the 2 days offset. My problem is that the TimeStamp of the log is not equal to the time it fired in the milliseconds. If i have multiple alarms appear at the same time when i run "Alarm.CheckAlarms()" the Timefired is diferent in every alarm by 1 or 2 milliseconds. But in the log, all alarms have the same timestamp but with more 30 ~ 50 miliseconds. EX: In the Alarms ALM00.Timefired - 2015-02-13 12:00:00.100 ALM01.Timefired - 2015-02-13 12:00:00.102 ALM02.Timefired - 2015-02-13 12:00:00.103 ALM03.Timefired - 2015-02-13 12:00:00.105 In the Log ALM00.TheTime- 2015-02-15 12:00:00.147 ALM01.TheTime- 2015-02-15 12:00:00.147 ALM02.TheTime- 2015-02-15 12:00:00.147 ALM03.TheTime- 2015-02-15 12:00:00.147 The two days diference is not a problem with me. As i said i can remove this 2 days shift when i process the data. But the Millisencods part is not correct with what the alarms say. For me the time in the log must be the same as the one that appears in the alarms.
  9. jbotas

    Alarm Log Timestamp

    I have a few alarms logging to a SQL DATABASE. The timestamps of the log is not equal to the timestamps of the alarms, always 2 days and 30 ~70 milliseconds more. The 2 days is about the initial time reference, so no problem here, i just subtract 2 days. But the 30 ~ 70 milliseconds i don't know why the difference. If i change the log type to a file the time stamp is the same as the alarms, even the milliseconds.
  10. I think if you have the possibility to import and export with this work around, is always better than not having it. With this I can edit the scripts by copy paste in excel. And if i want, i can use the excel formulas or macros to create a table with the alarms or channels with the correct format, and then copy everything to a file and import to daqfactory. I already do this with other programs where i have a database in excel for channels and alarms, and then by macros i export the configuration to files and then import. As i said it would be really good to also have this in the import and export of alarms.
  11. Thanks for the answer. In a project that I made a years ago i needed to do something like this. What i did is to change the "Carriage Return" to a new pattern "%NL%". So that when i exported the text HELLO WORLD it will appear HELLO%NL%WORLD In import i would do the reverse operation. In this case because we want to edit the pattern could be more simple, and a pattern that in not permitted in script, like for example "_%". Its a work around but works. Other suggestion is to use a different format for the file exported, that you can chose in export/import dialog, that can be edited in excel.
  12. I have a few requests about new features in alarms - Import and export od alarms with the events scripts - Assign groups to the alarms as in the channels - Possibility to copy a alarm o a variable and be ablo to acess the properties Ex: private Alm = execute("Alarm."+Almname) private AlmFired = Alm.Fired - A function to list alarms as an array with the properties acessible Ex: private AlmList = Alarm.List() private iter = 0 while(iter < NumRows(AlmList)) if(AlmList[iter].Fired) //code here endif iter++ endwhile
  13. I have a request about Channels - Import and export of Channels with the event script.
  14. jbotas

    Copy Alarm To Variable

    In my opinion by event is not a good solution. We can't import and export alarms with the events. So if i have 100 alarms i have to copy the code of the 3 events in every alarm. To much work and prone to human error. And if later i create another alarm i can forget about the events and the alarm won't go in the table. I'll post in the new Features Request about this functions.
  15. jbotas

    Copy Alarm To Variable

    I'm trying to do a script that list alarms and creates a table with the active alarms. The problem is that the listall function only return the names as strings. I need to do a lot of "executes" to check for example if the alarms are fired. This is really slow and the script takes alot of time to check all the alarms. If i have about 150 alarms and 50 of them fires it takes 2 to 3 seconds to run the script I tried but I can't copy an alarm to a variable like this private Alm = execute("Alarm."+Almname) private AlmFired = Almname.Fired Is there a way to acess the database of alarms without using the execute? Maybe a list function that returns the alarms but with the parameters and variables acessed in a "while" or "for" ex: private AlmList = Alarm.List() private iter = 0 while(iter < NumRows(AlmList)) if(AlmList[iter].Fired) //code here endif iter++ endwhile As attachment i'll put my teste project. The script is ALARM_DISPLAY_MANAGER and the display of the alarms is in page ALARMES and TEMPLATE_BANNER Testes.ctl