script issue

Report · May 30, 2023

Hello 🙂 Is there anyway someone could help me fix a an exsisting indesign script that works, but has a bug?

The purpose of the script is orginaize large number of signs (pdf files) on a layout.
it scan all pdf files on a folder and orginize them like this:

תמונה ראשונה.jpg

The script creates one indesign file that includes all pdfs with the same prefix as links, while sorting them chronologically accoriding to the numbers on the prefix.
All filenames that has the prefix "r" are placed on the right side of the page.
All filenames that has the prefix "l" are placed on the left side of the page.
All filenames that has the suffix "_B" are placed on the right page accordingly, and mirrored (right turn into left and left turned into right, beacuse it represent the back side of the sign)

now the bug is that i have 2 versions of this script. each version works well with a certain project, while has some errors with another project.

i want to fix it so 1 version of the script will work with all projects.
note that "C10" is the newest version i have. it displays page numbers and i need to keep these pages numbering so try to stick to C10 version.

The error on C7 version is that it not displaying page numbers and also return error message when scanning some projects folders:

C7ERROR MESSAGE.jpg

But the layout on C7 is Good.

C7 ERROR.jpg

The error on C10 version is that all sign that turns right, (on the left page), moved beheind the signs that turns left.

Script ver C7.jsx:

var doc = app.documents.add();
var cellll
doc.documentPreferences.pageWidth = "1520mm";
doc.documentPreferences.pageHeight = "2000mm";
doc.documentPreferences.properties = { facingPages: true };
var rowHeig;
var margin = 50;
var extraWidth = margin*5;
var takeWidth = 0;
var myFolder = Folder.selectDialog("Select the PDFs folder");
var max_rows = 0;
if (!myFolder)

  exit(0);

var myFileList = myFolder.getFiles("*.pdf");

var fileName= myFileList[myFileList.length-1].name;
fileName = fileName.toString();
var regex = /^(\d*)_([A-Z]+\d*)_(\w+)\.pdf$/ ;
var match = regex.exec(fileName);
if (match == null){
  var regex = /^(\d*)_([A-Z]+\d*)\.pdf$/ ;
  var match = regex.exec(fileName);
}
var max = 0;
for (var i = 0; i < myFileList.length-1 ; i++) {
  var fileName= myFileList[i].name;
  fileName = fileName.toString();
  var regex = /^(\d*)_([A-Z]+\d*)_(\w+)\.pdf$/ ;
  var match = regex.exec(fileName);
  if (match == null){
    var regex = /^(\d*)_([A-Z]+\d*)\.pdf$/ ;
    var match = regex.exec(fileName);
  }if (match === null){

  }else {
    if ( parseInt(match[1]) > max){

      max = parseInt(match[1]);
    }
  }

}


for (var i = 1; i < max*2 +1 ; i++) {
  app.activeDocument.pages.add();
  var textFrame = app.activeDocument.pages.item(i).textFrames.add();
  textFrame.geometricBounds = [12.7, 12.7, 100, 50];


  textFrame.textFramePreferences.autoSizingReferencePoint = AutoSizingReferenceEnum.TOP_CENTER_POINT  ;
  textFrame.textFramePreferences.autoSizingType = AutoSizingTypeEnum.HEIGHT_ONLY  ; 

  var table = textFrame.tables.add();
  table.headerRowCount = 0;
  table.bodyRowCount = 10;
  table.columnCount = 2;
  table.rows.everyItem().autoGrow = true;
  table.rows.everyItem().maximumHeight = 2500
  table.columns.everyItem().autoGrow = true;
}

var regex = /^([A-Z]+)(\d+)$/;
var parts = match[2].match(regex);
var letter = parts[1];
var rowNum = parseInt(parts[2]) - 1;


// create a text frame


var extraPages=0;
var extraP = 0;
var checkA = 0;

var flag = 0;
var minusP =0;



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

  var fileName= myFileList[i].name;
  fileName = fileName.toString();
  var regex = /^(\d+)_([A-Z]+\d+)_(\w+)\.pdf$/ ;
  var match = regex.exec(fileName);

  if (match == null){
    var regex = /^(\d+)_([A-Z]+\d+)\.pdf$/ ;
    var match = regex.exec(fileName);
    flag =1
  }
  if(match == null){
   continue;
  }else if(flag == 1){
    match[3] = "F";flag =0;
  }

  var regex = /^([A-Z]+)(\d+)$/;
  var parts = match[2].match(regex);
  var letter = parts[1];
  var rowNum = parseInt(parts[2]) - 1;
  if(rowNum>max_rows){
    max_rows=rowNum+2;
  }
  var pageNum = parseInt(match[1])
  if (match[3] == "F"){
      pageNum*=2;
  }else{
    pageNum*=2;
    pageNum-=1;
  }
  if ( letter ==  "R"){
    var LR = 1;
  }else{
    var LR = 0;
  }
  if (match[3] == "F" ){
    if ( letter ==  "R"){
      var LR = 1;
    }else{
      var LR = 0;
    }
    }
    else {
      if ( letter ==  "R"){
        var LR = 0;
      }else{
        var LR = 1;
      }
    }



  var textFrame2 = app.activeDocument.pages.item(0).textFrames.add();
  
  var page = app.activeDocument.pages.item(pageNum);
  if (page && page.textFrames.length > 0) {
      var textFrame = page.textFrames.firstItem();
      if (textFrame && textFrame.tables.length > 0) {
          var table = textFrame.tables.firstItem();
          var page = app.activeDocument.pages.item(pageNum).textFrames.firstItem().tables.firstItem();
        } else {
          // text frame does not contain any tables
          continue; 
      }
  } else {
    continue;
  }
  var cellll = page.rows.item(rowNum).cells.item(LR);


  var pdfFrame = cellll.contents;
  textFrame2.place(myFileList[i]);
  textFrame2.fit(FitOptions.FRAME_TO_CONTENT);
  if(takeWidth == 0){
    takeWidth == 1;
    var docWidth = textFrame2.geometricBounds[3]-textFrame2.geometricBounds[1];
    app.activeDocument.documentPreferences.pageWidth = (docWidth*2)+ extraWidth;
    var test = app.activeDocument.pages.everyItem().textFrames.firstItem().tables.everyItem();
    test.columns.everyItem().width = docWidth;

    
  }
  cellll.contents = textFrame2;
  cellll.allGraphics[0].fit(FitOptions.FRAME_TO_CONTENT);
  


  rowHeig = table.rows.item(rowNum).height;

}

