Welcome, Guest. Please Login.
11/01/24 at 13:28:28
News:
Home Help Search Login


Pages: 1
Send Topic Print
Who and when a WO was created (Read 690 times)
jwalden
Browser
*




Posts: 15
Gender: male
Who and when a WO was created
04/19/04 at 07:50:34
 
I've had a request to record the date/time and user ID of the person who converts or creates a work order and tie this information to the WO.
Back to top
 
 

James Walden
High Voltage Power Systems, Inc
2542 Highlander Way
Carrollton, TX 75006
972-248-7691
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Who and when a WO was created
Reply #1 - 04/19/04 at 07:53:01
 
Cannot be done. DBA does not have the ability to know what user is logged in after they log in. That information is used ONLY at the time of login in order to establish menu access and then it is gone. And since that is part of the core TAS executable, it cannot be changed.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Highlight/Chris
Browser
*




Posts: 18
Gender: male
Re: Who and when a WO was created
Reply #2 - 05/20/04 at 06:27:52
 
I had this same problem with an xBase system that I was tasked with maintaining years ago.  The solution was fairly simple, assuming that TAS has a way to access DOS environmental variables.  At the time of login, create an environmental variable with the users initials or ID or whatever tag you want to use.  (We wrote a small program in C that polled Novell and Microsoft networks User IDs)  You could also create a global variable that could be referenced when needed.  Now create a line in the notes field with the user ID and a time/date stamp each time the work order (and a short description of change) is changed and saved.  It is not exactly a transaction tracking system, but it got the info needed for reference purposes.  Just an idea.
Back to top
 
 

Chris Lofald
HIGHLIGHT, INC.
1120 Hoeschler Drive
Sparta, WI 54656-0538
WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Who and when a WO was created
Reply #3 - 05/20/04 at 07:45:43
 
Chris,
 
Might be workable (I'll let the programmer comment more in depth on that) but here is a use case scenario that kinda throws it out of whack:
 
User X logs into the client station and then into DBA. The environment variable (if that works) stores that info. Good so far. User Y comes along and changes the login in DBA to THEIR login and the environment variable records user X again as it is reading the network login info.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Who and when a WO was created
Reply #4 - 06/25/04 at 10:09:22
 
We have worked out a way using TAS 6 Evo to track DBA Login so that change tracking can be maintained and will be implementing it in various programs.  It will require the TAS 6 Evolution menu, the standard DBA menu can not do this.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: Who and when a WO was created
Reply #5 - 06/30/04 at 08:15:10
 
this sounds like a reason to switch to the TAS 6 version
 
JW
Back to top
 
 
WWW   IP Logged
Pages: 1
Send Topic Print