SharePoint Development & Administration + InfoPath

The following article demonstrates how to integrate an InfoPath form with a SharePoint form library, using a centralised template stored in a SharePoint document library and linked to a site Content Type. The form is set up to submit to a SharePoint form library Overview: Set up SharePoint libraries Design the form template Publish form template to SharePoint Content Type Configure the form's primary data connection to submit to the SharePoint library Secondary Data Connections to receive or submit data to a SharePoint list Setting up SharePoint to store the Form template and receive Submitted forms: If InfoPath Form services are available on your SharePoint server, you have the option to store the form template using Central Administration's managed templates list. To make the form available using this method it must uploaded to the Managed Templates List, the activated for the required site collection. In this example I publish the form template to a ...

Problem: Access Denied page when uploading files using SharePoint's multiple file upload interface. No details are displayed when the upload fails except the Access Denied page. In my case, this was not related to permission on the site or document library as the Access Denied page suggests. After uploading one of the files using the single file upload interface, an illegal character message displayed. Once the illegal character was removed, bother the single and multiple file upload interfaces were able to upload the file(s) successfully. For more information about illegal/unsupported characters in SharePoint document libraries see Illegal Characters in SharePoint Document Libraries . If a large number of files are being uploaded or migrated into SharePoint, there may be many with filenames containing illegal characters. File rename utilities allow conditional renaming of files to remove or replace characters and strings. See Bulk File Rename files to remove or replace illegal cha...

The following characters are unsupported / illegal in SharePoint document libraries: & " : * ? # {} % ~ / \ Tab If the file name of a document contains any of the characters above, a message will be displayed noting SharePoint's illegal characters. If using the multiple upload interface, the response will be an Access Denied page. See Access Denied when trying to upload multiple files to a SharePoint Library . For details about bulk file renaming if a large number of files and documents contain illegal characters, see Bulk File Rename files to remove or replace illegal characters - allow upload/migration to SharePoint Document Library .

SharePoint document libraries can not store files if illegal characters exist in the file name ( Illegal Characters in SharePoint (MOSS 2007) ). Migrating/uploading a large number of documents and files to a SharePoint document library can become tedious if you have to rename each file containing illegal characters each time the copy fails (or delayed write error). To save a time and effort when migrating a large number of files, freeware bulk file renaming utilities are available which allow conditional renaming of files in a directory any sub directories. The software I used to bulk rename files to remove unsupported characters prior to migrating to SharePoint was the PFrank File Renamer , written by Peter Frankenberger. PFrank allows a series of conditions and rename actions to be performed on each file in a specified directory and any sub directories to remove or replace characters or strings from filenames. The most common is the "&" (ampersand) character, which I re...