var occ = [];
//-------------------------------------------------------------
var oldNum =0
for (var i = 0; i < myFileList.length; i++) {
  var fileName= myFileList[i].name;
      fileName = fileName.toString();
  if(i>0 && match!=null){
    oldNum = parseInt(match[1])
    var oldpagenum = parseInt(match[1]);
  }
    var regex = /^(\d+)([A-Z])_([A-Z]\d+)_([A-Z]).(pdf)$/;
    var match = regex.exec(fileName);
    extraPages =1
    
  if (match != null){
    fefe = match[4];
    var rr = match[3];

  }


  if (match == null){
    var regex = /^(\d+)([A-Z])_([A-Z]\d+).(pdf)$/ ;
    var match = regex.exec(fileName);
    flag =1;
    if (match != null)
    var rr = match[3];
  }
  if (match == null){
    continue;}
  else if(flag == 1){
    var fefe = "F";flag =0;
  }
  var regex = /^([A-Z]+)(\d+)$/;
  var parts = rr.match(regex);
  var letter = parts[1];
  var rowNum = parseInt(parts[2]) - 1;
  if(rowNum>max_rows){
    max_rows=rowNum+2;
  }

//new pages
  if(parseInt(match[1]) != oldNum) {
    app.activeDocument.pages.add();
    if(oldNum == 0){
      occ.push(parseInt(match[1]))
    }else{
      occ.push(oldNum);

    }
  var textFrame = app.activeDocument.pages.lastItem().textFrames.add();
  textFrame.geometricBounds = [12.7, 12.7, 100, 50];


  textFrame.textFramePreferences.autoSizingReferencePoint = AutoSizingReferenceEnum.TOP_CENTER_POINT  ;
  textFrame.textFramePreferences.autoSizingType = AutoSizingTypeEnum.HEIGHT_ONLY  ; 
    var table = textFrame.tables.add();
  table.headerRowCount = 0;
  table.bodyRowCount = 10;
  table.columnCount = 2;
  table.rows.everyItem().autoGrow = true;
  table.rows.everyItem().maximumHeight = 2500
  table.columns.everyItem().autoGrow = true;
  app.activeDocument.pages.add();
  var textFrame = app.activeDocument.pages.lastItem().textFrames.add();
  textFrame.geometricBounds = [12.7, 12.7, 100, 50];


  textFrame.textFramePreferences.autoSizingReferencePoint = AutoSizingReferenceEnum.TOP_CENTER_POINT  ;
  textFrame.textFramePreferences.autoSizingType = AutoSizingTypeEnum.HEIGHT_ONLY  ; 

  var table = textFrame.tables.add();
  table.headerRowCount = 0;
  table.bodyRowCount = 10;
  table.columnCount = 2;
  table.rows.everyItem().autoGrow = true;
  table.rows.everyItem().maximumHeight = 2500
  table.columns.everyItem().autoGrow = true;

}




//new pages

 
  if ( letter ==  "R"){
    var LR = 1;
  }else{
    var LR = 0;
  }
  if (fefe == "F" ){
    if ( letter ==  "R"){
      var LR = 1;
    }else{
      var LR = 0;
    }
    }
    else {
      if ( letter ==  "R"){
        var LR = 0;
      }else{
        var LR = 1;
      }
    }



  var textFrame2 = app.activeDocument.pages.item(0).textFrames.add();
  var page = app.activeDocument.pages.lastItem();

  //alert(pageNum);


  if (page && page.textFrames.length > 0) {
      var textFrame = page.textFrames.firstItem();
      if (textFrame && textFrame.tables.length > 0) {
          var table = textFrame.tables.firstItem();
          var page = app.activeDocument.pages.lastItem().textFrames.firstItem().tables.firstItem();
          if(fefe != "F"){
            var page = app.activeDocument.pages.previousItem(app.activeDocument.pages.lastItem()).textFrames.item(0).tables.firstItem();
          }
        } else {
          // text frame does not contain any tables
          continue; 
      }
  } else {
    continue;
  }
  var cellll = page.rows.item(rowNum).cells.item(LR);


  var pdfFrame = cellll.contents;
  textFrame2.place(myFileList[i]);
  textFrame2.fit(FitOptions.FRAME_TO_CONTENT);
  if(takeWidth == 0){
    takeWidth == 1;
    var docWidth = textFrame2.geometricBounds[3]-textFrame2.geometricBounds[1];
    app.activeDocument.documentPreferences.pageWidth = (docWidth*2)+ extraWidth;
    var test = app.activeDocument.pages.everyItem().textFrames.firstItem().tables.everyItem();
    test.columns.everyItem().width = docWidth;

    
  }
  cellll.contents = textFrame2;
  cellll.allGraphics[0].fit(FitOptions.FRAME_TO_CONTENT);
  rowHeig = table.rows.item(rowNum).height;




}
for(var ee=0; ee < occ.length; ee++) {
  pageNum = occ[ee];
  
  var doc = app.activeDocument;
  var spread = app.activeDocument.spreads.lastItem();
  var destinationPage = app.activeDocument.spreads.item(pageNum);
  spread.move(LocationOptions.AFTER, destinationPage);
}
//------------------------------------------------

var doc = app.activeDocument;
var table = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 1; j < app.activeDocument.pages.length; j++) {
  var page = app.activeDocument.pages.item(j).textFrames.firstItem().tables.firstItem();
        for (var k = 0; k < page.rows.length; k++) {
          var cellll = page.rows.item(k).cells.item(0);
          var celllr = page.rows.item(k).cells.item(1);
       
          if(cellll.contents == "" || celllr.contents == ""){continue}
          var LEFTY = cellll.allGraphics[0].geometricBounds[2] - cellll.allGraphics[0].geometricBounds[0];
          var RIGHTY = celllr.allGraphics[0].geometricBounds[2] - celllr.allGraphics[0].geometricBounds[0];
          
          // compare the heights of the two columns and choose the higher height
          if(LEFTY>RIGHTY){
            cellll.allGraphics[0].fit(FitOptions.FRAME_TO_CONTENT);
         }else{
          celllr.allGraphics[0].fit(FitOptions.FRAME_TO_CONTENT);

         }
          
          }
     
}
var doc = app.activeDocument;

for (var i = 0; i < doc.stories.length; i++) {
  var story = doc.stories[i];
  for (var j = 0; j < story.tables.length; j++) {
    var table = story.tables[j];
    for (var k = table.rows.length - 1; k >= 2; k--) {
      var row = table.rows[k];
      var empty = true;
      for (var l = 0; l < row.cells.length; l++) {
        var cell = row.cells[l];
        if (cell.contents !== "") {
          empty = false;
          break;
        }
      }
      if (empty) {
        row.remove();
      }
    }
  }
}




var firstPage = app.activeDocument.pages.item(0);
var pageItems = firstPage.allPageItems;
for (var i = pageItems.length-1; i >= 0; i--) {
  pageItems[i].remove();
}

var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 0; j < tables.length; j++) {
  var table = tables[j];
  for (var i = 0; i < table.rows.length; i++) {
    var row = table.rows.item(i);
    if(row.cells.item(0).contents == "" && row.cells.item(1).contents == ""){
      
    row.autoGrow = false;
    row.height = rowHeig;
    }
  }
}

var doc = app.activeDocument;
var textFrames = doc.textFrames;
for (var i = 0; i < textFrames.length; i++) {
  var tf = textFrames[i];
  if ( i % 2 === 0 ){
    tf.geometricBounds = [12.7, margin+ margin, 1784.6, 200];
  }else{
    tf.geometricBounds = [12.7, margin + margin + (docWidth*2) + (margin*2) + (margin*2) + 0, 1784.6, margin + (docWidth*2) + (margin*2) + (margin*2) + extraWidth+200];
  }
}
var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 0; j < tables.length; j++) {
  var table = tables[j];
  for (var i = 0; i < table.rows.length; i++) {
    var row = table.rows.item(i);
    row.autoGrow = false;
    var height = row.height;
    row.height = height + 25;
  }
}

var colWid = app.activeDocument.pages.everyItem().textFrames.firstItem().tables.firstItem().columns.firstItem().width
//app.activeDocument.pages.everyItem().textFrames.firstItem().tables.firstItem().columns.firstItem().width = colWid[0] + (margin*2)
//app.activeDocument.pages.everyItem().textFrames.firstItem().tables.firstItem().rows.everyItem().cells.item(1).graphicLeftInset = 15;
var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var i = 0; i < tables.length; i++) {
  var table = tables[i];
  table.columns.firstItem().width = colWid[0] + (margin*2)
  // do something with the table
}
var doc = app.activeDocument;
for (var p = 0; p < doc.pages.length; p++) {
  var page = doc.pages.item(p).textFrames.everyItem();
  var tables = page.tables;
  for (var t = 0; t < tables.length; t++) {
    var table = tables.item(t);
    for (var r = 0; r < table.rows.length; r++) {
      var row = table.rows.item(r);
      for (var c = 0; c < row.cells.length; c++) {
        var cell = row.cells.item(c);
        cell.topEdgeStrokeWeight = "0 pt";
        cell.leftEdgeStrokeWeight = "0 pt";
        cell.bottomEdgeStrokeWeight = "0 pt";
        cell.rightEdgeStrokeWeight = "0 pt";      }
    }
  }
}

