kiwisilva

Hi SoCalMacDude, You should be able to accomplish this without a web viewer with TCPDirect plugin (www.fusionplugins.com/tcpdirect). It will allow you to send http request headers built up from filemaker data to a web server, and receive the response into filemaker where you will then be able to parse out the data you want using the various text functions. In order to do this you will also require another application which will allow you to view outgoing / incoming tcp packets on your network interface. If you are using a mac then check out the command line tool tcpflow (http://www.circlemud.org/~jelson/software/tcpflow/) which will display header information and received header/data on an interface you specify. So in other words what you would do is run tcpflow or an equivalent program, go into your web browser as usual and go to the URL, enter your code, hit submit etc, but check out everything thats happening underneath the hood, what the headers being sent/received are, and contain etc. Then using TCPdirect, rebuild the same thing by sending the same header, but only this time the information you receive will come into FileMaker, from there you can send more tcp requests, or parse out the data you require. The end result is quite elegant for a Filemaker database, no need for a web viewer, just a simple filemaker field where you enter your code, and a filemaker button attached to a script which handles the plugin function calls, and the data parsing.

You could always - before duplicating - set a number of local script variables to the fields you wish to copy through, then do your duplication, go to the duplicate, and set the desired fields to the relevant local variable. That way if you set 20 fields, rather than going back & forth 20 times you can do it in 1. That'll fix the freeze issue to a significant degree, but I also agree with the previous poster that its best to leave freeze/refresh in there as well.

I have to do a simimlar thing in a solution where I duplicate a set of around 10 records max. Rather than export/import i use a loop. I cannot paste the exact code right now but the premise is very simple, heres some psuedocode Go to found set of records you wish to duplicate. Set $counter to 1 Set $numRecords to get ( foundcount ) Go to first record Loop Go to record [ counter ] Duplicate record Omit record Set counter to itself + 1 Exit loop if $counter > $numRecords End Loop Bit messy, but duplicating a record adds it to the found set and takes you to that last record in the found set, so you need to keep track of where you were in the original found set and go back to that record + 1. You omit the duplicate to maintain the size of the original found count (altho this may not be necessary but I do it anyways). The reason I do this instead of export/import is if possible, I prefer to keep everything within the database and not have to export things to hard disk as if it is done without prompt there may be problems if paths become nonexistent, change etc.