Cant export folders

Jul 21, 2016 at 11:34 AM

For Folders

Hi all

Here is my XML for folders
<?xml version="1.0" encoding="utf-8"?>
<DataSetImportSettings xmlns:xsd="" xmlns:xsi="">
      <ConnectionString>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\xxx\StaffFolders.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=0";</ConnectionString>
    <OleDbTableSourceDataSetSettings />
      <SelectStatement>select * from [directories$]</SelectStatement>
      <domain />
        <ImportMapping xsi:type="ImportMapping_String">
        <ImportMapping xsi:type="ImportMapping_Native">
          <SourceColumn>Employee Number</SourceColumn>
        <ImportMapping xsi:type="ImportMapping_ManagedMetaDataAutoAdd">
          <DestinationField>Employee Name</DestinationField>
          <SourceColumn>Employee Name</SourceColumn>
        <ImportMapping xsi:type="ImportMapping_DateTimeFromString">
          <SourceColumn>Date of Leaving</SourceColumn>
          <ConversionMask>dd/MM/yyyy hh:mm:ss</ConversionMask>
        <ImportMapping xsi:type="ImportMapping_Lookup">
          <SourceColumn>Job Title</SourceColumn>
and here is the output for the first folder (same thing for the rest)

About to connect to source :
Source connected :
Source filled : 5 rows loaded
About to connect to destination :
Destination connected :
Exception importing : D:\xxx\Shared Folders\Staff\A\Adams, David - 1002 : Cette opération ne peut être effectuée que sur un fichier ; « » est un dossier.

Something is being doing on the folder as an SPItem so what's wrong ?

Help plz
Jul 21, 2016 at 2:38 PM

Thanks for the message - this might explain your other problem as well - certainly you need a folder structure first.

Your following setting looks wrong to me;


I will assume that "Importations" is a document library in the root web and F01 is a folder inside it that you have already created

So the above should be


If you want to create folders directly inside F01 then when you do a folder import the DestinationSubDirectories would be F01 and the DestinationFolderName
would be the name of the folder that you want to create.

If you want to create a deeper structure such as F01\Staff the DestinationSubDirectories would be F01\Staff and the DestinationFolderName
would be the name of the folder that you want to create.

I hope that this helps
Jul 21, 2016 at 3:27 PM
Edited Jul 21, 2016 at 3:30 PM
You put me on the right way, thank you

I was missing the xlsx -> DestinationSubDirectories "staff" folder

so I just added a Staff folder inside Importations DocumentLibrary
Jul 27, 2016 at 2:00 PM
I used the power shell script to generate my own csv I added the UTF 8 encoding for output

Thank you @MadAboutImport
Jul 27, 2016 at 2:02 PM


If you have had a success with DIFS then if you have time do post your success story or add a review. Also interested to hear about enhancements.

Jul 27, 2016 at 3:21 PM
Yes the tool is powerful in the case we know how it works :)
the configuration with xml and xlsx files was not easy in the beginning but later I understand the fact it can be really helpful for managing metadatas and content types.

thank you @MadAboutImports
Jul 27, 2016 at 3:31 PM

Thanks; Will try and improve the documentation when time permits!

Jul 28, 2016 at 9:07 AM