Run MRP Unattended

We also have been using the task scheduler for running MRP during the
night for over 2 years. Currently on 305K, testing 404B - no problems so
far.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charles Carden
Sent: Tuesday, May 13, 2008 2:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Run MRP Unattended



I have been scheduling it with 8.x since January 2007 without any
issues.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Kunal Ganguly
Sent: Tuesday, May 13, 2008 12:40 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: Run MRP Unattended

This deviates a bit from the original post. In 8.x, MRP can be automated
using the task scheduler. We ultimately plan on running it nightly (it
takes about 45 - 60 mins at the moment). Has anyone run into issues with
running MRP scheduler with the task scheduler in vantage?

Thanks,
Kunal

----- Original Message ----
From: golf_turn <mjd@... <mailto:mjd%40dbqstamp.com>
<mailto:mjd%40dbqstamp.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Tuesday, May 13, 2008 12:14:00 PM
Subject: [Vantage] Re: Run MRP Unattended

Ted,
Thanks for the tip. I have downloaded AutoIT and have perused the
online documentation but it is a bit overwhelming to me. Do you have
an example of how you used it to help me get started? Thanks.

Mike Dunn
Dubuque Stamping

--- In vantage@yahoogroups .com, "Ted Kitch" <tkitch@...> wrote:
>
> You can also do this with a freeware automation program called
AutoIT. It
> can be downloaded at www.autoitscript. com
<http://www.autoitsc ript.com/>
> and you won't have to deal with Access. It can be compiled,
scheduled and
> used in a variety of ways.
>
>
>
> HTH,
>
>
>
> Ted Kitch
>
> Information Technology Manager
>
> Astro Machine Corporation
>
> www.astromachine. com
>
>
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf Of
> Butch Menge
> Sent: Tuesday, May 06, 2008 2:03 PM
> To: vantage@yahoogroups .com
> Subject: RE: [Vantage] Run MRP Unattended
>
>
>
> I use Microsoft Access and the sendkey function. Here is how it
works:
>
> Vantage
>
> Create a security group called MRP in Vantage
>
> Assign the MRP group using Menu Security to the minimal path to get
to
> the MRP option
>
> Create a user ID and assign it to the MRP security group
>
> Microsoft Access
>
> Create a new module and paste the following code:
>
> Public Function RunMRP()
>
> Dim RetVal
>
> RetVal = Shell("V:\mfgsys61\ mfg.exe v:\Vantage.MFG" , vbNormalFocus)
>
> Wait 45
>
> AppActivate "System Login", False
>
> 'User ID
>
> SendKeys "mrp01", True
>
> SendKeys "{Tab}", True
>
> 'Password
>
> Wait 1
>
> SendKeys "mypassword" , True
>
> SendKeys "{F2}", True
>
> Wait 2 'To display the program
>
> 'Select MRP option
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> 'Launch MRP
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> 'Do a Regen - need to wait about an hour
>
> SendKeys "{Right}", True
>
> SendKeys "{F2}", True
>
> Wait 3600
>
> 'Run complete so press Enter
>
> SendKeys "{Enter}", True
>
> Wait 1
>
> 'Close down the application
>
> SendKeys "%{F4}"
>
> Wait 0.5
>
> SendKeys "{Left}"
>
> Wait 0.5
>
> SendKeys "{Enter}"
>
> End Function
>
> Sub Wait(PauseTime)
>
> 'slows down the sendkeys because it is too fast for Vantage
>
> Dim Start
>
> Start = Timer ' Set start time.
>
> Do While Timer < Start + PauseTime
>
> DoEvents ' Yield to other processes.
>
> Loop
>
> End Sub
>
> Create a macro called AutoExec to start the process when the
database is
> launched:
>
> run the code (RunMRP)
>
> exit the application (shutdown Access)
>
> In Windows use the Task Scheduler to open the database at whatever
time
> you want MRP to be run
>
> In summary what happens:
>
> Windows Task Scheduler opens the Access database
>
> AutoExec runs the code RunMRP
>
> RunMRP launches Vantage and runs an MRP Regen
>
> An hour later RunMRP closes Vantage
>
> AutoExec then closes the database
>
> Hope that gives you a starting point.
>
> Butch
>
> ____________ _________ _________ __
>
> From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> [mailto:vantage@yahoogroups .com <mailto:vantage%
40yahoogroups. com> ] On
> Behalf
> Of golf_turn
> Sent: Tuesday, May 06, 2008 11:10 AM
> To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> Subject: [Vantage] Run MRP Unattended
>
> Does anyone run MRP unattended in 6.1 using something other than
> Service Connect? We manually run it every evening and are seeking a
> more economical alternative than Service Connect. Thanks.
>
> Mike Dunn
> Dubuque Stamping
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

Charles Carden
Manager, MIS
Manitex, Inc.
Phone: 512-942-3086
Fax: 512-942-3089

DISCLAIMER:
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

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






[Non-text portions of this message have been removed]
Does anyone run MRP unattended in 6.1 using something other than
Service Connect? We manually run it every evening and are seeking a
more economical alternative than Service Connect. Thanks.

Mike Dunn
Dubuque Stamping
I use Microsoft Access and the sendkey function. Here is how it works:



Vantage

Create a security group called MRP in Vantage

Assign the MRP group using Menu Security to the minimal path to get to
the MRP option

Create a user ID and assign it to the MRP security group



Microsoft Access

Create a new module and paste the following code:

Public Function RunMRP()



Dim RetVal



