LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Time stamp and barcode into .xls spreadsheet

Solved!
Go to solution
Hello, I am pretty new to programming in Labview and I have a few issues I need to get worked out. I am using a "Prompt User for Input" asking for a units barcode if there is a failure. So when the message prompts I have the user scan in a barcode and this needs to be sent to a .xls file. Numbers will go into the .xls file but the barcodes I am using have dashes(-) in them and when these barcodes get scanned Labview sends a zero to the spreadsheet. If I manually send numbers they will write to the spreadsheet. I also need a timestamp of when the barcode was scanned to get written to the spreadsheet as well.  Any suggestions?
0 Kudos
Message 1 of 4
(2,920 Views)
Solution
Accepted by Branderegg
It sounds like you should be setting the Prompt User input as a string instead of a numeric if you want to preserve the dashes. Use a Get Date/Time String function along with the prompt.
Message Edited by Dennis Knutson on 05-13-2009 12:18 PM
0 Kudos
Message 2 of 4
(2,915 Views)

Dennis:

 

I believe you have become infected (by Express vi's, that is) 🙂

 

I have to be truthful, that is the one and only Express vi I have ever used.

 

-AK2DM

~~~~~~~~~~~~~~~~~~~~~~~~~~
"It’s the questions that drive us.”
~~~~~~~~~~~~~~~~~~~~~~~~~~
0 Kudos
Message 3 of 4
(2,885 Views)

To tell the truth, I've only really used the express Elapsed Time function in my programs. In this case, since the op was already using the express function, I really didn't see much reason to use anything else since the fix was just a right click option.

0 Kudos
Message 4 of 4
(2,879 Views)