Joseph

Forum Replies Created

  • In reply to: ShortCuts not working

    17 March 2020 at 4:15 pm #35916
    Joseph
    Participant

    Hi Praveenraj.k ,
    I’m using the same Movicon version , shortcuts working fine in my project.

    Are you sure you give the correct name to the resource you created?
    Try to rename the shortcut with the same name as a synoptic of your project, and try the command that you defined in that screen.

    Refer here the help with the “Shortcut Activation in Runtime” , what I mean above is explained in the manual at this link:

    http://www.movicon.info/HelpNExT3.4/269/en-US/PlatformNext.htm#t=mergedProjects%2FMoviconNext%2FMenu_and_Shortcuts%2FAttivazione_di_un_Acceleratore_in_Runtime.htm

    Regards
    Joseph

    • This reply was modified 1 week, 4 days ago by Joseph.
  • In reply to: How get the number of row in Data logger Windows

    29 January 2020 at 10:00 am #35478
    Joseph
    Participant

    Hi Jeff,
    In these cases I usually use the grid object instead of the DL Windows because it is more flexible.
    It has this function embedded in the script interface.

    GetRowCount, GridWndCmdTarget Function

    Description
    This function get the number of rows loaded into the grid object. The number of rows correspond to the number of records retrieved by the selection query when connected to a database, or the number of rows existing in a linked text file.

    E.g.

    ***
    Dim objGrid As GridWndCmdTarget
    Public Sub Click()
    objGrid.Query = “SELECT * FROM DataLogger00001 WHERE VAR00001 >= 5”
    objGrid.Refresh
    End Sub

    Public Sub SymbolLoading()
    Set objGrid = GetSynopticObject.GetSubObject(“Grid1”).GetObjectInterface
    End Sub

    ***
    ‘Button environment

    Dim objGrid As GridWndCmdTarget

    Public Sub Click()
    Debug.Print objGrid.GetRowCount
    End Sub

    Public Sub SymbolLoading()
    Set objGrid = GetSynopticObject.GetSubObject(“Grid1”).GetObjectInterface
    End Sub

    Best Regards
    Joseph

  • In reply to: Archiving Project

    8 January 2020 at 9:59 am #35315
    Joseph
    Participant

    Hi there!

    Very good!

    BR
    Joseph

  • In reply to: Alarms TimeStamps Redundancy

    8 January 2020 at 9:53 am #35313
    Joseph
    Participant

    Hi Costafi,
    I think the last message is a spam 🙂
    By reading your post, i think this behaviour is by design ; it is always the active server that defines the time stamp of an alarm event when it reads the value of the variable received from the field.
    The alarm manager is only active on the active server.
    In case the primary server has a serious problem and the secondary server intervenes, it will define the new alarm timestamp by reading the values from the field. This seems correct from me.
    Obviously all these alarm events are stored in the DB so you can make your analisis in these case starting from the DB not from the real time alarms.

    There is an option that you could evaluate…..in the alarm threshold properties :

    Use Variable TimeStamp

    When this property is enabled the alarm ON and OFF times will include a TimeStamp (date and time of last modification executed) of the variable that generated it. The Variable’s TimStamp is set from the communication driver and the OPC management.

    In additon to this and as usual the event in question will be recorded in the Historical Log with the TimeStamp of the variable that generated it.

    This function could be handy in situations where the variable’s value is notified to Movicon with a delay time in respect to its effective variation. For instance, in a OPC communication, the Server may happen to be in Client refresh mode for a few seconds. In this case the variable TimeStamp will nevertheless be received by the Server indicating the actual time in which the variable effectively changed in the Server.

    The “Use Variable TimeStamp” can be also read and modified in runtime using the “DateTimeFromTimeStamp” property from the “AlarmThresholdCmdTarget”.

    Best Regards
    Joseph

    • This reply was modified 2 months, 3 weeks ago by Joseph.
  • Joseph
    Participant

    Hi Jeff,
    Quite difficult to give a generic response at your questions, should go into details.
    On line you will find several information about MYSQL restrictions.

    Best Regards
    Joseph

  • In reply to: What is the DSN for Mysql database?

    8 January 2020 at 9:38 am #35311
    Joseph
    Participant

    Hi Jeff,
    If you had created and tested externally in the ODBC Data Source Administrator (32 bit) tool an ODBC channel that point your DB you have simply to use it in the Movicon 11 project resources that are interfacing the DB.
    So basically you have to put the same name of this ODBC in the Historical Log settings > ODBC Manager > ODBC DSN property
    You have to define a Movicon user with the same name and password of your MYSQL user and use it in the Historical Log settings > ODBC Manager > ODBC DSN User, so to grant the correct rights for the Movicon application to access your MYSQL instance.

    Must repeate the same settings in all the various resources like Data Loggers, Recipes…if present, that are interfacing the DB , same ODBC DSN, same ODBC DSN User.

    Kind Regards
    Joseph

  • In reply to: Child Project & Database

    3 January 2020 at 11:39 am #35278
    Joseph
    Participant

    Hi Knecjj,
    I’m guessing you’re using an SQL DB for this application and with this architecture…an MS Access database for example is not suitable for this purpose.
    If you use SQL DB as I believe, you have to create a custom ODBC that from the client PC can access the DB on the Server.

    Best Regards
    Joseph

  • Joseph
    Participant

    Hi Jeff,
    Please note that the examples available on the Progea Web Site often refer to an SQL DB and not to a MYSQL DB.
    The query syntax may be different!
    My suggestion is to use if possible SQL DB …

    Best Regards
    Joseph

  • In reply to: How to send variable string to report preview parameter

    3 January 2020 at 11:31 am #35276
    Joseph
    Participant

    Hi Jeff,
    Yes sure it’s possible.

    You can study and check the example “ES_ReportDesignerParameters” available on this web site.

    This example shows you how to open a report created with the Report Designer from basic script code in order to pass it some parameters.

    It’s a very good starting point!

    Best Regards
    Joseph

  • In reply to: What is the DSN for Mysql database?

    3 January 2020 at 11:28 am #35275
    Joseph
    Participant

    Hi Jeff
    In the ReportViewerNet.exe the DSN is the name of the ODBC connection to be used for connection to the database (i.e. TestProject_HisLog). If not specified, the connection set by the Report Designer when the report is first created is used (in this case it can no more be accessed or modified)…

    Have you created, externally of Movicon, in the ODBC Data Source Manager (32bit) an ODBC link that points this MySQL data base?

    Recently i did a small application with Movicon 11.6.1202 & MySQL Server 8.0.18 & Connector/ODBC 8.0.18 (x86)..i used this ODBC directly in the Movicon dataloggers so i was able to write data from Movicon. Then a standard report command was using directly the datalogger’s ODBC.

    BR
    Joseph

  • Joseph
    Participant

    Hi Praveenraj,
    If your data are not linked with the datalogger resource you could use simply the real time trend object.
    You can set the property > Trend Style > Runtime Mode “Only Run” & add the variable in the Add Pen…

    Take a look at the preinstalled example available in

    C:\Users\Public\Documents\Progea\Movicon.NExT\ExampleProjects 3.4\Trends

    BR
    Joseph

  • In reply to: Read/Write String from PLC

    13 December 2019 at 2:16 pm #35201
    Joseph
    Participant

    Good to hear from you that it works

    BR
    Jo

  • In reply to: Archiving Project

    13 December 2019 at 2:15 pm #35200
    Joseph
    Participant

    Hi

    I normally flag the properties “Save Backup” & “Increase Project Build Number” under the project general settings to get an automatic backup of my applications.

    Here below I paste the information from the help on line.

    Save Backup

    When this property is enabled a “Project Backup” file will be created every time the project is saved.

    Increase Project Build Number

    By enabling this property the project build will be increased each time the project is saved. Otherwise, if not enabled, the build will always remain the same and the Backup file, created after each save, will always have the same name and overwrite the previous one. For further information on ‘Project Backup Files’ please refer to “Project Files”.

    BR
    Joseph

  • In reply to: HMI screen event how to set tag at opening

    13 December 2019 at 2:10 pm #35199
    Joseph
    Participant

    Hi
    Very Good ! I’m glad that you solved this issue

    BR

  • In reply to: Add pen to DataAnalisysRTControl from script

    6 December 2019 at 12:15 pm #35099
    Joseph
    Participant

    Hello Giocamo,
    Normally I don’t use the script, you can manage it directly from the runtime editor offered by the object…

    https://screencast-o-matic.com/watch/cbiYX7lt3b

    I find this method very useful.

    BR
    Jose