Frustrated again...trying to implement a duplicate removal script
directly from a FP Support document.

There is NO "Find All" option within ScriptMaker (.fp5)...see FP support
script lines below).

HELP! 

Thank you.

Eric

(Regarding)

Example step 5: Define the script
In ScriptMaker, define the Find Duplicates script.

Find All
Sort [Restore, No Dialog]
Go to Record/Request/Page [First]
Replace [No dialog, �Mark�, �""�]
Set Field[�Global�,�ClientID�]
Loop
Go to Record/Request/Page [Exit after last, Next]
If [�Global = ClientID�]
Set Field [�Mark�, �"X"�]
Else
Set Field [�Global�,�ClientID�]
End If
End Loop
Perform Find [Restore]

How about "Show All Records"?

Matt

Eric wrote:

> Frustrated again...trying to implement a duplicate removal script
> directly from a FP Support document.
> 
> There is NO "Find All" option within ScriptMaker (.fp5)...see FP
> support script lines below).
> 
> HELP! 
> 
> Thank you.
> 
> Eric
> 
> (Regarding)
> 
> Example step 5: Define the script
> In ScriptMaker, define the Find Duplicates script.
> 
> Find All
> Sort [Restore, No Dialog]
> Go to Record/Request/Page [First]
> Replace [No dialog, �Mark�, �""�]
> Set Field[�Global�,�ClientID�]
> Loop
> Go to Record/Request/Page [Exit after last, Next]
> If [�Global = ClientID�]
> Set Field [�Mark�, �"X"�]
> Else
> Set Field [�Global�,�ClientID�]
> End If
> End Loop
> Perform Find [Restore]



-- 

Matt Wills wrote:
> 
> How about "Show All Records"?

Thanks, but I tried this and it doesn't work.

Very frustrating ;-)

Eric

What do you mean "It doesn't work"? It is the only scriptstap that will find 
all the records.

And by the way: for a replace you don't need to go to the first record. A 
replace works where-ever you are and will replace the contents of all 
records in the current found set.

The you set the contents of the field Global, I presume the field Global is 
a global field. After that the field will contain RecordID so the IF would 
allways be true.

So I'm not entirely clear what it is you want to do. Please allso try to 
describe next time what it is you want to accomplish, that might help us to 
formulate an answer.

Ursus

"Eric" <nospam@xx.com> schreef in bericht news:43F8EC18.F7F30E89@xx.com...
> Matt Wills wrote:
>>
>> How about "Show All Records"?
>
> Thanks, but I tried this and it doesn't work.
>
> Very frustrating ;-)
>
> Eric 

"ursus.kirk" wrote:
> 
> What do you mean "It doesn't work"? It is the only scriptstap that will find
> all the records.

Sorry, I meant to say the script still doesn't work right using Show All
Records.

> The you set the contents of the field Global, I presume the field Global is
> a global field. After that the field will contain RecordID so the IF would
> allways be true.

From the FP Support document:

� A global field, called Global, to store the unique identification
while comparing records. Global should be the same data type as the
Client ID field.

My ClientID field (renamed & changed in the script accordingly) is a
text field, so I did what the instructions called for (made the data
type also text).

> So I'm not entirely clear what it is you want to do. Please allso try to
> describe next time what it is you want to accomplish, that might help us to
> formulate an answer.

I simply am trying to do what the FP Support document Script is supposed
to do.  Namely, put an "X" in the "Mark" field for any "Duplicate"
record found.  Then, I can manually purge any duplicates by doing a Find
= "X" in the "Mark" field *after* performing the script.

What is happening now, is that I get an Error Dialog after activating
the script, which says:

"There are no valid criteria in this request. Type a valid request
before clicking Find."  This makes no sense, because the Script itself
if *supposed* to be finding any duplicate records.  If I click
"Continue", the script finishes but the last record ClientID ends up
displaying in every record Global field, which is not the way it is
supposed to work.

In the document examples, I do, however, find the following to be
somewhat confusing and absent of specific instuction on how to do these
items:

> Example step 4: Store settings
> Store Sort and Find settings for the script.

> Sort: In Browse mode, choose Sort from the Mode menu. If fields appear in the Sort Order list, click Clear All. Click ClientID, choose > Ascending order, click Move, and then click Done.

