I am having a requirement to push Excel data to UD forms through a scheduler.
I Have achieved it through manual customization but the customization cannot be attached to a schedule which we create in system agent.
The one solution I can think of is
Create a BAQ Report.
Add my customization to BAQ Report Print form customization in which I will pull data from excel and create rows in UD.
The thought process here is as soon as the scheduled time is Hit of BAQ Report it will trigger the report (I don’t know if it triggers the customization completely Bit)
Will this be achievable ? OR how can I get the AfterAdapterMethod of SubmitTo Agent method ?
Is it possible to pick data from excel using SQL query and Insert to UD08 through a Stored Procedure and then add it to the Job scheduler?
Have you considered using a DMT upload that is run via powershell and initiated via windows task scheduler? There are good posts on here about how to do that. I like it because DMT is made for uploading the data per spec.
@patel_saif There are lots of post here doing this process with UBAQs or functions. The nice thing about the approach is you can test the ubaq and then schedule it or call it from rest.
I recently did two projects that read a directory and consumed the files based on extension, wrote data to Epicor or dropped anther file and then moved the processed files to another directory in post processing of getlist using standard C# utilities.
You don’t need anything real in the baq. You can just query the company table for a single company to kickoff the process.