Jump to content
Sign in to follow this  
K1200

How to automate update script?

Recommended Posts

I have a script that imports the contents of a dozen tables from the previous version of my application (I use the separation model) after I've made structure changes. The actual imports work fine.

My problem is this: even though I have the "run with full access" option set, the script pauses at each import and requests a login to access the previous application file.

How can I cause it to carry out the sequence of imports without me having to login twelve times? I tried adding a "Re-Login as Admin" script step before the series of imports, but that didn't change anything. I'm only using the Guest and Admin accounts at this point and either one works at the login prompts.

Any help will be greatly appreciated.

Share this post


Link to post
Share on other sites

You probably need to explicitly open the file first. Otherwise FileMaker will open only for import and close it immediately after that, so at the next step it will have to open it again. This is why it asks you several times for a password. Once you open a file using the Open File[] script step, it will remain open.

Share this post


Link to post
Share on other sites

Keep in mind that when importing from an open file, the found sets are considered. You should explicitly Show All Records in each table before importing their records.

Share this post


Link to post
Share on other sites

That worked!

Thanks for the help.

(P.S., I had already included the Show All step, based on my previous results)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.