DMT Questions Blank Title 95545

What table(s) are you looking at importing?

Consider that the use of an updateable Dashboard would work with no cost for you.

If you are pulling the information from one database to another you could just copy the BAQ from one to the other.


I will say that the DMT software is pretty versatile and easy to use.


Bruce


Hi All,



For those that use the DMT, is the order in which the columns are
arranged in the templates important, or does DMT simply read the column
name and map it accordingly?

I ask, because we need to export data from one Epicor 9 database and
import is to another Epicor 9 database and I'm hoping it's just a matter
of dumping the data to a CSV and then importing it.










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
I've been using the tool as we are bringing another site online soon. The ordering does not matter, just the column headings.

Bryan

--- In vantage@yahoogroups.com, Joe Rojas <jrojas@...> wrote:
>
> Hi All,
>
>
>
> For those that use the DMT, is the order in which the columns are
> arranged in the templates important, or does DMT simply read the column
> name and map it accordingly?
>
> I ask, because we need to export data from one Epicor 9 database and
> import is to another Epicor 9 database and I'm hoping it's just a matter
> of dumping the data to a CSV and then importing it.
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
>
>
> This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
>
>
> [Non-text portions of this message have been removed]
>
Thanks Brian and Jose!



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bderuvo
Sent: Wednesday, November 17, 2010 5:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: DMT Questions





I've been using the tool as we are bringing another site online soon.
The ordering does not matter, just the column headings.

Bryan

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Joe
Rojas <jrojas@...> wrote:
>
> Hi All,
>
>
>
> For those that use the DMT, is the order in which the columns are
> arranged in the templates important, or does DMT simply read the
column
> name and map it accordingly?
>
> I ask, because we need to export data from one Epicor 9 database and
> import is to another Epicor 9 database and I'm hoping it's just a
matter
> of dumping the data to a CSV and then importing it.
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
beautiful matting and flooring
>
>
> This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.
>
>
> [Non-text portions of this message have been removed]
>












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
I have been using this tool for a long time on a regular basis to import the data into E9 from a different database. The DMT does not need to have the columns in the order, but as long as the column name & required fields matches it should be good. Â

--- On Wed, 11/17/10, bderuvo <bderuvo@...> wrote:


From: bderuvo <bderuvo@...>
Subject: [Vantage] Re: DMT Questions
To: vantage@yahoogroups.com
Date: Wednesday, November 17, 2010, 4:04 PM


Â



I've been using the tool as we are bringing another site online soon. The ordering does not matter, just the column headings.

Bryan

--- In vantage@yahoogroups.com, Joe Rojas <jrojas@...> wrote:
>
> Hi All,
>
>
>
> For those that use the DMT, is the order in which the columns are
> arranged in the templates important, or does DMT simply read the column
> name and map it accordingly?
>
> I ask, because we need to export data from one Epicor 9 database and
> import is to another Epicor 9 database and I'm hoping it's just a matter
> of dumping the data to a CSV and then importing it.
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
>
>
> This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
>
>
> [Non-text portions of this message have been removed]
>











[Non-text portions of this message have been removed]
Has anyone used the DMT tool to copy Vantage 6.1 open jobs to E9.0X.XXX ?

We have around 2000 that we will need to transfer when we go live.

If so, how did it work out?



Thanks.

Jim Moore



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Doma Reddy
Sent: Wednesday, November 17, 2010 4:10 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: DMT Questions





I have been using this tool for a long time on a regular basis to import the data into E9 from a different database. The DMT does not need to have the columns in the order, but as long as the column name & required fields matches it should be good.

--- On Wed, 11/17/10, bderuvo <bderuvo@... <mailto:bderuvo%40yahoo.com> > wrote:

From: bderuvo <bderuvo@... <mailto:bderuvo%40yahoo.com> >
Subject: [Vantage] Re: DMT Questions
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Wednesday, November 17, 2010, 4:04 PM



I've been using the tool as we are bringing another site online soon. The ordering does not matter, just the column headings.

