DMT Tool Blank Title 98612

Thx


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of brad_boes
Sent: Wednesday, March 23, 2011 4:40 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: DMT Tool

We are live on 9.05.600b progress 64 bit with no issues. We use the DMT weekly.

Brad Boes
Metalworks

--- In vantage@yahoogroups.com, "Robert Jessop" <rjj@...> wrote:
>
> Is anyone aware of issues related to using the DMT tool in an E9.05 64bit environment? Thanks, Bob Jessop
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]
DMT (Data Management Tool)

- Who's using this tool?
- Is it worthwhile for your organization?
- How does it compare to Service Connect (in reality)

We've got Service Connect, and I believe we were sold Service Connect with the idea that it would be simple to use to get data in and out of Epicor. Not so much. DMT seems like it's much more appropriate for bulk administration-type tasks and looks like a much more straightforward tool.

Thoughts?
Each tool has it's niche.

For repeatable tasks on a schedule, then SC has it hands down.

For a one time mass update, then DMT has it hands down.

One time importing - DMT although I did use SC prior to our purchase of DMT.

My only complaint - DMT is licensed by the year - lapse your maintenance - SOL

$.02

--- In vantage@yahoogroups.com, "cubcrafters_it" <jason.navarrete@...> wrote:
>
> DMT (Data Management Tool)
>
> - Who's using this tool?
> - Is it worthwhile for your organization?
> - How does it compare to Service Connect (in reality)
>
> We've got Service Connect, and I believe we were sold Service Connect with the idea that it would be simple to use to get data in and out of Epicor. Not so much. DMT seems like it's much more appropriate for bulk administration-type tasks and looks like a much more straightforward tool.
>
> Thoughts?
>
We are using DMT to load the initial data into E9. Its incredibly simple to use and there is no problems porting it from the test server to the live server unlike SC.

However, unlike SC you can't program it. Its just setup your data and click import. Any errors are put in a seperate file for you to fix and reimport.

For automation use SC
For simplicity use DMT

Regards
Wayne



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

Not used SC so can't comment but have heard it is a lot slower for data import. We have just upgraded from 6.1 to E9 and used the standard conversions but, then used the DMT to make mass changes to data. For example on V6.1 all are drawing PDF attachments were against the revision and we wanted to move them to the Part.

Personally an essential tool for mass updates which is safe as it checks your business logic.

Regards

Richard

--- In vantage@yahoogroups.com, Wayne Sheldon <wgsheldon@...> wrote:
>
> We are using DMT to load the initial data into E9. Its incredibly simple to use and there is no problems porting it from the test server to the live server unlike SC.

However, unlike SC you can't program it. Its just setup your data and click import. Any errors are put in a seperate file for you to fix and reimport.

For automation use SC
For simplicity use DMT


Regards
Wayne
>
> [Non-text portions of this message have been removed]
>
I'll echo Wayne's sentiments. We just went live on 9.04 on 1/3, and uploaded all our old data (from an ancient unrelated ERP system) via DMT. I still use it frequently for updating corrections to a large number of records.

We are also using SC for a couple of different workflows, and will be increasing its use as time munches on.

Ernie Lowell
Diba Industries
I agree with using Service connect for repeatable tasks, but we use DMT heavily for 1- time importing/data fixes. It seems like we are mass updating/correcting data on a regular basis (especially for MRP analysis and changes) . you can easily correct or change data by simply importing a spreadsheet verses creating a Service connect. It's also a quick fix until you can get your service connect workflow created.

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> Each tool has it's niche.
>
> For repeatable tasks on a schedule, then SC has it hands down.
>
> For a one time mass update, then DMT has it hands down.
>
> One time importing - DMT although I did use SC prior to our purchase of DMT.
>
> My only complaint - DMT is licensed by the year - lapse your maintenance - SOL
>
> $.02
>
> --- In vantage@yahoogroups.com, "cubcrafters_it" <jason.navarrete@> wrote:
> >
> > DMT (Data Management Tool)
> >
> > - Who's using this tool?
> > - Is it worthwhile for your organization?
> > - How does it compare to Service Connect (in reality)
> >
> > We've got Service Connect, and I believe we were sold Service Connect with the idea that it would be simple to use to get data in and out of Epicor. Not so much. DMT seems like it's much more appropriate for bulk administration-type tasks and looks like a much more straightforward tool.
> >
> > Thoughts?
> >
>
I was wondering if it was possible to import BOMs with the help of
Service Connect. I am pretty sure I can use the DMT for that but would
like to automate the process to upload customer provided BOMs.



Mike Tonoyan / Natel Engr.

mtonoyan@...


______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
yes, as well as create new parts on the fly if needed.

