From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
06-14-2009 02:53 AM
Hello,
I am doing datalogging with the interval of 1min data, this will logg the data up to 3 days, forthat i am using sql server, now i can able to insert and fetch the data as much fast enough. but i need to retrieve the data as specified time and also a batch wise data. could you tell me how do i implement this?
i downloaded some examples vi's from ni.com, but its not working....
if possible send me example vi
Solved! Go to Solution.
06-14-2009 09:47 AM
Hi Balaji DP,
what do you mean with retrieve the data at specified time? Can you explain a bit more please?
Mike
06-15-2009 12:28 AM
hello mike,
what i mean that, let say i am started data logging from 6:00:00 AM then till now running the logging as per 1min interval will insert the data in to the data base.
1. now, i just want to retrieve the data from 8:00:00 AM to 9:00:00 AM,
Here i am doing with paramerterised data logging and the first column will be Date/time format i set in the sql database, and my date/time format from labview will be dd/mm/yyyy hh:mm:ss PM or AM, this will be a single column only. remaining data channels are single precesicision format only .
2. here i am always inserting the data in the interval of 1min. after, i want to retrieve the data for my report, i need a every 5 minutes data, this must be a user defined.
eg. this is example for insert data to sql data base as default as 1min interval.
15/06/2009 06:00:00 AM 234.5 454.5 565.7
15/06/2009 06:01:00 AM 234.5 454.5 565.7
15/06/2009 06:02:00 AM 234.5 454.5 565.7
15/06/2009 06:03:00 AM 234.5 454.5 565.7
15/06/2009 06:04:00 AM 234.5 454.5 565.7
15/06/2009 06:05:00 AM 234.5 454.5 565.7
15/06/2009 06:06:00 AM 234.5 454.5 565.7
15/06/2009 06:07:00 AM 234.5 454.5 565.7
15/06/2009 06:08:00 AM 234.5 454.5 565.7
15/06/2009 06:09:00 AM 234.5 454.5 565.7
15/06/2009 06:10:00 AM 234.5 454.5 565.7
15/06/2009 06:11:00 AM 234.5 454.5 565.7
15/06/2009 06:12:00 AM 234.5 454.5 565.7
eg: This is to be done. for retrieve the data as 5 min interval only.
15/06/2009 06:00:00 AM 234.5 454.5 565.7
15/06/2009 06:04:00 AM 234.5 454.5 565.7
15/06/2009 06:09:00 AM 234.5 454.5 565.7
for the above logic is there any queries on sql server?
3. what is the difference betweeen the sql database and access data base, functionality and userfriendly programming?
06-16-2009 01:52 AM
06-16-2009 02:01 AM
Hi Balaji DP,
see this link please
http://vyaskn.tripod.com/searching_date_time_values.htm
It shows how you can search for date and time values. You can combine them. I'm not really sure if you can solve the 5 minutes interval with it, but you can definitifly get the range you need. You can then filter the last data in LabVIEW.
See also this link for your second question
http://www.mssqlcity.com/Articles/Compare/sql_server_vs_access.htm
Mike
06-16-2009 02:22 AM
thanks mike,
I have another question, i am using TDMS.vi for fast data logging, what i mean that i am logging the data 1000 samples/sec. of course my pc has a 4gb ram as well as high speed drive also, i can able to retrieve the data upto 30mb, blut i wants to check the file size while i am start stroing the data.. how could do this?
06-16-2009 02:26 AM
Hi Balaji DP,
you can use the "Get File Size" function from the File I/O palette.
Mike