I was able to DMT the method of manufacturing (MOM) for BOMs using the Bill of Operations, I used the template from the Epicor's DMT download page and then modified slightly. I also created a BAQ Â to export the data from one database into another, which I will create a dashboard for.Â
We are not live yet in Epicor, but our running actually jobs in Pilot until we go live. I am exporting those MOMs from the jobs and importing into live.
We are not live yet in Epicor, but our running actually jobs in Pilot until we go live. I am exporting those MOMs from the jobs and importing into live.
--- In vantage@yahoogroups.com, Greg Payne <gpayne@...> wrote:
>
> Thanks, I was using a vba routine and vlookup to do this.
>
> Greg
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Gary Parfrey
> Sent: Thursday, July 05, 2012 7:13 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] RE: DMT Tool - Location for PartOpr, PartOprDtl and ParMtl
>
>
>
> Greg, All
>
> There is a new free DMT Difftool on Epicweb
>
> DMTDiff is a command line utility that allows you to compare changes between groups of files.
>
> This is useful when you are exporting large amounts of data to be imported into Epicor via DMT ahead of time.
>
> Hence you extract your data to CSV, then you Import this into Epicor via DMT. You retain the original load files.
>
> After a period of time you extract the data again, utilize the DMTDiff tool to compare it to the previously loaded data and it will provide you with just the changes, which you can load.
>
> The utility also allows the ability to split and merge data files to aid in the importing and comparison of large or multiple data sets.
>
> Its free and is downloadable from the DMT section of Epicweb
>
> Regards
>
> Gary
>
> If you have a large amounts of data
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Greg Payne
> Sent: 05 July 2012 03:54
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] RE: DMT Tool - Location for PartOpr, PartOprDtl and ParMtl
>
> Pick Engineering, Bill of Operations. Click on Template builder button, you will find the tables at the bottom. Pick the fields you want, the required ones are already checked, then create a template csv file.
>
> I use an odbc connection in Excel to fill the template from Epicor and then dmt back the results.
>
> The DMT 1.0.4.5 Labs and Templates from epicweb is a good resource if you don't already have it.
>
> A tip I got from my DMT trainer was to break up a large dmt spreadsheet to smaller chunks and run multiple sessions. I am importing 50K+ operations and I run 5 sessions of 10K each in 3 hours.
>
> Greg
>
> 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 Miguel Santillan
> Sent: Tuesday, July 03, 2012 12:42 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] DMT Tool - Location for PartOpr, PartOprDtl and ParMtl
>
> Where in the DMT do I find:
> PartOpr = Engineering > Bill of Operations????
> PartOpDtl = ??????
> Part Mtl = Engineering > Bill of Materials????
>
> Regards,
>
> Miguel A. Santillan
>
> [Non-text portions of this message have been removed]
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at (727) 578-6258 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at (727) 578-6258 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
>
> [Non-text portions of this message have been removed]
>