2 posts in this topic
Hi...I have created a database using a "modified" anchor buoy method and so far everything works great...but...I have a portal in a "join table" that works fine...however, my button that is supposed to open the record in the portal row does not function...it returns nothing. The records are indeed related (see RG) as the fields show up from the related table without relational conflicts, but this button that is supposed to open the "library" table with the related record pulled up simply does nothing.
I have attached the DB. Also a screen shot of the table where the portal is (it is actually a join table layout, this may be the problem). I don't understand how the button (with the little arrow) does not go to the table that the actual portal record, which IS related because I see it show up on the portal row...what is not right here?
By Tony Morosco
I'm a botanist, and the tables I am working with are for tracking botanical garden collections. The data represents plants in the garden, and the plants are tagged and show up in the database. The tables I am working with were created in FMP 7, and I'd like to open them up in FMP 11 (or later.) The system hasn't been used in years, but still has valuable information.
One of the tables is giving me problems using the FMP convert and recover commands.
These tables are all inter-related. The main table is the Accessions table, which contains records for all of one kind of plant, from the same source, received on the same date. It is basically a museum standard.
The other tables are related to each other through this one main table. The Species table is related to the locations table through the Accessions table.
(i.e. table A relates to table C through the table B, the intermediary)
From the Locations table, we can't see the the species information unless the accessions table is present.
When issuing the open command on the main table to convert the database to FMP 11, I get the message:
"Accessions.fmp7" is damaged and cannot be opened. Use the Recover command to recover this file. When using the Recover command from v. 11, I get another message:
WARNING: problems were detected while recovering the database. Please review the Recover.log file to see where problems were found and their severity. The recovered file should NOT be used going forward; copy only the most recent work from it into a backup copy of the original file. Recovery results: File blocks: scanned and rebuilt 563 blocks, dropped 214 invalid data blocks. Schema: scanned fields and tables, 1 items modified Structure: scanned; 1 items modified Field indexes: rebuilt
Opening the recovered database, there are only three records present. There should be hundreds. So obviously I am looking on how to wrangle this database open.
I've attached the log file here, as well as the database structure map.
The other files have converted just fine. But since the main table won't open, we are kind of stuck.
I can share the files with you through Dropbox or whatever, if needed.
Please let me know any thoughts you have, either basic or advanced. And ask for any clarifications or additional questions. :-)
I am trying to set up a database to calculate and report exhaust emissions from diesel engines and am stumped at Step #1: The infamous Entity Relationship Diagram!
I am looking at a few thousand engines and need to calculate how much of what kind of pollutants they kick out into the air. I have spreadsheets that list the Year of Manufacture, the horsepower, the serial number, how long the engine ran during a given year and how much fuel it consumed during that year. I also have some spreadsheets that list what the Emission Factors, usually expressed in pounds per hour operated or pounds per gallon of fuel consumed, for each of the two dozen chemical compounds I’m interested in tracking.
Those emissions are relatively simple to calculate: Multiply the Emission Factor times the number of hours operated (or times the gallons of fuel consumed) and we’re done. Except for the fact that the Emission Factors are based on the Year of Manufacture and, in some cases, the horsepower rating of the engine, so I have to circle back around to the Engine table: I don’t know how to connect the emission factor for, say, Arsenic to a specific engine, say a 154 hp Chevy made in 2014, based on that engine’s year of manufacture and hp rating.
So my ERD keeps looking something like this: Engines --->Emission Factors--->Engines or Engines ---< Emissions >---Emission Factors--->Engines
My computer keeps puking ones and zeroes all over my keyboard when I try either setup in my Relationship Graph!
The only other way I can think of accomplishing these seemingly simple calculations is to write a boatload of scripts with variables, but I’m not even sure I could come up with all of the combinations/permutations involved. And, unfortunately, I can’ even spell SQL, let alone know how to execute one of ‘em!
I have attached a (simplified) copy of the spreadsheets I currently use to better explain my problem. I hope one of you will find this to be mind-numbingly simple and explain how it should be done. Thanks very much for your time and consideration.
Engine Emissions Calc Sheet MOD for FMF.xlsx
By Gently Does It
I am working in a biology lab and have developed several basic databases using filemaker 11 to help the lab organise their stocks of chemicals and so on. We have a fairly onerous excel sheet that we have to fill out for registering certain new reagents we make with the regulatory authorities and as these are a pain to use, they are not filled out regularly enough. I would like to simplify this for everyone by making a filemaker form/database that will automatically fill out as much detail as possible.
The data in question is that when we clone a piece of DNA we need to insert this into several different DNA vectors that are used for different things. Whenever this one particular piece of DNA is inserted into a new vector it must be registered, so for one piece of DNA there may be , lets say 6 individual entries in the database, all saying more or less similar things, but just having different target vectors. I hope this isn’t already sounding to weird.
I have a plan that I will have a ‘home screen’ with a field for entering the name of the DNA and then some tick boxes for each of the common target vectors. What I would like is that all my colleagues will need to do is tick the boxes for the vectors they want to clone the DNA into and filemaker will then automatically populate a new entry for each of the vectors specifically for the new DNA they have cloned. As I have some basic experience, but am admittedly very limited in my scripting knowledge, I am unsure as to how best to do this. Would it be best to have a button next to each of the vectors instead of a tick box that would run a script that would take the name of the DNA in the field and then make a new entry based on the associated vector? If so can anyone suggest how this would be best organised. I am guessing I only need a single table with two layouts, one for the home screen and one for viewing all the entries.
I’m sorry if this seems a bit convoluted.
Thanks for any help.
Is there a way in AppleScript to trap if the connection is lost and have an AppleScript act on this?By ggt667
Is there a way in AppleScript to trap if the connection is lost and have an AppleScript act on this?
At the risk of asking and answering myself( AppleScript below )
repeat tell application "FileMaker Pro" try database "db" on error do shell script "sudo shutdown -r now" with administrator privileges end try end tell delay 59 -- 59 secs end repeat