Invoking .net Blank Title 81663

Thanks for all thIs. How do you know this. Where or What documentation from Epicor. Nothing I ever knew of?

Can you direct me to learn more and also what are the best resources for .net and writing code thru visual studio
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Mark Wonsil" <mark_wonsil@...>

Date: Thu, 20 Aug 2009 18:54:42
To: <vantage@yahoogroups.com>
Subject: RE: [Vantage] Invoking .net


vantage@yahoogroups.com wrote:
> Install BPM Server on your develoment evironment
>
> Create a new .net Project and for DLL Library and add the reference
> C:\Program Files\ComPlus
> Applications\{CB819E8D-DF90-4B54-B72C-51787B8A5091}\Epicor.Mfg
> .BPM.Server.CallContext.dll
>
> Then from Vantage
> Go to Method Directives and find the the BO in which you want
> to trigger the
> BPM say it is Cutomer Update
> OnceYou've Selected th Method Click on Advanced Select the Parameters
> you will like to have passed to your program and click Create
> Programming Interface Select .NET Assembly
> Select Before or After
>
> Copy the generated code to the class you created earlier in your dev
> environment. Once all done compile and copy the .dll into Actions on
> C:/Progrma Files /Epicor/BPM Server
>

Here's the "Hello BPM" code I use to test Epicor 9:

namespace Bpm.Custom {
using System;
using System.Data;
using System.Diagnostics;
using Bpm.Action;
using System.Data.Sql;
using System.Data.SqlClient;

public class SalesOrder {

public virtual void OnAfterUpdate(System.Data.DataSet
SalesOrderDataSet) {

SalesOrderDataSet.WriteXml("c:\\temp\\SalesOrder.xml");

}
}
}

Note that in Epicor 9, you don't get a set of tt files but get a full
dataset. I just call the WriteXML method to dump what's available to you.
You will NOT see all of the variables that are available to Progress 4G/L
BPMs.

Mark W.





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

We would like to inactivate a number of parts beginning with a certain prefix and were wondering if there was a script that could be made to do this. I am not learned in SQL scripts, so I thought I'd throw it out there for suggestions. We are looking to:

Mass inactivate part #'s that begin with

ABC*

have 0 quantity and no transactions against them (these are requirements of the inactive option).

Any suggestions are appreciated. Thank you!
Hello,



If you have Service Connect I would use that to make these changes.



If not I would look into getting service connect.



Making direct changes to the DB with transact is not recommended. There is
logic in place that protects the data that is not initiated from the DB side
but rather the application. SO if you make changes to the db directly you
are bypassing these protections.



I have a Service connect work flow that disables parts I would be happy to
share it with you but you will need Service connect to use it.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
pbriscoe10
Sent: Tuesday, August 18, 2009 12:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Script to Mass Inactivate Parts





Hello,

We would like to inactivate a number of parts beginning with a certain
prefix and were wondering if there was a script that could be made to do
this. I am not learned in SQL scripts, so I thought I'd throw it out there
for suggestions. We are looking to:

Mass inactivate part #'s that begin with

ABC*

have 0 quantity and no transactions against them (these are requirements of
the inactive option).

Any suggestions are appreciated. Thank you!





[Non-text portions of this message have been removed]
Nigel Kerley gave a great example to do something like that with a BPM
if you don't have service connect.



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<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 Charlie Wilson
Sent: Tuesday, August 18, 2009 11:24 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Script to Mass Inactivate Parts





Hello,

If you have Service Connect I would use that to make these changes.

If not I would look into getting service connect.

Making direct changes to the DB with transact is not recommended. There
is
logic in place that protects the data that is not initiated from the DB
side
but rather the application. SO if you make changes to the db directly
you
are bypassing these protections.

I have a Service connect work flow that disables parts I would be happy
to
share it with you but you will need Service connect to use it.

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
pbriscoe10
Sent: Tuesday, August 18, 2009 12:07 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Script to Mass Inactivate Parts

Hello,

We would like to inactivate a number of parts beginning with a certain
prefix and were wondering if there was a script that could be made to do
this. I am not learned in SQL scripts, so I thought I'd throw it out
there
for suggestions. We are looking to:

Mass inactivate part #'s that begin with

ABC*

have 0 quantity and no transactions against them (these are requirements
of
the inactive option).

Any suggestions are appreciated. Thank you!

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





[Non-text portions of this message have been removed]
If you have SQL, which I think you do, let me know and I can write you a script to do this.

Doing some things on the back-end is risky, but I don't believe flagging a part as inactive will cause any cascading effects.

