Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About itsalljustaride

  • Rank
  1. I've discovered a more serious problem than how to construct a compound find command with this strategy. As it is right now, these forms will return the whole set of records. If you do a find through the Site Assistant generated form in the findrecords.php page AND THEN go back and click the form constructed above, then it will work. Somehow the findrecords.php page is setting something up in the session that isn't being constructed by my cobbled-together method.
  2. I've made some significant headway on this. In the end, I had to construct some forms composed of hidden fields with submit buttons styled to be images (also could be text if need be). The Site Assistant saves the search parameters in the session after the POST action. From there it parses they keys and values based on numerically named fields. 0 and even numbers are translated to operands and odd numbers are the search values. For example: For this to work the $layoutName variable has to be copied from the top of the findrecords.php file. The Site Assistant code interprets the keys that begin with a dash as general search params, and ones without as the keys and values to build the search with. This strategy works fairly well, but I am not sure yet how compound finds with work.
  3. I'm trying to create some simple links on a Site Assistant created home screen to a few often-used search queries. I can't figure out how to construct such a link in the PHP code, though. The search parameters seem to be stored in the session, and if it is possible to construct such a search via a URL (for example: http://www.site.com/recordlist.php&-name="Fred"&-job="Boss") I can't seem to tease out the logic of it. Any ideas? Thanks much.
  4. I'm trying to use the values entered in a "Ignore Words" value list during a calculation to set a catalog number for film titles (for example, ignoring words like "the" and "a"). I would assume I would use the ValueListNames function, but not sure how exactly it works. How do I test if a text string is in that value list? I tried something along the lines of If firstword = ValueListNames( Get (Filename); 'Ignore Words List") But that didn't go so well. Any thoughts?
  5. Thanks for the point in the right direction. I think I see what needs to be done, vaguely.
  6. Hello, I apologize if this has already been discussed here, but a search didn't turn up anything of use. I have a database that I am using to catalog and track foreign language media checkouts. Each title has a catalog # of the form AA-## where the first letter is the language it is in (A for Arabic, etc), the second letter is the first letter in the title (A for Amelie for example), and the last part is a unique two-digit number that we simply increment by 1 when we get another "AA-##" title. For instance, say I have 5 titles with cat #s "AA-". The last one would have a cat # of "AA-05". If I wanted to add another Arabic film whose title started with "A" then I would need it to automatically assign it the cat # "AA-06". I have a calculation set up to assign the catalog number based on the language and title, which gets me the first two letters, but I can't figure out how to begin getting the unique two-digit number at the end. What functions would I use? The cat #s are indexed, so if there is a way to search for all the cat #s which match, find the one with the highest ending number, then increment by 1? Maybe that's more work than is needed. Any advice? Thanks.
  7. I'm doing imports from the Amazon ECS. For the most part all of the parts and peices are easy enough to get at, but there are a couple little details that are evading my grasp. #1 Amazon makes available the item description, such as the text that would be on the back of a DVD cover. However, it puts it in with the editorial reviews, rather than as its own separate node. Like thus: - --Amazon.com --- ----Like a dream, Howl's Moving Castle carries audiences to vistas... --- -- - --Description --- ----In Hayao Miyazaki's latest animated masterpiece... --- -- So basically what I want is just the "Content" portion of the one that has "Description" as the "Source", and all others it can ignore. #2 How can I parse out elements that reside inside the tags? There are some parts that look like this: 134 I can get the data "134" easy enough, but I'd also like to append the other stuff as well, so that it looks like "134 minutes". Or, in this case: Atsushi Okui I'd like to get something like "Cinematographer - Atsushi Okui" Thanks for any help!
  8. nevermind. I found it. set error capture "on". thanks for all your help!
  9. That seems to be working pretty good, with the exception that not every record has a corresponding image. So what I need is a way to test that there is actually a file before it performs the import. Otherwise I'd have to sit there and keep pressing "ok, continue" for each error message when it doesn't find the image in the $path variable. I know there is a script step to validate that a field is not empty, etc, but is there some way to validate that a file is there or not? Or can I just build in a step to ignore errors?
  10. Hi, I have a folder full of about 1000 cover images for films that is left over form a previous Access database. The images are all named according to a catalog number (that is how they were displayed in Access), which is the same in my new FMP database. Being wholly inept when it comes to Applescript, how might I go about writing a script that would import the images to container fields in their respective records in FMP.
  11. I think I may have teased out the answer. Sometimes the Name I give the project has a space in the name, as in "LRC Library". If I try the same settings with "LRCLibrary" it works. Apparently IWP doesn't like spaces.
  12. Hello, I have a database that I have set up a IWP page for. I have tried this multiple times, with both the sample database in Sever 9 Advanced, and with my own databases. The page works fine except for the fact that when I do a search it returns all of the records, no matter what search criteria I input. The server is an Intel Xserve running 10.4.10 here is the address to the database page http://marvin.mll.gvsu.edu/Filemaker/LRC%20Library/home.php? If you do a search for "Live" in the title field you'll see what I mean. Where only one of the 9 records should be returned it returns all 9. This happened before, but for some reason I got it to work by making another page. That page worked fine while others did not, until I deleted it today. Then when I tried to redo it, it broke again. Now I can't get even one page to actually give a record set that is actually limited by the search terms. Any thoughts?
  13. fair enough. I guess I'll just hide it behind the image or something. Thanks.
  14. I've got something really weird happening with the image import. If i put the field for the image URL in the layout it works fine, but if I take it out, it breaks the import. It gives me an error message saying it can't find the image file. If i put the field back in, bingo, works great. Any reason why this would be happening? I don't see why having the field in the layout makes any difference.
  15. oooooookay, it's all starting to make sense now. haha. I was structuring my relationships based on what the data I wanted to show up was(i.e. Actor = Actors) when it should be based on the ID or something (I used the ASIN, like you suggested) I tested the relationship now and it works fine with a portal. Each table has a field for a filemaker ID, and the ASIN to use as a link, so I can't forsee any issues with identical records. Thanks for helping me crack that nut : You mentioned earlier about the images and caveats of them in filemaker. At what point does filemaker strain under stored images? I'm using the large images from Amazon, which are about 50 kb each.
  • Create New...

Important Information

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