Script won't auto populate information.

[AbsoluteVoice4u]

Whenever I import records, I have a script that automatically populates City, State and County upon seeing the zip code. Should the zip code not be present in the reference file, it populates all three areas with the letters URD (update relational database). All records show this whenever I import.

However, when I manually re-enter the zip code in each record, the correct corresponding City State and County show up, as if by magic. Any help on where I've gone astray with either my relational database(s) or scripting?

When I use a script to re-enter the zipcode in each record, I still get URD populated in each of the three fields. Woe is me.

It seems as if there's two different relational databases at work here. Any thoughts will be greatly appreciated. It's driving me wacko!

[bcooney]

"I have a script that automatically populates City, State and County upon seeing the zip code."

Why a script? Why not just a relationship to the ZipCode table or a Lookup to ZipCode table?

On Import, you will see a checkbox about running Auto-enter options, it must be checked.

Let's see the script, but all you need is a relationship to the ZipCode table.

[AbsoluteVoice4u]

Good question......I did set up a relationship and I have all three set to automatically pull the data from the database that has the information....but it won't pull the information. When I manually enter a zip code, then it populates correctly......it's plain weird.....any suggestions?

[Søren Dyhr]

The most likely is what Barbara suggest have been ignored:

you will see a checkbox about running Auto-enter options, it must be checked

--sd

[bcooney]

"I did set up a relationship and I have all three set to automatically pull the data from the database that has the information"

How? Through a lookup? If so, as Soren nicely restates, you need to check the Auto-enter on Import.

[AbsoluteVoice4u]

Ok I do have that checked..............my question is.........when I retype the zipcode in the field, all three areas populate with the correct info.....but.....when I have a script go through all the records and retype each zipcode, nothing changes?....

Script does the following

loop

Copy zip (select all)

paste zip ( replace all)

end loop (at last record exit loop)

any thoughts?

[Søren Dyhr]

Literally won't your script do much, without a:

http://fmhelp.filemaker.com/fmphelp_10/en/html/scripts_ref1.36.19.html

...which probably just is an omission. But an issue could be that the autoenter not is set to update, this turns them into a oneshot.

There is however an issue, why do you involve the operating system, copy and paste should be reserved for traffic in and out of other applications. Why do you think there is provisions with these at all?:

http://fmhelp.filemaker.com/fmphelp_10/en/html/scripts_ref1.36.39.html

http://fmhelp.filemaker.com/fmphelp_10/en/html/scripts_ref1.36.54.html

http://fmhelp.filemaker.com/fmphelp_10/en/html/scripts_ref1.36.55.html

http://fmhelp.filemaker.com/fmphelp_10/en/html/scripts_ref1.36.40.html

...well a problem, is that copy and paste might overwrite other trafic between 3rd and 4th party tools, imagine you have a picture of you loved ones in the OS pasteboard, the phone rings and a client makes you fire the script in filemaker - where did the picture go? The commands I've just listed above, doesn't tamper with anything outside the filemaker realm.

--sd

[bcooney]

You haven't answered my question, "How? Through a lookup?" or an auto-enter calc?

[AbsoluteVoice4u]

Yes...the (go to next record) step was an omission...I had that in the script.

Hmmm...copy and paste reserved for traffic outside the database? That's something I need to correct immediately. Thank you. I'll look over the links you gave. You're a plethora of help....everyone on here is great.

I still can't understand why I can manually re-enter the zipcode and the city, state & county populate correctly....yet when I have the script cut and paste the zipcode for each record, it seems to be looking up the info from some other database.

[Søren Dyhr]

And we need to know the nature of the either lookups or autoenters involved, to understand you problem better ... until that are you on your own I'm afraid.

Provisions could be made by making an upload of a clone file, with an indication of which reluctant to "obey"

--sd