Get on your SQL server and run this select statement against MFGSYS803 database (it's just selecting data, it's safe to run). It will give you a list of all parts starting with ABC which have a ZERO on-hand quantity. Validate that list and if it looks good let me know and I'll send you the UPDATE statement. When I do mass updates I also flag a UD field also so I can always identify what I just changed. For example I'll set Part.Number20 equal to 999 assuming I don't use Number20 for anything. This allows me to easily undo my Update if I overlooked something. (this statement will not list any negative OH qtys)


--------------------------------------------
SELECT
CASE
WHEN (SELECT SUM(PB.ONHANDQTY) FROM PARTBIN PB WHERE PB.PARTNUM = P.PARTNUM) is NULL THEN 0
ELSE (SELECT SUM(PB.ONHANDQTY) FROM PARTBIN PB WHERE PB.PARTNUM = P.PARTNUM)
END AS [ONHAND_QTY],P.*
FROM PART P WHERE P.PARTNUM LIKE 'ABC%'
AND (CASE
WHEN (SELECT SUM(PB.ONHANDQTY) FROM PARTBIN PB WHERE PB.PARTNUM = P.PARTNUM) is NULL THEN 0
ELSE (SELECT SUM(PB.ONHANDQTY) FROM PARTBIN PB WHERE PB.PARTNUM = P.PARTNUM)
END) = 0
ORDER BY P.PARTNUM






Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Mobile:Â 704.530.3092

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of pbriscoe10
Sent: Tuesday, August 18, 2009 12:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Script to Mass Inactivate Parts

Hello,

We would like to inactivate a number of parts beginning with a certain prefix and were wondering if there was a script that could be made to do this. I am not learned in SQL scripts, so I thought I'd throw it out there for suggestions. We are looking to:

Mass inactivate part #'s that begin with

ABC*

have 0 quantity and no transactions against them (these are requirements of the inactive option).

Any suggestions are appreciated. Thank you!





------------------------------------

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
Has anyone seen an issue where Crystal reports brought up in Vantage
803.407C do not Print Preview? If she brings up a Progress report, she can
Print Preview, but if she chooses a report written in Crystal it brings up a
blank page. It does not do this at other workstations logged in as her,
this is just happening at her workstation. I reinstalled the Crystal
runtime on her workstation to see if that would fix the problem, but it did
not help.

Thank you

Jeff



[Non-text portions of this message have been removed]
.NET re-install?

Check her default windows printer.

...just a couple random quick thoughts.





-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jeff Stockard
Sent: Tuesday, August 18, 2009 3:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Print Preview problem

Has anyone seen an issue where Crystal reports brought up in Vantage
803.407C do not Print Preview? If she brings up a Progress report, she
can
Print Preview, but if she chooses a report written in Crystal it brings
up a
blank page. It does not do this at other workstations logged in as her,
this is just happening at her workstation. I reinstalled the Crystal
runtime on her workstation to see if that would fix the problem, but it
did
not help.

Thank you

Jeff



