cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Nintex Workflow - Parse CSV file in a Document Library and Insert or Update a List Data

Hi Team,

We are getting daily Feed files in CSV format and they get loaded into SharePoitn 2013 Document Library.

We are planning to create a Workflow on Doc Libraty so that the data can be inserted and udpated (if the same data already available in the list).

Ex: Employee Id, First Name, Middle Name, Last Name, Status (Active/InActive) - Data comes in CSV.

 

How can we Update the Data in the list if the same Employee record (by Employee Id) got changed today because of the CSV feed ?

 

https://www.youtube.com/watch?v=GBU4p0gRdOU - Video shows how can we insert new records all the time but it won't talk about how to update the exisiting record.

Labels: (1)
The Nintex Guru demonstrates a simple and effective method of importing CSV data in a SharePoint list. It's a great way to start integrating external data wi...
0 Kudos
Reply
1 Reply
Highlighted
Nintex Newbie

Re: Nintex Workflow - Parse CSV file in a Document Library and Insert or Update a List Data

Instead of creating an item (Video: 5:57), check if an entry in your people list with the employee id already exists. (For example using query list - Employee Id matches - count returned elements)
If the entry exists, update it, if not, create it.

0 Kudos
Reply