DMT & Change Log Report - Assistance Needed

[dgreenEA (Dylan Green)]

Found the issue. Forgot to include the line number and rel number. Once included that error stopped occurring.

[hkeric.wci (Haso Keric)]

@dgreenEA

image617×560 20.9 KB

ttOrderRel.SetUDField<System.String>("PrevShipTo_c", ttOrderRelRow.ShipToNum);

But im not sure if you can add it in the expression, unless you use ttOrderRelRow.SetUDField

[dgreenEA (Dylan Green)]

@hkeric.wci,
That seemed to do the trick! Thank you sir!

Next Section of the project is to schedule DMT. I’m currently looking into how to use Windows scheduler to run it, but I haven’t found anything that tells it where to look to files or how to do so. If anyone has so insight on how to I would greatly appreciate it.

I am currently following these two posts:

Schedule a process/task in Epicor

If you are in 600+ you have Functions… [image] And you can definitely schedule those and they are WONDERFUL… right @Mark_Wonsil

Using a Task Agent Schedule to run a BPM on a schedule

The topic came up elsewhere so I thought I’d make a general post for those who want to see how it works. My apologies if this is already a topic elsewhere - I did not see a similar post in my cursory search. Premise - how to run a BPM (usually a chunk of custom code) on a schedule with no add-ons to the basic system such as the User Process Scheduler add on. Solution - using the Task Agent schedules, you can create a schedule that has no tasks, but can trigger a BPM that is itself selective in…

What I don’t understand is what is to go in the custom c# coding section. Does anyone know what is to be put there?

[ckrusen (Calvin Krusen)]

@dgreenEA

Next Section of the project is to schedule DMT. I’m currently looking into how to use Windows scheduler to run it, but I haven’t found anything that tells it where to look to files or how to do so. If anyone has so insight on how to I would greatly appreciate it.

I use Windows Task Scheduler to run a DMT daily. But the windows task specifies a PowerShell(PS) script to run at a certain time each day.

You could make a PS script, that checks for the existence of a file and the if it exists, the call DMT via the command line, and then delete the file. This PS script could be scheduled to run every 5 minutes.

Looking for something like that?

edit

And here’s a lengthy topic on DMT and PowerShell

DMT Powershell Help

So I am trying to create a powershell script to import data into the Product Group table. I use the following script: Start-Process -Wait -FilePath $DMTPath -ArgumentList "-User $User -Pass $Pass -Delete -Import “Product Group” -Source $Source " I get this message: [image] So my Import variable is not accepting spaces. How do I get it to except spaces. It works fine with “Part”, because no spaces. Thanks!

and FWIW - I struggled with how to use quotes in a string that is referenced by another string.