OK Everyone...
Once again, I need to export formatted reports in PDF format, each with a filename that contains the patient number, the date of the report, and the type of report (echo).
I've converted the file to FMP12 (via FMP8, since once cannot import FMP6 files directly into FMP12).
Unless I am missing something, the Save Records as PDF script step does not allow me to give the exported PDF a unique file name.
I can export PDFs to a folder, but not individually with unique file names governed by a calculated field (iePatient no,date,echo).
I can give a PDF a unique Title derived from a calculated field, but the filename is always the same. If I create a multipage PDF, the title is that of the first report.
If I could give each pdf a unique file name that could be associated with the patient number and date in a separate table, that would be fine too.
I am really stuck here,
Any suggestions?
Jay
On Oct 19, 2012, at 7:31 PM, Steve Cassidy wrote:
> On 19 Oct 2012, at 23:29, Jay Erlebacher wrote:
>
>> Problem is this: There are 18,000 reports, and by the time I have converted 3750 of them, the file size reaches the maximum of 2gB and the script stops.
>>
>> Short of breaking up the job into 5 pieces, does anyone have any ideas on how to do this?
>> I have another file to convert that has 163,000 records, so breaking it up into that many pieces will be an issue.
>
> Jay
>
> You haven't said anything about how complex your database is, such as whether there are many related files, complex scripts, etc.
>
> If it is very simple, then just converting the whole thing to FMP12 should be very straightforward.
>
> Once converted, you can simply create a script that saves each record as pdf (using patient ID and date in the pdf filename).
>
> On the other hand, if the database is more complex then the conversion might be more problematic; you may find yourself spending some time fixing things prior to conversion (or, worse, after conversion). You'd probably want to read up on the conversion process; I assume old guides to the move from FMP6 to FMP7 are still around on the web (and these would pretty much hold for FMP6 to FMP12 as well).
>
> Whether that is a better route than dividing up the process you have already started is for you to decide.
>
> Steve
|