status

[Zahkay]

Hello everyone

i need help for my VI

i am monitoring laboratory equipment in a university

However i wanted a help for example:

When the student didnt return the equipment on time, there should be a notification that

the due date has reached or check the student details since equipment is not returned

All my data is stored in the excel

where

Date and time of the borrowal equipment is stored

On the equipment ( qr code is  sticked and once it is decoded)- the data is also stored in the excel

there is a due date ( an extension of 7 days given to the student to return)

My aim is to help me in determing the status ( whether it is returned or not or pending)

Hope to hear from somebody soon

thanks

[RavensFan]

You've already started numerous threads about your project.  Why are you starting a new thread now?

You've been given a lot of specific help in the past.  Why are you now asking very general questions again in a manner that no one is going to be able to help you since you haven't provided any details on the progress you've made on your project since you last posted?

[P@Anand]

A normal .csv file should be good enough to store the data you expect. You can always save the Date and time in csv and you can retrive and check with the current data and time to see elapse detail. 

Please show so far what you have done on this.

[DailyDose]

This is of course suggesting that LabVIEW is operating 24/7 and is probing and writing to your excel workbook.  There are quite a few SubVIs in that project that I highly doubt someone can simply give you an example.  You'll probably need the following read_excel_values.llb.  Then you'll need to develop an Excel format that displays the data the way you wish it to.  Then you'll need some sort of configuration (.txt document) file that tells LabVIEW how to read and write to/from Excel.  If you plan on having a computer just non-stop pinging for updates, a Maser/Slave structure will be required.  Events will trigger (returning/checking out) telling slave what to do (update Excel).  Psudo code your stuff and this should be a piece of cake.

[Zahkay]

hello sir,

the help i obtained is that the date was not fixed hence

and when i compare so that i can put the notif as pending,

OK and Not returned

is not compatible for all student.

it can be used only once.

I did enhance my VI by putting privacy such as username, MD5.

I am still stuck with the excel database. i am not able to make it work.

this is why i seek another chance where some people can give me another

idea of how to represent to get better output

thanks

[RavensFan]

Then show what you've done so far.

It seems like you have yet to sit down and make a flowchart of exactly how you expect your program to operate.  That should be done before laying down functions and wires in a a LabVIEW program, or typing code in a text-based program.

[P@Anand]

---

@Zahkay wrote:

hello sir,

the help i obtained is that the date was not fixed hence

and when i compare so that i can put the notif as pending,

OK and Not returned

is not compatible for all student.

it can be used only once.

I did enhance my VI by putting privacy such as username, MD5.

I am still stuck with the excel database. i am not able to make it work.

this is why i seek another chance where some people can give me another

idea of how to represent to get better output

thanks

---

So you cannot show the code? It will be tough to explain details on the Air.

Apart from that, Is there any specific reason why you go for Excel format? 

[Dennis_Knutson]

Are you using ado functions with the excel file? That would be the correct way to use it as a database. The queries would pretty simple. From what I have seen of your code in your numerous posts, it is messy and disorganized. .

[Zahkay]

hello

thank u for responding

I am saving in .xls file of excel and i attached my work to it.

My problem is the status.

As you can see in the coding that i put ( enter manually). I put enter manually there so that the lab attendant by himself write the status.

But i wanted it to be automatic. this is only the issue i am facing..

Even though if am using in terms of date ( the second and then put the greater sign then put the status) - as other people suggest.

This is not working since the date of borrowal for each student is not the same

[Dennis_Knutson]

Not only are you not using a database, you aren't using Excel.

Nothing that you have posted shows a read of the text file so that you can determine status. Nothing that you have posted shows any code to handle a return of equipment. Looks like you have done nothing since you last posted.