OK, I have run into another roadblock. Maybe you all have some ideas.
To re-summarize, I have a large FMP6 database of one page medical
reports, that I want to export in the formatted form that I would
normally print.
I need to name the file of each exported report with the Patient
number and date of the report so that it can be imported into a
commercial electronic medical record program.
I have been able to run a script that copies each report in Preview,
and then pastes the report into a container field. The plan was to
export the container field and the date and Patient number fields into
FMP12 where I can export the reports with the above filename convention.
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.
On Oct 16, 2012, at 4:09 AM, Steve Cassidy wrote:
On 15 Oct 2012, at 12:55, Jay Erlebacher wrote:
Your advice seems very practical and do-able. Steve.
Jay
Since no-one has suggested other ways of doing what you want, I'll
add a couple of thoughts I've had:
– Conversion may not be completely straightforward; it's quite a big
jump from FMP6 to FMP12 and quite a lot of functions have changed in
small ways.
– If you decide to purchase a copy of FMP12 in order to complete
this task, you may still want to store images of your reports in a
container field BEFORE any conversion to FMP12. This will ensure
that the report is preserved exactly as seen in FMP6. (Or perhaps
you could take this as a fallback process in case you do see issues
when/after converting the full database.)
– If you take this approach, I'd suggest first exporting only the
data you need for the image export (ie the new image container and
the patient ID or whatever) to a new FMP6 file. This will be a
simple, uncluttered FMP6 file containing only these fields (and no
scripts, etc). Then you can convert this file to FMP12, where you
would prepare the export of images with suitable filenames. Your
main import of ordinary alphanumeric data to the new system would be
directly from FMP6.
– Make sure you keep secure backups of your data before doing any of
this. And also keep copies of the file(s) along the way, so you can
always go back a step without having to do everything again!
Steve
