Ground control

Yahoo Archive
1
The F2 should work OK with syntax SENDKEYS("{F2}") but I can't get the ALT
key to work either. I'm having to use Mouse commands. As I use GC on only
one PC, the screen locations remain constant but I'd feel happier/more
secure using ALT. Acrasoft support haven't been a whole heap of help either.
I think it might be a difference between US and UK keyboards.
Mark Twain is probably right again!
Feel free to contact me direct if you want.
Regards,
Richard

Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...

-----Original Message-----
From: andrewcretors [mailto:acretors@...]
Sent: 02 November 2004 14:41
To: vantage@yahoogroups.com
Subject: [Vantage] Ground control



To all,
Has anyone been able to send keyboard combinations using ground
control?

I am trying to automate the navigation of the screens from the part
master for a given record to the warehouses screen. I would like to
send ALT+I then ALT+W then ALT+A.

I tried doing this with the mousemoveto and mouseleft functions, but
this requires that the screens pop up in the exact same locations
each time.

And what about the F2 key? This would be a good way to have the macro
save the changes and "back out" to the part master screen.

Thanks in advance for your help!

Andrew





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/links


Yahoo! Groups Sponsor

Get unlimited calls to

U.S./Canada




----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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

I'm interested in using Ground Control (use macro's in Vantage), but I need to know:

