Go Down

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

larryd

Thanks for all your work, again  :) .

Looks like this can turn into quite an nice tool.

Note:  
If 2.5 is running and accepting data from your supplied INO, things function fine.

- If however, when you move the VBA window, I have noticed Excel sometimes crashes 10 or so seconds later.
- Maybe freeze the ability of moving VBA window while data is being received.

- Also, if you try to use the vertical scroll bar on the right side of the Excel screen while data is being received, Excel crashes.
(so Larry don't scroll  :smiley-confuse: )

- Quitting at 450 works great.



Edit
Also, when data is being received and you click the 'Reset Timer' button, Excel crashes.


OK, maybe the rule should be while data is received do not touch. ;)
.
No technical PMs.
The last thing you did is where you should start looking.

NetDevil

Thanks for all your work, again  :)

(...)

OK, maybe the rule should be while data is received do not touch. ;)
Thanks for the feedback :)

I could use the buttons and checkboxes quit frequently but let me have another look over the next days. Maybe it has something to do with Office365 again ;)

Anyways we are getting better and better with each release and bring PLX DAQ back to its glory days :) 

larryd

It appears: scrolling, moving the VBA window or clicking the reset button freezes then crashes Excel (while data is received).
Almost as if any interruption in data received is not tolerated.


.
No technical PMs.
The last thing you did is where you should start looking.

SharkWheelSDSU

Hello,

I'm having a little trouble getting my PLX-DAQ(v2.3) to work. Whenever I try to run my Arduino program with PLX open, I get the error message "avrdude: ser_send():write error: sorry no info available". Whenever I run my code with the program disconnected though, it runs fine. However, when my Arduino is connected, the Excel sheet does display the column labels. Any help would be greatly appreciated!

larryd

Make sure you don't have the com port open in Excel when you try uploading in the IDE.


.
No technical PMs.
The last thing you did is where you should start looking.

SharkWheelSDSU

Hi,

Thanks for the response! The serial monitor was closed when I was getting that error. I'm not sure if it's a problem with my Arduino code, but here's the the portion that is supposed to send the data:


Code: [Select]

void setup (){
 Serial.begin(9600);
  Serial.println("CLEARDATA");
  Serial.println("LABEL,Load,Drum Speed,Wheel RPM,Run Time");  // These labels DO work

// Irrelevant Stuff
}


void loop() {

// Even more of irrelevant stuff

      if((millis()- refresh) >= 100){   // When to send Data 
                Serial.print("DATA");
                Serial.print(mloadVal);
                Serial.print(",");
                Serial.print(dmph);
                Serial.print(",");
                Serial.print(wrpm);
                Serial.print(",");
                Serial.println(timerSeconds);
                refresh = millis();

// Rest of the irrelevant stuff
}


NetDevil

but here's the the portion that is supposed to send the data:

Code: [Select]

                Serial.print("DATA");
                Serial.print(","); <<== this one was missing
                Serial.print(mloadVal);

You were missing the , after the DATA
Try opening the direct debug window in PLX DAQ and you should be able to see how your lines are incoming from Arduino in PLX DAQ.

NetDevil

Well I wasn't able to fix the problem with the UI crashing .... It is totally arbitrary and I cannot put my finger on where and what and how crashes the form. It is both when moving the form as well when moving the whole application. Scrolling on the sheet works fine with me but as soon as you do some action that stops the macro from working for a few seconds it crashes some times after. For example when you move the window around you can see the logging to pause in the direct debug window.

So I just added a warning message on the UI :-X

Alongside some other staff:



=============================================================
This version is already outdated !! Link to always most recent version of PLX DAQ v2 here:

==> https://forum.arduino.cc/index.php?topic=437398.msg3013761#msg3013761 <==
=============================================================




What's new in "version 2.6" aka Change log:

  • Fixed the reset timer button (there was a useless message box implemented somehow)
  • Formatted the timer to always have 6 trailing digits
  • removed the old fashioned limit to 27 columns - now supports the thousands of columns that Excel supports (although it is getting pretty slow with too many columns)
  • Set the columns all to be aligned centrally on default and column captions to be written in bold by default
  • and well yeah - added the warning remark not to play around too much with the window during logging


I also updated the example sketch once more (included stand alone and in the zip file as well).


Image-Link: http://www.freebie-base.de/Pics/PLX_DAQ_v2.6.png
(hosted on my server, no traffic hijack)





Quote from: Older changelogs
What's new in "version 2.5" aka Change log:
  • Added a "Pause logging" / "Resume logging" button that can (well no surprise) stop the logging of the data without disconnecting the Arduino. The Button is enabled when connected
  • Removed the old 4 checkboxes as the functions are useless without Stamp nowadays and replaced with 3 custom checkboxes. As with old PLX DAQ v1 these checkboxes can be controlled by Arduino code: change text, check/uncheck box, read status of boxed (if checked or not). Codes changed from "DOWNLOAD" / "STORED" / "USER1" to CUSTOMBOX1 / CUSTOMBOX2 / CUSTOMBOX3. "USER2" was removed completely.
  • Moved "Reset on Connect" around a bit for better UI layout
  • Re-implemented the code for "Reset Timer" button. I don't know why I removed that anyways in version 2.1 ....
  • I added a new example sketch that demonstrates the new functions and how one can use them
  • I also rework the example codes in the custom dev points for not crashing Excel anymore - hopefully ;)
  • Added new functions to call in Excel by Arduino:
    • Beep : makes a simple beep
    • Pauselogging : stops printing logged data to the Excel sheet
    • Resumelogging: continues pasting data again
    • Stoplogging : disconnects the Arduino
    • Saveworkbook : simply saves the workbook
    • SaveworkbookAs,Filename : saves the workbook as a new copy in the same folder by the name Filename.xlsm
    • ForcequitExcel: forces Excel to close. Note: the workbook will not be saved by this!