Bryan

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Joe Rojas <jrojas@...> wrote:
>
> Hi All,
>
>
>
> For those that use the DMT, is the order in which the columns are
> arranged in the templates important, or does DMT simply read the column
> name and map it accordingly?
>
> I ask, because we need to export data from one Epicor 9 database and
> import is to another Epicor 9 database and I'm hoping it's just a matter
> of dumping the data to a CSV and then importing it.
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
>







[Non-text portions of this message have been removed]
Hey guys,
Couple questions about DMT. I am currently using the Updateable Dashboard in Epicor to update a large amount of data fields, but it sucks and I am about to pull my hair out.

I have a large Dashboard that I have created a lot of user defined fields that I update in bulk by using the Updateable Dashboard function.

Is DMT better for this type of daily update of data?
Can I update UD Fields with DMT?
Is there a limit of the amount of records that can be uploaded or updated?
Does the migration of data flawless or are there errors or mistakes by DMT?

The UDashboard won't let me paste update a large amount of lines to update and returns a lot of mistakes. Any info on what works better for my daily updates would be greatly appreciated.

thanks, Andrew

See inline below

www.practicaltek.com

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Drew
Sent: Wednesday, January 22, 2014 3:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] DMT Questions

 

 

Hey guys,
Couple questions about DMT. I am currently using the Updateable Dashboard in Epicor to update a large amount of data fields, but it sucks and I am about to pull my hair out.

I have a large Dashboard that I have created a lot of user defined fields that I update in bulk by using the Updateable Dashboard function.

Is DMT better for this type of daily update of data? - Yes
Can I update UD Fields with DMT? - Yes
Is there a limit of the amount of records that can be uploaded or updated? – Limited by the size of your disc space and time
Does the migration of data flawless or are there errors or mistakes by DMT? – Data imported must adhere to Epicor’s base layer logic/BO’s/etc..

The UDashboard won't let me paste update a large amount of lines to update and returns a lot of mistakes. Any info on what works better for my daily updates would be greatly appreciated.

thanks, Andrew

For user-defined fields that don’t go through Epicor processing, I just dump an Excel sheet into Access and write update queries.

So much faster than DMT.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Drew
Sent: Wednesday, January 22, 2014 3:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] DMT Questions

 

 

Hey guys,
Couple questions about DMT. I am currently using the Updateable Dashboard in Epicor to update a large amount of data fields, but it sucks and I am about to pull my hair out.

I have a large Dashboard that I have created a lot of user defined fields that I update in bulk by using the Updateable Dashboard function.

Is DMT better for this type of daily update of data?
Can I update UD Fields with DMT?
Is there a limit of the amount of records that can be uploaded or updated?
Does the migration of data flawless or are there errors or mistakes by DMT?

The UDashboard won't let me paste update a large amount of lines to update and returns a lot of mistakes. Any info on what works better for my daily updates would be greatly appreciated.

thanks, Andrew

That is beyond my capabilities. I made a dashboard for about 20-25 Dimension fields(L,W,H,LBS,Ship L, Ship W...) and I have an employee that works all new skus and existing ones to get us the most accurate DIMs data possible. Using the Updateable Dashboard is such a mess and unpredictable. Sometimes it lets me dump 25K lines at a time and sometimes it will crash with 1000 lines of data. I have heard of DMT and didn't know if it will help with UD Fields.

--- In vantage@yahoogroups.com, "Turgeon, Bill" <bturgeon@...> wrote:
>
> For user-defined fields that don't go through Epicor processing, I just
> dump an Excel sheet into Access and write update queries.
>
> So much faster than DMT.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Drew
> Sent: Wednesday, January 22, 2014 3:52 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] DMT Questions
>
>
>
>
>
> Hey guys,
> Couple questions about DMT. I am currently using the Updateable
> Dashboard in Epicor to update a large amount of data fields, but it
> sucks and I am about to pull my hair out.
>
> I have a large Dashboard that I have created a lot of user defined
> fields that I update in bulk by using the Updateable Dashboard function.
>
>
> Is DMT better for this type of daily update of data?
> Can I update UD Fields with DMT?
> Is there a limit of the amount of records that can be uploaded or
> updated?
> Does the migration of data flawless or are there errors or mistakes by
> DMT?
>
> The UDashboard won't let me paste update a large amount of lines to
> update and returns a lot of mistakes. Any info on what works better for
> my daily updates would be greatly appreciated.
>
> thanks, Andrew
>

