Update LaborHed.Character01 with Client PC HostName (ABL / 4GL)

Yahoo Archive
1
I thought you were using it in a BPM that table is a temporary table it
doesn't actually get stored. My bad I had forgotten that you wanted that
originally.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Wed, Jan 9, 2013 at 12:27 PM, jyprksh@... <jyprksh@...>wrote:

> **
>
>
> I take your advice Jose!..
>
> but, i I could not find the BPMDataTable in the SQLServer 2008 database.
> How can i find the right information is stored?
>
> Please brief me about BPMDataTable..
> Apologize if it is dumb question!!
> #Epicor9 #EpicorNovice
>
> --- In vantage@yahoogroups.com, Jose Gomez wrote:
> >
> > Only comment would be that I would set Character01 on BPMDataTable
> instead
> > of laborhead as to not waste a field
> >
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> >
> >
> >
> >
> >
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Wed, Jan 9, 2013 at 12:17 PM, jyprksh@... wrote:
> >
> > > **
>
> > >
> > >
> > > Fantastic Jose,
> > >
> > > figured it out.. here is the piece of code:
> > >
> > > Module level declaration:
> > > Private WithEvents edvLaborHed As EpiDataView
> > >
> > > Sub InitializeCustomCode()
> > >
> > >
> Script.edvLaborHed=CType(Script.oTrans.EpiDataViews("LaborHed"),EpiDataView)
> > > Addhandler Script.edvLaborHed.EpiViewNotification, AddressOf
> > > Script.edvLaborHed_EpiViewNotification
> > >
> > > Sub DestroyCustomCode()
> > > RemoveHandler Script.edvLaborHed.EpiViewNotification, AddressOf
> > > Script.edvLaborHed_EpiViewNotification
> > > Script.edvLaborHed = Nothing
> > >
> > > Private Sub edvLaborHed_EpiViewNotification(ByVal view As EpiDataView,
> > > ByVal args As EpiNotifyArgs)
> > > If (args.NotifyType = EpiTransaction.NotifyType.Initialize) Then
> > > If (args.Row > -1) Then
> > > edvLaborHed.dataView(edvLaborHed.Row).BeginEdit()
> > > edvLaborHed.dataView(edvLaborHed.Row)("Character01") =
> > > System.Environment.Machinename.ToString
> > > edvLaborHed.dataView(edvLaborHed.Row).EndEdit()
> > > End If
> > > End If
> > > End Sub
> > >
> > > Big thanks all!!
> > >
> > > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > > >
> > > > Simply add a Notify Event to LaborHed -> Initialize
> > > > within here simply set txtCallContextBPMData.Character01 =
> > > > System.Environment.Machinename.ToString
> > > >
> > > > Let me know if you need the actual code. And I'll write it up, but I
> am
> > > > feeling lazy today :-)
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *T: 904.469.1524 mobile
> > > > E: jose@
> > > > http://www.josecgomez.com
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > > >
> > > >
> > > > On Wed, Jan 9, 2013 at 11:46 AM, jyprksh@ wrote:
> > > >
> > > > > **
> > > > >
> > > > >
> > > > >
> > > > > Hi Jose,
> > > > >
> > > > > Well, i dropped the textbox1 in the mes and showed the computer
> name
> > > using
> > > > > (System.Environment.MachineName) and I bounded the control to
> > > > > ttCallContextBpmData.Character01..
> > > > >
> > > > > Okay, i added another textbox2 and bounded the control to
> > > > > 'LaborHed.EmployeeNumName'.The purpose is, as soon as the employee
> name
> > > > > loaded, i want to trigger the below event
> > > > >
> > > > > Now under the textbox2.valuechanged event
> > > > >
> > > > > If len(textbox2.text) <> 0 then
> > > > > textbox1.text =
> > > (Replace(System.Environment.Machinename.ToString),"-","")
> > > > > End If
> > > > >
> > > > > ....
> > > > >
> > > > > the above logic failed(it shows the system name in the textbox1 and
> > > > > disappears immediately also not saving system name in the table(as
> it
> > > is
> > > > > bounded to ttCallContextBpmData.Character01)
> > > > >
> > > > > Could you please help in finding the right logic??
> > > > >
> > > > > Big thank you!
> > > > >
> > > > > #BuddingEpicorBuilder
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > > > > >
> > > > > > AHh i remember now, I stick the client name in the
> > > ttCallContextTable in
> > > > > a
> > > > > > Customization and get it on the BPM
> > > > > >
> > > > > >
> > > > > > *Jose C Gomez*
> > > > > > *Software Engineer*
> > > > > > *
> > > > > > *
> > > > > > *
> > > > > > *T: 904.469.1524 mobile
> > > > > > E: jose@
> > > > > > http://www.josecgomez.com
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > *Quis custodiet ipsos custodes?*
> > > > >
> > > > > >
> > > > > >
> > > > > > On Wed, Jan 9, 2013 at 9:27 AM, jyprksh@ wrote:
> > > > > >
> > > > > > > **
> > > > > > >
> > > > > > >
> > > > > > > Hi Jose,
> > > > > > >
> > > > > > > thank you very much for your suggestion. But, I am afraid I
> could
> > > find
> > > > > > > host pc name via context table.
> > > > > > >
> > > > > > > if you achieved this previously, can you please share the
> piece of
> > > ABL
> > > > > > > code?
> > > > > > >
> > > > > > > Cheers!
> > > > > > >
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > > > > > > >
> > > > > > > > If you are on e9 your context tables have that information
> > > > > > > > On Jan 9, 2013 4:55 AM, "jyprksh@" wrote:
> > > > > > > >
> > > > > > > > > **
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > We need to be able to update the LaborHed.Character01 field
> > > when
> > > > > > > someone
> > > > > > > > > Clocks In via MES with the CLIENT HOSTNAME (Client PC
> Name).
> > > > > > > > >
> > > > > > > > > We have successfully done this by using a Data Directive on
> > > > > LaborHed
> > > > > > > but
> > > > > > > > > sadly, given that the ABL runs server side, we are only
> able to
> > > > > input
> > > > > > > the
> > > > > > > > > Epicor9_ServerName.
> > > > > > > > >
> > > > > > > > > We can clearly obtain the System.Enviroment.MachineName
> using
> > > a C#
> > > > > / VB
> > > > > > > > > Customisation but not via a BPM / DataDirective / ABL.
> > > > > > > > >
> > > > > > > > > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > > > > > > > > find first laborhed where laborhed.Company = "MSIBR" AND
> > > > > > > > > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > > > > > > > > If AVAIL laborhed then Do:
> > > > > > > > > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > > > > > > > > END.
> > > > > > > > > END.
> > > > > > > > >
> > > > > > > > > Any help on achieving this would be great !
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > [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]
> >
>
>
>


[Non-text portions of this message have been removed]
2
We need to be able to update the LaborHed.Character01 field when someone Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).

