Existing Folder Behavior

Dec 8, 2016 at 7:42 PM
Hello,

Migrating to an empty library in SharePoint Online. Folder and document structure outline is as follows:

Folder 1
Doc1

Folder 2
Doc2
Doc3

Folder 3
Doc4

Folder 4
Doc5

Folder 5
Doc6

All folders are created, and all documents are migrated except Doc3 (the second doc in the same folder). It fails with the error below.

Configuration is also below with domain, username and password redacted.

I reviewed the documentation but did not see this use case. Do I need to create folders beforehand in this scenario?

Thanks!
About to connect to source : 
Source connected : 
Source filled : 6 rows loaded
About to connect to destination : 
Destination connected : 
Imported : \\PSLT0164\IMStore\000\000\000000010-.TIF
Imported : \\PSLT0164\IMStore\000\000\000000012-12.TIF
Exception importing : \\PSLT0164\IMStore\000\000\000000013-13.TIF : A file or folder with the name https://clubquarters.sharepoint.com/sites/cpx3test/ConnectPoint Archived Invoices/Acme American Repairs, Inc already exists.
Imported : \\PSLT0164\IMStore\000\000\000000014-14.TIF
Imported : \\PSLT0164\IMStore\000\000\000000015-.TIF
Imported : \\PSLT0164\IMStore\000\000\000000017-17.TIF
<?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 CP Archived Invoice TIF.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=0";</ConnectionString>
    </OleDbSourceDataSetSettings>
    <OleDbTableSourceDataSetSettings />
    <OleDbSelectSourceDataSetSettings>
      <SelectStatement>select * from [files$]</SelectStatement>
    </OleDbSelectSourceDataSetSettings>
    <ODBCSourceDataSetSettings />
    <ODBCSelectSourceDataSetSettings />
  </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>Batch No</DestinationField>
          <SourceColumn>Batch No</SourceColumn>
        </ImportMapping>
        <ImportMapping xsi:type="ImportMapping_String">
          <DestinationField>Vendor No</DestinationField>
          <SourceColumn>Vendor No</SourceColumn>
        </ImportMapping>
        <ImportMapping xsi:type="ImportMapping_String">
          <DestinationField>Vendor Name</DestinationField>
          <SourceColumn>Vendor Name</SourceColumn>
        </ImportMapping>
        <ImportMapping xsi:type="ImportMapping_String">
          <DestinationField>Invoice Number</DestinationField>
          <SourceColumn>Invoice No</SourceColumn>
        </ImportMapping>
        <ImportMapping xsi:type="ImportMapping_String">
          <DestinationField>GL Account Code</DestinationField>
          <SourceColumn>GL Account Code</SourceColumn>
        </ImportMapping>
        <ImportMapping xsi:type="ImportMapping_String">
          <DestinationField>GL Account Description</DestinationField>
          <SourceColumn>GL Account Description</SourceColumn>
        </ImportMapping>
        <ImportMapping xsi:type="ImportMapping_Native">
          <DestinationField>Invoice Total</DestinationField>
          <SourceColumn>Invoice Total</SourceColumn>
        </ImportMapping>
        <ImportMapping xsi:type="ImportMapping_DateTimeFromString">
          <DestinationField>Archive Invoice Date</DestinationField>
          <SourceColumn>Invoice Date</SourceColumn>
          <ConversionMask>MM/dd/yyyy</ConversionMask>
          <Culture>en-US</Culture>
        </ImportMapping>
        <ImportMapping xsi:type="ImportMapping_DateTimeFromString">
          <DestinationField>Posting Date</DestinationField>
          <SourceColumn>Posting Date</SourceColumn>
          <ConversionMask>MM/dd/yyyy</ConversionMask>
          <Culture>en-US</Culture>
        </ImportMapping>
      </ImportMappings>
    </DestinationItemSettings>
    <DestinationListSettings>
      <DestinationWebUrlRelative>/sites/CPX3Test</DestinationWebUrlRelative>
      <DestinationFolderUrlRelative>/sites/CPX3Test/ConnectPoint Archived Invoices</DestinationFolderUrlRelative>
      <DestinationServerUrl>https://*************s.sharepoint.com</DestinationServerUrl>
      <DestinationListName>ConnectPoint Archived Invoices</DestinationListName>
    </DestinationListSettings>
    <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>
Coordinator
Dec 8, 2016 at 9:36 PM
Probably the comma in the folder name causing the problem

Either that or create the folders beforehand
Dec 9, 2016 at 3:15 PM
Edited Dec 9, 2016 at 3:33 PM
Hello,

Good call: the comma and the period characters were causing the issue. Once both were removed from the folder names in the Excel source then DIFS ran in one shot (no need to create folders beforehand).

Thanks!
Marked as answer by bwalker31 on 6/1/2017 at 12:28 PM