Interview Questions and FAQ For InfoPath

Q. What is InfoPath
A. Office InfoPath 2007 is office Toll that help to design User Interface Form for Submitting and accessing data It can help you efficiently gather information through rich, dynamic forms. The information collected can easily be reused throughout organizations and across business processes because Office InfoPath 2007 supports industry-standard XML using any customer-defined schema. Office InfoPath 2007 customers who share information across their organizations and business processes can have greater business impact. Processed
Q. What does Office InfoPath 2007 provide?
A. Office InfoPath 2007 provides you with an easy and efficient way to create rich, flexible forms. In addition, Office InfoPath 2007 provides a user-friendly interface for entering information into these forms and automatically updates the data in XML format. Ready-to-use sample forms in Office InfoPath 2007 provide templates for common usage scenarios. Extend the power of Office InfoPath 2007 to browser-based environments by integrating it with Microsoft Office Forms Services. Q.Who is Office nfoPath 2007 designed for?
Office InfoPath 2007 was developed for teams and organizations that need to collect and use information. Office InfoPath 2007 is valuable to any business, IT professional, or organization that needs an efficient and flexible way to collect information that can be standardized, validated, and integrated with an organization’s server systems.

• Take advantage of existing IT investments and knowledge to ease deployment costs.

What are some of the typical ways teams and organizations might use Office InfoPath 2007?

A. Office InfoPath 2007 can be applied to many different scenarios, either within organizations and workgroups, or across suppliers and partners. Using Office InfoPath 2007:

• A division manager can design and implement a performance appraisal system.

• A company can implement a timecard or expense reporting system.

• A health insurance company can create and implement its forms, and then integrate them into its database system and with the business processes of member hospitals.

• A team or workgroup can submit weekly status reports.

Pricing and Ordering

Q. How much does Office InfoPath 2007 cost?
A. Find pricing and licensing information on the 2007 Microsoft Office System Pricing page.

Will Office InfoPath 2007 be included with the 2007 Microsoft Office release?
A. Yes. Office Infopath 2007 comes with EnterPrise Edition of Microsoft Office, Find packaging information on the 2007 Microsoft Office Packaging page.

. How does Office InfoPath 2007 fit in with other Microsoft Office system programs?
A. The Microsoft Office system provides customers with a set of programs that they can choose from to best address their business needs. Office InfoPath 2007 can be used as the interface to help gather information more effectively. Microsoft Office Excel 2007 is a spreadsheet program that can help you analyze numerical data. Microsoft Office Word 2007 provides word-processing capabilities for documents. Microsoft Office Access 2007 is a database management program for storing information and creating reports. Use Microsoft Office PowerPoint 2007 to graphically present information.

Integration and Compatibility

Q. What are the system requirements for Office InfoPath 2007?
A. See the system requirements for Office InfoPath 2007.
Q. How does Office InfoPath 2007 work with existing servers and databases?
A. Office InfoPath 2007 works with any XML-enabled database or server by providing support for Web services and database interoperability.
Q. What is XML and what does it have to do with Office InfoPath 2007?
A. XML is an open, industry-standard language for organizing and storing data. Having data in XML means that the information is transportable and can be easily shared and reused.The default file format for Office InfoPath 2007 is XML, and InfoPath 2007 supports any customer-defined schema, which means that information gathered using InfoPath forms more easily integrates with server systems. Using Office InfoPath 2007 to gather information can improve the flow of information throughout the organization. Office InfoPath 2007 is a great example of how Microsoft Office system programs take advantage of XML technology to help people, teams, and organizations manage and use information more productively.
Q. How does Office InfoPath 2007 relate to Microsoft .NET connection software?
A. Microsoft .NET is a set of software technologies for connecting people, systems, information, and devices. It is built on a foundation of XML Web services, so that new and existing applications can connect with software and services across operating systems, programs, and programming languages. Office InfoPath 2007 works well as a client for Web services because it was built to work with XML and can help customers connect information with business processes and solutions.
Q. What are the advantages of having Office InfoPath 2007 as a rich client application?
A. Office InfoPath 2007 provides powerful functionality such as business logic validation, rich text formatting, AutoCorrect, and spelling checker.

What are browser-compatible forms?

Browser-Compatible forms are open in Browser, there is no need of InfoPath Installed on Client machine if your InfoPath form is designed as Browser Compatible design InfoPath 2007 introduced the possibility to fill out InfoPath forms by using a browser such as Internet Explorer, Firefox, Netscape, or Safari. These types of forms are called InfoPath 2007 browser-compatible forms. For a complete list of browsers that can be used to fill out InfoPath form.

Can I use browser-compatible forms without installing Microsoft Office SharePoint Server 2007 (MOSS)?

Yes, you can, but you will have to install Forms Server to be able to run browser-compatible forms. On your SharePoint site, there must be feature Office Publishing Infrastructure activated.

What is Forms Server?

Forms Server is the extracted version of Forms Services that comes with Microsoft Office SharePoint Server 2007 (MOSS). It is sold and can be used separately from MOSS to run and fill out InfoPath 2007 browser-compatible forms.

How do I make InfoPath 2007 forms compatible with InfoPath 2003?

Open the form template that you want to save in InfoPath 2003 format.

On the File menu, click Save As.

In the Save as type list, click InfoPath 2003 Form Template.

