AnsweredAssumed Answered

34450A send log to PC

Question asked by cdndesigner on Mar 22, 2013
Latest reply on May 8, 2013 by cdndesigner

Like • Show 0 Likes0
Comment • 5

Hello all,

I'm just getting into this meter and having some trouble.

The user manual explains how to create a log of measurements and how to view it on the meter and it says you can export to PC but doesn't say how. How do I send log to PC?

--------------------------------------------------------------------------------------------------------------------------------------------------
Extra info:
--------------------------------------------------------------------------------------------------------------------------------------------------
Goal:
Get a lot of quick measurements into excel.

Status:
Got example program running where excel takes 1 measurement every second but that's way too slow.
Got meter to log a bunch of recordings, that's quick enough but I can't figure out how to send the log to the PC.

Thanks for any help.

No one else has this question

Outcomes

cdndesigner Apr 1, 2013 11:11 AM

Got it.

DATA:DATA? NVMEM

Actions

igotic May 7, 2013 3:55 AM

Hello!

Can you explain how did you connect 34450A with excel and where did you set "reading sample"?? We had tried both with USB and GPIB USB HS cable from NI - addin "sees" the instrument but Connect button stays shadowed (unavaliable)...check attachment
Can you please explain how did you connect it...
We have succeeded also to save log into instrument and managed to view logged data but also we were unable to "send" logged data to pc.
Thanks

Edited by: Igotic on May 7, 2013 4:50 AM

Attachments

intuilink.jpg85.7 KB

Actions

cdndesigner May 7, 2013 8:59 AM

To send data right to Excel I just used one of the Agilent examples and modified it.

You can either add the command DATA:DATA? NVMEM to the Excel script or use the connection expert:
open Agilent connection expert
select the meter you're connecting with
select send commands to the instrument
enter DATA:DATA? NVMEM
select send and read
copy the data into a .txt doc
change the extension of the .txt doc to .csv
open .csv log in excel.

Actions

igotic @ cdndesigner on May 7, 2013 11:47 PM

Thanks a lot...
One more question - do you have any idea why i cannot connect it to excel??? I can see the instrument in the Addin and it is recognized but cannot establish connection (communication)!!??
p.s - I have installed intuilink for Agilent multimeter although 34450A is not in the list of supported models.

Actions

cdndesigner @ igotic on May 8, 2013 8:45 AM

I started with the example 34401A stripchart

Used USB connection

In Excel -
enable active content
select 'set i/o'
enter address (addr can be found in agilent connection expert)
select 'start monitor'

Hope this helps, I think that's all I needed to do.

Actions

5 Replies

cdndesigner Apr 1, 2013 11:11 AM
Mark Correct
Correct Answer
Got it.

DATA:DATA? NVMEM
Like • Show 0 Likes0
Actions
igotic May 7, 2013 3:55 AM
Mark Correct
Correct Answer
Hello!

Can you explain how did you connect 34450A with excel and where did you set "reading sample"?? We had tried both with USB and GPIB USB HS cable from NI - addin "sees" the instrument but Connect button stays shadowed (unavaliable)...check attachment
Can you please explain how did you connect it...
We have succeeded also to save log into instrument and managed to view logged data but also we were unable to "send" logged data to pc.
Thanks

Edited by: Igotic on May 7, 2013 4:50 AM
Attachments
- intuilink.jpg85.7 KB
Like • Show 0 Likes0
Actions
cdndesigner May 7, 2013 8:59 AM
Mark Correct
Correct Answer
To send data right to Excel I just used one of the Agilent examples and modified it.

You can either add the command DATA:DATA? NVMEM to the Excel script or use the connection expert:
open Agilent connection expert
select the meter you're connecting with
select send commands to the instrument
enter DATA:DATA? NVMEM
select send and read
copy the data into a .txt doc
change the extension of the .txt doc to .csv
open .csv log in excel.
Like • Show 0 Likes0
Actions
- igotic @ cdndesigner on May 7, 2013 11:47 PM
  Mark Correct
  Correct Answer
  Thanks a lot...
  One more question - do you have any idea why i cannot connect it to excel??? I can see the instrument in the Addin and it is recognized but cannot establish connection (communication)!!??
  p.s - I have installed intuilink for Agilent multimeter although 34450A is not in the list of supported models.
  Like • Show 0 Likes0
  Actions
  - cdndesigner @ igotic on May 8, 2013 8:45 AM
    Mark Correct
    Correct Answer
    I started with the example 34401A stripchart
    
    Used USB connection
    
    In Excel -
    enable active content
    select 'set i/o'
    enter address (addr can be found in agilent connection expert)
    select 'start monitor'
    
    Hope this helps, I think that's all I needed to do.
    Like • Show 0 Likes0
    Actions

34450A send log to PC

Outcomes

Attachments

Related Content

Recommended Content