Cant export documents err 409 conflict

Jul 21, 2016 at 10:38 AM

For files

Hi all

Here is my XML for files

<?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=D:\xxx\StaffDocuments.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=0";</ConnectionString>
    </OleDbSourceDataSetSettings>
    <OleDbTableSourceDataSetSettings />
    <OleDbSelectSourceDataSetSettings>
      <SelectStatement>select * from [files$]</SelectStatement>
    </OleDbSelectSourceDataSetSettings>
  </Source>
  <Destination>
    <AuthenticationSettings>
      <AuthenticationType>Office365</AuthenticationType>
      <domain />
      <username>xxxxxx@xxxxx.onmicrosoft.com</username>
      <encryptedpassed>xxxxxxxx</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>EmployeeNumber</DestinationField>
          <SourceColumn>Employee Number</SourceColumn>
        </ImportMapping>
      </ImportMappings>
    </DestinationItemSettings>
    <DestinationListSettings>
      <DestinationWebUrlRelative>/</DestinationWebUrlRelative>
      <DestinationFolderUrlRelative>/Importations</DestinationFolderUrlRelative>
      <DestinationServerUrl>https://xxx.sharepoint.com</DestinationServerUrl>
      <DestinationListName>Importations</DestinationListName>
    </DestinationListSettings>
    <SourceColumns>
      <SourceFileNameAndPath>FullName</SourceFileNameAndPath>
      <ContentType>ContentType</ContentType>
      <DestinationSubFolder>DestinationSubDirectories</DestinationSubFolder>
      <DestinationFileName>DestinationFileName</DestinationFileName>
    </SourceColumns>
  </Destination>
</DataSetImportSettings>
and here is the output



About to connect to source :
Source connected :
Source filled : 11 rows loaded
About to connect to destination :
Destination connected :
Exception importing : D:\xxx\Shared Folders\Staff\A\Adams, David - 1002\Contract.txt : Le serveur distant a retourné une erreur : (409) Conflit.
Exception importing : D:\xxx\Shared Folders\Staff\A\Adams, David - 1002\Promotion.txt : Le serveur distant a retourné une erreur : (409) Conflit.
Exception importing : D:\xxx\Shared Folders\Staff\A\Andrews, Robert - 1001\Contract.txt : Le serveur distant a retourné une erreur : (409) Conflit.





Help again plz
Coordinator
Jul 21, 2016 at 1:26 PM
MarwenK,

Thanks for the question.

You seem to be importing out of the example spreadsheets - that which demonstrates how to upload documents.

The error message that SharePoint is returning suggests that when the file is uploaded the destination is incorrect.

I will assume that the document library "Importations" does exist.

That would mean that the software will try to import the documents into the subfolder(s) as specified in the columns DestinationSubDirectories

These subfolders must exist. So in the first example on staff documents spreadsheet it assumes that there is a subfolder "Staff" and inside that a folder "1002".

If those folders exist the import should succeed in uploading the file.

It would be useful if you can confirm if the file is or is not being uploaded - it is always worth checking library settings "Manage files which have no checked in version" incase the file is being uploaded but not checked in.
Jul 21, 2016 at 2:35 PM
Edited Jul 21, 2016 at 2:36 PM
Thank you for your quick reply

you're right I havent the folders hierarchy, i thought that subfolders will be created automatically

is there a way to specify a local windows folder as source and upload all its content ?
Coordinator
Jul 21, 2016 at 4:10 PM
MarwenK

If you want to do a good job, set content types etc then prepare your sources carefully - this article shows a way to do that;

http://www.ensentia.co.uk/file-share-migration-sharepoint-preparation/

If you want to just do drag and drop.

http://www.ensentia.co.uk/simple-onedrive-to-sharepoint-library-file-copy/

The old version of DIFS used to have a mode that just dumped a folder from A to B

The release is still available https://difs.codeplex.com/releases/view/102382 but Office 365 has moved on since then so it may not work with SharePoint Online.