StephenWonfor

FMP 12 File Copy Strategy From Server 12

Discussion created by StephenWonfor on Mar 7, 2014
Latest reply on Mar 10, 2014 by StephenWonfor

Hi

 

A client has a database where we store 800+ images in open external storage.

I have learned that grabbing last db backup seems to orphan the images. They are in place but there seems to be a path failure.

 

Here's the GetAsText of the image...

 

remote:357-9064F.jpg

size:750,1000

DPI:300

JPEG:IMAGES/Dress/357-9064F.jpg

 

And here's the current path of the backup.

 

/Users/stephen/Work Databases/Bƒ/GownCenter/Hourly_2014-03-06_1620/Databases/Gown/RC_Data_FMS/GownCenter/Files/GownCenter/IMAGES/Dress/357-9064F.jpg

 

This leaves me with two options I can dream up:

 

1. Change the server hosted file to store the images internally and get a backup of that.

2. Write a script to llop through all the data records and InsertPicture

 

And there is likely this one:

 

3. // the right approach

 

I wonder what 3 might be...

 


Stephen

 

"Have no fear of perfection - you'll never reach it." --- Salvador Dali

Outcomes