BL Tester Blank Title 87399

Can anyone share BL Tester for 64-bit environment from E9? I would like to give it ago with out Vantage.

Cheers,
Mark

--- In vantage@yahoogroups.com, "snielsen28" wrote:
>
> I finally got around to opening my Epicor 9 CDs. I installed the BL Tester on my 64-bit workstation and our 64-bit server, pointed them to our Vantage database and it works! Thanks for the tip, I don't think I'd have thought of trying that:)
>
> Sue
>
> --- In vantage@yahoogroups.com, "bw2868bond" wrote:
> >
> > I have found that the E9 BL Tester works with V8.03.405a
> >
> > --- In vantage@yahoogroups.com, "snielsen28" wrote:
> > >
> > > I put in a support call to Epicor on this. I tried a number of the tech's suggestions and ended up doing a WebEx with tech support. The conclusion was that BL Tester was not compatible with win 7 64 bit. We already guessed that, but now it's "official"! The tech also told me that there was a new BL Tester for Epicor 9 that was compatible with Windows 7 64-bit. Maybe an Epicor 9 user can verify that for us. The workaround for Vantage is to run BL Tester from a 32 bit machine. In my case, I either remote log on to the server and run it from there or fire up an old XP machine in my office.
> > >
> > > Sue
> > >
> > > --- In vantage@yahoogroups.com, "bw2868bond" wrote:
> > > >
> > > > I 'discovered' the BLTester win 64 problem a year ago - I have deduced that the program relies on a communication dll file that is not there or is substantially changed from WinXPx32 or Server2003x32 - I figure that finding the correct dll and putting it in the same folder as the BLTester exe file might fix it, but I have not gotten to finding it yet....
> > > >
> > > > If you do resolve this, kindly post to the group what the solution is...
> > > >
> > > > bw
> > > >
> > > > --- In vantage@yahoogroups.com, Bill Wu wrote:
> > > > >
> > > > > My computer is upgraded to win7 (64bit version). BL Tester stops working. It will run but when you open a BO, it says "Login failed: The system cannot find the file specified....". Anyone can help? We are on Vantage 803.407
> > > > >
> > > > > Thanks in advance.
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > >
> >
>
Does anyone know how to write to the LaborDtl table? I have a variable with a string value and I need to store it in the Character01 user field in the LaborDtl table. Someone mentioned an update function but the syntax has my head spinning.

Thanks in advance,
Jeff Sanders
Bernie provided this to me some time ago.

Hope this helps.

The UpdateTableBuffer was covered in the Epicor Tools Users Guide

And from help:


Update Table Buffer




Use the Update Table Buffer program to assign a value to a table field from
outside of a particular window. This program is useful when you want to
connect the entries in one field to the entry in another field,
automatically.

For example, you may want a Product Configurator input to update another,
existing value as part of an OnLeave expression for a field. Use this
program to perform such an update.


Syntax


Use the following syntax for this program:

Run lib\UpdateTableBuffer.p(input BUFFER <Table>:HANDLE, '<Field>',<Value>)

The entire statement should fit on one line.


Description of Parameters


Replace the terms in caret marks <> as follows:


<Parameter>

Meaning


Table

The table that has the field to be updated


Field

The field to be updated


Value

The value that the field should hold.



The value could be a literal term (for example, 123) or it could be a named
input from Product Configurator or a custom program.


Example


An order line should specify OurConfiguredPart as the part number. An input
on the configuration screen should specify the quantity. The goal is to have
the Quantity field on the configuration screen update the Quantity field on
Sales Order Line Entry (which is OrderDtl.OrderQty).

Specify the Quantity input as usual on the Detail tab in Product
Configurator Inputs. Then, on the OnLeave tab, enter the following logic:

Some of the words in the code are bracketed. Do not enter them yourself.
They are in this help topic only as comment.

[These first four lines declare and assign the current order and line
numbers to variables]
def var OrderNum as integer.
def var OrderLine as integer.

OrderNum = GetCurrentOrderNum().
OrderLine = GetCurrentOrderLine().

[This if statement validates that the update instruction is done for the
company, order number and line with this input]

If OrderNum > 0 and OrderLine > 0 then do:
Find OrderDtl where OrderDtl.Company = "VN10T" and Orderdtl.OrderNum =
OrderNum and OrderDtl.OrderLine = OrderLine no-lock no-error.

[And then perform the update with the value entered in the input]
Run lib\UpdateTableBuffer.p(input BUFFER OrderDtl:HANDLE, 'OrderQty',
Quantity).

End.

