InfoPath

baed

Hi,

does anybody know if data can be entered (imported) into Navision 4.0 via Office InfoPath forms (XML)?

Regards,
David

Hushdontspamme

Hi

Any anyone had much luck with this? I am not sure how this would work with work flow fields. What do i need to do to start using Nav and Infopaths?


I would like to do a PO form and submit it to be approved. I would like to use the Infopath form on Sharepoint services to extend on the EP webparts.

Many Thanks

HalMdy

I don't have a lot of information and experience with that but you have to know that the new Employee Portal available with SP1 is based on SharePoint and propose Standard WebParts for Navision...

Savatage

HalMdy wrote:

I don't have a lot of information and experience with that but you have to know that the new Employee Portal available with SP1 is based on SharePoint and propose Standard WebParts for Navision...

See how to create Web parts for Employee Portal.
http://www.microsoft.com/businesssoluti ... aunch.html


Quote From "Jeremy's World of Microsoft Dynamics and other things..."

There are many ways that we can create Self Service solutions. One of the ways of giving employees access to Microsoft Business Solutions – Navision is to use the Employee Portal that shipped with Service Pack 1. The Employee Portal is an intranet solution implemented as a set of Web Parts for Microsoft SharePoint Portal Server / Microsoft Windows SharePoint Services which allows data stored within Navision to be delivered via a browser.

One of the little discovered gems of the Microsoft Office System is Microsoft Office InfoPath 2003 which allows you to create rich, dynamic forms which can be linked to data sources such as Navision. Because InfoPath natively persists the data input into the form as XML it can easily update Navision.

More about this topic soon..

http://blogs.msdn.com/jpalmer/

girish.joshi

I've started trying to do this. So far this is where I've gotten;

I've setup Navision as a data source, and been able to hook into its tables from Infopath. The problem about using this form for data entry is that fairly standard: You don't get any of the business logic for validating fields (you do get field type validation), and you also don't get any of the lookup functionality.

I see there being two approaches, three if you consider a hybrid solution. 1. You can reimplement the business logic. And then have the InfoPath forms update the Navision tables directly from the backend. This has some pretty obvious drawbacks.

2. You can determine the fundamental fields. Put some logic into Navision to determine which fields come through. Write a routine that can parse the Infonet xml documents and load them into Navision tables.

Will keep you posted....

girish.joshi

I have this working now.

Submitting data directly into Navision still has the problems listed above.

However, its fairly easy to use a codeunit and Micrsofts XML DOM to parse the XML that a submitted InfoPath form creates.

I'd say that this fufills the promise of submitting data to Navision.

Also, its very easy to have Infopath drop down boxes and such populated with Navision, and only slighlty more complicated to have fields default in from the values that are selected from those drop downs. If requested, I'll put some more detailed instructions about how to do this here.

DenSter

You could submit the values from the form and wait for an answer from Navision with message queues. I wouldnt know how to do that with InfoPath though, never worked with it.

girish.joshi

Yeah -- that's a good idea Denster. I'll see if I can work it into my solution in a sensible way.