Iterate through a data source, exporting one document per record

Iterate through a data source, exporting one document per record in the panel.

To install this script, navigate to the Adobe InDesign Application Directory and paste the script file into the following folder ‘Scripts -> Scripts Panel’. The script can then be run from the Scripts panel; this is found in ‘Window -> Utilities -> Scripts’.

#target InDesign
//EDIT THE VARIABLES BELOW BEFORE RUNNING SCRIPT
var datasourceName = "ENTER NAME OF DATASOURCE HERE";
var docName = "NAME OF FIELD CONTAINING DOCUMENT NAMING INFORMATION"; //For example a category field
var templateLocation = "PATH TO THE .INDT TEMPLATE FILE";
var scriptLabelName = "ENTER THE SCRIPT LABEL THAT REFERS TO THE PAGINATION TEXT FRAME";
var libraryLocation = "PATH TO THE LIBRARY FILE";
var outputLocation = "PATH TO OUTPUT LOCATION";

	app.scriptPreferences.userInteractionLevel = UserInteractionLevels.neverInteract;
	var myEC = app.easycatalogObject;
	var myDoc;
	if (myEC == null) 
	{
		$.writeln("myEC is null");
	}

	myDS = myEC.datasources.item(datasourceName);
	if (myDS != null)
	{
		var dvCount = myDS.dataviews.count();
		for (index = dvCount-1; index >= 0; index--)
		{
			myDS.dataviews.item(index).closeDataView();
		}


		var myDV = myDS.dataviews.add();

		if (myDV != null)
		{
			var RowCount=myDV.rowCount;
			for (var i = 1; i <= RowCount; i++)
			{

				myDV.makeSelection(i,i); 
				var myName = myDV.records.item(i-1).fields.item(docName).fieldContent;

				myDoc = app.open(File(templateLocation), true);

				if (myDoc != null)
				{
					var myInsertionPoint = myDoc.textFrames.item(scriptLabelName).insertionPoints[0];
					myDV.paginateIntoTextFlow(myInsertionPoint, libraryLocation);

					var fileName = outputLocation;

					if (i < 10) fileName += "0";
					fileName += i;
					fileName += " - ";
					fileName += myName;
					fileName += ".indd";

					myDoc.save(new File(fileName));
				}
				else
				{
					result =result + ("Error: Unable to open the source InDesign file " );
					myDoc = null;
				}

				myDoc.close();
			}

			myDV.closeDataView();
		}
	}
	else
	{
		$.writeln("unable to open datasource");
		myDoc = null;
		myEC = null;
	}

#target InDesign

//EDIT THE VARIABLES BELOW BEFORE RUNNING SCRIPT

var datasourceName = "ENTER NAME OF DATASOURCE HERE";

var docName = "NAME OF FIELD CONTAINING DOCUMENT NAMING INFORMATION"; //For example a category field

var templateLocation = "PATH TO THE .INDT TEMPLATE FILE";

var scriptLabelName = "ENTER THE SCRIPT LABEL THAT REFERS TO THE PAGINATION TEXT FRAME";

var libraryLocation = "PATH TO THE LIBRARY FILE";

var outputLocation = "PATH TO OUTPUT LOCATION";

app.scriptPreferences.userInteractionLevel = UserInteractionLevels.neverInteract;

var myEC = app.easycatalogObject;

var myDoc;

if (myEC == null)

{

$.writeln("myEC is null");

}

myDS = myEC.datasources.item(datasourceName);

if (myDS != null)

{

var dvCount = myDS.dataviews.count();

for (index = dvCount-1; index >= 0; index--)

{

myDS.dataviews.item(index).closeDataView();

}

var myDV = myDS.dataviews.add();

if (myDV != null)

{

var RowCount=myDV.rowCount;

for (var i = 1; i <= RowCount; i++)

{

myDV.makeSelection(i,i);

var myName = myDV.records.item(i-1).fields.item(docName).fieldContent;

myDoc = app.open(File(templateLocation), true);

if (myDoc != null)

{

var myInsertionPoint = myDoc.textFrames.item(scriptLabelName).insertionPoints[0];

myDV.paginateIntoTextFlow(myInsertionPoint, libraryLocation);

var fileName = outputLocation;

if (i < 10) fileName += "0";

fileName += i;

fileName += " - ";

fileName += myName;

fileName += ".indd";

myDoc.save(new File(fileName));

}

else

{

result =result + ("Error: Unable to open the source InDesign file " );

myDoc = null;

}

myDoc.close();

}

myDV.closeDataView();

}

else

{

$.writeln("unable to open datasource");

myDoc = null;

myEC = null;

}

Iterate through a data source, exporting one document per record

EasyCatalog Training

Whats new in 2023

Whats new in 2022

InDesign Automation Event

Start your free trial today