Problem occur when read CSV data!

[natrev]

Hi Everyone!,

I have an CSV file that contains file format data ( like screenshot). I need to read data from csv file and apply to save as option.

I am getting error "Boolean value expected" during the run time. Please suggest me or give the solution. your help much appreciated. -

-yajiv

Screenshot:

    var flg_LOADATA=[],TaskLst=[];
    main();
    function main(){
        var docRef = app.activeDocument;   
        var docName=(docRef.name).replace(/\.[^\.]+$/, '');
        var docPath=docRef.path;
        var Ext=docRef.name.split(".")[1];
        var TaskLst=LoadData(File("~/Desktop/Data.csv")); 
        TaskLst=TaskLst.toString().split(",");
        var alphaCh=TaskLst[1]; 
        var cProfile=TaskLst[2];
        var flgLayer=TaskLst[3];
        alert(alphaCh+"\n"+cProfile+"\n"+flgLayer);
        OutFoldPSD(docRef.path+"/PSD",docName+".psd",cProfile,alphaCh,Extension.LOWERCASE,flgLayer)
    }
    function LoadData(FilePath){
        flg_LOADATA.length=0;
        var flg_loadata="";
        var datafile = new File(FilePath);
        if (datafile.exists){ 
            datafile.open('r');
            while (!datafile.eof){
                strLineIn = datafile.readln();
                colArray = strLineIn.split(",");
                var fileFormat=trim(colArray[0]);
                if (fileFormat != "" && fileFormat !="Format"){
                    for(i=0;i<colArray.length;i++){
                        flg_loadata+=colArray+",";
                    }
                 flg_LOADATA.push(flg_loadata);
                 flg_loadata="";
                }//if loop
            }//While loop
            return flg_LOADATA;
        }//IF data exisist
    }
    function SavePSD(saveFile,cProfile,alphaCh,fCase,flgLayer){           
        psdSaveOptions = new PhotoshopSaveOptions(); 
        if(cProfile!=""){psdSaveOptions.embedColorProfile = cProfile;} //false
        if(alphaCh!=""){psdSaveOptions.alphaChannels = alphaCh;}  //false
        if(flgLayer!=""){psdSaveOptions.layers = flgLayer;}  //false
        activeDocument.saveAs(saveFile, psdSaveOptions, true, fCase); 
    }
    function OutFoldPSD(dnme,dn,cProfile,alphaCh,fCase,flgLayer){//PSD dnme,dn,cProfile,alphaCh,fCase Extension.LOWERCASE
        var outfolder = new Folder(dnme)
        if (outfolder.exists == false){
             outfolder.create();
             var saveFile = new File(outfolder + "/" + dn);
            SavePSD(saveFile,cProfile,alphaCh,fCase,flgLayer);}
        else{
            var saveFile = new File(outfolder + "/" + dn);
            SavePSD(saveFile,cProfile,alphaCh,fCase,flgLayer);}
    }
    function trim(str) {
        //return str.replace(/^\s+|\s+$/gm,'');
        try{return str.replace(/^\s+/,'').replace(/\s+$/,'');}catch(er){}
    } 

[JJMack · Accepted solution]

A quick guess in the CSV file use true not TRUE

 var flg_LOADATA=[],TaskLst=[];  
    main();  
    function main(){  
        var docRef = app.activeDocument;     
        var docName=(docRef.name).replace(/\.[^\.]+$/, '');  
        var docPath=docRef.path;  
        var Ext=docRef.name.split(".")[1];  
        var TaskLst=LoadData(File("~/Desktop/Data.csv"));   
        TaskLst=TaskLst.toString().split(",");  
        var alphaCh=TaskLst[1];   
        var cProfile=TaskLst[2];  
        var flgLayer=TaskLst[3];  
        alert(alphaCh+"\n"+cProfile+"\n"+flgLayer);  
     OutFoldPSD(docRef.path + "/PSD/", docName + ".psd", cProfile,alphaCh,Extension.LOWERCASE,flgLayer);  
     }  
    function LoadData(FilePath){  
        flg_LOADATA.length=0;  
        var flg_loadata="";  
        var datafile = new File(FilePath);  
        if (datafile.exists){   
            datafile.open('r');  
            while (!datafile.eof){  
                strLineIn = datafile.readln();  
                colArray = strLineIn.split(",");  
                var fileFormat=trim(colArray[0]);  
                if (fileFormat != "" && fileFormat !="Format"){  
                    for(i=0;i<colArray.length;i++){  
                        flg_loadata+=colArray+",";  
                    }  
                 flg_LOADATA.push(flg_loadata);  
                 flg_loadata="";  
                }//if loop  
            }//While loop  
            return flg_LOADATA;  
        }//IF data exisist  
    }  
    function SavePSD(saveFile, cProfile, alphaCh, fCase, flgLayer){    
        psdSaveOptions = new PhotoshopSaveOptions();   
        if(cProfile=="TRUE"|cProfile=="true"|cProfile==1) psdSaveOptions.embedColorProfile = true;
  else psdSaveOptions.embedColorProfile = false;
        if(alphaCh!="TRUE"|alphaCh!="true"|alphaCh!=1) psdSaveOptions.alphaChannels = true;
  else psdSaveOptions.alphaChannels = false;
        if(flgLayer!="TRUE"|flgLayer!="true"|flgLayer!=1)  psdSaveOptions.layers = true;
  else psdSaveOptions.layers = false;
        activeDocument.saveAs(saveFile, psdSaveOptions, true, fCase);
    }  
    function OutFoldPSD(dnme,dn,cProfile,alphaCh,fCase,flgLayer){//PSD dnme,dn,cProfile,alphaCh,fCase Extension.LOWERCASE  
        var outfolder = new Folder(dnme)  
        if (outfolder.exists == false){  
             outfolder.create();  
             var saveFile = new File(outfolder + "/" + dn);  
            SavePSD(saveFile,cProfile,alphaCh,fCase,flgLayer);}  
        else{  
            var saveFile = new File(outfolder + "/" + dn);  
            SavePSD(saveFile,cProfile,alphaCh,fCase,flgLayer);}  
    }  
    function trim(str) {  
        //return str.replace(/^\s+|\s+$/gm,'');  
        try{return str.replace(/^\s+/,'').replace(/\s+$/,'');}catch(er){}  
    }   

[natrev]

Thank you Mack, I did not think about that other side. Its working fine. - yajiv