Yes, it works with user defined fields.  I just find it to be very slow.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Drew
Sent: Wednesday, January 22, 2014 4:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: DMT Questions

 

 

That is beyond my capabilities. I made a dashboard for about 20-25 Dimension fields(L,W,H,LBS,Ship L, Ship W...) and I have an employee that works all new skus and existing ones to get us the most accurate DIMs data possible. Using the Updateable Dashboard is such a mess and unpredictable. Sometimes it lets me dump 25K lines at a time and sometimes it will crash with 1000 lines of data. I have heard of DMT and didn't know if it will help with UD Fields.

--- In vantage@yahoogroups.com, "Turgeon, Bill" <bturgeon@...> wrote:
>
> For user-defined fields that don't go through Epicor processing, I just
> dump an Excel sheet into Access and write update queries.
>
> So much faster than DMT.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Drew
> Sent: Wednesday, January 22, 2014 3:52 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] DMT Questions
>
>
>
>
>
> Hey guys,
> Couple questions about DMT. I am currently using the Updateable
> Dashboard in Epicor to update a large amount of data fields, but it
> sucks and I am about to pull my hair out.
>
> I have a large Dashboard that I have created a lot of user defined
> fields that I update in bulk by using the Updateable Dashboard function.
>
>
> Is DMT better for this type of daily update of data?
> Can I update UD Fields with DMT?
> Is there a limit of the amount of records that can be uploaded or
> updated?
> Does the migration of data flawless or are there errors or mistakes by
> DMT?
>
> The UDashboard won't let me paste update a large amount of lines to
> update and returns a lot of mistakes. Any info on what works better for
> my daily updates would be greatly appreciated.
>
> thanks, Andrew
>

LoL Bill I wouldn't go announcing that too much if you want to keep your support... Epicor frowns very much at direct updates like that.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Wed, Jan 22, 2014 at 3:59 PM, Turgeon, Bill <bturgeon@...> wrote:

Â
<div>
  
  
  <p></p><div><p class="ygrps-yiv-1258044596MsoNormal"><span style="font-size:11.0pt;color:#1f497d;">For user-defined fields that don’t go through Epicor processing, I just dump an Excel sheet into Access and write update queries.<u></u><u></u></span></p>

So much faster than DMT.

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Drew

Sent: Wednesday, January 22, 2014 3:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] DMT Questions

Â

Â

Hey guys,


Couple questions about DMT. I am currently using the Updateable Dashboard in Epicor to update a large amount of data fields, but it sucks and I am about to pull my hair out.


I have a large Dashboard that I have created a lot of user defined fields that I update in bulk by using the Updateable Dashboard function.

Is DMT better for this type of daily update of data?
Can I update UD Fields with DMT?

Is there a limit of the amount of records that can be uploaded or updated?
Does the migration of data flawless or are there errors or mistakes by DMT?

The UDashboard won't let me paste update a large amount of lines to update and returns a lot of mistakes. Any info on what works better for my daily updates would be greatly appreciated.


thanks, Andrew

</div>
 


<div style="color:#fff;min-height:0;"></div>

I guess I need to learn your way.

