Home > Software > WinDaq Acquisition Software > Forum > how to record and save the data in an excel sheet without manual operation.

how to record and save the data in an excel sheet without manual operation.

Jan 29, 2015
swathi wrote
I'm working with DI-720 hardware and windaq data acquisition software for recording the value of current in an CT. At present manual operation is being carried out to record and to save the data in excel. I need to do it automatically i.e once the connections is made and power is given , all the recordings and operations has to be done automatically and the program should stop by its own, is there any possibility to do it.
Reply
5 Answers
Jan 30, 2015
Shawn agent wrote
Swathi,

I'm not certain that you can do exactly what you'd like without programming.

Here are a couple of suggestion:

1.) You can use Triggered Storage to begin recording when the voltage value on a 'trigger' channel exceeds a specified level.

You can specify the number of sample that will be stored to disk when a trigger level is exceeded. Once that number of samples has been acquired, the trigger will re-arm.

For instructions, go to:
http://www.dataq.com/resources/installations/web-help/acquisition/Content/functions/acquisition_triggering/Triggered_Storage.htm

In order to get the data into Microsoft Excel, you would need to have the WinDaq/XL add-on ($99) running in the background.

For more on WinDaq/XL, go to:
http://www.dataq.com/resources/installations/web-help/acquisition/Content/functions/acquisition_triggering/Triggered_Storage.htm


2.) Alternatively, you can begin recording when the PC is powered up by creating a command line, placing it in a batch (.bat) file, and the using the Windows Scheduler to run the batch file on boot-up.

For instructions, see our blog post on the subject at:
http://www.dataq.com/blog/data-acquisition/start-logging-data-on-boot-up-using-youre-dataq-data-acquisition-device/

Note: If you're using the batch file method, you'll need to manually save the recorded data in Excel (.csv) format.
Jan 30, 2015
Shawn agent wrote
Sorry, for more on the WinDaq/XL add-on, go to:
http://www.dataq.com/products/windaq/windaqxl/product.html
Feb 04, 2015
swathi wrote
Thankyou sir, i got some idea. One more doubt, sir, using NI-Labview is there any possibility to do this?
Feb 04, 2015
swathi wrote
If Programming can be done to do this, sir, can you tell me, how to program it and where to do it.
what languages can be used, default program in the software can be modified to do this ?
Feb 05, 2015
Shawn agent wrote
No, the default program (WinDaq) cannot be modified.

Please see our blog post on programming with LabVIEW (incorporating our ActiveX control library) at: http://www.dataq.com/blog/data-acquisition/programming/data-acquisition-using-labview-dataq-instruments-activex-controls/
 
Note that programs incorporating our ActiveX controls would need to be compiled using a 32-bit compiler.