Collaboration, Technology, and New York

The blog for SharePoint, InfoPath, and Designer, along with business and technology insight….. plus a little NYC

You are currently browsing the GP category.

InfoPath…..Times out with large amounts of data.

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.

Add a comment

Business process automation from SharePoint to GP: Workflow, e-forms, budgets..Avoid the BIG PAPER chase webinar this Thursday

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.

Add a comment

Distinguishing Between Dynamics Great Plains Business Portal and Microsoft Office SharePoint Server (MOSS) 2007 Presentation

Add a comment

Web X -Distinguishing Between Dynamics Business Portal and SharePoint Server 2007

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.
Also:

  • 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

2 comments

Microsoft Announces New Package to Extend Microsoft Dynamics ERP Solutions to Microsoft Office Users: Business applications now accessible across a company, connecting people to processes and information for increased business productivity.

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 🙂

Add a comment