Photoshop Script Variable Images From CSV

Рет қаралды 7,001

Жыл бұрын

JavaScript for Photoshop reads a CSV spreadsheet of multiple image names and text, and for each row of data, updates layer names that match column heads to the image or text specified. Then each unique result is output in the selected file format. Simplify data-driven graphics in Photoshop with batch processing and variable data sets rolled into one solution.
- Combine images and text for personalized images
- Update any number of image and text layers
- Specify URLs to download image and import to layer
- Output formats BMP, JPG, PNG, PSD, or TIF
- An easier way to accomplish data merge in Photoshop
- Recognizes column for output file name
Get the script: www.marspremedia.com/software...
Get the advanced version: www.marspremedia.com/software...
How to install Illustrator scripts macOS: • Illustrator Scripts Ho...
How to install Illustrator scripts Windows: • Illustrator Scripts Ho...
How to install InDesign scripts macOS: • InDesign Scripts How t...
How to install InDesign scripts Windows: youtu.be/
How to install Photoshop scripts macOS: • Photoshop Scripts How ...
How to install Photoshop scripts Windows: • Photoshop Scripts How ...
More about installing scripts both macOS and Windows: www.marspremedia.com/software...
Other useful scripts for Adobe Creative Cloud applications: www.marspremedia.com/software

Пікірлер: 60

@victor25021983 Жыл бұрын

see your youtube channel and this video is really helpful. few people learn adobe well and more fewer learn scripting. and more fewer people learn designing and coding togehter as well.. your video will atract few person but in very enthuasism.

@coolhandlooks 3 ай бұрын

Thanks!

@wc7 3 ай бұрын

Thank you. I really appreciate it.

@bharamappabandak9226 Жыл бұрын

🔥🔥👌👌👌👌👍👍👍👍

@wc7 Жыл бұрын

Thanks

@EkaspenoyV2 7 ай бұрын

❤❤ great content sir thanks for keeping this free it means a lot apreciate your efforts…….

@wc7 7 ай бұрын

Script is not free.

@EkaspenoyV2 7 ай бұрын

Ya i realized it afterwords 🥲i couldent buy it though you are helping a lot to those who can afford it

@kennethog6433 Жыл бұрын

Is there a simple code i can run to save the files as mp4? i am creating a timeline animation in photoshop. Can this script also work in after effects?

@wc7 Жыл бұрын

Made for photoshop to make still images. Not for video.

@dertester1 Жыл бұрын

Is there a way to change the background colors of the image through the script? I need each image to have a different color

@wc7 Жыл бұрын

The script won't change the color of images. I have considered adding the capability to change the value of a solid color fill layer. Is that what you mean? Even without that capability, it could be achieved with the current script. You could have a bottom layer that is replaced by an image that is simply a solid color. Each row that image could be a different one that's a different color.

@dertester1 Жыл бұрын

@@wc7 Thank you for the fast response. I'm just looking for a way to create multiple images at once with a text layer and a background. Like 100 quotes, different texts and I'd like each image to have a different background color so that the 100 images form a rainbow with the colors slowly changing. I can give the HEX values into a csv, but I don't get how to script the background color.

@wc7 Жыл бұрын

@@dertester1 You could make 100 images to import that are 100 different colors. But that's a lot of work. How to solve otherwise depends on what is the colored background. Does it have a shape? Or is it simply a flat color? Either way, a solid color fill layer is likely how I'd solve the challenge, the color layer either the entire canvas size or masked if it needs a specific shape. The script doesn't do it now, but I could add the feature to read hex values and if the target layer is a solid color fill layer, update the color value to the hex value in the row. I've considered this as a new feature already, but haven't done it yet.

@hustleheartdesignco2319 10 ай бұрын

does the advanced version work will with smart objects. I couldn't get the free version to work. I am doing a trial of the middle version. it changing the smart object but not filling all the way in?

@wc7 10 ай бұрын

This version and the advanced version work with smart objects. In fact regular pixel layers are converted to smart objects to make swapping the content easier. If not working correctly, reach me on my website contact page and post a sample file for me to download and test. www.marspremedia.com/contact/

@dmailerdude Жыл бұрын

I'm using the advanced trial version with no luck. The free version using 'layer' and 'text' columns still works but that method doesn't work with the advanced. I am only using text layers, no images at this point. Maybe I'm not setting up the spreadsheet correctly?

@wc7 Жыл бұрын

This script works differently from the text update script. The head for the column is the name of the layer. So each layer requires only one column each, not two like the text update script. Watch the instructions and study the webpage. This script has a lot more moving parts.

@dmailerdude Жыл бұрын

Thanks for the quick reply. I have gone through the video and instructions many times. I'm just trying to insert text and so I have only columns for the file name and text. The error I get is: Error line 2332: undefined is not an object

@wc7 Жыл бұрын

@@dmailerdude Which script are you using? It should be "Variable Images From CSV" (trial). That script does not have that many lines. Are you using the Advanced version? I don't think you need that. Also if text only, be sure to check "Data for images is full path or URL (or there are no images)". If it still doesn't work, see my channel page about tab for my contact info. Send your CSV and I'll check it for any problems.

@wc7 Жыл бұрын

Easier way to resolve this for me is to add an option to the free script to disable changing the text position, which I have done. Go back to the webpage and download the updated script. Try that. www.marspremedia.com/software/photoshop/text-update-from-csv

@dmailerdude Жыл бұрын

@@wc7 Yaay, it works! As long as I do NOT check the Options box about the original placeholder position. Many thanks , great service!

@dubzi100 5 ай бұрын

Does this allow you to merge layer as link or embedded smart object within the data set rather than only raster.?

@wc7 5 ай бұрын

Images imported become smart objects.

@ashoksathasivam9549 Ай бұрын

Is there any chance to save all files to single pdf in output. it will be hepful for me.....

@wc7 Ай бұрын

Make the reply address the same. I think it should work?

@mustafadudhwala7278 2 ай бұрын

Is there something dimilar created for variables in illustrator?

@wc7 2 ай бұрын

The script can output more than PSD. It gives control of output file name. Imports from URLs. Advanced version handles multiple templates and data files. That's just a few differences. Next update I'm adding an option to auto-reduce font size to make text layers not wrap when the line is too long. Also now working on column and cell overrides for alignment and image placement.

@wc7 2 ай бұрын

I realize later you were asking about Illustrator. No I don't have a similar script for Illustrator. This one is Photoshop.

@rahuldestty 11 ай бұрын

Hi, thanks for the nice video. Is it possible to append csv datasets to photoshop templet. I have a photshop file where I have imported a csv dataset, now is it possible to append another csv dataset to the same photoshop file. thanks in advance.

@wc7 11 ай бұрын

This script doesn't use the variables or dataset feature of Photoshop. It reaches a similar result on its own. For this script, there is one source of data, and datasets in Photoshop work the same. You don't select more datasets or data files. If more results are needed, add more rows to the existing data.

@rahuldestty 11 ай бұрын

@@wc7 hank you so much for the response. I have another small query, I have been struglling with this for a long. Is there a way to export the datasets back to csv or txt from photoshop? Please find sometime to respond. thanks and in advance.

@wc7 11 ай бұрын

@@rahuldestty I don't know a way to do that.

@burakakpnar9543 11 ай бұрын

Thanks for the script. However when I try to use it with URLs, the script deletes the first variable and names the last variable as downloaded image name. How can I solve this?

@wc7 11 ай бұрын

How do you define "variable" ? Do you mean name of layer in Photoshop? If so, are you putting images in pixel layers? If trying to put images in text layers, the result could be similar to what you describe. The layer content becomes the value from the spreadsheet, the image name not the image itself. This is described in the documentation. Images go in pixel layers, not text layers. If the layers are correct, pixel layers for images and text layers for text, then it should work. If not it's unclear why. Will need more details, particularly what signals the result is incorrect. The statement "deletes the first variable" makes no sense. What is a "variable" in this context? Please clarify.

@burakakpnar9543 11 ай бұрын

@@wc7 Sorry for my English, its not my native language. I can make a screen recording and send it to you if you cant understand me

@wc7 11 ай бұрын

@@burakakpnar9543 Add a column to your CSV "file name". Enter a unique file name to each row of the data. Do not include an extension. The script adds that. Then none of the output files will conflict with any other.

