Connection with Microsoft Dynamics NAV (Navision)

[thewolf79]

Hello,

Does anybody know a way to link VirtueMart to Microsoft Dynamics NAV (Navision) ?
I want to be able to upload / update products every night,
and download new orders every 15 minutes or so.

I would prefer to have a direct link to the Navision's SQL database,
but if that's not possible I can work with CSV or XLS files as well....

All help is much appreciated!

Kind regards

EDIT: I'm using VM 2.0.12f and Joomla 2.5.7

[AH]

Just setup the relevant odbc connection

http://dev.mysql.com/downloads/connector/odbc/

You might also consider the web services route

Not sure that Navision lets you update the database, it creates a "copy" for reporting.  BUt of course, I may be completely wrong.  Note that if you have the free version of Navision, you will not be able to move any of the "tempaltes" you have created to any other machine as this is a restriction of the free license.

[thewolf79]

Thank you, Andrew,

I will look into that.

I don't think I will go for the direct approach after all. If I can find a way to automatically import products from a CSV or XLS, and automatically export orders in a CSV or XLS, then I'll have our Navision developer program an automated job to process these.

Is there an import / export plugin for VM that you know of? The import and export section of the VM extension site is empty...

Thank you,

Kind regards

[AH]

Export is easy, just use excel 2010 built in data tools with the relevant mysql/odbc driver connection to the database.
http://office.microsoft.com/en-us/excel-help/overview-of-connecting-to-importing-data-HP010342748.aspx


Import, use csvi improved

http://www.csvimproved.com/

[thewolf79]

That will get me started in the right direction. Thanks again!