Sports Photo Automation 7 – CSV/TSV Data

What CSV/TSV data is used for

Sports Photo Automation can use CSV or TSV data to customize the compositions on a per image basis. Data functions include the following.

  • auto replace text
  • auto scale text
  • specify a background (overrides the default choice)
  • specify the output file name (overrides the default naming)
  • run photoshop actions on the composition

CSV/TSV files are typically setup in a spreadsheet program such as Excel. There is also a good free office suite called Libre Office that contains a spreadsheet program called Calc. You can download Libre Offic at https://www.libreoffice.org/.

Basic CSV Layout

Important: If the cell data contains commas or quotes then you must save the file as a tab delimited .tsv file instead of .csv. Commas and quotes will interfere with the .csv data parsing. Using a .tsv will avoid this problem.

Only use the columns you need – For example, if you are only replacing text in one layer with no resizing, the you only need column A for the file list and column B for the text layer.

Column A – Defines the source file list. If you are doing multiple images per template then add those in separate columns labeled Player 2 File, Player 3 File, and Team File.

Row 1 – This is the header row. It contains the “commands” for Sports Photo Automation to use (layer names, resize methods, etc.). These DO NOT need to be in any specific order.

Data Section – This is everything from below row 1 and right of column A. This contains the data the Sports Photo Automation will use.

Column A – Image Processing List

For player images or memory mates, column A MUST be used for the Player 1 layer group.

Column A doesn’t need any header assigned because that column much be used for the specific purpose of creating the main batch file list. You can add a header to column A if you want but it will be ignored by the software.

If you are only adding team images to the template and no players, and the template is setup with a team layer group only, then column will be used for the team images. All of the files in column A will dropped into the team layers. However, if the template has both a Player 1 image and a team image then column A will default to the player 1 layer. So for memory mates, Column A must be for the players. The team files can go in any other column (column B makes the most sense though).

Also, if there is no Player 1 layer group then it won’t process for any players, even is there are groups for players 2 and 3. This is important to know because if you create a template with multiple players, you can’t delete player 1 and decide to use the player 2 group unless you rename the group and all layers in the group from player 1 to player 2.