I believe the order the fields are in on the file are important too. It reads them left to right I believe. So if you have your detail fields first, it won’t find the headers.
If you can do this, this will help everyone help you so we don’t have to guess at what could be the problem.
And also,
Which DMT program are you trying to use? I would probably recommend using the TE Labor Detail No Header program to start, it’s easier and won’t give you that particular error.
There ARE reasons to use TE Labor Detail, but it is more complicated.
I am sorry I got incomplete information from the user. I am meeting with the user to get some facts straightened out. This may turn out that I was going in a rabbit hole. Once I get everything and all the facts established, I will reopen this if I need to. Thanks for all the help. As I have indicated before some of these things are new to me because I’m coming back to Epicor after a few years away. With the help of members here, I am recovering my knowledge of Epicor
I guess I was premature in stating that the problem was solved. It is now coming back with an error
Any ideas what it is I am doing wrong.
I do know for a fact that the EmployeeNum is there and I made sure format it as text in the .CSV file.
“EmployeeName” is not required in a TE Labor Combined DMT so I’d remove that column completely. As a general note, I’d only include the columns you really need to in a DMT.
Thank You. I’ll try that.
Enclose all your field names and data in quotes.
Should look more like this.
Also LaborDtl#Company should be filled in same as the header field
You mean the .csv fields should be in quotes? I am not using a comma delimited file but an Excel .csv file
Yes,
Try doing the upload from a csv file
Here is the .csv file I am trying to load and a screenshot of the DMT and the error I am getting. I formatted the hours as instructed by Epicor.
I am very close, but I don’t know why it is rejecting the Time format.
Try entering your time format like this
“5.00”,“13.00”
This is what DMT looks like when I upload a csv file to my system
Thanks, I just tried that. It looks like that works but I have another issue on Invalid Operation Code that I am going to try and see if I can resolve that.
Epicor is expecting those time columns in hours/hundredths not hours/minutes
Just looked at your import file again. The Operation Code field should contain the code(8 char max) for the operation, looks like you have the operation description in your upload.
Thanks for your help. I think I am getting close to getting this done. I just have to test the fields I need to make sure they are formatted the right way. I have been able to load some files. Now I am adding columns and making sure they are needed and work. You’ve of great help and I appreciate it to you all.
I think I am getting close, but I get
TE Labor Combined 2.csv.CompleteLog.txt (253 Bytes)
TE Labor Combined 2.csv.Errors.Reprocess.csv (503 Bytes)
TE Labor Combined 2.csv.Errors.txt (441 Bytes)
I am trying to find out where I need to go in the database to make sure that the Job Number does exist or not.
Thanks
I did go into [Erp].[LaborDtl] to try and find the Job Number. The Job Number in question was not there. Does it have to be in this table if not, where would it be
One way to find where a field is in the database is to open the screen that you know it exists and then use Field Help. In classic, it’s under the Help menu. In Kinetic, it is enabled at the bottom of the Help icon.
Thanks, I was not very clear on my previous post. The post should have read where else apart from the Labor Detail table might the Job Number be store. I did look in the detail file and I couldn’t find it
