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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    ron n 
×

Important Information

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