DC 5.7 Example import configurations

Owned by Mathias Mattson (MHM)
Feb 17, 2023
3 min read

This section contains example import and metadata configurations.

Use case: asset upload without metadata

Variant: Without asset replace

Import configuration
<?xml version="1.0" encoding="utf-8" ?>
<ImportConfig>
  <LanguageId>3</LanguageId>
  <UploadDirectory>D:\Work\DAMImporter\HotFolder\AssetUploadNoMetadataNoReplace\Input</UploadDirectory>
  <FailureDirectory>D:\Work\DAMImporter\HotFolder\AssetUploadNoMetadataNoReplace\Failed</FailureDirectory>
  <DeleteEmptyDirectories>true</DeleteEmptyDirectories>
  <RunUpload>true</RunUpload>
  <ComputerName>AssetUploadNoMetadataNoReplace</ComputerName>
  <FileNameStampType>RelativePath</FileNameStampType>
  <FileNameStampMetafieldId>10148</FileNameStampMetafieldId>
  <Active>true</Active>
</ImportConfig>

Variant: With asset replace

Import configuration
<?xml version="1.0" encoding="utf-8" ?>
<ImportConfig>
  <LanguageId>3</LanguageId>
  <UploadDirectory>D:\Work\DAMImporter\HotFolder\AssetUploadNoMetadataWithReplace\Input</UploadDirectory>
  <FailureDirectory>D:\Work\DAMImporter\HotFolder\AssetUploadNoMetadataWithReplace\Failed</FailureDirectory>
  <DeleteEmptyDirectories>true</DeleteEmptyDirectories>
  <RunUpload>true</RunUpload>
  <ComputerName>AssetUploadNoMetadataWithReplace</ComputerName>
  <FileNameStampType>RelativePath</FileNameStampType>
  <FileNameStampMetafieldId>10148</FileNameStampMetafieldId>
  <MatchSearchName>DamImporterMatchSearch</MatchSearchName>
  <MatchTokenFallbackType>RelativePath</MatchTokenFallbackType>
  <ArchiveOnReplace>true</ArchiveOnReplace>
  <Active>true</Active>
</ImportConfig>

Use case: asset upload with metadata

Variant: Xml metadata without asset replace

Import configuration
<?xml version="1.0" encoding="utf-8" ?>
<ImportConfig>
  <LanguageId>3</LanguageId>
  <UploadDirectory>D:\Work\DAMImporter\HotFolder\AssetUploadWithXmlMetadataNoReplace\Input</UploadDirectory>
  <FailureDirectory>D:\Work\DAMImporter\HotFolder\AssetUploadWithXmlMetadataNoReplace\Failed</FailureDirectory>
  <DeleteEmptyDirectories>true</DeleteEmptyDirectories>
  <RunUpload>true</RunUpload>
  <ComputerName>AssetUploadWithXmlMetadataNoReplace</ComputerName>
  <FileNameStampType>RelativePath</FileNameStampType>
  <FileNameStampMetafieldId>10148</FileNameStampMetafieldId>
  <RunMetadataUpdate>true</RunMetadataUpdate>
  <MetadataFileName>D:\Work\DAMImporter\HotFolder\AssetUploadWithXmlMetadataNoReplace\MetadataConfiguration.xml</MetadataFileName>
  <Culture>da-DK</Culture>
  <MetadataParser>Xml2Metadata</MetadataParser>
  <Active>true</Active>
</ImportConfig>


Metadata configuration
<?xml version="1.0" encoding="utf-8" ?>
<MetadataDefinitions>
  <Metafield Id="50181" XPath="/Media/Title"/>
  <Metafield Id="50182" XPath="/Media/Description"/>
  <Metafield Id="50511" XPath="/Media/AnInteger"/>
  <Metafield Id="50510" XPath="/Media/AString"/>
  <Metafield Id="50517" XPath="/Media/ADatetime"/>
  <Metafield Id="10192" XPath="/Media/Keyword"/>
  <Metafield Id="50188" XPath="/Media/MediaManagerMenu"/>
  <Metafield Id="50512" XPath="/Media/ABit"/>
  <Metafield Id="50522" XPath="/Media/ACombo"/>
  <Metafield Id="50513" XPath="/Media/AFloat"/>
  <Metafield Id="50521" XPath="/Media/AMultiCombo"/>