Click Save.

In C# code:

XPathNavigator nav = MainDataSource.CreateNavigator(); // xPathNavigator is Class is used to walk in DataSource of your Infopath Form

string fieldValue = nav.SelectSingleNode(“//my:field1”, NamespaceManager).Value; // Here “//my:field1” is the XPath of your Field in Infopath Form you can get by Tool Pane – DataSource , select Field, RightClick and Choose CopyXPath.

In VB.NET code:

Dim nav As XPathNavigator = MainDataSource.CreateNavigator()

Dim fieldValue As String = nav.SelectSingleNode(“//my:field1”, NamespaceManager).Value

How do I set the value of an InfoPath field through code?

In C# code:

XPathNavigator nav = MainDataSource.CreateNavigator();

nav.SelectSingleNode(“//my:field1”, NamespaceManager).SetValue(“myValue”);

In VB.NET code:

Dim nav As XPathNavigator = MainDataSource.CreateNavigator()

nav.SelectSingleNode(“//my:field1”, NamespaceManager).SetValue(“myValue”)

How do I call a web service through code?

In C# code:

First we need to create the Connection with Given web Service then we write the following Code here I take the example of HelloWorld Name of our DataConnection with our Given webService.

// Create an XPathNavigator object to navigate the secondary data source of the web service

XPathNavigator nav = DataSources[“HelloWorld”].CreateNavigator();

// Set the value of the parameter to pass to the web service

nav.SelectSingleNode(“//dfs:queryFields/tns:HelloWorld/tns:name”, NamespaceManager).SetValue(“myValue”);

// Call the web service

DataSources[“HelloWorld”].QueryConnection.Execute();

// Retrieve the results returned by the web service

string results = nav.SelectSingleNode(“//dfs:dataFields/tns:HelloWorldResponse/tns:HelloWorldResult”, NamespaceManager).Value;

where HelloWorld is the name of a data connection to a web service.

In VB.NET code:

‘ Create an XPathNavigator object to navigate the data source of the web service

Dim nav As XPathNavigator = DataSources(“HelloWorld”).CreateNavigator()

‘ Set the value of the parameter to pass to the web service

nav.SelectSingleNode(“//dfs:queryFields/tns:HelloWorld/tns:name”, NamespaceManager).SetValue(“myValue”)

‘ Call the web service

DataSources(“HelloWorld”).QueryConnection.Execute()

‘ Retrieve the results returned by the web service

Dim results As String = nav.SelectSingleNode(“//dfs:dataFields/tns:HelloWorldResponse/tns:HelloWorldResult”, NamespaceManager).Value

Where HelloWorld is the name of a data connection to a web service.

Date and time basics in Microsoft Office InfoPath

Problem with date Field in InfoPath Form

You want to filter data on the current month, display the date in a way that is not available in Microsoft Office InfoPath, or perform calculations with dates.

Solution

Use the fact that Microsoft Office InfoPath represents dates and times internally as YYYY-MM-DDThh:mm:ss to be able to filter, display, and perform calculations with dates and times within InfoPath.

Discussion

InfoPath comes with 3 date/time data types:

1. Date (date)

2. Time (time)

3. Date and Time (dateTime)

The following table lists the corresponding internal representations InfoPath uses for each data type:

Data Type Internal InfoPath Representation

Date (date) YYYY-MM-DD

Time (time) hh:mm:ss

Date and Time (dateTime) YYYY-MM-DDThh:mm:ss

InfoPath uses the format you set on a date/time field through the Properties dialog box of the field and the Format… button to display dates and times. InfoPath will show dates/times in any way you have indicated, like e.g. 9:46 P.M., 21:46, 2/19/2006, or 19-02-2006. Keep in mind that this is only a visual display. When InfoPath performs validation on date and time fields, it still uses its own internal date and time representations.

This is important to know when you want to write date and time values to fields using code. If for example you set a field’s data type to Date (date) and you write 2006-02-19T13:00:23 to the field through code, you will get the following validation error:

To correct this error, change the field’s data type to Date (date) and write 2006-02-19 to the field, or change the field’s data type to Date and Time (dateTime) and write 2006-02-19T13:00:23 to the

About Krishana Kumar

Krishana Kumar is SharePoint Architect/Trainer having Architecture experience with high volumes at Enterprise level and global scale - creation of highly scalable solutions with global user base and geographically distributed architectural components. Good knowledge of SharePoint best practices and governance models. I hold Two Master degree in Computer Science with over 11 years of experience working on Microsoft Technologies specially SharePoint, Project, .NET and other Information Worker Technologies. Having good exposer in Client side scripting Angular.js, backbone and Node. I am currently responsible for SharePoint Infrastructure set up and leading teams in various medium and large scale projects, architecting, designing & installing SharePoint farms, developing custom components,, and providing advanced SharePoint administration and development training to teams and customers. I regularly speaks in various SharePoint User Groups and other Events. I have MCSA Windows Azure, MCSA Office 365, MCSE & MCSD SharePoint 2013, Microsoft Certified Developer (MCD) and holds MCPD, MCTIP and MCTS for SharePoint 2010, MCTS MOSS 2007 & WSS 3.0, MCPD, MCITP (EPM 2010 & 2007) and MCSD .NET.
This entry was posted in General Interest. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *