13 Replies Latest reply on Aug 25, 2014 1:41 AM by crm

    How To find all Fonts used in an old database


      Since around 14 years a small business application was always added on to match new needs.

      It started with FM 6, sticked to that Version until about 2.5 years ago, when I converted it to FM 11.

      Since then it grew in complexity and comfort quickly.

      It still uses around 12 FM Files with around 25 main tabels.

      And too many Layouts. And too many different Fonts.


      **** Could somebody know how to find out which Fonts are used within a database ? *******


      Maybe You can recommend a tool for that.

      Why doesn't FileMaker build that into their 'Developer' Version ?!

        • 1. Re: How To find all Fonts used in an old database

          I'm not sure of any platform that really gives that level of granular detail to give you a list of fonts and where they are used.


          IF anything exists in filemaker to give that detail, it would be in ther DDR (developers report, under tools) generated by FMP advanced. There are two notable "analysis" tools for the DDR, Beezwax InspectorPro, and Goya BaseElements. Although, they are more useful for telling you what's wrong or broken in your file as far as I know.


          What might be exponentially easier is to convert your files into FM13, which offers loads more control over consistency across many layouts. After you convert you could develop a theme with all of your customizations, then apply that theme across your file. This would make all fonts consistent throughout based on your theme, and also give you the ability to change the font from one location instead of requiring updating everywhere.


          It's a few hours of grunt work, but worth it in the end. And after 14 years, I'm sure there's a lot that's due for an overhaul.

          • 2. Re: How To find all Fonts used in an old database
            Stephen Huston

            I remember the days when Macs started to support a wide range of fonts, and people applied them for effec to everything! We had a term back in the '80s about a document having been "Mac'd" if it looked like a pasted-up ransom note.


            I can recall multiple fonts on a single FM layout back then being common, with different fonts and font-weights for labels and fields being FM's defaults. Later I started changing everything on a layout to Verdana, just to assure x-platform compatibility.


            You might try taking an off-line copy of your file system, and working your way through each file, converting all objects on each layout to an x-platform font like Verdana (or whatever you prefer) to see how badly that change would mess up your existing layouts, and then plan from there.


            Mike's suggestion about a custom theme in 13 would do the trick nicely as well, though that will tend to mess with text object sizes as well as chosen font, and is likely to be more disruptive, depending on how tight your old layouts packed objects.


            Meanwhile, sorry, but I know of no tool which discloses the font content of the layouts in FM files.

            • 3. Re: How To find all Fonts used in an old database

              Thank You very much for sharing Your expertise !


              It's probably more than 5 Years ago when I caught a glimpse of how specialists in the graphical industry work:

              When they get a file from a customer - let's take a pdf as an example - they would immediately open the List of Fonts used in the doc.

              Then they would check and edit the automatically generated replacements. Only after that done, they would check the doc optically, especially looking on those spots where the tool had to replace a font. ( easily possible that those tools can search and highlight by font ! )

              I guess I need a tool like that. Then I simply would generate a pdf of each layout and analyze them with that tool. Then I definitely can see which I might have to change by hand or how to get a good result converting into FM13 designs.


              Curious really, only after reading Your and Mike's answers, those memories came dripping out of my old pRom.

              Perhaps somebody in the graphical industry can help !

              ...  an most probably I can help them to use FileMaker more efficiently...


              Let's see if one of them reads this...   or is there a special Forum for that range ?


              Talking of pdf - I had some troubles with FM13 and pdf in active container fields. That only ceased after deleting all Adobe Acrobat and other Adobe reader stuff. I only found out after FileMaker Germany helped me. I'm glad the adobe stuff is deleted. It works fine with my habitual Apple Preview application.


              At the moment I'm working on a FM Script Analizer. The way it works now, is that I print the scripts into a pdf, copy paste the text into a FileMaker field, analize the text, and finally import the pdf to a container Field to get the readability as well.

              What I want to try, is to automatically import pdf's (similar to photo importing) an then automatically copy paste the text out of the pdf in the active container field. (that was one of the points where FM13 regularly crashed when Adobe was installed)

              • 4. Re: How To find all Fonts used in an old database

                "When they get a file from a customer - let's take a pdf as an example - they would immediately open the List of Fonts used in the doc." —


                You are onto something there. Produce a PDF of each layout (either print to pdf, or save as pdf, and in either case either the current record or a blank record). In Acrobat Pro you can then see a list of all fonts used on that layout (File –> Properties). I don't used the free Acrobat Reader. so I don't know if this menu is available there.

                • 5. Re: How To find all Fonts used in an old database

                  Take a look at FMDiff. I'm pretty sure it will give you a list of fonts used. www.fmdiff.com

                  • 6. Re: How To find all Fonts used in an old database

                    FMDiff will indeed provide a list of fonts, but this is rather a list of all fonts that have ever been selected on any of the layouts, not just of those currently in use. Fonts never disappear from that list. This list is very small though since it only holds the font name and an ID.


                    I'll add this requirement to our FMVis project which could provide this by the end of 2014.






                    Huslik Verlag GmbH • Bgm.-Widmeier-Str. 42 • 86179 Augsburg, DE

                    CEO Winfried Huslik - HRB Augsburg 12386 -  VAT-Id. DE127485099

                    Phone +49 821 565606, Fax +49 821 565001, Email info@fmdiff.com

                    Verify your FileMaker Pro files with FMDiff - http://fmdiff.com

                    FileMaker Developer Conference July 28-31 2014 • San Antonio TX

                    Visit my Session on Thu, July 31, 2:00pm-3:15pm, room Perwinkle

                    Linkedin: http://de.linkedin.com/pub/winfried-huslik/2/505/1a1/

                    • 7. Re: How To find all Fonts used in an old database
                      Stephen Huston

                      Depending on how many layouts a file has, you could even script the creation of a PDF using a single record, but starting with layout 1, saving the record to PDF, then switching to the the next layout number and appending to that same PDF, etc, for all layouts. Then analyze the resulting PDF file for font content of that file.


                      Not 100% guaranteed, depending on non-printing objects and objects which may be off-page, but likely to give you a list which includes all fonts in the layouts.

                      • 8. Re: How To find all Fonts used in an old database

                        The only problem with this approach (I believe), is that it won’t tell you what fonts were used in layouts that are missing. FileMaker will create a PDF with whatever fonts are on the system. If a font was used in the layout, but not currently available, FM will substitute something else. The PDF will be created with those substituted fonts, and any PDF reporting tools will only show those substituted fonts.

                        • 9. Re: How To find all Fonts used in an old database
                          Stephen Huston

                          Yep, I assumed the local system would have all of the used fonts, but that's not necessarily the case with really old files.


                          On the other hand, the PDF will show how the layout looked with whatever font(s) the system is using, so a combination of PDF inspection and actual review of the PDF pages for appearance will give a good clue to what needs attention most.


                          Unfortunately, varying much from X-platform standard OS-installation fonts when designing layouts means some users are going to see unexpected variations. (I've even seen fonts for layouts cause IWP solutions to have all data appear to be blank when viewed in Safari with a user-set default font that suddenly went missing after a system upgrade.)

                          • 10. Re: How To find all Fonts used in an old database

                            PDF solution needs good data for not missing all sub summary part.


                            I'm interested in this (I also have files converted from old versions...), wrote a XSLT for DDR.

                            This is half of way ( only text object is reported ).

                            The 5th column 'uniq' is used for removing duplicates, not need if defined in FMtable as auto-calc.


                            <?xml version="1.0" encoding="UTF-8"?>

                            <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

                                <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>

                                <xsl:template match="/*">

                                    <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">


                                        <PRODUCT BUILD="" NAME="" VERSION=""/>

                                        <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="" RECORDS="{count(/*/*)}" TIMEFORMAT="h:mm:ss a"/>


                                             <FIELD EMPTYOK="NO" MAXREPEAT="1" NAME="LayoutName" TYPE="TEXT"/>

                                             <FIELD EMPTYOK="NO" MAXREPEAT="1" NAME="LayoutID" TYPE="NUMBER"/>

                                             <FIELD EMPTYOK="NO" MAXREPEAT="1" NAME="FontName" TYPE="TEXT"/>

                                             <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Data" TYPE="TEXT"/>

                                             <FIELD EMPTYOK="NO" MAXREPEAT="1" NAME="Uniq" TYPE="TEXT"/>


                                        <RESULTSET FOUND="0">

                                                <xsl:for-each select="*//Layout">

                                                 <xsl:variable name="ln" select="@name"/>

                                                 <xsl:variable name="li" select="@id"/>

                                                <xsl:for-each select=".//Font-family">

                                                     <ROW MODID="0" RECORDID="0">

                                                        <COL><DATA><xsl:value-of select="$ln"/></DATA></COL>

                                                        <COL><DATA><xsl:value-of select="$li"/></DATA></COL>

                                                        <COL><DATA><xsl:value-of select="."/></DATA></COL>

                                                        <COL><DATA><xsl:value-of select="../preceding-sibling::Data"/></DATA></COL>

                                                        <COL><DATA><xsl:value-of select="concat($ln,'&#9;',$li,'&#9;',text())"/></DATA></COL>








                            • 11. Re: How To find all Fonts used in an old database

                              Well, it is a bit embarrassing, but I found a much easier way:


                              Simply    Storage - Restore...   (please correct if You have an english version running)  then open the logfile. In there somewhere all fonts are listed, neatly one after the other. And they are tested - meaning I get all the information needed except which font is used in which Layout.


                              Einfach   Ablage - Wiederherstellen...   und dann das Logfile anschauen. Dort sind die Fonts alle drin. Schön der Reihe nach. Getestet. Nur die Info in welchem Layout welcher Font benützt wird fehlt noch.


                              Many thanks vor all the good tipps !

                              Could be they're useful for something else.


                              Colin from Zurich

                              • 12. Re: How To find all Fonts used in an old database

                                I guess you mean "Recover".  The Recover Log will show the Font Catalog


                                A FileMaker DDR in XML format also has Font details




                                2014-08-20 08:18:39.573 -0400test.fmp120Recovering: font catalog
                                2014-08-20 08:18:39.574 -0400test.fmp120  Rebuilding font catalog order list: name
                                2014-08-20 08:18:39.576 -0400test.fmp120  Recovering: font 'Helvetica' (0)
                                2014-08-20 08:18:39.576 -0400test.fmp120  Recovering: font 'Lucida Grande' (1)
                                2014-08-20 08:18:39.576 -0400test.fmp120  Recovering: font 'Baskerville' (2)
                                2014-08-20 08:18:39.577 -0400test.fmp120  Recovering: font 'Comic Sans MS' (3)



                                • 13. Re: How To find all Fonts used in an old database

                                  exactly. thanks.


                                  Colin Robert Metzger

                                  Apfelbaumstr. 50

                                  8050  Zürich

                                  t 079 771 46 13




                                  Am 20. August 2014 14:23 schrieb gdurniak <noreply@filemaker.com>:


                                       <https://fmdev.filemaker.com/index.jspa>   erstellt von gdurniak

                                  <https://fmdev.filemaker.com/people/gdurniak> in Advanced Discussion - vollen

                                  Thread anzeigen <https://fmdev.filemaker.com/message/155947#155947>