With the template image open, run the script. UTF-8 is recommended so any Unicode characters are preserved. From Excel, choose Save As, and in the drop-down list Save as type, select CSV UTF-8 Comma delimited. Once the spreadsheet is ready, save it as Comma Separated Values (CSV format). If this column is absent, the first image name or text value found is used to name the output file.
Use the column head “file name” to indicate the output file name. There is one special column head that is optional and not related to any layer name. See the section Further reading for more details. It is possible to mix image names that are full paths and/or URLs with images that are file name only. If file name only, select the folder to search for images in the section Images. When the template image contains multiple layers of the same name, all are updated with the content specified in the data for the layer name.Ĭolumns for images may be the full path to the file, a URL to download the file, or the file name only. Rows of the column “text1” replace the text contents of the layer named “text1”.Īnd so on with all layer names and column heads present in both the template and data.
#Data merge in photoshop update
In this example, rows of the column “image1” are image file names to import and update the layer named “image1” of the template image. If column heads exist that have no matching layer in the template image, the columns are ignored. The column heads must match layer names in the template image. The second item to prepare is a spreadsheet of image file names and text. Any layer name that does not appear in the spreadsheet is untouched and, if visible, is included with all images output. For example, elements common to all images output. The number of layers to update is limited only by the resources available to Photoshop. Pixel layers may be masked as are layers “image2” and “logo” in this example. This example is two normal pixel layers, “image1” and “image2”, then three text layers, “text1”, “text2”, and “text3”.
0 kommentar(er)
