【第578回】 Marketing Cloud Next ： 複数画像を一括でアップロード公開する

summer_hero.png
autumn_sale.png
winter_campaign.png
spring_collection.png
product_feature.png
new_arrival.png
member_offer.png
event_banner.png
brand_story.png
company_logo.png

fileName,title,altText,folderPath
summer_hero.png,Summer Hero,Summer campaign hero image,Practice 10 Images
autumn_sale.png,Autumn Sale,Autumn sale promotional image,Practice 10 Images
winter_campaign.png,Winter Campaign,Winter campaign banner image,Practice 10 Images
spring_collection.png,Spring Collection,Spring collection promotional image,Practice 10 Images
product_feature.png,Product Feature,Featured product promotional image,Practice 10 Images
new_arrival.png,New Arrival,New arrival announcement image,Practice 10 Images
member_offer.png,Member Offer,Special offer image for members,Practice 10 Images
event_banner.png,Event Banner,Event announcement banner image,Practice 10 Images
brand_story.png,Brand Story,Brand story visual image,Practice 10 Images
company_logo.png,Company Logo,Company logo image,Practice 10 Images

/Import/mcn-cms-images/
├─ manifest.csv
├─ summer_hero.png
├─ autumn_sale.png
├─ winter_campaign.png
├─ spring_collection.png
├─ product_feature.png
├─ new_arrival.png
├─ member_offer.png
├─ event_banner.png
├─ brand_story.png
└─ company_logo.png

New-Item -ItemType Directory -Path "C:\MCN-CMS-Import"

C:\MCN-CMS-Import\
├─ create-cms-import.ps1
├─ download\
├─ work\
└─ MCN_CMS_Import.zip

# ============================================================
# Marketing Cloud Next
# CMS Bulk Image Import ZIP Generator
# MCE SFTP -> WinSCP -> CMS Import ZIP
# manifest.csv: fileName,title,altText,folderPath
# ============================================================

$WinSCPSite = "MCE SFTP"
$RemoteFolder = "/Import/mcn-cms-images"

$BaseFolder = Split-Path -Parent $MyInvocation.MyCommand.Path
$DownloadFolder = Join-Path $BaseFolder "download"
$WorkFolder = Join-Path $BaseFolder "work"
$OutputZip = Join-Path $BaseFolder "MCN_CMS_Import.zip"

$Utf8NoBom = New-Object System.Text.UTF8Encoding($false)

$WinSCPPaths = @(
    "C:\Program Files (x86)\WinSCP\WinSCP.com",
    "C:\Program Files\WinSCP\WinSCP.com"
)

$WinSCPExe = $null
foreach ($Path in $WinSCPPaths) {
    if (Test-Path $Path) {
        $WinSCPExe = $Path
        break
    }
}

if (-not $WinSCPExe) {
    Write-Error "WinSCP.com was not found."
    exit 1
}

Write-Host ""
Write-Host "========================================"
Write-Host "MCN CMS Import ZIP Generator"
Write-Host "========================================"
Write-Host ""

if (Test-Path $DownloadFolder) { Remove-Item $DownloadFolder -Recurse -Force }
if (Test-Path $WorkFolder) { Remove-Item $WorkFolder -Recurse -Force }
if (Test-Path $OutputZip) { Remove-Item $OutputZip -Force }

New-Item -ItemType Directory -Path $DownloadFolder -Force | Out-Null
New-Item -ItemType Directory -Path $WorkFolder -Force | Out-Null

$WinSCPScript = Join-Path $BaseFolder "winscp-download.txt"

$WinSCPCommands = @"
option batch abort
option confirm off
open "$WinSCPSite"
cd "$RemoteFolder"
lcd "$DownloadFolder"
get *
exit
"@

[System.IO.File]::WriteAllText(
    $WinSCPScript,
    $WinSCPCommands,
    $Utf8NoBom
)

Write-Host "Downloading files from MCE SFTP..."

& $WinSCPExe "/script=$WinSCPScript"

if ($LASTEXITCODE -ne 0) {
    Write-Error "SFTP download failed."
    Remove-Item $WinSCPScript -Force -ErrorAction SilentlyContinue
    exit 1
}

Remove-Item $WinSCPScript -Force -ErrorAction SilentlyContinue

$ManifestPath = Join-Path $DownloadFolder "manifest.csv"

if (-not (Test-Path $ManifestPath)) {
    Write-Error "manifest.csv was not found."
    exit 1
}

$Items = Import-Csv $ManifestPath

if (-not $Items) {
    Write-Error "manifest.csv contains no records."
    exit 1
}

$Index = 1
$CreatedCount = 0
$SkippedCount = 0

