Photoshop Script Text Update From CSV
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2022
- JavaScript for Photoshop reads CSV spreadsheet rows for layer names and text, and updates matching layers in a master document, then saves new images of each result. Video tutorial is Windows. Script works the same both macOS and Windows.
- Update text layers with new content
- Multiple text layers each with own content
- Save a unique image for each row of CSV
- Output JPG, PNG, TIF, or PSD
Also see related video:
Photoshop Script Images And Text From CSV: • Photoshop Script Image...
Get the script: www.marspremedia.com/software/...
For multiple image and text layers, images from URLs, and unique output file names, see the script "Variable Images From CSV": www.marspremedia.com/software...
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
Example artwork thanks to www.freepik.com/vectors/dialog - วิทยาศาสตร์และเทคโนโลยี
![แข่งแลกของ 1 วัน!! ของใครแพงสุดชนะ!! [Ver.2024]](http://i.ytimg.com/vi/joRT59ilPHg/mqdefault.jpg)
![โอ้มายก๊อด! ไม่ถึงชั่วโมงหมดเป็นแสน 😅 [cc] แดนแพทตี้ SS2 | EP.42 |](http://i.ytimg.com/vi/OH2ShXfO6tA/mqdefault.jpg)
This wonderful software has saved me hours. Thank you. Even works, with a little magic with a displacement map to wrap text.
Works perfect even for cyrillic texts, Thank you! 🙏
That's very nice to hear. Can't test every scenario so it's good to know when it works in others. Thank you for feedback, and for watching.
Thank you very mutch!
thanks! you just saved me from editing 200 business cards. Well at least i only have to change the pictures manually.
This other script does text and images. th-cam.com/video/Ku2IZJmSadA/w-d-xo.html
@@wc7 ohh yeah i saw it.. but it isnt free 😝... i just sent you a paypal tip for the free script. Thanks again!
@@jahivan Thank you.
Thank you this is great!
Awesome. Glad it helps.
Merci infiniment pour cet Script, très intéressant 🤩
You're welcome. Thanks for watching.
Just one more question - I have been using this to process text replacements on over 30 different files, with 30 different corresponding csvs. I would like to create an action associated to each file + csv set, so I don't have to select the corresponding csv each time. I tried creating copies of the .jsxbin files and adding an identifier to the name with the hopes the action could be saved with that specific script with that specific csv already selected, but no luck. Is it possible?
Making copies of the script file won't help. The last data file used is stored in the settings file under user preferences, which all copies of the script read to remember the last settings used. For a free script the limitation of processing a single CSV file is only to be expected. For more features, including an advanced version that processes any number of templates and/or data files, see these paid scripts:
www.marspremedia.com/software/photoshop/variable-images-from-csv
www.marspremedia.com/software/photoshop/variable-images-advanced
@@wc7 excellent, will look into them now and likely buy, thank you.
This has helped me so much in my workflow!! My only issue is when using it to replace text on a curved/arched text box. Seems to slightly shift the location of the text after replacement. Any idea why?
It's a bug in Photoshop. Out of my control. The problem isn't likely to be addressed because Adobe is shifting away from ExtendScript to Unified Extensibility Platform. Perhaps in the new scripting engine the bug will be gone. Don't know yet as I've yet to make anything with the new stuff.
@@wc7 okay great to know. thank you so much!
Would you happen to know of any scripts or if it's possible for a script to edit text inside an embedded smart object?
I have a PSD template file, in order for me to change the text I have to open the Embedded Smart Object (.psb) file, change text, save and then the styling updates on the main PSD template. After that's done then the final file can be exported.
I hope it makes sense
I'm not aware of a script to do that specifically. It seems it should be possible. Pretty much if it can be done manually, a script can automate it. A few things are difficult or get tricky, but I think digging into a smart object shouldn't be a big deal. Just open it and do whatever. Then save and update in the source.
Hi, thank you for your amazing script, but can we save the file as vector format? is there anyway to do it?
Save as PSD, don't convert color and don't flatten. Then run batch automation to save the PSDs as PDF. The added text added will be vector combined with the other raster elements from Photoshop. Similar results straight to PDF from a script are possible but I won't be adding that to a free script. Paid scripts perhaps, if enough users request it, for example the script Variable Images From CSV -- th-cam.com/video/Ku2IZJmSadA/w-d-xo.html
Hello! Great video and an excellent script. Question; When I export my image (PNG) the colors are slightly more muted than if I were to export via Quickly Export as PNG despite using the same Color Profile. Is there a reason for this? Am I doing something wrong on my end?
The script outputs PNG to sRGB color space (web standard, so the correct profile to use for "network" graphics, the N in PNG). The option to select otherwise is disabled. Are you comparing to same saved otherwise to sRGB profile? The "Quick Export to PNG" option is a black box. Not sure what it is doing, and there is no reliable means in script to get the same result. Not a simple matter of a method to call, for example. So if it is different, not much can done about it in script code to make it match.
@@wc7 Yeah, I was just comparing the saved PNGs from both methods and noticed the slight difference. Anyway, thank you for the response!
Nice sr
Thanks
@@wc7 Thanks sir, we wanted to tell you because you make scripts that everyone can use
Excellent, is it possible for Illustrator also?
Possible, but more complex because layers can have more than one text item. And a script isn't really needed for AI anyway (actually, most of this can be done in PS without a script as well, just not as simple to do). For doing nearly the same thing in AI without a script see this link: helpx.adobe.com/illustrator/using/data-driven-graphics-templates-variables.html
But that's not to say I won't make a script for AI also (someday) that is more to the point like this script is. Half the battle using Data Merge features in Adobe apps is figuring out the dialogs and choices to configure. The scripts I make I'm trying to simplify the choices so it's easier to get the same task done.
Thanks for this script. However, I have an issue I can't seem to solve. Whenever the text goes to two or more lines, the text moves up in the output. Is there a way to keep the text from moving up, or is it a bug in PS (it's an older version)?
Probably depends on if the text is single line or a text area. Try each and put in your own line breaks in the data if needed. It might be a result of the auto center vertically this script does, the desire of the original request. Check out a trial of the paid script that does not auto center vertically. That might give the result you want. th-cam.com/video/Ku2IZJmSadA/w-d-xo.html
When I left justify the text layer, it doesn't move. Does the paid script allow me to use the auto center vertically without the text moving up?
@@dmailerdude Yes that is how the script was designed to work (the original user request that inspired the script). Watch the video @ around 5:00 and after. This behavior is explained. And on the webpage for the script. Left and right does not shift the text vertically, whereas center positions the updated text to the prior vertical center. The paid script with additional features does not alter the text layer position in any way. It always stays where it begins. Again this behavior is from user requests. Users of the newer script Variable Images From CSV asked that the script NOT move text layers. No users have asked for otherwise, to re-position text layers center to the prior center of the placeholder text. If any buyers of Variable Images From CSV request that I add the option, I will certainly consider it. But free scripts I'm not likely to add further features.
Hi!! Super Great Script!! very useful in Sport Brodcast Graphics! Everything is working just fine!! I just have a question.. Can this Script can be used to turn on and off layers? For explae I am using for players statistics, but it would be great to turn on each olater photo per row on the excel file! can this be done? I was searching and view it is possible with Variables, but want to know if it is possible to do it with your Script? Great Work!!!! Thanks!!
Not this free script. I have another that does control layer visibility, and more.
www.marspremedia.com/software/photoshop/variable-images-from-csv
Excellent. Thank you for sharing. Is there a way to edit the text within a PS smart object? The goal is to use a smart object because we can apply consistent effects (e.g., warping) to the smart object while the script changes the underlying text. Just a thought. Thanks again.
-- Frank
I have not tried that yet. I will investigate. If it does work, I would update the paid script, but not the free one. That is still enough to get an idea of what can be done.
Yes - create a white layer above all, apply displacement map and change blend to multiple. Make sure text is center aligned
Thanks for the script! Unfortunately there was an error while running it.
It says that on Line 909: General Photoshop error occured. This functionality may not be available in this version of photoshop.
- Could not save as "cards2;text 1;..." because the file could not be found.
Could you pls help me with this problem?
What does your CSV file look like in a text editor? Is the delimiter a semicolon instead of comma? It seems maybe it is because your file name has semicolons in it, and looks like it's the header from the CSV. If your CSV uses semicolon not comma, be sure to switch the option to semicolon in the Data file section or the script won't work right. If that doesn't fix the problem we'll go from there.
@@wc7 Thanks for the fast response! The header looked like this: file name; layer; text; layer; text
I changed the option to semicolon but now there is a similar error message:
Line 772: General Photoshop error occured. This functionality may not be available in this version of photoshop. -
@@TheAries174 The new error is when reading the text alignment of the target layer. Are the text layers editable text? Not rasterized? The text layers have to be editable text layers. If that's not the problem, I'll need to see your files to figure out what the problem might be. Master image, CSV, etc. To continue further you can reach me through my website contact page: www.marspremedia.com/contact/
I changed the alignment in the psd-file and now it updates the text!
@@TheAries174 Great! Can you tell what the alignment was before, and what you changed it to? I'll see if I can repeat the error here and fix it so other users don't run into the same problem. Thank you for your feedback. It helps make better scripts.
👌👌👌👌
Thanks
@@wc7 well come sir
Is there a way to make the file name the same name as layer 1’s text?
Could be done. However I don't have time right now, and I'm not inclined to do so for a free script. I have made the source JSX available on the webpage so if anyone wants to edit the script for file name same as layer one name, go for it.
@@wc7turns out resolved the issue! Just made a formula on the excel file to make the example column = the text column.
For example, I made A3 =C3
You’re amazing!
Hello thank you sharing, I have multiple PSD file their content is different example name, and date, the details are not placed in the same position, can we do it as a batch process using the script, when I try to do this using action that now allows recording image ---variable ---define---and dataset, can u help me do this using script, base on CVS
my idea is this can not make using a template different image different variable
The script is not meant to use in an Action other than to make it easier to launch. It has its own interface and batch process, so there is no need to use batch automation on an Action containing the script, or involve any of the Photoshop variables/data set functionality. Use one or the other. The script is meant to work on its own.
@@wc7 can you tell me, I have 1.psd 2.psd.3.psd fils so their content is not the same with each, I want to change text Layer content, (when using formant defining Verible and dataset using CSV that does not match my aim ) , then text layer details will show in all in the same position, but my aim that text layer details are not same position
so how to fix this issue,
if not clear my issue please give me your contact details I'll send picture
@@mihira85 If using variables and data sets, scripts are not involved. Set up the data merge then use batch automation to output files. If text layer position varies, have separate text layers, one for each position. All blank content. Only insert content into the desired position for each variable/data set. Run batch automation with the corresponding data set on each PSD. This script Text Update From CSV can't do what you describe. After all, it is free. A script could be created to do this, but it will cost $$$ to customize and take time. Use tools in Photoshop at no extra cost. My contact info is on my channel page, contact tab.
@@wc7 I have around 500 PSD file one file have 3 layer , can we all covert to one file without merging 3 layer (I want keep that are separate) lord file in to stack not match me when using it all 3 later will merge
@@wc7 yes, corrct " If text layer position varies, have separate text layers, one for each position. All blank content. Only insert content into the desired position for each variable/data set. Run batch automation with the corresponding data set on each PSD. This script Text Update From CSV can't do what you describe" this is my issue,