Engineering workbench

Yahoo Archive
1
I agree with Kerry,
I have also used a screen macro - free online - forgot the name.

I also created a quick query that used a BAQ to pull in the parts that
needed to be worked on.
That way, when I was done updating, the query would not bring back any
results. (It also let me know where I was at in fixing things)

Bruce Larson
www.ERPgeek.com
bruce@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Kerry_Muntz
Sent: Wednesday, May 20, 2009 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Engineering workbench

Just read some of the "Update Vantage Using AuotIT" thread. I agree about
limiting the high speed playback. Due to the nature of the V8 GUI, we have
had to change our thinking, and speed is no longer the main issue for us.
When the occassion arises, we now run the macros at either human, or 'very
fast human' speed. Speed isn't really the issue, as the macros can run all
night (if they are well written), and don't complain about the overtime. Or
we can easily set up a second terminal, so a human isn't wasted 'waiting'
for the macros to run. The irony is that our support company used to
actually encourage us to use the recorders over other mass-change methods
when we were using 6, as they mimicked human interface. Now they deny all
knowledge of ever encouraging our use of them, and say we need to run them
at sub human speed. Macros are great for consistent results, rigid
disciplines, and don't suffer RSI or boredom and fatigue.



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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
2
V8.03.407C

We have not been using the Engineering workbench as designed, and as a result, we have over 6,000 parts checked out to a Group called 'Engineering'. This causes the Engineering workbench to hang for several minutes whenever we open this group. We didn't notice the problem until V8 because the V6 list doesn't display all parts checked out to the group.

We have lot's of clean up to do, but I wanted to make sure we get this right before we go forward.

What we have been doing that appears to cause the problem is we create new parts as we quote them, add a Rev NR (for new release)and a Rev 1 and check them out to group Engineering. If the part isn't booked, it just stays there, hence the long list of checked out parts. Also, if we book it, we bump up to Rev 1 and this one is checked in and approved, but the Rev NR stays checked out.

I thought we could just undo check out to get rid of this long list, but that loses the rev and its methods. We don't want that. It appears that we have to approve and check in the rev, then unapprove it in Part Maintenance.

Am I right here?

thanks in advance,

Randy Weber
3
Here is a fast way, if you want...when you open your group, go to
group....check in all, then approve all...then it gets out ALL of the
parts in the group fast....then you have your long tedious method of
cleaning up in part maintenance.



M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Randy
Sent: Tuesday, May 19, 2009 3:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Engineering workbench





V8.03.407C

We have not been using the Engineering workbench as designed, and as a
result, we have over 6,000 parts checked out to a Group called
'Engineering'. This causes the Engineering workbench to hang for several
minutes whenever we open this group. We didn't notice the problem until
V8 because the V6 list doesn't display all parts checked out to the
group.

We have lot's of clean up to do, but I wanted to make sure we get this
right before we go forward.

What we have been doing that appears to cause the problem is we create
new parts as we quote them, add a Rev NR (for new release)and a Rev 1
and check them out to group Engineering. If the part isn't booked, it
just stays there, hence the long list of checked out parts. Also, if we
book it, we bump up to Rev 1 and this one is checked in and approved,
but the Rev NR stays checked out.

I thought we could just undo check out to get rid of this long list, but
that loses the rev and its methods. We don't want that. It appears that
we have to approve and check in the rev, then unapprove it in Part
Maintenance.

Am I right here?

thanks in advance,

Randy Weber






[Non-text portions of this message have been removed]
4
Thanks - but most of them should not be approved. It's just that they
should not be checked out either. Thanks though.



Randy Weber



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Tuesday, May 19, 2009 3:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Engineering workbench








Here is a fast way, if you want...when you open your group, go to
group....check in all, then approve all...then it gets out ALL of the
parts in the group fast....then you have your long tedious method of
cleaning up in part maintenance.



M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Randy
Sent: Tuesday, May 19, 2009 3:21 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Engineering workbench

V8.03.407C

We have not been using the Engineering workbench as designed, and as a
result, we have over 6,000 parts checked out to a Group called
'Engineering'. This causes the Engineering workbench to hang for several
minutes whenever we open this group. We didn't notice the problem until
V8 because the V6 list doesn't display all parts checked out to the
group.

