Scheduling Navision Code

Jonathan2708

Hi,

I have a project that involves monitoring a folder for CSV files containing new customers, invoices, credits etc to be imported into Navision. Am I right in saying the Navision Application Server is the way to go for scheduling the code to run the imports? I've never used NAS before so just want to make sure I'm starting on the right track. If so is it used in conjunction with the Job Scheduler?

It's NAV 5.0 SQL by the way.

Thanks,

Jonathan

tinoruijs

You can use the new Job Queue functionality. You will need to setup a NAS for that.

Take a look at the following site for a explanation of Job Queue:
http://blogs.msdn.com/microsoft_dynamics_nav_sustained_engineering/archive/tags/Job+Queue/default.aspx

bbrown

I find NAS a very good tool for this purpose. I've done a number of interfaces using it. Never really bothered with the Job Queue. Just used NAS with a custom codeunit.

libin80

Hey Guys,

I have a simmilar requirement. There is 2 requirements

1. I want to send sales back order report to the customers every day by 7 p.m
2. I have to monitor a folder for CSV files containing new customers, orders, to be imported into Navision .

Please suggest me a solution. I have scheduled the emailing (point 1) using job scheduler with NAS. The NAS runs sucessfully, but the email is not send out. :roll:

Please let me know if you have suggesstion.
Please give me any code if you have written already.

We havn't done anything for point 2. Should I use Job queue or just use NASHandler.

Jonathan, it seems you have done simillar work, were you sucessfull, please provide some information.

Thanks
Libin

libin80

Hi,

By the way, we have NAV 5.0 SP1 australia, NAS 5.0 Sp1, with SQL server 2005, Outlook 2007.

Thanks
Libin D

jlandeen

From my understanding of Job Queue (I've worked with a similar custom one but not the new one in Nav 5.0) I don't think it would be a good candidate for running a folder monitoring application from. Unless its more infrequent monitoring (say once a day). You should be able to just create a Job Entry record with some recurrance settings.

I would think it would be much easier to run a Codeunit with a Timer on a seperate NAS that constantly monitors your folder for files to import. It should be pretty easy & pretty straightforward to build and youd can either use the tables in Navision to access folder & it's contents or you can just use some of the windows dlls.

You have to build the logic to check the folder and carry out the actions of processing the CSV file no matter which architecture you use.

Waldo

The tools are out there ... .

... but I don't want to advertise ... :oops:

Depends on the functionality. I agree with bbrown, this is perfectly possible with a simple NAS-executing-a-codeunit-setup.
Only, in some implementations, you got many companies, many interfaces, ... that it becomes a "sloppy" and expensive business.

libin80

Oh thanks for the information guys. I ll go with the NAS handler then.

Thanks
Libin D