PIM605 FileMaker Mulitexport to html

Dr. PI Method in blue Nr. 605, created 5.1.2005, checked 15.1.2005, last updated

Used for creating Dr. PI's bluebook Mammalia

A later version of the example ist found on the Web http://www.bloobook.net
In the "work" folder, Content file is: species.fp5, the field for species name is "biolog". Export file is: "MultiExport.fp5" from the Troi-File-Plug-in2.8. Html-output pages will be in the "pag" folder.

Creating a file

  1. Collect all information in a FileMakerPro datababase e.g. Arten.fp5
  2. Create a Sample html-File for an entry
  3. Put the constant parts of the file (Head, Layoutstuff, Footer) into global FileMaker Pro Fields.
  4. From the Database entries compile the html-file in the FileMaker database for each entry input one html-field named "output".

Linking to Multiexport.file

NB: It is not absolutely necessary to have separate file for content and for exporting, but crashes can occur during export and can irreverisbly damage the file. This section describes how to connect.

  1. Copy the MultiExport.fp5 file into the Work folder (keep a virgin copy of MultiExport.fp5)
  2. Open MultiExport.fp5
  3. Create a new Relationship: Arten.fp5 : biolog :: MultiExport.fp5 : textfield1
  4. Import records : Arten.fp5 : biolog :: MultiExport.fp5 : textfield1 (one field is enough, keep in original order).
  5. Create layout "Output" with textfield 1 and a large field "Arten.fp5 : output"

Single Record Export

  1. Select a single record
    • select all
    • omit current with Apple-T
    • Menu / Records / Find omitted
  2. Export one record into the work folder ( The first export is preferably done manually to set all options as desired)
  3. File / Export Records / Save as TrExport.tab /
  4. Speciefy Field Order for Export (Relationship, Field): species : output
  5. The default field order for export in the "export data" script is:
  6. replace this field order: with 1. species::output, numberfiel as follows:
    • open Multiexport.fp5/file Menu/ Scripts / ScriptMaker/
    • select the script "Export Data"
    • click the line export Order,
    • deselect "Restore Export Order", press ok
    • replace export order with the information currently in use
  7. Locate the Export File (step 2):
    DrPI OSX:Users:pi:Sites:piweb:bluebook:mammalia:work:TrExport.tab
  8. Before continuing check the content of the exported file:
    • copy TrExport.tab
    • rename copy to TrExport.html
    • open in Browser.

Multiexport

  1. Adjustment 1for Mulitexport:
    • to avoid restoration of the export order


  2. Adjustment 2 for Multiexport:
    • to replace the filename extension ".TAB" wit ".html"
    • open the script"Do Multi export" (as above)
    • at the end of line 8 ( "set Field ...") replace ".TAB" with ".html"

    Adjustments in the loop of the Do Multi export script

  5. Create a destination folder "pag"(step3).
    • If the folder already exists, create a folder "DemoFolder" within it.
    • destination folder: DrPI OSX:Users:pi:Sites:piweb:bluebook:mammalia:pag:DemoFolder:
    • you can then delete the extra folder from the path:
    DrPI OSX:Users:pi:Sites:piweb:bluebook:mammalia:pag:
  6. Do multi Export
    each record from the 2species.fp5" file is exported as a File into the folder "pag"

© Dr. PI Method in blue -> Dr. PI Webseiten für e-Learning und Forschung. Mehr zu diesem Thema