Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About pnelson

  • Rank
  1. Fenton, your solution works great for a single record at a time, however, I'm not figuring out how to batch geocode a Found Set of records using the same technique. Can you shed some light on this? I'd sure appreciate it.
  2. I've started looking at both responses and I can see ways to use each approach so once I've had time to digest this a bit more I'll try and report back and to contribute my results. In the meantime thanks so much for pointing out some techniques I had not thought of and was not familiar with. Per one reply, this would be the example of the source from the response URL: <?xml version="1.0"?> 42.742843-71.459653 389 Main StNashuaNH03060-5035US
  3. I'm trying to parse data using the Geocoding Web Service (from Google Maps or Yahoo Maps for example) to find the specific latitude and longitude for an address. The Request URL is formulated as follows: [color:purple]http://local.yahooapis.com/MapsService/V1/geocode It's easy enough to form a sample Request Url as follows: [color:purple]http://local.yahooapis.com/MapsService/V1/geocode?appid=[color:red]YD-9G7bey8_JXxQP6rxl.fBFGgCdNjoDMACQA--&street=701+First+Ave&city=Sunnyvale&state=CA using data from fields in FileMaker (note: [color:red]you need to apply for and sup
  4. I was hoping someone had already automated a procedure in FileMaker that would do that. I don't want to do manual lookups and I'd like a flexible way to handle the presentation of time zone information for any given record. Has anyone used the tz database via FileMaker to accomplish something along these lines? http://www.twinsun.com/tz/tz-link.htm If I do need to go to a web site to post and retrieve info, it's looking like the Troi URL plugin would work: http://www.troi.com/software/urldownload.html#dldNative
  5. Does anyone have a script that will look at address and/or phone number fields of a given record to lookup the correct time zone that record is in and then insert the current date and time? That would be very handy if you could share it. I saw a post (Post#262763 - http://www.fmforums.com/forum/showpost.php?post/262763/) on another thread showing how to calculate UTC time that was sort of on the right track minus a way to look up and/or calculate the UTC offets needed to figure out the right value for your given record. I also found a nice little Mac OS X app ( http://www.veladg.com/velaterra.
  6. To take this a bit further, is there a way to lookup a timezone (on the web or otherwise) using fields in your database (say city,state,zip, area code or phone number) and then return that timezone to FileMaker plus insert the correct UTC offsets to get the correct date and time for the current record you are viewing? That would be helpful to me. Are there any externals that do this that anyone knows of?
  7. This is basically what I ended up doing. Plus, I am aware of the dangers of using the Copy All to clipboard command, but that is implemented as a separate way to simply view the found set in a portal and since the found sets are likely to be small, I'm not expecting it to be a problem.
  8. Thanks for the help, but the way I have solved this is as follows. First off, I used some of the techniques offered up by Dwayne Wright on his blog post entitled Found Set in a Portal 2 What I did was create a portal for displaying all the records in a given found set. I added some global fields to count the number of records in the found set, and then created a loop script that basically just increments the counter as it moves through each record in the found set. During each pass it creates the child record for the parent ID that it is currently on. This seems to work OK and has th
  9. I'm not looking to export/import if I can help it. As a further example, I find 100 customers and plan to contact each one of them with a piece of mail (that Filemaker will generate and each piece will ultimately be customized to the individual customer record). So I want to automatically create a hundred transaction items all of which will be automatically created in with basic record content from the parent record, coded as a mailer transaction type, and then each individual transaction item will be further added to and customized one at a time as/if needed before they are printed and maile
  10. I'm looking for a streamlined way to script the creation of child records for a found set of records. Example: Perform a manual find on Customer table which yields a found set of Customers. Using that found set, automatically create one child record for each parent record (i.e., for each Customer, create a new related transaction/line item record. The script would end showing a list of all the child records created and their parent IDs. Apologies if there is a thread to this effect already - I couldn't find it.
  • Create New...

Important Information

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