Hello, I'm a FM newbie (I started working with it 10 days ago)

I have a DB (made by an other guy) that has a container field. This field contains for each record an embedded PDF file. I don't know the name of those files, I know just the container field name.

Is there a way to export those files into my filesystem?

THANKS and HAVE A NICE DAY!

Sig

Go to Record [First]

Loop

Set Variable [ $path; "filewin:/C:/" & GetAsText ( YourContainerField )]

Export Field Contents [ YourContainerField; $path ]

Go to Record [Next; Exit After Last ]

End Loop

This will save the files with their names in the C Directory.

Edited September 11, 200817 yr by Guest
added start record

I tried your script but I get the message below:

container field can't be exported.

Am I missing something?

THANKS

Here's a little file that exports a file to the Desktop.

Export_Container.fp7.zip

Thanks Fenton, your script is much more flexible than mine but basically it it the same so I guess my exporting issue is related to the fact that the DB I'm working with has been converted from FM6 and all the PDFs have been loaded using FM6. Is it possible?

I will try to export using FM6 if I find the installation CD.

Thanks again

Edited September 13, 200817 yr by Guest

It could not have an embedded "file" if it was inserted in FileMaker 6. Because FileMaker 6 did not support files in container files. So, it would have had to be inserted as a "picture", which is just the 1st page of the PDF file. If it was not "embedded", but inserted as a reference, and you still have the actual PDF files, then there's hope you could match them up somehow. If the PDF files were inserted in 6 as embedded, there's no way you can "reconstitute" a multi-page PDF file from that, AFAIK.

Unless it was inserted as an Object, which is a Windows-only technology, and I don't really know enough it to say what you've got.

Thanks again for your reply.

I haven't make it but I can guarantee that it is a FM6 DB with embedded PDFs. They are not pictures since if using FM6 you can open them on Acrobat Reader (but you can't using FM9)

It runs on Windows so I guess they have been loaded as a object.

I will play around on FM6 to see if I can export them.

Have a nice weekend.

In FM6 for windows, you could insert as an Adobe object, however I dont recall being able to export those out. I also dont think you will be able to do it in the convereted version of FM9 either.

You may have to resort to saving each one manually.

I have 660 records and a PDF for each one

I will try something before doing it manually.

THANKS