Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About dev_synaptech

  • Rank
  1. Comment, Worked perfectly. Many thanks -much gratitude.
  2. Hi, I have a text field that contains size and color data separated by a "-" dash. i.e. record (1) red - XL record (2): crystal blue - small record (3): black/light blue - large record (4): mediterranean blue/ speckled black (45) - extra small .. and so on I am looking to parse everything to the left and to the right of the "-" dash into two other fields (color) and (size). I am having trouble accounting for the variability of the location of the dash in building my calculation. Within this field, there is one and only one occurrence of the "-" dash. Any
  3. It seems that I have been running in circles as I got lost in the forest. Thank you for the much simpler, more elegant solution. Your help is very much appreciated!
  4. Hi bcooney, Thank you for the assist - the List function is exactly what I needed. I thought I'd post my solution in hopes that it might help someone else. So, I only needed to work in the one "join table" - the one that contained only two fields "products" and "categories". I created the self-join with products=products and displayed product ID and Category ID in a portal. So for "product_1" I have "category_a" "category_b" "category_c" and for "product_2" I have "category_d"
  5. Hi, my data modeling skills are rusty and the solution is not clear to me. I have a table with 6000 records, it's a join table for two other tables and it contains a Product ID field and a Category field. The products are not unique and neither are the categories - they repeat throughout the array. I have managed to show for every Product the multiple categories that the product can be in through a self join in a second table occurrence - yay for me. However, what I'd like to do is build a calculation that writes the values in the self-join portal out to a field that looks li
  6. Outstanding, thanks for your help in extending this concept! It works well! It's too bad there isn't a more robust set of drivers for ImageCapture, as that would be a cleaner solution... Much appreciated!
  7. As for the size, the default 640x480 is fine.
  8. Yes, I absolutely can place the iSightcapture App in the Utilities folder. Each "client" or user, is updating a shared database served by FM Server 8.
  9. Ah, I seem to be making a mess of this.. Yes, you are correct in your questioning of why I wouldn't I want to embed the picture into Filemaker.. I couldn't figure out how to get the .jpeg file into the container field via the Applescript "set " command...The work flow is this, or this is what I am trying to do... For each employee record, I want to associate three separate images. I would like the user to be able to click a scripted button to "take" picture one, then two, then three. Ideally, I'd like the child picture records to be related to the Parent Employee record by the employee ID. My
  10. Umm, that's my fault, I put that path example in my script. I was simply trying to put a sample path example into my script example as I *expected* it would necessarily have to be changed on another user's machine. My fault for assuming... I can get get an image into a container field, that's not the problem, the isight app works great. My problem is that the file needs to be stored (the terminal command saves Jpeg image as the same name every time a new picture is taken, to the same file location) uniquely, as I want to associate multiple pictures with one record.
  11. I am working on a variant of this solution provided by Fenton. I am having trouble bringing the picture data in permanently to Filemaker. I get the following error: "Filemaker Pro got an error: Data is being accessed by another user, script, or transaction." Is there a better applescript command that will actually paste the picture data into the container vs. simply displaying the file contents as it seems it is currently doing? I have included my sample file, with scripts. The purpose of this is to have multiple, related (child) pictures, for one (parent) record. I could b
  12. Fenton, thank you again for the assist on this project! I understand why keeping the data relational is important as it relates to the overall structure; the hope was to keep the selection of the data targeted with more precise queries... but alas, I'd like to be 19 again too. OK, so I've built the separate XSL stylesheets and related tables(still having a slight problem with the ParallelATA section, the XSL works for the second device but has the "tabbed" column effect for the first device), but now the problems are "contained" within each set of related records and doesn't blow up the
  13. So, to be more clear in my request.. Is there an XPATH expression that will allow me to pick out the nodes (and the following siblings) that I want to get from Anywhere in the System Profiler XML output? Or is it absolutely required to define the node within the XML structure to then grab the information you want. As I stated before the System Profiler XML node structure changes by machine and my current attempt at capturing segments of the entire structure is failing. Any help in the regard would be welcome. Cheers, Cliff
  14. Hi, I'd like to import the contents of a .txt File into a container (retaining the carriage returns if possible) based upon the matching field criteria in Filemaker to a Filename in a specific folder on the desktop. Let's say the example is that a user enters an ISBN number into a field, then executes a script that will go to a folder on the desktop that contains files labeled with the ISBN, performs a match then imports the contents of the book into a text container in Filemaker. I figure it's an Applescript embedded in Filemaker but I can't seem to work the logic out. TI
  15. Hi All, I have been slogging through Fenton Jones' great tutorial for bringing in ASP xml data into FileMaker. I have hit a wall with the project and wanted to submit my work to see if someone might have a better way for me to reinvent this wheel. So my goal is to pull specific pieces of data from various Apple machines (G3, G4, Intel, etc) from their respective system profile data. To control for the varieties of OS's and ASP builds, all of the machines are booting to 10.4.x volumes. I have built an Automator App to pull only the specific SPDATATYPES into a generic xml file (not the .
  • Create New...

Important Information

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