Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Copy Data from a list to another list

  Asked By: Grace    Date: Nov 25    Category: Sharepoint    Views: 11076

Recently our portal was migrated to a new server. This was done using
the backup/restore facility. We didn't go live with the new server
until we find it is safe and things are working fine. The problem is
there were some new items added to a list in the old server by several
users. So the questions is, is there a way that i can copy the new ly
added items to the new server's list (List and list template is same).
Let me know if i am missing to mention anything.



5 Answers Found

Answer #1    Answered By: Schuyler Le     Answered On: Nov 25

I'd probably set a filter or sort to get the new items  I need to
copy, then use datasheet view to copy  the cells and paste them into
the same list  on the new server  when it is also in datasheet view.
The major thing I've found is that the fields have to be identical
or else you can screw up your records.

I did this yesterday, and I made sure both views were identical,
then switched to "edit in datasheet" and highlighted and copied the
cells I needed. I suppose you could also select the entire rows, but
I didn't do that. I then switched to the new list and clicked inside
the first cell of the last row (the empty one) and pasted. It
plopped everything into the proper place.

Formatting might be an issue for certain types of columns. Mine were
pretty simple ones, so I didn't run into any snags.

Quick note: Something I recently  discovered is that you cannot edit
in datasheet (it becomes read-only) *if* you have content approval
required for the list. I needed to switch this back to off (after
making sure nothing was waiting for approval) so I could use the
edit in datasheet feature.

Answer #2    Answered By: Kristina Cox     Answered On: Nov 25

Alas, while WSS v3 can migrate content, but 2003 required a manual
effort (copy each listitem by hand, move the entire modified list  using
an STP, etc.) or a custom program.

Answer #3    Answered By: Delbert Frederick     Answered On: Nov 25

copying list  items in spreadsheet
is fine. But i guess i missed to mention something. List doesn't
allow me to enter the original user's name in the Created by column
and it says ReadOnly. Think i am violating the security.
Simply saying, we have a bulletin board running in sharepoint and
ppl use to post there items  to the list. Do you guys think that i
can copy  the Created by column and paste it to the new list?
Sharepoint ain't allowing me :D.

return answerpls;

'There is a way, if there is a will'

Answer #4    Answered By: Willard Valenzuela     Answered On: Nov 25

The Created By column is not only ReadOnly, it can't even be manipulated
by the Object Model. There are some third party tools that let you
specify it but I think that they all update the database directly.

Answer #5    Answered By: Damon Garner     Answered On: Nov 25

If you're uploading from the api it's one of the parameters. I rarely
use anythingother than administrator because matching user names isn't that fun,
but it's possible... At least on creation.

Didn't find what you were looking for? Find more on Copy Data from a list to another list Or get search suggestion and latest updates.