--- In vantage@yahoogroups.com, "Turgeon, Bill" <bturgeon@...> wrote:
>
> Yes, it works with user defined fields. I just find it to be very slow.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Drew
> Sent: Wednesday, January 22, 2014 4:08 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: DMT Questions
>
>
>
>
>
> That is beyond my capabilities. I made a dashboard for about 20-25
> Dimension fields(L,W,H,LBS,Ship L, Ship W...) and I have an employee
> that works all new skus and existing ones to get us the most accurate
> DIMs data possible. Using the Updateable Dashboard is such a mess and
> unpredictable. Sometimes it lets me dump 25K lines at a time and
> sometimes it will crash with 1000 lines of data. I have heard of DMT and
> didn't know if it will help with UD Fields.
>
> --- In vantage@yahoogroups.com, "Turgeon, Bill" <bturgeon@> wrote:
> >
> > For user-defined fields that don't go through Epicor processing, I
> just
> > dump an Excel sheet into Access and write update queries.
> >
> > So much faster than DMT.
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of Drew
> > Sent: Wednesday, January 22, 2014 3:52 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] DMT Questions
> >
> >
> >
> >
> >
> > Hey guys,
> > Couple questions about DMT. I am currently using the Updateable
> > Dashboard in Epicor to update a large amount of data fields, but it
> > sucks and I am about to pull my hair out.
> >
> > I have a large Dashboard that I have created a lot of user defined
> > fields that I update in bulk by using the Updateable Dashboard
> function.
> >
> >
> > Is DMT better for this type of daily update of data?
> > Can I update UD Fields with DMT?
> > Is there a limit of the amount of records that can be uploaded or
> > updated?
> > Does the migration of data flawless or are there errors or mistakes by
> > DMT?
> >
> > The UDashboard won't let me paste update a large amount of lines to
> > update and returns a lot of mistakes. Any info on what works better
> for
> > my daily updates would be greatly appreciated.
> >
> > thanks, Andrew
> >
>

Oppp!!!  I mean I use DMT for all that stuff (grin)

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Wednesday, January 22, 2014 4:11 PM
To: Vantage
Subject: Re: [Vantage] DMT Questions

 

 

LoL Bill I wouldn't go announcing that too much if you want to keep your support... Epicor frowns very much at direct updates like that.



Jose C Gomez

Software Engineer

 


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Wed, Jan 22, 2014 at 3:59 PM, Turgeon, Bill <bturgeon@...> wrote:

 

For user-defined fields that don’t go through Epicor processing, I just dump an Excel sheet into Access and write update queries.

So much faster than DMT.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Drew
Sent: Wednesday, January 22, 2014 3:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] DMT Questions

 

 

Hey guys,


Couple questions about DMT. I am currently using the Updateable Dashboard in Epicor to update a large amount of data fields, but it sucks and I am about to pull my hair out.

I have a large Dashboard that I have created a lot of user defined fields that I update in bulk by using the Updateable Dashboard function.

Is DMT better for this type of daily update of data?
Can I update UD Fields with DMT?
Is there a limit of the amount of records that can be uploaded or updated?
Does the migration of data flawless or are there errors or mistakes by DMT?

The UDashboard won't let me paste update a large amount of lines to update and returns a lot of mistakes. Any info on what works better for my daily updates would be greatly appreciated.

thanks, Andrew

 

That's what I thought Bill I always confuse DMT and Access myself its a typo ;-) lol



Jose C Gomez
Software Engineer



T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Wed, Jan 22, 2014 at 4:13 PM, Turgeon, Bill <bturgeon@...> wrote:

Â
<div>
  
  
  <p></p><div><p class="ygrps-yiv-1581455564MsoNormal"><span style="font-size:11.0pt;color:#1f497d;">Oppp!!!  I mean I use DMT for all that stuff (grin)<u></u><u></u></span></p><p class="ygrps-yiv-1581455564MsoNormal"><span style="font-size:11.0pt;color:#1f497d;"><u></u> <u></u></span></p>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez

Sent: Wednesday, January 22, 2014 4:11 PM
To: Vantage
Subject: Re: [Vantage] DMT Questions

Â

Â

LoL Bill I wouldn't go announcing that too much if you want to keep your support… Epicor frowns very much at direct updates like that.



Jose C Gomez

Software Engineer

Â


T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?

Â

On Wed, Jan 22, 2014 at 3:59 PM, Turgeon, Bill <bturgeon@...> wrote:

Â

For user-defined fields that don’t go through Epicor processing, I just dump an Excel sheet into Access and write update queries.

So much faster than DMT.

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Drew

Sent: Wednesday, January 22, 2014 3:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] DMT Questions

