Invalid look-up value error message when trying to upload Visio or other files to SharePoint

Posted: May 26, 2015 | Author: | Filed under: 2010, 2013, ECM, Metadata, SharePoint | Tags: , | Leave a comment

Ran into an issue the other day. A user was getting an error message when he tried to upload some Visio diagrams.

SharePoint error message

The strange thing was some of the Visio diagrams uploaded to the SharePoint Online site without any issues.

After searching the internet for the error message I ran across Vaikun Rajanihanth’s post from 2012 Invalid lookup value. The author correctly identifies the issue as the file was down loaded from another SharePoint site before the user tried to upload it to the current SharePoint site. The file still maintained the metadata from the first SharePoint site which caused the conflict while uploading the file to its new SharePoint location. The author details how to resolve the issue for a Word file, but the solution could not be applied to the Visio diagram because “Check for Issues” does not appear in the Info or Backstage view of the Visio file.

To remove the prior SharePoint metadata from the Visio file take the following steps…

  1. Right click on the file name and select Properties from the drop-down menu.
    Right Click on File
  2. In the Properties widow, click the Custom tab.
  3. If there are no values in the Properties field, this is not the fix you need.
    InvalidLookup3
  4. If you do see values in the Properties field, you are on the right path.
    InvalidLookup4
  5. To remove the Properties, select the first Property and then click Remove.
    InvalidLookup5
  6. Repeat this process until all Properties are removed.
  7. Click OK.
    InvalidLookup6
  8. You may now upload the file to your new SharePoint location without any issues.

ECM is Going Social in SharePoint and Beyond

Posted: March 4, 2014 | Author: | Filed under: ECM | Tags: , , | Leave a comment

Female human head shape with social media icons design EPS10 filDocuments aren’t the only thing in an organization that need to be managed to mitigate risk and increase employee efficiencies. Videos, meeting recordings, blog posts, microblogs and activity feeds are all part of your enterprise content.

These frequently missed file types have now earned a place in your file plan and retention policies.

When a judge want to see all the information pertaining to a case, he or she isn’t interested in the easy to find documents, he or she wants all the INFORMATION your organization has retained regarding the issue at hand.

“Sorry, we don’t have a way to get that information to you” is not a viable excuse.

Writing a check for huge fines doesn’t make anyone happy.

My favorite quote from the KnowlegeLake User Conference on March 2nd, 2014 was from Pamela Doyle, Director or Fujitsu Computer Products of America, “Not managing your content is like driving a car 85 miles per hour in a school zone because you can pay the ticket. Obviously you haven’t considered any of the other possible ramifications”