Part Maintenance Mass Update

Yahoo Archive
1
Your sales rep.

From: vacortes21
Sent: Thursday, October 20, 2011 12:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Part Maintenance Mass Update


Can anyone help me find this DMT tool?

--- In mailto:vantage%40yahoogroups.com, "Lisser, Jennifer" <Jennifer.Lisser@...> wrote:
>
> Jeff,
> We use the DMT Tool on a regular basis to mass update parts - BOMs, BOOs, Revs, etc. It has been rock solid and they now even have the ability to create scripts & run them off hours if you want. That way when we do massive part updates we can chain the updates to make sure the operation is on the bill before we add the material, part exists before we add a rev, etc. You can run adds, deletes & updates with the tool. There is also a log to show you exactly what updates were successful and what ones weren't. The tool isn't limited to parts either - we also use it for mass updates on customers, supplier price lists and a whole bunch of other things. It was much easier using this DMT than the Service Connect templates when we went live. I don't know if Service Connect has improved, but at the time it required us to have every column in the exact order in our spreadsheets and it was MUCH slower than the DMT loads. With the DMT we need to include the required columns, but after that just pick and choose what we to update and not worry about the order of the columns.
>
> Jenn Lisser
> Business Analyst
> Dorner Mfg. Corp.
>
>
> [Non-text portions of this message have been removed]
>




No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1831 / Virus Database: 2092/4563 - Release Date: 10/20/11


[Non-text portions of this message have been removed]
2
Vantage 8.03.409C

First, if this is a duplicate post from me I apologize. Didn't see my post from last hour. Looking for a quick option to do a mass update in Part Maintenance.

I have approximately 1,700 parts where I need to set the "Backflush" as true. My common variables are... 1) all are Purchased Parts and 2) all are from 2 warehouses.

Any way to perform this without going into each part?

Jeff
3
Do you have service connect?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jplehr
Sent: Wednesday, June 08, 2011 11:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Part Maintenance Mass Update





Vantage 8.03.409C

First, if this is a duplicate post from me I apologize. Didn't see my
post from last hour. Looking for a quick option to do a mass update in
Part Maintenance.

I have approximately 1,700 parts where I need to set the "Backflush" as
true. My common variables are... 1) all are Purchased Parts and 2) all
are from 2 warehouses.

Any way to perform this without going into each part?

Jeff





[Non-text portions of this message have been removed]
4
I replied to your original post, don't know if you saw it:

Normally I wouldn't suggest going straight to the DB, but this is simple
enough that you'll probably be ok.

Disclaimer: I'm not familiar with the intricacies/requirements of
backflushing. But as long as it's something that can just be checked on
every part with no issues, you should be ok. For example, you can pretty
much always change the description whenever you want; but UOMs can't be
changed as they are referenced in other places. If changing the backflush
status on a part ever gives you an exception like 'can't change backflush
because of X' you'll need a more complex method. (Which I can help you with,
if it comes to that.)

Assuming it's a simple field to change; a bit of 4gl like the following
should do the trick:

FOR EACH Part WHERE Part.Field = "SomeValue" AND Part.OtherField <>
"SomeOtherValue".
ASSIGN Part.BackFlush = true.
END.

I'm not sure if Part.BackFlush is the actual field name, but I'm sure you
know/can find out for yourself.
Also, it's probably wise to dupe your DB into Test and try this there the
first time. Another good trick is to populate one of your UD fields with
'changed during backflush update' or something so you can reliably find
those records if you end up needing to undo this.

On Wed, Jun 8, 2011 at 1:27 PM, Blake Clemens <blake.clemens@...>wrote:

