Vantage 8.03.400 BAM .P question

Thank you for your reply, Aaron.



I know that Vantage uses global variables and I will do some research on how
Vantage handles its global user id.



Carl



Carl D. Peterson, CPIM

Nexus Software, Inc.

Plymouth, Michigan 48170

1-734-812-9532 - Mobile

1-734-453-3101 - Office

1-734-455-9550 - Fax

cpeterson@...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 2:45 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question



Thank you, but it is still pulling the userid of the appserver, not the user
that triggered the BAM.
I have a call into support, but I am not holding my breath at this point.
I just had a thought though. I might be able to get around it by using the
WorkCenter that the employee is working on to determine the information
(This BAM is triggered by the LaborDtl table) I am really looking for the
computer they are using so that I can print a label on their printer. I
might be able to use the workcenter (sorry Resource group) they are
reporting against and print to that printer. It will not handle well when
they are reporting on a different workcenter, but in the long run that might
be a good thing.
I appreciate the help, if I do hear back from Support about how they suggest
handling this, I will be sure to pass it on.
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of
Carl Peterson
Sent: Tuesday, October 23, 2007 12:38 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question

You could try this, Aaron.

Def var vUserid as char format "x(30)" no-undo.

vUserid = userid("Mfgsys").

Find first company no-lock no-error.

Find first UserComp no-lock where usercomp.company =
company.company

And usercomp.DCDUserid = vuserid no-error.

This will give you access to the user's name.

Carl

Carl D. Peterson, CPIM

Nexus Software, Inc.

Plymouth, Michigan 48170

1-734-812-9532 - Mobile

1-734-453-3101 - Office

1-734-455-9550 - Fax

cpeterson@... <mailto:cpeterson%40NexusSoftware.net>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 11:49 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question

Scott,
Try as I might, I can't figure how to use this table in a .p. Can you
suggest a method to find the correct record from this table?
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ]On
Behalf Of
Scott Litzau
Sent: Tuesday, October 23, 2007 11:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question

Aaron,

There is a Table UserComp that holds the Full User Name and User ID. The
fields are Name and DCDUserID.

Scott

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 9:27 AM
To: Vantage Group
Subject: [Vantage] Vantage 8.03.400 BAM .P question

In preparing for the jump from 6.1 to 8.03.400 I have finally learned how
to
fix my BAM .p procedures to allow them to run in 8.X. Unfortunately they
are now running from the server and that leaves me a new challenge. What I
need to know is the Global variables available to the .p running from a
BAM.
Specifically I am looking for the current Vantage UserID. I have
discovered
I can get at the windows UserID using UserID, but I need the Vantage user
that is driving the BAM. Does anyone have any ideas of how to get at this
information?
Thanks,
Aaron Hoyt
Vantage Plastics

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
In preparing for the jump from 6.1 to 8.03.400 I have finally learned how to
fix my BAM .p procedures to allow them to run in 8.X. Unfortunately they
are now running from the server and that leaves me a new challenge. What I
need to know is the Global variables available to the .p running from a BAM.
Specifically I am looking for the current Vantage UserID. I have discovered
I can get at the windows UserID using UserID, but I need the Vantage user
that is driving the BAM. Does anyone have any ideas of how to get at this
information?
Thanks,
Aaron Hoyt
Vantage Plastics
Aaron...I am way out of my league on 8.x and .p stuff but one of the interesting things I heard at Perspectives about 8.03.400 was related to single signon to the network and Vantage. There was mention of a field in the user setup that stores the user's network userid. Might this be a way (if populated) to connect the network userid and the Vantage user? On the other hand there might be some security and access issues for that table but it might be worth looking at anyway.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Aaron Hoyt
Sent: Tuesday, October 23, 2007 9:27 AM
To: Vantage Group
Subject: [Vantage] Vantage 8.03.400 BAM .P question


In preparing for the jump from 6.1 to 8.03.400 I have finally learned how to
fix my BAM .p procedures to allow them to run in 8.X. Unfortunately they
are now running from the server and that leaves me a new challenge. What I
need to know is the Global variables available to the .p running from a BAM.
Specifically I am looking for the current Vantage UserID. I have discovered
I can get at the windows UserID using UserID, but I need the Vantage user
that is driving the BAM. Does anyone have any ideas of how to get at this
information?
Thanks,
Aaron Hoyt
Vantage Plastics



________________________________
The information contained in this E-mail message and any documents which may be attached are privileged and confidential, and may be protected from disclosure.

Please be aware that any use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think you have received this message in error, please reply to the sender.

For more information please visit www.harveyvogel.com


[Non-text portions of this message have been removed]
Aaron,

There is a Table UserComp that holds the Full User Name and User ID. The
fields are Name and DCDUserID.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 9:27 AM
To: Vantage Group
Subject: [Vantage] Vantage 8.03.400 BAM .P question