We have successfully done this by using a Data Directive on LaborHed but sadly, given that the ABL runs server side, we are only able to input the Epicor9_ServerName.

We can clearly obtain the System.Enviroment.MachineName using a C# / VB Customisation but not via a BPM / DataDirective / ABL.

for each ttLaborHed where ttlaborhed.RowMod = 'A':
find first laborhed where laborhed.Company = "MSIBR" AND
laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
If AVAIL laborhed then Do:
ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
END.
END.

Any help on achieving this would be great !
3
If you are on e9 your context tables have that information
On Jan 9, 2013 4:55 AM, "jyprksh@..." <jyprksh@...> wrote:

> **
>
>
> We need to be able to update the LaborHed.Character01 field when someone
> Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
>
> We have successfully done this by using a Data Directive on LaborHed but
> sadly, given that the ABL runs server side, we are only able to input the
> Epicor9_ServerName.
>
> We can clearly obtain the System.Enviroment.MachineName using a C# / VB
> Customisation but not via a BPM / DataDirective / ABL.
>
> for each ttLaborHed where ttlaborhed.RowMod = 'A':
> find first laborhed where laborhed.Company = "MSIBR" AND
> laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> If AVAIL laborhed then Do:
> ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> END.
> END.
>
> Any help on achieving this would be great !
>
>
>


[Non-text portions of this message have been removed]
4
Have you tried some of the global variables?
CUR-COMP
CUR-COMP-NAME
CUR-WORKSTATIONID

On Wed, Jan 9, 2013 at 3:54 AM, jyprksh@... <jyprksh@...> wrote:

> **
>
>
> We need to be able to update the LaborHed.Character01 field when someone
> Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
>
> We have successfully done this by using a Data Directive on LaborHed but
> sadly, given that the ABL runs server side, we are only able to input the
> Epicor9_ServerName.
>
> We can clearly obtain the System.Enviroment.MachineName using a C# / VB
> Customisation but not via a BPM / DataDirective / ABL.
>
> for each ttLaborHed where ttlaborhed.RowMod = 'A':
> find first laborhed where laborhed.Company = "MSIBR" AND
> laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> If AVAIL laborhed then Do:
> ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> END.
> END.
>
> Any help on achieving this would be great !
>
>
>


[Non-text portions of this message have been removed]
5
Hi Scotty,

thanks for your suggestion. below is the result which i achieved via 4GL constants.

CUR-COMP RETURNS COMPANY NAME ( i.e 'MSIBR')
CUR-COMP-NAME RETURNS FULL COMPANY NAME (i.e MSI-Forks (Brazil))
CUR-WORKSTATIONID RETURNS NOTHING

Still looking for global variable which gives the host name!!


--- In vantage@yahoogroups.com, "Scotty K." wrote:
>
> Have you tried some of the global variables?
> CUR-COMP
> CUR-COMP-NAME
> CUR-WORKSTATIONID
>
> On Wed, Jan 9, 2013 at 3:54 AM, jyprksh@... wrote:
>
> > **
> >
> >
> > We need to be able to update the LaborHed.Character01 field when someone
> > Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
> >
> > We have successfully done this by using a Data Directive on LaborHed but
> > sadly, given that the ABL runs server side, we are only able to input the
> > Epicor9_ServerName.
> >
> > We can clearly obtain the System.Enviroment.MachineName using a C# / VB
> > Customisation but not via a BPM / DataDirective / ABL.
> >
> > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > find first laborhed where laborhed.Company = "MSIBR" AND
> > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > If AVAIL laborhed then Do:
> > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > END.
> > END.
> >
> > Any help on achieving this would be great !
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
6
Look in your CallContextTable.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Wed, Jan 9, 2013 at 9:24 AM, jyprksh@... <jyprksh@...> wrote:

