Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Nasty error message on Office 2010 saving to SharePoint Foundation 2010

Posted on 2011-02-24
6
Medium Priority
?
2,684 Views
Last Modified: 2012-05-11
Folks:

I have a newly-installed SharePoint 2010 Foundation (as in "FREE") server running.  I have created a test document library and added a couple of columns as mandatory fields.  I can upload files from the actual SharePoint site in my browser, and it prompts me very nicely to add the information for the metadata columns including the mandatory ones.

When I generate a PDF in a product called Nuance PDF Converter and choose its save to SharePoint function, it also nicely prompts me to put in the column info and everything is hunky-dory.

And then there's Microsoft Office.

Ahem.

When I create a document from within a Microsoft Office 2010 app using "File, New" and then choose "File, Save & Send, Save to Sharepoint", browsing to my new document library....I get a very nasty error message across the screen with a big red "X".....and the text:

The file cannot be saved because some properties are missing or invalid.

Use the Document Information Panel to provide the correct property values.  Errors for required properties are marked with a red asterisk, and errors for invalid properties are marked with a red dashed border.

There is a button to go to the Document Information Panel and fix the data but this is a really nasty error message.  I find it ironic that as much as Microsoft touts Office-to-SharePoint integration a third-party app from Nuance does this so much better.

I have read a few articles that suggest changing the characteristics of the content type, in this case the default "Document" content type, to always display the DIP (aptly named IMHO) on save of new documents which is supposed to fix this but of course SharePoint Foundation does not include this, at least not in the GUI.

Is there a way to make this work a lot better than the nasty-looking error message?  I'd be embarassed to roll this out to my users the way it looks now. Error message given in Word 2010 when saving a new file to a SharePoint library with required columns
0
Comment
Question by:CeleritasPrime
  • 4
  • 2
6 Comments
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 34979679
This means you have some required fields that need to be set prior to Check in

So  you will need to hit that (Go to Document Information Panel ) and update the required fields

the best way to do that is to use the server options from the Office Ribbon.


Best of luck .

0
 
LVL 1

Author Comment

by:CeleritasPrime
ID: 34980542
I know what it means (I created the library and made the columns mandatory), and those fields do not appear in the DIP.  Remember, this is a newly-created file and so Word has no way of associating it with the fields in the SharePoint library.  

Also, what do you mean by "Server Options from the Office Ribbon"?
0
 
LVL 1

Author Comment

by:CeleritasPrime
ID: 34980574
What I am looking for is a way to convince Office to display the DIP and prompt/allow the user to fill in the required fields as a smooth part of the save process rather than have them faced with an error message.  Like I mentioned, the Nuance product does this nicely.  I have found reference to how to change the content type to always display the DIP on the save of a new item, but this option is not available in SharePoint foundation.  My guess is that I will need to manually edit some XML files for the content types on each site collection to make this happen.  Any help?
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 14

Accepted Solution

by:
GeorgeGergues earned 2000 total points
ID: 34981108


I don't think there is a way , to know the required fields before you connect to the site first time ,.
the product you  mentioned actually connects to the site first to get the required columns.

Here are the settings for the DIP
Word options  - > Advanced   - > General  ->  Service Options - >  Document Management Pane

I am sure you can have a Registery change to make that happen but I would not go that far

I am interested to know how this will work.

Best of luck.
0
 
LVL 1

Author Comment

by:CeleritasPrime
ID: 35060771
George:

I know there is no way to know the required fields but it would be nice if the DIP popped up to request user input rather than the nasty-looking error message.  Third-party products seem to do this just fine, it's only Office, ironically enough.
0
 
LVL 1

Author Closing Comment

by:CeleritasPrime
ID: 35060790
There is no solution to this, unfortunately.  Just really bad design on Microsoft's part on the user experience here.  With all of Microsoft's touting of Office integration with SharePoint this is pretty inexcusable on their part.  Thanks, George, for trying to help, though.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question