Hello all,
So, I have a dashboard with a BAQ.
The dashboard has a tracker view, and an employee will filter the query by Job Number, and we want a csv to be generated on the local C drive with the results.
(They will scan a barcode to fill out the job num, then the query will be refreshed and give only that data).
Any ideas? I’m kinda lost right now.
Sometimes you just have to say no 
C:\ drive is asking for trouble, security issues etc…
Well, we need to export a csv so another application on the same computer can read it. This isn’t data we are worried about security wise.
Does it have to be on the Dashboard, could you use Epicors new BAQRpt Feature, Electronic Compliance instead. The user would then scan the Job # on a mini form and it would execute a BAQ and that BAQ can write to a path?
Well to answer your question, you could add a Customization Layer on the Dashboard and listen for the “RefreshTool” event click (AfterToolClick) (you can find that in the Wizards) and then you can just via basic C# get the Grid Data (DataRows) and using basic # Write to any file.
Don’t forget you can use this for the “Electronic Compliance” reports as well. Build a couple BAQs, map them to XML, JSON or CVS output. Sweet!
It does not have to be a dashboard.
Is the feature available on 10.2.300.12?
That’s a bad idea because it’s going to be the first thing to break as soon as there is a network or local machine change.
Write the file to a network share.
