Looping Migrate

[Steven1337]

I was able to get the Migrate script to work using the tutorial in 360 works.

The migrate script is the one that transfers whatever image is in the container field and puts it in the SC field.

However, I have 23k records that need to be migrated...how would I go about creating a script that does this automatically for all records?

[Smef]

You will need to add a loop to the script that will upload a file and then go to the next record. This will repeat for all 23k records.

You will probably also want to add a script step at the beginning to go to the first record of the set to make sure that you don't miss any.

[Steven1337]

Yea I did that..it works but filemaker crashes every 80-90 records...idk what it could be

[shmert]

What version of SuperContainer are you running? There was a memory leak which we fixed over a year ago, I believe.

[Steven1337]

9/9/09 8:36:56 AM - SuperContainer version is 2.61

Is the latest one I believe...So I don't think that is the issue.

[Smef]

I spoke with another person at one point who had a similar problem to this one. His solution was to add a slight delay in his script to prevent the uploads from going so quickly, as they were bogging down his system. Try adding a small delay to your script and see if this resolves your issue.

[Steven1337]

Ok I added a half a second delay and that seems to have fixed it thanks alot.