> **
>
>
> Hi Scotty,
>
> thanks for your suggestion. below is the result which i achieved via 4GL
> constants.
>
> CUR-COMP RETURNS COMPANY NAME ( i.e 'MSIBR')
> CUR-COMP-NAME RETURNS FULL COMPANY NAME (i.e MSI-Forks (Brazil))
> CUR-WORKSTATIONID RETURNS NOTHING
>
> Still looking for global variable which gives the host name!!
>
>
> --- In vantage@yahoogroups.com, "Scotty K." wrote:
> >
> > Have you tried some of the global variables?
> > CUR-COMP
> > CUR-COMP-NAME
> > CUR-WORKSTATIONID
> >
> > On Wed, Jan 9, 2013 at 3:54 AM, jyprksh@... wrote:
> >
> > > **
> > >
> > >
> > > We need to be able to update the LaborHed.Character01 field when
> someone
> > > Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
> > >
> > > We have successfully done this by using a Data Directive on LaborHed
> but
> > > sadly, given that the ABL runs server side, we are only able to input
> the
> > > Epicor9_ServerName.
> > >
> > > We can clearly obtain the System.Enviroment.MachineName using a C# / VB
> > > Customisation but not via a BPM / DataDirective / ABL.
> > >
> > > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > > find first laborhed where laborhed.Company = "MSIBR" AND
> > > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > > If AVAIL laborhed then Do:
> > > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > > END.
> > > END.
> > >
> > > Any help on achieving this would be great !
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
7
Hi Jose,

thank you very much for your suggestion. But, I am afraid I could find host pc name via context table.

if you achieved this previously, can you please share the piece of ABL code?

Cheers!

--- In vantage@yahoogroups.com, Jose Gomez wrote:
>
> If you are on e9 your context tables have that information
> On Jan 9, 2013 4:55 AM, "jyprksh@..." wrote:
>
> > **
> >
> >
> > We need to be able to update the LaborHed.Character01 field when someone
> > Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
> >
> > We have successfully done this by using a Data Directive on LaborHed but
> > sadly, given that the ABL runs server side, we are only able to input the
> > Epicor9_ServerName.
> >
> > We can clearly obtain the System.Enviroment.MachineName using a C# / VB
> > Customisation but not via a BPM / DataDirective / ABL.
> >
> > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > find first laborhed where laborhed.Company = "MSIBR" AND
> > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > If AVAIL laborhed then Do:
> > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > END.
> > END.
> >
> > Any help on achieving this would be great !
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
8
AHh i remember now, I stick the client name in the ttCallContextTable in a
Customization and get it on the BPM


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Wed, Jan 9, 2013 at 9:27 AM, jyprksh@... <jyprksh@...> wrote:

> **
>
>
> Hi Jose,
>
> thank you very much for your suggestion. But, I am afraid I could find
> host pc name via context table.
>
> if you achieved this previously, can you please share the piece of ABL
> code?
>
> Cheers!
>
>
> --- In vantage@yahoogroups.com, Jose Gomez wrote:
> >
> > If you are on e9 your context tables have that information
> > On Jan 9, 2013 4:55 AM, "jyprksh@..." wrote:
> >
> > > **
> > >
> > >
> > > We need to be able to update the LaborHed.Character01 field when
> someone
> > > Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
> > >
> > > We have successfully done this by using a Data Directive on LaborHed
> but
> > > sadly, given that the ABL runs server side, we are only able to input
> the
> > > Epicor9_ServerName.
> > >
> > > We can clearly obtain the System.Enviroment.MachineName using a C# / VB
> > > Customisation but not via a BPM / DataDirective / ABL.
> > >
> > > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > > find first laborhed where laborhed.Company = "MSIBR" AND
> > > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > > If AVAIL laborhed then Do:
> > > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > > END.
> > > END.
> > >
> > > Any help on achieving this would be great !
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
9
Clever man, just curious, what event do you hang that on?

Sent from my Verizon Wireless 4G LTE DROID


Jose Gomez <jose@...> wrote:

AHh i remember now, I stick the client name in the ttCallContextTable in a
Customization and get it on the BPM


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Wed, Jan 9, 2013 at 9:27 AM, jyprksh@... <jyprksh@...> wrote:

