This is a guide to an alternative, third-party method to renaming exported photos from Fulcrum. It uses tools that are available for free and should work for users across all operating system platforms. While this guide uses Google Sheets, the process is likely similar for Microsoft Office Excel and LibreOffice Calc.

To begin, you need a CSV file exported from Fulcrum using the exporter that includes photos. Then, import your CSV into a blank Sheet.

If your Fulcrum app contains multiple photos per photo-field, you will need to prepare the Sheet accordingly. If not, please skip this step. 

Use Sheets' Split text to columns functionality to create separate columns for each photo ID (both Excel and Calc have similar functionality). You may have to do this more than once if you have more than one photo-field in your app.

Insert columns to the right of your photo-field columns. Give them a name in the first row header; you can use the corresponding columns' name and append the suffix _rename to it, like below.

Now we will use a formula that will build a new filename for the photos by referencing a couple other columns in our exported data. This particular formula is specific for a demonstration project, but hopefully it can serve as a model for you to achieve your own similar task.

Here's what the formula is doing:

Below, we already applied the formula to the first rename-field column and are applying it to the second column (changing Post1 to Post2). Run a quick test on a few rows and if it looks good, paste it into the rest of the column. Also check to make sure the custom ID field is inserted when appropriate. 

This step is where we will build our rename commands. You will use ren for Windows OR mv for Mac/Linux. We'll use mv in this example. Again, we will use a formula to check for empty values and build our command:

Here's what the formula is doing:

Next, we will copy the rename commands into a text editor for cleanup. Copy the cells containing your commands from your column, omitting the first row header.

Paste this into a text editor such as Sublime, Atom, or Notepad++ (something that includes Find & Replace with support for RegEx) and save your the file. For example: rename-photos.sh (Mac/Linux) or rename-photos.bat (Windows).

Now let's cleanup the script. We are going to use Find & Replace with RegEx to tidy up each line containing the rename commands. There will be 3 parts:

Remove the double-quotes at the beginning of each line by finding ^" and leaving "Replace With" blank.

Remove the double-quotes at the end of each line by finding "$ and leaving "Replace With" blank.

Remove blank lines by finding ^(?:[\t ]*(?:\r?\n|\r))+ and leaving "Replace With" blank.

Finally, run the script.

To run a batch file (example: rename-photos.bat ) from the Command Prompt, open Command Prompt and enter into the directory containing the file and type the name of the batch file and press enter. To run a batch file from the Windows Desktop, it runs like any other executable file by double-clicking the file. However, because a batch file runs in a command prompt, it immediately exits when completed - so you may only briefly see a black box for a second.

To run a script (example: rename-photos.sh ) from a Mac/Linux terminal, open the terminal and navigate to the directory containing the file and type sh rename-photos.sh.

This guide has shown you how to work with spreadsheet formulas to modify filenames and build new commands for a script. Find & Replace was also used (with RegEx) to cleanup text. Hopefully this guide provides an example of an alternative method of building a script for batch processing files.