for(var i = 1; i < app.activeDocument.spreads.length; i++){
  for(var kek =0 ; kek<app.activeDocument.spreads.item(i).textFrames.length;kek++)    { 
  
                     var page = app.activeDocument.spreads.item(i).textFrames.item(kek);
                  var isPageEmpty = true;
                  for(var j = 0; j < page.tables.length; j++){
  
                      var table = page.tables.item(j);
                      for(var k = 0; k < table.rows.length; k++){
                          var row = table.rows.item(k);
                          for(var m = 0; m < row.cells.length; m++){
                              var cell = row.cells.item(m);
                              if(cell.contents != ""){
                                  isPageEmpty = false;
                                  break;
                              }
                          }
                          if(!isPageEmpty) break;
                      }
                      if(!isPageEmpty) break;
                  }
                  if(isPageEmpty) {app.activeDocument.spreads.item(i).remove();
                  i--;
                  }}
  
  
    } 


//-----------------------------------------------------------------------

for(var i = 1; i < app.activeDocument.pages.length; i++){

          var myDocument = app.activeDocument;
          var originalFrame = myDocument.pages[i].textFrames.item(0);
          var newFrame = originalFrame.duplicate();
          //originalFrame.tables.item(0).columns.item(1).remove();
          //newFrame.tables.item(0).columns.item(0).remove();
          var aaa = myDocument.pages[i].textFrames.item(1)
          var aaaa =myDocument.pages[i].textFrames.item(2)
          myDocument.pages[i].textFrames.item(0).tables.item(0).columns.item(1).remove();
          myDocument.pages[i].textFrames.item(1).tables.item(0).columns.item(0).remove();
          if ( i%2 == 0){
            aaa.geometricBounds = [aaa.geometricBounds[0], (margin*2) + docWidth + (margin*2), aaa.geometricBounds[2], aaa.geometricBounds[3]];
          }else{
            var dist = (margin*2) +docWidth+(margin*2)+docWidth+(margin*2)+docWidth+(margin*2);
            aaa.geometricBounds = [aaa.geometricBounds[0],dist, aaa.geometricBounds[2], dist+10];
          }
}




var doc = app.activeDocument;
var table = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 1; j < app.activeDocument.pages.length; j++) {
  for (var wew =0; wew<2 ; wew++){
  var page = app.activeDocument.pages.item(j).textFrames.item(wew).tables.item(0);
  var doc = app.activeDocument;
  var page = app.activeDocument.pages.item(j);
  var textFrame = page.textFrames.item(wew);
  var table = textFrame.tables.item(0);
  var rowss = table.rows.length;
        for (var k = 0; k < rowss-1; k++) {
          var cellll = table.rows.item(k).cells.item(0);
          if(cellll.contents == "" ){continue}
          cellll.allGraphics[0].fit(FitOptions.FRAME_TO_CONTENT);
        }
}
     
}


for(var i = 1; i < app.activeDocument.pages.length; i++){
  var myDocument = app.activeDocument;
  if(i%2 == 0){
    myDocument.pages[i].textFrames.item(0).geometricBounds = [12.7, margin*2  ,  12.7+5  ,margin*2+5 ]
    myDocument.pages[i].textFrames.item(1).geometricBounds = [12.7, margin*2+docWidth+margin*2  ,  12.7+5  ,margin*2+docWidth+margin*2+5]
  }else{
    myDocument.pages[i].textFrames.item(0).geometricBounds = [12.7, margin*2+docWidth+margin*2+docWidth+margin*2  ,  12.7+5  ,margin*2+docWidth+margin*2+docWidth+margin*2+5]
    myDocument.pages[i].textFrames.item(1).geometricBounds = [12.7, margin*2+docWidth+margin*2+docWidth+margin*2+docWidth+margin*2  ,  12.7+5  ,margin*2+docWidth+margin*2+docWidth+margin*2+docWidth+margin*2+5]
  }
  }

var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 0; j < tables.length; j++) {
  var table = tables[j];
  for (var i = 0; i < table.rows.length; i++) {
    var row = table.rows.item(i);
    row.autoGrow = false;
    var height = row.height;
    row.height = height + 25;
  }
}
if (app.activeDocument.pages.item(2).textFrames.item(0).tables.firstItem().columns.item(0).cells.firstItem().contents != "" ){
  var firstHeight = app.activeDocument.pages.item(2).textFrames.item(0).tables.firstItem().rows.firstItem().height;
}else{
  var firstHeight = app.activeDocument.pages.item(2).textFrames.item(1).tables.firstItem().rows.firstItem().height;
}

var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 1; j < doc.pages.length; j++) {
    if( app.activeDocument.pages.item(j).textFrames.item(0).tables.firstItem().rows.firstItem().cells.firstItem().contents == "" && app.activeDocument.pages.item(j).textFrames.item(1).tables.firstItem().rows.firstItem().cells.firstItem().contents == ""){
      app.activeDocument.pages.item(j).textFrames.item(0).tables.firstItem().rows.firstItem().height = firstHeight;
      app.activeDocument.pages.item(j).textFrames.item(1).tables.firstItem().rows.firstItem().height = firstHeight;
    }
}

var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 1; j < doc.pages.length; j+=2) {
    if( app.activeDocument.pages.item(j).textFrames.item(0).tables.firstItem().rows.firstItem().cells.firstItem().contents == "" && app.activeDocument.pages.item(j).textFrames.item(1).tables.firstItem().rows.firstItem().cells.firstItem().contents == ""){
      if( app.activeDocument.pages.item(j+1).textFrames.item(0).tables.firstItem().rows.firstItem().cells.firstItem().contents == "" && app.activeDocument.pages.item(j+1).textFrames.item(1).tables.firstItem().rows.firstItem().cells.firstItem().contents == ""){
        app.activeDocument.pages.item(j).textFrames.item(0).tables.firstItem().rows.firstItem().remove();
        app.activeDocument.pages.item(j).textFrames.item(1).tables.firstItem().rows.firstItem().remove();
        app.activeDocument.pages.item(j+1).textFrames.item(0).tables.firstItem().rows.firstItem().remove();
        app.activeDocument.pages.item(j+1).textFrames.item(1).tables.firstItem().rows.firstItem().remove();
        j-=2;
    }
}
}
for (var i =0;i< app.activeDocument.textFrames.length;i++){
  var bounds = app.activeDocument.textFrames.item(i).geometricBounds;
  if ( app.activeDocument.textFrames.item(i).overflows ) {
    app.activeDocument.documentPreferences.pageHeight  = max_rows*rowHeig+200 ;
    bounds[2] = (rowHeig)*max_rows+100;
    app.activeDocument.textFrames.item(i).geometricBounds = bounds;
  }  
  bounds[0] = 12.7;
  app.activeDocument.textFrames.item(i).geometricBounds = bounds;  
}
for (var i =0;i< app.activeDocument.textFrames.length;i++){
  var bounds = app.activeDocument.textFrames.item(i).geometricBounds;

  bounds[0] = 12.7;
  app.activeDocument.textFrames.item(i).geometricBounds = bounds;  
}
//-----------------------------------------------------------------------
exit(0);
var f = new Folder(myFolder+ '/Export/');
   	if (!f.exists)
        f.create();
	var docFile = new File(myFolder + "/" + "Export" + "/" + "Export" + ".indd");
	app.activeDocument.save(docFile);


	f = new Folder(myFolder+ '/Export/');
   	if (!f.exists)
        f.create();

var docFile = new File(myFolder + "/" + "Export" + "/" + "Export" + ".pdf");
var customPreset = app.pdfExportPresets.add("CustomPreset");
customPreset.exportReaderSpreads = true;

app.activeDocument.exportFile(ExportFormat.PDF_TYPE, docFile, false, customPreset);

Script ver C10.jsx:

var doc = app.documents.add();
var cellll
doc.documentPreferences.pageWidth = "1520mm";
doc.documentPreferences.pageHeight = "2000mm";
doc.documentPreferences.properties = { facingPages: true };
var rowHeig;
var margin = 50;
var extraWidth = margin*5;
var takeWidth = 0;
var myFolder = Folder.selectDialog("Select the PDFs folder");
var max_rows = 0;
var colWid;
var docWidth;
var col3Flag = 0;
var dispNum = [];
var maxHeight = 0;
if (!myFolder)

  exit(0);