</MetadataDefinitions>


Metadata example
<?xml version="1.0" encoding="utf-8" ?>
<Media>
    <Title>Bugatti Chiron in blue colors</Title>
    <Description>A really nice car.</Description>
    <AnInteger>54321</AnInteger>
    <AString>Nothing to see here</AString>
    <ADatetime>2018-01-01T01:00:00</ADatetime>
    <Keyword>Awesome</Keyword>
    <Keyword>Sexy</Keyword>
    <Keyword>Car</Keyword>
    <MediaManagerMenu>Images/Cars</MediaManagerMenu>
    <MediaManagerMenu>Images/Cars/Bugatti</MediaManagerMenu>
    <ABit>false</ABit>
    <ACombo>Bugatti</ACombo>
    <AFloat>1,1</AFloat>
    <AMultiCombo>Lettuce</AMultiCombo>
    <AMultiCombo>Carrot</AMultiCombo>
</Media>


Variant: Excel metadata with asset replace

Import configuration
<?xml version="1.0" encoding="utf-8" ?>
<ImportConfig>
  <LanguageId>3</LanguageId>
  <UploadDirectory>D:\Work\DAMImporter\HotFolder\AssetUploadWithExcelMetadataWithReplace\Assets</UploadDirectory>
  <SheetDirectory>D:\Work\DAMImporter\HotFolder\AssetUploadWithExcelMetadataWithReplace\Sheets</SheetDirectory>
  <FailureDirectory>D:\Work\DAMImporter\HotFolder\AssetUploadWithExcelMetadataWithReplace\Failed</FailureDirectory>
  <DeleteEmptyDirectories>true</DeleteEmptyDirectories>
  <RunUpload>true</RunUpload>
  <ComputerName>AssetUploadWithExcelMetadataWithReplace</ComputerName>
  <FileNameStampType>RelativePath</FileNameStampType>
  <FileNameStampMetafieldId>10148</FileNameStampMetafieldId>
  <RunMetadataUpdate>true</RunMetadataUpdate>
  <Culture>da-DK</Culture>
  <MetadataParser>Excel</MetadataParser>
  <ComboSeparator>;</ComboSeparator>
  <FilenameColumn>1</FilenameColumn>
  <MetafieldIdRow>2</MetafieldIdRow>
  <DataStartRow>4</DataStartRow>
  <MatchSearchName>DamImporterMatchSearch</MatchSearchName>
  <MatchTokenColumn>1</MatchTokenColumn>
  <MatchTokenFallbackType>RelativePath</MatchTokenFallbackType>
  <ArchiveOnReplace>true</ArchiveOnReplace>
  <Active>true</Active>
</ImportConfig>


Variant: Excel metadata without asset replace

Import configuration
<?xml version="1.0" encoding="utf-8" ?>
<ImportConfig>
  <LanguageId>3</LanguageId>
  <UploadDirectory>D:\Work\DAMImporter\HotFolder\AssetUploadWithExcelMetadataNoReplace\Assets</UploadDirectory>
  <SheetDirectory>D:\Work\DAMImporter\HotFolder\AssetUploadWithExcelMetadataNoReplace\Sheets</SheetDirectory>
  <FailureDirectory>D:\Work\DAMImporter\HotFolder\AssetUploadWithExcelMetadataNoReplace\Failed</FailureDirectory>
  <DeleteEmptyDirectories>true</DeleteEmptyDirectories>
  <RunUpload>true</RunUpload>
  <ComputerName>AssetUploadWithExcelMetadataNoReplace</ComputerName>
  <FileNameStampType>RelativePath</FileNameStampType>
  <FileNameStampMetafieldId>10148</FileNameStampMetafieldId>
  <RunMetadataUpdate>true</RunMetadataUpdate>
  <Culture>da-DK</Culture>
  <MetadataParser>Excel</MetadataParser>
  <ComboSeparator>;</ComboSeparator>
  <FilenameColumn>1</FilenameColumn>
  <MetafieldIdRow>2</MetafieldIdRow>
  <DataStartRow>4</DataStartRow>
  <Active>true</Active>
