MOSS | @SPJeff

Drag and drop .XML files to Excel 2007

July 7, 2009 in Uncategorized

Working with SharePoint daily I see a great deal of XML data.   System configuration, user data, feature definition, list schema, usage, etc.     SharePoint is a product that lives and breathes in XML format for nearly everything.

I personally find Excel 2007 very handy here.

If you didn’t know it is possible to drag a plain XML file onto a blank workbook and follow the Excel 2007 defaults to view in a grid layout (sample below).   From there it’s …

  1. Easier to read
  2. Simple to filter and sort
  3. Possible to create PivotTables or Charts to identify patterns

Try it out!    Please leave a comment of any XML tricks you find helpful.    Anybody work a lot with XML in SQL 2005 or InfoPath forms?

 

image

image 

image

Import XML data (http://office.microsoft.com/en-us/excel/HP102064051033.aspx)

 

.

Event Error 5553 – failure trying to synch site”??” for ContentDB “??” WebApp “??”. Exception message was Cannot insert duplicate key row in object ‘dbo.UserMemberships’ with unique index

May 21, 2009 in Uncategorized

I ran into this problem this week after doing several site collection moves.     The resolution is simple, effective, and only take a few minutes.

  1. ststam -o preparetomove –contentdb [SQLServer:DatabaseName] –site [http://sharepoint]
  2. stsadm -o deletecontentdb –url [http://sharepoint] –databasename [database] –databaseserver [SQL sever]
  3. stsadm -o addcontentdb –url [http://sharepoint] –databasename [database] –databaseserver [SQL sever]

The given key was not present in the dictionary.

March 20, 2009 in Uncategorized

If you see this error message in WSS chances are you have an active reference to custom field type but have not installed the field type.     The “/_layouts/mngfield.aspx” page will throw this error in the above scenario.    Two possible resolutions:

 

 

  • Remove the Site Column (SPField) objects with object model code.     Requires developer skills.

 

image

MOSS Wheel

February 1, 2009 in Uncategorized

Microsoft Office SharePoint Server 2007 provides a single, integrated location where employees can efficiently collaborate with team members, find organizational resources, search for experts and corporate information, manage content and workflow, and leverage business insight to make better-informed decisions.

Collaboration Allow teams to work together effectively, collaborate on and publish documents, maintain task lists, implement workflows, and share information through the use of wikis and blogs.

Portals Create a personal MySite portal to share information with others and personalize the user experience and content of an enterprise Web site based on the user’s profile.

Enterprise Search Quickly and easily find people, expertise, and content in business applications.

Enterprise Content Management Create and manage documents, records, and Web content.

Business Process and Forms Create workflows and electronic forms to automate and streamline your business processes.

Business Intelligence Allow information workers to easily access critical business information, analyze and view data, and publish reports to make more informed decisions.

 

http://blogs.technet.com/photos/jocarpenter/images/448050/500x374.aspx

 

NewMOSSPinwheel

Return to Top ▲Return to Top ▲