4GL in BPM (or .NET method)

Yahoo Archive
1
Grzegorz,
BPM 4GL code is run on the server, so if you have it pop up a message it
will arrive on the server if at all.
To pop up messages, you will need to use customizations. These run on
the client and will allow you to pop up messages. The process is
covered well in the Tools Guide.
If the pop up is just to confirm that the record is available, I expect
that I have solved that mystery in my last off list post to you.
Let us all know if the solution worked.
Aaron Hoyt
Vantage Plastics

phoenix wrote:
>
> Rob,
>
> It will be very usefull if you can post 4GL code that can pop up a
> message box. Regarding ttCustomer.CustID - I was trying the most
> simple version like:
>
> OUTPUT TO "/usr/local/epicor/mfgsys803/bpm/GS/cus_u.txt".
> EXPORT ttCustomer.CustID.
> OUTPUT CLOSE.
>
> and the file cus_u.txt was created, inside the file was only the below
> information
>
> ** No ttCustomer record is available. (91)
>
> So it seems like ttCustomer table with some reasons is not available.
> As someone mentioned there is also possibility that Vantage doesn't
> commit the full write to DB, so I was trying also put into the file
> ttCustomer.Name which I changed before saving. The result was the same.
>
> The code which I paste above it is the whole code that I put into 4GL
> action, selecting "Execute code below" check box.
>
> Grzegorz Szczepañski
>
> Dnia Tue, 24 Jun 2008 16:15:13 -0700 (PDT)
> Robert Brown <robertb_versa@...
> <mailto:robertb_versa%40yahoo.com>> napisał(a):
>
> > Grzegorz,
> >
> > 4GL supports a pop up message box. I'm on vacation and don't have any
> > handy guide as to the syntax but it exists (as we've used it to debug
> > & build BPMs).
> >
> > The fact that you say ttCustomer.CustID set as an exception wasn't an
> > empty string suggest to me your concatenation code is at fault. It
> > could be as simple as requiring parenthesis around your
> >
> > STRING(NOW)+ "Base Customer.Update( )" + ttCustomer.CustID
> >
> > statement.
> >
> > You didn't list the full code so it is not possible to see if the
> > order of statements is causing your problem.
> >
> > I agree with using BPM over VB customizations. A single BPM can
> > impact multiple applications that trigger the same event (versus
> > having to customize multiple apps to get the same total effect).
> >
> > Rob Brown
> >
> >
> >
> > --- On Tue, 6/24/08, phoenix <phoenix_@...
> <mailto:phoenix_%40wp.pl>> wrote:
> > From: phoenix <phoenix_@... <mailto:phoenix_%40wp.pl>>
> > Subject: Re: [Vantage] 4GL in BPM (or .NET method)
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Date: Tuesday, June 24, 2008, 5:23 PM
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > I was already trying to use BEFORE Customer.Update but
> > the result was
> >
> > the same. Regarding Message Box. I am using 4GL code, and I can't
> >
> > display any graphical notification at this level.
> >
> >
> >
> > But I raised exception with ttCustomer.CustID field as parameter and
> > it
> >
> > wasn't empty string.
> >
> >
> >
> > So two actions. The first one output to file information that
> >
> > ttCustomer.CustID is empty and the 2'nd is showing me that data.
> >
> > Strange for me.
> >
> >
> >
> > The build in Vantage ChangeLog doesn't handle all the fields. The
> >
> > structure of this changeLog is also not good for further processing.
> >
> >
> >
> > The way with using customisation and grab data after customer "update"
> >
> > adapter was invoked is also one of my aproach but is seems to be less
> >
> > clear than having everything in one place (BPM).
> >
> >
> >
> > Grzegorz Szczepański
> >
> >
> >
> > Dnia Mon, 23 Jun :22: (PDT)
> >
> > Robert Brown <robertb_versa@ yahoo.com> napisał(a):
> >
> >
> >
> > > Try executing BEFORE the update actually occurs. The tt data may be
> >
> > > null after update as it may only reflect in-app-session changes to
> >
> > > data that are then used to update the db in a full commit write.
> > > With
> >
> > > the inconsistencies I've seen in VB.NET object method & property
> >
> > > polling behavior, I suspect some apps don't carry a full copy of the
> >
> > > data set in the tt data.
> >
> > >
> >
> > > Also: Just to be sure it isn't a syntax issue with your
> > > concatenation
> >
> > > of multiple values (or with your export file), try to display
> >
> > > ttCustomer.CustID in a message box window to see if you still get
> > > the
> >
> > > error message.
> >
> > >
> >
> > > If that works, try displaying your concatenated string in the
> > > message
> >
> > > box (and if that works, try exporting it to your file).
> >
> > >
> >
> > > It looks like you are doing nothing more than creating a change log
> >
> > > file.
> >
> > >
> >
> > > Why not just use Vantage's built in change log?
> >
> > >
> >
> > > RE: Doing this with VB.NET customization: You can probably trap the
> >
> > > after customer adapter 'update' method and grab the updated value
> >
> > > from the record open on screen. (Trapping both before and after
> >
> > > update would give you the old value and the new changed-to value if
> >
> > > that is your goal.)
> >
> > >
> >
> > > Rob Brown
> >
> > >
> >
> > > --- On Mon, 6/23/08, phoenix <phoenix_@wp. pl> wrote:
> >
> > > From: phoenix <phoenix_@wp. pl>
> >
> > > Subject: [Vantage] 4GL in BPM (or .NET method)
> >
> > > To: vantage@yahoogroups .com
> >
> > > Date: Monday, June 23, 2008, 3:15 AM
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > > Hi,
> >
> > >
> >
> > >
> >
> > >
> >
> > > I am trying to use 4GL code in BPM to get data from Vantage and put
> > > it
> >
> > >
> >
> > > into file. I want to do this each time Customer.Update method is
> >
> > >
> >
> > > executed.
> >
> > >
> >
> > >
> >
> > >
> >
> > > Please take a look at code I am executing
> >
> > >
> >
> > >
> >
> > >
> >
> > > OUTPUT TO "/path/to/my/ file.txt" .
> >
> > >
> >
> > > EXPORT STRING(NOW)+ "Base Customer.Update( )" + ttCustomer.CustID.
> >
> > >
> >
> > > OUTPUT CLOSE.
> >
> > >
> >
> > >
> >
> > >
> >
> > > Unfortunately the ttCustomer is temp table and in output file I get
> >
> > >
> >
> > > "** No ttCustomer record is available. (91)"
> >
> > >
> >
> > >
> >
> > >
> >
> > > Can anyone know how can I have an access to data of Customer being
> >
> > >
> >
> > > updated? or maybe someone have an example of .NET method that I can
> >
> > >
> >
> > > modify?
> >
> > >
> >
> > >
> >
> > >
> >
> > > Grzegorz Szczepañski
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> > >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>


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