> Find: Choose a layout that displays the Mark field. In Find mode, type and X into the Mark field, and then switch to Browse mode. (You don't > have to perform the find request.) 

I'm told to "Store Sort and Find settings for the script", but it makes
no sense to "Store" an "X" in the "Mark" field ***before*** running the
script.  It appears this info is for ***after*** the script has run,
when it is time to pull up any duplicate records.  I can find no viable
"Save" or "Store" button anywhere to "Store Sort and Find settings for
the script".  Very confusing Technical Support documentation for a
non-guru user!!!

I appreciate your assistance.

Eric

Here is more info from the FP Support document describing what this
script is *supposed* to do.

When you perform the Find Duplicates script:
1. It finds all records, and then sorts them by the ClientID field so
that records with the same Client ID are grouped together.

2. Starting with the first record, the script copies the value from the
ClientID field into the Global field.

3. The script goes to the next record and compares the value in ClientID
with the value in Global.

� If the values match, the record is a duplicate the script puts an X in
the Mark field .

� If the values don't match, FileMaker Pro copies the ClientID value
into Global. It doesn't change the Mark field.

4. The script repeats step 3 until it reaches the last record in the
file.

5. The script finds all records with an X in the Mark field, and then
displays the found set of the duplicate records.

Deleting the duplicate records
To delete the duplicate records you can manually delete the found set
using the Delete All command from the Mode menu after running the Find
Duplicates script. This way you can control the deleting of records
before making any mistakes. If your script works properly to find the
duplicate records you can add the Delete All command as the last step to
your script. This will automate the whole process for you.

I love how we've gone from "show all records doesn't work" to the fact 
that you don't understand how to store the find request and sort order.

Do your manual find and your manual sort.  Yes, find with the 'x' even 
if your results are no records.  Open your script in Scriptmaker, then 
click OK.  You will be asked whether you want to save or replace the 
stored Find and Sort commands.  You want to replace.  This will save 
into the script the manual find and sort you just did.

Or if you don't need to fully automate the process, you can take out the 
show all, sort and find from the script...in which case you need to 
start before running the step by doing a manual 'show all records' 
(CTRL-J / CMD-J) and a manual sort (by Client ID).  And then after the 
script runs, you can manually search for the 'X's.


Eric wrote:
> "ursus.kirk" wrote:
>> What do you mean "It doesn't work"? It is the only scriptstap that will find
>> all the records.
> 
> Sorry, I meant to say the script still doesn't work right using Show All
> Records.
>
> In the document examples, I do, however, find the following to be
> somewhat confusing and absent of specific instuction on how to do these
> items:
> 
>> Example step 4: Store settings
>> Store Sort and Find settings for the script.
> 
>> Sort: In Browse mode, choose Sort from the Mode menu. If fields appear in the Sort Order list, click Clear All. Click ClientID, choose > Ascending order, click Move, and then click Done.
> 
>> Find: Choose a layout that displays the Mark field. In Find mode, type and X into the Mark field, and then switch to Browse mode. (You don't > have to perform the find request.) 
> 
> I'm told to "Store Sort and Find settings for the script", but it makes
> no sense to "Store" an "X" in the "Mark" field ***before*** running the
> script.  It appears this info is for ***after*** the script has run,
> when it is time to pull up any duplicate records.  I can find no viable
> "Save" or "Store" button anywhere to "Store Sort and Find settings for
> the script".  Very confusing Technical Support documentation for a
> non-guru user!!!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Professional Solutions, Inc.    Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

Howard Schlossberg wrote:
> 
> I love how we've gone from "show all records doesn't work" to the fact
> that you don't understand how to store the find request and sort order.

No, part the problem is POORLY worded and ERRONEOUS FP Tech Support
Documentation.

> 1. "Find All" = "Show All Records"???  

#&^! A Beta Test QC failure, IMHO.  If the ****actual*** command is
"Show All Records", THAT is what should be listed. I understand the FP
guru users would perhaps not have a problem with this, and I did
"assume" they might be one and the same, but "assuming" things is a
very, very poor way to deal with faulty instructions.  Period.

> 2. "Sort: In Browse mode, choose Sort from the Mode menu."  

I still have not been able to find a "Mode" menu speifically named
"Mode" ;-

> Do your manual find and your manual sort.  Yes, find with the 'x' even
> if your results are no records.  Open your script in Scriptmaker, then
> click OK.  You will be asked whether you want to save or replace the
> stored Find and Sort commands.  You want to replace.  This will save
> into the script the manual find and sort you just did.

I had seen this dialog come up (for "Keep" or "Replace"), but nowhere in
the FP Tech doc did it specify this clearly, IMHO. My "assumption" was
that "Keep" would keep the desired Find & Sort I had done.  Surprise,
Surprise...it was the opposite.

> Or if you don't need to fully automate the process, you can take out the
> show all, sort and find from the script...in which case you need to
> start before running the step by doing a manual 'show all records'
> (CTRL-J / CMD-J) and a manual sort (by Client ID).  And then after the
> script runs, you can manually search for the 'X's.

I would prefer to fully automate the process, but now thanks to your
help, at least I can get *some* results.

If I sound like poorly written software documentation gives me a major
wedgie, you're right!

Thank you again.

Eric

Eric wrote:
>> 1. "Find All" = "Show All Records"???  
> 
> #&^! A Beta Test QC failure, IMHO.  If the ****actual*** command is
> "Show All Records", THAT is what should be listed.
 >
>> 2. "Sort: In Browse mode, choose Sort from the Mode menu."  
> 
> I still have not been able to find a "Mode" menu speifically named
> "Mode" ;-

In older versions (before FM 5), there was a 'Mode' menu and there was a 
'Find All'.  Sort is now found on the Records menu.  I'm not sure where 
you got the documentation you have been referring to, but there is an up 
to date version at 
<http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=3441>.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Professional Solutions, Inc.    Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

next time:

Loop
go run Outside for a couple of minutes
goto back to File
set Count = 1 to 10
exit Loop If ( Erik = Cooled Down a Little )
end loop

Better for your health
Better for us who only try to get you on your way.

Ursus


"Eric" <nospam@xx.com> schreef in bericht news:43F91FDB.6A67C0FF@xx.com...
> Howard Schlossberg wrote:
>>
>> I love how we've gone from "show all records doesn't work" to the fact
>> that you don't understand how to store the find request and sort order.
>
> No, part the problem is POORLY worded and ERRONEOUS FP Tech Support
> Documentation.
>
>> 1. "Find All" = "Show All Records"???
>
> #&^! A Beta Test QC failure, IMHO.  If the ****actual*** command is
> "Show All Records", THAT is what should be listed. I understand the FP
> guru users would perhaps not have a problem with this, and I did
> "assume" they might be one and the same, but "assuming" things is a
> very, very poor way to deal with faulty instructions.  Period.
>
>> 2. "Sort: In Browse mode, choose Sort from the Mode menu."
>
> I still have not been able to find a "Mode" menu speifically named
> "Mode" ;-
>
>> Do your manual find and your manual sort.  Yes, find with the 'x' even
>> if your results are no records.  Open your script in Scriptmaker, then
>> click OK.  You will be asked whether you want to save or replace the
>> stored Find and Sort commands.  You want to replace.  This will save
>> into the script the manual find and sort you just did.
>
> I had seen this dialog come up (for "Keep" or "Replace"), but nowhere in
> the FP Tech doc did it specify this clearly, IMHO. My "assumption" was
> that "Keep" would keep the desired Find & Sort I had done.  Surprise,
> Surprise...it was the opposite.
>
>> Or if you don't need to fully automate the process, you can take out the
>> show all, sort and find from the script...in which case you need to
>> start before running the step by doing a manual 'show all records'
>> (CTRL-J / CMD-J) and a manual sort (by Client ID).  And then after the
>> script runs, you can manually search for the 'X's.
>
> I would prefer to fully automate the process, but now thanks to your
> help, at least I can get *some* results.
>
> If I sound like poorly written software documentation gives me a major
> wedgie, you're right!
>
> Thank you again.
>
> Eric 

Eric <nospam@xx.com> wrote:

> Find All
> Sort [Restore, No Dialog]
> Go to Record/Request/Page [First]
> Replace [No dialog, "Mark�, """�]
> Set Field["Global�,"ClientID�]
> Loop
> Go to Record/Request/Page [Exit after last, Next]
> If ["Global = ClientID�]
> Set Field ["Mark�, ""X"�]
> Else
> Set Field ["Global�,"ClientID�]
> End If
> End Loop
> Perform Find [Restore]

I can't be bothered to boot into OS X and test the script, but shouldn't
it be 'if ClientID=Global'? 


Catja