RetVal = Shell("V:\mfgsys61\mfg.exe v:\Vantage.MFG", vbNormalFocus)



Wait 45



AppActivate "System Login", False



'User ID

SendKeys "mrp01", True

SendKeys "{Tab}", True



'Password

Wait 1

SendKeys "mypassword", True

SendKeys "{F2}", True

Wait 2 'To display the program



'Select MRP option

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5



SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5



SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5



'Launch MRP

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5



'Do a Regen - need to wait about an hour

SendKeys "{Right}", True

SendKeys "{F2}", True

Wait 3600



'Run complete so press Enter

SendKeys "{Enter}", True

Wait 1



'Close down the application

SendKeys "%{F4}"

Wait 0.5

SendKeys "{Left}"

Wait 0.5

SendKeys "{Enter}"



End Function



Sub Wait(PauseTime)



'slows down the sendkeys because it is too fast for Vantage



Dim Start



Start = Timer ' Set start time.



Do While Timer < Start + PauseTime

DoEvents ' Yield to other processes.

Loop



End Sub



Create a macro called AutoExec to start the process when the database is
launched:

run the code (RunMRP)

exit the application (shutdown Access)



In Windows use the Task Scheduler to open the database at whatever time
you want MRP to be run



In summary what happens:

Windows Task Scheduler opens the Access database

AutoExec runs the code RunMRP

RunMRP launches Vantage and runs an MRP Regen

An hour later RunMRP closes Vantage

AutoExec then closes the database



Hope that gives you a starting point.

Butch



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of golf_turn
Sent: Tuesday, May 06, 2008 11:10 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Run MRP Unattended



Does anyone run MRP unattended in 6.1 using something other than
Service Connect? We manually run it every evening and are seeking a
more economical alternative than Service Connect. Thanks.

Mike Dunn
Dubuque Stamping





[Non-text portions of this message have been removed]
I didn't even know Service Connect was available to use in 6.1 We own it
but have been waiting to upgrade to V8. Can anyone tell me how we can
use service connect w/ 6.1 to run MRP?

________________________________

From: Butch Menge [mailto:bmenge@...]
Sent: Tuesday, May 06, 2008 2:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Run MRP Unattended



I use Microsoft Access and the sendkey function. Here is how it works:

Vantage

Create a security group called MRP in Vantage

Assign the MRP group using Menu Security to the minimal path to get to
the MRP option

Create a user ID and assign it to the MRP security group

Microsoft Access

Create a new module and paste the following code:

Public Function RunMRP()

Dim RetVal

RetVal = Shell("V:\mfgsys61\mfg.exe v:\Vantage.MFG", vbNormalFocus)

Wait 45

AppActivate "System Login", False

'User ID

SendKeys "mrp01", True

SendKeys "{Tab}", True

'Password

Wait 1

SendKeys "mypassword", True

SendKeys "{F2}", True

Wait 2 'To display the program

'Select MRP option

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

'Launch MRP

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

'Do a Regen - need to wait about an hour

SendKeys "{Right}", True

SendKeys "{F2}", True

Wait 3600

'Run complete so press Enter

SendKeys "{Enter}", True

Wait 1

'Close down the application

SendKeys "%{F4}"

Wait 0.5

SendKeys "{Left}"

Wait 0.5

SendKeys "{Enter}"

End Function

Sub Wait(PauseTime)

'slows down the sendkeys because it is too fast for Vantage

Dim Start

Start = Timer ' Set start time.

Do While Timer < Start + PauseTime

DoEvents ' Yield to other processes.

Loop

End Sub

Create a macro called AutoExec to start the process when the database is
launched:

run the code (RunMRP)

exit the application (shutdown Access)

In Windows use the Task Scheduler to open the database at whatever time
you want MRP to be run

In summary what happens:

Windows Task Scheduler opens the Access database

AutoExec runs the code RunMRP

RunMRP launches Vantage and runs an MRP Regen

An hour later RunMRP closes Vantage

AutoExec then closes the database

Hope that gives you a starting point.

Butch

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of golf_turn
Sent: Tuesday, May 06, 2008 11:10 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Run MRP Unattended

Does anyone run MRP unattended in 6.1 using something other than
Service Connect? We manually run it every evening and are seeking a
more economical alternative than Service Connect. Thanks.

Mike Dunn
Dubuque Stamping

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






[Non-text portions of this message have been removed]
You can also do this with a freeware automation program called AutoIT. It
can be downloaded at www.autoitscript.com <http://www.autoitscript.com/>
and you won't have to deal with Access. It can be compiled, scheduled and
used in a variety of ways.



HTH,



Ted Kitch

Information Technology Manager

Astro Machine Corporation

www.astromachine.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Butch Menge
Sent: Tuesday, May 06, 2008 2:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Run MRP Unattended



I use Microsoft Access and the sendkey function. Here is how it works:

Vantage

Create a security group called MRP in Vantage

Assign the MRP group using Menu Security to the minimal path to get to
the MRP option

Create a user ID and assign it to the MRP security group

Microsoft Access

Create a new module and paste the following code:

Public Function RunMRP()

Dim RetVal

RetVal = Shell("V:\mfgsys61\mfg.exe v:\Vantage.MFG", vbNormalFocus)

Wait 45

AppActivate "System Login", False

'User ID

SendKeys "mrp01", True

SendKeys "{Tab}", True

'Password

Wait 1

SendKeys "mypassword", True

SendKeys "{F2}", True

