BAM fire on new record

Yahoo Archive
1
Aimee,

Do you still have these samples of .p alert programs?
I would be interested to see them

Mark

--- In vantage@yahoogroups.com, "aimee.grebe" <aimee.grebe@...> wrote:
>
> In my experience a BAM fires when a new record is added as well as on an update to an existing record. You need one of the .p alert programs to reference field values in the email. They are written in Progress. I have a few samples that some other group members were kind enough to send me if you want to see them.
>
> Thanks,
> Aimee
>
> --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> >
> > Is there a way to have a BAM fire on a new record vs a changed field?
> >
> >
> >
> > I have no problem getting a BAM to trigger when a user changes a certain
> > field. But what I need is a BAM to fire when a new record is added to a
> > table.
> >
> >
> >
> > For example, when a new record is added to XFileAttch and
> > XFileAttch.RelatedToFile = "JobHead" I want to send an email saying "A
> > new attachment has been added to Job# XXXXXX"
> >
> >
> >
> > Can you reference fields in the Alert Text? Or do I need an Alert
> > Program for this?
> >
> >
> >
> > Any ideas? Thank you in advance.
> >
> >
> >
> >
> >
> >
> >
> > Vic
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
2
Is there a way to have a BAM fire on a new record vs a changed field?



I have no problem getting a BAM to trigger when a user changes a certain
field. But what I need is a BAM to fire when a new record is added to a
table.



For example, when a new record is added to XFileAttch and
XFileAttch.RelatedToFile = "JobHead" I want to send an email saying "A
new attachment has been added to Job# XXXXXX"



Can you reference fields in the Alert Text? Or do I need an Alert
Program for this?



Any ideas? Thank you in advance.







Vic





[Non-text portions of this message have been removed]
3
In my experience a BAM fires when a new record is added as well as on an update to an existing record. You need one of the .p alert programs to reference field values in the email. They are written in Progress. I have a few samples that some other group members were kind enough to send me if you want to see them.

Thanks,
Aimee

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Is there a way to have a BAM fire on a new record vs a changed field?
>
>
>
> I have no problem getting a BAM to trigger when a user changes a certain
> field. But what I need is a BAM to fire when a new record is added to a
> table.
>
>
>
> For example, when a new record is added to XFileAttch and
> XFileAttch.RelatedToFile = "JobHead" I want to send an email saying "A
> new attachment has been added to Job# XXXXXX"
>
>
>
> Can you reference fields in the Alert Text? Or do I need an Alert
> Program for this?
>
>
>
> Any ideas? Thank you in advance.
>
>
>
>
>
>
>
> Vic
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Hi Vic,

If you create the BAM against the Key Field in the table, it should work.

For example: in Customer use CustNum (not CustID), in OrderHed use OrderNum, etc.

The key field for any table can't be changed once it's saved, so the BAM should only be triggered when a new record is created.

For new records in the XFileAttch table, I'd try using the AttachNum field and then use an Alert Program to filter out non-job related attachments.


HTH,
Nigel.


--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Is there a way to have a BAM fire on a new record vs a changed field?
>
>
>
> I have no problem getting a BAM to trigger when a user changes a certain
> field. But what I need is a BAM to fire when a new record is added to a
> table.
>
>
>
> For example, when a new record is added to XFileAttch and
> XFileAttch.RelatedToFile = "JobHead" I want to send an email saying "A
> new attachment has been added to Job# XXXXXX"
>
>
>
> Can you reference fields in the Alert Text? Or do I need an Alert
> Program for this?
>
>
>
> Any ideas? Thank you in advance.
>
>
>
>
>
>
>
> Vic
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Nigel, thanks.



I cannot get anything to fire on XFileAttch. Can you? I've tried Key1,
AttachNum, all fields, etc. Nothing will fire. I have no rules set so
there is nothing stopping it.....



Hmm...



Perhaps this is one of those tables that are in the BAM list but not
BAMable.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of NigelK
Sent: Tuesday, June 15, 2010 9:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAM fire on new record





Hi Vic,

If you create the BAM against the Key Field in the table, it should
work.

For example: in Customer use CustNum (not CustID), in OrderHed use
OrderNum, etc.