>
>
> Do you have service connect?
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of jplehr
> Sent: Wednesday, June 08, 2011 11:01 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Part Maintenance Mass Update
>
>
> Vantage 8.03.409C
>
> First, if this is a duplicate post from me I apologize. Didn't see my
> post from last hour. Looking for a quick option to do a mass update in
> Part Maintenance.
>
> I have approximately 1,700 parts where I need to set the "Backflush" as
> true. My common variables are... 1) all are Purchased Parts and 2) all
> are from 2 warehouses.
>
> Any way to perform this without going into each part?
>
> Jeff
>
> [Non-text portions of this message have been removed]
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
5
What's the general, Epicor-centric way to run arbitrary 4GL code like that?

The DMT (Data Maintenance Tool) seems like the other obvious tool for something like this, but I don't actually own the tool yet to say for sure.

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> I replied to your original post, don't know if you saw it:
>
> Normally I wouldn't suggest going straight to the DB, but this is simple
> enough that you'll probably be ok.
>
> Disclaimer: I'm not familiar with the intricacies/requirements of
> backflushing. But as long as it's something that can just be checked on
> every part with no issues, you should be ok. For example, you can pretty
> much always change the description whenever you want; but UOMs can't be
> changed as they are referenced in other places. If changing the backflush
> status on a part ever gives you an exception like 'can't change backflush
> because of X' you'll need a more complex method. (Which I can help you with,
> if it comes to that.)
>
> Assuming it's a simple field to change; a bit of 4gl like the following
> should do the trick:
>
> FOR EACH Part WHERE Part.Field = "SomeValue" AND Part.OtherField <>
> "SomeOtherValue".
> ASSIGN Part.BackFlush = true.
> END.
>
> I'm not sure if Part.BackFlush is the actual field name, but I'm sure you
> know/can find out for yourself.
> Also, it's probably wise to dupe your DB into Test and try this there the
> first time. Another good trick is to populate one of your UD fields with
> 'changed during backflush update' or something so you can reliably find
> those records if you end up needing to undo this.
>
> On Wed, Jun 8, 2011 at 1:27 PM, Blake Clemens <blake.clemens@...>wrote:
>
> >
> >
> > Do you have service connect?
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of jplehr
> > Sent: Wednesday, June 08, 2011 11:01 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Part Maintenance Mass Update
> >
> >
> > Vantage 8.03.409C
> >
> > First, if this is a duplicate post from me I apologize. Didn't see my
> > post from last hour. Looking for a quick option to do a mass update in
> > Part Maintenance.
> >
> > I have approximately 1,700 parts where I need to set the "Backflush" as
> > true. My common variables are... 1) all are Purchased Parts and 2) all
> > are from 2 warehouses.
> >
> > Any way to perform this without going into each part?
> >
> > Jeff
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
6
Via the progress client. Should be installed on your server. You need a 4gl
developer license to do it on 8xx versions. You can cheat and run it through
a BPM, but it's kinda hacky.

On Wed, Jun 8, 2011 at 2:07 PM, cubcrafters_it <
jason.navarrete@...> wrote:

