Programmatically create virtual channels in labview.

[Brian_S]

This is what I need to do. I have a database written in MsAccess 97. This is called my sensor database which contains all my sensor calibration data. In this database about 90% of the sensors are accelerometers (voltage excitation). There are well over 100 of these accelerometers. They are calibrated every 6 months or sooner. Each accelerometer entry in this database has an entry for Min/Max range, sensitivity (mv/g), excitation voltage, etc....

Before I run the Labview application I've written I would have to manually enter the new calibration data from the sensor database into Nidaq Max. This can take a bit of time on my part typing this information in. So, what I thought would be an easy thing to do would be to have Labview access this database, pull out the calibration data for each sensor (accelerometers) and somehow get this info into max.

Nidaqmx (acceleration AI) is out of the question because it does not support accelerometers using voltage excitation when used with a SCXI-1520. I would not be looking forward to converting the sensitivity over to a custom scaled voltage measurement.

As in Legacy NIdaq you are able to select a "Accelerometer" as an Analog Input Device and configure it with a sensitivity value, excitation voltage,<--(not current),ranges etc....

This is not available in NiDaqmax. If it can be done in NIDaq why can't it be done in NiDaqmx. What I mean is why did NI remove this capablity in NIDaqmx using a SCXI-1520.

Is was so handy to just enter in a sensitivity and not have use a custom scale for an accelerometer.

Well, anyways still back to original problem of reading in a database from MsAccess and writing in sensor calibration data to update the sensor data in Max using Labview.

No can do? Would be a great feature to add someday I hope. My wish list. How about Labwindows can it do it or Measurement studio for VB?

Thanks,

BrianS

[Marni]

Dear Brian,

There is a toolkit called Database Connectivity Toolkit that allows you to read from a database in LabVIEW. You could then use DAQmx Create Scale.vi to create a scale based off of your database values and DAQmx Save Scale.vi to save it to MAX. In MAX, just open a Custom Voltage with Excitation and select your scale as the custom scaling.

In MAX, accelerometers are assumed to be IEPE accelerometers, which are excited by currents and not voltages. Since the SCXI-1520 provides voltage excitation, it will not show up in the list. This is exactly why we have Custom Voltage with Excitation tasks.

If at any time you would like to make a product suggestion, you can do so at the Product Feedback link. Have a great day!

Sincerely,

Marni S.

[Brian_S]

Thanks, currently we are going to be ordering the database toolkit  in the very near future but for now I've been using a freeware database toolkit which is quite handy. It's only limited in documentation. It can be found here if you want to check it out. http://www.jeffreytravis.com/lost/labsql.html

Maybe you and others already know about this. It works pretty well. Still I would like to see what NI Database Toolkit actually is capable of doing.

Thanks,

Brian