MES - Automatic Clock Out

aclements · October 5, 2020, 7:47am

I use the DMT.

aclements · October 5, 2020, 7:48am

I’m happy to post the script, if you want to give it a go.

aarong · October 5, 2020, 7:49am

Sounds like a plan…

aclements · October 5, 2020, 8:00am

Here is the script

The BAQ is very simple and queries the LaborHed table for records where the ‘ClockOutTime’ = 0.

The columns selected are

The calculated columns are:

aarong · October 5, 2020, 8:28am

What’s the name of your BAQ I couldn’t find it in your script to change it.

aclements · October 5, 2020, 8:29am

See below

aarong · October 5, 2020, 9:11am

I’m getting this back…

aclements · October 5, 2020, 9:28am

I think the issue may be the line

$Env = “net.tcp://EPICORAPP/EpicorERP”

Just check the final double quotes is in fact shift-2

Just check all your double quotes

aarong · October 5, 2020, 9:34am

Found the issue.

Should this PS script clock emps out?

aarong · October 5, 2020, 10:16am

I can’t seem to get it to generate a csv file it’s just blank

aclements · October 5, 2020, 1:46pm

Does the BAQ return rows when you run it manually?

aarong · October 5, 2020, 2:16pm

It does return rows

aclements · October 5, 2020, 2:41pm

Have you tried running it from the command line using the DMT example

start C:\Epicor\ERP10\DMT.exe -User=myuser -Pass=mypass -Export -BAQ="BAQClockOut" -Target="C:\temp\clockout.csv"

aarong · October 6, 2020, 10:27am

Hi Andrew,

Still bring back nothing unfortunately.

Maybe we can discuss this over Teams?

Kind regards,
Aaron.