Insert Picture

[Plucky]

Hi

I have a database layout that has a container field with a linked image.

The images have been stored on a networked drive that has now become corrupt. I have had to move the images folder to a new drive and have now found that the link between filemaker and the images folder is broken.

The old path is:

size:5129,3764

image:111614.pdf

imagemac:/fmserver_images/aug_07/111614.pdf

and the new path is:

size:5129,3764

image:111614.pdf

imagemac:/ContactS1/Groups/fmserver_images/aug_07/111614.pdf

is there a quick way of re-linking them to the new folder without having to go into each record and manually linking it as I have a few thousand records.

any ideas.

[Raybaudi]

Hi

create a NEW calculated field, result of type container, and calc:

Replace ( GetValue ( YourOldContainerField ; 3 ) ; 10 ; 0 ; "/ContactS1/Groups" )

When ( and IF ) you'll see ALL the images, we'll have to do another thing.

[IdealData]

Can you re-create the original directory structure and simply put the files in there?

If you are using OS X Server then you create the share point at any level.

[Mark Reed]

We use a calc to reference images for each record.

This way, if the location for the images changes, we just change the calc.

"imagewin:/R:/"&Print_Number & "_" & Publishers::Assigned_ftpfolder & ".jpg" is set as a calc field and set it to display as container type.

this keeps your FMP db leaner. If you have reasonable size images, meaning no huge billboard sized ones, response times should be ok.

[Plucky]

Hi

Thanks for the help everyone.

I've created a calc field like Daniele suggested and it works OK.

Regards

Peter