Can I use it in a network, running CITRIX Metaframe?
Or is it necessary to install it on clients (I use thin clients, that don't have a seperate HD, win-install, etc.)

Does anyone have any experience with this?

Thanks in advance,


Len Holtkamp
Project Manager
--------------------------------------------
Bumet BV
Buijsen Metaalindustrie, Heeze
www.Bumet.nl
Len.Holtkamp@...

> -----Oorspronkelijk bericht-----
> Van: Lepley, Scott A. [SMTP:sal@...]
> Verzonden: dinsdag 16 juli 2002 14:52
> Aan: 'vantage@yahoogroups.com'
> Onderwerp: RE: [Vantage] Re: User4User Conference Cancelled
>
> Patrick:
>
> I am not suggesting that the regional VUGs be replaced by the EUG.
> Companies that currently send employees to a regional VUG could, and
> hopefully would, still do so. Each VUG, in turn, would work with the EUG.
> The EUG would become a consolidation point for providing feedback to Epicor
> regarding Vantage, just as it is now regarding Manfact, Dataflo and Avanté.
>
> Regards,
> Scott
>
> -----Original Message-----
> From: Winter, Patrick [mailto:pjw@...]
> Sent: Tuesday, July 16, 2002 8:12 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Re: User4User Conference Cancelled
>
> Are you sure you want to hang around all those platinum/dataworks people.
> Just kidding. I think you have an excellent idea. By becoming part of EUG
> the vantage users would be able to gain more structure and back bone to our
> group. But the big issue will remain, what small company will be able to
> spend the money/time to work with the EUG?
>
> Patrick
>
> -----Original Message-----
> From: Lepley, Scott A. [mailto:sal@...]
> Sent: Monday, July 15, 2002 6:55 PM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Re: User4User Conference Cancelled
>
>
> So that a Vantage user conference does not need to achieve "critical mass"
> by itself, perhaps it makes sense for such an event to be held as part of a
> larger Epicor user conference. The Epicor Users Group (EUG) holds such a
> conference, which the EUG calls a forum. The EUG website address is
> <http://www.epicorusers.org> <<http://www.epicorusers.org>> <
> <http://www.epicorusers.org/> <<http://www.epicorusers.org/>> > . Maybe the
> time
> has come for all of the regional VUGs to collaborate with the EUG to be able
> to achieve some common objectives. Part of the EUG mission statement is to
> "provide a forum for mutual education and exchange of ideas and information
> among members", essentially the intent of the User4User conference.
>
> Collaboration with the EUG may have benefits beyond the mutual education
> aspect. Last week, I received a message from Rick Borg (Senior Vice
> President and General Manager, Manufacturing Solutions Group, Epicor
> Software) regarding an Epicor customer satisfaction survey. In his message,
> Rick stated "we have increased our involvement with the Epicor User Group to
> get specific feedback on the products and services we are delivering."
> While this statement might not have pertained to Vantage specifically,
> perhaps it could or should in the future.
>
> Regards,
> Scott Lepley
> Systems Administrator
> Phone: 717-432-8686, ext. 14
> Fax: 717-432-8688
> Email: sal@...
> Vantage version 5.10.119
>
>
> -----Original Message-----
> From: B_Stinger [mailto:bstenglein@...]
> Sent: Monday, July 15, 2002 1:39 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: User $ User Conference Cancelled
>
> I agree about the plane tickets, I hope they're refundable. I'm sure
> they'll take a big chunk out for cancelling. My management was
> excited about letting me go to this conference as opposed to Epicor's
> expensive event. But if we get burned with a big cancellation fee, >
> they might think twice next time (if there is a next time).
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@y..., Bob Goss <bobg@b...> wrote:
> > All I can say, is that I hope I can get a refund on my plane
> tickets.......I
> > haven't officially heard, but I will take your word for it and try
> and get
> > money back...This will go over well with our president....
> >
> > Bob Goss
> > BC Instruments
> >
> > 905-939-7323
> > www.bc-instruments.com
> >
> > -----Original Message-----
> > From: Dina Hieber [mailto:dhieber@v...]
> > Sent: Monday, July 15, 2002 1:02 PM
> > To: vantage@y...
> > Subject: Re: [Vantage] User $ User Conference Cancelled
> >
> > I agree with Todd. It was bad timing. I was not able to attend
> this
> > conference. I hope they can try this again sometime in the spring.
> >
> > D -
> >
> > Todd Caughey wrote:
> >
> > > Ditto to that Bummer. Great idea, poor timing (summer vacation
> season,
> > > budgets not fully restored, etc...). More "lead time" to get
> approval
> > would
> > > have helped too. I hope this can get tried again perhaps in the
> Spring
> > as
> > > a counterpoint to Perspectives. The focus on practical use and
> user
> > > interaction sounded a lot better than the Perspectives emphasis
> on selling
> > > modules.
> > > -Todd C.
> > >
> > > -----Original Message-----
> > > From: B_Stinger [mailto:bstenglein@c...]
> > > Sent: Monday, July 15, 2002 11:13 AM
> > > To: vantage@y...
> > > Subject: [Vantage] User $ User Conference Cancelled
> > >
> > > I just received a letter and a refund of my conference fees,
> stating
> > > that there was limited enrollment so the conference is being
> > > cancelled. Bummer!
> > >
> > > Brian Stenglein
> > > Clow Stamping Co.
> >
> > --
> > Dina M. Hieber
> > Vamco International, Inc.
> > 555 Epsilon Drive
> > Pittsburgh, PA 15238
> > (412) 963-7100 - phone
> > (412) 963-9511 - fax
> >
> > www.vamcointernational.com
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> <http://rd.yahoo.com/M=228862.2128520.3581629.1829184/D=egroupweb/S=1705007183:HM/A=1155065/R=0/*http://adfarm.mediaplex.com/ad/ck/990-1736-1039-302>
>
> 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/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/>.
3
Len,
Ground Control works very simply... It imitates keystrokes/mouse-clicks on a PC. Whatever that PC can do, if it can be translated to mouse clicks and keyboard strokes, then it can do it (plus a few more things).

Troy Funte
Liberty Electronics

----- Original Message -----
From: Len Holtkamp
To: vantage@yahoogroups.com
Sent: Tuesday, July 16, 2002 6:15 AM
Subject: [Vantage] Ground control


Hello!

I'm interested in using Ground Control (use macro's in Vantage), but I need to know:

