Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

currently I'm trying to copy from one list to another. However I have an issue in that the field names are different and can't really change without causing more headaches (example: First Name is FName on the other list) . I'm wondering what have people done to move list items when this is the case. I could always resort to a custom development script but was hoping to avoid this.

One theory I had and wondered if anyone tried is something of a "junction table" that would have 2 fields such as First Name and Fname with Fname being a lookup to First Name. Then do a multi-step copy in the workflow, does this work? Thanks!

This is using MOSS 2007 with SharePoint Designer workflows.

share|improve this question
add comment

3 Answers 3

up vote 2 down vote accepted

Unfortunately I don't think you're going to be able to get around this without script since the column names are different. Sorry it wasn't the answer you were looking for.

share|improve this answer
    
after some research, me neither :-/ –  tekiegreg Aug 18 '10 at 11:28
add comment

You can go to the list you want to copy the items from, and then select:

Actions, Export to Spreadsheet.

This will then enable you to save this data to a file called: owssvr.iqy

You then open this file with Microsoft Excel, and then select (highlight) the data that you want to export into your other list, and copy. [Do not copy the data underneath the columns 'Item Type' and 'Path'.]

Leave Excel open for the moment. Now you can go your your other list, and select:

Actions, Edit in Datasheet, then Paste your data. Even better if both lists have columns in the same order.

Once done, all you do is select Actions, Show In Standard View. That's it!

Hope that helps.

Regards, Ash

share|improve this answer
    
No, this is using WORKFLOWS, not just copy and paste... –  tekiegreg Aug 17 '10 at 17:56
    
OK, I see. Sorry, my fault for not realising. –  Ashok Jingar Aug 17 '10 at 20:26
add comment

Instead of the "Copy item" action in SPD workflow, use "Create item". This will give you the junction table you're looking for.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.