NAV Integration with Student Portal

chandrurec

Hi All,

I need to integrate the navision with a student portal. The client can able to provide the student information in csv file and this file needs to be imported into navision in customer card. Can anyone tell me how we can perform integration to import the csv periodically from the file into navision.

If anyone already come across this kind of integration , kindly share the steps involved in doing this kind of integration.

Thanks in advance.

Regards,
chandru

Luc_VanDyck

Importing csv-files into NAV is common practice and not rocket-science. Read this section on msdn for more info: Creating XMLports
XMLPorts can be scheduled using the Job Queue module, to be executed automatically through the NAS (NAV Application Server).

chandrurec

Hi Luc,

Is it possible to create dataport to import the csv files and call this dataport from codeunit. After doing this, we can tag the codeunit to run in th job queue. is this method applicable or we need to compulsorily use xml ports for importing the csv files into nav.

Thanks & Regards,
chandru.

Luc_VanDyck

Dataports cannot be executed through NAS, not even when they are called from a codeunit.

chandrurec

Hi Luc,

But for running Job scheduler, we dont want to configure NAS . Am I correct. IF thats the case , we can use the dataport.

Thanks & Regards,
chandru.

Luc_VanDyck

And how are you going to execute the Job Scheduler? Right, through the NAS.

chandrurec

Hi Luc,

Yes job scheduler run thorugh the nas but we dont need to configire nas am i correct.

The another question is how to update the records using xml port.

Thanks & Regards,
chandru.

Luc_VanDyck

Don't know what you mean by "configure nas".

And one question per topic please.

chandrurec

Hi Luc,

Configuring means I am telling we need to open the navision application console and there we need to mention the company name db name etc and then start the service. This step we dont need to do am i correct?

Thanks & Regards,
chandru.

Luc_VanDyck

If a NAS is already installed with the JOBQUEUE parameter, then you don't. Otherwise you need to install NAS and configure the Windows Service through Management Console.

chandrurec

Hi Luc,

Got it. Thank you.

Regards,
chandru.