Jump to content


  • Posts

  • Joined

  • Last visited

chrisk1's Achievements


Apprentice (3/14)

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

Recent Badges



  1. Yes, that's exactly what I need, to view a PDF stored as a file and not a reference. I'm not sure it's impossible but I haven't been able to do it. I think what I may end up doing is this: PDFs in my database are automatically inserted by a series of AppleScripts and FM scripts when created. When that takes place, it will also place a duplicate of the PDF on the web server and have URL info leading to the PDF calculated and stored along with the PDF in FM. Then, through IWP, share the database out and include on the layout a button with an Open URL script that leads to the PDF. That way they can view it or download it or whatever they need to do from their browser without needing to deal with the Web Viewer component at all. I was just really excited about being able to justify the need to upgrade and get my hands on the web viewer. I originally had designed my database to view and navigate the PDFs right in the layout and it worked great, until the first Windows user logged on...was hoping the upgrade might open that feature back up for me. Thanks for all the help and suggestions, everyone!
  2. Thanks. I DL'd the plugin and and installed it, works fairly well. However, the problem I have with this is that it only works if the PDF is stored as a reference in the container, and is local. A PDF from across the network breaks the function as does a PDF stored as a file in the field. I've been reading that images in containers can be viewed in the viewer, but they must be broken down to Base64 using independent website(s) and then some behind the scenes wizardry takes place within FileMaker, but I don't think this would be an appropriate solution for a PDF, especially the PDFs we deal with. I guess to break it down into simpler terms, does anyone think it is viable to to create an IWP solution for clients, externally, to view and access PDFs of their jobs as well as other related data? Or would it be more appropriate to create a data-driven web solution that accesses the data I have within FileMaker? If it were an IWP solution I feel I would need to develop a function that A ) Has a separate layout interface for the clients that pares down info related to their jobs, that is shared out by IWP, B ) Create functions that would export HTML that contains links to (and to download) the PDFs, as well as the actual PDFs, to our server, which in turn C ) Are viewable by the client layout interface that will contain a web viewer element. I just need to know if it's possible. If so I can figure out how to do it. A year ago I never used FM outside of Browse mode and I was able to build the database that 75% of the company now depends on for it's workflow. This was possible mostly by either finding the solutions here, or just finding that they were possible and taking it from there. And now I'm counting on it more than ever. :D
  3. I have downloaded an 8.5 trial and a few Web Viewer examples and so far I'm pretty disappointed. None of the examples I have been toying with will display a PDF, local or otherwise, stored as a reference or file. The only thing that happens is that the first time I import a PDF and FM tries to display it in the Web Viewer, I get a dialog box asking me to open something. What I am supposed to be looking for, I have no idea — files are grayed, browser apps are grayed, and Acrobat is selectable but nothing happens when selected. I am totally confused by this. The reason for this post is this: I have developed an in-house workflow for our Production and Creative processes. The db contains, among a vast variety of other information related to our job processes, scheduling information and PDFs of creative. We have been using this for some time and it is fairly solid. The challenge is that a potential client has been promised the ability to go online to view information related to their jobs and status, as well as view and download PDFs of current creative for proofing and/or approvals. All of this would, of course, need to be tied to our FileMaker-based workflow since this is where all of this information currently resides. When this was brought to me (after the fact of someone having promised it) the first options I could provide were that I could develop an IWP solution interface and we would need to upgrade to Server Advanced (for serving IWP) and FM 8.5 (for developing the Web Viewer that I've heard SO much about). Since IWP does not support exporting field contents it would be necessary to use the Web Viewer to display a web page with the PDF and a download link, since so far I have not seen any evidence that it actually will display a PDF. Am I just doing something wrong? The examples I have been experimenting with explicitly state that storing a PDF in this container field will display the PDF in this viewer field. But it does not. So anyway my main challenge—would I need to somehow develop a solution that: Provides access for our clients using IWP, exporting HTML (as well as the PDFs) to our server that displays and makes the PDFs available for download through the Web Viewer that is on a layout served by IWP? It seems kind of silly to me to add a Web Viewer to a page that people will be using a web browser for to begin with. -or- Would the best option to be to use a synergistic approach and use FM to export HTML, PDFs and XML to our server that would be accessed by some type of data-driven web solution and avoid IWP altogether? I am desperate to even provide an option for a solution, let alone say I can do it. I have about a week to "fake" an example of what we are promising, and then not much time thereafter to actually develop the system. Thanks in advance for any advice.
  4. Thanks, all! Value count of window names did the trick! This also solves a few other related problems I've been hesitant to bug people with. Hopefully someday I can be as helpful as yall have been to me. Thanks again — CK
  5. Is there a way to get a count of the number of windows that a certain database has open at any time? Long story short—my users keep on exiting the database by closing windows (using close buttons I've created) and need to log back in, which they get tired of quickly. I tried a script to let them know when they are about to exit the db, and not just a window, and set it to run when the db closes through file options. But when the cancel option is selected to stay in the db, it closes out anyway, I'm guessing because technically the file is closing and nothing can stop it. I'd like to be able get an open window count and test that when they hit my close buttons, so if the window count is 1 when they close it gives them the option to cancel and stay in if they want. I haven't been able to find anything that will return this value in the lists of functions. Thanks! — CK
  6. I don't understand how creating a global field to sort the portal by, then writing a two step script to assign a value to the global, is considered bloating. Including assigning field names as button parameters to sort your portal by, this takes no more than 5-10 minutes. I just finished creating all the necessary tabs for headers in my portal (six times 2 for asc and dec), then copied and placed all the portals for the tabs, had to set the sort for all 12 portals, refomatted the tab titles to align properly (not even wanting to think how this will eventually display in XP), then had to monkey with making sure my arrow graphics were aligned correctly over the right tabs while retaining consistency from column to column. This took nearly an hour, but it does work. I only have about 25 more portals I need to do this to. I just don't understand why there isn't a way to script switching from ascend to descend per column. This makes about as much sense as FileMaker not natively scrolling a portal horizontally.
  7. Genius, my friend, pure genius. Looking back at the specification documentation this totally makes sense now. This actually answers many questions I know I would have had to ask in the future but thanks to this I won't have to. Man, thanks so much! I've been using XSLT to fill forms in PDFs, but since saving was removed from Acrobat Reader I had to scrap it and try this method. So I've actually only been exposed to the real inner-workings of XSLT for about a week and a half. Good example of how something so complicated can work so simply. Thank you so much again!
  8. Hi, thanks for your response. I know this isn't a specifically-FM related topic but it's the only place I thought I'd be able to get a decent answer, so especially thanks. I have been able to peek into some actual RTF code and have seen the font table structure in the language specification, so what you posted did look familiar but I don't think it helps me. If you look into the file I'm posting you can see that the section near the top declares entities to use as elements of a style sheet, and that a form of tag is created which is used throughout the document to instruct and RTF-compatable editor to display text as the format tags instruct it to. I am able to use this method to format all sorts of character attributes (bold, size, etc.) however specifying a specific font eludes me. I would assume that specifying a specific font would be possible, since if I create a document in Text Editor and specify a word to be "Garamond" it displays in that font, even when opened in Word. I have scoured the RTF laguage specification up and down several times and have not been able to find a solution, nor have I been able to find a file that would be a good example of what I'm trying to accomplish font-wise. The file I am posting is a modified version of the "RTF with XSLT" example in the XSLT library on FileMaker's site found at http://www.filemaker.com/products/technologies/xslt_library.html I've been using Dreamweaver's code view to edit the files as the tags are easier to view. Please excuse the excess of tabs and general untidiness Thanks in advance for any help anyone would be able to give me. Like I said, I truly am at the end of the rope here. xsltExample.txt
  9. At the end of my rope here In an XSLT style sheet to format text with a specific font when creating an RTF document- Using this language to create a formatting command: RTFcodeFontname "> and as the formatting command: &RTFcodeFontname; ...what would I use as the "RTFcode" for an RTF formatting code? I've been able to use this language structure to format everything from size to line spacing to color, but I cannot find an example where it is dictated how to format text as a specific font. Thanks!
  10. Yes, the cells are uneditable. I didn't realize that (but should have, and should have mentioned that) because my layouts that would use the matrix are all for displaying final information and strictly draw on records from various layouts throughout my file that are continuoulsy edited throught a job process.
  11. I don't have anything I can post, but there is a working example included with download files that is fairly easy to decipher. I know how you feel because I was only using FileMaker from the dev side for about a month when I had to tackle this but it is actually pretty simple. However, no matter what I can't get the function to update the FileMaker record from the PDF to work properly yet.
  12. http://www.filemaker.com/products/technologies/xslt_library.html Go down to FMP to the PDF/PDF to FMP section. It took me awhile to get it figured out but it works well.
  13. Actually... Export your Flash file(s) as Quicktime, then insert them as quicktime into a container. You have to save the Flash version back pretty far in your publish settings, like 5 or earlier. There are some ActionScript functions that are not supported in ealier versions that will not work but I don't have any trouble so far. The only hitch I've really had is that no controls appear at the bottom of the container field when you click into it, like when it contains a multi-page PDF, and you have to context menu to play the movie (there may be an autostart feature you can turn on in the movie). You can actually interact with FileMaker through a Flash movie using the XML connector in your Flash file and bind it to elements of the FileMaker file. But I'm not sure if it will work through a QT movie. And I'm also not sure why you would want to work through Flash in a container field to get to FileMaker when you're there already. But navigation and hyperlinks all work fine. One more thing—if you have other .swf files that are loaded into your main movie by the loader component they will not load. I even tried replacing the .mov extension with .swf to trick it but no go.
  14. The actual records are retained. The portal just "forgets," I guess is the best way to put it, that it is supposed to be displaying records—until a new one is created, that is, at which point it wakes up and everything is normal. I added to my startup script steps to go to the layout of the missing records, create, then delete, a new record, then continue with the rest of the script. Of course this is no solution, just a workaround. If you're actually missing records when you reopen the file I would delete any other instance of the main file that has the same name, even from the trash, and make copies of your backups and save them out of reach. FileMaker has a tendency to go to older versions of the DB files, even in the trash. I had this same thing happen—I would enter data in a record, close it, then re-open it and everything I had entered had disapeared, and it was actually drawing on records in a previous version of the file it was finding over the network.
  15. Thanks, both of you, for the advice. Each suggestion does make sense but unfortunately does not solve the problem. The problem seems to be the difference in opening the DB directly and opening it as a shared file. Further review of other sections of the file also display the same problem in a couple places. As impractical as it may seem I may just have to add to the startup script steps to create and delete a new record for the problem tables. Thanks—CK
  • Create New...

Important Information

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