Insert multi-page PDFs from Multi-line records

[mdlivels]

I have a sensitive mailing that has a multi-line data file (Excel) where the new record indicator is the National Provider Identifier (NPI) number. I have a rule created to pull in PDFs of ******* records (the filenames are IN the data exactly) of varying lengths, which is not the problem. My template consists of a cover sheet (with address block for the physician), common letter, followed by the ******* record. The problem is, I want to pull all of the patients that belong to a particular NPI, but when I process I only ever get one patient per NPI - even though the data contains many. How can I build this to loop through and include all patients? I can't share any of this data in order to help shed light, as it's protected health information.

[Dan Korn]

I have a sensitive mailing that has a multi-line data file (Excel) where the new record indicator is the National Provider Identifier (NPI) number. I have a rule created to pull in PDFs of ******* records (the filenames are IN the data exactly) of varying lengths, which is not the problem. My template consists of a cover sheet (with address block for the physician), common letter, followed by the ******* record. The problem is, I want to pull all of the patients that belong to a particular NPI, but when I process I only ever get one patient per NPI - even though the data contains many. How can I build this to loop through and include all patients?

If you're really using multi-line records, then you need to call the FusionPro.GetMultiLineRecords() function in a rule to get a ExternalDataFileEx object containing the lines of data for the record, then iterate through those records.

I can't share any of this data in order to help shed light, as it's protected health information.

Can you mock up some data in the same format?