Data Connections

Re: XML Support Files

brandtsmith — Fri, 14 Nov 2008 19:15:41 GMT

Thanks...I actually found out that my support file would not be picked up as document properties in Word...so-I went back and added all of those fields to the SharePoint content type and rebuilt the IP form...kind of had the same problem though with the date fields...here is a real gotcha-the Sharepoint date field comes across as simpleType...but allows dateTime formatting..but the value would not format...the value from the SharePoint list was like "11-15-2008 00:00:00"...hmmm...I tried picking off the first 10 chars...still no formatting (you got to have some formatting to use date in a Word doc!)...OK...last resort...I saw a reference that XML datetime strings need to have a "T" in between date and time...so I stuffed a "T" in there ("11-15-2008T00:00:00") and it worked!!!

Now the SharePoint List dates can be formatted in IP and used in the DIP! Here is the xpath from the Rule: (Pulling date for a Provider from a secondary ds named Provider Contacts into my Document Properties from the Content Type))

concat(substring(xdXDocument:GetDOM("Provider Contacts")/dfs:myFields/dfs:dataFields/dfs:Provider_Contacts/@Accreditation_Date[../@ID = xdXDocument:get-DOM()/pr:properties/p:properties/documentManagement/ns2:Provider], 1, 10), "T00:00:00")

Re: XML Support Files

Shiva — Thu, 13 Nov 2008 16:11:25 GMT

Hello,

Do want to restrict the data time field data type in xml then you have to change in .xsd as below,

<xsd:simpleType name="dateTime" id="dateTime">

<xsd:restriction base="xsd:dateTime">

<xsd:whiteSpace value="collapse" fixed="true"/>

</xsd:restriction>

</xsd:simpleType>

XML Support Files

brandtsmith — Thu, 13 Nov 2008 14:47:51 GMT

I've used xml suport files a few times...but always with the simple data type ...basically strings...now I am trying to map a Sharepoint Contact list Date field (Secondary DS) into my external XML support files (Resource)...question is how to format the xml fle to allow me to use the formatting features of the DateTime fields?

<?xml version="1.0" encoding="UTF-8"?>
<Support>
<LastName/>
<FirstName/>
<FullName/>
<EMailAddress/>
<Company/>
<JobTitle/>
<BusinessPhone/>
<FaxNumber/>
<Address/>
<City/>
<StateProvince/>
<ZipPostalCode/>
<AcreditationType/>
<AccreditationDate/> how to make this field a DateTime field in InfoPath???????????????????????????????
</Support>