Generate media file PATHs for batch import

L
Generate media file PATHs for batch import

Click here for full screen view.

To view this article in full screen click here.

This article will help you format the media import template (available here) with media PATHs that you’ll upload with your media files. The finished template will look like this :

How do I Generate File Paths?

Generating file Paths is easiest with an Excel add-on or a dedicated software that generates file PATHs by batch. In this article, we use “FilelistCreator” available for free here.

DRAG AND DROP your Master Folder into the FilelistCreator

Set the following parameters:

  • Select “Files” in Include
  • Select “Path” in Columns/General
  • Select “Excel Spreadsheet XLSX” in Export Format
  • Copy the PATH by clicking “Clipboard“

How do I Modify the File Paths for the Template?

PASTE the PATHs in the Excel document medias-template.xlsx (paste from cell 2a)

In cell 2A, HIGHLIGHT and COPY the data path from the start of the PATH up to the name of the Master Folder (named Casting Database in example) as seen below :

  • SELECT Column A
  • OPEN “Find” window (ctrl +f)
  • PASTE  (ctrl + v) the text from your clipboard to the “Find” field
  • Leave “Replace with” field empty
  • CLICK  “Replace All”
Your file should now look like this
  • SELECT Column A and COPY
  • SELECT Column C and PASTE
Your file should now look like this
  • SELECT Column A and OPEN “Find” window (ctrl +f)
  • TYPE the name of your Master Folder and “/” after the name (without spaces) in “Find” field (example: “Casting Database/”)
  • LEAVE “Replace with” field empty and CLICK “Replace All”
Your file should now look like this
  • SELECT Column A and OPEN “Find” window (ctrl +f)
  • TYPE “ /* ” (without quotation marks or spaces) in the “Find” field
  • CLICK “Replace”
  • LEAVE “Replace with” field empty
  • CLICK “Replace All”
Your file should now look like this
  • SELECT Column A and OPEN “Find” window (ctrl +f)
  • COPY (ctrl + c) Column A to Column B (ctrl + v)
Your file should now look like this
  • SELECT Column A and OPEN “Find” window (ctrl +f)
  • TYPE space + asterisk “ * ” (without quotation marks or spaces) in the “Find” field
  • CLICK “Replace”
  • LEAVE “Replace with” field empty
  • CLICK “Replace All”
Your file should now look like this
  • SELECT Column B and OPEN “Find” window (ctrl +f)
  • TYPE asterisk + space “* ” (without quotation marks or spaces) in the “Find” field
  • CLICK “Replace”
  • LEAVE “Replace with” field empty
  • CLICK “Replace All”
Your file should now look like this

Your data is ready to be copied to the template medias-template.xlsx. DO NOT MODIFY the headers of the template.

SAVE the finished template at the same level as your contact subfolders.

Your import template should look like this
Permalink