Advanced Noob needs assistance

Anyone, especially newbies, asking for help with Photoshop Scripting and Photoshop Automation - as opposed to those contributing to discussion about an aspect of Photoshop Scripting

Moderators: Tom, Kukurykus

ValHallen

Advanced Noob needs assistance

Post by ValHallen »

Hey all.

I work as a TD for an animation company, and I'm in charge of the 2d Pipeline (Photoshop, Nuke, Sketchbook Pro). I'm currently re-writing the existing tools and workflows for a major software upgrade (Maya 2009 --> 2013 and CS5 --> CS6). I was wondering if someone on here could help me with some of questions. I wrote the existing tools for the pipeline (mainly automation and workflow), and now I want to be able to connect Photoshop to our studio database (Shotgun/SQL) as well as nail down a couple of other issues with the tools that have been a long running bugbear to the departments that use them. I have no problem coding in JS or Python, but as a self-taught coder (am actually an FX artist really) I have large gaps in my knowledge, especially in the area of best practise - seriously my scripts read a little like commodore 64 programs ... so anyways!

My questions are (and there maybe more later):

Is there any way to implement a connection to a SQL database without using the .bat file method? IE, can AJAX be used or a more direct connection be made through PHP or something?

Is there a way to run Python scripts from inside Photoshop? I'm not talking about a win32Com solution here, just a way to run our API scripts from inside Photoshop itself. I would like to be able to code in Python to match the studio workflow and force PS to use it.

What are zStrings? Are they just a way to load in stuff? I'm confused by these things.

Thanks in advance!

Professional AI Audio Generation within Adobe Premiere Pro - Download Free Plugin here

xbytor

Advanced Noob needs assistance

Post by xbytor »

ValHallen wrote:Is there any way to implement a connection to a SQL database without using the .bat file method? IE, can AJAX be used or a more direct connection be made through PHP or something?


There is a Socket API. Very raw, but the only real alternative to app.system(). AJAX and it's ilk do not work.


Is there a way to run Python scripts from inside Photoshop? I'm not talking about a win32Com solution here, just a way to run our API scripts from inside Photoshop itself. I would like to be able to code in Python to match the studio workflow and force PS to use it.


No direct Python support; Python via COM has been done in the past by others.

What are zStrings? Are they just a way to load in stuff? I'm confused by these things.


ZStrings are a mechanism to enable localization. There is some material on the subject in the JS Tools Guide PDF.
Unless you're going to be using an non-English version of PS, don't worry about it. Just copy/paste ZStrings when needed.