Participant

Answered

export histogram mean value for RGB to csv file

Forum|Forum|10 years ago
November 27, 2015
7 replies
3702 views

Hello,

I am trying to export the mean value of a selection that is shown in the histogram panel.

I need to collect this data point for many images and was hoping to create an action that would export this data point for an entire folder of images.

So far all I have been able to do is export the raw histogram data which I suppose I could calculate the mean value from there but it is a lot of additional steps.

Let me know if there is a solution I am overlooking.

Actions and scripting

This topic has been closed for replies.

Correct answer Stephen Marsh

SuperMerlin created some great scripts here:

sort bright photos from dark photos in bridge?

dobravoda

Participating Frequently

Can believe I ran into this, have you managed to do it? I need the exact same thing and I'm unfortunately not too keen on scripting. Thanks in advance if you even read this, since it's been 9 years 🙂

c.pfaffenbichler

Community Expert

I'm unfortunately not too keen on scripting.

What is this to indicate?

Did you try the Script/s @Stephen Marsh referenced?

dobravoda

Participating Frequently

Thanks for the reply, I'm pretty new to scripting.

Well yes, but I kept getting this message:
Error 1242: Illegal argument - argument 1
- File/Folder expected
Une: 19
-> open(fileList);

and couldn't find elaboration on how to fix this. So I tried to at least load one image with

which is finally working. But now the script runs and there's no mean value exported (see picture)

I thought an opened file would be recognized as an activeDocument, but somehow (I think) it's not:

Should I set the opened file to be the active document and how do I do that?

Here's the current state of my script (commented parts are still causing errors and I plan to deal with them later when I at least get the correct exported value to the CSV):

#target photoshop;

app.bringToFront();

main();

function main(){

//var inputFolder = Folder.selectDialog ("Please select folder");

//if(inputFolder == null) return;

//var fileList = inputFolder.getFiles(/\.(jpg|dng|tif|psd|crw|cr2|psb|exr|nef|dcr|dc2|erf|raf|orf|tga|mrw|mos|srf|pic|pct|pxr|pdd|pef|png|x3f|rw2)$/i);

var myFile = new File("D:/Projects/MASTER/VP/test/pas01.jpg");

var outFile = File(Folder.desktop +"/"+'TEST'+".csv");

outFile.open('w');

outFile.writeln("Filename,Mean Histogram");

//for(var a in fileList){

var myFileOpen = app.open(myFile);

//open(fileList);

//for (i=0; i<fileList.length; i++) {

// open(fileList);

// }

var area = activeDocument.histogram;

outFile.writeln(decodeURI(activeDocument.name)+ "," + mean(area).toFixed(0));

app.activeDocument.close(SaveOptions.DONOTSAVECHANGES);

//}

//outFile.close();

//alert("Process complete\nCSV created...\n" + decodeURI(outFile));

}

function mean(hist) {

var acc = 0;

var cnt = 0;

for (var i = 0; i < hist.length; i++) {

acc += i*hist;

cnt += hist;

}

return acc/cnt;

};

T

TALAL_M_ZAHID

Participant

Hi, did you have any luck finding a method to do it ? I am doing a research and came across your question. Thank you in advance

Stephen Marsh

Correct answer

Community Expert

SuperMerlin created some great scripts here:

sort bright photos from dark photos in bridge?

Stephen Marsh

Community Expert

With luck somebody can change the script in my previous post to output the mean histogram value for an RGB selection.

alantor08 if nobody else can help, then I have an alternative hack method that would allow you to get this value from a batch of imges into a CSV file. Copies of the images would first need to be cropped to the selection. Note, this would only be accurate to the nearest integer value and anything after the decimal point would slightly vary from Photoshop (for example if Photoshop reported 143.93, my hack would report 143.66, which I doubt would matter that much).

Another option would be to look into ImageJ:

imagej.nih.gov/ij/index.html

Process/Batch/Measure (then point it to a folder full of images), again the results would only be accurate to Photoshop to the nearest integer value.

Stephen Marsh

Community Expert

Somebody with the appropriate scripting knowledge may be able to change the following script:

https://forums.adobe.com/message/7246695

Stephen Marsh

Community Expert

https://www.adobe.com/uk/digitalimag/pdfs/ph_exportdata.pdf

Of course, the link in the PDF no longer works and I have not been able to track down the histogram.js for CS2.

EDIT: Another option here, however it is only for older versions of Photoshop and the numbers don’t exactly match Photoshop’s histogram…

Telegraphics - Free plugins for Photoshop & Illustrator...and other software

JJMack

Community Expert

You would need to write a Photoshop Script to do that. I adobe Photoshop Scripting Guide the is am example script the accesses the histogram. Scripts can also write to files and create a csv file.

Photoshop Extended also has the Statistics script that may help you to do what you want Photoshop Help | Image Stacks

measure Photoshop Help | Measurement