FileMaker Pro Advanced 12.0.1 Portable
Nelson Suggs
FileMaker Pro includes features that help you develop and deploy FileMaker Pro custom apps faster and more efficiently. These features are available when the Use advanced tools general preference is selected.
I've manage to follow -nation/discussions/28127/managed-installation-of-filemaker-pro-16 but when I push it to a new machine it install as a trial version. The assistant text file has been edited with our volume license key and company name.
Our solution was pretty simple. I just built a composer package to deploy the FileMaker package and Assisted Install.txt file to /private/tmp and then used a post install script to run the installer and remove the temporary tidbits.
Nevermind. I was successful when I re-attempted to upload the 2 .pkg files directly after downloading them from the FileMaker downloads page for 17.0.3 and 17.0.4. I put each as a separate policy and triggered 1 to install after another. I initially had both packages in the same policy and 17.0.4 must have been running before 17.0.3 finished.
Jamf's purpose is to simplify work by helping organizations manage and secure an Apple experience that end users love and organizations trust. Jamf is the only company in the world that provides a complete management and security solution for an Apple-first environment that is enterprise secure, consumer simple and protects personal privacy. Learn about Jamf.
This site contains User Content submitted by Jamf Nation community members. Jamf does not review User Content submitted by members or other third parties before it is posted. All content on Jamf Nation is for informational purposes only. Information and posts may be out of date when you view them. Jamf is not responsible for, nor assumes any liability for any User Content or other third-party content appearing on Jamf Nation.
Science Chicago hosts Mythbusters
Through August 2009, Science Chicago offers tours, hands-on activities and other science-related events for adults and children, many free of charge. Events include the Fermilab Open House on Jan. 17 and a visit by the Mythbusters of the Discovery Channel, Adam Savage & Jamie Hyneman, on March 1 at the Harris Theater. Check out the Science Chicago calendar for details and many other events
IRS Final 403(b) Regulations
The Internal Revenue Service has finalized regulations covering the 403(b) plans. The memo explaining in detail the changes to the eligibility requirements for obtaining hardship withdrawal distributions will be sent to all employees. You can have access to the memo on the Benefits Web site at:
NALWO - A Russian Style New Year
This is a traditional Russian Style New Year celebration for children, Saturday, Dec. 20 from 11 a.m. to 1 p.m. at Kuhn Barn. The event will begin with a non-professional childrens performance, in the Russian language, based on the Russian folk tale Twelve Months, English translation will be provided. Grandfather Frost will visit the children following the performance, and traditional Russian songs will be sung by all. Food and non-alcoholic beverages will be provided, following the activities.Please note that this is a ticketed event. Adult admission is free, but children admission is $10. The fee covers the cost of a gift, pizza, and juice, for your child. To make your reservation call Madina Sukhanova at (630)846-6501 by Dec. 9 or e-mail Madina.S...@gmail.com. Barn Dance Dec. 14
Fermilab barn dance Sunday, Dec. 14 in the Kuhn Village Barn at 6:30 p.m. with music by Sam Strong and calling by Tony Scarimbolo. For more information visit
Fermilab Blood Drive Dec. 16, 17
Mark your calendars. Heartland Blood Centers will be here for the Fermilab Blood Drive on Dec. 16 and 17 from 8 a.m to 2 p.m. in the Wilson Hall Ground Floor NE Training Room. Appointments can be scheduled on the Web or by calling Diana at x3771 or Margie at x5680. More information can be found here (pdf).
The University of Chicago Tuition Remission Program deadline Dec. 17
The deadline to apply for the tuition remission program at The University of Chicago for the Winter 2009 quarter is Dec. 17th. For more information and enrollment forms, contact Nicole Gee at x3697 or visit the Web site -dev/uchicago.html Weekly Time Sheets are due Dec. 18
Week ending 12/21/08 time sheets are due in payroll by 10 a.m. on Dec. 18. The pay date will be Dec. 23. International Folk Dancing Holiday Party Dec. 18
International Folk Dancing will hold its Holiday Party Thursday, Dec. 18, at Kuhn Village Barn. Dancing begins at 7:30 p.m., upon request teaching as needed. Newcomers are welcome and you do not need to come with a partner. Contributions of treats are welcome. There will be no international folk dancing on Dec. 25 or Jan. 1. Info at 630-584-0825 or 630-840-8194 or e-mailf...@fnal.gov
Monthly Leave Sheets due Dec. 19
Monthly leave sheets for Dec. are due in payroll by 10 a.m. on Dec. 19. The pay date will be Dec. 30. This cutoff time does not apply to employees who are on the FTL system. Their normal schedule applies. Shop early - Lederman Science Center store open until Dec. 20
The Lederman Science Center and gift shop will be closed for the holidays beginning Dec. 22 through Jan 2. Please place online orders by Dec. 18 to ensure mailing. Deliveries before Christmas are not guaranteed. The LSC will be open on Saturday, Dec. 27, 9 a.m. to 3 p.m. Regular hours resume Saturday, Jan. 3. Contact Andrea Varry at x8258 for more information. Barn Dance Dec. 21
Barn Dance Sunday, Dec. 21 at 2 p.m. in the Kuhn Village Barn with music by Just Us Chickens and calling by Dan Saathoff. For more information visit
Find carpool partners with PACE
PACE offers a free program to look for carpool partners. Register at and enter the start point of your daily commute. Then choose Fermilab from the list of employers and select Fermilab again for the street address. To find carpool partners for the West Chicago and Route 59 Metra train stations, enter the address of the train station as the start of your commute. You can look up the train station addresses here: For groups of five or more, PACE offers vanpool programs:
Python Programming - Jan. 6 - 8
Learn the basics of Python programming and become proficient enough to apply the language for day to day tasks. For more information or to enroll please visit -esh.fnal.gov/pls/default/schedule.show_course_details?cid=3647 Intermediate / Advanced Python Programming - Jan. 27 - 29
Learn the Intermediate and Advanced features of Python programming. For more information or to enroll visit -esh.fnal.gov/pls/default/schedule.show_course_details?cid=3691 Annual enrollment carrier meetings Dec. 9
Representatives from Blue Cross/Blue Shield and CIGNA will be available to answer questions and assist with Annual Enrollment at meetings this month and next. View the meeting schedule here (pdf).
FileMaker Pro 8.0 - Dec. 10
Learn the more advanced features of FileMaker Pro and techniques of integrated database system design. For more information or to enroll, please visit -esh.fnal.gov/pls/default/schedule.show_course_details?cid=4640
INTRODUCTIONThis online Guide is designed for detailed documentation of
GeneRecords 1.0 software.A quick, illustrated Tutorialteaching how to install the software
and how to import the desired GenBank entries is available.--GeneRecords is a solution for GenBank biological flat file
parsing, as it implements a structured representation of
each "feature" and "feature qualifier" in GenBank following importin a
common database managing system usable in a personal computer
(Macintosh and Windows environments).This collection of related databases enables the local managementof
GenBank records, allowing indexing, retrieval and analysis of both
information and sequences on a personal computer.Minimal requirements for use are:
Macintosh OS 8.1 or later, 9.x
Macintosh OS X with Classic
Windows OS 95/98 with Internet Explorer 4.0 or later,
NT4.0 with Service Pack 3, 2000.
Download GeneRecords 1.0 forWindows from address:
_1.0/GeneRecordsWin.zipThe downloaded file should to be automatically decompressed,
generating a "GeneRecords" folder.
If it does not happen, the decompression needs the "StuffitExpander"
(or any other unzip) utility.The GeneRecords Folder contains:
GeneRecords file (runtime application),
42 related subdatabases (.DNA files),
the "Search and Replace" helper application folder,
the "BK ReplaceEm" alternative helper application folder,
the "Parsed file" empty folder.
The "LocusLink" database,
formatted for GeneRecords relationshipsis provided.
The "Fasta extractor" is an utility to generate sequence in FASTAformat.
The "Win_Tutorial" and "Win_Guide" folders contain a copy
of the on-line documentation, for local (off-line)use.GeneRecords is based on FileMaker Pro 6 (FileMaker Pro, Inc.)
database management software (www.filemaker.com/index.html).It is released as a set of related FileMaker Pro templates thatwill import
any set of GenBank-formatted entries into a local database,
including a free runtime application to run "FileMaker Pro" atthe core of
the software.
The GeneRecords database directly imports GenBank flat files datasources,
automatically pre-formatted by a text-filter, and it contextuallygenerates
a relational database with 42 files containing the parsed data,making them
available for complete search and analysis. The system implementsan
independent representation of each feature and its respective qualifiersin
GenBank within a common database managing system usable in a personal
computer (Macintosh and Windows environments).The master file of GeneRecords collection is the file "Records"
(extension is .DNA).
Clicking on the "GeneRecords" application causes the opening of
"Records.DNA",
which readily opens all the related subdatabases.The "Records.DNA" layout functions as the GeneRecords package mainview,
and it is a way to access all subdatabases that constitute thepackage.It is organized in a GenBank entry-specific way:
each database record in "Records.DNA" contains datafrom one GenBank entry.
The software package contains also the related subdatabases listedhere
(names are the same as in the official GenBank featuresspecifications):CDS; ClipX; Conflict; D_loop; Exon; Gene; Hyphen; iDNA;
Intron; LTR; Mat_peptide; Misc_binding; Misc_difference;
Misc_feature; Misc_recomb; Misc_structure; Modified_base; mRNA;
Old_sequence; PolyA_signal; PolyA_site; Primer_bind; Protein_bind;RBS;
Reference; Region_X; Rep_origin; Repeat_region; Repeat_unit; RNA_X;
Satellite; Segment_X; Sig_peptide; Signal_X; Source; Stem_loop;
STS; Transit_peptide; Unsure; UTRX; Variation.Please note that some features of the same type will be imported
in the same subdatabase; in particular:
the "ClipX" database includes the features: 5'clip, 3'clip;
the "UTRX" database includes the features: 5'UTR, 3'UTR;
the "Region_X" database includes the features:
C_region, S_region, V_region;
the "RNA_X" database includes the features:
misc_RNA, precursor_RNA, prim_transcript,
rRNA, scRNA, snRNA, snoRNA, tRNA;
the "Segment_X" database includes the features:
V_segment, D_segment, J_segment, N_region;
the "Signal_X" database includes the features:
attenuator, CAAT_signal, enhancer, GC_signal,misc_signal,
promoter, TATA_signal, terminator, -10_signal,-35_signal.
METHODFirst, a detailed description of GenBank flat file format
( )
has been accurately analyzed for:1. identification of characters usable as consistent limits
for each data type;2. conversion of the flat file format in a multiple related tableseries,
allowing the appropriate import for each data type.Our strategy is thus based on treatment of the downloaded, expandeddata file
by a fast text conversion utility in order to find, change or insert
control characters (e.g. insert carriage return and tabs at a desiredpoint,
to define the end respectively of each record and of differentfields in
the same record).
This step is performed by fully automated text filtering
(we enclose "Search and Replace" by Funduc Software Inc. or
"BK ReplaceEm" by Boolean Dream for Windows,
both ready to load an appropriate, provided replacement "filter"
based on invariant features of the GenBank flat file format.At this point the file is ready to be imported into the appropriatedtext
fields (e.g. NM Entry, Features, Seq1 50100) of GeneRecords.
In this step, the master file is filled inwith the entry set data
("raw data" layout),
using the "tabulator" characters appropriatelyinserted
by a text replacement utility.
Each GenBank entry is imported as onerecord.Finally, GeneRecord will automatically parsedata using calculated fields,
that extract each single data type from thetext fields.
This process is driven by FileMaker pro (FMP)scripts
launched by the "Import data" button.At the end of importation step, several kindof subscripts create
a new record in related subdatabases foreach feature reported in any entry;
these records contain only the accessionnumber and a progessive numeration.
These data create the relationships betweeneach subdatabase and the
master file, allowing the visualization ofthe data (read from the
Records.DNA) within specific field in eachsubdatabases.
Each feature of the entry is visualized ina dedicated subdatabase.In the master file, different layoutsare accessible from the "Layout
menu", (a pop-up Menu in the top left corner,above the small book icon).
Each layout contains fields within a "portal",the FileMaker Pro tool for
construction of relational databases.
Each field visualizes the related subdatabasecontent for each feature.It is possible to visualize these layoutsalso by clicking on the
"To Features" button,
and then on the desired green button neareach feature name.--
The free included FMP runtime allows freerecords management and browsing,
while the creation of new fields for elaborationor further relationships
definition require the installation of theFMP application.
We encourage any creative use, modificationand noncommercial redistribution
of GeneRecords, as long as the original paperis cited,
and statement that the original program hasbeen modified
is provided (if the case).The availability of complete GenBank datasetsin a relational database
format allows the easy integration with otherbiological databases available
in the same or similar format; for example,Unigene(collection of ESTs
clusters) and LocusLink(a table of correlation among different types of
biological data) can be easily imported inan FMP template.
Our release includes the integration withLocusLink,with the respective
GeneOntology tags.
INSTALLATIONYou have simply to install the provided text replacement utility,
which works together with GeneRecords.Two equivalent alternatives are availables:
install "Search and Replace" (faster, but requiring a $25 fee after 30 days)
or install "BK ReplaceEm" (slower, but it is a freeware).
The respective folders are located into the "GeneRecords 1.0 Win"folder.A. Search and Replace1. Install "Search and Replace"
by double-click on the file "setupsr", in the folder "Search and Replace"
(default options).
2. Open Search and Replace application,
choose "Script..." from "View" Menu,
click "Load" button in the appearing window,
choose file "Script Search and Replace.srs"
(in the "Search and Replace" folder)
click "Use Script" button,
type "*.*" (without quotes) in "File Mask"field,
click on "..." (three dots) button tothe right of "Path" field,
choose "Parsed file" folder in "GeneRecords1.0 Win" folder.
Quit the application.B. BK ReplaceEm1. Install "BK ReplaceEm"
by double-click on the setup file "bkrep20", in thefolder "BK ReplaceEm"
(default options).
GENERAL DEFINITIONSFile
One set of records pertaining to the samesubject.
GeneRecords is a set of 42 related files.
It includes a "master" GeneRecordsfile (Records.DNA),
related to 41 files (subdatabases).
Each subdatabase correspond to one (or more)specific
"GenBank Feature", except"Fasta extractor.DNA"
(an utility to convertsequence data in Fasta format).
A file with "LocusLink" data is also provided.Record
One set of fields which constitute oneentry.
One record contains data about one GenBankentry.
The record browser is a small book icon
at the top left of thewindow.
You may browse the database by clicking onthe book pages,
or enter a record numberand click on "Return" key.
You constantly visualize these informations:
Records: totalnumber of Records in the database
Found: total numberof Records currently selected
Sorted: sortingstatus of the Records (Sorted/Unsorted)Field
One area of the record containig a specificdata type.
In the subdatabases,
each field corresponds to a specific "GenBankFeature Qualifier"Browse Mode
A mode to use the database.
It allows data entry, viewing, browsing,sorting, manipulation.
It may be selected:
from the green "Browse mode" button on thewindow, or
from the "View" menu, or
from the mode pop-up Menu bar, at the bottomleft of the window.Find Mode
An alternative mode to use the database.
It allows searching for specific contentin the databases fields,
using any different combination of criteria
(see the "Searchmode" section below for details about searching).
It may be selected:
from the green "Find mode" button on thewindow, or
from the "View" menu, or
from the mode pop-up Menu bar, at the bottomleft of the window.Preview Mode
An alternative mode to use the database.
It visualizes a print preview of the foundrecords.
It may be selected:
from the "View" menu, or
from the mode pop-up Menu bar, at the bottomleft of the window.Layout
A particular graphical organization of thedatabase fields.
A file may show data from within differentlayouts.
Visualization of a field is independent fromthe
memorization of the data it contains.
The user can navigate among the differentlayout of a file by the
pop-up Menu (Layout Menu),
clicking on the bar at the top of the book icon.USE1. Download GenBank entries
Download a set of desired GenBank entries
(GenBank entry sequence allowed maximum size: up to 1,102,200 bp)
from any database which supports GenBank format
(GenBank "CON" division, i.e. NT_entry code, is not supported).There are two usual alternatives:I. Querying GenBank viaWorld Wide Web at:
=nucleotide&TabCmd=Limits