</ImportConfig>


Use case: metadata only ingest

Variant: Xml metadata without match search

Import configuration
<?xml version="1.0" encoding="utf-8" ?>
<ImportConfig>
  <LanguageId>3</LanguageId>
  <UploadDirectory>D:\Work\DAMImporter\HotFolder\MetadataUpdateXmlInput\Input</UploadDirectory>
  <FailureDirectory>D:\Work\DAMImporter\HotFolder\MetadataUpdateXmlInput\Failed</FailureDirectory>
  <DeleteEmptyDirectories>true</DeleteEmptyDirectories>
  <RunUpload>false</RunUpload>
  <RunMetadataUpdate>true</RunMetadataUpdate>
  <MetadataFileName>D:\Work\DAMImporter\HotFolder\MetadataUpdateXmlInput\MetadataConfiguration.xml</MetadataFileName>
  <Culture>da-DK</Culture>
  <BulkSize>10</BulkSize>
  <MetadataParser>Xml2Metadata</MetadataParser>
  <Active>true</Active>
</ImportConfig>


Metadata configuration
<?xml version="1.0" encoding="utf-8" ?>
<MetadataDefinitions>
  <Metafield Id="itemId" XPath="/Media/ItemId"/>
  <Metafield Id="50181" XPath="/Media/Title"/>
  <Metafield Id="50182" XPath="/Media/Description"/>
  <Metafield Id="50511" XPath="/Media/AnInteger"/>
  <Metafield Id="50510" XPath="/Media/AString"/>
  <Metafield Id="50517" XPath="/Media/ADatetime"/>
  <Metafield Id="10192" XPath="/Media/Keyword"/>
  <Metafield Id="50188" XPath="/Media/MediaManagerMenu"/>
  <Metafield Id="50512" XPath="/Media/ABit"/>
  <Metafield Id="50522" XPath="/Media/ACombo"/>
  <Metafield Id="50513" XPath="/Media/AFloat"/>
  <Metafield Id="50521" XPath="/Media/AMultiCombo"/>
</MetadataDefinitions>


Metadata example
<?xml version="1.0" encoding="utf-8" ?>
<Media> 
    <ItemId>13001</ItemId>
    <Title>Bugatti Chiron in black</Title>
    <Description>A car that will kick the lamas ass.</Description>
    <AnInteger>999</AnInteger>
    <AString>Blah blah blah Bugatti blab blah</AString>
    <ADatetime>2014-04-14T14:14:00</ADatetime>
    <Keyword>Awesome</Keyword>
    <Keyword>Supercar</Keyword>
    <Keyword>Hypercar</Keyword>
    <MediaManagerMenu>Images/Cars/Bugatti</MediaManagerMenu>
    <MediaManagerMenu>Images/Expensive</MediaManagerMenu>
    <MediaManagerMenu>Images/Dreams</MediaManagerMenu>
    <ABit>true</ABit>
    <ACombo>Bugatti</ACombo>
    <AFloat>3,33</AFloat>
    <AMultiCombo>Garden cress</AMultiCombo>
    <AMultiCombo>Potato</AMultiCombo>
</Media>


Variant: Excel metadata with match search

Import configuration
<?xml version="1.0" encoding="utf-8" ?>
<ImportConfig>
  <LanguageId>3</LanguageId>
  <UploadDirectory>D:\Work\DAMImporter\HotFolder\MetadataUpdateExcelInputFileNameMatch\Input</UploadDirectory>
  <FailureDirectory>D:\Work\DAMImporter\HotFolder\MetadataUpdateExcelInputFileNameMatch\Failed</FailureDirectory>
  <RunUpload>false</RunUpload>
  <RunMetadataUpdate>true</RunMetadataUpdate>
  <Culture>da-DK</Culture>
  <BulkSize>7</BulkSize>
  <MetadataParser>Excel</MetadataParser>
  <ComboSeparator>;</ComboSeparator>
  <MetafieldIdRow>2</MetafieldIdRow>
  <DataStartRow>4</DataStartRow>
  <MatchSearchName>DamImporterMatchSearch</MatchSearchName>
  <MatchTokenColumn>1</MatchTokenColumn>
  <Active>true</Active>
</ImportConfig>