LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Reading the number from a certain column in an running .CSV file

Solved!
Go to solution
Solution
Accepted by topic author eevisi.chen

Here's an example of how to properly use this device. This program was an Accelerated Lifecycle Test that used TWO FULLY LOADED 34790A's to monitor temperatures, and output voltages for must have been 30 individual units under test.

 

34970A #1

  1. Initialize 34970A 
  2. Configure DC voltage measurements
  3. Configure AC voltage measurements
  4. Configure K type thermocouples
  5. Configure Scan list
  6. Configure Scan

logger1.PNG

 

23970A #2

  1. Initialize 34970A
  2. Configure 60 K type thermocouples
  3. Configure Scan List
  4. Configure Scan

Logger2.PNG

 

Now this one looks complicated, but it's not really. This is where I take measurements Sort, display, and save them to a file. SO most of the mess is sorting things for display. Follow the Error Cluster for the important parts that I will touch on.

 

  1. Take a measurement (Scan 34970A's) 
    1. I wrote my own "Agilent Scan.vi" years ago to make it more user friendly. My vi outputs data in three forms. Numeric Array, String Array, and a "CSV string". Long ago I found that helpful, but honestly I onlt ever use the Numeric Array output anymore.
    2. I will attach this VI for you.
  2. Write data to file (1D Array to XLS)
    1. Now this vi of mine is very handy. It takes an array of numerics add a time stamp, and writes them to a text file that can be opened by Excel.
    2. I will attach this vi too 
  3. The rest of this diagram is sorting measurements for display and writing to four other files

LogDisp.PNG

 

 

 

-------------------------------------------------------------------
Unfortunately, most readers of this Forum, including some real Experts, have not mastered the skill of being able to read the code that Posters fail to post. If we cannot see "what you did wrong", we are unable to tell you how to fix it. (Bob Schor 28 August 2018)
0 Kudos
Message 11 of 13
(136 Views)

Hi, RTSLVU:

Do appreciate you attached so useful sample, to a rookie like me who just jumped into LV for one month.

The 60 K-type thermoCoupling vi is already very close to my demand, to improve my daily work becoming more efficiently.

My great honor to be guided by a senior like you.

 

eevisi

 

 

0 Kudos
Message 12 of 13
(115 Views)

Hi RTSLVU:

Followed your comment, I tried to setup the 34970A by the device in LabVIEW.

But something was not correct & I have no idea what's going wrong....

 

Please see another thread in forum by the link:

https://forums.ni.com/t5/LabVIEW/Channel-missing-amp-amp-write-the-data-in-csv-file/m-p/3943518

 

Have you met similar issue when you program it?

 

B/R

eevisi 

0 Kudos
Message 13 of 13
(65 Views)