Jump to content

Tips and Tricks

This is where you can post items of interest that are not covered by other forum sections.

58 topics in this forum

    • 1 reply
    • 46 views
    • 0 replies
    • 77 views
    • 0 replies
    • 100 views
    • 4 replies
    • 1,079 views
    • 2 replies
    • 137 views
    • 4 replies
    • 398 views
  1. RJ45 to wifi

    • 17 replies
    • 612 views
  2. 4-20ma to digital input

    • 6 replies
    • 640 views
  3. Moteur PAP

    • 2 replies
    • 176 views
  4. modem connection

    • 4 replies
    • 1,764 views
    • 2 replies
    • 292 views
    • 4 replies
    • 819 views
    • 4 replies
    • 799 views
    • 0 replies
    • 718 views
    • 1 reply
    • 741 views
    • 1 reply
    • 948 views
    • 3 replies
    • 625 views
    • 1 reply
    • 463 views
    • 6 replies
    • 886 views
    • 1 reply
    • 1,544 views
  5. USB Boost Converter

    • 3 replies
    • 922 views
    • 5 replies
    • 1,312 views
    • 1 reply
    • 638 views
    • 1 reply
    • 987 views
    • 16 replies
    • 1,432 views
  • Member Statistics

    5,294
    Total Members
    501
    Most Online
    SRod
    Newest Member
    SRod
    Joined
  • Topics

  • Who's Online (See full list)

  • Posts

    • Hi every one. Just taken another look now I have a bit more time. The issue has not been resolved. I have checked and i have the latest software etc.   Steve
    • So, this was updated last month and worked ok for a while but today, Saturday, 18th, its back to displaying 6 as apposed to 7. This really needs to be fixed. Also, since the update I seem to be having ethernet issues dropping the modbus, don't know if this is related or a coincidence.   Any ideas?  Cheers, Steve.
    • Three questions related to tables in DataXport.  If I have the V570 in a testing device which has programs for each product I'm testing, and each of those programs saves a separate results table (Samples_P01, Samples_P02, Samples_P03, etc.): 1)  If I download a table from the PLC using DataXport, is there a way to flag it as having been received?  I don't want to download the same data again until all the results in the table have been updated with new results. 2)  How can I switch to another table (which is another product's results) without stopping, editing the site, selecting the table, unselecting the previous table, and running again?  The other option I found is to create multiple sites for the same PLC, each with a different table selected.  This still requires you to stop the call log, edit the current site to uncheck enable, edit the other site to check enable, then running again.  Just as much work. 3)  Is there a way to pull the table without using schedules?  I don't want the data to continuously pull every minute or hour, but rather only when the operator performed new tests.  Otherwise, I am getting the same data over and over in new CSV files.  I'd rather force a call when they need it and bypass schedules.
    • I've been doing this for many many years and can't remember the last time I needed floating point numbers in my program except for some crazy flowmeters that insisted on outputting their data via MODBUS as floating point. Insane, if you ask me. I guess if you have a situation where the number of significant figures in the decimal varies and is unknown at the time of programming then floating point is necessary. Other than that it's poor programming practice in my humble opinion.
    • In UniDDE, if you right click on your open project or use the menu buttons, you can copy the Read Command, Stop PLC Macro, Run PLC Macro, and Run/Stop Toggle macro.  If I have the read command in an Excel worksheet, it tries to start UniDDE.exe but fails.  Instead, I had to clear the field until the workbook is open then add the read command =UniDDE|Items!'lblDDE(1)' to the cell afterwards.  My second issue (the first being that I can't seem to get the UniDDE read command to automatically load the software) is that the PLC is not in Run mode.  Therefore, I try to use the code that UniDDE provides with those copy buttons.  If I use the "Run/Stop" toggle it will properly stop the PLC connection if it's already running.  If I execute that code to make it run, it will run but Excel freezes until I click escape.  I also tried the "Run PLC" macro, but it does absolutely nothing.   My VBA to start the UniDDE software is below.  Cell F1 = "C:\Program Files (x86)\Unitronics\Unitronics DDE Server\UniDDE.exe" Cell F2 = "UniDDE.exe" Cell F3 = "U:\Display Result and Write CSV.ude" Sub Load_UniDDE() Application.StatusBar = "loading PLC application" Dim strApp, strAppShort, strFile As String Dim WB As Workbook Set WB = ThisWorkbook strApp = WB.Worksheets(1).Range("F1").Value strAppShort = WB.Worksheets(1).Range("F2").Value strFile = WB.Worksheets(1).Range("F3").Value If strApp = "" Or strAppShort = "" Then Application.WindowState = xlMaximized WB.Worksheets(1).Range("F1").Select MsgBox "Please correct the software path and process in the Excel worksheet." Else If Dir(strFile) <> "" Then Dim objList As Object Set objList = GetObject("winmgmts:").ExecQuery("select * from win32_process where name='" & strAppShort & "'") ' determine if the DDE app is already running If objList.Count = 0 Then Shell strApp & " " & strFile, vbMinimizedFocus ' open the DDE app and project file End If Else Application.WindowState = xlMaximized WB.Worksheets(1).Range("F3").Select MsgBox "Please correct the project path in the Excel worksheet." End If End If Application.StatusBar = False End Sub UniDDE provides the following macros which are not working properly RUN PLC: Dim lchannelNumber As Long '/ Run PLC lchannelNumber = Application.DDEInitiate("UniDDE", "Items") Application.DDEExecute lchannelNumber, "Last Test Result_RUN" Application.DDETerminate lchannelNumber RUN/STOP Toggle: Dim lchannelNumber As Long '/ Run/stop UniDDE lchannelNumber = Application.DDEInitiate("UniDDE", "Items") Application.DDEExecute lchannelNumber, "UniDDE_RUN/STOP" Application.DDETerminate lchannelNumber  
  • Blog Entries

×
×
  • Create New...