>
>
> What's the general, Epicor-centric way to run arbitrary 4GL code like that?
>
> The DMT (Data Maintenance Tool) seems like the other obvious tool for
> something like this, but I don't actually own the tool yet to say for sure.
>
>
> --- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
> >
> > I replied to your original post, don't know if you saw it:
> >
> > Normally I wouldn't suggest going straight to the DB, but this is simple
> > enough that you'll probably be ok.
> >
> > Disclaimer: I'm not familiar with the intricacies/requirements of
> > backflushing. But as long as it's something that can just be checked on
> > every part with no issues, you should be ok. For example, you can pretty
> > much always change the description whenever you want; but UOMs can't be
> > changed as they are referenced in other places. If changing the backflush
> > status on a part ever gives you an exception like 'can't change backflush
> > because of X' you'll need a more complex method. (Which I can help you
> with,
> > if it comes to that.)
> >
> > Assuming it's a simple field to change; a bit of 4gl like the following
> > should do the trick:
> >
> > FOR EACH Part WHERE Part.Field = "SomeValue" AND Part.OtherField <>
> > "SomeOtherValue".
> > ASSIGN Part.BackFlush = true.
> > END.
> >
> > I'm not sure if Part.BackFlush is the actual field name, but I'm sure you
> > know/can find out for yourself.
> > Also, it's probably wise to dupe your DB into Test and try this there the
> > first time. Another good trick is to populate one of your UD fields with
> > 'changed during backflush update' or something so you can reliably find
> > those records if you end up needing to undo this.
> >
> > On Wed, Jun 8, 2011 at 1:27 PM, Blake Clemens <blake.clemens@...>wrote:
>
> >
> > >
> > >
> > > Do you have service connect?
> > >
> > > Thanks,
> > >
> > > Blake Clemens
> > >
> > > IT Systems Engineer
> > >
> > > Delmarva Millwork Corporation
> > >
> > > (800) 360-2364 x132
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > > Of jplehr
> > > Sent: Wednesday, June 08, 2011 11:01 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Part Maintenance Mass Update
> > >
> > >
> > > Vantage 8.03.409C
> > >
> > > First, if this is a duplicate post from me I apologize. Didn't see my
> > > post from last hour. Looking for a quick option to do a mass update in
> > > Part Maintenance.
> > >
> > > I have approximately 1,700 parts where I need to set the "Backflush" as
> > > true. My common variables are... 1) all are Purchased Parts and 2) all
> > > are from 2 warehouses.
> > >
> > > Any way to perform this without going into each part?
> > >
> > > Jeff
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> >
> >
> > --
> > *Waffqle Driggers*
>
> > *High End Dev, System Design, Profit Drinking
> > *
> > *:: 904.962.2887*
> > *:: waffqle@...*
> > *:: NO FAXES*
> >
> > *
>
> >
> > *
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
7
Jeff,
We use the DMT Tool on a regular basis to mass update parts - BOMs, BOOs, Revs, etc. It has been rock solid and they now even have the ability to create scripts & run them off hours if you want. That way when we do massive part updates we can chain the updates to make sure the operation is on the bill before we add the material, part exists before we add a rev, etc. You can run adds, deletes & updates with the tool. There is also a log to show you exactly what updates were successful and what ones weren't. The tool isn't limited to parts either - we also use it for mass updates on customers, supplier price lists and a whole bunch of other things. It was much easier using this DMT than the Service Connect templates when we went live. I don't know if Service Connect has improved, but at the time it required us to have every column in the exact order in our spreadsheets and it was MUCH slower than the DMT loads. With the DMT we need to include the required columns, but after that just pick and choose what we to update and not worry about the order of the columns.

Jenn Lisser
Business Analyst
Dorner Mfg. Corp.


[Non-text portions of this message have been removed]
8
Can anyone help me find this DMT tool?

--- In vantage@yahoogroups.com, "Lisser, Jennifer" <Jennifer.Lisser@...> wrote:
>
> Jeff,
> We use the DMT Tool on a regular basis to mass update parts - BOMs, BOOs, Revs, etc. It has been rock solid and they now even have the ability to create scripts & run them off hours if you want. That way when we do massive part updates we can chain the updates to make sure the operation is on the bill before we add the material, part exists before we add a rev, etc. You can run adds, deletes & updates with the tool. There is also a log to show you exactly what updates were successful and what ones weren't. The tool isn't limited to parts either - we also use it for mass updates on customers, supplier price lists and a whole bunch of other things. It was much easier using this DMT than the Service Connect templates when we went live. I don't know if Service Connect has improved, but at the time it required us to have every column in the exact order in our spreadsheets and it was MUCH slower than the DMT loads. With the DMT we need to include the required columns, but after that just pick and choose what we to update and not worry about the order of the columns.
>
> Jenn Lisser
> Business Analyst
> Dorner Mfg. Corp.
>
>
> [Non-text portions of this message have been removed]
>