We have lot's of clean up to do, but I wanted to make sure we get this
right before we go forward.

What we have been doing that appears to cause the problem is we create
new parts as we quote them, add a Rev NR (for new release)and a Rev 1
and check them out to group Engineering. If the part isn't booked, it
just stays there, hence the long list of checked out parts. Also, if we
book it, we bump up to Rev 1 and this one is checked in and approved,
but the Rev NR stays checked out.

I thought we could just undo check out to get rid of this long list, but
that loses the rev and its methods. We don't want that. It appears that
we have to approve and check in the rev, then unapprove it in Part
Maintenance.

Am I right here?

thanks in advance,

Randy Weber

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





[Non-text portions of this message have been removed]
5
Wow, 6000 of them... Yes you are right about the pitfall of unchecking out. I agree about checking in and approving all en mass, and then unapproving in Part Maintenance.

I use a tool "Mouse and Key Recorder" to do big missions like this. I have a macro written for such a task, with some tweaking for your environment. You'd need to download the software, and I could email you my macro, a customization and give a little guidance. The trial software version might do the business for you, kratronic.com

You can email me if you choose this route. There are other packages that do similar functions.

Otherwise you could build some business rules around how you treat parts with NR revisions. Also, if the dates of the NR revs are older, then the newer revs will be used instead (except for when they are not approved - which is unpleasant, including for recosting).



--- In vantage@yahoogroups.com, "Randy Weber" <rweber@...> wrote:
>
> Thanks - but most of them should not be approved. It's just that they
> should not be checked out either. Thanks though.
>
>
>
> Randy Weber
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Manasa Reddy
> Sent: Tuesday, May 19, 2009 3:26 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Engineering workbench
>
>
>
>
>
>
>
>
> Here is a fast way, if you want...when you open your group, go to
> group....check in all, then approve all...then it gets out ALL of the
> parts in the group fast....then you have your long tedious method of
> cleaning up in part maintenance.
>
>
>
> M. Manasa Reddy
> manasa@... <mailto:manasa%40weldcoa.com>
> P: 630-806-2000
> F: 630-806-2001
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Randy
> Sent: Tuesday, May 19, 2009 3:21 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Engineering workbench
>
> V8.03.407C
>
> We have not been using the Engineering workbench as designed, and as a
> result, we have over 6,000 parts checked out to a Group called
> 'Engineering'. This causes the Engineering workbench to hang for several
> minutes whenever we open this group. We didn't notice the problem until
> V8 because the V6 list doesn't display all parts checked out to the
> group.
>
> We have lot's of clean up to do, but I wanted to make sure we get this
> right before we go forward.
>
> What we have been doing that appears to cause the problem is we create
> new parts as we quote them, add a Rev NR (for new release)and a Rev 1
> and check them out to group Engineering. If the part isn't booked, it
> just stays there, hence the long list of checked out parts. Also, if we
> book it, we bump up to Rev 1 and this one is checked in and approved,
> but the Rev NR stays checked out.
>
> I thought we could just undo check out to get rid of this long list, but
> that loses the rev and its methods. We don't want that. It appears that
> we have to approve and check in the rev, then unapprove it in Part
> Maintenance.
>
> Am I right here?
>
> thanks in advance,
>
> Randy Weber
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
Why don't you check out all/approve all & then use part entry to unapprove all the part rev's you don't want used?

Vantage (Engineering apps) will come to a crawl with so many parts in an open EC group. It noticably slows at 50 parts checked in (let alone 6000!)

Rob




________________________________
From: Randy <rweber@...>
To: vantage@yahoogroups.com
Sent: Tuesday, May 19, 2009 4:21:11 PM
Subject: [Vantage] Engineering workbench





V8.03.407C

We have not been using the Engineering workbench as designed, and as a result, we have over 6,000 parts checked out to a Group called 'Engineering' . This causes the Engineering workbench to hang for several minutes whenever we open this group. We didn't notice the problem until V8 because the V6 list doesn't display all parts checked out to the group.

We have lot's of clean up to do, but I wanted to make sure we get this right before we go forward.

