Microsoft Office SharePoint Server 2007: The Complete Reference in Microsoft Office

Encoder QR Code in Microsoft Office Microsoft Office SharePoint Server 2007: The Complete Reference

WebToCreateListInAllowUnsafeUpdates = true; // Create the list in SharePoint: try { NewListGuid = WebToCreateListInListsAdd("Navigation Page List", "List used to provide Custom Navigation", SPListTemplateTypeGenericList); } catch (Exception UnableToCreateList) { return false; } // // Get an object reference to the new list: try { CreatedList = WebToCreateListInLists[NewListGuid]; } catch (Exception UnableToOpenList) { return false; } // // Add the Link and Appearance Order fields: try { // Rename the title field: SPField TitleField = CreatedListFields["Title"]; TitleFieldDescription = "Title to appear in Navigation"; TitleFieldUpdate(); // Add Link Field: CreatedListFieldsAdd("Link", SPFieldTypeURL, true); SPField LinkField = CreatedListFields["Link"]; LinkFieldDescription = "Relative Link and Tool Tip"; LinkFieldShowInEditForm = true; LinkFieldShowInDisplayForm = true; LinkFieldShowInListSettings = true; LinkFieldShowInViewForms = true; LinkFieldUpdate(); // Add Appearance Order Field: CreatedListFieldsAdd("Appearance Order", SPFieldTypeNumber, true); SPField AppearanceOrderField = CreatedListFields["Appearance Order"]; AppearanceOrderFieldDescription = "Order to display"; AppearanceOrderFieldShowInEditForm = true; AppearanceOrderFieldShowInDisplayForm = true; AppearanceOrderFieldShowInListSettings = true; AppearanceOrderFieldShowInViewForms = true; AppearanceOrderFieldUpdate(); // Add Publish Date Field: CreatedListFieldsAdd("Publish Date", SPFieldTypeDateTime, false); SPFieldDateTime PublishDateF = (SPFieldDateTime)CreatedListFields["Publish Date"]; PublishDateFDescription = "Date to publish (show)"; PublishDateFDefaultValue = "[today]"; PublishDateFDisplayFormat = SPDateTimeFieldFormatTypeDateOnly; PublishDateFShowInEditForm = true; PublishDateFShowInDisplayForm = true;

18:

PublishDateFShowInListSettings = true; PublishDateFShowInViewForms = true; // NOWCRAWL means don t search this field! PublishDateFNoCrawl = true; PublishDateFUpdate(); // Add Stop Publish Date Field: CreatedListFieldsAdd("Stop Publish Date", SPFieldTypeDateTime, false); SPFieldDateTime StopPublishDateF = (SPFieldDateTime)CreatedListFields["Stop Publish Date"]; StopPublishDateFDescription = "Date to remove"; StopPublishDateFDisplayFormat = SPDateTimeFieldFormatTypeDateOnly; StopPublishDateFShowInEditForm = true; StopPublishDateFShowInDisplayForm = true; StopPublishDateFShowInListSettings = true; StopPublishDateFShowInViewForms = true; // NOWCRAWL means don t search this field! StopPublishDateFNoCrawl = true; StopPublishDateFUpdate(); // // Add the Columns (fields) to the default view: SPView DefView = CreatedListDefaultView; DefViewViewFieldsAdd(LinkField); DefViewViewFieldsAdd(AppearanceOrderField); DefViewViewFieldsAdd(PublishDateF); DefViewViewFieldsAdd(StopPublishDateF); DefViewUpdate(); // // Now add an item: SPListItem NewItem = CreatedListItemsAdd(); // NewItem["Title"] = "Home"; NewItem["Link"] = WebToCreateListInServerRelativeUrlToString() + ", " + WebToCreateListInTitle; NewItem["Appearance Order"] = 0; NewItem["Publish Date"] = SystemDateTimeTodayAddDays(-1); NewItem["Stop Publish Date"] = null; NewItemUpdate(); } catch (Exception UnableToCreateFields) { return false; } return true; }

There are many occasions where exporting a document from SharePoint is necessary without using a client-side program like Word A good example of when you might do this is during an external workflow; to send a user the actual file requires creating a disk-based file that can be sent via Outlook Using the SharePoint object model, you can easily access a library

and export a file to disk You simply connect to the library and then extract the binary form of the file as shown The following example does the following: Attaches to a site at URL http://mossspsdev:14584 Opens a document library called Legal Documents Gets the first item in the library (note, this should have error handling as there may not be an item) Saves the actual name of the document Retrieves the file in binary format Writes the file out (using a file stream) to a physical disk file

SPSite AppLvlSite = new SPSite("http://mossspsdev:14584"); SPWeb TopLvlSite = AppLvlSiteOpenWeb(); // Open the Library: SPDocumentLibrary LegalDocLib = TopLvlSiteLists["Legal Documents"]; // Get the first item (by index): SPListItem FirstItem = LegalDocLibItems[0]; // Get the file attached to the item: SPFile TheFile = FirstItemFile; // Save the filename: string OutName = TheFileName; // Get the file in bytes: byte[] binFile = null; binFile = TheFileOpenBinary(); // Save the file to disk: try { // Create a new File Stream and write out the file to C: drive: FileStream OurFileStream = new FileStream(@"C:\" + OutName, FileModeCreateNew); // Create the writer for data: BinaryWriter BinWriter = new BinaryWriter(OurFileStream); // Write it out: BinWriterWrite(binFile); // Close up: BinWriterClose(); OurFileStreamClose(); } catch (Exception FileStreamOpenExcep) { // Handle error }

Like the object model, SharePoint s Web Services provide access to many standard features in SharePoint in terms of reading data, checking alerts, and so on, and they are very useful when working between two SharePoint sites or SharePoint and an external application Most Web Services (shown in Table 18-1) are available in both WSS and MOSS (MOSS includes services for enterprise features)

18: