Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

wendykdt's Achievements


Explorer (4/14)

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

Recent Badges



  1. Following up on this old post to see if anything has changed... FM Server 16 console still shows the User Name column, rather than the Account Name... which means I have no way to identify the logged-in users. When our IT department installs FM on PCs, every installation receives a user name of "Windows Technologies". This holds true for both internal and external authentication at the OS level. Also, our IT department also uses Computer Names that do not identify the user, so no hope there. My only "solution" is to constantly monitor for User Names that don't make sense, try to find someone in IT to help me figure out who it is (which is time consuming), and chase down the user to have them change that User Name--and log out and back in. (I'm not up to writing to the Registry, which I doubt IT's settings will allow in any case.) Why doesn't the server display the all-important Account Name, if User Name is deprecated?? (We're avoiding FMS 17 as we have administrators on Macs; the FMS 17 console "missing" logs, etc. present a learning curve that is too high for us at this time.)
  2. Question about Wim Decorte's note to "disable power saving functions, screensavers, etc.". We have FMS15 on an iMac. Can I at least put the display to sleep (without a screensaver)? I don't like the idea of the display being brilliantly lit all the time... I'm talking about setting a hot corner to "Put Display To Sleep" so I can blank the screen when I walk away. (I used to have it set to a screen saver, but I can understand why that may not be desirable from a performance point of view.) Thanks.
  3. I've actually been struggling with this for a couple days and can't seem to pinpoint the logic: I have a set of records. There is a related portal on the layout. I go to the first record via Go To Record/Request/Page First. Start a loop. If a certain field is empty, Custom Dialog 1 (shows the user the record ID number and a message specifying the problem). Then... If the count of the number of records in the portal is <2, Custom Dialog 2 (shows the user the record ID number and a message specifying the problem). Then... Go to the LAST record in the portal. If the date equals the current date, Custom Dialog 3 (shows the user the record ID number and a message specifying the problem). Then... If ANY ONE OR MORE of the above tests are true (i.e. a dialog is triggered), I want to OMIT the record, once the user has a chance to note the information presented in the dialog(s) for that record, and move on to the next record and repeat ALL of the same tests. If none of these are true, I want to simply move on to the next record in the set and repeat ALL of the same tests. Exit the loop after all the records are reviewed. Sounds simple. I can't seem to do it. I do understand the script steps for creating custom dialogs, counting records in portals, etc. It's the logic that escapes me. I've been messing with Loop, If, Else If and Else (I can't seem to understand the difference between those two), and have considered Case within an IF. But I can't seem to get the sequence right to show all dialogs as needed and then omit that record if necessary. FM11 Advanced on Mac OSX. Thank you...
  4. Help. Recent upgrades to Filemaker, Mac OS and Adobe Software have created a show-stopper of a problem with our Filemaker database. Here's the problem, as succinctly as I can state it: We've been using Filemaker Server/Filemaker Pro as an image catalog for our art department for years, and we have thousands of images and multiple users on Mac and PC platforms. We import 72-dpi images in the Photoshop EPS image format because this is the only format we've found that carries a clipping path into Filemaker. (The EPS image files are also placed (linked) into Adobe Illustrator and InDesign artwork.) Photoshop EPS images created in Photoshop CS3 worked fine in Filemaker (8) until we upgraded to OS 10.6.4 iMacs, Photoshop CS5 and Filemaker 11. Now: - Photoshop EPS images created in new Photoshop CS5 cause consistent Out of Memory errors when imported into Filemaker on the Mac. (Script stops once it hits one of these images.) - Older Photoshop EPS images created in Photoshop CS3 randomly appear/disappear in Filemaker 11 container fields (known problem). - We've been using the EPS format for years because it is the only format we've found that shows image clipping paths in Filemaker. (Crucial.) - To avoid maintaining duplicate libraries, these images should ideally be in a format that can also be placed (linked) into Illustrator and InDesign artwork. Perusal of various forums has made it clear that Adobe, Apple and Filemaker have been aware of problems with EPS images for quite a while. Meanwhile, we need a solution. Does anyone know how we can save Photoshop CS5 image files in a format that shows clipping paths when imported into Filemaker on both platforms (and, ideally, can also be placed (linked) in Adobe artwork, so we can avoid maintaining duplicate collections)? Or is there any other solution that would allow us to keep using EPS images? I'm going nuts testing various configurations, and our image filing backlog is growing! Thanks to anyone who can shed some light on this. DETAILS IF YOU WANT THEM--AND WHAT WE'VE TRIED: The catalog has a list view layout showing small thumbnails, and a larger form layout showing each image via a reference. A script is run from both Filemaker 11 Advanced on Mac OS 10.6.4, and from Filemaker Pro on Windows XP Professional (Version 2002 Service Pack 3. We have no control over the PC OS.) The script: - Determines the user's platform, goes to the appropriate layout, and on the Mac imports 72-dpi EPS images from a folder into a container field (Import records > Picture and movie files > import only a reference). - It also writes the Mac file path to a text field, and - Places the image thumbnail in a second container field. - The PC branch of the script does the same, importing a reference to a container field and a PC file path to a text field, except it does not re-import the thumbnail, as the thumbnail provided via the Mac script has been viewable on both Mac and PC. The problem began when we upgraded from Mac G5s running 10.4.11 and Adobe CS3 software, to iMacs running 10.6.4 and Adobe CS5 software. The script now ends with an Out Of Memory error as soon as it hits a Photoshop CS5 EPS (without indicating the problem image, dang it, but we've managed to track them all down). We've tried saving in Photoshop with various previews and encoding without success. TIF, PSD and JPG images do not carry clipping paths into Filemaker as far as I can tell. I thought I had a solution when I discovered that saving images as a Photoshop PDF worked beautifully in all programs (Mac Filemaker catalog, Illustrator and InDesign artwork)… only to find that Filemaker on the PC rejects a folder full of Photoshop PDF images as "empty". (Error message: "No files of the specified file type were found in the specified folder.") Thank you...
  5. Hold it. I think I just got it. Lemme try Count, if I think I understand...!
  6. I looked at Count... but it seems to count the number of values in a field? Is there a way to make it count records in a portal?
  7. I'm a newbie and I'm stuck AND feeling quite stupid. I have a script that goes to a portal (of self-related records) on a layout, directly to Record#2. (Go to Portal Row [select; No dialog; 2]). The script then continues to loop through portal records and perform additional tasks. However, if record #2 doesn't exist (that is, there is only one related record), I want to abort the whole thing and generate an alert message. (If Record#2 doesn't exist, it indicates another problem that needs investigation.) I thought I could just trap for an error, but it doesn't appear to generate an error if there is no second record. It just continues on, even though it hasn't been able to go to Portal Record 2. It apparently becomes caught in a loop as it continually retests a record that doesn't exist. Questions: Is there any way to count the number of records in a portal? And/Or is there any other way to have it identify that there is no second record? There's probably a really obvious answer out there... Will be happy to provide more detail about this particular script, if needed!
  8. Worked beautifully!!! One more question please...? My group of scripts to accomplish this import first makes sure that the found set in File 2 contains only the record to be imported. It also makes sure that the found set in File 1 contains only the record over which the imported record will be written. Then the import script does the import, including a prior IF step that incorporates FentonJones's calculation. (Basically it compares the results of a calculation to isolate the root of the EIN field in File 1... to... the results of a calculation to isolate the root of the ECO field in File 2.) However, I found I had to first set the contents of the ECO field in File 2 to a GLOBAL (then compare gECO to EIN) in order to get the comparison to work properly. It's not a big deal to use the global, as long as it works, but there is apparently something missing in my understanding of Filemaker, because I didn't realize I would need to do this. Why couldn't Filemaker do the one-to-one comparison, without a global ...as long as both files only had one record in their found sets? If anyone wants to take on the task of enlightening me, I would appreciate it... thanks.
  9. Man oh man, the things I don't know... Wow. I had to stare at this and pull it apart and review the syntax for every function used, but I think I get it. In particular I've never seen "Case" used this way before. Neat. So this calculation will get me the "root" of the EIN field, and I can do the same for the ECO field. And it sounds like I just do this all "on the fly" within the script by plopping these calculations into an "IF" script step: If (Calculation for EIN field = Calculation for ECO field) Proceed with import Else Show user error dialog and halt import Do I really not need any globals or actual calculation fields? I gotta go try this. What fun. Thank you sir! (Note: An EIN field without a dash OR decimal is unlikely to happen, but given human capacity for error, you never know. I AM pretty sure that an instance with both a dot AND a dash in the same number would not occur.)
  10. OK, I've batted this around for a couple of days, with the grand result of a lot of bits-and-pieces ideas, but no idea how to put it all together. Too much of a newbie, I guess. Here's the problem. In File 1, I have a field called "EIN". It contains data such as GKL00361-6, GBV358.101, GDN2345-67. In File 2 there is a field called "ECO", and it has data such as 00361-6, 358-47, and 2344-67. An import from File 2 to File 1 can proceed if the "root" of the number matches in both records. The root consists of the numbers to the left of the hyphen (or dot, in a few cases), excluding any letters. I already have an extensive script that handles the import. It does not/cannot use a match field, so the user manually chooses the correct record to import to/from. I just want a way to double-check their choices by comparing the "root" of both numbers. I dinked around with a lot of functions and don't really know how to combine the correct ones or how to incorporate them into the script. I did figure out a calculation of Middle (EIN; 4; Length (EIN) -3) which gets rid of the initial letters. I plopped that result into a global. I think I could find the position of the hyphen or dot and then remove whatever is to the right of that. (I wasn't too happy to discover that LeftWords didn't work because of the presence of numbers in the data!) But how/where do I create a calculation that "on the side" parses two fields in two different files and compares the results? Within a script run from File 1? Would someone get me started with a few clues?
  11. Sounds like the safest approach. (Any method that means I "...don't need to worry..." is a good method)! :
  12. I did think of that (after my initial mess-up, of course), but it seemed clunky, so thought I'd ask if there was another method. Sounds like the copy/paste is the way to go. Thank you! (P.S. Like your quote. If only I knew how to start my LIFE over again. Or at least since my college years...!)
  13. I take it there is no easy way to replace a layout without disrupting scripts. Rats.
  14. Hello all. I would like to know the best way to replace/update a layout without causing problems (as I recently did!) Recently I needed to work on a layout (add a few fields to the layout, shift some things around). I created a duplicate of an existing layout, named "Existing Layout Copy", and made my changes to my copy of the layout (while the dbase was hosted). Then when all users were out of the dbase (but it was still hosted), I changed the name of my layout to match the existing layout (since 8 allows layouts with identical names), then IMMEDIATELY added the word "OLD" to the previous layout. I also moved my new layout to the same position in the layout listing, and moved the "OLD" layout to the bottom of the list. Since I am not familiar with all the scripting/calculations in the database (mostly created by someone else), and because I am secretly quite lazy, I was hoping this would circumvent the need to fix lots of scripts. Well it didn't work; I still had scripts saying Unknown Layout... some of which were discovered by unhappy users... I could also swear that I fixed some of those scripts only to have them revert to "Unknown Layout" again, so I hope I didn't introduce some corruption by momentarily having two layouts with the same name. For future reference, is there any way to replace one layout with another, without this disruption? I am using 8 Advanced, users have regular 8, files were converted from FM 5.5 months ago and appear to be healthy (with one table per file).
  15. Shame on me, I almost forgot: Thank you! :thankyou:
  • Create New...

Important Information

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