Multiple Import Password Requests

[innodat]

Multiple import warnings

I have created an automated update routine (one script), which imports records from 23 tables in a single .fp7 file.

It used to be that I only had to enter the password for the file (from which the records are imported) ONCE, upon the first import. All the subsequent imports then run without any further passwords prompts... this no longer is the case. It now produces a dialogue for each import step, and I'm not sure what I changed that causes this.

Any ideas?

Thank you so much!

[fseipel]

Filemaker will attempt to use the password of the file running the script, to open the files the script references. So consider creating an account for that file, which is the same as the files it opens. Alternately, use a URL to open the files (this allows you to specify a password in the script but is a potential security issue). Or, prompt for the password in the script, then use a URL to open the files, and clear this field when done.

[innodat]

Thank you! Using the URL worked.

[jfcarbel]

I am trying to do the same but the URL is not working (at least how I am trying it). Can you post an example or explain in more detail how I do this.

I tried the following URLs and nothing opens:

fmp7://jfcarbel:[email protected]/CaseManagement.fp7

fmp7://jfcarbel:passwordhere@localhost/CaseManagement.fp7

fmp7://jfcarbel:passwordhere/CaseManagement.fp7

My file is actually located in:

C:/Documents and Settings/Administrator/My Documents/FM10_projects/CaseManagement.fp7

But with the URLs I tried placing the file in the Root C:/ directory and still nothing opened

The username and password is the same on both files, the target and the source. What's odd is that if I have the target file open after entering my user/password and then run a script with Open File step and point to the source file, it will open it with no prompts. I would like to achieve the same from the import script step, but not sure how to supply the filename as a URL that includes username and password and get it to work.

Edited July 19, 2009 by Guest

[innodat]

Try to start out the path with either

file:// OR file:///

[jfcarbel]

Do I include the password in that file:// path and where?

If I don't include the username and password in the path then how does it avoid the prompt?

[innodat]

In my solution, I actually needed the user to identify (once) before proceeding.

I'm not sure how to submit password and username in an URL to open a file... sorry!

[mr_vodka]

I am trying to do the same but the URL is not working (at least how I am trying it). Can you post an example or explain in more detail how I do this.

I tried the following URLs and nothing opens:

fmp7://jfcarbel:passwordhere@YOURHOST/CaseManagement.fp7

fmp7://jfcarbel:passwordhere@localhost/CaseManagement.fp7

This will not work as the files have to be shared using the fmnet protocol. If your files are being shared or served then you can use a method as such.

In your case, you should just have the account that you open the first file with in the second file as well. double check to see if you are running an opening script and if you are logging in automatically with a particular account. If you have a referred location to your second file and the account is the same in the second file, then you wouldn't be prompted twice.