Go deep into SharePoint-Batch import data

String batchReturn = web. ProcessBatchData (batch );

<Results> <Result ID = "0" Code = "-2147217900"> <ErrorText> The operation failed because an unexpected error occurred. (Result Code: 0x80040e14) </ErrorText> </Result> </Results>

 

Cause:

When defining the schema. xml file,

For attributes of multi-line text, ColName should be defined as ntext2 rather than nvarchar3.

The correct syntax is as follows:

<Field Type = "Note" DisplayName = "Address" Required = "FALSE" NumLines = "4" RichText = "FALSE" RichTextMode = "Compatible" IsolateStyles = "FALSE" Sortable =" FALSE "Group =" C0370A "ID =" {region} "StaticName =" C0370A_VPPI_Address "Name =" C0370A_VPPI_Address "ColName =" ntext2 "AllowHyperlink =" TRUE "AppendOnly =" FALSE "/>

Cause 2: The ColName of multiple fields has the same name. You should specify different names for different fields.

Correct syntax:

<Field Type = "Text" DisplayName = "First Name" Required = "FALSE" MaxLength = "255" Group = "C0370A" ID = "{region}" StaticName = "C0370A_VPPI_FirstName" name = "C0370A_VPPI_FirstName" mizmization = "" ColName = "nvarchar6"/>
<Field Type = "Text" DisplayName = "Phone Number" Required = "FALSE" MaxLength = "255" Group = "C0370A" ID = "{region}" StaticName = "C0370A_VPPI_PhoneNum" name = "C0370A_VPPI_PhoneNum" mizmization = "" ColName = "nvarchar6"/>

 

Principle Analysis: The ColName attribute defines the ing between a field and its physical storage name. This must be a valid name in the basic database and must be the same name as in the database table. If not specified, the Server generates a column name, which does not conflict with any existing column name and only contains characters allowed by Microsoft SQL Server.

 

Therefore, we recommend that you do not add non-essential attribute settings to reduce unnecessary troubles.