Recently I’ve been building a PO Request form in a browser InfoPath, that needs to bring in large amounts of data from Dynamics GP (Great Plains) on to the form. This data includes vendor codes and vendor names. The problems with data connections with SQL is that these kind of error will occur:
Stop running this script? A script on this page is causing Internet Explorer to run slowly. If it continues to run, your computer might become unresponsive.
This is a limitation of the data connections in Infopath. There is because the form is trying to grab 5,000 records at once and there is no way to filter on the records before you bring them back.
I got round this problem by using a 3rd party product :Web Services Solution Pack (WSSP) by Qdabra
Another nice feature of the product is that if you have the need for dynamic lookup, with one value based on another field, then another, it can make these calls to the database.
Also to improve performance
I’m not a huge fan of 3rd party products, but this one looks like the Bamboo Solutions type for InfoPath forms.
Last call: link
With SharePoint and GP you can now simplify and streamline your business process to automate forms and make them “intelligent” by embedding your data and business rules directly into the forms, to provide real-time integration to GP.
Learn how to:Avoid the BIG PAPER chase.
Web x, next week, covering Business Portal and SharePoint
There will be a Q and A session at the end, to ask direct questions to the presenter.
- Brief history of both products
- Technical architecture of SharePoint 2007 and Business Portal
- Appropriate business scenarios for each product
- Why migrate to Microsoft Office SharePoint Server 2007?
- Moving forward
Who Should Attend:
Technology Executives, , Project Management, IT Managers, IT Professionals, Business Executives, Managers, CIO, CTO, Business Managers, Business Decision Maker, Technical Decision Makers, Developers,
Date: Thursday, January 24th
Time: 2:00pm EST
Sign Up Here
Microsoft Press Release
“This new low-cost package is aimed at helping our customers improve the situation they face today, where on average 85 percent of their employees do not have direct access to critical information, such as data on customers, costs, orders, and schedules, contained in their ERP application,”
Now that is a high statistic.
InterDyn is mentioned as well 🙂