Author Topic: Data Input  (Read 12090 times)

philipjoseph

  • Jr. Member
  • Posts: 57
    • View Profile
Data Input
« on: June 18, 2002, 05:34:18 AM »
I have a T100MD with Tri-Excelink to take production information from a machine and then connected to SQL Server. I need that the operator has the option to insert some information such as, coments and the the order#. How can I do it?.
(I don't know if I can use a lcd and a keybord or keypad).
Right now, is conected one machine, but I'm planning to install to 6 machines.

PHILIP
« Last Edit: December 31, 1969, 04:00:00 PM by 1076562000 »
Philip.

support

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3174
    • View Profile
    • Internet Programmable PLCs
Re: Data Input
« Reply #1 on: June 18, 2002, 09:29:55 AM »
T100MD888+ can be made to construct a string based on user's input via push button. The string value can then be read into Excel spreadsheet by ExcelLink.  Or it can be read from RS232 device such as bar code scanner, smart card reader etc and these data can be read into Excel Spreadsheet as well. :)
« Last Edit: December 31, 1969, 04:00:00 PM by 1076562000 »
Email: support@triplc.com
Tel: 1-877-TRI-PLCS

philipjoseph

  • Jr. Member
  • Posts: 57
    • View Profile
Re: Data Input
« Reply #2 on: June 18, 2002, 12:27:47 PM »
I would like to use a computer keyboard and monitor, for I need that the operator explain the resons when the machine is shut down, so I cann't use preselected data or bar scaner.
Is posible use them?
« Last Edit: December 31, 1969, 04:00:00 PM by 1076562000 »
Philip.

support

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3174
    • View Profile
    • Internet Programmable PLCs
Re: Data Input
« Reply #3 on: June 18, 2002, 12:37:18 PM »
1. Do you need such data (operator inputs) to be captured in Excel?
2. Is the same computer used for capturing data in Excel? If so, then you can write a macro in Excel to capture operator input when a certain condition occur. Please refer to MS-Excel macro programming reference book.
« Last Edit: December 31, 1969, 04:00:00 PM by 1076562000 »
Email: support@triplc.com
Tel: 1-877-TRI-PLCS