Wait 2 'To display the program

'Select MRP option

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

'Launch MRP

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

'Do a Regen - need to wait about an hour

SendKeys "{Right}", True

SendKeys "{F2}", True

Wait 3600

'Run complete so press Enter

SendKeys "{Enter}", True

Wait 1

'Close down the application

SendKeys "%{F4}"

Wait 0.5

SendKeys "{Left}"

Wait 0.5

SendKeys "{Enter}"

End Function

Sub Wait(PauseTime)

'slows down the sendkeys because it is too fast for Vantage

Dim Start

Start = Timer ' Set start time.

Do While Timer < Start + PauseTime

DoEvents ' Yield to other processes.

Loop

End Sub

Create a macro called AutoExec to start the process when the database is
launched:

run the code (RunMRP)

exit the application (shutdown Access)

In Windows use the Task Scheduler to open the database at whatever time
you want MRP to be run

In summary what happens:

Windows Task Scheduler opens the Access database

AutoExec runs the code RunMRP

RunMRP launches Vantage and runs an MRP Regen

An hour later RunMRP closes Vantage

AutoExec then closes the database

Hope that gives you a starting point.

Butch

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of golf_turn
Sent: Tuesday, May 06, 2008 11:10 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Run MRP Unattended

Does anyone run MRP unattended in 6.1 using something other than
Service Connect? We manually run it every evening and are seeking a
more economical alternative than Service Connect. Thanks.

Mike Dunn
Dubuque Stamping

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





[Non-text portions of this message have been removed]
how do I pass a date into the MRP Cutoff date input on the screen using
access code?

________________________________

From: Butch Menge [mailto:bmenge@...]
Sent: Tuesday, May 06, 2008 2:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Run MRP Unattended



I use Microsoft Access and the sendkey function. Here is how it works:

Vantage

Create a security group called MRP in Vantage

Assign the MRP group using Menu Security to the minimal path to get to
the MRP option

Create a user ID and assign it to the MRP security group

Microsoft Access

Create a new module and paste the following code:

Public Function RunMRP()

Dim RetVal

RetVal = Shell("V:\mfgsys61\mfg.exe v:\Vantage.MFG", vbNormalFocus)

Wait 45

AppActivate "System Login", False

'User ID

SendKeys "mrp01", True

SendKeys "{Tab}", True

'Password

Wait 1

SendKeys "mypassword", True

SendKeys "{F2}", True

Wait 2 'To display the program

'Select MRP option

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

'Launch MRP

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

'Do a Regen - need to wait about an hour

SendKeys "{Right}", True

SendKeys "{F2}", True

Wait 3600

'Run complete so press Enter

SendKeys "{Enter}", True

Wait 1

'Close down the application

SendKeys "%{F4}"

Wait 0.5

SendKeys "{Left}"

Wait 0.5

SendKeys "{Enter}"

End Function

Sub Wait(PauseTime)

'slows down the sendkeys because it is too fast for Vantage

Dim Start

Start = Timer ' Set start time.

Do While Timer < Start + PauseTime

DoEvents ' Yield to other processes.

Loop

End Sub

Create a macro called AutoExec to start the process when the database is
launched:

run the code (RunMRP)

exit the application (shutdown Access)

In Windows use the Task Scheduler to open the database at whatever time
you want MRP to be run

In summary what happens:

Windows Task Scheduler opens the Access database

AutoExec runs the code RunMRP

RunMRP launches Vantage and runs an MRP Regen

An hour later RunMRP closes Vantage

AutoExec then closes the database

Hope that gives you a starting point.

Butch

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of golf_turn
Sent: Tuesday, May 06, 2008 11:10 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Run MRP Unattended

Does anyone run MRP unattended in 6.1 using something other than
Service Connect? We manually run it every evening and are seeking a
more economical alternative than Service Connect. Thanks.

Mike Dunn
Dubuque Stamping

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






[Non-text portions of this message have been removed]
do you have a setup script on using this to run vantage mrp?

________________________________

From: Ted Kitch [mailto:tkitch@...]
Sent: Tuesday, May 06, 2008 2:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Run MRP Unattended



You can also do this with a freeware automation program called AutoIT.
It
can be downloaded at www.autoitscript.com <http://www.autoitscript.com/
<http://www.autoitscript.com/> >
and you won't have to deal with Access. It can be compiled, scheduled
and
used in a variety of ways.

HTH,

Ted Kitch

Information Technology Manager

Astro Machine Corporation

www.astromachine.com

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Butch Menge
Sent: Tuesday, May 06, 2008 2:03 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Run MRP Unattended

I use Microsoft Access and the sendkey function. Here is how it works:

Vantage

Create a security group called MRP in Vantage

Assign the MRP group using Menu Security to the minimal path to get to
the MRP option

Create a user ID and assign it to the MRP security group

Microsoft Access

Create a new module and paste the following code:

Public Function RunMRP()

Dim RetVal

RetVal = Shell("V:\mfgsys61\mfg.exe v:\Vantage.MFG", vbNormalFocus)

Wait 45

AppActivate "System Login", False

'User ID

SendKeys "mrp01", True

SendKeys "{Tab}", True

'Password

Wait 1

SendKeys "mypassword", True

SendKeys "{F2}", True

Wait 2 'To display the program

'Select MRP option

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

'Launch MRP

SendKeys "{Down}", True

SendKeys "{Enter}", True

Wait 0.5

'Do a Regen - need to wait about an hour

SendKeys "{Right}", True