What we have been doing that appears to cause the problem is we create new parts as we quote them, add a Rev NR (for new release)and a Rev 1 and check them out to group Engineering. If the part isn't booked, it just stays there, hence the long list of checked out parts. Also, if we book it, we bump up to Rev 1 and this one is checked in and approved, but the Rev NR stays checked out.

I thought we could just undo check out to get rid of this long list, but that loses the rev and its methods. We don't want that. It appears that we have to approve and check in the rev, then unapprove it in Part Maintenance.

Am I right here?

thanks in advance,

Randy Weber







[Non-text portions of this message have been removed]
7
Not sure I understand why you feel they have to stay checked out. If parts are marked as Use Rev control in Part Entry, simply unapproving these rev's (after mass check in/approval & manual unapproval of appropriate parts out of the 6000) will prevent use.

No benefit to keeping them in limbo in EC group in v8.

Manessa is doing exactly what I would do (and have done during 1st week of being live when all the data import errors must be resolved quickly).

The EC group isn't intended to hold massive qty's of quote parts... If you want to do that, create quotes (to whatever level of part method detail you desire).

Rob




________________________________
From: Manasa Reddy <manasa@...>
To: vantage@yahoogroups.com
Sent: Tuesday, May 19, 2009 4:25:39 PM
Subject: RE: [Vantage] Engineering workbench





Here is a fast way, if you want...when you open your group, go to
group....check in all, then approve all...then it gets out ALL of the
parts in the group fast....then you have your long tedious method of
cleaning up in part maintenance.



M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001


____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Randy
Sent: Tuesday, May 19, 2009 3:21 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Engineering workbench

V8.03.407C

We have not been using the Engineering workbench as designed, and as a
result, we have over 6,000 parts checked out to a Group called
'Engineering' . This causes the Engineering workbench to hang for several
minutes whenever we open this group. We didn't notice the problem until
V8 because the V6 list doesn't display all parts checked out to the
group.

We have lot's of clean up to do, but I wanted to make sure we get this
right before we go forward.

What we have been doing that appears to cause the problem is we create
new parts as we quote them, add a Rev NR (for new release)and a Rev 1
and check them out to group Engineering. If the part isn't booked, it
just stays there, hence the long list of checked out parts. Also, if we
book it, we bump up to Rev 1 and this one is checked in and approved,
but the Rev NR stays checked out.

I thought we could just undo check out to get rid of this long list, but
that loses the rev and its methods. We don't want that. It appears that
we have to approve and check in the rev, then unapprove it in Part
Maintenance.

Am I right here?

thanks in advance,

Randy Weber

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







[Non-text portions of this message have been removed]
8
Keyboard/mouse script recorders can definitely help on large data entry chores like this. I use AutoHotKey (free) but there are many others.

Rob




________________________________
From: Robert Brown <robertb_versa@...>
To: vantage@yahoogroups.com
Sent: Tuesday, May 19, 2009 5:19:17 PM
Subject: Re: [Vantage] Engineering workbench





Not sure I understand why you feel they have to stay checked out. If parts are marked as Use Rev control in Part Entry, simply unapproving these rev's (after mass check in/approval & manual unapproval of appropriate parts out of the 6000) will prevent use.

No benefit to keeping them in limbo in EC group in v8.

Manessa is doing exactly what I would do (and have done during 1st week of being live when all the data import errors must be resolved quickly).

The EC group isn't intended to hold massive qty's of quote parts... If you want to do that, create quotes (to whatever level of part method detail you desire).

Rob

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com>
To: vantage@yahoogroups .com
Sent: Tuesday, May 19, 2009 4:25:39 PM
Subject: RE: [Vantage] Engineering workbench

Here is a fast way, if you want...when you open your group, go to
group....check in all, then approve all...then it gets out ALL of the
parts in the group fast....then you have your long tedious method of
cleaning up in part maintenance.

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Randy
Sent: Tuesday, May 19, 2009 3:21 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Engineering workbench

V8.03.407C

We have not been using the Engineering workbench as designed, and as a
result, we have over 6,000 parts checked out to a Group called
'Engineering' . This causes the Engineering workbench to hang for several
minutes whenever we open this group. We didn't notice the problem until
V8 because the V6 list doesn't display all parts checked out to the
group.

