Hi,
I have a script that can move data from one unformatted table in one document to a formatted table in a second document. It works ok, but if I have a third document, then the script fails. I'm dealing with it with a clause that checks if there are 2 documents or not at the beginning of the script but I would like to be able to have a third document open for reference sometime so I want to modify the script. Don't laugh, it's an old script from Shane which I have adapted a bit.
--Table Data replace
--Use this script to replace data in a table already designed in ID CS4.
--You need two document opened, one with a table formatted and the other document with the table with the same number of columns and rows without formating. Select the part you want to replace in the first and the part you want to replace with in the other document and you're good to go.
--By Shane Stanley, from the ID Magazine issue 2.
--fixed number of rows and columns check that didn't work on 2013-03-25 by Jeff Lambert
tell application "Adobe InDesign CC 2019"
if number of document is not 2 then
beep
activate
display dialog "This script requires two documents open, with equivalent table areas selected." buttons {"OK"}
return
end if
set columnCount1 to count of columns of selection of document 1
set rowCount1 to count of rows of selection of document 1
set columnCount2 to count of columns of selection of document 2
set rowCount2 to count of rows of selection of document 2
if (rowCount1 is not equal to rowCount2) then
beep
activate
display dialog "The number of rows don't match." & return & " You have " & rowCount1 & " rows for the document in front vs " & return & rowCount2 & " rows for the document in back." buttons {"OK"}
return
else if (columnCount1 is not equal to columnCount2) then
beep
activate
display dialog "The number of columns don't match." & return & " You have " & columnCount1 & " columns for the document in front vs " & return & columnCount2 & " columns for the document in back." buttons {"OK"}
return
end if
display dialog "Which document contains the formatted table?" buttons {"Cancel", "Front", "Back"} default button 2
if button returned of result = "Back" then
set dataDocument to document 1
set formatDocument to document 2
else
set dataDocument to document 2
set formatDocument to document 1
end if
set ourData to contents of selection of dataDocument
set contents of selection of formatDocument to ourData
end tell
Here's the way I would like to work on this. Having 3 documents open, Document1 in window 1, Document 2 and 3 in a second window. Document 1 would be the active document, and document 3 would be in a hidden tab in window 2.
I don't want to have a dialog that asks which document is the front and the back from a list, it would be too long since I have hundreds of tables to do this way. Having a dialog with two buttons is enough and it defaults to the front-most which is how I usually work, I just hit enter and I'm good to go.
So, how can I deal with the top document in each window? I could have 4 documents or more if possible but still be able to run the script and the only document the script has to work with would be the top ones from each window, not the other tabs which are hidden. If there are more then two windows, it could just throw an error, that would be fine.
Thanks for any help!
12
Replies
Hi Jeff,
alright. Then we could look into every open document and see if and what actually is selected.
From your previous posts I understand that the target document is always the active one.
Where I am still unsure is:
In what order should the contents be applied.
Source cells selected:
Target cells selected:
Possible result A:
Possible result B:
FWIW: I think that something like that was already discussed years ago in the former InDesign Scripting Forum. With a solution. But I am not able to find the discussion again.
What I can offer for now is ExtendScript (JavaScript) code to discern the source selection from the target selection.
Also code that collects the unformatted content of the source and code to collect the target cells:
( function()
{
// Get all open documents:
var allOpenDocs = app.documents.everyItem().getElements();
// My assumption
// The target document is the one you clicked to the front in one of the layout windows:
var targetDoc = app.documents[0];
// In that document you did a selection of table cells.
// Either the whole table, all cells are selected, OR only some cells are selected:
var targetSelection = targetDoc.selection[0];
// Source selection is not known, we have to detect it:
var sourceSelection;
// Loop all documents but the top most with the target selection:
for( var n=1; n<allOpenDocs.length; n++ )
{
// The least we can do is to check if there is a selection with length 1.
// If the selection length is not 1 do nothing and continue the loop:
if( allOpenDocs[n].selection.length != 1 ){ continue };
// Next check if table cells are selected, when identified break the loop:
if( allOpenDocs[n].selection[0].hasOwnProperty("cells") )
{
sourceSelection = allOpenDocs[n].selection[0] ;
break;
};
};
// No source selection found, alert and do nothing:
if( sourceSelection == undefined ){ alert( "No target selection found. | SCRIPT " ); return };
// All unformatted contents of the source is stored in an array:
var sourceContentsArray = sourceSelection.cells.everyItem().contents;
// We identified the target selection, made sure that cells are selected.
// Store all selected cells in an array:
var targetCells = targetSelection.cells.everyItem().getElements();
}() )
Regards,
Uwe Laubender
( ACP )
AdChoices