<?php

$files = array_diff(scandir('soa-wiki'), array('.', '..'));

$fp = fopen('soa-wiki.csv', 'w');

$headers = ['asset_id', 'url'];
fputcsv($fp, $headers, ',', '"', '\\');

foreach ($files as $key => $file) {
  $fields = [
    'soa-wiki--' . $key,
    'https://mysite.utexas.edu/sites/default/files/soa-wiki/' . $file,
  ];
  fputcsv($fp, $fields, ',', '"', '\\');
}

fclose($fp);