I am trying to use 4GL code in BPM to get data from Vantage and put it
into file. I want to do this each time Customer.Update method is
executed.

Please take a look at code I am executing

OUTPUT TO "/path/to/my/file.txt".
EXPORT STRING(NOW)+ "Base Customer.Update()" + ttCustomer.CustID.
OUTPUT CLOSE.

Unfortunately the ttCustomer is temp table and in output file I get
"** No ttCustomer record is available. (91)"

Can anyone know how can I have an access to data of Customer being
updated? or maybe someone have an example of .NET method that I can
modify?


Grzegorz Szczepañski
3
Try executing BEFORE the update actually occurs. The tt data may be null after update as it may only reflect in-app-session changes to data that are then used to update the db in a full commit write. With the inconsistencies I've seen in VB.NET object method & property polling behavior, I suspect some apps don't carry a full copy of the data set in the tt data.

Also: Just to be sure it isn't a syntax issue with your concatenation of multiple values (or with your export file), try to display ttCustomer.CustID in a message box window to see if you still get the error message.

If that works, try displaying your concatenated string in the message box (and if that works, try exporting it to your file).

It looks like you are doing nothing more than creating a change log file.

Why not just use Vantage's built in change log?

RE: Doing this with VB.NET customization: You can probably trap the after customer adapter 'update' method and grab the updated value from the record open on screen. (Trapping both before and after update would give you the old value and the new changed-to value if that is your goal.)

