July 16, 201213 yr I have a container field in a table that contains pictures that are linked only. I would like to make the file more portable by having the pictures embedded instead of linked as I don't always have network access to the server where the pictures are stored. I have tried to run a loop script that copies and pastes from the original container field into a new one but it only copies the link. Insert picture function dialogue box only seems to give you the option of adding a file path and not a field itself. Is there a way of doing this or will I need to do it manually?
July 16, 201213 yr In your looping script, use a variable as path for Insert Picture. For each loop iteration, set this variable dynamically to your stored file path.
July 16, 201213 yr Author use a variable as path for Insert Picture. Thanks for your reply, could you give me a little more info on how to do this please? I haven't got round to using variables yet.
July 16, 201213 yr Basically (meaning: without error trapping and the usual script paraphernalia) it looks like this: Go to Record/Request [ First ] Loop Set Variable [ $path ; Value: yourTable::imagePathField ] Go To Field [ yourTable::yourContainerField ] Insert Picture [ "$path" ] // that's how it shows in the script, but you write/insert the variable name without quotes. Also make sure to uncheck the Store only a reference option Go to Record/Request [ Next ; Exit after last ] End Loop Maybe best to experiment with a subset of a few records until you've got it right.
July 16, 201213 yr Author Basically (meaning: without error trapping and the usual script paraphernalia) it looks like this: Go to Record/Request [ First ] Loop Set Variable [ $path ; Value: yourTable::imagePathField ] Go To Field [ yourTable::yourContainerField ] Insert Picture [ "$path" ] // that's how it shows in the script, but you write/insert the variable name without quotes. Also make sure to uncheck the Store only a reference option Go to Record/Request [ Next ; Exit after last ] End Loop Maybe best to experiment with a subset of a few records until you've got it right. Thanks for the detailed explanation, I'll try it at work tomorrow.
Create an account or sign in to comment