The key field for any table can't be changed once it's saved, so the BAM
should only be triggered when a new record is created.

For new records in the XFileAttch table, I'd try using the AttachNum
field and then use an Alert Program to filter out non-job related
attachments.

HTH,
Nigel.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Vic
Drecchio" <vic.drecchio@...> wrote:
>
> Is there a way to have a BAM fire on a new record vs a changed field?
>
>
>
> I have no problem getting a BAM to trigger when a user changes a
certain
> field. But what I need is a BAM to fire when a new record is added to
a
> table.
>
>
>
> For example, when a new record is added to XFileAttch and
> XFileAttch.RelatedToFile = "JobHead" I want to send an email saying "A
> new attachment has been added to Job# XXXXXX"
>
>
>
> Can you reference fields in the Alert Text? Or do I need an Alert
> Program for this?
>
>
>
> Any ideas? Thank you in advance.
>
>
>
>
>
>
>
> Vic
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
6
Hi Vic,

Worked OK for me. I setup the BAM with just "AttachNum" in Selected Fields and an action of Send Alert. I created a new Part and added an attachment to that.

If you're working on your test DB, are you sure the Global Alerts are running?

BTW, we're on v8.03.406a/Progress.


Nigel.


--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Nigel, thanks.
>
>
>
> I cannot get anything to fire on XFileAttch. Can you? I've tried Key1,
> AttachNum, all fields, etc. Nothing will fire. I have no rules set so
> there is nothing stopping it.....
>
>
>
> Hmm...
>
>
>
> Perhaps this is one of those tables that are in the BAM list but not
> BAMable.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of NigelK
> Sent: Tuesday, June 15, 2010 9:50 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAM fire on new record
>
>
>
>
>
> Hi Vic,
>
> If you create the BAM against the Key Field in the table, it should
> work.
>
> For example: in Customer use CustNum (not CustID), in OrderHed use
> OrderNum, etc.
>
> The key field for any table can't be changed once it's saved, so the BAM
> should only be triggered when a new record is created.
>
> For new records in the XFileAttch table, I'd try using the AttachNum
> field and then use an Alert Program to filter out non-job related
> attachments.
>
> HTH,
> Nigel.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Vic
> Drecchio" <vic.drecchio@> wrote:
> >
> > Is there a way to have a BAM fire on a new record vs a changed field?
> >
> >
> >
> > I have no problem getting a BAM to trigger when a user changes a
> certain
> > field. But what I need is a BAM to fire when a new record is added to
> a
> > table.
> >
> >
> >
> > For example, when a new record is added to XFileAttch and
> > XFileAttch.RelatedToFile = "JobHead" I want to send an email saying "A
> > new attachment has been added to Job# XXXXXX"
> >
> >
> >
> > Can you reference fields in the Alert Text? Or do I need an Alert
> > Program for this?
> >
> >
> >
> > Any ideas? Thank you in advance.
> >
> >
> >
> >
> >
> >
> >
> > Vic
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
7
Aimee,
He may not want those samples but I would. I have not been successful in my attempts to include record data in an email.

Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas

----- Original Message -----
From: aimee.grebe
To: vantage@yahoogroups.com
Sent: Tuesday, June 15, 2010 7:54 AM
Subject: [Vantage] Re: BAM fire on new record





In my experience a BAM fires when a new record is added as well as on an update to an existing record. You need one of the .p alert programs to reference field values in the email. They are written in Progress. I have a few samples that some other group members were kind enough to send me if you want to see them.

Thanks,
Aimee

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Is there a way to have a BAM fire on a new record vs a changed field?
>
>
>
> I have no problem getting a BAM to trigger when a user changes a certain
> field. But what I need is a BAM to fire when a new record is added to a
> table.
>
>
>
> For example, when a new record is added to XFileAttch and
> XFileAttch.RelatedToFile = "JobHead" I want to send an email saying "A
> new attachment has been added to Job# XXXXXX"
>
>
>
> Can you reference fields in the Alert Text? Or do I need an Alert
> Program for this?
>
>
>
> Any ideas? Thank you in advance.
>
>
>
>
>
>
>
> Vic
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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