It seemed like such an easy task...(automatic sales exports)

Mindie

My client has only 1 inventory item but with a high volume of web sales. They would like to have these sales imported into NAV. Of course, importing sales orders is not a difficult task. The problem I'm running into is finding a way to automatically export sales from a web site.

I have found solutions that fully sync the web page with the NAV database. These solutions are way too expensive and 90% of the functionality would never be used. Also, they require someone to approve each and every sales order. This would require hiring a full time person to do nothing but click approve over and over.

Then I have also found shopping carts that will export the information into .csv but the export has to be done manually. I haven't found any that offer that export to be done automatically.

It's seemed like such a simple task to just get a .csv file with new sales orders exported every few minutes. They just hired a web page developer and he said that he doesn't know how to accomplish it either. Why is it so difficult?

Does anyone know of a simple and inexpensive solution to this problem?

Luc_VanDyck

Let the web developer create a program/script to export new orders to a CSV-file (presuming the website keeps the entered orders in a database), and use Windows Task Scheduler (or Cron when using Linux) to execute this script every X minutes.

rvduuren

Hello Mindie,

So you're looking for a KISS (keep it short and simple) solution

Well i found one..

Solution:
Remote Query MySQL (web db) through a simple xml webservice. (I assume you're web database is MySQL)
Download remotequery.zip here -> http://www.phpclasses.org/browse/package/4000.html

The NAS or Dynamics Clients consumes the webservice periodic (daily).

Dynamics NAV code

---------------------------------------------------------------------
Globals
Http	Automation	'Microsoft XML, v6.0'.XMLHTTP60	
Dom	Automation	'Microsoft XML, v6.0'.DOMDocument
---------------------------------------------------------------------
CREATE(Http);
CREATE(Dom);
Http.open('GET','http://yourewebshop.com/remote_query_server.php?key=mykey',FALSE);
Http.send();
Dom.load(Http.responseStream);
Dom.save('c:\test.xml');
// Now read the xml and do the job..
CLEAR(Http);
CLEAR(Dom);

I tested the NAV and php code, and it worked out of the box
Hope this helpes you..

shri_mi

Hello Rvduuren,

We are also working on a similar integration. Please let me know where do we need to embed the aforementioned Dynamics NAV code in Navision 5.0.

Regards,
Sriram

davmac1

The job queue is the easiest way to run scheduled jobs. It requires NAS and is easy to setup.