Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


invalid Default Values

Posted on 2009-12-18
Medium Priority
Last Modified: 2012-05-08
I created a list by importing it from an excel spreadsheet.

It is a list of contacts. I would like to copy this list I imported to a Contact List but when I copy & paste the data I receive this error:

The rows you modified could not be saved to the server due to validation errors. This is usually caused by inavlid default values.

Can I turn off this data validation?

Is there a better say to get this info into a Contacts Sharepoint list?
Question by:sullisnyc44
  • 2

Expert Comment

ID: 26081758
It can be tricky to get this exactly right, one way that helps is to create some dummy entries in your contacts list, then export it to excel just to make sure that you have the columns in the right order etc. Another thing to check is that you are populating any required fields that are there, you can check which ones are required by going to the contacts list's settings and looking at the list of fields, you can also then set them to be optional. It can also depend on what exactly you have highlighted before you do your paste, sometimes it works if you have the first cell selected, other times you need to select the grey bar just to the left. Finally it can also help to take the 'Attachments' field out of the view you are pasting into, again go to the contacts list's setting and lookat the view you are using, untick any of the fields in it that you will not be pasting data into.


Expert Comment

ID: 26081769
Oh, and you should be able to copy and paste direct from excel without using the intermediate custom list.

LVL 12

Accepted Solution

mccarthybri earned 2000 total points
ID: 26081808
create a contact list in moss using the contact list template.  make sure each column matches your exel spreadsheet.  Then create a datasheet view.

ensure the items from left to right in datasheet view match your spreadsheet left to right, now  copy your speadsheet and then paste it in your your sharepoint list.  you should be good from there.

This seems the quickest to me.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
Loops Section Overview
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

576 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