In preparing for the jump from 6.1 to 8.03.400 I have finally learned how to
fix my BAM .p procedures to allow them to run in 8.X. Unfortunately they
are now running from the server and that leaves me a new challenge. What I
need to know is the Global variables available to the .p running from a BAM.
Specifically I am looking for the current Vantage UserID. I have discovered
I can get at the windows UserID using UserID, but I need the Vantage user
that is driving the BAM. Does anyone have any ideas of how to get at this
information?
Thanks,
Aaron Hoyt
Vantage Plastics



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Todd,
Interesting direction of though.
Frustrating result so far though. When I used UserID to attempt to find the
correct UserFile record, I get stuck because the process is running from the
server and declares the UserID to be Administrator (the user currently
logged onto the server and the one currently set to run the Admin Service)
but not the user on the windows box that called the BAM.
It's nice that the server is doing the heavy lifting, but sometimes it would
be nice if Epicor would leave well enough alone.
Do you know of any other way to read the information from the user that is
calling the BAM, like maybe something involved with the writing of the
ChangeLog?
Thanks again,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Todd Caughey
Sent: Tuesday, October 23, 2007 10:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question


Aaron...I am way out of my league on 8.x and .p stuff but one of the
interesting things I heard at Perspectives about 8.03.400 was related to
single signon to the network and Vantage. There was mention of a field in
the user setup that stores the user's network userid. Might this be a way
(if populated) to connect the network userid and the Vantage user? On the
other hand there might be some security and access issues for that table but
it might be worth looking at anyway.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Aaron Hoyt
Sent: Tuesday, October 23, 2007 9:27 AM
To: Vantage Group
Subject: [Vantage] Vantage 8.03.400 BAM .P question

In preparing for the jump from 6.1 to 8.03.400 I have finally learned how
to
fix my BAM .p procedures to allow them to run in 8.X. Unfortunately they
are now running from the server and that leaves me a new challenge. What I
need to know is the Global variables available to the .p running from a
BAM.
Specifically I am looking for the current Vantage UserID. I have
discovered
I can get at the windows UserID using UserID, but I need the Vantage user
that is driving the BAM. Does anyone have any ideas of how to get at this
information?
Thanks,
Aaron Hoyt
Vantage Plastics

________________________________
The information contained in this E-mail message and any documents which
may be attached are privileged and confidential, and may be protected from
disclosure.

Please be aware that any use, printing, copying, disclosure or
dissemination of this communication may be subject to legal restriction or
sanction. If you think you have received this message in error, please reply
to the sender.

For more information please visit www.harveyvogel.com

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
Scott,
Try as I might, I can't figure how to use this table in a .p. Can you
suggest a method to find the correct record from this table?
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Scott Litzau
Sent: Tuesday, October 23, 2007 11:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question


Aaron,

There is a Table UserComp that holds the Full User Name and User ID. The
fields are Name and DCDUserID.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 9:27 AM
To: Vantage Group
Subject: [Vantage] Vantage 8.03.400 BAM .P question

In preparing for the jump from 6.1 to 8.03.400 I have finally learned how
to
fix my BAM .p procedures to allow them to run in 8.X. Unfortunately they
are now running from the server and that leaves me a new challenge. What I
need to know is the Global variables available to the .p running from a
BAM.
Specifically I am looking for the current Vantage UserID. I have
discovered
I can get at the windows UserID using UserID, but I need the Vantage user
that is driving the BAM. Does anyone have any ideas of how to get at this
information?
Thanks,
Aaron Hoyt
Vantage Plastics

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links






[Non-text portions of this message have been removed]
Aaron:



If you are using your userid assignment in Vantage as the same as your
Window's userid, then try the following in Progress.



Def var vUserid as char format "x(30)" no-undo.



vUserid = userid("Mfgsys").







MFGSYS is the database name.



I hope that this helps.





Carl D. Peterson, CPIM

Nexus Software, Inc.

Plymouth, Michigan 48170

1-734-812-9532 - Mobile

1-734-453-3101 - Office

1-734-455-9550 - Fax

cpeterson@...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 10:27 AM
To: Vantage Group
Subject: [Vantage] Vantage 8.03.400 BAM .P question



In preparing for the jump from 6.1 to 8.03.400 I have finally learned how to
fix my BAM .p procedures to allow them to run in 8.X. Unfortunately they
are now running from the server and that leaves me a new challenge. What I
need to know is the Global variables available to the .p running from a BAM.
Specifically I am looking for the current Vantage UserID. I have discovered
I can get at the windows UserID using UserID, but I need the Vantage user
that is driving the BAM. Does anyone have any ideas of how to get at this
information?
Thanks,
Aaron Hoyt
Vantage Plastics





[Non-text portions of this message have been removed]
Aaron,

I do not know progress code. I have not implemented BAM just yet. I am going
to 8.03 soon myself and then I hope to dig into them.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 10:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question