What's new in "version 2.4" aka Change log:
  • Fixed a UI problem with Office 365
  • Implemented 2 "custom dev points" ("new line was read" and "new data row recognized") which get called by the system automatically and where custom code can be pasted and used (example included in code)

What's new in "version 2.3" aka Change log:
  • Port and baud rate not drop down box anymore but free text fields
  • Port number bug fixed thus ports > 10 can be used (max set to 256 as of modern Windows OS limit)

What's new in "version 2.2" aka Change log:
  • Enhanced 64 bit support (even better stability now)
  • Added a dropdown box to select with sheet to post to (got rid of the radio buttons)
  • Minor adjustment for faster startup of logging

What's new in "version 2.1" aka Change log:
  • --- version never released ---
  • --- it was more of an "internal development version"

What's new in "version 2":
  • Support for both Office versions 64 bit as well as Office 32 bit
  • No more installation needed! All within the workbook
  • I got rid of the selmaDAQ_Ver2.ocx and use API calls now
  • Fully compatible to all previous PLX-DAQ commands in your code!
  • Got rid of some old stuff like "Max row size of 65000" (Office limit is 1048576 rows with 64 bit) or Baud rate only up to 128000 (now supports 230400 and 250000 as well)
  • Added a direct debugging window for better testing as well as a VBA code module for testing and debugging
  • Setting for selecting where to post data (first most left sheet or currently active sheet)
  • Disabled the control boxes as Stamp object is no more in use

=============================================================
This version is already outdated !! Link to always most recent version of PLX DAQ v2 here:

==> https://forum.arduino.cc/index.php?topic=437398.msg3013761#msg3013761 <==
=============================================================

SharkWheelSDSU


ralphjabonga

 :(  :smiley-confuse:

Im a newbee
I just want to directly write serial monitor values to excel i downloaded all versions. v2 v2.2 v2.3
I dont get whats the correct code. when i clicked connect nothing changes. com3 was recognize where my arduino was connected

PS: im using DHT22 Humidity and Temperature sensor.

NetDevil

I just want to directly write serial monitor values to excel i downloaded all versions. v2 v2.2 v2.3
I dont get whats the correct code. when i clicked connect nothing changes. com3 was recognize where my arduino was connected
Hi ralphjabonga,

the Serial.print statements in your code are written to output to the serial monitor of Arduino IDE. To see the results in Excel, please:

  • Download the latest version 2.6 above
  • Connect your Arduino to your PC, click on Connect and open the "direct debug window"
  • You should now see the serial.print statements as in Arduino IDE serial monitor
  • To have it being posted to Excel you need to use the PLX DAQ syntax. Examples can be found here http://robottini.altervista.org/arduino-and-real-time-charts-in-excel or here http://www.instructables.com/id/Sending-data-from-Arduino-to-Excel-and-plotting-it/?ALLSTEPS and of course in the example sketch attached to the zip file of version 2.6
  • Basically you just need to send 1) CLEARDATA first, 2) followed by LABEL and the name of the columns you want to have in Excel and 3) send DATA followed by the t and h values you measured


It is pretty simple, just take a look at the examples I provided ;-)

Greetings

ankoo

please help me..

Win10 and office13

all time with all version program have the same problems

 :smiley-confuse:  :smiley-confuse:

NetDevil

Win10 and office13
Hi Ankoo,

are you running Win10 on 64bit or 32bit ?
same for Office 2013: 64 or 32 bit?

jl1cny

Hi Net Devil

Thank you very much for providing a great handy tool to transfer serial data to Excel. I am writing a sketch that controls Arduino by sending characters and numbers to it through serial. I am wondering if you can add functions to PLQ-DAQ version 2 that allows the user to send characters and numbers to Arduino through serial.

My project is to build a sweep frequency generator with a power detector. One can control the frequency range of the signal generated and the output of a filter under measure is measured and sent back to EXCEL to  draw a graph.

Thank you in advance for your consideration.

Best regards,

Sam


NetDevil

Thank you very much for providing a great handy tool to transfer serial data to Excel. I am writing a sketch that controls Arduino by sending characters and numbers to it through serial. I am wondering if you can add functions to PLQ-DAQ version 2 that allows the user to send characters and numbers to Arduino through serial.
(...)
Thank you in advance for your consideration.
Hi Sam,

thanks a lot for your feedback :) Good news for you: the function is in fact already present in the program ;)

With the command
Code: [Select]
Serial.println("CELL,GET,D1,");
your Ardunio can ask Excel to send him the values from cell D1 (well in this case). In that cell (and further cells) you could put the variables that you use to operate the frequency range.

Otherwise you could use the custom dev-point "CustomDevPointNewData". There you could easily send your own defined commands from Arduino to Excel and programm in VBA any behaviour you want (e.g. check current time of PC and adjust frequency if time is pre 12:00 am or past 12:00 am. Data can be send to your Arduino from VBA via command
Code: [Select]
CommWrite cboPort.Text, "Any information can be send here"

In case you have any further questions please feel free to ask :-)

Greetings

NetDevil

Go Up