var myFileList = myFolder.getFiles("*.pdf");

var fileName= myFileList[myFileList.length-1].name;
fileName = fileName.toString();
var regex = /^(\d*)_([A-Z]+\d*)_(\w+)\.pdf$/ ;
var match = regex.exec(fileName);
if (match == null){
  var regex = /^(\d*)_([A-Z]+\d*)\.pdf$/ ;
  var match = regex.exec(fileName);
}
var max = 0;
for (var i = 0; i < myFileList.length-1 ; i++) {
  var fileName= myFileList[i].name;
  fileName = fileName.toString();
  var regex = /^(\d*)_([A-Z]+\d*)_(\w+)\.pdf$/ ;
  var match = regex.exec(fileName);
  if (match == null){
    var regex = /^(\d*)_([A-Z]+\d*)\.pdf$/ ;
    var match = regex.exec(fileName);
  }if (match === null){

  }else {
    if ( parseInt(match[1]) > max){

      max = parseInt(match[1]);
    }
  }

}


for (var i = 1; i < max*2 +1 ; i++) {
  app.activeDocument.pages.add();
  var textFrame = app.activeDocument.pages.item(i).textFrames.add();
  textFrame.geometricBounds = [82.5, 12.7, 100, 50];


  textFrame.textFramePreferences.autoSizingReferencePoint = AutoSizingReferenceEnum.TOP_CENTER_POINT  ;
  textFrame.textFramePreferences.autoSizingType = AutoSizingTypeEnum.HEIGHT_ONLY  ; 

  var table = textFrame.tables.add();
  table.headerRowCount = 0;
  table.bodyRowCount = 10;
  table.columnCount = 2;
  table.rows.everyItem().autoGrow = true;
  table.rows.everyItem().maximumHeight = 2500
  table.columns.everyItem().autoGrow = true;
}

var regex = /^([A-Z]+)(\d+)$/;
if(match !=null){
var parts = match[2].match(regex);
var letter = parts[1];
var rowNum = parseInt(parts[2]) - 1;
} 

// create a text frame


var extraPages=0;
var extraP = 0;
var checkA = 0;

var flag = 0;
var minusP =0;



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

  var fileName= myFileList[i].name;
  fileName = fileName.toString();
  var regex = /^(\d+)_([A-Z]+\d+)_(\w+)\.pdf$/ ;
  var match = regex.exec(fileName);
  if (match == null){
    var regex = /^(\d+)_([A-Z]+\d+)\.pdf$/ ;
    var match = regex.exec(fileName);
    flag =1
  }
  if(match == null){
    flag =0;
   continue;
  }else if(flag == 1){
    match[3] = "F";flag =0;
  }
 
  dispNum.push(match[1]);
  var regex = /^([A-Z]+)(\d+)$/;
  var parts = match[2].match(regex);
  var letter = parts[1];
  var rowNum = parseInt(parts[2]) - 1;
  if(rowNum>max_rows){
    max_rows=rowNum+2;
  }
  var pageNum = parseInt(match[1])
  if (match[3] == "F"){
      pageNum*=2;
  }else{
    pageNum*=2;
    pageNum-=1;
  }
  if ( letter ==  "R"){
    var LR = 1;
  }else{
    var LR = 0;
  }
  if (match[3] == "F" ){
    if ( letter ==  "R"){
      var LR = 1;
    }else{
      var LR = 0;
    }
    }
    else {
      if ( letter ==  "R"){
        var LR = 0;
      }else{
        var LR = 1;
      }
    }



  var textFrame2 = app.activeDocument.pages.item(0).textFrames.add();
  
  var page = app.activeDocument.pages.item(pageNum);
  if (page && page.textFrames.length > 0) {
      var textFrame = page.textFrames.firstItem();
      if (textFrame && textFrame.tables.length > 0) {
          var table = textFrame.tables.firstItem();
          var page = app.activeDocument.pages.item(pageNum).textFrames.firstItem().tables.firstItem();
        } else {
          // text frame does not contain any tables
          continue; 
      }
  } else {
    continue;
  }
  var cellll = page.rows.item(rowNum).cells.item(LR);


  var pdfFrame = cellll.contents;
  textFrame2.place(myFileList[i]);
  textFrame2.fit(FitOptions.FRAME_TO_CONTENT);
  if(takeWidth == 0){
    takeWidth == 1;
    var docWidth = textFrame2.geometricBounds[3]-textFrame2.geometricBounds[1];
    app.activeDocument.documentPreferences.pageWidth = (docWidth*2)+ extraWidth;
    var test = app.activeDocument.pages.everyItem().textFrames.firstItem().tables.everyItem();
    test.columns.everyItem().width = docWidth;

    
  }
  cellll.contents = textFrame2;
  cellll.allGraphics[0].fit(FitOptions.FRAME_TO_CONTENT);
  


  rowHeig = table.rows.item(rowNum).height;
  flag = 0;
}

var occ = [];
//-------------------------------------------------------------
var oldNum =0
var alphaFlag =0 ;
var flagEnter = 0;
var oldAlpha = "wew";
for (var i = 0; i < myFileList.length; i++) {
  var fileName= myFileList[i].name;
      fileName = fileName.toString();
  if(i>0 && match!=null){
    if (    alphaFlag ==1){    oldAlpha = match[2]; flagEnter =1;}
    oldNum = parseInt(match[1])
    var oldpagenum = parseInt(match[1]);
  }
    var regex = /^(\d+)([a-zA-Z]+)_([A-Z]\d+)_([A-Z]).(pdf)$/;
    var match = regex.exec(fileName);
    extraPages =1
    alphaFlag =1
    
  if (match != null){
    fefe = match[4];
    var rr = match[3];

  }


  if (match == null){
    var regex = /^(\d+)([a-zA-Z]+)_([A-Z]\d+).(pdf)$/ ;
    var match = regex.exec(fileName);
    flag =1;
    alphaFlag =1;
    if (match != null)
    var rr = match[3];
  }
    if (match == null){
    var regex = /^([a-zA-Z]+)_([A-Z]\d+)_(\w+).(pdf)$/ ;
    var match = regex.exec(fileName);
    alphaFlag = 0
    if (match != null)
        var rr = match[2];
    flag =1;
  }if (match == null){
    var regex = /^([a-zA-Z]+)_([A-Z]\d+).(pdf)$/ ;
    alphaFlag = 0
    var match = regex.exec(fileName);
    if (match != null){
      var rr = match[2];
    }
  }
  if (match == null){
    continue;}
  else if(flag == 1){
    var fefe = "F";flag =0;
  }
  dispNum.splice(parseInt(match[1]), 0, (match[1]+match[2]));
  var regex = /^([A-Z]+)(\d+)$/;
  var parts = rr.match(regex);
  var letter = parts[1];
  var rowNum = parseInt(parts[2]) - 1;
  if(rowNum>max_rows){
    max_rows=rowNum+2;
  }

//new pages
  if(parseInt(match[1]) != oldNum  || (alphaFlag == 1 &&  match[2] != oldAlpha  )    )  {
    app.activeDocument.pages.add();
    if(oldNum == 0){
      occ.push(parseInt(match[1]))
    }else{
      occ.push(parseInt(match[1]));

    }
  var textFrame = app.activeDocument.pages.lastItem().textFrames.add();
  textFrame.geometricBounds = [82.5, 12.7, 100, 50];
  textFrame.textFramePreferences.autoSizingReferencePoint = AutoSizingReferenceEnum.TOP_CENTER_POINT  ;
  textFrame.textFramePreferences.autoSizingType = AutoSizingTypeEnum.HEIGHT_ONLY  ; 
  var table = textFrame.tables.add();
  table.headerRowCount = 0;
  table.bodyRowCount = 10;
  table.columnCount = 2;
  table.rows.everyItem().autoGrow = true;
  table.rows.everyItem().maximumHeight = 2500
  table.columns.everyItem().autoGrow = true;
  app.activeDocument.pages.add();
  var textFrame = app.activeDocument.pages.lastItem().textFrames.add();
  textFrame.geometricBounds = [82.5, 12.7, 100, 50];


  textFrame.textFramePreferences.autoSizingReferencePoint = AutoSizingReferenceEnum.TOP_CENTER_POINT  ;
  textFrame.textFramePreferences.autoSizingType = AutoSizingTypeEnum.HEIGHT_ONLY  ; 

  var table = textFrame.tables.add();
  table.headerRowCount = 0;
  table.bodyRowCount = 10;
  table.columnCount = 2;
  table.rows.everyItem().autoGrow = true;
  table.rows.everyItem().maximumHeight = 2500
  table.columns.everyItem().autoGrow = true;

}




//new pages

 
  if ( letter ==  "R"){
    var LR = 1;
  }else{
    var LR = 0;
  }
  if (fefe == "F" ){
    if ( letter ==  "R"){
      var LR = 1;
    }else{
      var LR = 0;
    }
    }
    else {
      if ( letter ==  "R"){
        var LR = 0;
      }else{
        var LR = 1;
      }
    }



  var textFrame2 = app.activeDocument.pages.item(0).textFrames.add();
  var page = app.activeDocument.pages.lastItem();

  //alert(pageNum);


  if (page && page.textFrames.length > 0) {
      var textFrame = page.textFrames.firstItem();
      if (textFrame && textFrame.tables.length > 0) {
          var table = textFrame.tables.firstItem();
          var page = app.activeDocument.pages.lastItem().textFrames.firstItem().tables.firstItem();
          if(fefe != "F"){
            var page = app.activeDocument.pages.previousItem(app.activeDocument.pages.lastItem()).textFrames.item(0).tables.firstItem();
          }
        } else {
          // text frame does not contain any tables
          continue; 
      }
  } else {
    continue;
  }
  var cellll = page.rows.item(rowNum).cells.item(LR);


  var pdfFrame = cellll.contents;
  textFrame2.place(myFileList[i]);
  textFrame2.fit(FitOptions.FRAME_TO_CONTENT);
  if(takeWidth == 0){
    takeWidth == 1;
    var docWidth = textFrame2.geometricBounds[3]-textFrame2.geometricBounds[1];
    app.activeDocument.documentPreferences.pageWidth = (docWidth*2)+ extraWidth;
    var test = app.activeDocument.pages.everyItem().textFrames.firstItem().tables.everyItem();
    test.columns.everyItem().width = docWidth;

    
  }
  cellll.contents = textFrame2;
  cellll.allGraphics[0].fit(FitOptions.FRAME_TO_CONTENT);
  rowHeig = table.rows.item(rowNum).height;




}
//app.activeDocument.spreads.item(1).remove()
var vount = 0;