Scott,
Try as I might, I can't figure how to use this table in a .p. Can you
suggest a method to find the correct record from this table?
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Scott Litzau
Sent: Tuesday, October 23, 2007 11:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question


Aaron,

There is a Table UserComp that holds the Full User Name and User ID. The
fields are Name and DCDUserID.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 9:27 AM
To: Vantage Group
Subject: [Vantage] Vantage 8.03.400 BAM .P question

In preparing for the jump from 6.1 to 8.03.400 I have finally learned how
to
fix my BAM .p procedures to allow them to run in 8.X. Unfortunately they
are now running from the server and that leaves me a new challenge. What I
need to know is the Global variables available to the .p running from a
BAM.
Specifically I am looking for the current Vantage UserID. I have
discovered
I can get at the windows UserID using UserID, but I need the Vantage user
that is driving the BAM. Does anyone have any ideas of how to get at this
information?
Thanks,
Aaron Hoyt
Vantage Plastics

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links






[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
You could try this, Aaron.



Def var vUserid as char format "x(30)" no-undo.



vUserid = userid("Mfgsys").

Find first company no-lock no-error.

Find first UserComp no-lock where usercomp.company =
company.company

And usercomp.DCDUserid = vuserid no-error.





This will give you access to the user's name.



Carl















Carl D. Peterson, CPIM

Nexus Software, Inc.

Plymouth, Michigan 48170

1-734-812-9532 - Mobile

1-734-453-3101 - Office

1-734-455-9550 - Fax

cpeterson@...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 11:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question



Scott,
Try as I might, I can't figure how to use this table in a .p. Can you
suggest a method to find the correct record from this table?
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of
Scott Litzau
Sent: Tuesday, October 23, 2007 11:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question

Aaron,

There is a Table UserComp that holds the Full User Name and User ID. The
fields are Name and DCDUserID.

Scott

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 9:27 AM
To: Vantage Group
Subject: [Vantage] Vantage 8.03.400 BAM .P question

In preparing for the jump from 6.1 to 8.03.400 I have finally learned how
to
fix my BAM .p procedures to allow them to run in 8.X. Unfortunately they
are now running from the server and that leaves me a new challenge. What I
need to know is the Global variables available to the .p running from a
BAM.
Specifically I am looking for the current Vantage UserID. I have
discovered
I can get at the windows UserID using UserID, but I need the Vantage user
that is driving the BAM. Does anyone have any ideas of how to get at this
information?
Thanks,
Aaron Hoyt
Vantage Plastics

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Thank you, but it is still pulling the userid of the appserver, not the user
that triggered the BAM.
I have a call into support, but I am not holding my breath at this point.
I just had a thought though. I might be able to get around it by using the
WorkCenter that the employee is working on to determine the information
(This BAM is triggered by the LaborDtl table) I am really looking for the
computer they are using so that I can print a label on their printer. I
might be able to use the workcenter (sorry Resource group) they are
reporting against and print to that printer. It will not handle well when
they are reporting on a different workcenter, but in the long run that might
be a good thing.
I appreciate the help, if I do hear back from Support about how they suggest
handling this, I will be sure to pass it on.
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Carl Peterson
Sent: Tuesday, October 23, 2007 12:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question


You could try this, Aaron.

Def var vUserid as char format "x(30)" no-undo.

vUserid = userid("Mfgsys").

Find first company no-lock no-error.

Find first UserComp no-lock where usercomp.company =
company.company

And usercomp.DCDUserid = vuserid no-error.

This will give you access to the user's name.

Carl

Carl D. Peterson, CPIM

Nexus Software, Inc.

Plymouth, Michigan 48170

1-734-812-9532 - Mobile

1-734-453-3101 - Office

1-734-455-9550 - Fax

cpeterson@...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 11:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question

Scott,
Try as I might, I can't figure how to use this table in a .p. Can you
suggest a method to find the correct record from this table?
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of
Scott Litzau
Sent: Tuesday, October 23, 2007 11:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.400 BAM .P question

Aaron,

There is a Table UserComp that holds the Full User Name and User ID. The
fields are Name and DCDUserID.

Scott

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of
Aaron Hoyt
Sent: Tuesday, October 23, 2007 9:27 AM
To: Vantage Group
Subject: [Vantage] Vantage 8.03.400 BAM .P question

In preparing for the jump from 6.1 to 8.03.400 I have finally learned how
to
fix my BAM .p procedures to allow them to run in 8.X. Unfortunately they
are now running from the server and that leaves me a new challenge. What I
need to know is the Global variables available to the .p running from a
BAM.
Specifically I am looking for the current Vantage UserID. I have
discovered
I can get at the windows UserID using UserID, but I need the Vantage user
that is driving the BAM. Does anyone have any ideas of how to get at this
information?
Thanks,
Aaron Hoyt
Vantage Plastics

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]