Jump to content


  • Posts

  • Joined

  • Last visited

amgdba's Achievements


Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. "it only encompasses a relatively small number of cities" is putting it kindly. One would think with all the money they pour into these organizations, they might pay someone to do the calcs for more than 15+ some odd metro areas. Thanks for the vendor link. I'll check them out.
  2. I am trying to find a site that has a downloadable list, or at the very least a screen scrape-able, list of percent modifiers for calculating cost of living between major US cities. I have been to the BLS and spent a lot of time trying to find some "modifier" value list based upon standard CPI values, but I can find no such beast, and what is there is really not useful for doing the conversions. Does anybody know of a website that has a list of values one could use to perform calcs to determine the cost of living between metropolitan areas?
  3. FilemakerData has added 2 new files to its library. Programming Languages is a list of officially recognized programming languages. California Municipal Tax Codes (2009) is list of all tax rates for all municipalities in the state of California for the year of 2009. (Special thanks to Katherine Kayne of Dynamic Business Solutions for this list. You can visit DBS at www.adynamicsolution.com) Don't forget, we want your files too, so if you have a file you want to submit simply send it to the contact link fmdata@cox.net. ALERT! FileMakerData is still in need of a content expert for the periodic table file. If you are knowledgeable in chemistry and would like to help clean it up, email fmdata@cox.net to get started. You name and company will be posted with a link on the site and will also be included in the download file as well for free. Speaking of free, we are still committed to staying free and all files are available free of charge, so please come on by and take a look. www.filemakerdata.org
  4. amgdba


    I am searching for a xslt template for craigslist.com feeds. I have tried to get my head around the RDF tags but my limited time just hasn't been enough to decipher how to do this. Does there exist a good example for FileMaker to import craigslist feeds? Thanks in advance for any help.
  5. I found the issue outside of the XSLT. So I had two, you fixed one. Thanks again, your help saved me a couple or more hours of wasting time trying to discern the issue with the XSLT.
  6. Thank you Fenton, I have made the change though and I still get a NetAccessorException error. I am going to send a file to you back channel. Maybe there is something wrong with it and I'm just not giving all the right details.
  7. I have given up on Google Directions, as it works, but only sometimes, due to the query limit and the domain that I am using. I switched to MapQuest and I get a result everytime, but only in my browser. I have an XSLT stylesheet and FM accepts it at first, even lets me specify the import order, but when it comes time to import, it fails. I have a file: directions.fp7 - field: narrative (text) I have a MapQuest key: lalalala(obviously an example), and I have the wildcard setup in the API key account so it shouldn't care which domain is requesting it. I have an XML Data Source: "http://www.mapquestapi.com/directions/v1/route?key=lalalala&from=" & directions::start & "&to=" & directions::stop & "&callback=renderNarrative&outFormat=xml" - that looks like this when compiled: http://www.mapquestapi.com/directions/v1/route?key=lalala&from=8401 W Monroe St , 85345&to=6350 W Glendale Ave, 85301&callback=renderNarrative&outFormat=xml I have an xslt: mqdirect.xsl <?xml version="1.0" encoding="UTF-8"?> 0 -which returns: <?xml version="1.0" encoding="UTF-8" ?> - - 0 - © 2010 MapQuest, Inc. © 2010 MapQuest, Inc. - 4c30ab07-02f7-0000-02b7-4463-001ec93cd079 - raw -1.0 0 text true true true true false false 0 FASTEST en_US M true - - 33.577758 -112.239822 - 33.538311 -112.196098 4.315999984741211 500 00:08:20 - - 4.316 500 00:08:20 0 - - - 33.577331 -112.239822 0.375 81 00:01:21 0 2 8 Start out going EAST on W MONROE ST toward N 84TH AVE. East 0 - W MONROE ST - - <img src='<img src='http://content.mapquest.com/mqsite/turnsigns/rs_right_sm.gif' alt='' class='ipsImage' >' alt='' class='ipsImage' ></p><p> - - http://www.mapquestapi.com/staticmap/v3/getmap?type=map&size=225,160&pois=purple-2,33.577331,-112.239822,0,0|purple-3,33.577758,-112.233421,0,0|&center=33.5775445,-112.23662150000001&zoom=12&key=Fmjtd|luu7206r2q,8n=o5-5y10u&rand=-1047336837&session=4c30ab07-02f7-0000-02b7-4463-001ec93cd079</p><p> - - 33.577758 -112.233421 2.495 203 00:03:23 0 2 5 Turn RIGHT onto W GRAND AVE/US-60 E. Southeast 1 - W GRAND AVE US HIGHWAY 60 E - - 2 8 60 - - http://api-signs.mqcdn.com/?s=rs&t=RS00002BW_SM&n=60&d=EAST</p><p> - - <img src='<img src='http://content.mapquest.com/mqsite/turnsigns/rs_right_sm.gif' alt='' class='ipsImage' >' alt='' class='ipsImage' ></p><p> - - http://www.mapquestapi.com/staticmap/v3/getmap?type=map&size=225,160&pois=purple-3,33.577758,-112.233421,0,0|purple-4,33.55278,-112.202926,0,0|&center=33.565269,-112.2181735&zoom=8&key=Fmjtd|luu7206r2q,8n=o5-5y10u&rand=-1047336837&session=4c30ab07-02f7-0000-02b7-4463-001ec93cd079</p><p> - - 33.55278 -112.202926 0.293 54 00:00:54 0 1 4 Turn SLIGHT RIGHT onto N 67TH AVE. South 2 - N 67TH AVE - - <img src='http://content.mapquest.com/mqsite/turnsigns/rs_slight_right_sm.gif' alt='' class='ipsImage' ></p><p> - - http://www.mapquestapi.com/staticmap/v3/getmap?type=map&size=225,160&pois=purple-4,33.55278,-112.202926,0,0|purple-5,33.54916,-112.202987,0,0|&center=33.55097,-112.2025865&zoom=11&key=Fmjtd|luu7206r2q,8n=o5-5y10u&rand=-1047336837&session=4c30ab07-02f7-0000-02b7-4463-001ec93cd079</p><p> - - 33.54916 -112.202987 0.751 109 00:01:49 0 6 4 Turn LEFT to stay on N 67TH AVE. South 3 - N 67TH AVE - - <img src='<img src='http://content.mapquest.com/mqsite/turnsigns/rs_left_sm.gif' alt='' class='ipsImage' >' alt='' class='ipsImage' ></p><p> - - http://www.mapquestapi.com/staticmap/v3/getmap?type=map&size=225,160&pois=purple-5,33.54916,-112.202987,0,0|purple-6,33.538311,-112.203056,0,0|&center=33.5437355,-112.2030215&zoom=10&key=Fmjtd|luu7206r2q,8n=o5-5y10u&rand=-1047336837&session=4c30ab07-02f7-0000-02b7-4463-001ec93cd079</p><p> - - 33.538311 -112.203056 0.402 53 00:00:53 0 6 8 Turn LEFT onto W GLENDALE AVE. East 4 - W GLENDALE AVE - - <img src='<img src='http://content.mapquest.com/mqsite/turnsigns/rs_left_sm.gif' alt='' class='ipsImage' >' alt='' class='ipsImage' ></p><p> - - http://www.mapquestapi.com/staticmap/v3/getmap?type=map&size=225,160&pois=purple-6,33.538311,-112.203056,0,0|purple-7,33.538425,-112.196098,0,0|&center=33.538368,-112.199577&zoom=12&key=Fmjtd|luu7206r2q,8n=o5-5y10u&rand=-1047336837&session=4c30ab07-02f7-0000-02b7-4463-001ec93cd079</p><p> - 0.0 0 00:00:00 0 -1 0 6350 W GLENDALE AVE is on the LEFT. 5 - - </p><p> false false false false false false false false false false false false - - 8401 W Monroe St Peoria AZ Maricopa County 85345-6560 US ADDRESS L1AAA false R - - 33.577331 -112.239822 20917791 s - 33.577331 -112.239821 - 6350 W Glendale Ave Glendale AZ Maricopa County 85301 US ADDRESS L1AAA false L - - 33.538425 -112.196098 20960240 s - 33.538424 -112.196096 0,1 I want to import the narrative data, and if I can get this to work, the index as well. I can't figure out why this doesn't work. I believe I have followed all the grammer rules properly and I'm cannibalizing another XSLT from Google directions which is pretty much the same structure, so I'm at a loss. Is there a glaring error here, or something more subtle that I am missing.
  8. I am testing a mapping solution and I have the following: 1. A list of location addresses. 2. A XSLT stylesheet (it actually works) 3. A well formed xml request to Google Maps Directions API 4. A FM solution that captures this data. Everything works, so the problem is this; Everytime I work working on this solution, it just up and stops after a little while and dies until a day or two has passed. Yes, I copied the URL for the XML into my browser and I get a result of "OVER QUERY LIMIT". Ok, I sign up for an API key (note that the DIRECTIONS API instructions page clearly states you don't need one, but anyways). I try again, nothing. I don't understand why it is doing this because my little list of 146 locations is a far cry from the listed max of 2500 stated. Does anybody have any thoughts or experience on this? (just for ref: http://code.google.com/apis/maps/documentation/directions/)
  9. If the end user is the client, and the lowest common denominator is NON tech savvy users, present them with the same data set as when they started the script. This gives an air of consistency, and allays fears of using the system in a way that will leave them in a spot there were not in just moments ago. Always expect the worst, especially from users.
  10. "Wouldn't that annoy the end user?" That is a philosophical question, and my opinion is the user is an exchangeable part of the equation. They should have little bearing on the solution. What is important is the business model specifications. What is the workflow attempting to achieve. End users will run a system into the ground, quickly, if left to dictate how they think it should function. If the management finds it conducive to the workflow, then by all means, you should keep the found set. If the business logic says, either by explicit, or implied rules, that the users work will be more in line with the business rules by forcing them back into the entire record set, show the entire record set. This unfortunately oftentimes gets missed in the design planning stages of an application. There needs to be some sort of channel between who is specing the app and the designer, so when questions like these come up, there is a clear process of comparison of the original app intent to determine whether or not an unexpected topic should be handled one way or another. I know there are many schools of thought on design in general, and no doubt many who would disagree, but at the end of the day, the person writing the check is usually writing the spec, so if you want a happy client, make the users do what he/she wants, and never defer to the opinion of end users. With that said, if the end users want to make their case as to how their thoughts are superior to the another course of action as it pertains to achieving the goal of the application and the business rules it intends to enforce, then by all means, present that to the client, as end users usually have a vast amount of insight that the management usually does not necessarily available. You might even surprise the client with some tidbit that they find useful in general, and that will always help to earn happy points.
  11. Thanks Lee, That is good sober advice, but I fear that in spite of the indexes being turned off, the file compacted, and then turning the indexes back on, there will be legacy structural items within the file that are related to the field that will simply cause the same issues. It's very frustrating to not have more knowledge about the internals of FM files so I can be sure if the field itself will be the problem or if the index is the problem independently. I'm going to keep that one on the list as the client has "ixnay'ed" the down time on the field replace for now, so maybe that will be the best option.
  12. No, it's running in a 10 environment. Anybody have any thoughts of 11 maybe being better at cleaning up messes? I haven't checked to see if any new features or improvements were included with the new release.
  13. I have a system I'm working on that could very well be the most mistreated system I have ever be exposed to. Too many relations, unstored calcs, legacy junk that nobody can remember if it's useful or not, etc, etc. Couple of days ago it just stopped indexing a couple of fields, and then the next, and then the next, to the point now where it is clear we have a handful of fields that simply WILL NOT function after a recovery on the indexes is performed. They work for a few hours and then die. So, my thoughts are that since they have no clean copy, backups are indicating damage as well, and a rewrite would take a month or two, to keep them afloat I was going to document the system, identify where all the fields are used, create new ones, export the data, import the data into the new fields, repoint everything to the new fields, delete the old ones, and cross my fingers the new indexes are stable and they don't have any other issues with the tables that would continue to cause problems. Anyone ever try this and did it work?
  14. In regards to how useful this error is, I was giving some thought to it, and I would agree if there wasn't one small issue, and that is consistency. Remember, if the current parent DOES have a related child, poof, no error, even if every other parent doesn't. This could be useful for trapping where every parent would have to have a child and you wanted to trap for it, but since its the luck of the draw pending the active parent in the found set, you can't depend on it, so again, some annoying additional coding would have to be in place in lieu of the error trap.
  15. Again, I'm lazy and was looking for an easy pass through on the error. In the end you are all right, there are ways to get around this, so you just code for it. I can just capture for 401 or 101 and be done with it (though it wreaks havoc with pause on error). As for the record collector technique, this solution, CURRENTLY (key variable), is well below that, but that does not mean there is no expectation to do that volume in short order (6 months to a year). I'm not very keen on the idea of thinking too much outside the box on this solution, but I would be curious to see the record collector technique.
  • Create New...

Important Information

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