SendKeys "{F2}", True

Wait 3600

'Run complete so press Enter

SendKeys "{Enter}", True

Wait 1

'Close down the application

SendKeys "%{F4}"

Wait 0.5

SendKeys "{Left}"

Wait 0.5

SendKeys "{Enter}"

End Function

Sub Wait(PauseTime)

'slows down the sendkeys because it is too fast for Vantage

Dim Start

Start = Timer ' Set start time.

Do While Timer < Start + PauseTime

DoEvents ' Yield to other processes.

Loop

End Sub

Create a macro called AutoExec to start the process when the database is
launched:

run the code (RunMRP)

exit the application (shutdown Access)

In Windows use the Task Scheduler to open the database at whatever time
you want MRP to be run

In summary what happens:

Windows Task Scheduler opens the Access database

AutoExec runs the code RunMRP

RunMRP launches Vantage and runs an MRP Regen

An hour later RunMRP closes Vantage

AutoExec then closes the database

Hope that gives you a starting point.

Butch

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of golf_turn
Sent: Tuesday, May 06, 2008 11:10 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Run MRP Unattended

Does anyone run MRP unattended in 6.1 using something other than
Service Connect? We manually run it every evening and are seeking a
more economical alternative than Service Connect. Thanks.

Mike Dunn
Dubuque Stamping

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

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






[Non-text portions of this message have been removed]
We are on 6.1 and use GroundControl (keyboard macro software) which invokes
a Vantage session and runs the MRP process.
It's easy to build the script and it's worked very well for us for over 5
years over various Vantage versions.
If you need any help with scripting etc, please contact me offline.
Regards,
Richard

Richard Bailey
Dudley Industries
Mailto: rbailey@...
Tel: +44(0)1253 738311
Mob: +44(0)7836 550360
Fax: +44(0)870 7628173

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
golf_turn
Sent: 06 May 2008 19:10
To: vantage@yahoogroups.com
Subject: [Vantage] Run MRP Unattended


Does anyone run MRP unattended in 6.1 using something other than
Service Connect? We manually run it every evening and are seeking a
more economical alternative than Service Connect. Thanks.

Mike Dunn
Dubuque Stamping






[Non-text portions of this message have been removed]
Butch,
Thanks for the info. I can get to Vantage with the code you
supplied no problem. I have two questions. 1. When I attempt to run
the function from a macro I get the message "The expression you
entered has a function name that Microsoft Office Access can't find".
This is puzzling since everything is in the same database and I used
the build feature to find the function when I created the macro. Do
you have any idea what the problem might be? 2. Normally we specify a
path and filename for the MRP log. Is there a way to do this or is
the default no log? Thanks.

Mike Dunn
Dubuque Stamping


--- In vantage@yahoogroups.com, "Butch Menge" <bmenge@...> wrote:
>
> I use Microsoft Access and the sendkey function. Here is how it
works:
>
>
>
> Vantage
>
> Create a security group called MRP in Vantage
>
> Assign the MRP group using Menu Security to the minimal path to get
to
> the MRP option
>
> Create a user ID and assign it to the MRP security group
>
>
>
> Microsoft Access
>
> Create a new module and paste the following code:
>
> Public Function RunMRP()
>
>
>
> Dim RetVal
>
>
>
> RetVal = Shell("V:\mfgsys61\mfg.exe v:\Vantage.MFG",
vbNormalFocus)
>
>
>
> Wait 45
>
>
>
> AppActivate "System Login", False
>
>
>
> 'User ID
>
> SendKeys "mrp01", True
>
> SendKeys "{Tab}", True
>
>
>
> 'Password
>
> Wait 1
>
> SendKeys "mypassword", True
>
> SendKeys "{F2}", True
>
> Wait 2 'To display the program
>
>
>
> 'Select MRP option
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
>
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
>
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
>
>
> 'Launch MRP
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
>
>
> 'Do a Regen - need to wait about an hour
>
> SendKeys "{Right}", True
>
> SendKeys "{F2}", True
>
> Wait 3600
>
>
>
> 'Run complete so press Enter
>
> SendKeys "{Enter}", True
>
> Wait 1
>
>
>
> 'Close down the application
>
> SendKeys "%{F4}"
>
> Wait 0.5
>
> SendKeys "{Left}"
>
> Wait 0.5
>
> SendKeys "{Enter}"
>
>
>
> End Function
>
>
>
> Sub Wait(PauseTime)
>
>
>
> 'slows down the sendkeys because it is too fast for Vantage
>
>
>
> Dim Start
>
>
>
> Start = Timer ' Set start time.
>
>
>
> Do While Timer < Start + PauseTime
>
> DoEvents ' Yield to other processes.
>
> Loop
>
>
>
> End Sub
>
>
>
> Create a macro called AutoExec to start the process when the
database is
> launched:
>
> run the code (RunMRP)
>
> exit the application (shutdown Access)
>
>
>
> In Windows use the Task Scheduler to open the database at whatever
time
> you want MRP to be run
>
>
>
> In summary what happens:
>
> Windows Task Scheduler opens the Access database
>
> AutoExec runs the code RunMRP
>
> RunMRP launches Vantage and runs an MRP Regen
>
> An hour later RunMRP closes Vantage
>
> AutoExec then closes the database
>
>
>
> Hope that gives you a starting point.
>
> Butch
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of golf_turn
> Sent: Tuesday, May 06, 2008 11:10 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Run MRP Unattended
>
>
>
> Does anyone run MRP unattended in 6.1 using something other than
> Service Connect? We manually run it every evening and are seeking a
> more economical alternative than Service Connect. Thanks.
>
> Mike Dunn
> Dubuque Stamping
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
1. Check your function call in the Macro. I don't know how the
builder creates it but you need to have RunMrp () and not just RunMRP.
2. Should be able to do it. I would comment out the lines in the
script after the form is displayed so you can play around. Watch the
form to see where the focus is when the script stops. Insert tabs or
text as necessary until you get it working the way you want it.