We have lot's of clean up to do, but I wanted to make sure we get this
right before we go forward.

What we have been doing that appears to cause the problem is we create
new parts as we quote them, add a Rev NR (for new release)and a Rev 1
and check them out to group Engineering. If the part isn't booked, it
just stays there, hence the long list of checked out parts. Also, if we
book it, we bump up to Rev 1 and this one is checked in and approved,
but the Rev NR stays checked out.

I thought we could just undo check out to get rid of this long list, but
that loses the rev and its methods. We don't want that. It appears that
we have to approve and check in the rev, then unapprove it in Part
Maintenance.

Am I right here?

thanks in advance,

Randy Weber

[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]
9
Thank you all for good info. We had no particular reason for leaving
them there in the EC - it's stuff from way back when apparently we
weren't properly trained. We happen to quote lots of stuff that never
gets built. I guess nobody noticed it until we got to V8.



The key recorders will be a big help. When we started with V6, I was
able to get a lot done using Visual Basic SendKeys method from an MS
Access database. It seems I tried this in V8 and ran into stumbling
blocks - can't recall exactly. If anybody has used Visual Basic for
Applications SendKeys method successfully for massive updates, I'd like
to hear from you.



Randy Weber





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Tuesday, May 19, 2009 4:27 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Engineering workbench








Keyboard/mouse script recorders can definitely help on large data entry
chores like this. I use AutoHotKey (free) but there are many others.

Rob

________________________________
From: Robert Brown <robertb_versa@...
<mailto:robertb_versa%40yahoo.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tuesday, May 19, 2009 5:19:17 PM
Subject: Re: [Vantage] Engineering workbench

Not sure I understand why you feel they have to stay checked out. If
parts are marked as Use Rev control in Part Entry, simply unapproving
these rev's (after mass check in/approval & manual unapproval of
appropriate parts out of the 6000) will prevent use.

No benefit to keeping them in limbo in EC group in v8.

Manessa is doing exactly what I would do (and have done during 1st week
of being live when all the data import errors must be resolved quickly).

The EC group isn't intended to hold massive qty's of quote parts... If
you want to do that, create quotes (to whatever level of part method
detail you desire).

Rob

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com>
To: vantage@yahoogroups .com
Sent: Tuesday, May 19, 2009 4:25:39 PM
Subject: RE: [Vantage] Engineering workbench

Here is a fast way, if you want...when you open your group, go to
group....check in all, then approve all...then it gets out ALL of the
parts in the group fast....then you have your long tedious method of
cleaning up in part maintenance.

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Randy
Sent: Tuesday, May 19, 2009 3:21 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Engineering workbench

V8.03.407C

We have not been using the Engineering workbench as designed, and as a
result, we have over 6,000 parts checked out to a Group called
'Engineering' . This causes the Engineering workbench to hang for
several
minutes whenever we open this group. We didn't notice the problem until
V8 because the V6 list doesn't display all parts checked out to the
group.

We have lot's of clean up to do, but I wanted to make sure we get this
right before we go forward.

What we have been doing that appears to cause the problem is we create
new parts as we quote them, add a Rev NR (for new release)and a Rev 1
and check them out to group Engineering. If the part isn't booked, it
just stays there, hence the long list of checked out parts. Also, if we
book it, we bump up to Rev 1 and this one is checked in and approved,
but the Rev NR stays checked out.

I thought we could just undo check out to get rid of this long list, but
that loses the rev and its methods. We don't want that. It appears that
we have to approve and check in the rev, then unapprove it in Part
Maintenance.

Am I right here?

thanks in advance,

Randy Weber

[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]





[Non-text portions of this message have been removed]
10
Have you considered deleting all of these part records (once you approve them to get them out of the EW)? If I understand correctly, they will remain in the quote module where they belong until you get an order. Everything you do to develop the methods, etc. should be done only in the quote module, not the engineering workbench, until the part is actually ordered. Do you really want 6,000 (and counting) part numbers in your part master that you wil probably never use?

Even if you want to (or have to) keep these 6,000 in the part master for some reason I'd recommend that in the future you never create a part in the part master that has not been ordered.

Greg

