How to display offline data statically into the Graph?

[Dennis_Knutson]

I think the reason that so many people try to use Excel is that it is on everyone's pc. Managers a familiar with it and that is who we have to please. You see so many questions about it because it is not particularly easy to use as a data collection system. You also are forced to use ActiveX and there are a lot of properties and methods you have to dig through to get it to work right. Then you have the problem of microsoft changing the properties and methods with every release so you have to constantly update your program to accomadate whatever version the IS department decides to install whenver they feel like it. Databases, in my opinion, are much simpler to interface to and they can hold an unlimited amount of data. All of the popular databases support SQL (structured query language). The language is stable and most commands work the same with all databases. It's pretty simple to write a variety of queries tha allow you to retrieve just the data you want. Access and the jet database is widely used and it's fine except when you need a lot of simultaneous writes and reads. Then you need to step up to something like SQL Server, Oracle, or MySQL. I haven't used it much, but MySQL is very robust, expandable, and it's free.

[Nishant]

Hiii,

              You are right, managers are the one to whom we should please, but the customers are the one to whom we have to provide all the specs they want and that is what is most difficult, cos they change their specs in every visit, and it always emberass us, neways its a life.

             Now i am also thinking to step up to SQL, but it also requires the LabVIEW database toolkit, and for that i have to beg to my manager, so...

              I think you have referred in the last second reply that you have attached a vi for gathering all the datas at a time, but i think you miss to attach it and that is what currently i required badly, so can you please do me a favor by sending that VI.

Thanks,

Nishant

[Dennis_Knutson]

The database toolkit is nice but it's not absolutely necessary. I couldn't get my company to pay for it and I ended up using LabSQL. You need to know more about SQL than with the NI toolkit but they are both based on the same technology called ADO. In the picture I posted with my first response, it shows the Read From Spreadsheet File being used to get an entire file worth of data. Using this function requires you to say the data in Excel as a comma or tab separated text file.

[Nishant]

Oh...oh!!!

              I was not getting the thing and that is why i was askin yu for the example, but anyways i ve get it now, so yes that is the way we can acquire all the data at a time, but another question raise in my mind is what kind of loop it requires cos when i tried to contanct NI in this regard they show me the way with the indexing of the tunnel at while loop and when we press the stp button all the datas are plo on to the Wavform graph, i think that was also a good idea, but i would rather like to go ur way, cos i know u ll be the perfect, but it seems that i have to get with the loop it requires and then i ll be able to plot the data.

            And i also want to know about reading the datas of serial files continuously, mean start with data 0, when the data 0 finishes start with the data 1,  and so on, upto the last file, so is it possible and if yes then how???

Thanks,
Nishant

[Kalin_T]

Dear Nishant,

If I understand your question correctly, you want to read several different files one after another. You can use the List Folder VI to get the names of all files in a folder with a specific extension. Then you can get that string array of file names and use it in conjunction with the Build Path VI to get the full path for each file in a specified folder. Look at the attached picture for an example.

Hope that helps.

[Nishant]

Deat Kelin,

            you are right that is what i am looking for also with the method that i can read whole the file once and to plot it on a single view of the graph (User dont have to scroll the graph to see whole data), can yopu please post me example of the jpg you have sent to me? I am using LabVIEW 7.1, please help me and send me this VI.

Thanks,

Nishant