var lount = 0;

var a3=0
for(var ee=occ.length-1; ee >= 0 ; ee--) {

    for(var uu=ee ; uu<=occ.length-1 ; uu++){
        if(  occ[ee]>occ[uu] ){
            lount++
        }
    }
        var pattern = /^[a-zA-Z]+$/;
    if (pattern.test(occ[ee])) {
      occ.splice(ee, 1);
      a3++;
      continue;
    }

  pageNum = occ[ee];
  var doc = app.activeDocument;
  var spread = app.activeDocument.spreads.item( app.activeDocument.spreads.length-1-a3    );
  var destinationPage = app.activeDocument.spreads.item(pageNum+1+lount);
  spread.move(LocationOptions.BEFORE, destinationPage);
}
//------------------------------------------------
var doc = app.activeDocument;

for (var i = 0; i < doc.stories.length; i++) {
  var story = doc.stories[i];
  for (var j = 0; j < story.tables.length; j++) {
    var table = story.tables[j];
    for (var k = table.rows.length - 1; k >= 2; k--) {
      var row = table.rows[k];
      var empty = true;
      for (var l = 0; l < row.cells.length; l++) {
        var cell = row.cells[l];
        if (cell.contents !== "") {
          empty = false;
          break;
        }
      }
      if (empty) {
        row.remove();
      }
    }
  }
}





var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for(var j=0; j< tables.length ; j++){
    var table = tables[j]
    var rowss = table.rows.length;
        for (var k = 0; k < rowss-1; k++) {
          var cellll = table.rows.item(k).cells.item(0);
          if(cellll.contents == "" ){continue}
          cellll.allGraphics[0].fit(FitOptions.FRAME_TO_CONTENT);
        }
}

var doc = app.activeDocument;
var textFrames = doc.textFrames;
for (var i = 0; i < textFrames.length; i++) {
  var tf = textFrames[i];
  if ( i % 2 === 0 ){
    tf.geometricBounds = [82.5, margin+ margin, 1784.6, 200];
  }else{
    tf.geometricBounds = [82.5, margin + margin + (docWidth*2) + (margin*2) + (margin*2) + 0, 1784.6, margin + (docWidth*2) + (margin*2) + (margin*2) + extraWidth+200];
  }
}

var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 0; j < tables.length; j++) {
  var table = tables[j];
  for (var i = 0; i < table.rows.length; i++) {
    var row = table.rows.item(i);
    row.autoGrow = false;
    var height = row.height;
    row.height = height + 25;
  }
}

var colWid = app.activeDocument.pages.everyItem().textFrames.firstItem().tables.firstItem().columns.firstItem().width
//app.activeDocument.pages.everyItem().textFrames.firstItem().tables.firstItem().columns.firstItem().width = colWid[0] + (margin*2)
//app.activeDocument.pages.everyItem().textFrames.firstItem().tables.firstItem().rows.everyItem().cells.item(1).graphicLeftInset = 15;
var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var i = 0; i < tables.length; i++) {
  var table = tables[i];
  table.columns.firstItem().width = colWid[0] + (margin*2)
  // do something with the table
}
var doc = app.activeDocument;
for (var p = 0; p < doc.pages.length; p++) {
  var page = doc.pages.item(p).textFrames.everyItem();
  var tables = page.tables;
  for (var t = 0; t < tables.length; t++) {
    var table = tables.item(t);
    for (var r = 0; r < table.rows.length; r++) {
      var row = table.rows.item(r);
      for (var c = 0; c < row.cells.length; c++) {
        var cell = row.cells.item(c);
        cell.topEdgeStrokeWeight = "0 pt";
        cell.leftEdgeStrokeWeight = "0 pt";
        cell.bottomEdgeStrokeWeight = "0 pt";
        cell.rightEdgeStrokeWeight = "0 pt";      }
    }
  }
}