Motty


--- In vantage@yahoogroups.com, "Mike Tonoyan" <mtonoyan@...> wrote:
>
> I was wondering if it was possible to import BOMs with the help of
> Service Connect. I am pretty sure I can use the DMT for that but would
> like to automate the process to upload customer provided BOMs.
>
>
>
> Mike Tonoyan / Natel Engr.
>
> mtonoyan@...
>
>
> ______________________________________________________________________
> Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
> ______________________________________________________________________
>
> [Non-text portions of this message have been removed]
>
Would you be willing to share this SC Workflow?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mordechai
Sent: Thursday, March 17, 2011 1:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Is it possible to import BOMs with Service
Connect?





yes, as well as create new parts on the fly if needed.

Motty

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Mike Tonoyan" <mtonoyan@...> wrote:
>
> I was wondering if it was possible to import BOMs with the help of
> Service Connect. I am pretty sure I can use the DMT for that but would
> like to automate the process to upload customer provided BOMs.
>
>
>
> Mike Tonoyan / Natel Engr.
>
> mtonoyan@...
>
>
> __________________________________________________________
> Notice: This email transmission may contain confidential information
and is intended only for the person(s) named. Any use, copying or
disclosure to/by any other person(s) is strictly prohibited. By
accepting this information, recipients confirm that they understand and
will comply with all applicable ITAR and EAR requirements.
> __________________________________________________________
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
We have some old code that has not been used for 2-3 year - can share that - you will need to put some work into it.
let me know what email to send to
Motty

--- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...> wrote:
>
> Would you be willing to share this SC Workflow?
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Mordechai
> Sent: Thursday, March 17, 2011 1:43 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Is it possible to import BOMs with Service
> Connect?
>
>
>
>
>
> yes, as well as create new parts on the fly if needed.
>
> Motty
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Mike Tonoyan" <mtonoyan@> wrote:
> >
> > I was wondering if it was possible to import BOMs with the help of
> > Service Connect. I am pretty sure I can use the DMT for that but would
> > like to automate the process to upload customer provided BOMs.
> >
> >
> >
> > Mike Tonoyan / Natel Engr.
> >
> > mtonoyan@
> >
> >
> > __________________________________________________________
> > Notice: This email transmission may contain confidential information
> and is intended only for the person(s) named. Any use, copying or
> disclosure to/by any other person(s) is strictly prohibited. By
> accepting this information, recipients confirm that they understand and
> will comply with all applicable ITAR and EAR requirements.
> > __________________________________________________________
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
we use Service Connect to import BOMS.

We have create a number of template Parts to use as the routing templates to pull an operation list. We use a user defined field on the Part table to hold the default operation that that part is used in. A file is dropped that contains some general information on the manufactured part and then the BOM below that. One of the fields in the general information is the routing template Part used to pull the operation list for that manufactured part.

So basically the workflow for our process is this:

- Verify manufactured part exist if not then create it (using the general information supplied in the dropped file). (Part.PartExists)
- Verify all purchased parts exist, if some do not, then error out. (sub-workflow of basically Part.PartExists on the components)
- Updating the manufactured part with inform from general information section of dropped file
- Add the new revision (Part.Update)
- Create the EngWorkBench group (EngWorkBench.UpdateCurrentECORev)
- Check out the group (engWorkBench.CheckOut)
- Get the Operation list from the Routing Template passed in from the general information (engWorkBench.GetDetailsOperations)
- Add the Operation List to the new ECO (EngWorkBench.UpdateCurrentECORev)
- Add the components ( Sub-Workflow)
- - Add a new row to the ECOMtl table (EngWorkBench.GetNewECOMTL)
- - Assign the material to the new row (EngWorkBench.UpdateCurrentECORev)


We do not automate the check-in so that we have a visual verification that all parts are assigned to an operation, then we check-in. My workflow works upto the point of checking the results returned from adding of the components. For some reason that check does not work and my workflow bombs out. I have been told by Epicor that in oder to fix the error I will have to redo the entire workflow. So that is on hold.







________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mike Tonoyan
Sent: Thursday, March 17, 2011 9:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Is it possible to import BOMs with Service Connect?



I was wondering if it was possible to import BOMs with the help of
Service Connect. I am pretty sure I can use the DMT for that but would
like to automate the process to upload customer provided BOMs.

Mike Tonoyan / Natel Engr.

mtonoyan@...<mailto:mtonoyan%40natelengr.com>

__________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
__________________________________________________________

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





[Non-text portions of this message have been removed]
Is it possible for me to receive the code also? Can it be posted to the
Vantage user group site?

Just in case my email is: mtonoyan@...



