Jump to content

Output only certain records from main mailing list based on second smaller list

Recommended Posts

I have a customer who wants to see about 30 variable proofs of his mailing piece.


I receive two list each month. The main mailing list that contains about 5,000 to 10,000 records with all the address information along with a ID number, and a second list of about 30 records that contains only the cooresponding ID number of the proofs he want to see.


Normally, I use Excel to compare the two lists, and flag the ID numbers for the proof records in the main list. Then I just delete all the other records that he doesn't want to see proofs for.


I was hoping that there would be a way to just compose only the records from the main list, by doing some kind of external reference rule to look at the second smaller list... but I havn't been able to find a method or instructions that work.


Any help would be much appreciated... Thanks!

Link to comment
Share on other sites

You can open up the second file with ExternalDataEx in OnJobStart, something like this:

var externalData = new ExternalDataEx("filename.txt", "\t"); // tab delimiter

Then you can do something like this in OnRecordStart:

FusionPro.Composition.composeThisRecord = externalData.FindRecord("ID", Field("ID")) > 0;

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...