//---------------------------------------------------------
for (var i = 0; i < myFileList.length; i++) {

  if(i>0 && matches!=null){
    var oldDir = parseInt(matches[1]);
  }
  var fileName= myFileList[i].name;
  fileName = fileName.toString();
  var regex = /^(\d+)_(\d+)(\w+)_(\d+)_(\w+)\.pdf$/;
  var matches = fileName.match(regex);
  //var firstGroup = matches[1]; // 24
  //var secondGroup = matches[2]; // 3rd_direction
  //var thirdGroup = matches[3]; // 1
  //var fourthGroup = matches[4]; // B
  //var fifthGroup = matches[5]; // pdf
  if (matches == null){
    var regex = /^(\d+)_(\d+)(\w+)_(\d+)\.pdf$/;
    if (matches != null)
    matches[4]="F";
    var matches = fileName.match(regex);
    flag =1
  }
  if(matches == null)continue;
  

  col3Flag = 1;
  var textFrame2 = app.activeDocument.pages.item(0).textFrames.add();
  vount = 0;
  for(var mo = 0;mo<occ.length;mo++){
    if(parseInt(matches[1]) > occ[mo]){
      vount++;
    }
  }
  if(matches[5] == "B"){
    pageNum = (parseInt(matches[1])+vount)*2-1

  }else{
    pageNum = (parseInt(matches[1])+vount)*2
  }
 

  var page = app.activeDocument.pages.item(pageNum);
 if ( app.activeDocument.pages.item(pageNum).textFrames.item(0).tables.firstItem().columns.length < 3 ){ 
  if ( app.activeDocument.textFrames.length > 0) {
      var textFrame = page.textFrames.item(0);
          //var table = textFrame.tables.firstItem();
          if(matches[5] == "B"){
            app.activeDocument.documentPreferences.pageWidth = (docWidth*2)+ extraWidth+margin*2+colWid[0];
            textFrame.tables.item(0).columns.add(LocationOptions.BEFORE,textFrame.tables.item(0).columns.item(0) )
            var page = textFrame.tables.firstItem();
          }else{
            app.activeDocument.documentPreferences.pageWidth = (docWidth*2)+ extraWidth+margin*2+colWid[0];
            textFrame.tables.item(0).columns.add(LocationOptions.AFTER,textFrame.tables.item(0).columns.item(1) )
            var page = textFrame.tables.firstItem(); ;
          }
          //var page = app.activeDocument.pages.item(pageNum).textFrames.item(1).tables.firstItem();

  } else {
    continue;
  }}
  rowNum = parseInt(matches[4]) - 1;
  var page = app.activeDocument.pages.item(pageNum);
  var textFrame = page.textFrames.item(0);
  var page = textFrame.tables.firstItem(); ;


  if(matches[5] == "B"){
  var cellll = page.rows.item(rowNum).cells.item(0);
  }else{  
  
  var cellll = page.rows.item(rowNum).cells.item(2);

  }
  var pdfFrame = cellll.contents;
  textFrame2.place(myFileList[i]);
  textFrame2.fit(FitOptions.FRAME_TO_CONTENT);

  cellll.contents = textFrame2;
  cellll.allGraphics[0].fit(FitOptions.FRAME_TO_CONTENT);

}

//-----------------------------------------------------------
for(var i = 1; i < app.activeDocument.spreads.length; i++){
  var page = app.activeDocument.spreads.item(i).textFrames.item(0);
  var isPageEmpty = true;
  for(var j = 0; j < page.tables.length; j++){
      var table = page.tables.item(j);
      for(var k = 0; k < table.rows.length; k++){
          var row = table.rows.item(k);
          for(var m = 0; m < row.cells.length; m++){
              var cell = row.cells.item(m);
              if(cell.contents != ""){
                  isPageEmpty = false;
                  break;
              }
          }
          if(!isPageEmpty) break;
      }
      if(!isPageEmpty) break;
  }

  var page = app.activeDocument.spreads.item(i).textFrames.item(1);
  var isPageEmpty2 = true;
  for(var j = 0; j < page.tables.length; j++){
      var table = page.tables.item(j);
      for(var k = 0; k < table.rows.length; k++){
          var row = table.rows.item(k);
          for(var m = 0; m < row.cells.length; m++){
              var cell = row.cells.item(m);
              if(cell.contents != ""){
                  isPageEmpty2 = false;
                  break;
              }
          }
          if(!isPageEmpty2) break;
      }
      if(!isPageEmpty2) break;
  }
  if(isPageEmpty && isPageEmpty2) {app.activeDocument.spreads.item(i).remove();
  
  
      i--;
  }
    } 


//-----------------------------------------------------------------------
for(var i = 1; i < app.activeDocument.pages.length; i++){

          var myDocument = app.activeDocument;

          var col3yes = myDocument.pages[i].textFrames.item(0).tables.item(0).columns.length;
          if(col3yes == 3){
            var originalFrame = myDocument.pages[i].textFrames.item(0);
            var newFrame = originalFrame.duplicate();
            var newFrame2 = originalFrame.duplicate();
            

          var aaa = myDocument.pages[i].textFrames.item(1)
          var aaaa =myDocument.pages[i].textFrames.item(0)
          if(col3yes == 3){
            var aaaaa = myDocument.pages[i].textFrames.item(2)
          }
          if (col3yes == 3){
            myDocument.pages[i].textFrames.item(0).tables.item(0).columns.item(0).remove();
            myDocument.pages[i].textFrames.item(0).tables.item(0).columns.item(0).remove();
            myDocument.pages[i].textFrames.item(1).tables.item(0).columns.item(1).remove();
            myDocument.pages[i].textFrames.item(1).tables.item(0).columns.item(1).remove();
            myDocument.pages[i].textFrames.item(2).tables.item(0).columns.item(0).remove();
            myDocument.pages[i].textFrames.item(2).tables.item(0).columns.item(1).remove();

          }else{
            myDocument.pages[i].textFrames.item(0).tables.item(0).columns.item(1).remove();
            myDocument.pages[i].textFrames.item(1).tables.item(0).columns.item(0).remove();
          }

          if ( i%2 == 0){
            aaaa.geometricBounds = [aaaa.geometricBounds[0], (margin*2), aaaa.geometricBounds[2], aaaa.geometricBounds[3]]
            aaa.geometricBounds = [aaa.geometricBounds[0], (margin*2) + docWidth + (margin*2), aaa.geometricBounds[2], aaa.geometricBounds[3]];
            if(col3yes == 3)
            aaaaa.geometricBounds = [aaaaa.geometricBounds[0], (margin*2) + docWidth + (margin*2) +docWidth+margin*2, aaaaa.geometricBounds[2], (margin*2) + docWidth + (margin*2) +docWidth+margin*2+10]
          }else{
            var dist = (margin*2) +docWidth+(margin*2)+docWidth+(margin*2)+docWidth+(margin*2)+margin*2+docWidth;
            aaaa.geometricBounds = [aaa.geometricBounds[0],dist, aaa.geometricBounds[2], dist+10];
            if(col3yes == 3)
            aaa.geometricBounds = [aaaaa.geometricBounds[0],dist+docWidth+margin*2, aaaaa.geometricBounds[2], dist+docWidth+margin*2+10];
          }
        }else{
          var myDocument = app.activeDocument;
          var originalFrame = myDocument.pages[i].textFrames.item(0);
          var newFrame = originalFrame.duplicate();
          //originalFrame.tables.item(0).columns.item(1).remove();
          //newFrame.tables.item(0).columns.item(0).remove();
          var aaa = myDocument.pages[i].textFrames.item(1)
          var aaaa =myDocument.pages[i].textFrames.item(0)
          myDocument.pages[i].textFrames.item(0).tables.item(0).columns.item(1).remove();
          myDocument.pages[i].textFrames.item(1).tables.item(0).columns.item(0).remove();
          var meme = (docWidth)*0
          if ( i%2 == 0){
            if(col3Flag == 1){
              aaa.geometricBounds = [aaa.geometricBounds[0], meme+(margin*2) + docWidth + (margin*2)  +docWidth+margin*2, aaa.geometricBounds[2], (margin*2) + docWidth + (margin*2)  +docWidth+margin*2+25+meme];
              aaaa.geometricBounds = [aaaa.geometricBounds[0], meme+docWidth+margin*2+margin*2, aaaa.geometricBounds[2], docWidth+margin*2+25+margin*2+meme];
            }else{
              aaa.geometricBounds = [aaa.geometricBounds[0], (margin*2) + docWidth + (margin*2), aaa.geometricBounds[2], aaa.geometricBounds[3]];
            }
          }else{
            if(col3Flag == 1){
              var dist = (margin*2) +docWidth+(margin*2)+docWidth+(margin*2)+docWidth+(margin*2)+docWidth+margin*2;
              aaa.geometricBounds = [aaa.geometricBounds[0],dist, aaa.geometricBounds[2], dist+10];
            }else{
              var dist = (margin*2) +docWidth+(margin*2)+docWidth+(margin*2)+docWidth+(margin*2);
              aaa.geometricBounds = [aaa.geometricBounds[0],dist, aaa.geometricBounds[2], dist+10];
            }

          }
        }

}