The buffer handle statement passes the instance of the table name to the
table record that was retrieved from the Find statement in the previous
statement.

The result of this example is that when OurConfiguredPart is entered on an
order line, and the part is Configured, the Quantity input will accept a
number (for example, 100). When that screen is closed, and the user returns
to the Sales Order Line Entry window, the standard Quantity field also will
show 100.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jeffery_p_sanders
Sent: Tuesday, February 09, 2010 9:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MES Customization via Visual Basic





Does anyone know how to write to the LaborDtl table? I have a variable with
a string value and I need to store it in the Character01 user field in the
LaborDtl table. Someone mentioned an update function but the syntax has my
head spinning.

Thanks in advance,
Jeff Sanders





[Non-text portions of this message have been removed]
Sorry about the previous post - misunderstood.



If you're doing this through VB then you'll be going through the method
calls, not directly against the database. To determine what is called, it
might help to turn on the tracing. This will produce an XML file that you
can then look at to get more details about the methods being called and in
what order.



You'll need to get the dataset first using the GetList method call (or get
new if creating a record). This will return your dataset that you can then
update as needed. You'll then execute the Update method call passing in the
dataset.



Here is an example that I did involving the UD table as a rough outline of
the steps.



You have to make sure you add the custom assemblies to the customization.

This will create a new record with watever variable you use and then
populate the character01 with whatever you want.



Dim udAdapter As UD03Adapter = New UD03Adapter(ReceiptEntryForm)
Dim udConnected As Boolean = udAdapter.BOConnect()
Dim newUD03 As Boolean = udAdapter.GetaNewUD03()
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key1") = variable
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key2") = String.Empty
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key3") = String.Empty
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key4") = String.Empty
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key5") = String.Empty
udAdapter.UD03Data.Tables("UD03").Rows(0)("Character01") = """"""
udAdapter.Update()

This will let you read the data from UD01 table
Dim ud01Adapt As UD01Adapter = New UD01Adapter(CustShipForm)
ud01Adapt.BOConnect()
Dim key1 As String = TBLot.ToString()
Dim key2 As String = String.Empty
Dim key3 As String = String.Empty
Dim key4 As String = String.Empty
Dim key5 As String = String.Empty
Dim UD01 As Boolean = ud01Adapt.GetByID(key1, key2, key3, key4,
key5)
If UD01 Then variable =
UD01Adapt.UD01Data.Tables("UD01").Rows(0)("CheckBox10")
ud01Adapt.dispose()





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jeffery_p_sanders
Sent: Tuesday, February 09, 2010 9:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MES Customization via Visual Basic





Does anyone know how to write to the LaborDtl table? I have a variable with
a string value and I need to store it in the Character01 user field in the
LaborDtl table. Someone mentioned an update function but the syntax has my
head spinning.

Thanks in advance,
Jeff Sanders





[Non-text portions of this message have been removed]
If you can, use the Method Viewer. V9 ships this, but I believe in V8 you
need to get this separately.

With this tool you can use the business objects directly, seeing the data
returned, execute updates, etc. I have found this incredibly useful as you
can run through what needs to happen and then program accordingly.



From: Sean McDaniel [mailto:smcdanie@...]
Sent: Tuesday, February 09, 2010 9:55 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] MES Customization via Visual Basic



Sorry about the previous post - misunderstood.



If you're doing this through VB then you'll be going through the method
calls, not directly against the database. To determine what is called, it
might help to turn on the tracing. This will produce an XML file that you
can then look at to get more details about the methods being called and in
what order.



You'll need to get the dataset first using the GetList method call (or get
new if creating a record). This will return your dataset that you can then
update as needed. You'll then execute the Update method call passing in the
dataset.



Here is an example that I did involving the UD table as a rough outline of
the steps.



You have to make sure you add the custom assemblies to the customization.

This will create a new record with watever variable you use and then
populate the character01 with whatever you want.

Dim udAdapter As UD03Adapter = New UD03Adapter(ReceiptEntryForm)
Dim udConnected As Boolean = udAdapter.BOConnect()
Dim newUD03 As Boolean = udAdapter.GetaNewUD03()
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key1") = variable
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key2") = String.Empty
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key3") = String.Empty
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key4") = String.Empty
udAdapter.UD03Data.Tables("UD03").Rows(0)("Key5") = String.Empty
udAdapter.UD03Data.Tables("UD03").Rows(0)("Character01") = """"""
udAdapter.Update()

