importing Sales order and sales orderline!!!???

nara

Hi,
I need som advise for solving that problem/issue.
I did develop a a.NET app that will communicate with Navisio 3.7 by using MSMQ and NAS.
I did managed export of Items/products from Navision, but I have problemwith import of orders and orderlines to Navision, since the navision has not XMLPORt( this was my first idea) so I think that I can make use of DATAPORT, is it a WRONG IDEA?
My idea is that my .NET app delivering a file( XML or TXT) that including Ortders and orderlines and my .NET app can call a codeunit that retrieve this file and this coseunijnt calling the proper DATAPORT to do this import job.
How realistic is this IDEA?
I am not that experienced in NAVISION so may be I am talking CREASY here.

Any help will be appreciated.

nunomaia

That isn’t a so creasy idea.
It’s a common way to solve some problems of import / export

kriki

And to add something : NEVER import data directly into Navision tables from outside Navision. This because you can use the Navision-triggers. At best, you import the data into new tables and then have some codeunit/report/... to import it into the real tables.

Devi

Hai

I am Devi.
For one of our client some of the data from outside application should flow into navision.

Basically purchase orders and sales orders should be imported/exported from/to navision.
I am trying to use xmlports in navision,but this is the first time i am using them.so not so familiar


Can anyone suggest me the bestway to do this and how to do this.

Waiting for reply soon as it is little critical.

Thanks and Regards,
Devi.

DenSter

If you're using NAS and MSMQ already, and don't have XMLPorts, that means you are on an earlier version. You can still use XML docs, you just have to program the parsing yourself. Check out the Biztalk codeunits for examples of how to do that. There's also an example in the download area here on mibuso if I'm not mistaken.

Then the last thing you can do is search for a file called 'devguide.chm', it's somewhere on the product CD. This file has code samples to make NAS work, and IIRC there's also a section about using the XMLDOM automation.

Use the search, because there are MANY postings about this subject from when we didn't have XMLPorts.

Devi

Hi

I am using microsoft nav4.0 sp3 and with sqlserver option .

I am able to use xmlports
but dont know how to do ,can anyone just help me out .

devi.

DenSter

Take a look at the Biztalk codeunits, those use XMLPorts to import and export data. You'll also find plenty of examples if you search the forum.

amadeod

Nara,
one simple approach might be to directly ad-hoc insert-update data on the NAV's SQL tabel level (either on actual or staging tables!) and afterward you just call some codeunit to validate NAV's business logic triggers upon inserted records ...

More serious longterm solution would of course be to use MSMQ & NAS interaction.

Regards,
A.

aboomar

Devi wrote:

Hi

I am using microsoft nav4.0 sp3 and with sqlserver option .

I am able to use xmlports
but dont know how to do ,can anyone just help me out .

devi.

you can use XMLPort 8000 -- Purchase Order but you must create codeuint

to import or export the data from or to XMLPort

use this code in codeunit


IF NOT EXISTS ('Path.xml') THEN
ERROR ('xml document file does not exist');
testfile.OPEN('Path.xml');
testfile.CREATEINSTREAM(filestr);
XMLPORT.IMPORT(8000, filestr);// you can change to export
testfile.CLOSE;
MESSAGE('Done');

//filestr=InStream
//testfile=File

you can use this code to import and export any XMLport i mean if you create new XMLPort