Can I use it in a network, running CITRIX Metaframe?
Or is it necessary to install it on clients (I use thin clients, that don't have a seperate HD, win-install, etc.)

Does anyone have any experience with this?

Thanks in advance,


Len Holtkamp
Project Manager
--------------------------------------------
Bumet BV
Buijsen Metaalindustrie, Heeze
www.Bumet.nl
Len.Holtkamp@...

> -----Oorspronkelijk bericht-----
> Van: Lepley, Scott A. [SMTP:sal@...]
> Verzonden: dinsdag 16 juli 2002 14:52
> Aan: 'vantage@yahoogroups.com'
> Onderwerp: RE: [Vantage] Re: User4User Conference Cancelled
>
> Patrick:
>
> I am not suggesting that the regional VUGs be replaced by the EUG.
> Companies that currently send employees to a regional VUG could, and
> hopefully would, still do so. Each VUG, in turn, would work with the EUG.
> The EUG would become a consolidation point for providing feedback to Epicor
> regarding Vantage, just as it is now regarding Manfact, Dataflo and Avanté.
>
> Regards,
> Scott
>
> -----Original Message-----
> From: Winter, Patrick [mailto:pjw@...]
> Sent: Tuesday, July 16, 2002 8:12 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Re: User4User Conference Cancelled
>
> Are you sure you want to hang around all those platinum/dataworks people.
> Just kidding. I think you have an excellent idea. By becoming part of EUG
> the vantage users would be able to gain more structure and back bone to our
> group. But the big issue will remain, what small company will be able to
> spend the money/time to work with the EUG?
>
> Patrick
>
> -----Original Message-----
> From: Lepley, Scott A. [mailto:sal@...]
> Sent: Monday, July 15, 2002 6:55 PM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Re: User4User Conference Cancelled
>
>
> So that a Vantage user conference does not need to achieve "critical mass"
> by itself, perhaps it makes sense for such an event to be held as part of a
> larger Epicor user conference. The Epicor Users Group (EUG) holds such a
> conference, which the EUG calls a forum. The EUG website address is
> <http://www.epicorusers.org> <<http://www.epicorusers.org>> <
> <http://www.epicorusers.org/> <<http://www.epicorusers.org/>> > . Maybe the
> time
> has come for all of the regional VUGs to collaborate with the EUG to be able
> to achieve some common objectives. Part of the EUG mission statement is to
> "provide a forum for mutual education and exchange of ideas and information
> among members", essentially the intent of the User4User conference.
>
> Collaboration with the EUG may have benefits beyond the mutual education
> aspect. Last week, I received a message from Rick Borg (Senior Vice
> President and General Manager, Manufacturing Solutions Group, Epicor
> Software) regarding an Epicor customer satisfaction survey. In his message,
> Rick stated "we have increased our involvement with the Epicor User Group to
> get specific feedback on the products and services we are delivering."
> While this statement might not have pertained to Vantage specifically,
> perhaps it could or should in the future.
>
> Regards,
> Scott Lepley
> Systems Administrator
> Phone: 717-432-8686, ext. 14
> Fax: 717-432-8688
> Email: sal@...
> Vantage version 5.10.119
>
>
> -----Original Message-----
> From: B_Stinger [mailto:bstenglein@...]
> Sent: Monday, July 15, 2002 1:39 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: User $ User Conference Cancelled
>
> I agree about the plane tickets, I hope they're refundable. I'm sure
> they'll take a big chunk out for cancelling. My management was
> excited about letting me go to this conference as opposed to Epicor's
> expensive event. But if we get burned with a big cancellation fee, >
> they might think twice next time (if there is a next time).
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@y..., Bob Goss <bobg@b...> wrote:
> > All I can say, is that I hope I can get a refund on my plane
> tickets.......I
> > haven't officially heard, but I will take your word for it and try
> and get
> > money back...This will go over well with our president....
> >
> > Bob Goss
> > BC Instruments
> >
> > 905-939-7323
> > www.bc-instruments.com
> >
> > -----Original Message-----
> > From: Dina Hieber [mailto:dhieber@v...]
> > Sent: Monday, July 15, 2002 1:02 PM
> > To: vantage@y...
> > Subject: Re: [Vantage] User $ User Conference Cancelled
> >
> > I agree with Todd. It was bad timing. I was not able to attend
> this
> > conference. I hope they can try this again sometime in the spring.
> >
> > D -
> >
> > Todd Caughey wrote:
> >
> > > Ditto to that Bummer. Great idea, poor timing (summer vacation
> season,
> > > budgets not fully restored, etc...). More "lead time" to get
> approval
> > would
> > > have helped too. I hope this can get tried again perhaps in the
> Spring
> > as
> > > a counterpoint to Perspectives. The focus on practical use and
> user
> > > interaction sounded a lot better than the Perspectives emphasis
> on selling
> > > modules.
> > > -Todd C.
> > >
> > > -----Original Message-----
> > > From: B_Stinger [mailto:bstenglein@c...]
> > > Sent: Monday, July 15, 2002 11:13 AM
> > > To: vantage@y...
> > > Subject: [Vantage] User $ User Conference Cancelled
> > >
> > > I just received a letter and a refund of my conference fees,
> stating
> > > that there was limited enrollment so the conference is being
> > > cancelled. Bummer!
> > >
> > > Brian Stenglein
> > > Clow Stamping Co.
> >
> > --
> > Dina M. Hieber
> > Vamco International, Inc.
> > 555 Epsilon Drive
> > Pittsburgh, PA 15238
> > (412) 963-7100 - phone
> > (412) 963-9511 - fax
> >
> > www.vamcointernational.com
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> <http://rd.yahoo.com/M=228862.2128520.3581629.1829184/D=egroupweb/S=1705007183:HM/A=1155065/R=0/*http://adfarm.mediaplex.com/ad/ck/990-1736-1039-302>
>
> 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/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/>.

Yahoo! Groups Sponsor
ADVERTISEMENT



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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
4
Thanks Troy,

I understand that's what it does, but I'm wondering how this will work in my situation (the thin clients). These are basically just NIC's with a monitor attached to them. How will Ground Control know where the command came from, or where to send the action to? Will it work at all?

Thanks,
Len

> Len,
> Ground Control works very simply... It imitates keystrokes/mouse-clicks on a PC. Whatever that PC can do, if it can be translated to mouse clicks and keyboard strokes, then it can do it (plus a few more things).
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Len Holtkamp
> To: vantage@yahoogroups.com
> Sent: Tuesday, July 16, 2002 6:15 AM
> Subject: [Vantage] Ground control
>
>
> Hello!
>
> I'm interested in using Ground Control (use macro's in Vantage), but I need to know:
>
> Can I use it in a network, running CITRIX Metaframe?
> Or is it necessary to install it on clients (I use thin clients, that don't have a seperate HD, win-install, etc.)
>
> Does anyone have any experience with this?
>
> Thanks in advance,
>
>
> Len Holtkamp
> Project Manager
> --------------------------------------------
> Bumet BV
> Buijsen Metaalindustrie, Heeze
> www.Bumet.nl
> Len.Holtkamp@...
>
>
5
Len,
I see your point. If a number of NIC's are attached to the same machine, I'm not sure how Ground Control would see that. I guess you could try and see. There are some sample macro's that come with the GC program which you could try.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Len Holtkamp
To: vantage@yahoogroups.com
Sent: Tuesday, July 16, 2002 6:27 AM
Subject: RE: [Vantage] Ground control


Thanks Troy,

I understand that's what it does, but I'm wondering how this will work in my situation (the thin clients). These are basically just NIC's with a monitor attached to them. How will Ground Control know where the command came from, or where to send the action to? Will it work at all?

Thanks,
Len

> Len,
> Ground Control works very simply... It imitates keystrokes/mouse-clicks on a PC. Whatever that PC can do, if it can be translated to mouse clicks and keyboard strokes, then it can do it (plus a few more things).
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Len Holtkamp
> To: vantage@yahoogroups.com
> Sent: Tuesday, July 16, 2002 6:15 AM
> Subject: [Vantage] Ground control
>
>
> Hello!
>
> I'm interested in using Ground Control (use macro's in Vantage), but I need to know:
>
> Can I use it in a network, running CITRIX Metaframe?
> Or is it necessary to install it on clients (I use thin clients, that don't have a seperate HD, win-install, etc.)
>
> Does anyone have any experience with this?
>
> Thanks in advance,
>
>
> Len Holtkamp
> Project Manager
> --------------------------------------------
> Bumet BV
> Buijsen Metaalindustrie, Heeze
> www.Bumet.nl
> Len.Holtkamp@...
>
>

Yahoo! Groups Sponsor
ADVERTISEMENT



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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
6
I was curious to know how people are using ground control, to update
fields in vantage and if they would be willing to share macros with me?

Thanks, in advance.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...




[Non-text portions of this message have been removed]
7
Frank,
Ground Control is a wonderful tool.

We use Ground Control daily and also occasionally. Each night after the
evening Vantage backup runs, I have some batch files that restore the
Vantage backup to the TRAINING database. After that is done, the Task
Scheduler runs a Ground Control macro which renames the TRAINING database to
show the date and time that it was backed up. This allows users to know
when the database was last refreshed and that it is the TRAINING and not the
LIVE. So, our TRAINING database is always within 8 hrs old of the LIVE
database. (We also have a TEST database that we use for special testing and
projects that may need to remain untouched for longer periods of time. We
refresh the TEST database only as needed.)

We have also used Ground Control on various occasions for data entry
projects. For instance, one time we realized that we were not "unapproving"
BOM's after creating a new Revision of a BOM, and thus there was the
potential for someone to create a job for an older version of a BOM. We
used Ground Control to "unapprove" all the older versions of the BOM for
each part where there was more than one approved. I used a Crystal report
to generate the list of parts with double-approved revs, then exported the
part list to a text file. Ground Control read each part from the text file
and accomplished the necessary keystrokes to unapprove the older BOM for
that part. Saved us hours of time.

Another instance was when we had to close a warehouse and move all the
parts into the main warehouse. This time we used Excel to generate the TO
and FROM lists of warehouse, bin, and partnumber. These were then pasted
into a text file. Ground Control read the part from the text file,
transferred the part from the appropriate bin into the new bin and completed
the transaction. Again, it saved someone hours of time. We've done this
process several times. We even were able to use multiple computers with
Ground Control to move more parts at the same time (but kept the operator,
me, quite busy watching it all.)

The most recent application for Ground Control was when we updated the
Standard Cost on a couple thousand parts at Year End. Again, Excel was the
template for the new cost for each part. The list of PartNum and Cost were
exported to a text file, which Ground Control read from to make the Cost
Adjustment. I used three computers for that process and it took about two
hours. Manually it would have taken a few days. Audits on the parts showed
that the costs were all entered perfectly accurate (no typos). The only
glitch in this process was when two computers tried transferring a part at
exactly the same time and Vantage would try to issue the same RecID number
for the transaction to both computers. One of them would get an error. This
would mean stopping the macro on that computer, locating which part was last
completed, and starting the macro again from that part.

I used to use Ground Control to run exports from Vantage using Vantage's
export utility, but I eventually found out how to use progress routines to
do this more powerfully and quicker (and more reliably).

I've heard of others using Ground Control to run MRP on a regular basis, but
have never tried that one actually myself.

Troy Funte
Liberty Electronics

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Wednesday, April 30, 2003 10:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Ground control


I was curious to know how people are using ground control, to update
fields in vantage and if they would be willing to share macros with me?

Thanks, in advance.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...




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


Yahoo! Groups Sponsor



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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
8
To all,
Has anyone been able to send keyboard combinations using ground
control?

I am trying to automate the navigation of the screens from the part
master for a given record to the warehouses screen. I would like to
send ALT+I then ALT+W then ALT+A.

I tried doing this with the mousemoveto and mouseleft functions, but
this requires that the screens pop up in the exact same locations
each time.

And what about the F2 key? This would be a good way to have the macro
save the changes and "back out" to the part master screen.

Thanks in advance for your help!

Andrew