Copy/Paste

[NB]

I have a column in which i am storing Guid and it is a hidden column.
Problem is that it can be duplicated when user copies and paste the
Tasks. How can i check that paste of task has happened through an event
and how to loop though just the copied task. If anyone can show me how
to do this will be appreciated.

 

[Rod Gill]

Use a formula in a custom field to create your GUID and base it on the
Unique ID field. That way even after pasting, pasted tasks get a new unique
GUID.

 

[NB]

I am storing GUIDS from db in the ms project when first time I generate
project file. So i need to keep those GUIDS so i can update back to db.
Problem occurs when user copies and paste the records and at that point
I get duplicate GUIDS and i want all those guids to be unique. Please
can anyone suggest what can i do to clear the guids for the new rows
copied and pasted OR how to identify the copied and pasted rows (Is
there anyway to differentiate)?

Thanks

NB

 

[Jan De Messemaeker]

Hi,

I'd copy (before save) the UIDs to a number field; whenever that field
contains zero, that is a "pasted" task.

 

[NB]

I am not sure how that would prevent UIDs from not to being duplicated.

Let's say if i copy TaskCol1 to TaskCol2(number)

1 1
2 2
IF i copy and paste i would get same duplicate rows again

TaskCol1 to TaskCol2(number)

1 1
2 2
1 1
2 2

What am i missing here?

NB

 

[Jan De Messemaeker]

UIDs are assigned by Project.
Project assures they are unique

 

[NB]

Perfect!! That worked out fine.

Thank You very much for your help.

NB