
mweiss
Members-
Posts
59 -
Joined
-
Last visited
Everything posted by mweiss
-
I'm completely baffled by this. The attached file contains two tables (Parent and Child). Parent has three fields, Parent::Serial, Parent::DefiningProducts, and Parent::DefiningResources. Child also has three fields, Child::Serial, Child::Products, and Child::Resources. The relationship is a simple one: Parent::DefiningResources = Child::Resources AND Parent::DefiningProducts = Child::Products. If you look at the portals, you will find that the relationship does not seem to be matching the expected records. In particular: the Parent record with serial 287 is correctly matching Child records with serials 3347, 3905 and 4086, but is also incorrectly matching with serials 3906 and 4909, despite the fact that the Resources are different the Parent record with serial 134 is correctly matching Child records with serials 525, 1993, 3348, 3353 and 4060, but is also incorrectly matching with serial 1996 and 4088 the Parent record with serial 305 is correctly marching Child record with serial 3888, but is also incorrectly matching with serial 4085 I'm wondering if the presence of the special characters (percents and parentheses) is somehow messing up the match? Or is there something else going on here? (The attached file is a stripped-down version of a much larger and more complicated database... I've tried to remove everything that is extraneous to this specific issue.) RelationshipsProblemDemo.fmp12.zip
-
FM Go displaying wrong image in container fields
mweiss replied to mweiss's topic in FileMaker Go for iPhone & iPad
I have done some digging, using a new field that calculates GetAsText(container), and have figured out some more information. Some background: The images were all inserted by copying portions of a PDF document (open in another application, e.g. Preview or Acrobat Reader) and pasting into the container field. Several different users were doing this, and apparently they did not all follow exactly the same procedures: (1) Some users used a screen grab tool to select a portion of the document, then pasted into the container field. In this case GetAsText(container) shows "Untitled.png" (2) Some users used the selection tool inside the PDF reader to copy a portion of the document, then pasted into the container field. In this case GetAsText(container) shows "Untitled.pdf". Apparently the problem I am experiencing only occurs when the graphic was pasted in as a PDF. More specifically what I am seeing is the wrong portion of the correct PDF. Because the correct portion of the PDF does appear when I access the file from FMP, I assume that what is going on is that the entire PDF is stored, but only a cropped portion of it is displayed. For some reason FM Go is having trouble showing the correct cropped region when the container field is on a layout (but does it correctly when I tap the container field and select "View" from the Actions popup). So my questions, then: (1) Has anybody else experienced this kind of behavior? (2) Is there somethng I can do to fix it? (3) Short of that, is there a way to batch-convert all of those "Untitled.pdf" fields to PNG or some other graphic format that doesn't confuse FM Go? -
I have been away from the forums for a very long time and I apologize if this is a FAQ, but I haven't been able to find any info on it. I have a container field on a layout that stores graphics (embedded, not file references). When I view some records (but only some records) in FM Go, the wrong image appears in the container field; it displays the data from another record. The image displayed is, consistently the same image, almost as if it were a Global field, but it is not (as evidenced by the fact that not all records behave this way). It does not seem to matter what layout I use, as long as that container field is on the layout. When I tap the container field and select "View" from the Actions pop-up, the correct image displays. So I know the correct data is there. But for some reason when I view the data on a layout it displays the wrong image. Also, the correct image displays when I access the same hosted database through desktop FMP 12. Does anybody have any idea what is going on?
-
MAC network file path designation
mweiss replied to tomp's topic in Legacy FileMaker Server Discussions
Just to be clear: The OP did not say he was using a file share. He said he was in a "shared file environment", which I think is a perfectly reasonable (if perhaps ambiguous) way of describing a situation in which Filemaker is sharing a file. -
MAC network file path designation
mweiss replied to tomp's topic in Legacy FileMaker Server Discussions
I'm sorry to stubbornly disagree with people much more experienced than I, but I think the question is still being misunderstood, and I believe the answer being given is wrong. Look, consider this (hypothetical) situation: I have a desktop computer in my office. On it is a copy of FMP (not FMS). On the hard drive of that computer there is a database ("Database Alpha") that is currently open. Filemaker sharing (not folder sharing or any OS-level sharing) is turned on. I access that database from my laptop using "Open Remote". My colleague down the hall from me has a similar setup -- her desktop computer has a (completely different) database ("Database Beta") that she shares using FMP sharing, and accesses remotely from her laptop using "Open Remote". This situation goes on for a while. Certainly there is no risk of file corruption yet, right? Now it turns out that my colleague and I collaborate occasionally, so she decides to create an account in Database Beta for me, and I decide to create an account in Database Alpha for her. And to make things even easier I create a script inside Database Alpha that remotely opens Database Beta, and she creates a script inside Database Beta that remotely opens Database Alpha. (Sure, we could create a Launcher. But do we need one?) So far everything is still great, right? But we have two installations of FMP, on different computers, sharing files with each other. And if one of us moves our desktop computer to an office in a new building, they will even be on different network paths. I think this is the kind of situation the OP is asking about. He never said ANYTHING about folder sharing or file sharing at the OS level, just that database files are being shared (which is, after all, exactly what the menu says: File > Sharing > Filemaker network...) on different computers with different network paths. I can't see any reason why the above scenario requires FMS (as long as only 2 people are using the databases), or why the files need to be on a single computer, or why there is risk of corruption. Am I missing something? -
MAC network file path designation
mweiss replied to tomp's topic in Legacy FileMaker Server Discussions
I'm still not sure. If my copy of FM Pro has an open database, and FM Network sharing is turned on, and other users can connect to my file, couldn't you call that a "shared file" environment? I think we need the OP to clarify. -
MAC network file path designation
mweiss replied to tomp's topic in Legacy FileMaker Server Discussions
I may have misunderstood the OP, but I think he is talking about "sharing" using the built-in FM Network sharing, not OS-level sharing. This should not corrupt the file, as FM is written to provide this functionality natively. Deploying FM Server is expensive, and for many purposes is way overkill! -
Video Library with Video preview
mweiss replied to johncgaiser's topic in Calculation Engine (Define Fields)
Just to be clear, do you want to host clips only, or is BrightCove going to host full-length videos as well? Either way, seems like a web viewer would do the trick neatly. -
An easier (I think) method is: (1) Open the CSV file in Excel. (2) Select rows 1-3 (that is, all of the data). (3) Select Edit > Copy. (4) Click in the 1st cell of row 4. (5) Select Edit > Paste Special... and select the option Transpose. (6) Delete rows 1-3. (7) Save the Excel spreadsheet and import it into Filemaker. To automate the process, use a Visual Basic macro or an Applescript (depending on platform). (Edited to add: Oh, I see you were already aware you could do this in Excel. Sorry I missed that in the original post. I think the thing to do is to work on automating the Excel process rather than trying to get Filemaker to do it for you.)
-
Ron, I am local (recent Ph.D. from the UM School of Ed, still living in Ann Arbor) and have a fair amount of experience developing databases (although not, of course, as much as comment and Fenton). I can probably come by and help you in person. If you're interested message me directly.
-
Might be it's related to this bug: http://fmforums.com/forum/showtopic.php?tid/214292/
-
New in FMPA 11: Either the host is not available...
mweiss replied to mweiss's topic in FileMaker Pro 11
Looks like it's documented here for the last version: http://www.fmforums.com/forum/printpost.php?tid/198157/ and here for the newer version: http://forum-en.filemaker.com/t5/Using-FileMaker-Pro/Is-FM11-incompatible-with-FM10-Server/m-p/59732#M46682 Seems kind of weird that this wouldn't be fixed, doesn't it? -
Hey all. Just got my hands, finally, on FMPA11. First time I tried to connect to a remotely-hosted file, I got the dreaded "The file <> could not be opened. Either the host is not available, or the file is not available on that host." Just to double-check, I tried again using FMPA10. Worked fine. Also under FMPA9. So it's clearly an issue with my new install, not with the host computer. I seem to recall vaguely having a similar issue back when FMPA10 came out -- something about a bug in the installer -- for which the workaround was to temporarily change my computer's date to be before some specific date, then install the software and updates, then set the date to current. Does anybody remember this? Is the same bug present in the FMPA11 installer?
-
Don't have FMP 11. That's why I asked if anybody else had tried it. But I can't see why it wouldn't work -- it seems like a pretty straightforward idea. I'm thinking to "open" the saved found set you would need to export the contents of the container field (i.e. the stored snapshot link) into your temp directory, with "automatically open file" checked -- and that would restore the saved found set. (What, if anything, would it do to already open windows, though? Hmmm.)
-
Nobody ever likes my ideas. :)
-
I haven't gotten my hands on FMP 11 yet, so it may be that this idea won't work. But it occurs to me that by saving a snapshot link, then embedding the snapshot into a container field using Insert File, we have a simple way of creating "saved found sets" without complicating our schema. Has anyone tried this yet? The idea has a "strange loopy" quality that I find very appealing.
-
If you want to display the image, use "imagemac" rather than "filemac".
-
Rather than a Container field, your field should be a Calculation, with "Calculation result is..." set to "Container".
-
What exactly do you mean by "display"? This may depend in part on what's in the container (graphic, file, etc.) If it's a file, do you just want to see the file icon in a larger view? Or are you looking for some kind of Quicklook-style preview? Since I'm not sure exactly what you want, this is just a guess: But you could put a largeish container field in the *parent* record (name it Parent::ContainerPreview), and put a button in the portal row that sets the value of Parent::ContainerPreview to be Child::Container. That gives you a way to browse the portal row container fields without navigating to another layout. Here's a dead-simple demo file. Portal_Browsing.fp7.zip
-
Thanks, and glad I could help. Once you are already using Applescript to check whether the hard drive is present, I think you would be best off doing a Find on the filepath (Option 3) rather than cycling through records. Just a thought.
-
Option 1: (a) define a calc field to show the container as text. ( Write a script that searches on the text field for the name of the hard drive and includes or excludes found records on an ad hoc basis. Note that this isn't smart enough to detect whether the hard drive is there, but gives you almost the same functionality. Option 2: Use a script (triggered on record load) that uses Applescript to check whether the referenced file exists. See my posts in this thread: http://fmforums.com/forum/showtopic.php?tid/211611/post/342555. You could add a script step that excludes the record if the result of the Applescript is that the reference is missing. Note that this option works on a record-by-record basis. To exclude all records with a missing reference, you will have to loop through the entire database, which maybe isn't what you want. Option 3: Some combination of the above. An Applescript checks to see if the hard drive is mounted, then (depending on the result of the Applescript) a search on the text field excludes or includes records from a given hard drive. I'll try to upload a demo later.
-
Couldn't you just use the Get(LayoutName) function? Cycle through all windows, as you described above; in each window, If (Get(LayoutName) ≠ "Scr.1") then close window. On the other hand if two or more windows have the same layout in it, this will keep them all open. What do you want to happen in that case?
-
Oh, and ignore that extra "Applescript" table (the one that has no records) in the demo file I just uploaded. It was left over from an earlier version; I forgot to delete it before uploading.
-
Here's another way to do it. A set of calculation fields determines what kind of "stuff" is in the container -- whether it stores an embedded object or just a reference, the prefix type (for reference files) and filepath, etc. Then a script executes an Applescript command to check for the existence of the file. In this example the script is triggered any time the record loads or the container field is modified; it can also be executed directly by a button click. This demo also shows how to pass parameters from FMP into Applescript, and how to pass results back again. Check_for_Containers.fp7.zip
-
Really? I've only recently started using this method myself. Previously I always used a join table for this kind of thing, but this seems so much easier. Could you give me some examples of the kind of problem I am setting myself up for? It's not too late for me to turn back.