Rob Brown

--- On Mon, 6/23/08, phoenix <phoenix_@...> wrote:
From: phoenix <phoenix_@...>
Subject: [Vantage] 4GL in BPM (or .NET method)
To: vantage@yahoogroups.com
Date: Monday, June 23, 2008, 3:15 AM











Hi,



I am trying to use 4GL code in BPM to get data from Vantage and put it

into file. I want to do this each time Customer.Update method is

executed.



Please take a look at code I am executing



OUTPUT TO "/path/to/my/ file.txt" .

EXPORT STRING(NOW)+ "Base Customer.Update( )" + ttCustomer.CustID.

OUTPUT CLOSE.



Unfortunately the ttCustomer is temp table and in output file I get

"** No ttCustomer record is available. (91)"



Can anyone know how can I have an access to data of Customer being

updated? or maybe someone have an example of .NET method that I can

modify?



Grzegorz Szczepañski
4
We upgraded to Vantage 8.03.405. When we upgraded to 8.03.404 (a ??) we
lost the ability to update our engineering workbench on configurator
items. This is putting a major kink in our business. Are there other
users of the configurator that are experiencing the same issues?
Apparently Vantage hangs up when the part is checked back in.



Regards,





Andrew Best



[Non-text portions of this message have been removed]
5
> We upgraded to Vantage 8.03.405. When we upgraded to 8.03.404 (a ??) we
> lost the ability to update our engineering workbench on configurator
> items. This is putting a major kink in our business. Are there other
> users of the configurator that are experiencing the same issues?
> Apparently Vantage hangs up when the part is checked back in.

I have been building Configured Parts in 404B with no problems in the
Engineering Work Bench. (Some issues with globals but...)

Mark W.
6
We are on 8.03.403D and haven't had any crash type issues.

My issues are just trying to maintain the proper sequence when
changing the MOM of a configured part. Are the following two
statements true?

To change the MOM of the configured part requires "Checking Out" the
part using the Eng Workbench. After changes to the MOM, the part
must be approved and then checked-in.

To change the configurator for an existing configurable part only
requires that the part be set as unrealeased, the changes made, and
then the part be set back to released.

Thanks,

Calvin

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> > We upgraded to Vantage 8.03.405. When we upgraded to 8.03.404
(a ??) we
> > lost the ability to update our engineering workbench on
configurator
> > items. This is putting a major kink in our business. Are there
other
> > users of the configurator that are experiencing the same issues?
> > Apparently Vantage hangs up when the part is checked back in.
>
> I have been building Configured Parts in 404B with no problems in
the
> Engineering Work Bench. (Some issues with globals but...)
>
> Mark W.
>
7
> To change the MOM of the configured part requires "Checking Out" the
> part using the Eng Workbench. After changes to the MOM, the part
> must be approved and then checked-in.

ALL part revision must be checked out in order to change the MOM, including
Configurable parts. Changes will not appear in your Rules tab until you
check in the revision.

> To change the configurator for an existing configurable part only
> requires that the part be set as unrealeased, the changes made, and
> then the part be set back to released.

If by "released" you mean "Approved" the Revision then that is correct.

When I make a configuration change to a configurable part revision, I

1.) Un-approve the Configuration.

2.) Mark the Part Revision as Not Approved.

3.) If making MOM changes, I check out the Part Revision to EWB, make
changes, Approve the Revision, Check it back it.

4.) Refresh my Configuration Screen to update MOM changes.

5.) Make Configuration changes, if any, then approve the Configuration

6.) Approve the Revision.

HTH,