Â

Â

Hey guys,


Couple questions about DMT. I am currently using the Updateable Dashboard in Epicor to update a large amount of data fields, but it sucks and I am about to pull my hair out.


I have a large Dashboard that I have created a lot of user defined fields that I update in bulk by using the Updateable Dashboard function.

Is DMT better for this type of daily update of data?
Can I update UD Fields with DMT?

Is there a limit of the amount of records that can be uploaded or updated?
Does the migration of data flawless or are there errors or mistakes by DMT?

The UDashboard won't let me paste update a large amount of lines to update and returns a lot of mistakes. Any info on what works better for my daily updates would be greatly appreciated.


thanks, Andrew

Â

</div>
 


<div style="color:#fff;min-height:0;"></div>

Wow, so much of Epicor is a black box (the Bo's) I can't imagine doing that. Sincerely. Sounds like it's working for you though. 


On Jan 22, 2014, at 4:13 PM, "Turgeon, Bill" <bturgeon@...> wrote:

 

Oppp!!!  I mean I use DMT for all that stuff (grin)

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Wednesday, January 22, 2014 4:11 PM
To: Vantage
Subject: Re: [Vantage] DMT Questions

 

 

LoL Bill I wouldn't go announcing that too much if you want to keep your support... Epicor frowns very much at direct updates like that.



Jose C Gomez

Software Engineer

 


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Wed, Jan 22, 2014 at 3:59 PM, Turgeon, Bill <bturgeon@...> wrote:

 

For user-defined fields that don’t go through Epicor processing, I just dump an Excel sheet into Access and write update queries.

So much faster than DMT.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Drew
Sent: Wednesday, January 22, 2014 3:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] DMT Questions

 

 

Hey guys,


Couple questions about DMT. I am currently using the Updateable Dashboard in Epicor to update a large amount of data fields, but it sucks and I am about to pull my hair out.

I have a large Dashboard that I have created a lot of user defined fields that I update in bulk by using the Updateable Dashboard function.

Is DMT better for this type of daily update of data?
Can I update UD Fields with DMT?
Is there a limit of the amount of records that can be uploaded or updated?
Does the migration of data flawless or are there errors or mistakes by DMT?

The UDashboard won't let me paste update a large amount of lines to update and returns a lot of mistakes. Any info on what works better for my daily updates would be greatly appreciated.

thanks, Andrew

 

Do you have a sql manager?  


Update part set part.character01 = "" where part.typecode = M


It's the kind of code you have to write, one field at time in sql.  


In DMT' you begin by creating a template of the table you want to update.  You select the field needed to be updated.  Then, you fill up your template with your information.


For sure, for each row you update throught DMT, it takes several seconds....  


DMT will not work if you have an error, and it will clear what it has done.  That way, if there is a mistake, everything is better.


DMT create large tempfiles though....  So you have to start your server sometimes to be sure you clean it.

I do have SQL Manager. I will have to look into that. I have to find a better way of doing this.

--- In vantage@yahoogroups.com, <amelie.pelletier@...> wrote:
>
> Do you have a sql manager?
>
>
> Update part set part.character01 = "" where part.typecode = M
>
>
> It's the kind of code you have to write, one field at time in sql.
>
>
> In DMT' you begin by creating a template of the table you want to update. You select the field needed to be updated. Then, you fill up your template with your information.
>
>
> For sure, for each row you update throught DMT, it takes several seconds....
>
>
> DMT will not work if you have an error, and it will clear what it has done. That way, if there is a mistake, everything is better.
>
>
> DMT create large tempfiles though.... So you have to start your server sometimes to be sure you clean it.
>

I’ll get off this after this but, please seriously consider not updating the database directly.  I speak TSQL so, I feel your pain but, the reason that the DMT takes time to enter records (not all inserts / updates perform the same way.  Some take many seconds per record, some are many records per second) is that they are being processed through Epicor’s business objects.  Records of related tables may be updated, data validity is checked, any relevant BPMs or Data Directives you’ve created will do their work. 

 

