Go Down

Topic: PLX-DAQ version 2 - now with 64 bit support! (and further new features) (Read 18735 times) previous topic - next topic

NetDevil

Hi, I have a problem with the v2.11, I have Windows 10, Excel 2016, when I clic Connect, after a while Excel stops and close.
Hi Alejandro,

could you give me a bit more detail? Are you already sending data from your Arduino to PLX DAQ? Is incoming data shown in the DirectDebug window? Is data being posted to Excel sheet already? And (maybe most important) what baud rate are you using?

simon_126

Hi Simon,

what links aren't working exactly? The one's to the image is working correctly ( http://www.freebie-base.de/Pics/PLX_DAQ_v2.11.png ) as does the link to the "promising example".

Do you mean the underlined words and sentences in the text? Those are no links but just highlighted text to better show the most significant changes in the new version.

Explainations to the new features can most likely be found in the Beginners Guide (see Post here for most recent version in the attachments)

Greetings
I have tried many times to download PLX DAQ v2.11, 16 to be correct. Right at the end, it says file corrupted, couldn't be downloaded and etc. I really need that scroll down function and much more that you implemented to the original one. Please if that is possible reupload install files or upload them on another server. For the time you are the only distributor of it.

NetDevil

I have tried many times to download PLX DAQ v2.11, 16 to be correct. Right at the end, it says file corrupted, couldn't be downloaded and etc. I really need that scroll down function and much more that you implemented to the original one. Please if that is possible reupload install files or upload them on another server. For the time you are the only distributor of it.
Hi Simon,

the download is working fine for me, same for unpacking the zip file.
Nevertheless I uploaded the latest version here as well => http://freebie-base.de/Stuff/PLX-DAQ-v2.11.zip <=
Please post feedback whether it is working or not.
Thanks.

el_supremo

Don't send me technical questions via Private Message.

simon_126

First of all, problem regarding link was my mistake at the office Kerio Control was ignoring download. When I tried download PLX from URLs everything was just perfect.
But second problem may be I am doing wrong can't get cell info from excel.

  Serial.println("CELL,GET,B3,");
cell_num=Serial.read();// this command reads the sell value from the specified cell

//now return this namber to EXCELL:
Serial.print("DATA,TIME,");
Serial.print(bla);
bla=random(1,100);
Serial.print(",");
Serial.print(cell_num);
Serial.print(",");

But in excel instead og providing info from B3 cell it just prints in consequent columns GET CELL B3

What I am doing wrong. Really need your help

dummy55555

Hi guys, I need a little help here. I tried the default sketch given and together with the latest PLX-DAQ version 2.11. I noticed that the AUTOSCROLL is not functioning. The excel does not scroll automatically when new data received. I am using Office Excel 2007. Can anyone guide me? Thanks

NetDevil

But second problem may be I am doing wrong can't get cell info from excel.

Code: [Select]

Serial.println("CELL,GET,B3,");
cell_num=Serial.read();// this command reads the sell value from the specified cell

//now return this namber to EXCELL:
Serial.print("DATA,TIME,");
Serial.print(bla);
bla=random(1,100);
Serial.print(",");
Serial.print(cell_num);
Serial.print(",");

But in excel instead og providing info from B3 cell it just prints in consequent columns GET CELL B3
Hi Simon,

your code needs some rework.
First of all, make sure to end your commands to PLX DAQ with "println" instead of "print". Plus there is no need to add a final "," at the end of the statement.
And you use the variable "bla" before assigning a random value to it, better to switch it around ;-)

My rework suggestion is:

Code: [Select]

Serial.println("CELL,GET,B3"); // <= remove ","
cell_num= Serial.readStringUntil(10).toInt(); // <= new read function


Serial.print("DATA,TIME,");
bla=random(1,100); // <= switched command
Serial.print(bla); // <= switched command
Serial.print(",");
Serial.println(cell_num); // <= changed to "println"
//Serial.print(","); <<== ignore

NetDevil

Hi guys, I need a little help here. I tried the default sketch given and together with the latest PLX-DAQ version 2.11. I noticed that the AUTOSCROLL is not functioning. The excel does not scroll automatically when new data received. I am using Office Excel 2007. Can anyone guide me? Thanks
Hi dummy,

sorry to say but the scroll function was added in Office 2013. Therefore no scrolling is possible in your version 2007...

I googled the issue and there was a dirty workaround in earlier versions of Excel. If you are familiar with Excel / VBA please try pressing Alt+F11 to open the code editor, search for the AUTOSCROLL part and replace with the following:

Code: [Select]

'## Check for AUTOSCROLL command and handle
If (InStr(1, UCase(DataVal(x)), "AUTOSCROLL_", vbBinaryCompare) >= 1) Then
    DontPostDataThisIteration = True ' Autoscroll will not be posted to sheet
    If (ActiveSheet.Name = WStoUse.Name) Then
        '## Autoscroll command checks should only be done if the currently active sheet is the sheet where data is pasted to
        '## Autoscroll command was added in Office 2013 (version 15.0) - dont use for earlier versions)
        Dim offset As String
        offset = Trim(Mid(DataVal(x), InStr(1, DataVal(x), "AUTOSCROLL_", vbBinaryCompare) + Len("AUTOSCROLL_"))) 'get value right side of "AUTOSCROLL_"
        If (IsNumeric(offset)) Then
            If ((row - offset) >= 1 And (row - offset) <= ActiveSheet.Rows.Count) Then 'if row - offset is too low (< 0) or too high ( > max row possible) set to row
                Application.Goto Range("A" & Range("A" & Rows.Count).End(xlUp).row - offset)
            Else
                Application.Goto Range("A1")
            End If
        End If
    End If
End If


I was not able to check the full code, however the workaround should basically work (it does with Excel 2013 on my PC).

Would be great to get some feedback from you

Greetings

dummy55555

Hi NetDevil,

The code works in excel 2007.
THanks alot for your help.  :) 

Go Up