FMPRO-L Archives

October 2012, Week 3

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Steve Cassidy <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Sat, 20 Oct 2012 00:31:30 +0100
Content-Type:
text/plain
Parts/Attachments:
text/plain (20 lines)
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

ATOM RSS1 RSS2