Butch

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of golf_turn
Sent: Wednesday, May 07, 2008 12:55 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Run MRP Unattended




Butch,
Thanks for the info. I can get to Vantage with the code you
supplied no problem. I have two questions. 1. When I attempt to run
the function from a macro I get the message "The expression you
entered has a function name that Microsoft Office Access can't find".
This is puzzling since everything is in the same database and I used
the build feature to find the function when I created the macro. Do
you have any idea what the problem might be? 2. Normally we specify a
path and filename for the MRP log. Is there a way to do this or is
the default no log? Thanks.

Mike Dunn
Dubuque Stamping


--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Butch Menge" <bmenge@...> wrote:
>
> I use Microsoft Access and the sendkey function. Here is how it
works:
>
>
>
> Vantage
>
> Create a security group called MRP in Vantage
>
> Assign the MRP group using Menu Security to the minimal path to get
to
> the MRP option
>
> Create a user ID and assign it to the MRP security group
>
>
>
> Microsoft Access
>
> Create a new module and paste the following code:
>
> Public Function RunMRP()
>
>
>
> Dim RetVal
>
>
>
> RetVal = Shell("V:\mfgsys61\mfg.exe v:\Vantage.MFG",
vbNormalFocus)
>
>
>
> Wait 45
>
>
>
> AppActivate "System Login", False
>
>
>
> 'User ID
>
> SendKeys "mrp01", True
>
> SendKeys "{Tab}", True
>
>
>
> 'Password
>
> Wait 1
>
> SendKeys "mypassword", True
>
> SendKeys "{F2}", True
>
> Wait 2 'To display the program
>
>
>
> 'Select MRP option
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
>
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
>
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
>
>
> 'Launch MRP
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
>
>
> 'Do a Regen - need to wait about an hour
>
> SendKeys "{Right}", True
>
> SendKeys "{F2}", True
>
> Wait 3600
>
>
>
> 'Run complete so press Enter
>
> SendKeys "{Enter}", True
>
> Wait 1
>
>
>
> 'Close down the application
>
> SendKeys "%{F4}"
>
> Wait 0.5
>
> SendKeys "{Left}"
>
> Wait 0.5
>
> SendKeys "{Enter}"
>
>
>
> End Function
>
>
>
> Sub Wait(PauseTime)
>
>
>
> 'slows down the sendkeys because it is too fast for Vantage
>
>
>
> Dim Start
>
>
>
> Start = Timer ' Set start time.
>
>
>
> Do While Timer < Start + PauseTime
>
> DoEvents ' Yield to other processes.
>
> Loop
>
>
>
> End Sub
>
>
>
> Create a macro called AutoExec to start the process when the
database is
> launched:
>
> run the code (RunMRP)
>
> exit the application (shutdown Access)
>
>
>
> In Windows use the Task Scheduler to open the database at whatever
time
> you want MRP to be run
>
>
>
> In summary what happens:
>
> Windows Task Scheduler opens the Access database
>
> AutoExec runs the code RunMRP
>
> RunMRP launches Vantage and runs an MRP Regen
>
> An hour later RunMRP closes Vantage
>
> AutoExec then closes the database
>
>
>
> Hope that gives you a starting point.
>
> Butch
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of golf_turn
> Sent: Tuesday, May 06, 2008 11:10 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Run MRP Unattended
>
>
>
> Does anyone run MRP unattended in 6.1 using something other than
> Service Connect? We manually run it every evening and are seeking a
> more economical alternative than Service Connect. Thanks.
>
> Mike Dunn
> Dubuque Stamping
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
Ted,
Thanks for the tip. I have downloaded AutoIT and have perused the
online documentation but it is a bit overwhelming to me. Do you have
an example of how you used it to help me get started? Thanks.

Mike Dunn
Dubuque Stamping


