Test and Measurement Forum

How to copy and paste measurements

Forum for discussing PicoScope version 6 (non-automotive version)

How to copy and paste measurements

Postby tomtam » Mon Oct 19, 2015 9:40 pm

I am trying to copy and paste the measurements that are made in the cell at the bottom of the screen. How do I copy them so that I can paste them into an Excel worksheet instead of manually typing the data?
tomtam
Newbie
 
Posts: 0
Joined: Mon Oct 19, 2015 9:34 pm

Re: How to copy and paste measurements

Postby AndrewA » Tue Oct 20, 2015 2:27 pm

Hi,

To do this open command window and type
Code: Select all
C: <enter>

Code: Select all
cd :\Program Files (x86)\Pico Technology\PicoScope6 <enter>

or for 32 bit systems
Code: Select all
cd Program Files\Pico Technology\PicoScope6 <enter>

Enter the following command to export the measurement(s) to a csv file-
Code: Select all
Picoscope.com /a Measurements.CSV? >> measurements.csv

To copy the measurement(s) to the windows clip board use-
Code: Select all
Picoscope.com /a Measurements.CSV? | CLIP

If you want to export measurement(s) from multiple waveform buffers see-
topic15481.html?hilit=batch#p52421
Regards Andrew
Technical Specialist
AndrewA
Zen Master
Zen Master
 
Posts: 178
Joined: Tue Oct 21, 2014 3:07 pm

Re: How to copy and paste measurements

Postby tomtam » Tue Oct 20, 2015 6:05 pm

AndrewA, thanks for your response. Is there any way to append the data to the csv file to store multiple data points? Is it possible to customize the output of the measurement? For example, it would be convenient to have a column for RMS and one column for Maximum for each row that represents one measurement.
tomtam
Newbie
 
Posts: 0
Joined: Mon Oct 19, 2015 9:34 pm

Re: How to copy and paste measurements

Postby AndrewA » Thu Oct 22, 2015 9:44 am

Using
Code: Select all
Picoscope.com /a Measurements.CSV? >> measurements.csv

will append each measurement to the file.
Each line/row after 0ms: Measurements.CSV? is a whole Measurement. ie
Channel, Name, Value, Min, Max, Average, StD, Capture Count Sapn
A,AC RMS,999.5 mV,999.5 mV,999.5 mV,999.5 mV,0 V,1,WholeTrace,


There are many ways to to remove '0ms: Measurements.CSV?' text and reorganize to text deal with multiple measures, per buffer.
You could use a scripting language or batch file, to do this. You can use excel to Switch (transpose) columns and rows
https://support.office.com/en-ca/article/Switch-transpose-columns-and-rows-ed1215f5-59af-47e6-953b-0b513b094dc2
Opening the csv file the in Excel will let you sort these into columns.
Regards Andrew
Technical Specialist
AndrewA
Zen Master
Zen Master
 
Posts: 178
Joined: Tue Oct 21, 2014 3:07 pm

Re: How to copy and paste measurements

Postby tomtam » Thu Oct 22, 2015 10:14 pm

AndrewA, thanks for the clarification.

I am trying to use a scripting language that can receive the output from a terminal command in Windows 7. When I run the command Picoscope.com /a Measurements.CSV? it is not able to get the output, it just waits for a response. I am wondering if it is a permissions issue? Is there another command I can try to get the measurement output?
tomtam
Newbie
 
Posts: 0
Joined: Mon Oct 19, 2015 9:34 pm

Re: How to copy and paste measurements

Postby AndrewA » Fri Oct 23, 2015 3:02 pm

Hi, Tomtam,
Yes you will need to run the 'command prompt' as administrator.
(start menu - cmd - right click on cmd.exe - click 'run as administrator' )
I would suggest you use the beta version of picoscope 6 to avoid this issue-
Point1 - topic19941.html#p62601
Regards Andrew
Technical Specialist
AndrewA
Zen Master
Zen Master
 
Posts: 178
Joined: Tue Oct 21, 2014 3:07 pm

Re: How to copy and paste measurements

Postby tomtam » Fri Oct 23, 2015 9:49 pm

When I use the command prompt directly with a keyboard, I do not need to run as admin. I installed the beta, however it did not solve the issue of running the command via my program to grab the output. I can attach my program that executes the measurement command if that would help.
tomtam
Newbie
 
Posts: 0
Joined: Mon Oct 19, 2015 9:34 pm

Re: How to copy and paste measurements

Postby AndrewA » Wed Oct 28, 2015 11:00 am

Hi, Tomtam,
Yes could you attach your program, and I will try it out.
Regards Andrew
Technical Specialist
AndrewA
Zen Master
Zen Master
 
Posts: 178
Joined: Tue Oct 21, 2014 3:07 pm

Re: How to copy and paste measurements

Postby nmgtn » Thu Jul 21, 2016 5:32 pm

Hi,

I'm trying the commands posted above from an administrator command prompt. The file measurements.csv is created, but the contents are only as below:

Code: Select all
Picoscope.com /a Measurements.CSV? >> measurements.csv

The above command populates the file measurements.csv with contents:
Code: Select all
0ms: Measurements.CSV?
NONE


I've tried a few variations but can't seem to get the measurements from my Picoscope session out into the file.
I'm running PicoScope 6.11.12.1692, using a 2204A, and I have three measurements currently set up on Channel A: Cycle Time, High Pulse Width, and Low Pulse Width.

Any tips on what I'm doing wrong?

Thanks,
Andy
nmgtn
Newbie
 
Posts: 0
Joined: Thu Jul 21, 2016 4:54 pm

Re: How to copy and paste measurements

Postby Hitesh » Mon Jul 25, 2016 9:28 am

Hi Andy,

Which directory are you running the command from?

Also, is the software running or stopped at the time of sending the command?

Regards,
Hitesh

Technical Specialist
Pico Technology
Hitesh
Site Admin
Site Admin
 
Posts: 2009
Joined: Tue May 31, 2011 3:43 pm
Location: St. Neots, Cambridgeshire


Return to PicoScope 6 for Windows

Who is online

Users browsing this forum: No registered users and 1 guest