foreach ($Item in $Items) {

    $FileName = if ($null -ne $Item.fileName) { $Item.fileName.Trim() } else { "" }
    $Title = if ($null -ne $Item.title) { $Item.title.Trim() } else { "" }
    $AltText = if ($null -ne $Item.altText) { $Item.altText.Trim() } else { "" }
    $FolderPath = if ($null -ne $Item.folderPath) { $Item.folderPath.Trim() } else { "" }

    if (-not $FileName) {
        Write-Warning "Skipped a row because fileName is blank."
        $SkippedCount++
        continue
    }

    if (-not $Title) {
        Write-Warning "Skipped $FileName because title is blank."
        $SkippedCount++
        continue
    }

    $SourceImage = Join-Path $DownloadFolder $FileName

    if (-not (Test-Path $SourceImage)) {
        Write-Warning "File not found: $FileName"
        $SkippedCount++
        continue
    }

    $Extension = [System.IO.Path]::GetExtension($FileName).ToLower()

    switch ($Extension) {
        ".png"  { $MimeType = "image/png" }
        ".jpg"  { $MimeType = "image/jpeg" }
        ".jpeg" { $MimeType = "image/jpeg" }
        ".gif"  { $MimeType = "image/gif" }
        ".webp" { $MimeType = "image/webp" }
        default {
            Write-Warning "Unsupported image type: $FileName"
            $SkippedCount++
            continue
        }
    }

    $SafeTitle = $Title -replace '[\\/:*?"<>|]', '_'
    $FolderName = "{0:D3}_{1}" -f $Index, $SafeTitle

    $ContentFolder = Join-Path $WorkFolder $FolderName
    $MediaFolder = Join-Path $ContentFolder "_media"

    New-Item -ItemType Directory -Path $MediaFolder -Force | Out-Null
    Copy-Item $SourceImage (Join-Path $MediaFolder $FileName)

    $ContentBody = @{
        "sfdc_cms:media" = @{
            source = @{
                type = "file"
                mimeType = $MimeType
            }
        }
    }

    if ($AltText) {
        $ContentBody["altText"] = $AltText
    }

    $Content = @{
        type = "sfdc_cms__image"
        title = $Title
        contentBody = $ContentBody
    }

    $Json = $Content | ConvertTo-Json -Depth 10
    $JsonPath = Join-Path $ContentFolder "content.json"

    [System.IO.File]::WriteAllText(
        $JsonPath,
        $Json,
        $Utf8NoBom
    )

    if ($FolderPath) {
        $Meta = @{ path = $FolderPath }
        $MetaJson = $Meta | ConvertTo-Json -Depth 5
        $MetaPath = Join-Path $ContentFolder "_meta.json"

        [System.IO.File]::WriteAllText(
            $MetaPath,
            $MetaJson,
            $Utf8NoBom
        )
    }

    if ($FolderPath) {
        Write-Host "Created: $Title [$FileName] -> $FolderPath"
    } else {
        Write-Host "Created: $Title [$FileName] -> Workspace root"
    }

    $Index++
    $CreatedCount++
}

if ($CreatedCount -eq 0) {
    Write-Error "No CMS content was created."
    exit 1
}

Write-Host ""
Write-Host "Creating CMS Import ZIP..."

Compress-Archive `
    -Path "$WorkFolder\*" `
    -DestinationPath $OutputZip `
    -CompressionLevel Optimal

Write-Host ""
Write-Host "========================================"
Write-Host "Completed"
Write-Host "========================================"
Write-Host "Created : $CreatedCount"
Write-Host "Skipped : $SkippedCount"
Write-Host ""
Write-Host "Output:"
Write-Host $OutputZip
Write-Host ""
Write-Host "Import this ZIP from:"
Write-Host "Marketing Cloud Next"
Write-Host "CMS Workspace > Manage > Import"
Write-Host ""

cd C:\MCN-CMS-Import

.\create-cms-import.ps1

MCN_CMS_Import.zip
├─ 001_Summer_Hero/
│  ├─ content.json
│  ├─ _meta.json
│  └─ _media/
│     └─ summer_hero.png
│
├─ 002_Autumn_Sale/
│  ├─ content.json
│  ├─ _meta.json
│  └─ _media/
│     └─ autumn_sale.png
│
├─ 003_Winter_Campaign/
│  ├─ content.json
│  ├─ _meta.json
│  └─ _media/
│     └─ winter_campaign.png
│
...

{
  "title": "Summer Hero",
  "contentBody": {
    "altText": "Summer campaign hero image",
    "sfdc_cms:media": {
      "source": {
        "mimeType": "image/png",
        "type": "file"
      }
    }
  },
  "type": "sfdc_cms__image"
}

{
  "path": "Practice 10 Images"
}