Messages

1

Open Discussion / Re: Advanced HMI on Linux?

« on: November 25, 2024, 05:10:23 PM »

Here's a post that starts with here's, just to try to see what we are talking about.  Do I win?

It was'nt.

There's it goes.

Ok. You won but not the turkey! it was only for Godra,

LOL! It might be, but I


Not exactly!, Did you see the above, it got cutoff again

LOL! It might be, but I

2

Open Discussion / Re: Advanced HMI on Linux?

« on: November 25, 2024, 04:11:56 PM »

LOL! It might be, but I will bet a 15-pound turkey that it was not. Why not try it out yourself? Try posting it starting a sentence with something like "Here is" and "There is," or "I will" or "It is"  or "was not" but using the apostrophes.

3

Open Discussion / Re: Advanced HMI on Linux?

« on: November 25, 2024, 10:31:59 AM »

Running Advanced HMI on Linux might be tricky since it

Here is another example of an issue with posting. The post was incomplete and got cut off.

4

Additional Components / Re: TCP Client Socket

« on: November 16, 2024, 04:01:03 PM »

This version replaces TerminatingByteValue with TerminatingCharacters, enabling it to check for 0, 1, or multiple terminating characters.

5

Support Questions / Re: Issue with the GenericTCPClient in the AdvancedHMI v3.99y Beta40 version.

« on: November 14, 2024, 07:57:09 PM »

My next issue is that I'm unable to send data from the server to the client.
The error occurs at line 452.

Code: [Select]

If m_ParsedTerminators = ReceivedPacketString.Substring(ReceivedPacketString.Length - m_ParsedTerminators.Length - 1, m_ParsedTerminators.Length) Then
At that point, the length of ReceivedPacketString is 0, which is expected since it's at the beginning of the call.

6

Support Questions / Re: Issue with the GenericTCPClient in the AdvancedHMI v3.99y Beta40 version.

« on: November 14, 2024, 05:53:49 PM »

I resolved the issue by uncommenting part of line 305.
However, I still do not fully understand the purpose of GTCDLL(MyDLLInstance).

       

Code: [Select]

If GTCDLL(MyDLLInstance) Is Nothing OrElse Not GTCDLL(MyDLLInstance).Connected Then

7

Support Questions / Issue with the GenericTCPClient in the AdvancedHMI v3.99y Beta40 version.

« on: November 14, 2024, 04:35:08 PM »

I am experiencing an issue with the GenericTCPClient in the AdvancedHMI v3.99y Beta40 version. The client is capable of sending data to a server (using the Hercules TCP server), but it only works when connected on the default port (23). When I attempt to change the port to any other value, the connection fails. However, if I manually modify the port within the GenericTCPClient.vb code file, it works as expected.

P.S There is still an issue with posting. I have to change the first sentence to use "I am" instead of "I'm" to avoid problems.

8

Additional Components / Re: TCP Client Socket

« on: November 13, 2024, 08:10:33 PM »

I tested the GenericTCPClient.zip file shared by Archie and verified its functionality in both directions using Hercules.

Configuration: Set to localhost 127.0.0.1, Port=7001
TerminatingByteValue (not TerminatingCharacters) is set to 10 (LF).

Client to Server Communication:
The client sent "1234" & <CR> using TCPClient.SendString(TxtSend.Text & vbCr).
Observed that a <LF> was automatically appended at the end.

Server to Client Communication:
The server sent "test from server$0D$0A", and the client successfully received it, stripping the <LF> terminating character. The <CR> is in the data , but not display in the text box.

9

Open Discussion / Re: Control Logix array to Excel in 2024

« on: November 12, 2024, 12:07:56 PM »

https://www.youtube.com/watch?v=p98PjtSfNWo 

10

Open Discussion / Re: Control Logix array to Excel in 2024

« on: November 12, 2024, 10:45:11 AM »

First of all, I appreciate the effort, but I noticed that my name was spelled incorrectly. While it may have been a mistake the first time, it was intentional the second time. So, thank you for that effort.

Secondly, what I provided was more than just a "tutoring me a little." I essentially shared the entire code with you.

11

Open Discussion / Re: Control Logix array to Excel in 2024

« on: November 09, 2024, 08:46:18 AM »

Drag a 'button' from the Toolbox and drop it on the form, then double click to get to the default click event, then insert the code :

Code: [Select]

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

    Dim FloatData() As String = EthernetIPforCLXCom1.Read("Historygram1[0]", 400)
End Sub

12

Open Discussion / Re: Control Logix array to Excel in 2024

« on: November 08, 2024, 03:48:25 PM »

As Archie mentioned, EPPlus now requires a commercial license for business use.
However, for non-commercial purposes, you can still add it to your project via NuGet.
There is also a free version called EPPlusFree, a continuation of the original 4.5.3.3 version.
I prefer EPPlus over alternatives like ClosedXML because it only adds a single DLL file, while ClosedXML includes multiple files.

Code: [Select]

   Using package As New ExcelPackage(New FileInfo(filePath))
       ' Get the count of existing sheets
       Dim sheetCount As Integer = package.Workbook.Worksheets.Count
       ' Add a new worksheet with a unique name
       Dim newSheetName As String = "SheetNum" & (sheetCount + 1).ToString()
       Dim newSheet As ExcelWorksheet = package.Workbook.Worksheets.Add(newSheetName)

       ' Populate the new worksheet with data contains TagName, TagValue
       For i As Integer = 0 To Data.GetLength(0) - 1
           For j As Integer = 0 To Data.GetLength(1) - 1
               newSheet.Cells(i + 1, j + 1).Value = Data(i, j)
           Next
       Next

       ' Optional: Add some styling to the new sheet
       Using range As ExcelRange = newSheet.Cells("A1:B1")
           range.Style.Font.Bold = True
       End Using
       newSheet.Cells.AutoFitColumns()

       ' Save the workbook back to the file
       package.Save()
   End Using

13

Open Discussion / Posting Issue

« on: November 08, 2024, 03:42:45 PM »

Recently, I've noticed that my posts sometimes only display 1 or 2 lines instead of the full content. Has anyone else experienced this issue?

Code: [Select]

As Archie mentioned, EPPlus now requires a commercial license for business use.
However, for non-commercial purposes, you can still add it to your project via NuGet.
There

As Archie mentioned, EPPlus now requires a commercial license for business use.
However, for non-commercial purposes, you can still add it to your project via NuGet.
There is also a free version called EPPlusFree, a continuation of the original 4.5.3.3 version.
I prefer EPPlus over alternatives like ClosedXML because it only adds a single DLL file, while ClosedXML includes multiple files.

I think I found the problem.   It stopped at "There's". I changed to "There is"

14

Open Discussion / Re: Control Logix array to Excel in 2024

« on: November 08, 2024, 02:44:17 PM »

Your code works correctly with ClosedXMLTest2.zip. But it will not work with the downloaded AdvancedHMIv399yBeta40.zip. Not sure why?

15

Open Discussion / Re: Control Logix array to Excel in 2024

« on: November 08, 2024, 01:38:21 PM »

change the code to:

WB.Worksheet("Sheet1").Cell("A2").Value = "New Value"