Timeline for Compare a csv items with sharepoint list items with PowerShell CSOM
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 14, 2015 at 9:33 | vote | accept | Ram | ||
| Aug 14, 2015 at 9:31 | answer | added | Ram | timeline score: 1 | |
| Aug 14, 2015 at 6:41 | comment | added | Gwny | no I think this is fine so far. now you need the part with comparing your fields and updating them | |
| Aug 14, 2015 at 5:11 | comment | added | Ram | Hello Gwny Thanks !!! I'd done with my task and used this approch to reach the goal. foreach ($row in $csv) { $CSVid = $row.ID [Microsoft.SharePoint.Client.List]$list = $web.Lists.GetByTitle($listName) $items = $list.GetItemById($CSVid) $context.load($items) try { $context.ExecuteQuery(); } catch { $ErrorMessage = $_.Exception.Message } Is it fine or have some another way to do the same ?? | |
| Aug 13, 2015 at 11:28 | comment | added | Gwny | so start scripting then :) | |
| Aug 13, 2015 at 10:58 | comment | added | Ram | I have to compare the csv item with the SP list-item and then if the csv item does not available in the list then need to add that item to list and if list contains more items than the CSV items then need to delete SP list-items. If some changes are thre then need to update the List-item. | |
| Aug 13, 2015 at 8:20 | answer | added | Gwny | timeline score: 2 | |
| Aug 13, 2015 at 8:13 | comment | added | Gwny | what is your question? what did you try so far? | |
| Aug 13, 2015 at 7:31 | history | asked | Ram | CC BY-SA 3.0 |