You can script the DMT to queue up your imports / updates so it can work while you eat dinner.  It kicks out any bad records into another file for fixing and reimporting.  We’ve had to have Epicor create templates for us on a few occasions but, I can’t remember that the DMT has ever been the source of a problem. 

 

Just can’t stress enough that you really don’t know the ramifications of bypassing the Business Logic.  Updating the database could absolutely corrupt your database absolutely. 

 

Okay, I’m off my soap box.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Drew
Sent: Wednesday, January 22, 2014 5:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: DMT Questions

 

 

I do have SQL Manager. I will have to look into that. I have to find a better way of doing this.

--- In vantage@yahoogroups.com, <amelie.pelletier@...> wrote:
>
> Do you have a sql manager?
>
>
> Update part set part.character01 = "" where part.typecode = M
>
>
> It's the kind of code you have to write, one field at time in sql.
>
>
> In DMT' you begin by creating a template of the table you want to update. You select the field needed to be updated. Then, you fill up your template with your information.
>
>
> For sure, for each row you update throught DMT, it takes several seconds....
>
>
> DMT will not work if you have an error, and it will clear what it has done. That way, if there is a mistake, everything is better.
>
>
> DMT create large tempfiles though.... So you have to start your server sometimes to be sure you clean it.
>

*steps up to the soap box after joe*

Joe if you go to insights remind me to buy you a drink....Â


Listen to Joe guys its not worth loosing your support (at best) and ruining your DB (at worst). You don't have to buy DMT if you don't want to but do get help form someone and set up a process that uses the business objects (DMT will most likely be cheaper… but ok). Its worth the money and the hassle to know that if something does blow up you'll be covered.


Epicor doesn't do this because they want to be jerks or cause they want your money (ok they do want that, but that's besides the point). They do it to protect you and your data from accidentally destroying / damaging information that may not be able to be recovered.

And you know what I am a "bad ass mofo in T-SQL" <-- take that as a cheeky statement, but I do not ever ever ever update the DB through it. I will query it to hell and back (on read only mode) but I will never update it. Its not worth it.



Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

E: jose@…

http://www.josecgomez.com
     Â


Quis custodiet ipsos custodes?


On Wed, Jan 22, 2014 at 5:33 PM, Joe Englert <englertj@...> wrote:

Â
<div>
  
  
  <p>

I’ll get off this after this but, please seriously consider not updating the database directly. I speak TSQL so, I feel your pain but, the reason that the DMT takes time to enter records (not all inserts / updates perform the same way. Some take many seconds per record, some are many records per second) is that they are being processed through Epicor’s business objects. Records of related tables may be updated, data validity is checked, any relevant BPMs or Data Directives you’ve created will do their work.Â

Â

You can script the DMT to queue up your imports / updates so it can work while you eat dinner. It kicks out any bad records into another file for fixing and reimporting. We’ve had to have Epicor create templates for us on a few occasions but, I can’t remember that the DMT has ever been the source of a problem.Â

Â

Just can’t stress enough that you really don’t know the ramifications of bypassing the Business Logic. Updating the database could absolutely corrupt your database absolutely.Â

Â

Okay, I’m off my soap box.

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Drew


Sent: Wednesday, January 22, 2014 5:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: DMT Questions

Â

Â

I do have SQL Manager. I will have to look into that. I have to find a better way of doing this.



--- In vantage@yahoogroups.com, <amelie.pelletier@...> wrote:
>
> Do you have a sql manager?
>
>
> Update part set part.character01 = "" where part.typecode = M
>
>
> It's the kind of code you have to write, one field at time in sql.
>
>
> In DMT' you begin by creating a template of the table you want to update. You select the field needed to be updated. Then, you fill up your template with your information.
>
>
> For sure, for each row you update throught DMT, it takes several seconds....
>
>
> DMT will not work if you have an error, and it will clear what it has done. That way, if there is a mistake, everything is better.
>
>
> DMT create large tempfiles though.... So you have to start your server sometimes to be sure you clean it.
>

</div>
 


<div style="color:#fff;min-height:0;"></div>