--- In vantage@yahoogroups.com, "Ted Kitch" <tkitch@...> wrote:
>
> You can also do this with a freeware automation program called
AutoIT. It
> can be downloaded at www.autoitscript.com
<http://www.autoitscript.com/>
> and you won't have to deal with Access. It can be compiled,
scheduled and
> used in a variety of ways.
>
>
>
> HTH,
>
>
>
> Ted Kitch
>
> Information Technology Manager
>
> Astro Machine Corporation
>
> www.astromachine.com
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Butch Menge
> Sent: Tuesday, May 06, 2008 2:03 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Run MRP Unattended
>
>
>
> I use Microsoft Access and the sendkey function. Here is how it
works:
>
> Vantage
>
> Create a security group called MRP in Vantage
>
> Assign the MRP group using Menu Security to the minimal path to get
to
> the MRP option
>
> Create a user ID and assign it to the MRP security group
>
> Microsoft Access
>
> Create a new module and paste the following code:
>
> Public Function RunMRP()
>
> Dim RetVal
>
> RetVal = Shell("V:\mfgsys61\mfg.exe v:\Vantage.MFG", vbNormalFocus)
>
> Wait 45
>
> AppActivate "System Login", False
>
> 'User ID
>
> SendKeys "mrp01", True
>
> SendKeys "{Tab}", True
>
> 'Password
>
> Wait 1
>
> SendKeys "mypassword", True
>
> SendKeys "{F2}", True
>
> Wait 2 'To display the program
>
> 'Select MRP option
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> 'Launch MRP
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> 'Do a Regen - need to wait about an hour
>
> SendKeys "{Right}", True
>
> SendKeys "{F2}", True
>
> Wait 3600
>
> 'Run complete so press Enter
>
> SendKeys "{Enter}", True
>
> Wait 1
>
> 'Close down the application
>
> SendKeys "%{F4}"
>
> Wait 0.5
>
> SendKeys "{Left}"
>
> Wait 0.5
>
> SendKeys "{Enter}"
>
> End Function
>
> Sub Wait(PauseTime)
>
> 'slows down the sendkeys because it is too fast for Vantage
>
> Dim Start
>
> Start = Timer ' Set start time.
>
> Do While Timer < Start + PauseTime
>
> DoEvents ' Yield to other processes.
>
> Loop
>
> End Sub
>
> Create a macro called AutoExec to start the process when the
database is
> launched:
>
> run the code (RunMRP)
>
> exit the application (shutdown Access)
>
> In Windows use the Task Scheduler to open the database at whatever
time
> you want MRP to be run
>
> In summary what happens:
>
> Windows Task Scheduler opens the Access database
>
> AutoExec runs the code RunMRP
>
> RunMRP launches Vantage and runs an MRP Regen
>
> An hour later RunMRP closes Vantage
>
> AutoExec then closes the database
>
> Hope that gives you a starting point.
>
> Butch
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> Of golf_turn
> Sent: Tuesday, May 06, 2008 11:10 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Run MRP Unattended
>
> Does anyone run MRP unattended in 6.1 using something other than
> Service Connect? We manually run it every evening and are seeking a
> more economical alternative than Service Connect. Thanks.
>
> Mike Dunn
> Dubuque Stamping
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
This deviates a bit from the original post. In 8.x, MRP can be automated using the task scheduler. We ultimately plan on running it nightly (it takes about 45 - 60 mins at the moment). Has anyone run into issues with running MRP scheduler with the task scheduler in vantage?

Thanks,
Kunal



----- Original Message ----
From: golf_turn <mjd@...>
To: vantage@yahoogroups.com
Sent: Tuesday, May 13, 2008 12:14:00 PM
Subject: [Vantage] Re: Run MRP Unattended



Ted,
Thanks for the tip. I have downloaded AutoIT and have perused the
online documentation but it is a bit overwhelming to me. Do you have
an example of how you used it to help me get started? Thanks.

Mike Dunn
Dubuque Stamping

--- In vantage@yahoogroups .com, "Ted Kitch" <tkitch@...> wrote:
>
> You can also do this with a freeware automation program called
AutoIT. It
> can be downloaded at www.autoitscript. com
<http://www.autoitsc ript.com/>
> and you won't have to deal with Access. It can be compiled,
scheduled and
> used in a variety of ways.
>
>
>
> HTH,
>
>
>
> Ted Kitch
>
> Information Technology Manager
>
> Astro Machine Corporation
>
> www.astromachine. com
>
>
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf Of
> Butch Menge
> Sent: Tuesday, May 06, 2008 2:03 PM
> To: vantage@yahoogroups .com
> Subject: RE: [Vantage] Run MRP Unattended
>
>
>
> I use Microsoft Access and the sendkey function. Here is how it
works:
>
> Vantage
>
> Create a security group called MRP in Vantage
>
> Assign the MRP group using Menu Security to the minimal path to get
to
> the MRP option
>
> Create a user ID and assign it to the MRP security group
>
> Microsoft Access
>
> Create a new module and paste the following code:
>
> Public Function RunMRP()
>
> Dim RetVal
>
> RetVal = Shell("V:\mfgsys61\ mfg.exe v:\Vantage.MFG" , vbNormalFocus)
>
> Wait 45
>
> AppActivate "System Login", False
>
> 'User ID
>
> SendKeys "mrp01", True
>
> SendKeys "{Tab}", True
>
> 'Password
>
> Wait 1
>
> SendKeys "mypassword" , True
>
> SendKeys "{F2}", True
>
> Wait 2 'To display the program
>
> 'Select MRP option
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> 'Launch MRP
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> 'Do a Regen - need to wait about an hour
>
> SendKeys "{Right}", True
>
> SendKeys "{F2}", True
>
> Wait 3600
>
> 'Run complete so press Enter
>
> SendKeys "{Enter}", True
>
> Wait 1
>
> 'Close down the application
>
> SendKeys "%{F4}"
>
> Wait 0.5
>
> SendKeys "{Left}"
>
> Wait 0.5
>
> SendKeys "{Enter}"
>
> End Function
>
> Sub Wait(PauseTime)
>
> 'slows down the sendkeys because it is too fast for Vantage
>
> Dim Start
>
> Start = Timer ' Set start time.
>
> Do While Timer < Start + PauseTime
>
> DoEvents ' Yield to other processes.
>
> Loop
>
> End Sub
>
> Create a macro called AutoExec to start the process when the
database is
> launched:
>
> run the code (RunMRP)
>
> exit the application (shutdown Access)
>
> In Windows use the Task Scheduler to open the database at whatever
time
> you want MRP to be run
>
> In summary what happens:
>
> Windows Task Scheduler opens the Access database
>
> AutoExec runs the code RunMRP
>
> RunMRP launches Vantage and runs an MRP Regen
>
> An hour later RunMRP closes Vantage
>
> AutoExec then closes the database
>
> Hope that gives you a starting point.
>
> Butch
>
> ____________ _________ _________ __
>
> From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> [mailto:vantage@yahoogroups .com <mailto:vantage%
40yahoogroups. com> ] On
> Behalf
> Of golf_turn
> Sent: Tuesday, May 06, 2008 11:10 AM
> To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> Subject: [Vantage] Run MRP Unattended
>
> Does anyone run MRP unattended in 6.1 using something other than
> Service Connect? We manually run it every evening and are seeking a
> more economical alternative than Service Connect. Thanks.
>
> Mike Dunn
> Dubuque Stamping
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
Start with the Notepad example application that launches notepad and then
types some text into it. This will give you an idea as to what AutoIT wants
you to do. After Vantage is opened then you can use mouse clicks or the
send command (lookup Send Key List in the help file and it will tell you
everything you want to know). The main thing with automating Vantage is
using the sleep() command in AutoIT after each entry. This gives Vantage
time to respond and will ensure that your application would work. The other
is that if you use a mouse and automate the clicks then you need to pay
attention to the resolution of the computer that you are programming on.



