Automating Epicor Job Traveller from VS2013

system · February 17, 2015, 11:47am

It turned out that I needed Crystal Report to make this work. Below is the extra code I had to add.

ReportDocument report = new ReportDocument();

report.Load(

@"\\yourUNCPath\EPICOR905\Server\reports\Traveler.rpt");

DataSet reportData = new DataSet();

reportData.ReadXml(rptmDS.Tables[

“SysRptLst”].Rows[0][“FileName”].ToString());

report.SetDataSource(reportData);

PrinterSettings printer = new PrinterSettings();

PageSettings pageSettings = printer.DefaultPageSettings;

report.PrintToPrinter(printer, pageSettings,

false);

system · February 9, 2015, 1:55pm

I am getting the error below when I try to automate the job traveller via VS 2013

[BusinessObjectException: Invalid path "D:\EPICORREPORTS/Reports/SFI_User/Job Traveler76633.XML".]

system · February 9, 2015, 1:58pm

Any reason you would use a local drive instead of mapping to the server? I would change the path to the server locationâ€¦

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 9, 2015 1:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Automating Epicor Job Traveller from VS2013

I am getting the error below when I try to automate the job traveller via VS 2013

[BusinessObjectException: Invalid path "D:\EPICORREPORTS/Reports/SFI_User/Job Traveler76633.XML".]

system · February 9, 2015, 3:10pm

The dataset rptmDS.Table["SysRptLst"].ROws[0]["FileName"] has the value of the file name which is D:\EPICORREPORTS/Reports/SFI_User/Job Traveler76633.XML. So what I will do is get the xml file name and point it to the path. Therefore, it will be:

rptmDS.Table["SysRptLst"].ROws[0]["FileName"] = \\MyPath\EpicorReports\Reports\SFI_User\Job Traveler76633.XML.

Will try this.

Thank you for the reply.

system · February 9, 2015, 5:54pm

Has anyone experienced why the job traveller will not print using Visual Stuido 2013, all though all my BO calls passed?

Cyril

system · February 9, 2015, 7:16pm

Even with your BO's you'll need a running System Agent somewhere for it to work. Do you have that?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â

Quis custodiet ipsos custodes?

On Mon, Feb 9, 2015 at 5:54 PM, cyrilz199@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div>
  
  
  <p></p><p>Has anyone experienced why the job traveller will not print using Visual Stuido 2013, all though all my BO calls passed?</p><p>Â </p><p>Â </p><p>Cyril<br></p><p></p>

</div><span class="ygrps-yiv-1502536653">
 


<div style="color:#fff;min-height:0;"></div>

system · February 10, 2015, 9:41am

I called the System Agent BO and used it the way I saw it on the trace.

SysAgent sa = new SysAgent(epiSession.ConnectionPool);

I could post all my code if you need to see it. Also, incase someone else may want to use it.

system · February 12, 2015, 9:57am

Do, I have to have Crystal Report Run time in Visual Studio for the Job traveller to print from VS2013?

I have done everything right but still don't have any paper coming out.

Also, looking at the system monitor, it says the Job Traveller completed successfully.

All my code compiled an ran and with no bugs.

I will scrap this and find another way to make this work.

WIll post my complete code as a new subject line (maybe someone will make it work for their own project)

Thanks all for all your help in this.

system · February 12, 2015, 10:12am

Canâ€™t speak to the VS parts â€“ thatâ€™s greek to me. ;)

I donâ€™t recall what version (E9 or E10) this was for but both use a CR 2011 based runtime that is installed with the client. So CR 2011 has to be the version reports are developed with. The runtime supplied has some special tweaks for Epicor to look in the /reports/<username> folder for the .xml data file if the report is not totally ODBC based. I was seeing the same â€œran in System Monitor but no report producedâ€ issue when I was using CR 2013 to create reports. I got it to work using a CR 2013 runtime from a free viewer program but that would not have worked with the .xml data files and every time we updated E10 the clients would be back to 2011 runtime. Finally broke down yesterday and ordered CR 2011 Developer - SAP could not get their act together and downgrade from CR 2013 and we were running out of time.

-Todd C.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, February 12, 2015 8:57 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Automating Epicor Job Traveller from VS2013