[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
Thank you for the input.

Charlie, unfortunately we don't have service connect...

Rob, I did a search on Nigel and couldn't come up with anything related to this, do you happen to know where I could find it?

Vic, thanks I'll give it a try


--- In vantage@yahoogroups.com, "pbriscoe10" <pbriscoe10@...> wrote:
>
> Hello,
>
> We would like to inactivate a number of parts beginning with a certain prefix and were wondering if there was a script that could be made to do this. I am not learned in SQL scripts, so I thought I'd throw it out there for suggestions. We are looking to:
>
> Mass inactivate part #'s that begin with
>
> ABC*
>
> have 0 quantity and no transactions against them (these are requirements of the inactive option).
>
> Any suggestions are appreciated. Thank you!
>
We've found most of the time this can be resolved by clearing temporary
files. Crystal tends to have memory leak issues and leaves temp files -
once the number of temp files gets too large you end up getting blank
reports. What we ended up doing here is write a batch file to delete
temporary Crystal Reports files on start up and have our users do a
restart on their computer each night.

We do have a couple of users that have the problem even after running
the temporary file cleanup (myself being 1 of them). Those tended to be
on Dell laptops - sometimes resizing the window would make the data
appear. Otherwise, if operating in dual screen mode, moving the report
from an analog to a digital screen would fix it. There was 1 user that
reported the same problem on Dells only, all his workstations ran fine.
He found removing the Intel(R) Graphics Media Accelerator Driver fixed
them. We hesitate to do that since the accelerator is supposed to help
speed up applications. I did remove it on my Dell to try and it didn't
resolve my blank print preview. I only get it occasionally now and a
reboot usually resolves it. I do a lot of Crystal development and just
figure its the price I'll pay.

FYI... We tried SAP support and weren't able to get any further with
this at the time. If someone else has support and wants to give it
another go, let me know if you get a fix.

Thanks!

Jennifer Lisser
Business Analyst
Dorner Mfg. Corp.
P: 262-369-1128
F: 262-367-3243
<http://www.dorner.com/>
http://www.Dorner.com <http://www.dorner.com/>




[Non-text portions of this message have been removed]
Jennifer, great point!

I once chased a print preview problem on dual monitors for days. On one
monitor the preview was BLANK. Simply moving the window to the other
monitor magically fixed it. Very odd.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Lisser, Jennifer
Sent: Wednesday, August 19, 2009 9:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Print Preview problem

We've found most of the time this can be resolved by clearing temporary
files. Crystal tends to have memory leak issues and leaves temp files -
once the number of temp files gets too large you end up getting blank
reports. What we ended up doing here is write a batch file to delete
temporary Crystal Reports files on start up and have our users do a
restart on their computer each night.

We do have a couple of users that have the problem even after running
the temporary file cleanup (myself being 1 of them). Those tended to be
on Dell laptops - sometimes resizing the window would make the data
appear. Otherwise, if operating in dual screen mode, moving the report
from an analog to a digital screen would fix it. There was 1 user that
reported the same problem on Dells only, all his workstations ran fine.
He found removing the Intel(R) Graphics Media Accelerator Driver fixed
them. We hesitate to do that since the accelerator is supposed to help
speed up applications. I did remove it on my Dell to try and it didn't
resolve my blank print preview. I only get it occasionally now and a
reboot usually resolves it. I do a lot of Crystal development and just
figure its the price I'll pay.

FYI... We tried SAP support and weren't able to get any further with
this at the time. If someone else has support and wants to give it
another go, let me know if you get a fix.

Thanks!

Jennifer Lisser
Business Analyst
Dorner Mfg. Corp.
P: 262-369-1128
F: 262-367-3243
<http://www.dorner.com/>
http://www.Dorner.com <http://www.dorner.com/>




[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
We had a user with this problem at one point he had an ATI card. The drivers
for the card got fragged and after reinstalling them he hasn't had a problem
since.







~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vic Drecchio
Sent: Wednesday, August 19, 2009 9:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Print Preview problem





Jennifer, great point!

I once chased a print preview problem on dual monitors for days. On one
monitor the preview was BLANK. Simply moving the window to the other
monitor magically fixed it. Very odd.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Lisser, Jennifer
Sent: Wednesday, August 19, 2009 9:33 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Print Preview problem

We've found most of the time this can be resolved by clearing temporary
files. Crystal tends to have memory leak issues and leaves temp files -
once the number of temp files gets too large you end up getting blank
reports. What we ended up doing here is write a batch file to delete
temporary Crystal Reports files on start up and have our users do a
restart on their computer each night.

We do have a couple of users that have the problem even after running
the temporary file cleanup (myself being 1 of them). Those tended to be
on Dell laptops - sometimes resizing the window would make the data
appear. Otherwise, if operating in dual screen mode, moving the report
from an analog to a digital screen would fix it. There was 1 user that
reported the same problem on Dells only, all his workstations ran fine.
He found removing the Intel(R) Graphics Media Accelerator Driver fixed
them. We hesitate to do that since the accelerator is supposed to help
speed up applications. I did remove it on my Dell to try and it didn't
resolve my blank print preview. I only get it occasionally now and a
reboot usually resolves it. I do a lot of Crystal development and just
figure its the price I'll pay.

FYI... We tried SAP support and weren't able to get any further with
this at the time. If someone else has support and wants to give it
another go, let me know if you get a fix.

Thanks!

Jennifer Lisser
Business Analyst
Dorner Mfg. Corp.
P: 262-369-1128
F: 262-367-3243
<http://www.dorner. <http://www.dorner.com/> com/>
http://www.Dorner. <http://www.Dorner.com> com <http://www.dorner.
<http://www.dorner.com/> com/>

[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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
We have seen some strange issues where specific users will have a problem on their PC but others or that same user doesn't have that problem on other PC's.

One solution we have found is to delete the following folder :

C:\Documents and Settings\All Users\Application Data\Epicor\Vantage\8.03.407 (and any older folders)

This folder is then re-built when the user logs into Vantage and the problem goes away.

Neil

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> .NET re-install?
>
> Check her default windows printer.
>
> ...just a couple random quick thoughts.
>
>
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jeff Stockard
> Sent: Tuesday, August 18, 2009 3:17 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Print Preview problem
>
> Has anyone seen an issue where Crystal reports brought up in Vantage
> 803.407C do not Print Preview? If she brings up a Progress report, she
> can
> Print Preview, but if she chooses a report written in Crystal it brings
> up a
> blank page. It does not do this at other workstations logged in as her,
> this is just happening at her workstation. I reinstalled the Crystal
> runtime on her workstation to see if that would fix the problem, but it
> did
> not help.
>
> Thank you
>
> Jeff
>
>
>
> [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
>
The example Rob is talking about is a PowerPoint presentation. It's in the file section of the Group website: http://f1.grp.yahoofs.com/v1/0EiNSkwdOJMClbvikMcLFFRw2FtpHkb2JSizoyC0546QgxjDKsFYxZqtgOEk7si70KX4_l94-xPCleH1zlA4Qo_LS5ZH50E/BPMs/Nigel-Yahoo%20User%20Group%20-%20Manual%20BPM.ppt

It was part of the BPM Webex Rob hosted a while back.

In our case, we use it to enter two sales order numbers and then run 4GL code on every sales order in that range. You should be able to amend the code to take one part number and run the code.

A warning though: As you probably know Vantage will not let the inactive flag be set on a part that has an on-hand qty or appears on an open PO or open SO. Changing the inactive flag on a part through 4GL may or may not trigger this checking. So I'd strongly advise you to try the code on a few parts that don't pass these conditions - just to see what happens.

You could always amend the 4GL code and build in these conditions if necessary.

HTH,

Nigel.

--- In vantage@yahoogroups.com, "pbriscoe10" <pbriscoe10@...> wrote:
>
> Thank you for the input.
>
> Charlie, unfortunately we don't have service connect...
>
> Rob, I did a search on Nigel and couldn't come up with anything related to this, do you happen to know where I could find it?
>
> Vic, thanks I'll give it a try
>
>
> --- In vantage@yahoogroups.com, "pbriscoe10" <pbriscoe10@> wrote:
> >
> > Hello,
> >
> > We would like to inactivate a number of parts beginning with a certain prefix and were wondering if there was a script that could be made to do this. I am not learned in SQL scripts, so I thought I'd throw it out there for suggestions. We are looking to:
> >
> > Mass inactivate part #'s that begin with
> >
> > ABC*
> >
> > have 0 quantity and no transactions against them (these are requirements of the inactive option).
> >
> > Any suggestions are appreciated. Thank you!
> >
>
Does anyone have any good instruction on invoking .net code through the BPM

[Non-text portions of this message have been removed]
Install BPM Server on your develoment evironment

Create a new .net Project and for DLL Library and add the reference
C:\Program Files\ComPlus
Applications\{CB819E8D-DF90-4B54-B72C-51787B8A5091}\Epicor.Mfg.BPM.Server.CallContext.dll

Then from Vantage
Go to Method Directives and find the the BO in which you want to trigger the
BPM say it is Cutomer Update
OnceYou've Selected th Method Click on Advanced Select the Parameters you
will like to have passed to your program and click Create Programming
Interface
Select .NET Assembly
Select Before or After

Copy the generated code to the class you created earlier in your dev
environment. Once all done compile and copy the .dll into Actions on
C:/Progrma Files /Epicor/BPM Server

Hope this helps




Sincerely
Jose C Gomez

http://www.josecgomez.com
Sent from Jacksonville, FL, United States

On Thu, Aug 20, 2009 at 11:39 AM, advantage <advantage@...> wrote:

>
>
> Does anyone have any good instruction on invoking .net code through the BPM
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
vantage@yahoogroups.com wrote:
> Install BPM Server on your develoment evironment
>
> Create a new .net Project and for DLL Library and add the reference
> C:\Program Files\ComPlus
> Applications\{CB819E8D-DF90-4B54-B72C-51787B8A5091}\Epicor.Mfg
> .BPM.Server.CallContext.dll
>
> Then from Vantage
> Go to Method Directives and find the the BO in which you want
> to trigger the
> BPM say it is Cutomer Update
> OnceYou've Selected th Method Click on Advanced Select the Parameters
> you will like to have passed to your program and click Create
> Programming Interface Select .NET Assembly
> Select Before or After
>
> Copy the generated code to the class you created earlier in your dev
> environment. Once all done compile and copy the .dll into Actions on
> C:/Progrma Files /Epicor/BPM Server
>

Here's the "Hello BPM" code I use to test Epicor 9:

namespace Bpm.Custom {
using System;
using System.Data;
using System.Diagnostics;
using Bpm.Action;
using System.Data.Sql;
using System.Data.SqlClient;

public class SalesOrder {

public virtual void OnAfterUpdate(System.Data.DataSet
SalesOrderDataSet) {

SalesOrderDataSet.WriteXml("c:\\temp\\SalesOrder.xml");

}
}
}

Note that in Epicor 9, you don't get a set of tt files but get a full
dataset. I just call the WriteXML method to dump what's available to you.
You will NOT see all of the variables that are available to Progress 4G/L
BPMs.

Mark W.