AnsweredAssumed Answered

Migration: trying to join up a list and a library so list values in columns pass to library columns

Question asked by darrel.richardson@manchester.ac.uk on Jul 4, 2015
Latest reply on Jul 16, 2015 by darrel.richardson@manchester.ac.uk

I'm doing some migration work at the moment and I'm sure I'd going about it the long way and manual way.

We've Nintex and I expect it can solve my problem and I'd like to ask the community.

 

Within the same site collection I have a list and a library.

 

The list has

 

Title | value1 | value2 | value3 | value4 .... value15

 

The library has a document set with only a name and 15 blank columns

 

Name | Title | value1 | value2 | value3 | value4 .... value15

 

In the majority of cases each list item has a corresponding folder of the same name. So the list has item 123 and the library has document set 123. It is possible that the list has 456 but the library doesn't.

 

Each document set that exists already contains content but it's missing it's values from the list.

 

So... how do I get Nintex to query the list and if there's a document set of the same name to update the blank columns with the values?

It also needs to create a document set if one doesn't already exist and again update the blank columns.

 

Presently I've one list with ~300 items in it and a library with ~170 document sets all missing data. That gives me the challenge of 170 doc sets to update and 130 to create.

 

Thanks

Outcomes