----- Original Message -----
From: Randy Weber
To: vantage@yahoogroups.com
Sent: Wednesday, May 20, 2009 8:40 AM
Subject: RE: [Vantage] Engineering workbench





Thank you all for good info. We had no particular reason for leaving
them there in the EC - it's stuff from way back when apparently we
weren't properly trained. We happen to quote lots of stuff that never
gets built. I guess nobody noticed it until we got to V8.

The key recorders will be a big help. When we started with V6, I was
able to get a lot done using Visual Basic SendKeys method from an MS
Access database. It seems I tried this in V8 and ran into stumbling
blocks - can't recall exactly. If anybody has used Visual Basic for
Applications SendKeys method successfully for massive updates, I'd like
to hear from you.

Randy Weber

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Tuesday, May 19, 2009 4:27 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Engineering workbench

Keyboard/mouse script recorders can definitely help on large data entry
chores like this. I use AutoHotKey (free) but there are many others.

Rob

________________________________
From: Robert Brown <robertb_versa@...
<mailto:robertb_versa%40yahoo.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tuesday, May 19, 2009 5:19:17 PM
Subject: Re: [Vantage] Engineering workbench

Not sure I understand why you feel they have to stay checked out. If
parts are marked as Use Rev control in Part Entry, simply unapproving
these rev's (after mass check in/approval & manual unapproval of
appropriate parts out of the 6000) will prevent use.

No benefit to keeping them in limbo in EC group in v8.

Manessa is doing exactly what I would do (and have done during 1st week
of being live when all the data import errors must be resolved quickly).

The EC group isn't intended to hold massive qty's of quote parts... If
you want to do that, create quotes (to whatever level of part method
detail you desire).

Rob

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com>
To: vantage@yahoogroups .com
Sent: Tuesday, May 19, 2009 4:25:39 PM
Subject: RE: [Vantage] Engineering workbench

Here is a fast way, if you want...when you open your group, go to
group....check in all, then approve all...then it gets out ALL of the
parts in the group fast....then you have your long tedious method of
cleaning up in part maintenance.

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Randy
Sent: Tuesday, May 19, 2009 3:21 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Engineering workbench

V8.03.407C

We have not been using the Engineering workbench as designed, and as a
result, we have over 6,000 parts checked out to a Group called
'Engineering' . This causes the Engineering workbench to hang for
several
minutes whenever we open this group. We didn't notice the problem until
V8 because the V6 list doesn't display all parts checked out to the
group.

We have lot's of clean up to do, but I wanted to make sure we get this
right before we go forward.

What we have been doing that appears to cause the problem is we create
new parts as we quote them, add a Rev NR (for new release)and a Rev 1
and check them out to group Engineering. If the part isn't booked, it
just stays there, hence the long list of checked out parts. Also, if we
book it, we bump up to Rev 1 and this one is checked in and approved,
but the Rev NR stays checked out.

I thought we could just undo check out to get rid of this long list, but
that loses the rev and its methods. We don't want that. It appears that
we have to approve and check in the rev, then unapprove it in Part
Maintenance.

Am I right here?

thanks in advance,

Randy Weber

[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]

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





[Non-text portions of this message have been removed]
11
SendKeys fails occasionally for the same reason other script recorder apps do: Vantage apps and controls do a very poor job of notifying the O/S when they are and are not active (so you keystrokes are sent to an app or specific input control that are not ready to accept them).

Disappointing as Infragistics is a good company (supplying GUI controls for many software companies). I suspect it is the way Epcior modified/enhanced them that is the problem.

Rob




________________________________
From: Randy Weber <rweber@...>
To: vantage@yahoogroups.com
Sent: Wednesday, May 20, 2009 9:40:33 AM
Subject: RE: [Vantage] Engineering workbench





Thank you all for good info. We had no particular reason for leaving
them there in the EC - it's stuff from way back when apparently we
weren't properly trained. We happen to quote lots of stuff that never
gets built. I guess nobody noticed it until we got to V8.

The key recorders will be a big help. When we started with V6, I was
able to get a lot done using Visual Basic SendKeys method from an MS
Access database. It seems I tried this in V8 and ran into stumbling
blocks - can't recall exactly. If anybody has used Visual Basic for
Applications SendKeys method successfully for massive updates, I'd like
to hear from you.