Make sure that you also download the Scite editor. It is nice to use with
AutoIT.



You will also need to make sure that you run the script that you create with
permissions to connect to the network. AutoIT by default runs under the
system account and this does not allow access to the network.



Below is a sample script to launch Vantage and open up the top item on the
Favorites tool bar. I'm still on 6.1, but it should give you the idea. You
will need to modify this for your environment.



<Begin Code>

Opt("MouseCoordMode", 0) ;Makes mouse clicks relative to the 0,0 of the
active window



Run("Y:\mfgsys\vantage.exe Vantage.MFG", "", @SW_MAXIMIZE) ;Launches Vantage



WinWaitActive("System Login") ;Waits for the system login screen to come up

Send("manager") ;Types in the username

Sleep(5) ;Waits 5 milliseconds

Send("{ENTER}") ;Sends the Enter key

Sleep(10) ;Waits for 10 milliseconds

Send("manager") ;Types in the password

Sleep(5) ;Waits for 5 milliseconds

Send("{ENTER}") ;Sends the Enter key



WinWaitActive("Vantage") ;Waits for the main Vantage window to open

MouseClick("left", 146, 93) ;Does a left mouse click at the x,y coordinates
for the first icon



</End Code>



Hope this helps,



Ted Kitch

Information Technology Manager

Astro Machine Corporation

www.astromachine.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
golf_turn
Sent: Tuesday, May 13, 2008 12:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Run MRP Unattended




Ted,
Thanks for the tip. I have downloaded AutoIT and have perused the
online documentation but it is a bit overwhelming to me. Do you have
an example of how you used it to help me get started? Thanks.

Mike Dunn
Dubuque Stamping

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Ted
Kitch" <tkitch@...> wrote:
>
> You can also do this with a freeware automation program called
AutoIT. It
> can be downloaded at www.autoitscript.com
<http://www.autoitscript.com/>
> and you won't have to deal with Access. It can be compiled,
scheduled and
> used in a variety of ways.
>
>
>
> HTH,
>
>
>
> Ted Kitch
>
> Information Technology Manager
>
> Astro Machine Corporation
>
> www.astromachine.com
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> Butch Menge
> Sent: Tuesday, May 06, 2008 2:03 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Run MRP Unattended
>
>
>
> I use Microsoft Access and the sendkey function. Here is how it
works:
>
> Vantage
>
> Create a security group called MRP in Vantage
>
> Assign the MRP group using Menu Security to the minimal path to get
to
> the MRP option
>
> Create a user ID and assign it to the MRP security group
>
> Microsoft Access
>
> Create a new module and paste the following code:
>
> Public Function RunMRP()
>
> Dim RetVal
>
> RetVal = Shell("V:\mfgsys61\mfg.exe v:\Vantage.MFG", vbNormalFocus)
>
> Wait 45
>
> AppActivate "System Login", False
>
> 'User ID
>
> SendKeys "mrp01", True
>
> SendKeys "{Tab}", True
>
> 'Password
>
> Wait 1
>
> SendKeys "mypassword", True
>
> SendKeys "{F2}", True
>
> Wait 2 'To display the program
>
> 'Select MRP option
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> 'Launch MRP
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> 'Do a Regen - need to wait about an hour
>
> SendKeys "{Right}", True
>
> SendKeys "{F2}", True
>
> Wait 3600
>
> 'Run complete so press Enter
>
> SendKeys "{Enter}", True
>
> Wait 1
>
> 'Close down the application
>
> SendKeys "%{F4}"
>
> Wait 0.5
>
> SendKeys "{Left}"
>
> Wait 0.5
>
> SendKeys "{Enter}"
>
> End Function
>
> Sub Wait(PauseTime)
>
> 'slows down the sendkeys because it is too fast for Vantage
>
> Dim Start
>
> Start = Timer ' Set start time.
>
> Do While Timer < Start + PauseTime
>
> DoEvents ' Yield to other processes.
>
> Loop
>
> End Sub
>
> Create a macro called AutoExec to start the process when the
database is
> launched:
>
> run the code (RunMRP)
>
> exit the application (shutdown Access)
>
> In Windows use the Task Scheduler to open the database at whatever
time
> you want MRP to be run
>
> In summary what happens:
>
> Windows Task Scheduler opens the Access database
>
> AutoExec runs the code RunMRP
>
> RunMRP launches Vantage and runs an MRP Regen
>
> An hour later RunMRP closes Vantage
>
> AutoExec then closes the database
>
> Hope that gives you a starting point.
>
> Butch
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> Of golf_turn
> Sent: Tuesday, May 06, 2008 11:10 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Run MRP Unattended
>
> Does anyone run MRP unattended in 6.1 using something other than
> Service Connect? We manually run it every evening and are seeking a
> more economical alternative than Service Connect. Thanks.
>
> Mike Dunn
> Dubuque Stamping
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
I have been scheduling it with 8.x since January 2007 without any
issues.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kunal Ganguly
Sent: Tuesday, May 13, 2008 12:40 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Run MRP Unattended



