Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About slehar

  • Rank
  • Birthday 01/22/1953
  1. That sounds great. But I already wrote a Python script that writes the data in the xml import file, and it already writes it in format, so if I used a stylesheet, all I would need it for would be to ensure that missing fields are represented with empty data. How would I do that in a stylesheet, if my file is already in format? (My Cologon: FMP Bible says almost nothing about this subject)
  2. Hi guys, I wrote an AppleScript that calls a FileMaker script that imports data records from an xml file, with lots of help from this forum! (Thanks!) Now I discover that the xml data (provided by another program) does not always have the same fields. Specifically, some of the fields may be missing (depending on options in the generating program). For example a record may contain: Field1 Field2 Field3 Field6 Field7 with fields 4 and 5 missing from this record. FileMaker simply imports the data from fields 6 and 7 into the slots that were supposed to be for the missi
  3. Wow! Its so simple once you know how to do it! To create a multi-file solution with records that have ~300 fields: [1] File > Manage > External data sources Name: WAIS-IV Details: (filepath) WAIS-IV.fp7 [2] File > Manage > Database > [Relationships] [ ]+ (Add Table) > Specify Table > WAIS-IV [3] (NEW!) Back to the Main Database layout: Layout Mode > Layouts > New Layout/Report > "WAIS-IV" Show records from: "WAIS IV" Layout Name: WAIS_IV_Layout > (move all) And it moves all the data from all ~300 fi
  4. I made a couple of more discoveries just playing around. In Layout Mode, I double-click on one of the (many) fields with [ But I have about 300 fields, a really long list, and they are sorted alphabetically in the list I have to pick from, so I have to do a lot of scrolling to find the one I want (error prone process!), and many of them have very similar names, e.g. VerbalComprehensionSumofScaledScores VerbalComprehensionIndexAbbr VerbalComprehensionCompositeScore VerbalComprehensionPercentileRank VerbalComprehensionConfidenceInterval ... and on and on! Its a loooong list!
  5. Main Database is what my predecessor named the big database containing a bunch of different tables, including WAIS-III which I am updating to add WAIS-IV (It is the Wechsler Adult Intelligence Scale, a.k.a. IQ test, version IV. We do psychological "assessments" and I manage the scores database) After more investigation in Cologon (FileMaker Pro 9 Bible) I discover that the multiple tables *don't* have to be "inside" the Main Database.fp7 file, but you can create a "Multi-file solution" with individual tables in separate single-table files, like my WAIS-IV.fp7, and in fact, that is how the
  6. Ok, now I see my bigger mistake - (its a newbie error!) I never added those tables to my main database using Manage > Database > Tables, so they were indeed not even in my database at all! I think that was the problem all along. I'm reading Cologon Filemaker Pro 9 Bible Chapter 5, creating a database, and he starts by adding the tables with Manage Database Tables. I think I'm on my way! Thanks guys!
  7. I FOUND THE PROBLEM!!! Layouts > Layout Setup > Show Records From > [The MAIN database!] I just had to change that to [WAIS-IV] and now I can see my data! Thanks for your help guys! I hope this helps anyone else who runs into the
  8. Oh, so THATS where that came from! Thanks! Now in Layout Mode my CompositeScoreSummary field reads [::CompositeScoreSummary], so that one field is finding the right field in the WAIS-IV table. (I hope I won't have to do this to all 300 fields by hand!) But back in Browse Mode that field is still blank, and does nothing when I double-click on it.
  9. How can I tell what table occurrence my When I look at the table in Layout Mode, I see really weird field contents... Accessible power Powerful scripts Customizable Buttons Graphic reporting Accessible power Powerful scripts ... (and so it repeats round and round for ~300 fields!) Where did THAT come from? Certainly not my data! I deleted my Table Occurence altogether and started again from scratch: File > Manage > Database > Relationships > [ ]+ Specify table I selected WAIS-IV from my WAIS-IV.fpm (Name "WAIS IV" to avoid using "-")
  10. I was fooling around with my layout, can't remember what I did, but when I returned to Browse mode, all my fields contained The problem is that I have about 100 fields. Do I have to click-and-select each one by hand? Or is there some way I can ask FMP to do it automagically? More important still, what went wrong, and how do I prevent this happening again?
  11. >> The statement, "But AppleScript does not pass >> parameters!" is too vague to really argue for or against. If I could pass a parameter from AppleScript to a FileMaker script, that would solve my problem immediately! Please tell me I was wrong, and that IS possible after all? I would love to do this in AppleScript: tell application "FileMaker Pro" activate tell database "Imports" open {"Macintosh HD:Users:steve:Documents:Database9:Imports.fp7"} do script FileMaker script "import" set FolderName to get data of field "Folder Name" of last record
  12. Ok, I have a much clearer idea of my problem and the proper solution. Here's a quick summary in case someone else has this same issue. I'm writing a Python program that logs in to a remote server and creates a "Participant" folder named for the participant (e.g. "Jane Doe"), and dumps 5 xml data files into it, that should serve as import records for 5 different databases. Then what I'd like to do is, operating remotely, write an AppleScript script and save it on the remote server, then execute that script, to open each database in turn, and for each one, import the appropriate xml fi
  13. Ok I think I'm getting a big-picture understanding of the problem and the proper solution. You're telling me the best way to communicate paramaters and values to my database is through the XML files that I'm sending it already to import, so it will have those parameters and values easily accessible as regular fields in the database, no need to pass them in through a dialog. So in my Python program, when the user types in the intended folder name (e.g. "John Jones") it will check it against the & fields in the xml file and issue a warning if they don't match. If the user ignores the
  14. Here's the details of my application. I have a Python program that reads the xml output of some other software product (Pearson's Psychcorp clinical assessments) which produces five separate data files for each of our voluntary participants (ptpts.). My program prompts for a ptpt. name, which is uses to create a folder by that name, copies all files into that folder, converts the 5 files to the format required by FMP, then (hopefully) it open FMP and imports the data from each file into the 5 corresponding database tables. The folder name was already typed in by the user of my Python pro
  15. Hi Fenton, Thanks for your help. Yes I have multiple tables in on database. And I discovered the Set Variable[ ] function. The problem is that I won't know the customer names, and thus the customer's folders, until running the script, which I was hoping to do automatically as I create those customer folders and populate them with the xml data files. I wish you could say something like $variable = Dialog("Enter customer name"). Is this part best done in AppleScript? I've got a kludge working now, where I created a new global field, which can be loaded with the path to the customer's f
  • Create New...

Important Information

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