Mark W.
8
Andrew,



I did notice at one patch level(I don't recall which) where check in
would appear to make it hang. If I waited long enough however it would
complete the check in process. Give it a few minutes and see if it will
complete.



I am on 404A and it no longer does that. My assumption was that 404A
fixed it.



Todd



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Andrew Best
Sent: Monday, June 23, 2008 9:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Configurator Issues



We upgraded to Vantage 8.03.405. When we upgraded to 8.03.404 (a ??) we
lost the ability to update our engineering workbench on configurator
items. This is putting a major kink in our business. Are there other
users of the configurator that are experiencing the same issues?
Apparently Vantage hangs up when the part is checked back in.

Regards,

Andrew Best

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





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

As far as I know your statements are true.

Ed




----- Original Message ----
From: Calvin Krusen <ckrusen@...>
To: vantage@yahoogroups.com
Sent: Monday, June 23, 2008 9:17:24 AM
Subject: [Vantage] Re: Configurator Issues


We are on 8.03.403D and haven't had any crash type issues.

My issues are just trying to maintain the proper sequence when
changing the MOM of a configured part. Are the following two
statements true?

To change the MOM of the configured part requires "Checking Out" the
part using the Eng Workbench. After changes to the MOM, the part
must be approved and then checked-in.

To change the configurator for an existing configurable part only
requires that the part be set as unrealeased, the changes made, and
then the part be set back to released.

Thanks,

Calvin

--- In vantage@yahoogroups .com, "Mark Wonsil" <mark_wonsil@ ...> wrote:
>
> > We upgraded to Vantage 8.03.405. When we upgraded to 8.03.404
(a ??) we
> > lost the ability to update our engineering workbench on
configurator
> > items. This is putting a major kink in our business. Are there
other
> > users of the configurator that are experiencing the same issues?
> > Apparently Vantage hangs up when the part is checked back in.
>
> I have been building Configured Parts in 404B with no problems in
the
> Engineering Work Bench. (Some issues with globals but...)
>
> Mark W.
>






[Non-text portions of this message have been removed]
10
We are also on 404B and I have had no problems with the Engineering
Workbench, but I have had issues with rules when we change the MOM in
the EW. We have had to change the MOM and input fields several times
and this wouldn't really be a problem except that one of things I was
unaware of is that everytime I change the MOM, the rules remained for
MOM levels that no longer exist or maintains rules to levels that still
exist but now have a fewer number of rules. I just foolishly assumed
that when you deleted the material or operation sequence in Engineering
Workbench and approved it and checked it back in, that the rules
attached were deleted with it since I could no longer see them...
apparently, no, they are not. Then I compounded this by creating
duplicate parts so that we could test or go back to previous versions
while I worked on the changes to the new one. I can't see these rules
even when the sequence exists, so I can't delete them. I tried bringing
in all previous MOM's and deleted those rules, but I am still missing
something.

This has caused the PC to not configure parts properly, or at times,
not configure them at all. And sometimes lock up and act outright
just "buggy", but that may just be the release we are on. I am
fighting this right now and am trying desperately to avoid having to
start over. I'm new enough to all this not to know if this is just my
inexperience or a real problem within PC/Vantage. I don't know if
anyone else has had this problem, but I hope this helps someone else
not make the same error I did.

Tara M.

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> > We upgraded to Vantage 8.03.405. When we upgraded to 8.03.404
(a ??) we
> > lost the ability to update our engineering workbench on configurator
> > items. This is putting a major kink in our business. Are there other
> > users of the configurator that are experiencing the same issues?
> > Apparently Vantage hangs up when the part is checked back in.
>
> I have been building Configured Parts in 404B with no problems in the
> Engineering Work Bench. (Some issues with globals but...)
>
> Mark W.
>
11
Tara,

We experienced this problem in April and received the following reply
in response to a call we posted.
---------------------------------------
4/14/2008 9:39:27 AM
By: NLEEMAN

Dave,

When making configurator changes, you *need* to remove the configured
rules and inputs first, then remove the materials from the method.
Doing this in the wrong order will corrupt that part. Your best bet at
this point is to delete the duplicated part, and then re-duplicate and
correct your procedure.

Thanks,
-----------------------------------------
We are also on 404B.

Dave
Xybix
8.03.404B

--- In vantage@yahoogroups.com, "Tara Madia" <tmadia@...> wrote:
>
> We are also on 404B and I have had no problems with the Engineering
> Workbench, but I have had issues with rules when we change the MOM in
> the EW. We have had to change the MOM and input fields several times
> and this wouldn't really be a problem except that one of things I was
> unaware of is that everytime I change the MOM, the rules remained for
> MOM levels that no longer exist or maintains rules to levels that still
> exist but now have a fewer number of rules. I just foolishly assumed
> that when you deleted the material or operation sequence in Engineering
> Workbench and approved it and checked it back in, that the rules
> attached were deleted with it since I could no longer see them...
> apparently, no, they are not. Then I compounded this by creating
> duplicate parts so that we could test or go back to previous versions
> while I worked on the changes to the new one. I can't see these rules
> even when the sequence exists, so I can't delete them. I tried bringing
> in all previous MOM's and deleted those rules, but I am still missing
> something.
>
> This has caused the PC to not configure parts properly, or at times,
> not configure them at all. And sometimes lock up and act outright
> just "buggy", but that may just be the release we are on. I am
> fighting this right now and am trying desperately to avoid having to
> start over. I'm new enough to all this not to know if this is just my
> inexperience or a real problem within PC/Vantage. I don't know if
> anyone else has had this problem, but I hope this helps someone else
> not make the same error I did.
>
> Tara M.
12
Andrew,

I'm unclear as to whether the change to 404A or the change to 405
seemed to coincide with the problem? Did the problem exist in 404A and
405?
We are on 404B and have not seen this problem.

Dave
Xybix
8.03.404B

--- In vantage@yahoogroups.com, "Andrew Best" <abest@...> wrote:
>
> We upgraded to Vantage 8.03.405. When we upgraded to 8.03.404 (a ??) we
> lost the ability to update our engineering workbench on configurator
> items. This is putting a major kink in our business. Are there other
> users of the configurator that are experiencing the same issues?
> Apparently Vantage hangs up when the part is checked back in.
>
>
>
> Regards,
>
>
>
>
>
> Andrew Best
>
>
>
> [Non-text portions of this message have been removed]
>
13
Yes, it started with 404A and was not corrected with 405.



Regards,





Andrew Best



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ofcwiz
Sent: Monday, June 23, 2008 1:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Configurator Issues



Andrew,

I'm unclear as to whether the change to 404A or the change to 405
seemed to coincide with the problem? Did the problem exist in 404A and
405?
We are on 404B and have not seen this problem.

Dave
Xybix
8.03.404B

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Andrew Best" <abest@...> wrote:
>
> We upgraded to Vantage 8.03.405. When we upgraded to 8.03.404 (a ??)
we
> lost the ability to update our engineering workbench on configurator
> items. This is putting a major kink in our business. Are there other
> users of the configurator that are experiencing the same issues?
> Apparently Vantage hangs up when the part is checked back in.
>
>
>
> Regards,
>
>
>
>
>
> Andrew Best
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
14
I was already trying to use BEFORE Customer.Update but the result was
the same. Regarding Message Box. I am using 4GL code, and I can't
display any graphical notification at this level.

But I raised exception with ttCustomer.CustID field as parameter and it
wasn't empty string.

So two actions. The first one output to file information that
ttCustomer.CustID is empty and the 2'nd is showing me that data.
Strange for me.

The build in Vantage ChangeLog doesn't handle all the fields. The
structure of this changeLog is also not good for further processing.

The way with using customisation and grab data after customer "update"
adapter was invoked is also one of my aproach but is seems to be less
clear than having everything in one place (BPM).

Grzegorz Szczepański

Dnia Mon, 23 Jun 2008 05:22:24 -0700 (PDT)
Robert Brown <robertb_versa@...> napisał(a):

> Try executing BEFORE the update actually occurs. The tt data may be
> null after update as it may only reflect in-app-session changes to
> data that are then used to update the db in a full commit write. With
> the inconsistencies I've seen in VB.NET object method & property
> polling behavior, I suspect some apps don't carry a full copy of the
> data set in the tt data.
>
> Also: Just to be sure it isn't a syntax issue with your concatenation
> of multiple values (or with your export file), try to display
> ttCustomer.CustID in a message box window to see if you still get the
> error message.
>
> If that works, try displaying your concatenated string in the message
> box (and if that works, try exporting it to your file).
>
> It looks like you are doing nothing more than creating a change log
> file.
>
> Why not just use Vantage's built in change log?
>
> RE: Doing this with VB.NET customization: You can probably trap the
> after customer adapter 'update' method and grab the updated value
> from the record open on screen. (Trapping both before and after
> update would give you the old value and the new changed-to value if
> that is your goal.)
>
> Rob Brown
>
> --- On Mon, 6/23/08, phoenix <phoenix_@...> wrote:
> From: phoenix <phoenix_@...>
> Subject: [Vantage] 4GL in BPM (or .NET method)
> To: vantage@yahoogroups.com
> Date: Monday, June 23, 2008, 3:15 AM
>
>
>
>
>
>
>
>
>
>
>
> Hi,
>
>
>
> I am trying to use 4GL code in BPM to get data from Vantage and put it
>
> into file. I want to do this each time Customer.Update method is
>
> executed.
>
>
>
> Please take a look at code I am executing
>
>
>
> OUTPUT TO "/path/to/my/ file.txt" .
>
> EXPORT STRING(NOW)+ "Base Customer.Update( )" + ttCustomer.CustID.
>
> OUTPUT CLOSE.
>
>
>
> Unfortunately the ttCustomer is temp table and in output file I get
>
> "** No ttCustomer record is available. (91)"
>
>
>
> Can anyone know how can I have an access to data of Customer being
>
> updated? or maybe someone have an example of .NET method that I can
>
> modify?
>
>
>
> Grzegorz Szczepañski
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
15
Grzegorz,

4GL supports a pop up message box. I'm on vacation and don't have any handy guide as to the syntax but it exists (as we've used it to debug & build BPMs).

The fact that you say ttCustomer.CustID set as an exception wasn't an empty string suggest to me your concatenation code is at fault. It could be as simple as requiring parenthesis around your

STRING(NOW)+ "Base Customer.Update( )" + ttCustomer.CustID

statement.

You didn't list the full code so it is not possible to see if the order of statements is causing your problem.

I agree with using BPM over VB customizations. A single BPM can impact multiple applications that trigger the same event (versus having to customize multiple apps to get the same total effect).

Rob Brown



--- On Tue, 6/24/08, phoenix <phoenix_@...> wrote:
From: phoenix <phoenix_@...>
Subject: Re: [Vantage] 4GL in BPM (or .NET method)
To: vantage@yahoogroups.com
Date: Tuesday, June 24, 2008, 5:23 PM











I was already trying to use BEFORE Customer.Update but the result was

the same. Regarding Message Box. I am using 4GL code, and I can't

display any graphical notification at this level.



But I raised exception with ttCustomer.CustID field as parameter and it

wasn't empty string.



So two actions. The first one output to file information that

ttCustomer.CustID is empty and the 2'nd is showing me that data.

Strange for me.



The build in Vantage ChangeLog doesn't handle all the fields. The

structure of this changeLog is also not good for further processing.



The way with using customisation and grab data after customer "update"

adapter was invoked is also one of my aproach but is seems to be less

clear than having everything in one place (BPM).



Grzegorz Szczepański



Dnia Mon, 23 Jun :22: (PDT)

Robert Brown <robertb_versa@ yahoo.com> napisał(a):



> Try executing BEFORE the update actually occurs. The tt data may be

> null after update as it may only reflect in-app-session changes to

> data that are then used to update the db in a full commit write. With

> the inconsistencies I've seen in VB.NET object method & property

> polling behavior, I suspect some apps don't carry a full copy of the

> data set in the tt data.

>

> Also: Just to be sure it isn't a syntax issue with your concatenation

> of multiple values (or with your export file), try to display

> ttCustomer.CustID in a message box window to see if you still get the

> error message.

>

> If that works, try displaying your concatenated string in the message

> box (and if that works, try exporting it to your file).

>

> It looks like you are doing nothing more than creating a change log

> file.

>

> Why not just use Vantage's built in change log?

>

> RE: Doing this with VB.NET customization: You can probably trap the

> after customer adapter 'update' method and grab the updated value

> from the record open on screen. (Trapping both before and after

> update would give you the old value and the new changed-to value if

> that is your goal.)

>

> Rob Brown

>

> --- On Mon, 6/23/08, phoenix <phoenix_@wp. pl> wrote:

> From: phoenix <phoenix_@wp. pl>

> Subject: [Vantage] 4GL in BPM (or .NET method)

> To: vantage@yahoogroups .com

> Date: Monday, June 23, 2008, 3:15 AM

>

>

>

>

>

>

>

>

>

>

>

> Hi,

>

>

>

> I am trying to use 4GL code in BPM to get data from Vantage and put it

>

> into file. I want to do this each time Customer.Update method is

>

> executed.

>

>

>

> Please take a look at code I am executing

>

>

>

> OUTPUT TO "/path/to/my/ file.txt" .

>

> EXPORT STRING(NOW)+ "Base Customer.Update( )" + ttCustomer.CustID.

>

> OUTPUT CLOSE.

>

>

>

> Unfortunately the ttCustomer is temp table and in output file I get

>

> "** No ttCustomer record is available. (91)"

>

>

>

> Can anyone know how can I have an access to data of Customer being

>

> updated? or maybe someone have an example of .NET method that I can

>

> modify?

>

>

>

> Grzegorz Szczepañski

>

>

>

>

>

>

>

>

>

>

>

>

>

>

>

>

>

>

>

>

>

>

>

>

>

>
16
Rob,

It will be very usefull if you can post 4GL code that can pop up a
message box. Regarding ttCustomer.CustID - I was trying the most
simple version like:

OUTPUT TO "/usr/local/epicor/mfgsys803/bpm/GS/cus_u.txt".
EXPORT ttCustomer.CustID.
OUTPUT CLOSE.

and the file cus_u.txt was created, inside the file was only the below
information

** No ttCustomer record is available. (91)

So it seems like ttCustomer table with some reasons is not available.
As someone mentioned there is also possibility that Vantage doesn't
commit the full write to DB, so I was trying also put into the file
ttCustomer.Name which I changed before saving. The result was the same.

The code which I paste above it is the whole code that I put into 4GL
action, selecting "Execute code below" check box.

Grzegorz Szczepañski


Dnia Tue, 24 Jun 2008 16:15:13 -0700 (PDT)
Robert Brown <robertb_versa@...> napisał(a):

> Grzegorz,
>
> 4GL supports a pop up message box. I'm on vacation and don't have any
> handy guide as to the syntax but it exists (as we've used it to debug
> & build BPMs).
>
> The fact that you say ttCustomer.CustID set as an exception wasn't an
> empty string suggest to me your concatenation code is at fault. It
> could be as simple as requiring parenthesis around your
>
> STRING(NOW)+ "Base Customer.Update( )" + ttCustomer.CustID
>
> statement.
>
> You didn't list the full code so it is not possible to see if the
> order of statements is causing your problem.
>
> I agree with using BPM over VB customizations. A single BPM can
> impact multiple applications that trigger the same event (versus
> having to customize multiple apps to get the same total effect).
>
> Rob Brown
>
>
>
> --- On Tue, 6/24/08, phoenix <phoenix_@...> wrote:
> From: phoenix <phoenix_@...>
> Subject: Re: [Vantage] 4GL in BPM (or .NET method)
> To: vantage@yahoogroups.com
> Date: Tuesday, June 24, 2008, 5:23 PM
>
>
>
>
>
>
>
>
>
>
>
> I was already trying to use BEFORE Customer.Update but
> the result was
>
> the same. Regarding Message Box. I am using 4GL code, and I can't
>
> display any graphical notification at this level.
>
>
>
> But I raised exception with ttCustomer.CustID field as parameter and
> it
>
> wasn't empty string.
>
>
>
> So two actions. The first one output to file information that
>
> ttCustomer.CustID is empty and the 2'nd is showing me that data.
>
> Strange for me.
>
>
>
> The build in Vantage ChangeLog doesn't handle all the fields. The
>
> structure of this changeLog is also not good for further processing.
>
>
>
> The way with using customisation and grab data after customer "update"
>
> adapter was invoked is also one of my aproach but is seems to be less
>
> clear than having everything in one place (BPM).
>
>
>
> Grzegorz Szczepański
>
>
>
> Dnia Mon, 23 Jun :22: (PDT)
>
> Robert Brown <robertb_versa@ yahoo.com> napisał(a):
>
>
>
> > Try executing BEFORE the update actually occurs. The tt data may be
>
> > null after update as it may only reflect in-app-session changes to
>
> > data that are then used to update the db in a full commit write.
> > With
>
> > the inconsistencies I've seen in VB.NET object method & property
>
> > polling behavior, I suspect some apps don't carry a full copy of the
>
> > data set in the tt data.
>
> >
>
> > Also: Just to be sure it isn't a syntax issue with your
> > concatenation
>
> > of multiple values (or with your export file), try to display
>
> > ttCustomer.CustID in a message box window to see if you still get
> > the
>
> > error message.
>
> >
>
> > If that works, try displaying your concatenated string in the
> > message
>
> > box (and if that works, try exporting it to your file).
>
> >
>
> > It looks like you are doing nothing more than creating a change log
>
> > file.
>
> >
>
> > Why not just use Vantage's built in change log?
>
> >
>
> > RE: Doing this with VB.NET customization: You can probably trap the
>
> > after customer adapter 'update' method and grab the updated value
>
> > from the record open on screen. (Trapping both before and after
>
> > update would give you the old value and the new changed-to value if
>
> > that is your goal.)
>
> >
>
> > Rob Brown
>
> >
>
> > --- On Mon, 6/23/08, phoenix <phoenix_@wp. pl> wrote:
>
> > From: phoenix <phoenix_@wp. pl>
>
> > Subject: [Vantage] 4GL in BPM (or .NET method)
>
> > To: vantage@yahoogroups .com
>
> > Date: Monday, June 23, 2008, 3:15 AM
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> > Hi,
>
> >
>
> >
>
> >
>
> > I am trying to use 4GL code in BPM to get data from Vantage and put
> > it
>
> >
>
> > into file. I want to do this each time Customer.Update method is
>
> >
>
> > executed.
>
> >
>
> >
>
> >
>
> > Please take a look at code I am executing
>
> >
>
> >
>
> >
>
> > OUTPUT TO "/path/to/my/ file.txt" .
>
> >
>
> > EXPORT STRING(NOW)+ "Base Customer.Update( )" + ttCustomer.CustID.
>
> >
>
> > OUTPUT CLOSE.
>
> >
>
> >
>
> >
>
> > Unfortunately the ttCustomer is temp table and in output file I get
>
> >
>
> > "** No ttCustomer record is available. (91)"
>
> >
>
> >
>
> >
>
> > Can anyone know how can I have an access to data of Customer being
>
> >
>
> > updated? or maybe someone have an example of .NET method that I can
>
> >
>
> > modify?
>
> >
>
> >
>
> >
>
> > Grzegorz Szczepañski
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>