> **
>
>
> Hi Jose,
>
> thank you very much for your suggestion. But, I am afraid I could find
> host pc name via context table.
>
> if you achieved this previously, can you please share the piece of ABL
> code?
>
> Cheers!
>
>
> --- In vantage@yahoogroups.com, Jose Gomez wrote:
> >
> > If you are on e9 your context tables have that information
> > On Jan 9, 2013 4:55 AM, "jyprksh@..." wrote:
> >
> > > **
> > >
> > >
> > > We need to be able to update the LaborHed.Character01 field when
> someone
> > > Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
> > >
> > > We have successfully done this by using a Data Directive on LaborHed
> but
> > > sadly, given that the ABL runs server side, we are only able to input
> the
> > > Epicor9_ServerName.
> > >
> > > We can clearly obtain the System.Enviroment.MachineName using a C# / VB
> > > Customisation but not via a BPM / DataDirective / ABL.
> > >
> > > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > > find first laborhed where laborhed.Company = "MSIBR" AND
> > > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > > If AVAIL laborhed then Do:
> > > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > > END.
> > > END.
> > >
> > > Any help on achieving this would be great !
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[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/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
10
On the Customization? I just do it on Notify of the Main DataView


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Wed, Jan 9, 2013 at 10:24 AM, Rob Bucek <rbucek@...> wrote:

> **
>
>
> Clever man, just curious, what event do you hang that on?
>
> Sent from my Verizon Wireless 4G LTE DROID
>
>
> Jose Gomez jose@...> wrote:
>
> AHh i remember now, I stick the client name in the ttCallContextTable in a
> Customization and get it on the BPM
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> http://www.linkedin.com/in/josecgomez> http://www.facebook.com/josegomez>
> http://www.google.com/profiles/jose.gomez> http://www.twitter.com/joc85>
> http://www.josecgomez.com/professional-resume/>
> http://www.josecgomez.com/feed/>
> http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Wed, Jan 9, 2013 at 9:27 AM, jyprksh@... jyprksh@...>
> wrote:
>
> > **
>
> >
> >
> > Hi Jose,
> >
> > thank you very much for your suggestion. But, I am afraid I could find
> > host pc name via context table.
> >
> > if you achieved this previously, can you please share the piece of ABL
> > code?
> >
> > Cheers!
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > >
> > > If you are on e9 your context tables have that information
> > > On Jan 9, 2013 4:55 AM, "jyprksh@..." wrote:
> > >
> > > > **
> > > >
> > > >
> > > > We need to be able to update the LaborHed.Character01 field when
> > someone
> > > > Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
> > > >
> > > > We have successfully done this by using a Data Directive on LaborHed
> > but
> > > > sadly, given that the ABL runs server side, we are only able to input
> > the
> > > > Epicor9_ServerName.
> > > >
> > > > We can clearly obtain the System.Enviroment.MachineName using a C# /
> VB
> > > > Customisation but not via a BPM / DataDirective / ABL.
> > > >
> > > > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > > > find first laborhed where laborhed.Company = "MSIBR" AND
> > > > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > > > If AVAIL laborhed then Do:
> > > > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > > > END.
> > > > END.
> > > >
> > > > Any help on achieving this would be great !
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
> [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/linksYahoo! Groups Links
>
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
11
Yes, that's what I was referring to, cool!

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084

(Click the logo to view our site)

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Wednesday, January 09, 2013 9:47 AM
To: Vantage
Subject: Re: [Vantage] Re: Update LaborHed.Character01 with Client PC HostName (ABL / 4GL)

On the Customization? I just do it on Notify of the Main DataView


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Wed, Jan 9, 2013 at 10:24 AM, Rob Bucek <rbucek@...> wrote:

> **
>
>
> Clever man, just curious, what event do you hang that on?
>
> Sent from my Verizon Wireless 4G LTE DROID
>
>
> Jose Gomez jose@...> wrote:
>
> AHh i remember now, I stick the client name in the ttCallContextTable
> in a Customization and get it on the BPM
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> http://www.linkedin.com/in/josecgomez>
> http://www.facebook.com/josegomez>
> http://www.google.com/profiles/jose.gomez>
> http://www.twitter.com/joc85>
> http://www.josecgomez.com/professional-resume/>
> http://www.josecgomez.com/feed/>
> http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Wed, Jan 9, 2013 at 9:27 AM, jyprksh@... jyprksh@...>
> wrote:
>
> > **
>
> >
> >
> > Hi Jose,
> >
> > thank you very much for your suggestion. But, I am afraid I could
> > find host pc name via context table.
> >
> > if you achieved this previously, can you please share the piece of
> > ABL code?
> >
> > Cheers!
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > >
> > > If you are on e9 your context tables have that information On Jan
> > > 9, 2013 4:55 AM, "jyprksh@..." wrote:
> > >
> > > > **
> > > >
> > > >
> > > > We need to be able to update the LaborHed.Character01 field when
> > someone
> > > > Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
> > > >
> > > > We have successfully done this by using a Data Directive on
> > > > LaborHed
> > but
> > > > sadly, given that the ABL runs server side, we are only able to
> > > > input
> > the
> > > > Epicor9_ServerName.
> > > >
> > > > We can clearly obtain the System.Enviroment.MachineName using a
> > > > C# /
> VB
> > > > Customisation but not via a BPM / DataDirective / ABL.
> > > >
> > > > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > > > find first laborhed where laborhed.Company = "MSIBR" AND
> > > > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > > > If AVAIL laborhed then Do:
> > > > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > > > END.
> > > > END.
> > > >
> > > > Any help on achieving this would be great !
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
> [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/linksYahoo! Groups Links
>
>
> [Non-text portions of this message have been removed]
>
>
>


[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/linksYahoo! Groups Links
12
Hi Jose,

Well, i dropped the textbox1 in the mes and showed the computer name using (System.Environment.MachineName) and I bounded the control to ttCallContextBpmData.Character01..

Okay, i added another textbox2 and bounded the control to 'LaborHed.EmployeeNumName'.The purpose is, as soon as the employee name loaded, i want to trigger the below event

Now under the textbox2.valuechanged event

If len(textbox2.text) <> 0 then
textbox1.text = (Replace(System.Environment.Machinename.ToString),"-","")
End If

....

the above logic failed(it shows the system name in the textbox1 and disappears immediately also not saving system name in the table(as it is bounded to ttCallContextBpmData.Character01)


Could you please help in finding the right logic??

Big thank you!

#BuddingEpicorBuilder

--- In vantage@yahoogroups.com, Jose Gomez wrote:
>
> AHh i remember now, I stick the client name in the ttCallContextTable in a
> Customization and get it on the BPM
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
>
>
>
>
>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Wed, Jan 9, 2013 at 9:27 AM, jyprksh@... wrote:
>
> > **
> >
> >
> > Hi Jose,
> >
> > thank you very much for your suggestion. But, I am afraid I could find
> > host pc name via context table.
> >
> > if you achieved this previously, can you please share the piece of ABL
> > code?
> >
> > Cheers!
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > >
> > > If you are on e9 your context tables have that information
> > > On Jan 9, 2013 4:55 AM, "jyprksh@" wrote:
> > >
> > > > **
> > > >
> > > >
> > > > We need to be able to update the LaborHed.Character01 field when
> > someone
> > > > Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
> > > >
> > > > We have successfully done this by using a Data Directive on LaborHed
> > but
> > > > sadly, given that the ABL runs server side, we are only able to input
> > the
> > > > Epicor9_ServerName.
> > > >
> > > > We can clearly obtain the System.Enviroment.MachineName using a C# / VB
> > > > Customisation but not via a BPM / DataDirective / ABL.
> > > >
> > > > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > > > find first laborhed where laborhed.Company = "MSIBR" AND
> > > > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > > > If AVAIL laborhed then Do:
> > > > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > > > END.
> > > > END.
> > > >
> > > > Any help on achieving this would be great !
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
13
Simply add a Notify Event to LaborHed -> Initialize
within here simply set txtCallContextBPMData.Character01 =
System.Environment.Machinename.ToString

Let me know if you need the actual code. And I'll write it up, but I am
feeling lazy today :-)


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Wed, Jan 9, 2013 at 11:46 AM, jyprksh@... <jyprksh@...>wrote:

> **
>
>
>
> Hi Jose,
>
> Well, i dropped the textbox1 in the mes and showed the computer name using
> (System.Environment.MachineName) and I bounded the control to
> ttCallContextBpmData.Character01..
>
> Okay, i added another textbox2 and bounded the control to
> 'LaborHed.EmployeeNumName'.The purpose is, as soon as the employee name
> loaded, i want to trigger the below event
>
> Now under the textbox2.valuechanged event
>
> If len(textbox2.text) <> 0 then
> textbox1.text = (Replace(System.Environment.Machinename.ToString),"-","")
> End If
>
> ....
>
> the above logic failed(it shows the system name in the textbox1 and
> disappears immediately also not saving system name in the table(as it is
> bounded to ttCallContextBpmData.Character01)
>
> Could you please help in finding the right logic??
>
> Big thank you!
>
> #BuddingEpicorBuilder
>
>
> --- In vantage@yahoogroups.com, Jose Gomez wrote:
> >
> > AHh i remember now, I stick the client name in the ttCallContextTable in
> a
> > Customization and get it on the BPM
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> >
> >
> >
> >
> >
> >
> > *Quis custodiet ipsos custodes?*
>
> >
> >
> > On Wed, Jan 9, 2013 at 9:27 AM, jyprksh@... wrote:
> >
> > > **
> > >
> > >
> > > Hi Jose,
> > >
> > > thank you very much for your suggestion. But, I am afraid I could find
> > > host pc name via context table.
> > >
> > > if you achieved this previously, can you please share the piece of ABL
> > > code?
> > >
> > > Cheers!
> > >
> > >
> > > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > > >
> > > > If you are on e9 your context tables have that information
> > > > On Jan 9, 2013 4:55 AM, "jyprksh@" wrote:
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > We need to be able to update the LaborHed.Character01 field when
> > > someone
> > > > > Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
> > > > >
> > > > > We have successfully done this by using a Data Directive on
> LaborHed
> > > but
> > > > > sadly, given that the ABL runs server side, we are only able to
> input
> > > the
> > > > > Epicor9_ServerName.
> > > > >
> > > > > We can clearly obtain the System.Enviroment.MachineName using a C#
> / VB
> > > > > Customisation but not via a BPM / DataDirective / ABL.
> > > > >
> > > > > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > > > > find first laborhed where laborhed.Company = "MSIBR" AND
> > > > > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > > > > If AVAIL laborhed then Do:
> > > > > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > > > > END.
> > > > > END.
> > > > >
> > > > > Any help on achieving this would be great !
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [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]
14
Fantastic Jose,

figured it out.. here is the piece of code:

Module level declaration:
Private WithEvents edvLaborHed As EpiDataView

Sub InitializeCustomCode()
Script.edvLaborHed=CType(Script.oTrans.EpiDataViews("LaborHed"),EpiDataView)
Addhandler Script.edvLaborHed.EpiViewNotification, AddressOf Script.edvLaborHed_EpiViewNotification

Sub DestroyCustomCode()
RemoveHandler Script.edvLaborHed.EpiViewNotification, AddressOf Script.edvLaborHed_EpiViewNotification
Script.edvLaborHed = Nothing


Private Sub edvLaborHed_EpiViewNotification(ByVal view As EpiDataView, ByVal args As EpiNotifyArgs)
If (args.NotifyType = EpiTransaction.NotifyType.Initialize) Then
If (args.Row > -1) Then
edvLaborHed.dataView(edvLaborHed.Row).BeginEdit()
edvLaborHed.dataView(edvLaborHed.Row)("Character01") = System.Environment.Machinename.ToString edvLaborHed.dataView(edvLaborHed.Row).EndEdit()
End If
End If
End Sub

Big thanks all!!

--- In vantage@yahoogroups.com, Jose Gomez wrote:
>
> Simply add a Notify Event to LaborHed -> Initialize
> within here simply set txtCallContextBPMData.Character01 =
> System.Environment.Machinename.ToString
>
> Let me know if you need the actual code. And I'll write it up, but I am
> feeling lazy today :-)
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
>
>
>
>
>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Wed, Jan 9, 2013 at 11:46 AM, jyprksh@... wrote:
>
> > **
> >
> >
> >
> > Hi Jose,
> >
> > Well, i dropped the textbox1 in the mes and showed the computer name using
> > (System.Environment.MachineName) and I bounded the control to
> > ttCallContextBpmData.Character01..
> >
> > Okay, i added another textbox2 and bounded the control to
> > 'LaborHed.EmployeeNumName'.The purpose is, as soon as the employee name
> > loaded, i want to trigger the below event
> >
> > Now under the textbox2.valuechanged event
> >
> > If len(textbox2.text) <> 0 then
> > textbox1.text = (Replace(System.Environment.Machinename.ToString),"-","")
> > End If
> >
> > ....
> >
> > the above logic failed(it shows the system name in the textbox1 and
> > disappears immediately also not saving system name in the table(as it is
> > bounded to ttCallContextBpmData.Character01)
> >
> > Could you please help in finding the right logic??
> >
> > Big thank you!
> >
> > #BuddingEpicorBuilder
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > >
> > > AHh i remember now, I stick the client name in the ttCallContextTable in
> > a
> > > Customization and get it on the BPM
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@
> > > http://www.josecgomez.com
> > >
> > >
> > >
> > >
> > >
> > >
> > > *Quis custodiet ipsos custodes?*
> >
> > >
> > >
> > > On Wed, Jan 9, 2013 at 9:27 AM, jyprksh@ wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Hi Jose,
> > > >
> > > > thank you very much for your suggestion. But, I am afraid I could find
> > > > host pc name via context table.
> > > >
> > > > if you achieved this previously, can you please share the piece of ABL
> > > > code?
> > > >
> > > > Cheers!
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > > > >
> > > > > If you are on e9 your context tables have that information
> > > > > On Jan 9, 2013 4:55 AM, "jyprksh@" wrote:
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > We need to be able to update the LaborHed.Character01 field when
> > > > someone
> > > > > > Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
> > > > > >
> > > > > > We have successfully done this by using a Data Directive on
> > LaborHed
> > > > but
> > > > > > sadly, given that the ABL runs server side, we are only able to
> > input
> > > > the
> > > > > > Epicor9_ServerName.
> > > > > >
> > > > > > We can clearly obtain the System.Enviroment.MachineName using a C#
> > / VB
> > > > > > Customisation but not via a BPM / DataDirective / ABL.
> > > > > >
> > > > > > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > > > > > find first laborhed where laborhed.Company = "MSIBR" AND
> > > > > > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > > > > > If AVAIL laborhed then Do:
> > > > > > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > > > > > END.
> > > > > > END.
> > > > > >
> > > > > > Any help on achieving this would be great !
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [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]
>
15
Only comment would be that I would set Character01 on BPMDataTable instead
of laborhead as to not waste a field



*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Wed, Jan 9, 2013 at 12:17 PM, jyprksh@... <jyprksh@...>wrote:

> **
>
>
> Fantastic Jose,
>
> figured it out.. here is the piece of code:
>
> Module level declaration:
> Private WithEvents edvLaborHed As EpiDataView
>
> Sub InitializeCustomCode()
>
> Script.edvLaborHed=CType(Script.oTrans.EpiDataViews("LaborHed"),EpiDataView)
> Addhandler Script.edvLaborHed.EpiViewNotification, AddressOf
> Script.edvLaborHed_EpiViewNotification
>
> Sub DestroyCustomCode()
> RemoveHandler Script.edvLaborHed.EpiViewNotification, AddressOf
> Script.edvLaborHed_EpiViewNotification
> Script.edvLaborHed = Nothing
>
> Private Sub edvLaborHed_EpiViewNotification(ByVal view As EpiDataView,
> ByVal args As EpiNotifyArgs)
> If (args.NotifyType = EpiTransaction.NotifyType.Initialize) Then
> If (args.Row > -1) Then
> edvLaborHed.dataView(edvLaborHed.Row).BeginEdit()
> edvLaborHed.dataView(edvLaborHed.Row)("Character01") =
> System.Environment.Machinename.ToString
> edvLaborHed.dataView(edvLaborHed.Row).EndEdit()
> End If
> End If
> End Sub
>
> Big thanks all!!
>
> --- In vantage@yahoogroups.com, Jose Gomez wrote:
> >
> > Simply add a Notify Event to LaborHed -> Initialize
> > within here simply set txtCallContextBPMData.Character01 =
> > System.Environment.Machinename.ToString
> >
> > Let me know if you need the actual code. And I'll write it up, but I am
> > feeling lazy today :-)
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> >
> >
> >
> >
> >
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Wed, Jan 9, 2013 at 11:46 AM, jyprksh@... wrote:
> >
> > > **
> > >
> > >
> > >
> > > Hi Jose,
> > >
> > > Well, i dropped the textbox1 in the mes and showed the computer name
> using
> > > (System.Environment.MachineName) and I bounded the control to
> > > ttCallContextBpmData.Character01..
> > >
> > > Okay, i added another textbox2 and bounded the control to
> > > 'LaborHed.EmployeeNumName'.The purpose is, as soon as the employee name
> > > loaded, i want to trigger the below event
> > >
> > > Now under the textbox2.valuechanged event
> > >
> > > If len(textbox2.text) <> 0 then
> > > textbox1.text =
> (Replace(System.Environment.Machinename.ToString),"-","")
> > > End If
> > >
> > > ....
> > >
> > > the above logic failed(it shows the system name in the textbox1 and
> > > disappears immediately also not saving system name in the table(as it
> is
> > > bounded to ttCallContextBpmData.Character01)
> > >
> > > Could you please help in finding the right logic??
> > >
> > > Big thank you!
> > >
> > > #BuddingEpicorBuilder
> > >
> > >
> > > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > > >
> > > > AHh i remember now, I stick the client name in the
> ttCallContextTable in
> > > a
> > > > Customization and get it on the BPM
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *T: 904.469.1524 mobile
> > > > E: jose@
> > > > http://www.josecgomez.com
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > >
> > > >
> > > >
> > > > On Wed, Jan 9, 2013 at 9:27 AM, jyprksh@ wrote:
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > Hi Jose,
> > > > >
> > > > > thank you very much for your suggestion. But, I am afraid I could
> find
> > > > > host pc name via context table.
> > > > >
> > > > > if you achieved this previously, can you please share the piece of
> ABL
> > > > > code?
> > > > >
> > > > > Cheers!
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > > > > >
> > > > > > If you are on e9 your context tables have that information
> > > > > > On Jan 9, 2013 4:55 AM, "jyprksh@" wrote:
> > > > > >
> > > > > > > **
> > > > > > >
> > > > > > >
> > > > > > > We need to be able to update the LaborHed.Character01 field
> when
> > > > > someone
> > > > > > > Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
> > > > > > >
> > > > > > > We have successfully done this by using a Data Directive on
> > > LaborHed
> > > > > but
> > > > > > > sadly, given that the ABL runs server side, we are only able to
> > > input
> > > > > the
> > > > > > > Epicor9_ServerName.
> > > > > > >
> > > > > > > We can clearly obtain the System.Enviroment.MachineName using
> a C#
> > > / VB
> > > > > > > Customisation but not via a BPM / DataDirective / ABL.
> > > > > > >
> > > > > > > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > > > > > > find first laborhed where laborhed.Company = "MSIBR" AND
> > > > > > > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > > > > > > If AVAIL laborhed then Do:
> > > > > > > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > > > > > > END.
> > > > > > > END.
> > > > > > >
> > > > > > > Any help on achieving this would be great !
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > [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]
16
I take your advice Jose!..

but, i I could not find the BPMDataTable in the SQLServer 2008 database. How can i find the right information is stored?

Please brief me about BPMDataTable..
Apologize if it is dumb question!!
#Epicor9 #EpicorNovice

--- In vantage@yahoogroups.com, Jose Gomez wrote:
>
> Only comment would be that I would set Character01 on BPMDataTable instead
> of laborhead as to not waste a field
>
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
>
>
>
>
>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Wed, Jan 9, 2013 at 12:17 PM, jyprksh@... wrote:
>
> > **
> >
> >
> > Fantastic Jose,
> >
> > figured it out.. here is the piece of code:
> >
> > Module level declaration:
> > Private WithEvents edvLaborHed As EpiDataView
> >
> > Sub InitializeCustomCode()
> >
> > Script.edvLaborHed=CType(Script.oTrans.EpiDataViews("LaborHed"),EpiDataView)
> > Addhandler Script.edvLaborHed.EpiViewNotification, AddressOf
> > Script.edvLaborHed_EpiViewNotification
> >
> > Sub DestroyCustomCode()
> > RemoveHandler Script.edvLaborHed.EpiViewNotification, AddressOf
> > Script.edvLaborHed_EpiViewNotification
> > Script.edvLaborHed = Nothing
> >
> > Private Sub edvLaborHed_EpiViewNotification(ByVal view As EpiDataView,
> > ByVal args As EpiNotifyArgs)
> > If (args.NotifyType = EpiTransaction.NotifyType.Initialize) Then
> > If (args.Row > -1) Then
> > edvLaborHed.dataView(edvLaborHed.Row).BeginEdit()
> > edvLaborHed.dataView(edvLaborHed.Row)("Character01") =
> > System.Environment.Machinename.ToString
> > edvLaborHed.dataView(edvLaborHed.Row).EndEdit()
> > End If
> > End If
> > End Sub
> >
> > Big thanks all!!
> >
> > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > >
> > > Simply add a Notify Event to LaborHed -> Initialize
> > > within here simply set txtCallContextBPMData.Character01 =
> > > System.Environment.Machinename.ToString
> > >
> > > Let me know if you need the actual code. And I'll write it up, but I am
> > > feeling lazy today :-)
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@
> > > http://www.josecgomez.com
> > >
> > >
> > >
> > >
> > >
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > > On Wed, Jan 9, 2013 at 11:46 AM, jyprksh@ wrote:
> > >
> > > > **
> > > >
> > > >
> > > >
> > > > Hi Jose,
> > > >
> > > > Well, i dropped the textbox1 in the mes and showed the computer name
> > using
> > > > (System.Environment.MachineName) and I bounded the control to
> > > > ttCallContextBpmData.Character01..
> > > >
> > > > Okay, i added another textbox2 and bounded the control to
> > > > 'LaborHed.EmployeeNumName'.The purpose is, as soon as the employee name
> > > > loaded, i want to trigger the below event
> > > >
> > > > Now under the textbox2.valuechanged event
> > > >
> > > > If len(textbox2.text) <> 0 then
> > > > textbox1.text =
> > (Replace(System.Environment.Machinename.ToString),"-","")
> > > > End If
> > > >
> > > > ....
> > > >
> > > > the above logic failed(it shows the system name in the textbox1 and
> > > > disappears immediately also not saving system name in the table(as it
> > is
> > > > bounded to ttCallContextBpmData.Character01)
> > > >
> > > > Could you please help in finding the right logic??
> > > >
> > > > Big thank you!
> > > >
> > > > #BuddingEpicorBuilder
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > > > >
> > > > > AHh i remember now, I stick the client name in the
> > ttCallContextTable in
> > > > a
> > > > > Customization and get it on the BPM
> > > > >
> > > > >
> > > > > *Jose C Gomez*
> > > > > *Software Engineer*
> > > > > *
> > > > > *
> > > > > *
> > > > > *T: 904.469.1524 mobile
> > > > > E: jose@
> > > > > http://www.josecgomez.com
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > *Quis custodiet ipsos custodes?*
> > > >
> > > > >
> > > > >
> > > > > On Wed, Jan 9, 2013 at 9:27 AM, jyprksh@ wrote:
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > Hi Jose,
> > > > > >
> > > > > > thank you very much for your suggestion. But, I am afraid I could
> > find
> > > > > > host pc name via context table.
> > > > > >
> > > > > > if you achieved this previously, can you please share the piece of
> > ABL
> > > > > > code?
> > > > > >
> > > > > > Cheers!
> > > > > >
> > > > > >
> > > > > > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > > > > > >
> > > > > > > If you are on e9 your context tables have that information
> > > > > > > On Jan 9, 2013 4:55 AM, "jyprksh@" wrote:
> > > > > > >
> > > > > > > > **
> > > > > > > >
> > > > > > > >
> > > > > > > > We need to be able to update the LaborHed.Character01 field
> > when
> > > > > > someone
> > > > > > > > Clocks In via MES with the CLIENT HOSTNAME (Client PC Name).
> > > > > > > >
> > > > > > > > We have successfully done this by using a Data Directive on
> > > > LaborHed
> > > > > > but
> > > > > > > > sadly, given that the ABL runs server side, we are only able to
> > > > input
> > > > > > the
> > > > > > > > Epicor9_ServerName.
> > > > > > > >
> > > > > > > > We can clearly obtain the System.Enviroment.MachineName using
> > a C#
> > > > / VB
> > > > > > > > Customisation but not via a BPM / DataDirective / ABL.
> > > > > > > >
> > > > > > > > for each ttLaborHed where ttlaborhed.RowMod = 'A':
> > > > > > > > find first laborhed where laborhed.Company = "MSIBR" AND
> > > > > > > > laborhed.EmployeeNum = ttlaborhed.EmployeeNum No-ERROR.
> > > > > > > > If AVAIL laborhed then Do:
> > > > > > > > ASSIGN ttlaborhed.Character01 = OS-GETENV("COMPUTERNAME").
> > > > > > > > END.
> > > > > > > > END.
> > > > > > > >
> > > > > > > > Any help on achieving this would be great !
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [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]
>