Error With "title" Argument and Lookup Field

Nov 28, 2016 at 8:31 PM
Hello,

I am running DIFS to test migrating files and metadata to SharePoint Online and am receiving the following error in the log file:

SPImportHelper Information: 0 : Exception message: The 'title' argument cannot be null.
Parameter name: title : Inner exception : Stack Trace at Microsoft.SharePoint.Client.ListCollection.GetByTitle(String title)
at SPImportHelper.Helper.MetaDataHelper.GetIDfor_Lookup(ClientContext secondaryclientcontext, ImportMapping_Lookup importmapping, String SourceFieldValue)
at SPImportHelper.Import.SharePointDestination.SetListItemField(ImportMapping_Lookup importmapping, DataRow datarow, Field destinationfield)
at SPImportHelper.Import.SharePointDestination.SetListItemField(Object importmapping, DataRow datarow)
at SPImportHelper.Import.SharePointDestination.DataRow_SetMetaData(DataRow datarow)
SPImportHelper Information: 0 : Source Column - Vendor Name : Destintation Field - LU_VendorName : Source Value : Ibm Corporation

I receive this error on two separate tenants when trying to write to a lookup field. Other metadata types (e.g. Invoice Number) are set correctly.

The job config (username and password redacted) is below for reference.

Thanks!
<?xml version="1.0" encoding="utf-8"?>
<DataSetImportSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Source>
    <SourceDataSetType>OLEDbSelect</SourceDataSetType>
    <OleDbSourceDataSetSettings>
      <ConnectionString>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\AP Invoices Test RA.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=0";</ConnectionString>
    </OleDbSourceDataSetSettings>
    <OleDbTableSourceDataSetSettings />
    <OleDbSelectSourceDataSetSettings>
      <SelectStatement>select * from [files$]</SelectStatement>
    </OleDbSelectSourceDataSetSettings>
    <ODBCSourceDataSetSettings />
    <ODBCSelectSourceDataSetSettings />
    <FileSystemFilesDataSetSettings />
  </Source>
  <Destination>
    <AuthenticationSettings>
      <AuthenticationType>Office365</AuthenticationType>
      <domain />
      <username>***************************</username>
      <encryptedpassed>***********************</encryptedpassed>
    </AuthenticationSettings>
    <DestinationItemSettings>
      <DestinationItemType>Document</DestinationItemType>
      <ItemExistsBehaviour>Overwrite</ItemExistsBehaviour>
      <ImportMappings>
        <ImportMapping xsi:type="ImportMapping_String">
          <DestinationField>Title</DestinationField>
          <SourceColumn>Title</SourceColumn>
        </ImportMapping>
        <ImportMapping xsi:type="ImportMapping_String">
          <DestinationField>InvoiceNumber</DestinationField>
          <SourceColumn>Invoice Number</SourceColumn>
        </ImportMapping>
        <ImportMapping xsi:type="ImportMapping_Lookup">
          <DestinationField>LU_VendorName</DestinationField>
          <SourceColumn>Vendor Name</SourceColumn>
        </ImportMapping>
      </ImportMappings>
    </DestinationItemSettings>
    <DestinationListSettings>
      <DestinationWebUrlRelative>/sites/rajeffreys</DestinationWebUrlRelative>
      <DestinationFolderUrlRelative>/sites/rajeffreys/Lists/ConnectPoint Invoices</DestinationFolderUrlRelative>
      <DestinationServerUrl>https://netatwork212.sharepoint.com</DestinationServerUrl>
      <DestinationListName>ConnectPoint Invoices</DestinationListName>
    </DestinationListSettings>
    <DestinationExecutionSettings>
      <PerItemImportThrottle>0</PerItemImportThrottle>
    </DestinationExecutionSettings>
    <SourceColumns>
      <SourceFileNameAndPath>FullName</SourceFileNameAndPath>
      <ContentType>ContentType</ContentType>
      <DestinationSubFolder>DestinationSubDirectories</DestinationSubFolder>
      <DestinationFileName>DestinationFileName</DestinationFileName>
      <Publish>Publish</Publish>
      <CheckInComment>CheckInComment</CheckInComment>
      <PublishComment>PublishComment</PublishComment>
      <PageLayoutASPXName>PageLayoutASPXName</PageLayoutASPXName>
    </SourceColumns>
  </Destination>
</DataSetImportSettings>
Nov 28, 2016 at 8:39 PM
Check out section 6.2.3 in the manual, your lookup field mapping is missing a load of settings there is and example in that section
Nov 29, 2016 at 1:05 PM
Hello,

You will be shocked and amazed: when the correct settings are applied, it actually worked.

On another note, version 2.6 has fixed the issue that I was having with writing to the log file. Not sure if that was included in the release, or perhaps the uninstall/reinstall did the trick.

Thanks!
Marked as answer by MadAboutImport on 11/29/2016 at 5:56 AM