Import CSV file into SharePoint list
This activity allows importing records from CSV file into SharePoint list.
SharePoint Workflow Designer Phrase
Import CSV file this file url into SharePoint list this list url using default mapping . Delimiter: , Text
Qualified: “. Trigger create event: No.
Parameters
| Parameter | Description |
|---|---|
| this file url | URL for the file containing the document to load. The URL can be either a local file or an HTTP URL (a Web address).; Ex: c:\Task.csv; Ex: http://externalsite.com/Task.csv; Ex: http://sharepoinportal/ Shared%20Documents/CSVTest.csv |
| this list url | Full list url or folder url in the list; Ex: http://mysharepoint/Lists/Tasks; Ex: http://mysharepoint/Lists/Tasks/Folder |
| default mapping | Optional. Defines SharePoint field and CSV column pair. [SharePointFieldName1]=[CsvColumnName1]…[SharePointFieldNameN]=[CsvColumnNameN]; If mapping is empty, the activity will try to copy each CSV column into SharePointfields. If SharePoint field doesn’t exist in the list, the activity will skip the column.; Note:; Use vti_titlte field to update title; Use ModerationInformation.Status field to update content approval status for an item.; Use ModerationInformation.Comment field to update comment that addresses why the item was approved or rejected.; Note:; Use [SharePointFieldName1]=DefaultValue:[DefaultValue] to set default value into SharePoint field. |
| Example:; Ex: copy Title CSV column to Title SharePoint field; Title=Title; Ex: copy Begin Date CSV column to Start Date SharePoint field; Start Date=Begin Date; Ex: set Status SharePoint field to In Progress; Status=DefaultValue:In Progress; Ex: set Start Date SharePoint field to 2010-12-10 12:30:00 Start Date=DefaultValue:2010-12-10T12:30:00; Ex: set Publushed SharePoint field to true; Published=DefaultValue:1 | |
| Delimiter | The delimiter character separating each field:; - ;; - ∙ ,; - Tab; - [Space] |
| Text Qualifier | The quotation character wrapping every field:; - “; - ‘ |