var doc = app.activeDocument;
var table = doc.stories.everyItem().tables.everyItem().getElements();
var keke =1;
for (var j = 1; j < app.activeDocument.pages.length; j++) {
  for (var wew =0; wew<keke ; wew++){
  /*if(app.activeDocument.pages.item(j).textFrames.length ==3){
    keke =2; 
  }*/
  var doc = app.activeDocument;
  var page = app.activeDocument.pages.item(j);
  var textFrame = page.textFrames.item(wew);
  var table = textFrame.tables.item(0);
  var rowss = table.rows.length;
        for (var k = 0; k < rowss-1; k++) {
          var cellll = table.rows.item(k).cells.item(0);
          if(cellll.contents == "" ){continue}
          cellll.allGraphics[0].fit(FitOptions.FRAME_TO_CONTENT);
        }
}
     
}
/*

for(var i = 1; i < app.activeDocument.pages.length; i++){
  var myDocument = app.activeDocument;
  if(i%2 == 0){
    myDocument.pages[i].textFrames.item(0).geometricBounds = [12.7, margin*2  ,  12.7+5  ,margin*2+5 ]
    myDocument.pages[i].textFrames.item(1).geometricBounds = [12.7, margin*2+docWidth+margin*2  ,  12.7+5  ,margin*2+docWidth+margin*2+5]
  }else{
    myDocument.pages[i].textFrames.item(0).geometricBounds = [12.7, margin*2+docWidth+margin*2+docWidth+margin*2+ docWidth+margin*2  ,  12.7+5  ,margin*2+docWidth+margin*2+docWidth+margin*2+ docWidth+margin*2+5]
    myDocument.pages[i].textFrames.item(1).geometricBounds = [12.7, margin*2+docWidth+margin*2+docWidth+margin*2+docWidth+margin*2+docWidth+margin*2   ,  12.7+5  ,margin*2+docWidth+margin*2+docWidth+margin*2+docWidth+margin*2+docWidth+margin*2 +25]
  }
  }*/
  var doc = app.activeDocument;
  var tables = doc.stories.everyItem().tables.everyItem().getElements();
  for(var j=0; j< tables.length ; j++){
      var table = tables[j]
      var rowss = table.rows.length;
          for (var k = 0; k < rowss-1; k++) {
            var cellll = table.rows.item(k).cells.item(0);
            if(cellll.contents == "" ){continue}
            cellll.allGraphics[0].fit(FitOptions.FRAME_TO_CONTENT);
          }
  }
var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 0; j < tables.length; j++) {
  var table = tables[j];
  for (var i = 0; i < table.rows.length; i++) {
    var row = table.rows.item(i);
    row.autoGrow = false;
    var height = row.height;
    row.height = height + 25;
  }
}
if (app.activeDocument.pages.item(2).textFrames.item(0).tables.firstItem().columns.item(0).cells.firstItem().contents != "" ){
  var firstHeight = app.activeDocument.pages.item(2).textFrames.item(0).tables.firstItem().rows.firstItem().height;
}else{
  var firstHeight = app.activeDocument.pages.item(2).textFrames.item(1).tables.firstItem().rows.firstItem().height;
}
var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 1; j < doc.pages.length; j++) {
  if( app.activeDocument.pages.item(j).textFrames.item(0).tables.firstItem().rows.firstItem().cells.firstItem().contents == "" && app.activeDocument.pages.item(j).textFrames.item(1).tables.firstItem().rows.firstItem().cells.firstItem().contents == ""){
    app.activeDocument.pages.item(j).textFrames.item(0).tables.firstItem().rows.firstItem().height = firstHeight;
    app.activeDocument.pages.item(j).textFrames.item(1).tables.firstItem().rows.firstItem().height = firstHeight;
  }
}
var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 1; j < doc.pages.length; j+=2) {
    //var table1 = app.activeDocument.pages.item(j).textFrames.item(0).tables.firstItem()
    //var table2 = app.activeDocument.pages.item(j).textFrames.item(1).tables.firstItem()

    //if (table1 === undefined && table2 === undefined) {
    if( app.activeDocument.pages.item(j).textFrames.item(0).tables.firstItem().rows.firstItem().cells.firstItem().contents == "" && app.activeDocument.pages.item(j).textFrames.item(1).tables.firstItem().rows.firstItem().cells.firstItem().contents == ""){
      if( app.activeDocument.pages.item(j+1).textFrames.item(0).tables.firstItem().rows.firstItem().cells.firstItem().contents == "" && app.activeDocument.pages.item(j+1).textFrames.item(1).tables.firstItem().rows.firstItem().cells.firstItem().contents == ""){
          if(app.activeDocument.pages.item(j).textFrames.item(0).tables.firstItem().rows.length >1){
          app.activeDocument.pages.item(j).textFrames.item(0).tables.firstItem().rows.firstItem().remove();
          app.activeDocument.pages.item(j).textFrames.item(1).tables.firstItem().rows.firstItem().remove();
          }
          if(app.activeDocument.pages.item(j+1).textFrames.item(0).tables.firstItem().rows.length >1){          
          app.activeDocument.pages.item(j+1).textFrames.item(0).tables.firstItem().rows.firstItem().remove();
          app.activeDocument.pages.item(j+1).textFrames.item(1).tables.firstItem().rows.firstItem().remove();
          }
          j-=2;
    }
    }
}

var firstPage = app.activeDocument.pages.item(0);
var pageItems = firstPage.allPageItems;
for (var i = pageItems.length-1; i >= 0; i--) {
  pageItems[i].remove();
}

if (app.activeDocument.pages.item(2).textFrames.item(0).tables.firstItem().columns.item(0).cells.firstItem().contents != "" ){
  var firstHeight = app.activeDocument.pages.item(2).textFrames.item(0).tables.firstItem().rows.firstItem().height-25;
}else{
  var firstHeight = app.activeDocument.pages.item(2).textFrames.item(1).tables.firstItem().rows.firstItem().height-25;
}
var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 1; j < doc.pages.length; j++) {
  if( app.activeDocument.pages.item(j).textFrames.item(0).tables.firstItem().rows.firstItem().cells.firstItem().contents == "" && app.activeDocument.pages.item(j).textFrames.item(1).tables.firstItem().rows.firstItem().cells.firstItem().contents == ""){
    app.activeDocument.pages.item(j).textFrames.item(0).tables.firstItem().rows.firstItem().height = firstHeight;
    app.activeDocument.pages.item(j).textFrames.item(1).tables.firstItem().rows.firstItem().height = firstHeight;
  }
}
var doc = app.activeDocument;
for (var j = 1; j < doc.spreads.length; j++) {
  var tables = doc.spreads.item(j).textFrames.everyItem().getElements();
  for(var i = 0; i < tables.length; i++){
      if(doc.spreads.item(j).textFrames.item(i).tables.firstItem().rows.firstItem().contents != ""){
        firstHeight = doc.spreads.item(j).textFrames.item(i).tables.firstItem().rows.firstItem().height ;
      }
  }
    for(var i = 0; i < tables.length; i++){
        if(doc.spreads.item(j).textFrames.item(i).tables.firstItem().rows.firstItem().contents == ""){
        doc.spreads.item(j).textFrames.item(i).tables.firstItem().rows.firstItem().height = firstHeight-25 ;
      }  }
}

var doc = app.activeDocument;



var tables = doc.stories.everyItem().tables.everyItem().getElements();
for(var j=0; j< tables.length ; j++){
    var table = tables[j]
    var rowss = table.rows.length;
        for (var k = 0; k < rowss-1; k++) {
          var cellll = table.rows.item(k).cells.item(0);
          if(cellll.contents == "" ){continue}
          cellll.allGraphics[0].fit(FitOptions.FRAME_TO_CONTENT);
        }
}

