Creating a database using Labview to acquire motor current & vibration signals

[Sammmy]

Hi all,

I've just purchased a NI USB-6009 DAQ card for my DAQ project.

My DAQ system requires me to create a database to store 2 kinds of signals from motor, namely the motor vibration and current signals.

This database must be abled to perform offline anaylsis, allowing the user to retrive the acquired data in the form of waveform graphs and analyse it based on previous data.

It must also be abled to create reports. I've learnt to generate report and the write to file command but I need help on creating a database.

Thanks.

Sammmy

[Ankita]

Hi,

Which application are you trying to craete a adatabase in - Access, SQL or something else? Also, do you have Database connectivtity toolkit?

Regards,

Ankita 

[Sammmy]

Hi Ankita,

I'm trying to create a database in Access with the capabilty of displaying waveform charts too. Using LabVIEW, I'm able to generate the 'write to file' in the excel format. From here, I will use the macro in Access to transfer all the acquired data from excel to access.  I don't have the DAtabase connectivity toolkit.

My problem is that access is not able to display any waveforms after importng the tables from excel spreadsheet. Labview has this capabilty of generating reports too with the tables n waveforms, but is there any way I can convert all the html reports into a database?

Can you help me with this? Thanks!

Sammmy

[Ankita]

Hi,

Using the database connectivity toolset, you can write data from LabvIEW to databases. However this is clearly not what you are looking for.

I believe you need a  way to tranfer a graph from Excel to Access. I found a few links that may be helpful:

http://www.ehow.com/how_12373_insert-picture-graph.html

http://office.microsoft.com/en-us/assistance/HP010950951033.aspx

Regards,

Ankita

[Sammmy]

Hi Ankita,

Thanks for your help.

I have another question, I want to take measurements of a vibration sensor to track the displacement, so what is the variable that I need to use under the DAQmx?  Voltage?

Thanks.

Sammmy 

[Marni]

Dear Sammmy,

The variable that you will choose is dependent on your sensor. Your sensor probably reads in vibration and converts it a voltage. In the manual for your sensor, it should say the equation to convert that voltage back to a vibration measurement. Once you read the measurement into LabVIEW as a voltage, you can then use that equation from the manual to convert it back to a vibration measurement. Have a great day!

Sincerely,

Marni S.

[Ruju]

Dear Sammmy,

           Mr. Marni is absolutely right, it doesnt depend on the variable u take, and i think after taking the signal in the labview, u also want to display it in the FFT way(the vibration monitoring methods generally do), so you also can try the Vibration and Monitoring Toolkit, either for the FFT or for any of the vibration analysis.

Thanks,

Rujuta