FileMaker 8.
© 2004-2006 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries, and ScriptMaker and the file folder logo are trademarks of FileMaker, Inc. All persons and companies listed in the examples are purely fictitious and any resemblance to existing persons and companies is purely coincidental. FileMaker documentation is copyrighted.
Contents Chapter 1 About publishing FileMaker Pro databases on the web About this guide Web publishing requirements Connecting to the Internet or an intranet About hosting databases with FileMaker Pro About hosting databases with FileMaker Server Advanced Web publishing improvements Publishing files from previous versions of FileMaker Pro Publishing files from FileMaker Pro 7 and 8 Publishing files from FileMaker Pro 6 and earlier Chapter 2 Publishing your database on the web Sharing a database with Instan
FileMaker Instant Web Publishing Guide Chapter 4 Designing a database for Instant Web Publishing Tips for designing layouts for Instant Web Publishing Tips for rendering layouts in Instant Web Publishing Design considerations for List View and Table View Tips for working with data in a web browser General database design considerations Working with graphics, sounds, and movies on the web Setting the initial layout and view Hiding the status area to customize the interface Specifying the sort order for w
Chapter 1 About publishing FileMaker Pro databases on the web With FileMaker® Pro, you can display your databases on the web in a variety of ways. This makes your data: 1 1 available to many people using a compatible web browser, anywhere in the world. (You can, however, restrict access to files.) accessible from many locations, for example, while traveling or working remotely. There are three ways to publish your data using FileMaker Pro.
FileMaker Instant Web Publishing Guide Data from a FileMaker layout displayed in a web browser with Instant Web Publishing Data displayed in a FileMaker Pro layout About this guide This guide provides information about the Instant Web Publishing and static web publishing features in FileMaker Pro.
Chapter 1 | About publishing FileMaker Pro databases on the web 7 Web publishing requirements To publish databases using Instant Web Publishing you need: 1 a Windows- or Mac OS-based computer running FileMaker Pro or FileMaker Server Advanced, enabled for Instant Web Publishing Important You cannot enable Instant Web Publishing in FileMaker Pro if FileMaker Server or FileMaker Server Advanced is also running on the same computer.
FileMaker Instant Web Publishing Guide Web publishing improvements Web viewers work in Instant Web Publishing. These objects can calculate a URL based on field data and display the web page directly in a FileMaker Pro layout. For more information about web viewers, see www.filemaker.com/web_viewer. For information on other new FileMaker Pro and FileMaker Pro Advanced features, see the Installation and New Features Guide for FileMaker Pro and FileMaker Pro Advanced.
Chapter 1 1 1 1 1 1 | About publishing FileMaker Pro databases on the web 9 Web users can dynamically choose a layout view to work with data, toggling between Form View, List View, and Table View. You can limit access to a view in the Views of the Layout Setup dialog box. For more information, see FileMaker Pro Help. FileMaker Pro clients can no longer host databases with Instant Web Publishing. The files must be web published on the host computer.
FileMaker Instant Web Publishing Guide
Chapter 2 Publishing your database on the web With FileMaker Pro, it is easy to share your database on the web dynamically with Instant Web Publishing, or statically by exporting data as HTML or XML. If you are connected to a LAN or WAN, you can share your file without requiring additional software. To share files over the internet, contact an Internet Service Provider (ISP) for internet access and information about hosting a database.
FileMaker Instant Web Publishing Guide 4. Choose which users can access the file. Choose this To provide access to these users All users Anyone who has the IP address or domain name of your computer hosting the database. Specify users by privilege set Allows select users access to the database. Users must enter their account name and password defined in Accounts & Privileges. No users This default setting prevents any user from accessing the database with Instant Web Publishing.
Chapter 2 | Publishing your database on the web 13 Choosing a language for Instant Web Publishing You can choose a language for the Instant Web Publishing interface, tooltips, and onscreen Help. Choosing or changing the language has no effect on your actual data. To specify the language, open the Instant Web Publishing dialog box, select the language to display in the status area, then click OK.
FileMaker Instant Web Publishing Guide Changing the port number on Mac OS X The first time you enable Instant Web Publishing, Mac OS X requests permission to make a one-time change to your computer’s setting to facilitate web publishing on a port number below 1024. For security reasons, Mac OS X restricts access to ports below 1024. To configure FileMaker Pro to use ports below 1024, you must provide an administrator password, such as the passphrase created when you first set up Mac OS X.
Chapter 2 | Publishing your database on the web 15 Disconnecting inactive web accounts You can specify the amount of time web users remain connected to the database when their session, or connection to the web server, is idle. Sessions are considered idle when web users do not submit requests from the web browser, such as finding, creating, or submitting changes, changing layouts, and so on.
FileMaker Instant Web Publishing Guide Using a custom home page To replace the default Database Homepage, place an HTML file named iwp_home.html in the Web folder inside the FileMaker Pro folder. Web users are returned to this page when they log out of a session or the session times out.
Chapter 2 | Publishing your database on the web 17 General steps for publishing static data With static publishing, you export data to a web page, then add the web page to your existing web site. Web users connect to your web site, not to your database. To publish static data from FileMaker Pro: 1. Find the appropriate records, then choose File menu > Export Records, and choose HTML Table or XML. 1 Choose HTML Table to generate a table of data that can be viewed by supported web browsers.
FileMaker Instant Web Publishing Guide
Chapter 3 Working with FileMaker databases on the web FileMaker Pro Instant Web Publishing automatically provides web pages and forms for interacting with your database. Web users click buttons in the status area to browse, find, sort, add, edit, and delete records. When you enable Instant Web Publishing and share files, anyone who has an account for a database and knows the IP address or domain name where it is hosted can access the file.
FileMaker Instant Web Publishing Guide Accessing a FileMaker database from the web To access the Database Homepage, web users open the web browser, then type the IP address of the host computer. Type the IP address or domain name in the browser window 1 1 1 In some cases, web users can type the domain and host name of your computer instead of the IP address, for example http://accounts.yourcompany.com. Or, they can type the host name, like http:// yourcompany.com.
Chapter 3 | Working with FileMaker databases on the web 21 Logging in to a file When opening a database, web users may be prompted for their account information. Forms-based login page 1 1 1 1 1 1 1 If the Guest account is enabled with the Instant Web Publishing extended privilege, web users have the option to log in with the Guest account instead of an account name and password.
FileMaker Instant Web Publishing Guide Working with data in Instant Web Publishing The FileMaker Instant Web Publishing status area has been designed to resemble the desktop application. Web users interact with databases on the web in Browse or Find mode. All the features that enable web users to interact with your database, for example, entering, editing, deleting, and finding records, are accessible from the status area.
Chapter 3 | Working with FileMaker databases on the web 23 Go to Database Homepage, Browse, or Find Mode Add, edit, delete, sort, omit, or show omitted records Save new or changed data to the host Change layouts and layout views Abandon any changes and return to Browse mode View previous or next record Status of current found set Modify last find request Log out and close windows to protect data Status area in Browse mode Status area when editing records Finding records In Find mode, web users have
FileMaker Instant Web Publishing Guide Procedures are outlined in the Instant Web Publishing Help. To view the Help file, click the Question Mark (?) in the status area. Note After entering or editing search criteria in a find request, web users must click the Perform Find button in the status area to send the request to the host. Web users can show or hide the status area with a toggle.
Chapter 3 | Working with FileMaker databases on the web 25 Displaying a database with the status area hidden Like the desktop version of FileMaker Pro, you can create a script that hides and locks the status area when the database is opened in a web browser. This allows you to design a custom interface. Keep these points in mind: 1 1 1 If you lock the status area, you must manually create scripts and buttons that offer users all the necessary functionality.
FileMaker Instant Web Publishing Guide Benefits to accessing databases with FileMaker Pro Although accessing a database from the web is very similar to FileMaker Pro, it is not as responsive as accessing a database from a FileMaker Pro network client: 1 1 1 1 1 1 1 1 1 1 1 1 There are no customization features available on the web. Although web users can choose layouts and different layout views, they cannot add, delete, or modify fields, layouts, scripts, relationships, and so on.
Chapter 4 Designing a database for Instant Web Publishing With FileMaker Pro, data displayed on a web form with Instant Web Publishing looks and behaves similarly to a FileMaker layout. When you design solutions that are accessed on the web, there are some limitations of the technologies that you should be aware of. For example, FileMaker Pro layouts are rendered on the web using Cascading Style Sheets, which doesn’t offer as robust graphics support as the FileMaker Pro application.
1 1 1 1 1 1 1 FileMaker Instant Web Publishing Guide Instant Web Publishing offers limited text styles. Paragraph text styles, tab stops, and vertical alignment are not supported. Additionally, underline, word underline and double underline are all rendered as regular underline. Evaluate your layouts in all supported web browsers before sharing the database with others. If layout text is wrapping to a new line, increase the size of the text boundaries in the FileMaker Pro layout.
Chapter 4 1 1 1 1 | Designing a database for Instant Web Publishing 29 If your solution includes multiple files, Instant Web Publishing must be enabled in all databases. If you don’t want related files to be accessed directly, you can exclude a filename from the Database Homepage by enabling the Don’t display in the Instant Web Publishing Database Homepage option in the Instant Web Publishing dialog box.
1 1 1 1 1 FileMaker Instant Web Publishing Guide You should not access the same file from multiple browser windows. Some features, such as the Drop-down Calendar field format, might not work or appear the same in Instant Web Publishing as they do in FileMaker Pro. Web browsers can’t display a calculated value if the calculation field uses values from other files.
Chapter 4 | Designing a database for Instant Web Publishing 31 Hiding the status area to customize the interface FileMaker Pro automatically generates interface controls in the status area for interacting with databases shared with Instant Web Publishing. These controls allow the user to create, alter, and delete records; switch views and modes when accessing databases via a web browser; find and sort records; open HTML Help; and so on.
FileMaker Instant Web Publishing Guide Web viewer design considerations If your FileMaker Pro solution contains web viewers, consider the following points for Instant Web Publishing: 1 1 1 1 1 1 Content in a web viewer may have unintended effects on Instant Web Publishing. Therefore you must test the websites you want to display within a web viewer.
Chapter 4 | Designing a database for Instant Web Publishing 33 Scripts and Instant Web Publishing The ScriptMaker feature in FileMaker Pro is useful for automating frequently performed tasks, or for combining several tasks. When used in Instant Web Publishing, it can allow web users to perform more tasks, or to easily perform a series of tasks simply by clicking a button. FileMaker Pro supports over 70 script steps with Instant Web Publishing and Custom Web Publishing.
1 FileMaker Instant Web Publishing Guide If your scripts contain steps that are unsupported, for example, steps that are not web-compatible, use the Allow User Abort script step to determine how subsequent steps are handled. 1 1 1 1 1 1 1 1 1 If the Allow User Abort script step option is enabled (on), unsupported script steps will stop the script from continuing. If Allow User Abort is set to Off, unsupported script steps are skipped over and the script continues to execute.
Chapter 4 | Designing a database for Instant Web Publishing 35 The script steps below function differently on the web than in the desktop application. For information on all script steps, see FileMaker Pro Help. Script step Behavior in Instant Web Publishing Perform Script Scripts cannot perform in other files, unless the files are open and shared with Instant Web Publishing on the host or server machine. Allow User Abort Determines how unsupported script steps are handled.
FileMaker Instant Web Publishing Guide Creating a script to log out of a database and close the session It is important that web users properly close their session by clicking the Log Out button in the status area. If they close browser windows or quit the browser before clicking the Log Out button, their session is still open. This might prevent others from accessing the database and could make data vulnerable to hackers until the specified time out occurs.
Chapter 5 Testing, monitoring, and securing your site Before notifying users that your published database is available, it is important to verify that it looks and functions as you expect. 1 1 1 1 1 Test features like finding, adding, deleting, and sorting records with different accounts and privilege sets. Verify that various privilege sets are performing as expected by logging in with different accounts. Make sure unauthorized users can’t access or modify your data.
FileMaker Instant Web Publishing Guide 2. For Advanced Options, click Specify, then enable the log files you want to create. Select To track In this file Script errors Information about errors generated when web users execute application.
Chapter 5 1 1 1 1 1 1 | Testing, monitoring, and securing your site 39 If an account limits record-by-record browse privileges but does not limit the privilege to delete records, it is possible for users to delete records they cannot view. If the same account opens related files, the related data is displayed on layouts containing related fields. Instant Web Publishing uses the accounts and privilege sets defined in FileMaker Pro for the best security.
FileMaker Instant Web Publishing Guide
Index A access privileges See Accounts and Privileges accessibility 28 account names and passwords, character set restrictions 29 Accounts and Privileges Guest account 21 limiting layouts 27 scripts 33 setting 12 testing 37 ActiveX 26 Allow User Abort script step 34, 35 Apache, hosting Instant Web Publishing databases 36 Apple events 26 authentication, forms-based 21 B Browse mode capabilities 22 Instant Web Publishing 22 browser, web open database URL 15 publishing requirements 7 requirements 19 viewing d
FileMaker Instant Web Publishing Guide FileMaker Pro Advanced custom menus 30 tooltips 26 FileMaker Pro databases, accessing from the web 19 FileMaker Pro layouts designing for Instant Web Publishing 27 using portals 29 FileMaker Server Advanced Custom Web Publishing 5 filtering databases 21 hosting databases 7, 24 security 24 using plug-ins 29 filenames, suppressing in Database Homepage 29 Find mode capabilities 23 constrain found set 23 extend found set 23 Instant Web Publishing 23 G GetLayoutObject
| log files archiving 38 creating 37 logging options 38 monitoring web activity 37 securing 38 Log Out button 24 importance 24 script 36 login page 21 M Mac OS X port number 14 web browser requirements 19 web publishing requirements 7 maximum number of web connections, FileMaker Pro 14 monitoring web activity 37 N New Window script step 35 O OLE 26 limitations 30 Open URL script step 35 P pages, web, viewing databases in 19 passwords changing 21 no login password 21 with multiple accounts 38 Pause/Resum
FileMaker Instant Web Publishing Guide T W tab order 28 tab panels 28, 30 Table View designing for 28 differences with FileMaker 28 restrictions 9 setting properties 28 TCP/IP port number 13 testing your published database 37 third party plug-ins 29 with FileMaker Server Advanced 29 time out setting 15, 24 tooltips, FileMaker Pro Advanced 26 web browser open database URL 15 publishing requirements 7 requirements 19 web pages, viewing databases in 19 Web Security databases, not supported 9 Web Styles