var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for (var j = 0; j < tables.length; j++) {
  var table = tables[j];
  for (var i = 0; i < table.rows.length; i++) {
    var row = table.rows.item(i);
    row.autoGrow = false;
    var height = row.height;
    row.height = height + 25;
  }
}
for(var i = 1 ; i< doc.spreads.length; i++){
    

    if(  doc.spreads.item(i).textFrames.item(1).tables.item(0).rows.length != doc.spreads.item(i).textFrames.item(2).tables.item(0).rows.length){
        continue;
    }


    for(var j = 0 ; j< doc.spreads.item(i).textFrames.item(0).tables.item(0).rows.length; j++){


        if(doc.spreads.item(i).textFrames.item(0).tables.firstItem().rows.item(j).cells.firstItem().contents == ""){   
            doc.spreads.item(i).textFrames.item(0).tables.firstItem().rows.item(j).height = doc.spreads.item(i).textFrames.item(1).tables.firstItem().rows.item(j).height;            
        }
        if(doc.spreads.item(i).textFrames.item(1).tables.firstItem().rows.item(j).cells.firstItem().contents == ""){
            doc.spreads.item(i).textFrames.item(1).tables.firstItem().rows.item(j).height = doc.spreads.item(i).textFrames.item(0).tables.firstItem().rows.item(j).height;            
        }
        if(doc.spreads.item(i).textFrames.item(2).tables.firstItem().rows.item(j).cells.firstItem().contents == ""){
            doc.spreads.item(i).textFrames.item(2).tables.firstItem().rows.item(j).height = doc.spreads.item(i).textFrames.item(3).tables.firstItem().rows.item(j).height;            
        }
        if(doc.spreads.item(i).textFrames.item(3).tables.firstItem().rows.item(j).cells.firstItem().contents == ""){
            doc.spreads.item(i).textFrames.item(3).tables.firstItem().rows.item(j).height = doc.spreads.item(i).textFrames.item(2).tables.firstItem().rows.item(j).height;            
        }
        if(doc.spreads.item(i).textFrames.item(3).tables.firstItem().rows.item(j).cells.firstItem().contents == "" && doc.spreads.item(i).textFrames.item(2).tables.firstItem().rows.item(j).cells.firstItem().contents == ""){
            doc.spreads.item(i).textFrames.item(2).tables.firstItem().rows.item(j).height = doc.spreads.item(i).textFrames.item(1).tables.firstItem().rows.item(j).height;            
            doc.spreads.item(i).textFrames.item(3).tables.firstItem().rows.item(j).height = doc.spreads.item(i).textFrames.item(1).tables.firstItem().rows.item(j).height;            
        }
        if(doc.spreads.item(i).textFrames.item(0).tables.firstItem().rows.item(j).cells.firstItem().contents == "" && doc.spreads.item(i).textFrames.item(1).tables.firstItem().rows.item(j).cells.firstItem().contents == ""){
            doc.spreads.item(i).textFrames.item(2).tables.firstItem().rows.item(j).height = doc.spreads.item(i).textFrames.item(2).tables.firstItem().rows.item(j).height;            
            doc.spreads.item(i).textFrames.item(3).tables.firstItem().rows.item(j).height = doc.spreads.item(i).textFrames.item(2).tables.firstItem().rows.item(j).height;            
        }
    }
}

//-----------------------------------------------------------------------

var doc = app.activeDocument;
var tables = doc.stories.everyItem().tables.everyItem().getElements();
for(var j=0; j< tables.length ; j++){
  for(var i=0; i< tables[j].rows.length; i++){
    if(tables[j].rows.item(i).height > maxHeight){
      maxHeight = tables[j].rows.item(i).height;
    }
  }

}
for (var i =0;i< app.activeDocument.textFrames.length;i++){
  var bounds = app.activeDocument.textFrames.item(i).geometricBounds;
  if ( app.activeDocument.textFrames.item(i).overflows ) {
    app.activeDocument.documentPreferences.pageHeight  = max_rows*maxHeight ;
    bounds[2] = bounds[0] + (maxHeight)*max_rows+100;
    
    app.activeDocument.textFrames.item(i).geometricBounds = bounds;
  }  
  bounds[0] = 82.5;
  app.activeDocument.textFrames.item(i).geometricBounds = bounds;  
}
for (var i =0;i< app.activeDocument.textFrames.length;i++){
  var bounds = app.activeDocument.textFrames.item(i).geometricBounds;

  bounds[0] = 82.5;
  app.activeDocument.textFrames.item(i).geometricBounds = bounds;  
}
flag = 0;


var unique = {};
// Loop through the array and add unique items to the object
for (var i = 0; i < dispNum.length; i++) {
  unique[dispNum[i]] = true;
}
// Create an array from the unique object properties
var result = [];
for (var key in unique) {
  result.push((key));
}

result.sort(function(a, b) {
  if(parseInt(a) == parseInt(b)){
    return a > b ? 1 : -1;
  }else{
    return parseInt(a) - parseInt(b);
  }
});


for(var i=0;i<result.length;i++){
  var mySpread = app.activeDocument.spreads.item(i+1); // replace 0 with the index of the spread you want
  var myTextFrame = mySpread.textFrames.add();
  myTextFrame.geometricBounds = [ 12.7,2178.368 ,12.7+53.3 ,   2178.368+108.8    ]
  myTextFrame.textFramePreferences.autoSizingReferencePoint = AutoSizingReferenceEnum.TOP_RIGHT_POINT ;
  myTextFrame.textFramePreferences.autoSizingType = AutoSizingTypeEnum.HEIGHT_AND_WIDTH  ; 

  myTextFrame.contents = result[i].toString();
  myTextFrame.textFramePreferences.textColumnCount = 1;
  myTextFrame.textFramePreferences.textColumnGutter = 0;
  myTextFrame.parentStory.appliedFont = "Verdana";
  myTextFrame.parentStory.fontStyle = "Bold"
  myTextFrame.paragraphs.everyItem().pointSize = 170;
  myTextFrame.paragraphs.everyItem().justification = Justification.RIGHT_ALIGN;  
}
//---------------------------------------------------------------------------
exit(0);
var f = new Folder(myFolder+ '/Export/');
   	if (!f.exists)
        f.create();
	var docFile = new File(myFolder + "/" + "Export" + "/" + "Export" + ".indd");
	app.activeDocument.save(docFile);


	f = new Folder(myFolder+ '/Export/');
   	if (!f.exists)
        f.create();

var docFile = new File(myFolder + "/" + "Export" + "/" + "Export" + ".pdf");
var customPreset = app.pdfExportPresets.add("CustomPreset");
customPreset.exportReaderSpreads = true;

app.activeDocument.exportFile(ExportFormat.PDF_TYPE, docFile, false, customPreset);

Here are the 2 scripts and 3 different projects for example:

https://e.pcloud.link/publink/show?code=kZfcfuZ4YerMNKNyd8rbO8zQ9blhbXDLSHk

am... thanks is adnace?

Report · May 30, 2023

Hi,

You may find more help isolating the part that is causing troubles. You are asking people to put a lot of energy in understanding your script and help debugguing. Many won't have that time 😉

Report · May 31, 2023

you're right, is it allowed to suggest paying for this help in this forum?

Report · Jun 01, 2023

I would suggest contacting the original author of the script to get swift help with little expenses. If you can't contact them due to any reason then you can search the forum for scripters and contact them via a personal message preferably

-Manan

Report · May 30, 2023

The first error you screen captured is happening because the variable match, which I assume is supposed to be an array of PDFs, is always returning null

var doc = app.documents.add();
var cellll
doc.documentPreferences.pageWidth = "1520mm";
doc.documentPreferences.pageHeight = "2000mm";
doc.documentPreferences.properties = { facingPages: true };
var rowHeig;
var margin = 50;
var extraWidth = margin*5;
var takeWidth = 0;
var myFolder = Folder.selectDialog("Select the PDFs folder");
var max_rows = 0;
if (!myFolder)

  exit(0);

var myFileList = myFolder.getFiles("*.pdf");

var fileName= myFileList[myFileList.length-1].name;
fileName = fileName.toString();
var regex = /^(\d*)_([A-Z]+\d*)_(\w+)\.pdf$/ ;
var match = regex.exec(fileName);

if (match == null){
  var regex = /^(\d*)_([A-Z]+\d*)\.pdf$/ ;
  match = regex.exec(fileName);
}
$.writeln(match)
//returns null

script issue

Photos