Randy Weber

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Robert Brown
Sent: Tuesday, May 19, 2009 4:27 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Engineering workbench

Keyboard/mouse script recorders can definitely help on large data entry
chores like this. I use AutoHotKey (free) but there are many others.

Rob

____________ _________ _________ __
From: Robert Brown <robertb_versa@ yahoo.com
<mailto:robertb_ versa%40yahoo. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Tuesday, May 19, 2009 5:19:17 PM
Subject: Re: [Vantage] Engineering workbench

Not sure I understand why you feel they have to stay checked out. If
parts are marked as Use Rev control in Part Entry, simply unapproving
these rev's (after mass check in/approval & manual unapproval of
appropriate parts out of the 6000) will prevent use.

No benefit to keeping them in limbo in EC group in v8.

Manessa is doing exactly what I would do (and have done during 1st week
of being live when all the data import errors must be resolved quickly).

The EC group isn't intended to hold massive qty's of quote parts... If
you want to do that, create quotes (to whatever level of part method
detail you desire).

Rob

____________ _________ _________ __
From: Manasa Reddy <manasa@weldcoa. com>
To: vantage@yahoogroups .com
Sent: Tuesday, May 19, 2009 4:25:39 PM
Subject: RE: [Vantage] Engineering workbench

Here is a fast way, if you want...when you open your group, go to
group....check in all, then approve all...then it gets out ALL of the
parts in the group fast....then you have your long tedious method of
cleaning up in part maintenance.

M. Manasa Reddy
manasa@weldcoa. com
P: 630-806-2000
F: 630-806-2001

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Randy
Sent: Tuesday, May 19, 2009 3:21 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Engineering workbench

V8.03.407C

We have not been using the Engineering workbench as designed, and as a
result, we have over 6,000 parts checked out to a Group called
'Engineering' . This causes the Engineering workbench to hang for
several
minutes whenever we open this group. We didn't notice the problem until
V8 because the V6 list doesn't display all parts checked out to the
group.

We have lot's of clean up to do, but I wanted to make sure we get this
right before we go forward.

What we have been doing that appears to cause the problem is we create
new parts as we quote them, add a Rev NR (for new release)and a Rev 1
and check them out to group Engineering. If the part isn't booked, it
just stays there, hence the long list of checked out parts. Also, if we
book it, we bump up to Rev 1 and this one is checked in and approved,
but the Rev NR stays checked out.

I thought we could just undo check out to get rid of this long list, but
that loses the rev and its methods. We don't want that. It appears that
we have to approve and check in the rev, then unapprove it in Part
Maintenance.

Am I right here?

thanks in advance,

Randy Weber

[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]

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







[Non-text portions of this message have been removed]
12
I know I was sorely disappointed after hearing Epicor sales brag about how 'tight' they are with Microsoft (during weeks of hard sell as we whittled down our candidates), to finally have one of the sales reps answer my question: "Is Visual Basic for Applications for simple scripting included?" - And he sheepishly said no.

"Tight with Microsoft" but no VBA?! (Please!... I knew we were dealing with used car salesmen after that.)

Rob




________________________________
From: Kerry_Muntz <kerry_muntz@...>
To: vantage@yahoogroups.com
Sent: Wednesday, May 20, 2009 4:38:05 PM
Subject: [Vantage] Re: Engineering workbench





Just read some of the "Update Vantage Using AuotIT" thread. I agree about limiting the high speed playback. Due to the nature of the V8 GUI, we have had to change our thinking, and speed is no longer the main issue for us. When the occassion arises, we now run the macros at either human, or 'very fast human' speed. Speed isn't really the issue, as the macros can run all night (if they are well written), and don't complain about the overtime. Or we can easily set up a second terminal, so a human isn't wasted 'waiting' for the macros to run. The irony is that our support company used to actually encourage us to use the recorders over other mass-change methods when we were using 6, as they mimicked human interface. Now they deny all knowledge of ever encouraging our use of them, and say we need to run them at sub human speed. Macros are great for consistent results, rigid disciplines, and don't suffer RSI or boredom and fatigue.







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