Jump to content

PKF

Members
  • Content Count

    19
  • Joined

  • Last visited

Community Reputation

1 Neutral

About PKF

  • Rank
    novice

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    High Sierra 10.13.4
  1. We just connected Tableau version 2019.3.0 with FileMaker 17 hosted files on a VM. Each time we try to connect to FileMaker files from Tableau using the WDC, we see a message that says 'This version of the Web Data Connector library is deprecated and will fail to work starting in the next release of Tableau. Please upgrade to the latest version or contact the developer of the WDC'. Here is my dumb question. Is the WDC part of Tableau or does one need to get a new WDC from FileMaker? In either case, I'm not sure how to swap a revised WDC for the old one. I suspect some of our problems crea
  2. I apologize in advance for my lack of knowledge. We would like to switch from FMS 14 to FMS 16. Version 14 resides on a VM and the hosted databases have container fields that use external links back to actual files stored on this VM. Can we simply install FMS 16 on top of FMS 14 and by doing so preserve the external links to container information? Also, where do the files corresponding to containers actually reside? I know they are somewhere on the VM, but not sure where and whether they are easily recognizable based upon their names. Again, my apologies for asking what many might co
  3. I couldn't find a pre-made solution to convert nucleotide sequences into corresponding amino acid sequences, so I created two scripts and some value lists to do the job. Each value list contains all possible nucleotide combinations corresponding to a single amino acid. For example, Value List 'A_ALA' for alanine contains: GCT, GCC, GCA, GCM, GCK, GCW, GCS, GCB, GCD, GCH, GCV, and GCN. Notice that some of the letters correspond to ambiguities, and hence IUPAC codes (R, Y, M, K, W, S, B, D, H, V, N) are used here. This is important if one is doing population sequencing on HIV viral sequences
  4. Did you ever develop a script to convert nucleotides into amino acids? I am also thinking about this, but don't want to reinvent the wheel.
  5. Any help for this poor misguided would-be database designer would be appreciated. If a user indicates he/she wishes to exit the database, this script progresses appropriately to the 'Exit Application' step, but then loops back to the custom dialog a 2nd time! On the second pass through the script, the database closes. Any idea how this could happen and how to avoid users having to respond twice about exiting a database? I'm stumped. The same looping occurs if using the 'Close Window' or 'Close File' steps. Here's the actual script: # Script exits database Show Custom Dialog ["E
  6. If a user indicates he/she wishes to exit the database, this script progresses appropriately to the 'Exit Application' step, but then loops back to the custom dialog a 2nd time! On the second pass through the script, the database closes. Any idea how this could happen and how to avoid users having to respond twice about exiting a database? I'm stumped. The same looping occurs if using the 'Close Window' or 'Close File' steps.
  7. Thanks for the 'robot' machine idea and the note about the cause of the slow operation. I believe the slowness is because it takes time for the script to generate the various charts, not due to moving them about. For this reason, the robot approach makes sense. I am assuming that one can run the script in the robot file on a schedule from the server admin console so that the script runs after hours, say once a day? I haven't tried running a script in one file that manipulates data in a second file, so this should be a great learning opportunity! Thanks again for the help.
  8. We would like to display data from multiple tables in the form of charts on a single layout. Filemaker does not allow this, so I am seeking a work-a-round that is not going to significantly add to the overhead. I have a solution that works. It involves container fields and a script that runs at start up. Unfortunately, this script dramatically slows the start of the database, especially if the database is accessed via VPN while away from work. We are using FMP12 clients on Macs running OSX 10.8 or 10.9, and our database is hosted on a server running FMP12 Server. Any ideas would be
  9. I hope someone can help this neophyte. A "Samples" layout contains sample information and freezer locations on 60,000 biological samples. It is very tedious to manually create multiple sample find requests because each find requires the entry of three fields. To automate finding samples, users populate Excel records with three fields: SampleID, SampleType, and SampleDate. A script imports these fields into a related "SampleQuery" layout, but this is where the script fails. The plan was to create multiple find requests in "Samples" corresponding to the number of requested records in "SampleQu
  10. Hi Ralph, Thank you for your advice regarding how to "hide" a specific field by using duplicate layouts containing global fields - one layout with a specific field and one without. I've partially implemented your solution by writing a script to direct a user to the appropriate layout. A remaining problem has to do with an ID field set up as a serial number in each of the two 'global type' layouts. You can't automatically display the next ID value if this ID field is identified as a global. If it is not set as a global, the value can be shown (upon record creation). However,
  11. A user will select one value from a popdown menu. The selected value should determine whether another entry field will be shown (required) or hidden (superfluous). I wonder if this should be controlled by a script. However, I can't think of how a script would be activated automatically in response to a user input (in this case, the entering of a value from the popdown menu). Any help would be much appreciated.
  12. Thanks for the solution! This approach should work, but given the number of entry layout screens and the number of fields/layout, this method seems very labor intensive. Why doesn't FM7 allow developers to force processing through scripts instead of allowing users the option of bypassing scripts by committing records by clicking outside fields. This seems to be a major weakness of FM7.
  13. A button-attached script will perform error checking for field entries and then commit the record. I do NOT want a user to be able to commit a record by clicking outside a field, thereby avoiding using the button. Is it possible to disable this default Filemaker7 feature?
  14. A parent table creates sequentially numbered sample names (e.g. Sample34, Sample35, ..., Sample42) that are stored in separate records along with other descriptive data (essentially duplicated data with the exception of the unique sample names). The user determine the number of sample names by entering the number of sample replicates. A daughter layout must show these sample names on one side of the screen so that a user can copy and paste these sample names from the list into a portal on the other side of the screen that is designed to simulate a 9x9 grid storage box (i.e. one sample name per
  15. A parent table creates sequentially numbered sample names (e.g. Sample34, Sample35, ..., Sample42) that are stored in separate records along with other descriptive data (essentially duplicated data with the exception of the unique sample names). The user determine the number of sample names by entering the number of sample replicates. A daughter layout must show these sample names on one side of the screen so that a user can copy and paste these sample names from the list into a portal on the other side of the screen that is designed to simulate a 9x9 grid storage box (i.e. one sample name per
×
×
  • Create New...

Important Information

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