Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / July 2004

Tip: Looking for answers? Try searching our database.

xml processing instructions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Papanii - 13 Jul 2004 21:44 GMT
Hi Guys,
          Does anyone know of a tutorial that explains how the PI's in
infopath work? I want to create an infopath form that works with sql/xml
templates and i am having a tough time finding any resources on the subject.

--Papanii
Brian Teutsch [MSFT] - 14 Jul 2004 02:08 GMT
Wow, there's really not that much on the web about this. Fortunately, it's
not hard to understand, so here goes.

This is the start of an InfoPath XML file with the PIs that you should worry
about

<!-- Standard PI for any XML file. InfoPath currently reads only UTF-8
encoding -->
<?xml version="1.0" encoding="UTF-8"?>

<!-- Information about the solution location and version
   solutionVersion in the XML and XSF files must match
   PIVersion - Currently at 1.0.0.0 for all versions of InfoPath
   href - tells InfoPath where to find the form template that edits this
XML. For ease of explanation, I won't talk about the urn attribute
   name - must match between the XSF and the XML. Simply a unique name for
this form
   productVersion - tells what version of InfoPath created this form
<?mso-infoPathSolution solutionVersion="1.0.0.7" PIVersion="1.0.0.0"
href="http://dummy/myForm.xsn"
name="urn:schemas-microsoft-com:office:infopath:ipxbox:-dataFormSolution"
productVersion="11.0.6255" ?>

<!-- mso-application is used by the various Office applications when writing
XML files.
It allows XML to be opened by the correct application when downloaded in a
web browser
or double-clicked in Windows Explorer." -->
<?mso-application progid="InfoPath.Document"?>

Thanks,
Brian

> Hi Guys,
>           Does anyone know of a tutorial that explains how the PI's in
[quoted text clipped - 3 lines]
>
> --Papanii
Papanii Okai - 14 Jul 2004 18:52 GMT
Ok, I think I understand it a bit better, however I still don't know how to
integrate SQL/XML into the whole picture. I have a few xml/sql Templates
that I want to use.

--Papanii

> Wow, there's really not that much on the web about this. Fortunately, it's
> not hard to understand, so here goes.
[quoted text clipped - 36 lines]
>>
>> --Papanii
Brian Teutsch [MSFT] - 14 Jul 2004 19:43 GMT
I'm pretty far from knowledgable about SQL XML Templates...

I think you would create the XSD that you expect the database to conform to.
Then, use that XSD to design the InfoPath form template. Publish it however
you want, probably to an http server or shared directory.

Now, write your template with the PIs below, such that the href points to
the published XSN. When SQL outputs the XML with your PIs, InfoPath should
open. I gueess you're probably streaming the data from an ASP or such.

Brian

> Ok, I think I understand it a bit better, however I still don't know how
> to integrate SQL/XML into the whole picture. I have a few xml/sql
[quoted text clipped - 42 lines]
>>>
>>> --Papanii
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.