This will let you read the data from UD01 table
Dim ud01Adapt As UD01Adapter = New UD01Adapter(CustShipForm)
ud01Adapt.BOConnect()
Dim key1 As String = TBLot.ToString()
Dim key2 As String = String.Empty
Dim key3 As String = String.Empty
Dim key4 As String = String.Empty
Dim key5 As String = String.Empty
Dim UD01 As Boolean = ud01Adapt.GetByID(key1, key2, key3, key4,
key5)
If UD01 Then variable =
UD01Adapt.UD01Data.Tables("UD01").Rows(0)("CheckBox10")
ud01Adapt.dispose()





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jeffery_p_sanders
Sent: Tuesday, February 09, 2010 9:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MES Customization via Visual Basic





Does anyone know how to write to the LaborDtl table? I have a variable with
a string value and I need to store it in the Character01 user field in the
LaborDtl table. Someone mentioned an update function but the syntax has my
head spinning.

Thanks in advance,
Jeff Sanders





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

Thanks for the information. I tried different variations of this but I am not experienced enough to work my way through the syntax and/or prodedures to get this working. Would you mind taking a look at it? I don't want to take up your time but if I can get this straight it will help tremendously.

I will add a file (txt file) to the Files section or I could send it to you in an email. Please let me know if you have time.

Thanks,
Jeff Sanders


--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@...> wrote:
>
> Sorry about the previous post - misunderstood.
>
>
>
> If you're doing this through VB then you'll be going through the method
> calls, not directly against the database. To determine what is called, it
> might help to turn on the tracing. This will produce an XML file that you
> can then look at to get more details about the methods being called and in
> what order.
>
>
>
> You'll need to get the dataset first using the GetList method call (or get
> new if creating a record). This will return your dataset that you can then
> update as needed. You'll then execute the Update method call passing in the
> dataset.
>
>
>
> Here is an example that I did involving the UD table as a rough outline of
> the steps.
>
>
>
> You have to make sure you add the custom assemblies to the customization.
>
> This will create a new record with watever variable you use and then
> populate the character01 with whatever you want.
>
>
>
> Dim udAdapter As UD03Adapter = New UD03Adapter(ReceiptEntryForm)
> Dim udConnected As Boolean = udAdapter.BOConnect()
> Dim newUD03 As Boolean = udAdapter.GetaNewUD03()
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key1") = variable
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key2") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key3") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key4") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key5") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Character01") = """"""
> udAdapter.Update()
>
> This will let you read the data from UD01 table
> Dim ud01Adapt As UD01Adapter = New UD01Adapter(CustShipForm)
> ud01Adapt.BOConnect()
> Dim key1 As String = TBLot.ToString()
> Dim key2 As String = String.Empty
> Dim key3 As String = String.Empty
> Dim key4 As String = String.Empty
> Dim key5 As String = String.Empty
> Dim UD01 As Boolean = ud01Adapt.GetByID(key1, key2, key3, key4,
> key5)
> If UD01 Then variable =
> UD01Adapt.UD01Data.Tables("UD01").Rows(0)("CheckBox10")
> ud01Adapt.dispose()
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> jeffery_p_sanders
> Sent: Tuesday, February 09, 2010 9:40 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] MES Customization via Visual Basic
>
>
>
>
>
> Does anyone know how to write to the LaborDtl table? I have a variable with
> a string value and I need to store it in the Character01 user field in the
> LaborDtl table. Someone mentioned an update function but the syntax has my
> head spinning.
>
> Thanks in advance,
> Jeff Sanders
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Where is the method viewer? I have V9.

--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@...> wrote:
>
> If you can, use the Method Viewer. V9 ships this, but I believe in V8 you
> need to get this separately.
>
> With this tool you can use the business objects directly, seeing the data
> returned, execute updates, etc. I have found this incredibly useful as you
> can run through what needs to happen and then program accordingly.
>
>
>
> From: Sean McDaniel [mailto:smcdanie@...]
> Sent: Tuesday, February 09, 2010 9:55 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] MES Customization via Visual Basic
>
>
>
> Sorry about the previous post - misunderstood.
>
>
>
> If you're doing this through VB then you'll be going through the method
> calls, not directly against the database. To determine what is called, it
> might help to turn on the tracing. This will produce an XML file that you
> can then look at to get more details about the methods being called and in
> what order.
>
>
>
> You'll need to get the dataset first using the GetList method call (or get
> new if creating a record). This will return your dataset that you can then
> update as needed. You'll then execute the Update method call passing in the
> dataset.
>
>
>
> Here is an example that I did involving the UD table as a rough outline of
> the steps.
>
>
>
> You have to make sure you add the custom assemblies to the customization.
>
> This will create a new record with watever variable you use and then
> populate the character01 with whatever you want.
>
> Dim udAdapter As UD03Adapter = New UD03Adapter(ReceiptEntryForm)
> Dim udConnected As Boolean = udAdapter.BOConnect()
> Dim newUD03 As Boolean = udAdapter.GetaNewUD03()
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key1") = variable
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key2") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key3") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key4") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key5") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Character01") = """"""
> udAdapter.Update()
>
> This will let you read the data from UD01 table
> Dim ud01Adapt As UD01Adapter = New UD01Adapter(CustShipForm)
> ud01Adapt.BOConnect()
> Dim key1 As String = TBLot.ToString()
> Dim key2 As String = String.Empty
> Dim key3 As String = String.Empty
> Dim key4 As String = String.Empty
> Dim key5 As String = String.Empty
> Dim UD01 As Boolean = ud01Adapt.GetByID(key1, key2, key3, key4,
> key5)
> If UD01 Then variable =
> UD01Adapt.UD01Data.Tables("UD01").Rows(0)("CheckBox10")
> ud01Adapt.dispose()
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> jeffery_p_sanders
> Sent: Tuesday, February 09, 2010 9:40 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] MES Customization via Visual Basic
>
>
>
>
>
> Does anyone know how to write to the LaborDtl table? I have a variable with
> a string value and I need to store it in the Character01 user field in the
> LaborDtl table. Someone mentioned an update function but the syntax has my
> head spinning.
>
> Thanks in advance,
> Jeff Sanders
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
The correct name (my mistake) is the BL Tester.

Try this.

C:\Program Files\Epicor Software\BL Tester for 8.03 (.Net 2.0 Edition)\



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jeffery_p_sanders
Sent: Tuesday, February 09, 2010 11:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: MES Customization via Visual Basic





Where is the method viewer? I have V9.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
McDaniel" <smcdanie@...> wrote:
>
> If you can, use the Method Viewer. V9 ships this, but I believe in V8 you
> need to get this separately.
>
> With this tool you can use the business objects directly, seeing the data
> returned, execute updates, etc. I have found this incredibly useful as you
> can run through what needs to happen and then program accordingly.
>
>
>
> From: Sean McDaniel [mailto:smcdanie@...]
> Sent: Tuesday, February 09, 2010 9:55 AM
> To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com> '
> Subject: RE: [Vantage] MES Customization via Visual Basic
>
>
>
> Sorry about the previous post - misunderstood.
>
>
>
> If you're doing this through VB then you'll be going through the method
> calls, not directly against the database. To determine what is called, it
> might help to turn on the tracing. This will produce an XML file that you
> can then look at to get more details about the methods being called and in
> what order.
>
>
>
> You'll need to get the dataset first using the GetList method call (or get
> new if creating a record). This will return your dataset that you can then
> update as needed. You'll then execute the Update method call passing in
the
> dataset.
>
>
>
> Here is an example that I did involving the UD table as a rough outline of
> the steps.
>
>
>
> You have to make sure you add the custom assemblies to the customization.
>
> This will create a new record with watever variable you use and then
> populate the character01 with whatever you want.
>
> Dim udAdapter As UD03Adapter = New UD03Adapter(ReceiptEntryForm)
> Dim udConnected As Boolean = udAdapter.BOConnect()
> Dim newUD03 As Boolean = udAdapter.GetaNewUD03()
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key1") = variable
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key2") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key3") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key4") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key5") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Character01") = """"""
> udAdapter.Update()
>
> This will let you read the data from UD01 table
> Dim ud01Adapt As UD01Adapter = New UD01Adapter(CustShipForm)
> ud01Adapt.BOConnect()
> Dim key1 As String = TBLot.ToString()
> Dim key2 As String = String.Empty
> Dim key3 As String = String.Empty
> Dim key4 As String = String.Empty
> Dim key5 As String = String.Empty
> Dim UD01 As Boolean = ud01Adapt.GetByID(key1, key2, key3, key4,
> key5)
> If UD01 Then variable =
> UD01Adapt.UD01Data.Tables("UD01").Rows(0)("CheckBox10")
> ud01Adapt.dispose()
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> jeffery_p_sanders
> Sent: Tuesday, February 09, 2010 9:40 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] MES Customization via Visual Basic
>
>
>
>
>
> Does anyone know how to write to the LaborDtl table? I have a variable
with
> a string value and I need to store it in the Character01 user field in the
> LaborDtl table. Someone mentioned an update function but the syntax has my
> head spinning.
>
> Thanks in advance,
> Jeff Sanders
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
smcdaniel@... or smcdanie@...

I'd be happy to see if I can help.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jeffery_p_sanders
Sent: Tuesday, February 09, 2010 10:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: MES Customization via Visual Basic





Sean,

Thanks for the information. I tried different variations of this but I am
not experienced enough to work my way through the syntax and/or prodedures
to get this working. Would you mind taking a look at it? I don't want to
take up your time but if I can get this straight it will help tremendously.

I will add a file (txt file) to the Files section or I could send it to you
in an email. Please let me know if you have time.

Thanks,
Jeff Sanders

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
McDaniel" <smcdanie@...> wrote:
>
> Sorry about the previous post - misunderstood.
>
>
>
> If you're doing this through VB then you'll be going through the method
> calls, not directly against the database. To determine what is called, it
> might help to turn on the tracing. This will produce an XML file that you
> can then look at to get more details about the methods being called and in
> what order.
>
>
>
> You'll need to get the dataset first using the GetList method call (or get
> new if creating a record). This will return your dataset that you can then
> update as needed. You'll then execute the Update method call passing in
the
> dataset.
>
>
>
> Here is an example that I did involving the UD table as a rough outline of
> the steps.
>
>
>
> You have to make sure you add the custom assemblies to the customization.
>
> This will create a new record with watever variable you use and then
> populate the character01 with whatever you want.
>
>
>
> Dim udAdapter As UD03Adapter = New UD03Adapter(ReceiptEntryForm)
> Dim udConnected As Boolean = udAdapter.BOConnect()
> Dim newUD03 As Boolean = udAdapter.GetaNewUD03()
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key1") = variable
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key2") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key3") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key4") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key5") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Character01") = """"""
> udAdapter.Update()
>
> This will let you read the data from UD01 table
> Dim ud01Adapt As UD01Adapter = New UD01Adapter(CustShipForm)
> ud01Adapt.BOConnect()
> Dim key1 As String = TBLot.ToString()
> Dim key2 As String = String.Empty
> Dim key3 As String = String.Empty
> Dim key4 As String = String.Empty
> Dim key5 As String = String.Empty
> Dim UD01 As Boolean = ud01Adapt.GetByID(key1, key2, key3, key4,
> key5)
> If UD01 Then variable =
> UD01Adapt.UD01Data.Tables("UD01").Rows(0)("CheckBox10")
> ud01Adapt.dispose()
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> jeffery_p_sanders
> Sent: Tuesday, February 09, 2010 9:40 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] MES Customization via Visual Basic
>
>
>
>
>
> Does anyone know how to write to the LaborDtl table? I have a variable
with
> a string value and I need to store it in the Character01 user field in the
> LaborDtl table. Someone mentioned an update function but the syntax has my
> head spinning.
>
> Thanks in advance,
> Jeff Sanders
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
Are there any instructions how to use the BL Tester? I have the BL Tester, but I can't seem to get it to successfully do anything.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Sean McDaniel
Sent: Tuesday, February 09, 2010 9:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: MES Customization via Visual Basic



The correct name (my mistake) is the BL Tester.

Try this.

C:\Program Files\Epicor Software\BL Tester for 8.03 (.Net 2.0 Edition)\

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
jeffery_p_sanders
Sent: Tuesday, February 09, 2010 11:27 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: MES Customization via Visual Basic

Where is the method viewer? I have V9.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , "Sean
McDaniel" <smcdanie@...> wrote:
>
> If you can, use the Method Viewer. V9 ships this, but I believe in V8 you
> need to get this separately.
>
> With this tool you can use the business objects directly, seeing the data
> returned, execute updates, etc. I have found this incredibly useful as you
> can run through what needs to happen and then program accordingly.
>
>
>
> From: Sean McDaniel [mailto:smcdanie@...]
> Sent: Tuesday, February 09, 2010 9:55 AM
> To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com> <mailto:%27vantage%40yahoogroups.com> '
> Subject: RE: [Vantage] MES Customization via Visual Basic
>
>
>
> Sorry about the previous post - misunderstood.
>
>
>
> If you're doing this through VB then you'll be going through the method
> calls, not directly against the database. To determine what is called, it
> might help to turn on the tracing. This will produce an XML file that you
> can then look at to get more details about the methods being called and in
> what order.
>
>
>
> You'll need to get the dataset first using the GetList method call (or get
> new if creating a record). This will return your dataset that you can then
> update as needed. You'll then execute the Update method call passing in
the
> dataset.
>
>
>
> Here is an example that I did involving the UD table as a rough outline of
> the steps.
>
>
>
> You have to make sure you add the custom assemblies to the customization.
>
> This will create a new record with watever variable you use and then
> populate the character01 with whatever you want.
>
> Dim udAdapter As UD03Adapter = New UD03Adapter(ReceiptEntryForm)
> Dim udConnected As Boolean = udAdapter.BOConnect()
> Dim newUD03 As Boolean = udAdapter.GetaNewUD03()
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key1") = variable
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key2") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key3") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key4") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key5") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Character01") = """"""
> udAdapter.Update()
>
> This will let you read the data from UD01 table
> Dim ud01Adapt As UD01Adapter = New UD01Adapter(CustShipForm)
> ud01Adapt.BOConnect()
> Dim key1 As String = TBLot.ToString()
> Dim key2 As String = String.Empty
> Dim key3 As String = String.Empty
> Dim key4 As String = String.Empty
> Dim key5 As String = String.Empty
> Dim UD01 As Boolean = ud01Adapt.GetByID(key1, key2, key3, key4,
> key5)
> If UD01 Then variable =
> UD01Adapt.UD01Data.Tables("UD01").Rows(0)("CheckBox10")
> ud01Adapt.dispose()
>
>
>
>
>
> 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
> jeffery_p_sanders
> Sent: Tuesday, February 09, 2010 9:40 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] MES Customization via Visual Basic
>
>
>
>
>
> Does anyone know how to write to the LaborDtl table? I have a variable
with
> a string value and I need to store it in the Character01 user field in the
> LaborDtl table. Someone mentioned an update function but the syntax has my
> head spinning.
>
> Thanks in advance,
> Jeff Sanders
>
>
>
>
>
> [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]
(I'm loading this to the files section "Business Logic Tester.PDF" as there
are pictures to help see what this tool gives you)

Hi Thomas,

I came across this because of SDK in V8, but it was an Epicor rep (Beverly
Sims) who had me use this during one of our troubleshooting sessions and it
totally opened my eyes. I have been using it ever since.

Here is my screen setup:



You go into File -> Open and select any BO file.

The BL Tester then opens that business object and lets you "play" by way of
any of the methods that the business object provides.



So, for example you could query for all parts beginning with "M"



You'd then click the "INVOKE" button and it will return a data set



That you can then expand



I've noticed that some methods return all the columns, but others only
return a subset of columns and so there are many ways to get to the same end
point and it might mean that you take a bit of a detour, but you can easily
find the new "route" by playing in this sandbox.

You can also go to View -> Class Documentation or Extended Properties View
for all information about the business object that you are using.







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Thomas Rose
Sent: Tuesday, February 09, 2010 5:55 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: MES Customization via Visual Basic





Are there any instructions how to use the BL Tester? I have the BL Tester,
but I can't seem to get it to successfully do anything.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

Note: The information contained in the e-mail, including any attachments, is
legally privileged and confidential. If you are not the intended recipient
you are hereby notified that any reading, use or dissemination of this
message is strictly prohibited. If you have received this message in error,
please immediately notify us by telephone at 425-776-4946 and delete this
message from your system. Even though this e-mail and any attachments are
believed to be free of any virus or other defect that might affect any
computer system into which it is received and opened, it is the
responsibility of the recipient to ensure that it is virus free, and no
responsibility is accepted by Electric Mirror LLC for any loss or damage
arising in any way from its use

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Sean McDaniel
Sent: Tuesday, February 09, 2010 9:25 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: MES Customization via Visual Basic

The correct name (my mistake) is the BL Tester.

Try this.

C:\Program Files\Epicor Software\BL Tester for 8.03 (.Net 2.0 Edition)\

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
jeffery_p_sanders
Sent: Tuesday, February 09, 2010 11:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: MES Customization via Visual Basic

Where is the method viewer? I have V9.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ,
"Sean
McDaniel" <smcdanie@...> wrote:
>
> If you can, use the Method Viewer. V9 ships this, but I believe in V8 you
> need to get this separately.
>
> With this tool you can use the business objects directly, seeing the data
> returned, execute updates, etc. I have found this incredibly useful as you
> can run through what needs to happen and then program accordingly.
>
>
>
> From: Sean McDaniel [mailto:smcdanie@...]
> Sent: Tuesday, February 09, 2010 9:55 AM
> To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com> <mailto:%27vantage%40yahoogroups.com>
'
> Subject: RE: [Vantage] MES Customization via Visual Basic
>
>
>
> Sorry about the previous post - misunderstood.
>
>
>
> If you're doing this through VB then you'll be going through the method
> calls, not directly against the database. To determine what is called, it
> might help to turn on the tracing. This will produce an XML file that you
> can then look at to get more details about the methods being called and in
> what order.
>
>
>
> You'll need to get the dataset first using the GetList method call (or get
> new if creating a record). This will return your dataset that you can then
> update as needed. You'll then execute the Update method call passing in
the
> dataset.
>
>
>
> Here is an example that I did involving the UD table as a rough outline of
> the steps.
>
>
>
> You have to make sure you add the custom assemblies to the customization.
>
> This will create a new record with watever variable you use and then
> populate the character01 with whatever you want.
>
> Dim udAdapter As UD03Adapter = New UD03Adapter(ReceiptEntryForm)
> Dim udConnected As Boolean = udAdapter.BOConnect()
> Dim newUD03 As Boolean = udAdapter.GetaNewUD03()
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key1") = variable
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key2") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key3") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key4") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Key5") = String.Empty
> udAdapter.UD03Data.Tables("UD03").Rows(0)("Character01") = """"""
> udAdapter.Update()
>
> This will let you read the data from UD01 table
> Dim ud01Adapt As UD01Adapter = New UD01Adapter(CustShipForm)
> ud01Adapt.BOConnect()
> Dim key1 As String = TBLot.ToString()
> Dim key2 As String = String.Empty
> Dim key3 As String = String.Empty
> Dim key4 As String = String.Empty
> Dim key5 As String = String.Empty
> Dim UD01 As Boolean = ud01Adapt.GetByID(key1, key2, key3, key4,
> key5)
> If UD01 Then variable =
> UD01Adapt.UD01Data.Tables("UD01").Rows(0)("CheckBox10")
> ud01Adapt.dispose()
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> jeffery_p_sanders
> Sent: Tuesday, February 09, 2010 9:40 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] MES Customization via Visual Basic
>
>
>
>
>
> Does anyone know how to write to the LaborDtl table? I have a variable
with
> a string value and I need to store it in the Character01 user field in the
> LaborDtl table. Someone mentioned an update function but the syntax has my
> head spinning.
>
> Thanks in advance,
> Jeff Sanders
>
>
>
>
>
> [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]
My computer is upgraded to win7 (64bit version). BL Tester stops working. It will run but when you open a BO, it says "Login failed: The system cannot find the file specified....". Anyone can help? We are on Vantage 803.407

Thanks in advance.


[Non-text portions of this message have been removed]
I 'discovered' the BLTester win 64 problem a year ago - I have deduced that the program relies on a communication dll file that is not there or is substantially changed from WinXPx32 or Server2003x32 - I figure that finding the correct dll and putting it in the same folder as the BLTester exe file might fix it, but I have not gotten to finding it yet....

If you do resolve this, kindly post to the group what the solution is...

bw

--- In vantage@yahoogroups.com, Bill Wu <billw@...> wrote:
>
> My computer is upgraded to win7 (64bit version). BL Tester stops working. It will run but when you open a BO, it says "Login failed: The system cannot find the file specified....". Anyone can help? We are on Vantage 803.407
>
> Thanks in advance.
>
>
> [Non-text portions of this message have been removed]
>
I put in a support call to Epicor on this. I tried a number of the tech's suggestions and ended up doing a WebEx with tech support. The conclusion was that BL Tester was not compatible with win 7 64 bit. We already guessed that, but now it's "official"! The tech also told me that there was a new BL Tester for Epicor 9 that was compatible with Windows 7 64-bit. Maybe an Epicor 9 user can verify that for us. The workaround for Vantage is to run BL Tester from a 32 bit machine. In my case, I either remote log on to the server and run it from there or fire up an old XP machine in my office.

Sue

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> I 'discovered' the BLTester win 64 problem a year ago - I have deduced that the program relies on a communication dll file that is not there or is substantially changed from WinXPx32 or Server2003x32 - I figure that finding the correct dll and putting it in the same folder as the BLTester exe file might fix it, but I have not gotten to finding it yet....
>
> If you do resolve this, kindly post to the group what the solution is...
>
> bw
>
> --- In vantage@yahoogroups.com, Bill Wu <billw@> wrote:
> >
> > My computer is upgraded to win7 (64bit version). BL Tester stops working. It will run but when you open a BO, it says "Login failed: The system cannot find the file specified....". Anyone can help? We are on Vantage 803.407
> >
> > Thanks in advance.
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
I have found that the E9 BL Tester works with V8.03.405a

--- In vantage@yahoogroups.com, "snielsen28" <snielsen.hipco@...> wrote:
>
> I put in a support call to Epicor on this. I tried a number of the tech's suggestions and ended up doing a WebEx with tech support. The conclusion was that BL Tester was not compatible with win 7 64 bit. We already guessed that, but now it's "official"! The tech also told me that there was a new BL Tester for Epicor 9 that was compatible with Windows 7 64-bit. Maybe an Epicor 9 user can verify that for us. The workaround for Vantage is to run BL Tester from a 32 bit machine. In my case, I either remote log on to the server and run it from there or fire up an old XP machine in my office.
>
> Sue
>
> --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> >
> > I 'discovered' the BLTester win 64 problem a year ago - I have deduced that the program relies on a communication dll file that is not there or is substantially changed from WinXPx32 or Server2003x32 - I figure that finding the correct dll and putting it in the same folder as the BLTester exe file might fix it, but I have not gotten to finding it yet....
> >
> > If you do resolve this, kindly post to the group what the solution is...
> >
> > bw
> >
> > --- In vantage@yahoogroups.com, Bill Wu <billw@> wrote:
> > >
> > > My computer is upgraded to win7 (64bit version). BL Tester stops working. It will run but when you open a BO, it says "Login failed: The system cannot find the file specified....". Anyone can help? We are on Vantage 803.407
> > >
> > > Thanks in advance.
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
Is it available on the Epicor download site? I haven't unpacked my Epicor 9 disks yet.

Sue

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> I have found that the E9 BL Tester works with V8.03.405a
>
> --- In vantage@yahoogroups.com, "snielsen28" <snielsen.hipco@> wrote:
> >
> > I put in a support call to Epicor on this. I tried a number of the tech's suggestions and ended up doing a WebEx with tech support. The conclusion was that BL Tester was not compatible with win 7 64 bit. We already guessed that, but now it's "official"! The tech also told me that there was a new BL Tester for Epicor 9 that was compatible with Windows 7 64-bit. Maybe an Epicor 9 user can verify that for us. The workaround for Vantage is to run BL Tester from a 32 bit machine. In my case, I either remote log on to the server and run it from there or fire up an old XP machine in my office.
> >
> > Sue
> >
> > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > >
> > > I 'discovered' the BLTester win 64 problem a year ago - I have deduced that the program relies on a communication dll file that is not there or is substantially changed from WinXPx32 or Server2003x32 - I figure that finding the correct dll and putting it in the same folder as the BLTester exe file might fix it, but I have not gotten to finding it yet....
> > >
> > > If you do resolve this, kindly post to the group what the solution is...
> > >
> > > bw
> > >
> > > --- In vantage@yahoogroups.com, Bill Wu <billw@> wrote:
> > > >
> > > > My computer is upgraded to win7 (64bit version). BL Tester stops working. It will run but when you open a BO, it says "Login failed: The system cannot find the file specified....". Anyone can help? We are on Vantage 803.407
> > > >
> > > > Thanks in advance.
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
>
I was looking at the files people have posted in our group and opened a pdf about a tool called Business Logic Tester. Does this cost money or is it available to use and I don't know where it is on my computer?
The tool is free..telling you where it is on your computer is $50.00

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tkoch77
Sent: Monday, November 21, 2011 12:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BL Tester



I was looking at the files people have posted in our group and opened a pdf about a tool called Business Logic Tester. Does this cost money or is it available to use and I don't know where it is on my computer?



[Non-text portions of this message have been removed]
Ok, thanks Rob.



________________________________
From: Rob Bucek <rbucek@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, November 21, 2011 1:06 PM
Subject: RE: [Vantage] BL Tester

The tool is free..telling you where it is on your computer is $50.00

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tkoch77
Sent: Monday, November 21, 2011 12:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BL Tester



I was looking at the files people have posted in our group and opened a pdf about a tool called Business Logic Tester. Does this cost money or is it available to use and I don't know where it is on my computer?



[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/.%c2%a0
(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]
Try \\yourvantageserver\epicor\mfgsys803\Utilities\<file:///\\yourvantageserver\epicor\mfgsys803\Utilities\>

Should be an exec file there to install...

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Monday, November 21, 2011 12:06 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BL Tester



The tool is free..telling you where it is on your computer is $50.00

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of tkoch77
Sent: Monday, November 21, 2011 12:02 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BL Tester

I was looking at the files people have posted in our group and opened a pdf about a tool called Business Logic Tester. Does this cost money or is it available to use and I don't know where it is on my computer?

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



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