Integrating Office applications with - Part I

Integrating Office applications with - Part I

Posted on May 05, 2009 0 Comments

As a regular reader of this blog, you probably remember we discussed at various occasions the ability to query, update and create Microsoft Office documents, using the DataDirect Integration Suite. But wait... all those examples were based on Microsoft Excel? As you expect, nothing prevents you from querying other formats, like Microsoft Word documents.

As we’ve discussed before, DataDirect XQuery, an integral part of DataDirect Integration Suite, allows to integrate diverse systems, in a simple and declarative way. For example, it also offers the ability to easily access web services.

In this new series we will show how to retrieve your business data from a Microsoft Word documents, and use that information to update your system. We’ll access through its web service interface.

Let’s consider a fairly simple scenario. The sales representatives at your company, compile their reports in Microsoft Word form, when flying home, on the train, wherever. Back in the office, the trip report is processed, and the system updated. No need to manually enter all the data in, no more error-prone copy/paste. Everything is handled through an automated system.

The Microsoft Word document could look as follows.

And after processing, we have the following account information in our system. Note that it does not only include the general account details, but also one or more contacts, and has the trip report attached as a note. In other words, multiple records are inserted and updated. And the process actually behaves conditionally. For example, if the account does not yet exist go through the creation of a new account, but if it exists only the new trip report needs to be added to the account.

In this series we’ll build step by step such solution, sharing concrete and fully functional code.


Marc Van Cappellen

View all posts from Marc Van Cappellen on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.


Comments are disabled in preview mode.

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

Loading animation