Mike Tonoyan / Natel Engr.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mordechai
Sent: Thursday, March 17, 2011 11:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Is it possible to import BOMs with Service
Connect?






We have some old code that has not been used for 2-3 year - can share
that - you will need to put some work into it.
let me know what email to send to
Motty

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Blake Clemens" <blake.clemens@...> wrote:
>
> Would you be willing to share this SC Workflow?
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Mordechai
> Sent: Thursday, March 17, 2011 1:43 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Is it possible to import BOMs with Service
> Connect?
>
>
>
>
>
> yes, as well as create new parts on the fly if needed.
>
> Motty
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Mike Tonoyan" <mtonoyan@> wrote:
> >
> > I was wondering if it was possible to import BOMs with the help of
> > Service Connect. I am pretty sure I can use the DMT for that but
would
> > like to automate the process to upload customer provided BOMs.
> >
> >
> >
> > Mike Tonoyan / Natel Engr.
> >
> > mtonoyan@
> >
> >




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
We are looking at using service connect for the same reason. Can you send it to me too if possible.

On Thu Mar 17th, 2011 3:14 PM EDT Mike Tonoyan wrote:

>Is it possible for me to receive the code also? Can it be posted to the
>Vantage user group site?
>
>Just in case my email is: mtonoyan@...
>
>
>
>Mike Tonoyan / Natel Engr.
>
>
>
>From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
>Of Mordechai
>Sent: Thursday, March 17, 2011 11:33 AM
>To: vantage@yahoogroups.com
>Subject: [Vantage] Re: Is it possible to import BOMs with Service
>Connect?
>
>
>
>
>
>
>We have some old code that has not been used for 2-3 year - can share
>that - you will need to put some work into it.
>let me know what email to send to
>Motty
>
>--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
>"Blake Clemens" <blake.clemens@...> wrote:
>>
>> Would you be willing to share this SC Workflow?
>>
>>
>>
>> Thanks,
>>
>> Blake Clemens
>>
>> IT Systems Engineer
>>
>> Delmarva Millwork Corporation
>>
>> (800) 360-2364 x132
>>
>> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
>Behalf
>> Of Mordechai
>> Sent: Thursday, March 17, 2011 1:43 PM
>> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>> Subject: [Vantage] Re: Is it possible to import BOMs with Service
>> Connect?
>>
>>
>>
>>
>>
>> yes, as well as create new parts on the fly if needed.
>>
>> Motty
>>
>> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
><mailto:vantage%40yahoogroups.com> ,
>> "Mike Tonoyan" <mtonoyan@> wrote:
>> >
>> > I was wondering if it was possible to import BOMs with the help of
>> > Service Connect. I am pretty sure I can use the DMT for that but
>would
>> > like to automate the process to upload customer provided BOMs.
>> >
>> >
>> >
>> > Mike Tonoyan / Natel Engr.
>> >
>> > mtonoyan@
>> >
>> >
>
>
>
>
>______________________________________________________________________
>Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
>______________________________________________________________________
>
>[Non-text portions of this message have been removed]
>
And send workflow to me as well please.

pgribanov@...
There's also an example in the Student Examples file under the Service Connect folder in the files section of this group.

--- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...> wrote:
>
> Would you be willing to share this SC Workflow?
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Mordechai
> Sent: Thursday, March 17, 2011 1:43 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Is it possible to import BOMs with Service
> Connect?
>
>
>
>
>
> yes, as well as create new parts on the fly if needed.
>
> Motty
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Mike Tonoyan" <mtonoyan@> wrote:
> >
> > I was wondering if it was possible to import BOMs with the help of
> > Service Connect. I am pretty sure I can use the DMT for that but would
> > like to automate the process to upload customer provided BOMs.
> >
> >
> >
> > Mike Tonoyan / Natel Engr.
> >
> > mtonoyan@
> >
> >
> > __________________________________________________________
> > Notice: This email transmission may contain confidential information
> and is intended only for the person(s) named. Any use, copying or
> disclosure to/by any other person(s) is strictly prohibited. By
> accepting this information, recipients confirm that they understand and
> will comply with all applicable ITAR and EAR requirements.
> > __________________________________________________________
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Is anyone aware of issues related to using the DMT tool in an E9.05 64bit environment? Thanks, Bob Jessop

[Non-text portions of this message have been removed]
We are live on 9.05.600b progress 64 bit with no issues. We use the DMT weekly.

Brad Boes
Metalworks

--- In vantage@yahoogroups.com, "Robert Jessop" <rjj@...> wrote:
>
> Is anyone aware of issues related to using the DMT tool in an E9.05 64bit environment? Thanks, Bob Jessop
>
> [Non-text portions of this message have been removed]
>