This deviates a bit from the original post. In 8.x, MRP can be automated
using the task scheduler. We ultimately plan on running it nightly (it
takes about 45 - 60 mins at the moment). Has anyone run into issues with
running MRP scheduler with the task scheduler in vantage?

Thanks,
Kunal

----- Original Message ----
From: golf_turn <mjd@... <mailto:mjd%40dbqstamp.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tuesday, May 13, 2008 12:14:00 PM
Subject: [Vantage] Re: Run MRP Unattended

Ted,
Thanks for the tip. I have downloaded AutoIT and have perused the
online documentation but it is a bit overwhelming to me. Do you have
an example of how you used it to help me get started? Thanks.

Mike Dunn
Dubuque Stamping

--- In vantage@yahoogroups .com, "Ted Kitch" <tkitch@...> wrote:
>
> You can also do this with a freeware automation program called
AutoIT. It
> can be downloaded at www.autoitscript. com
<http://www.autoitsc ript.com/>
> and you won't have to deal with Access. It can be compiled,
scheduled and
> used in a variety of ways.
>
>
>
> HTH,
>
>
>
> Ted Kitch
>
> Information Technology Manager
>
> Astro Machine Corporation
>
> www.astromachine. com
>
>
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf Of
> Butch Menge
> Sent: Tuesday, May 06, 2008 2:03 PM
> To: vantage@yahoogroups .com
> Subject: RE: [Vantage] Run MRP Unattended
>
>
>
> I use Microsoft Access and the sendkey function. Here is how it
works:
>
> Vantage
>
> Create a security group called MRP in Vantage
>
> Assign the MRP group using Menu Security to the minimal path to get
to
> the MRP option
>
> Create a user ID and assign it to the MRP security group
>
> Microsoft Access
>
> Create a new module and paste the following code:
>
> Public Function RunMRP()
>
> Dim RetVal
>
> RetVal = Shell("V:\mfgsys61\ mfg.exe v:\Vantage.MFG" , vbNormalFocus)
>
> Wait 45
>
> AppActivate "System Login", False
>
> 'User ID
>
> SendKeys "mrp01", True
>
> SendKeys "{Tab}", True
>
> 'Password
>
> Wait 1
>
> SendKeys "mypassword" , True
>
> SendKeys "{F2}", True
>
> Wait 2 'To display the program
>
> 'Select MRP option
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> 'Launch MRP
>
> SendKeys "{Down}", True
>
> SendKeys "{Enter}", True
>
> Wait 0.5
>
> 'Do a Regen - need to wait about an hour
>
> SendKeys "{Right}", True
>
> SendKeys "{F2}", True
>
> Wait 3600
>
> 'Run complete so press Enter
>
> SendKeys "{Enter}", True
>
> Wait 1
>
> 'Close down the application
>
> SendKeys "%{F4}"
>
> Wait 0.5
>
> SendKeys "{Left}"
>
> Wait 0.5
>
> SendKeys "{Enter}"
>
> End Function
>
> Sub Wait(PauseTime)
>
> 'slows down the sendkeys because it is too fast for Vantage
>
> Dim Start
>
> Start = Timer ' Set start time.
>
> Do While Timer < Start + PauseTime
>
> DoEvents ' Yield to other processes.
>
> Loop
>
> End Sub
>
> Create a macro called AutoExec to start the process when the
database is
> launched:
>
> run the code (RunMRP)
>
> exit the application (shutdown Access)
>
> In Windows use the Task Scheduler to open the database at whatever
time
> you want MRP to be run
>
> In summary what happens:
>
> Windows Task Scheduler opens the Access database
>
> AutoExec runs the code RunMRP
>
> RunMRP launches Vantage and runs an MRP Regen
>
> An hour later RunMRP closes Vantage
>
> AutoExec then closes the database
>
> Hope that gives you a starting point.
>
> Butch
>
> ____________ _________ _________ __
>
> From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> [mailto:vantage@yahoogroups .com <mailto:vantage%
40yahoogroups. com> ] On
> Behalf
> Of golf_turn
> Sent: Tuesday, May 06, 2008 11:10 AM
> To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> Subject: [Vantage] Run MRP Unattended
>
> Does anyone run MRP unattended in 6.1 using something other than
> Service Connect? We manually run it every evening and are seeking a
> more economical alternative than Service Connect. Thanks.
>
> Mike Dunn
> Dubuque Stamping
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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



Charles Carden
Manager, MIS
Manitex, Inc.
Phone: 512-942-3086
Fax: 512-942-3089


DISCLAIMER:
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.



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