@burakakpnar9543 11 ай бұрын

@@wc7 thanks thats solved the issue

@wc7 11 ай бұрын

@@burakakpnar9543 Great. I am also updating the code so if the output name matches an existing file, a number is added so it doesn't overwrite.

@BGdev305 Жыл бұрын

Why not just use Photoshop Variables, which is already in photoshop? And with more options!

@wc7 Жыл бұрын

That works too. Use it if you prefer. The script can output more than PSD. It gives control of output file name. Imports from URLs. Can do multiple templates and data files. Those are some differences, there are others. Read the documentation it explains everything. I'm working on adding the other options missing at this point, visibility for example. The current script is a product of user requests so far, so that's why it may be a complete solution for the users who asked for it, but perhaps not complete enough for everyone else. These things take time.

@shekhkasim2099 11 ай бұрын

can you make this type jsx script for after effects template ?

@wc7 11 ай бұрын

Sorry I have not programmed After Effects. Someday I will study how it works when I have time.

@shekhkasim2099 11 ай бұрын

@@wc7 Thank you. Please try it this is very important for me.

@thepetpaintery Жыл бұрын

Thanks! Anyone who can help on how to mask image layers, to make sure that the imported images is fit into the mask (mentioned at ~1:45) I have searched google and youtube for two hours now but without success. Thanks

@wc7 Жыл бұрын

First make a selection -- there a numerous ways. The simplest is use the Marquee tool. On the tool bar normally at left, the second tool down, looks like a square with dashed outline. Select the tool then drag the mouse to create a square on the layer to mask. This is the area that will show through. In the layers panel, select the layer to mask. If the Layers panel isn't showing, go to the "Window" menu, "Layers". Along the bottom of the Layers panel are buttons. First looks like a chain. Last is a trash can. Third one is create mask button. Looks like a black square with a white circle in it. With the layer selected, click the create mask button. Now the layer is masked.

@abdullahemad6469 3 ай бұрын

An error has occurred. Line 2198: undefined is not an object (It shows me this error)

@wc7 3 ай бұрын

Fixed. Visit webpage and download another copy of trial again, now version 5.2. Should work now. Let me know if not. Thank you for reporting the problem.

@ruudygh 8 ай бұрын

how to run an action for every loop?

@wc7 8 ай бұрын

This script does not run actions during its execution. Or are you asking how to program a script to run an Action during a for loop?

@HawaiiWS6 3 ай бұрын

having trouble with text not staying where I have it placed. I sent an e-mail.

@wc7 3 ай бұрын

Got the message and have replied.

@bloodbird742 11 ай бұрын

damn, if this thing also could swap colors, say on a color overlay layer effect, it could do all i need...

@wc7 11 ай бұрын

It is possible with added code. Easiest is to change value of a solid color fill layer. Color overlay can be done with a little extra work using Action Manager. I had another user with a similar request but when I asked how it should work I never heard back, so I didn't go further. If you would like to express how it should work, I'll think about implementing some changes.

@bloodbird742 11 ай бұрын

@@wc7I actually found an easier work around! by making myself a collection of .PNG with each of my solid colors and making my layout with masked layers, i can use your script to import the color PNG like an image. If i understand correctly, I can even change text fill color, but for that i need a second copy of my text without layer style ( to be replaced by the same text as the one with the layer style below it) then make a solid color layer on top as a clipping mask that is replaced by a color PNG, then the cliping mask fit it to the inside of the text letters. I have not yet tried it, i may come back adter to tell how that went

@wc7 11 ай бұрын

@@bloodbird742 Sounds like workable solutions. Again, without specifics of how the script might approach setting colors of layers in the template, I don't expect changes to the code.

@sumvanna1779 Жыл бұрын

❤❤🎉 I help script support unicode font ?

@wc7 Жыл бұрын

Adobe scripts support Unicode. If importing CSV, be sure (from Excel for example) to Save as type "CSV UTF-8 (Comma Delimited) (*.csv). Otherwise the encoding is lost and weird characters result.

@sumvanna1779 Жыл бұрын

@William Campbell thanks 🙏🙏🙏🙏🙏🙏