Custom Web Publishing

Hey there, I"m attempting to work through the FM Webschool example that uses the fmtest.php page. I have everything set up the way I think it should be, but I get "unable to open file" error. Any Ideas? Thanks, Michael Giesbrecht Luasfilm Entertainment Company Ltd.

I have a purchase order form in FM with the usual fields (Product Nbr, Description, Price). I have the same fields on a Supplier's website. What I currently do is cut the data from the website and paste it into FM, 1 field at a time. I am wondering if there is a more efficient way to copy the data from the website to FM. Any suggestion/pointer will be much appreciated.

Do any other web server operating systems besides OS X and Windows server work with the API? Ken

Newbie to firewalls and such (so be kind). I have FMSA 8.5 on a dedicated server running Windows Server 2003. We have an IT guy who set the whole thing up. There is a dedicated domain name and the firewall was configured to allow incoming traffic (I have no idea which port etc but can find out if needed). On the office "intranet", all is well. No connection is ever lost and all clients are without complaint. IWP also works, however: I can access the database over the web most of the time. 1 time I logged off properly and then tried to log back on..."address could not be found". I tried multiple computers and was unable to access the logon page of iwp. In the…

Hi Everyone, I just thought that I would give you guys a sneak peek of some software that will be released next week. The two movies only show the basics, FMStudio includes code coloring, code hinting, a site builder and much much much more : You can now see your live FileMaker data in DreamWeaver http://www.fmwebschool.com/movies/fmstudio/fmnew/fmnew.html Quick Overview http://www.fmwebschool.com/movies/fmstudio/fmsite/fmsite3.html Complete FileMaker website built and displayed in 15 minutes. Includes search page, list page, detail page and an error page. With the site wizard the same site can be created in less than 5 minutes. …

Has anyone seen or heard of any projects, utilizing filemaker as an online trainign program?

I have two main questions about the PHP API for FMP, so I'll put them both here instead of separate threads. My first question: Using this API, is it possible to upload a file into a container field? second questions: When using the API to execute scripts, can you execute a script that has non web-compatibile steps? (eg: export records, etc)

I have created an inventory database, and it is housed on a Matrix server. I make changes to the layouts from my desktop, and only myself and my administrator have access to the actual layouts. A few days ago, I created two new fields, from my desktop. When I went out to the web, to work on the inventory, from a laptop, the fields do not show up in the browse view. They show up in the "find" view, but not "browse", and this is important, because these are fields I need to be able to input info into, from the field, but I can't, if I can't get the field to show up off the server. I know this has to be something simple to fix, but I just can't figure it out. Per…

Hi there, Is there some 3rd party survey tool (like SurveyMonkey or Zoomerang) that Filemaker can talk to directly? I'm in a situation where a Filemaker server lives behind a tight firewall and we need to make a registration form for an event accessible to people outside our intranet. Any suggestions or advice would be greatly appreciated. thanks.

I am a novce with IWP so any help would be helpful. We have a number of users (Mac and PC)accessing a database using IWP. Everything look like it supposed to. One user(store manager) will need to access the database with a Pocket PC(Window mobile 5, with an intergraded barecode scanner,he will be using it to read barecode data and perform search, etc). Initially I tried filemaker mobile 8 with ActiveSync but it doesn't allowed to update/sync more than one table per file and our enterprise virus scan/firewall make it unreliable to use. So IWP seem the solution at the time but Internet explorer Mobile doesn't even show the log in page of IWP. I tried Opera mobile and it's…

I have a FileMaker solution that is on a computer in the office. I know what the outside IP address is to get to that computer. How do I tell FileMaker to connect remotely to the IP address of that computer?

Hi there, we are currently developing a solution using the new FM PHP API. We have 2 FileMaker files that are entirely identical in their field and table definitions. They contain some auto enter fields in their main tables that retrieve values from a specific (helper) table (again the helper tables are identical in both files). The strange thing that happens is that in the main table in one file when inserting a new record via PHP the values get loaded in the auto enter fields while in the other file those auto enter fields in the main table remain empty when using exactly the same PHP procedure. Has anyone experienced this too? Are there any known limitat…

Does anyone have an actual web site using FileMaker Pro PHP and FileMaker? I would like to see the performance, and what can be done. If you want some examples of XSLT on a web site, you can look at any of mine as an example (that I would like to convert to php if it can do more and is faster). http://fpas.neenah.k12.wi.us/fmi/xsl/curriculum/home.xsl http://fpas.neenah.k12.wi.us/fmi/xsl/stockroom/home.xsl http://fpas.neenah.k12.wi.us/fmi/xsl/msdiversity/home.xsl

So, now that I have several solutions done in XSL, is there any advantage in looking to switch to php instead? Is php faster than xsl? Is php easier to code than xsl? Can you do more in php than xsl?

Hello, This is a new File maker pro 8.5 and server 8.0 install. Installation was successful then i get a message to install curl. I followed the steps installing the Curl and also i am using filemaker API for PHP. I get the following communication error when i try connecting to the database. "Communication Error: (22) The requested URL returned error: 405" Please let me know if any one encountered this issue and how to resolve this issue. Thanks in advance for the help Thanks,

Over the past week "especially at Devcon" I have been contacted numerous times as to how to setup cURL with IIS so individuals could test the new FileMaker API for PHP. The PHP Installer for windows does not come with cURL configured, and there is a small process needed to setup cURL to work with your system. I have created a help movie and a PDF help guide that shows you how to setup cURL in less than 5 minutes. I have also included a zip file with all of the files you will need to setup cURL. Movie Links: http://www.fmwebschool.com/resources/php_curl/curlmovies/curl.html PDF Documentation: http://www.fmwebschool.com/resources/Curl_Install.pdf Fil…

I am working on a file that helps kindergarten students learn basic words. I recorded 61 single words into 61 Container fields. The fields are Global. The next day when I check, the sounds are gone. The Container fields are empty. I read that graphics are sounds are to be stored on the server. In which directory would that folder be? Are container files able to be loaded into this directory? Is 61 sound files too much?

Hi, Just set up a database for use with stock. We have two stores and wish to have a common database for the two. How would one go about sharing the one database over potentially 5 different computers? We're quite happy to use a browser to view the pages as this softens the need for fast computers. Any ideas would be greatly appriciated (looking for a somewhat inexpensive solution) Also all computers are connected to a high speed internet conection and could host the file, just need to know how the computers from other locations would enter it. Cheers elliot

hi, I shared my DB through instant web publishing, but how come I can't put any files into the container fields. Are the container fields not supported in web publishing? Thanks in advance! Regards,

Hello, I'm having some difficulty pulishing some portals that rely on a global field in the Parent table. I've tried using an opening script to set globals when the database is opened but the FM7 Server seems to ignore this and the global field is not set. Does anyone know a solution to this problem? Kevin

I'm using FMP Server 7 Advanced on a Windows 2003 server and can't connect to the Web Publishing Engine. We use a netopia router on which I've opened the ports 5003 and 16010-16018. When I try to connect to the web publishing engine using the address http://[localhost]:5003/fmi/config, I just get a page not displayed error. We are using the same 2003 server to host our website on port 80. What am I missing?

marginwidth="0" marginheight="0" vlink="#555555" alink="#000000" link="#555555"> ...

Hi, Please excuse my "newbie"-ness. I'm relatively new to FM, having written a half dozen fairly rudimentary databases for simple record keeping. I want to expand my abilities to encompass web publishing of a current database. This database is a large set of images (in container fields) and text. I want to be able to have a user enter search terms to find images associated with various key words. Unfortunately, FM 8.5 doesn't allow me to "publish" the contents of container fields. Since I am a newbie, I'm not familliar with how the experienced folks create such databases. What steps do I need to go through to get such a thing up and running?

Im new to this group... I copied 4 fm7 files to my website. When opened, none of the file references do not work. I can re-establish them but they wont be there the next time I open them from the site ??

I was curious if anyone had any performance comparison with Lasso vs PHP. Currently I am using Lasso and have a file in which I need to update 500plus records. It is only updating 3 records a sec max. Didn't know if fxPHP or the PHPapi would be any faster since they use the same xml string that lasso uses. Thanks for any input

Video Special available through September 13th! FMWebschool is proud to release a collection of over 80 web publishing videos. http://www.fmwebschool.com/filemaker_php_api_videos.php Download the videos and get started now! _________________________________________________________________________ The video collection includes the following: * HTML Primer (for individuals that have never worked with HTML or need a refresher) * Cascading Style Sheets Primer (Extremely beneficial for page layout and control) * Intro to PHP Primer (Necessary before beginning with FileMaker PHP section) * Connecting PHP with FileMaker (Covers Database set-up and we…

Hello, I do have problems using server-side xslt processing. When i put xslt styles sheets in the custom publishing filemaker 7 advance folder i have a "cannot find pages" message in the browsers i use. It is why i can't use the <?xslt-cwp-query?> or the fmxslt:break_encode tags. So i have two questions. First: Does anybody know the reason why client-side xml web publishing (fmxml) works on my server but not server-side xslt web publishing (fmxslt)? Second: By the time the solution to the first question will be found, is there any way to show carriage returns of a text field to the web without using the fmxslt:break_encode tag that is server-sid…

Hello, Did you ever experienced different behaviors between two computers that have the same version of Explorer when processing filemaker xml data transformed with xslt stylesheets by the browser? In the majority of the cases everything goes well but for some explorer programs it's like they recieve xml with no data. And Firefox works like a charm in thoses situations so it's not a firewall problem or a configuration of the computer... Strange. Thanks.

I've been banging my head against the wall nonstop all day. I've got a Purchase Request system that i am trying to allow web access to. I'm using the FileMaker site assistant to build the pages and then modifying them as I need. I've been pretty successfull with this so far when building web approvals and status pages. Unfortunately, I'm trying to do something a little more complicated. The Request system is made up of two tables, one to store the request itself (who its for, when they want it, etc) and another to store the actual requests (part numbers, quantities, totals). I have created a page that allows me to create records in the first table and view any r…

just a quick question: how does the fmp php api hold itself against fx.php? fx.php uses xml-generated data which has to be parsed by the fx.php module, as far as i know, and i'm wondering if the same goes for the fmp php api. if there's no xml parsing involved (using the fmp php api) my guess is that performance-wise it would shine. any comments on this are appreciated.

I did a search before posting so I apologize if I missed an earlier post that may answer my question. I am also not the most articulate when it comes to technical speak so please bear with me. We have several relational databases that our users update annually via the web using PHP. The problem is that we over 700 records and we are only having issues with around 50 to 100 of them in one of the databases. There doesn't seem to be any connection between the corrupt records. Some are brand new and some have been around for a few years. The user was able to enter the information initially and now the changes that they make are not sticking. The old information is …

<?php // Include FileMaker API require_once ('FileMaker.php'); // Create a new connection to server without specifying hostspec. $fm = new FileMaker('FMPHP_Sample'); // Instantiate a layout object derived from Filemaker object. $lay = new FileMaker_Layout($fm); // If an error is found, return a message and exit. if (FileMaker::isError($lay)) { printf("Error %s: %sn", $lay->getCode()); " "; printf($lay->getMessage()); exit; } // Print out some info of current layout echo "The layout is ".$lay->getName()." ".$lay." "; ?>

Hello, I really don't know if this is even possible, but I thought I'd ask. I have an XSLT page in which a user enters an ID number and selects a checkbox for an available time slot. When the user hits the submit button, the page runs a javascript to make sure the user has entered an ID number and selected a time. However, I want to be able to verify that 1. the time slot selected is available (meaning I want to see if the FMP field is empty), and 2. I want to verify that the user ID matches the value of another FMP field. I have no idea how I can get a FMP field value within a Javascript. Is this possible? I think what I'm really asking is whether there is a sy…

I am troubleshooting my Filemaker database online and something odd is happening: On my web search page I enter the terms I want to search (for which I know there are records) and get the message "No records found: Modify your search criteria and try again." But meanwhile I can see that the FM database on the server has searched for the records by looking at the information from the previous search, but FM nor the web results are displaying them. And when I then try to perform a search within the FM database immediately after, it cannot locate records. FM must be closed and opened again in order to search records accurately. My HTML code does not immediat…

In so far as Filemaker disables the Print Setup and Print script commands, how does one print a data layout from the web? Steve

Hello Everyone, I have written a 12 page PDF to help individuals get started with the new FileMaker API for PHP. I have also answered several questions individuals have asked us about Chris Hansen's FX.php. http://www.fmwebschool.com/resources/phpapi.pdf As always, please email me back-channel if you see any errors or have ideas as to how to make the documentation better. In Kindness Stephen K Knight http://www.fmwebschool.com 800.353.7950 / 386.453.5843 FMWebschool, we bring the web to life FX.PHP PHP XML MySQL CDML ASP

I work at a small company who has an employee that works from home where the only high speed internet is satellite. When trying to connect to our server, the employee is spending enormous amounts of time for data to load, it is actually slower than using dial-up. Filemaker says it is the lag time inherent in satellite internet, they suggested publishing the db on line. Does anyone have any experience with satellite internet and db's online? My manager is hesitant to go ahead and buy the new server advanced due to the cost. Does anybody know of a workaround or have any suggestions?

FileMaker Inc, has just released their new FileMaker API Public Beta learn more about it here: http://www.filemaker.com/developers/resources/php/index.html We have also have created a question and answer section on our forum here: http://www.fmwebschool.com/frm/index.php We also have a created a blog where you can download code snippets and ask questions about the new API. In Kindness Stephen K Knight http://www.fmwebschool.com

Instead of the default, http://mysite.com/fmi/iwp/res/iwp_auth.html anyway that I can make it into: http://mysite.com//iwp_auth.html w/out having to use frames or or scripting to hide the URL

How to I turn off the views available to an online user? I want to keep the sidebar, but only want users to use my layouts in form view.

Hi all, I created an XSLT stylesheet that is a basic web form. It's the first time I've done such a thing. The only point is to accept a user submissions; users can't edit or read existing records. The problem I'm having is figuring out what URL to use to enable the form to be submitted. For example, I can use: http://mysite.com/fmi/xsl/addrecord.xsl?-new But, when I do this, it creates a blank record upon entering the URL, then another record when I hit the submit button (which has the proper data). I imagine I shouldn't be using the -new command in the URL, but if I use any other command, hitting the submit button will not produce new records. Anybody k…

I have a client still using FMP Unlimited 5.5, running on Server 10.4, and I'm using WSC. Every other day or every day I'm getting an error that the Customer DB is not found (This is the first DB that is queried), I then have to login to the server and either restart the WSC Apache Service or login to the WSC and resubmit the Databases for hosting. I have created a Cron job to open the databases every 30 minutes. There is lost revenue everytime this goes down. We will be moving to FMP 8 Server Advanced but that won't be until next year. In the mean time we need this to stay up and running to generate money. Thanks, Dan

our agency doesn't have a network but is scattered about the state (New Mexico). We need to share client files/reports and I want to recommend a FM hosting database server. Suggestions? Thank you...Carol

I've noticed that sometimes a defined button stops working in IWP. It remains working in the FM application however. So far the only way to get it to work again is to build the button all over again. (Insert -> Button ...) Any ideas?

OK, here's the deal. Time is of the essence and I need a crash course on getting all learned up on this Filemaker stuff. I need to move from novice to semi-pro in the shortest period of time. Obviously I'm looking for the best FM resource that can make the complex look easy, and at a reasonable cost. Online training with peronal consultation support if I got stumped would be ideal, but I realize I probably can't have my cake and eat it too. Any (I will not be disappointed) suggestions? Also, since most of what I'm trying to develop would be web published, an emphasis in that area would be most helpful. Thanks!

Can anyone explain what I need to do in order to send an email notification to a predertmined address when the submit button is clicked on a web form? Thanks

I have some sort criteria which I used in HTML in FMP 6. When I use the CDML Converter, it seems to convert properly, but when I run it, it gives me a field missing error (which is not caused by the rest of the body - that works until I add back the sort criteria lines). Does anyone have a properly working sort criteria that works?? Any help is appreciated.

I have a single user who is getting the following error when trying to edit a record on the web using CWP xsl: The resource http://[email protected]:16014/fmi/xml/FMPXMLLAYOUT.xml?-db=Inventory&-lay=Step+2+-+DSG+Approval&-view= could not be loaded because of an unexpected error (MCS-604) File: editrecord.xsl Line: 16 Column: 112 He is logging into the database using his domain account. Mine works fine to do the same task. I have tried everything I can think of. I gave him the same access rights as me. When he logs in on his computer as me, it works. When he logs into my computer as him, it doesn't. I removed a field from the page and it works…

So I have a contact form on a website and a registration page (name, number etc etc). At the moment they done as PHP Scripts (I Think, I'm not a web geek). But I'm thinking "Hey why not have a filemaker layout instead, that way the data would go straight into Filemaker rather than an email" So my next question is "OMG how?" lol Where should I start? Is there anything I can read?

OK -- this question is going to display my total ignorance about networking. I don't know what I have to do to get the correct IP address with IWP on a Mac (OS 10.4.3). When I set up IWP sharing, I get the "internal IP" (I don't even know if I'm using the right term) so that within my network I can access the hosted database at http://10.0.1.7/. But I know that this address will not work outside my network. What do I have to do to get it set correctly? Where do I find my correct address? Do I have to set up a Filemaker port? (I already did in networking.) Please -- point me in the right direction!

1. Our new web site will have a 2 level drop down main left menu - that is each menu item will have a submenu that pops out to the right and in some cases when sub menu items are rolled over, a second set of submenus appears. This cannot be built in Filemaker as far as I know. We will use MenuMachine 2 to add the menu in Golive. So our site will have some pages built in a web editor and others which are pure Filemaker (registration forms, shopping cart etc). I assume there is no problem linking Golive pages to Filemaker (IWP) web pages for navigation purposes. I contemplated using the custom web publishing to add the 2 tier main menu to a Filemaker generated homepage but …

We are attempting to use FX.PHP to get a small application up on the Web. We have FM Server Advanced 8. One of my scripts sets a Global. The Global is in a Related Table but in the same File. We have Relationships that use this Global, and Caculations that use those Relationships. Our first script call sets the Global. The second script call retrieves the Calculations (using the Relationships & Global). As of now, it does not appear that the Global gets assigned. Our Calculations don't change anyway. Can we change & retain the Global Data as we make multiple calls through FX? I assumed so, but since each call seems to be its own s…

Hello there. I am a novice when it comes to Filemaker and the web. I have Filemaker 7. I will try to explain what I want to do and if it is possible. I want to make and online form for registration for a trade show, and when they submit the form it gets directly put in the Registration database. So basically its a filemaker form in the web browser that submits to the database on the server. Is this possible with Filemaker Pro 7 or do I need the Server version. The actual file will not be hosted by us, but by another companies server that runs Filemaker server and we just pull the file off their server to our computer. Thanks

1. Do the tabs layout feature in FM 8 advanced work with a web published database? 2. Since I can't seem to get any help in controlling access to data within the FM desktop application, is there a simple and secure way of downloading record data from a web solution and then importing that data into a mirrored desktop solution? 3. If I want to publish online Quicktime video files within individual records, what are the most critical components in serving those files properly.. (memory), (CPU), (harddrive), or (bandwidth)? 4. Does the 100 simultaneous user limitation (FM Server 8 Advanced), apply to each database file or all database files being served on…

I am new to FMP8. My dad showed me the amazing potential of it and now i am hooked. Essentially this is my problem. I run an Australian Rules football dreamteam competition for myself and 15 other friends. If you are not familiar with the dreamteam concept - basically each player at the start of the year picks their team in a 'draft' then each week you play each other and your team scores points based on the playres you picked statistics for carious things. In this comp my dad has written me a database to basically import the stats from the statisitc site on the web (via importing into a excel sheet then importing into the database).Also each player emails me their team…

Ok i have finished my database it has access rights and passwords, what steps do i take to put it online so multiple people can use it and it also be apart of my website. Basically i need a brief summary of how to put my database on the web

Hi Is it possible to print a found filemaker set via a web browser. E.G User conducts a mailshot search and wants to print the letters from the web browser. i.e 25 people found to mailout too, pressing filemaker print button in browser window prints the 25 personalised letters from i.e rather than FM. We have this setup in Filemaker but have a client that wants purely a Web hosted solution and this is the only block I have stumbled on so far. Hope it makes sense.

Good morning FileMaker enthousiasts ! Please forgive me a basic question that has probably been discussed here a thousand times, but I am new to this and I need to find a good platform for what I am looking for in a short time... So here goes: I am looking for a tool that will allow me to set up an online database in which users can register with a username and password (if possible, I'd like to be able to automatically confirm their registration by e-mail). I want them to be able to log onto their profile online (using username and password) and edit their profile. Of course, each user should only be able to see their own data. I want to be able to do…

Hi.. I'm using CWP and xsl stylesheets to view records, but I can't get the xsl code to display the fields formatting I applied in the FMP database. For example, I have a summary field that calculates the average, in the FMP db the average formats as 2 decimal place (i.e, 34.55), however in the xsl formatting I get 34.5549785945. I've tried using html_encode and break_encode and they don't work. In the old FMP 5.5 w/CDML I could just add use [FMP:field, format]. The CDML converter says this is no good, and converts using html_encode, but that doesn't work. Any suggestions would be greatly appreciated. thanks

How do I make a standard weblink in a field that when exported and viewed as an HTML table is clickable. I need it for my online store, but I have been unable to even make a basic link usable ie. a link to filemaker would show up as FileMaker in my web browser - not clickable! Thanks All!

So... I googled around for about an hour. All I found about this topic was a post on these forums for the wishlist, a post that was over a year old. I'm currently working on a number of PHP scripts which parse through the XML that the FM8 Server Advanced Web Publishing spits out. I can view, edit, create records, and download files that are stored in the database. My PHP runs over Apache on a Linux server, and sends HTTP queries to a Windows machine running FileMaker Server. Now I'm trying to write a portion of a script that would allow a web user to upload a file with an HTML form to my web server. So far so good... Now I'm trying to store this file in a Con…

Hi, Does anyone know how to change the username and password the browser holds after authentication. You could create a link http://empty:empty@domain, but that only works in Firefox. So I've been trying to modify the or and add a different username and password I've tried using the document(), but I get errors about the 'http://' not being declared as a namespace. any ideas

Hi All, I have a FM database of books running on the web, with a search form to search for an Author, Title etc. The filemaker server is FMPro 6.0 running on a G4 under OS X. The search works fine when viewing from a Mac using any browser. It works from a PC but only if you click the actual search button, not if you type your search text in the field and click return on the keyboard, you gt an error page instead. Any ideas? The site can be seen at www.greenhillbooks.com

I can tell everyone how many times I have read the CWP Filemaker guide and I'm still struggling. My problem seems simple but it's driving me looney. I have created an addrecord.xsl from the Site Assistant. It lets me add a record into my database but when I look in the database I noticed that several fields that have calculated lookups don't show their data. These lookups are from another database but I have created a relationship table. Is there some secret to make the database perform the lookup once the xsl passes the information to the field? Also Martin, I found an example you had post from a while back but it doesn't work for me. You have a input text on the s…

I'm using FM Server 7 Advanced to run a CWP solution. Does anyone know how to implement field validation via the web? I'd like to return an XSL error page which tells the user to input information in the required form fields. The web engine currently only outputs a generic "error 502" page.

Could someone please explain how I might publish a set records (that have zip code information) on Google (or some other) map ? This isn't a very important project.. so I don't want to kill myself over it.. it also doesn't really /need/ to be dynamic, though that would be nice. Are there some simple options ? I have no clue about how to approach this. The database is served on Filemaker Server 7 (standard version), but I could move it to Server 7 Advanced. In any case, thanks for any advice or pointers to tutorials you can offer. Cheers :)

Hi All, We are trying to make a FileMaker database with a web page UI that allows our users to click on a button to open a word document stored on the same server that hosts the FileMaker database. We are using FileMaker Developer 7 and publishing it using the Instant Web Publishing feature. We made a button and in the "Specify Button" dialog, checked "Indicate Web Compatibility", saw that "Send Event" is not available and selected "Miscellaneous | Open URL". Under "Options" we selected "Perform without dialog" and clicked "Specify", entering the following (including the quotes): "file://C:/Documents and Settings/admin/My Documents/FMVersion7/ACE01.doc" W…

I have been working on a new site for our printing business, but I have ran into a couple of difficulties. I'm running FMP 8 and viewing my site using IWP, Should I get the Advanced version would it help me make this site any easier. Oh and the site is a "pay for print and design it while your there" site. The first problem is my container fields which show paper color don't show online. Next I can't get the tool bar to disappear, can you activate a kiosk mode? Now another question, if this was hosted on a FMP Server would it solve any of this? I'm no programmer, but I can learn if this is what it will take, the reason I picked FMP is it would be easy to learn and manage …

Hi Can someone tell me if it is possible to use a form action to trigger the download of a file using CDML or would I need some sort of Javascript to trigger it? thanks

I know this crops up quite a bit but I'm struggling to work out the optimal method to get data from FMP to MySQL on a regular basis. As a bookshop, we maintain all our inventory data in Filemaker. We are looking to set up an ecommerce website which would run on MySQL and with either PHP or RubyOnRails as the server-side technology. Now, rather than having to maintain 2 versions of the database in FM and MySQL, the preferred solution is to move data from the FMP database to MySQL on a, say, weekly, basis. Has anyone done this sort of thing successfully and care to talk about it? I am aware of FMP Migrator and fmSQL Synch but am nor sure how robust these are.…

I have neve worked with HTML codes or web publishing. My client wants the databases I create on the web. Due to firewall issues, they are not able to access the databases remotely. I am in Nebraska and the client is in D.C. There will be at least 15-20 users or more needing these databases. What is the simple and cost effective way of approaching this matter? I looked in using Fxforge. Has anyone used this? And is it easy to use?

I am an intermediate Filemaker developer but have never worked with publishing databases online. I have a client that is considering going web-based so they don't have to buy as many licenses for the hard copies of Filemaker. However, the employees of this company are allowed to create and edit their own reports, tables, label layouts, etc. in layout mode Is this possible with publishing databases online? Would multiple users be allowed to enter layout mode? They will upgrade to 8.0 and Server 8.0 if they decide to go this route.

I have a few filemaker databases which I developed webpages to acces them using filemaker unlimited 5.5 and claris homepage if anyone remembers that and more recently updated in dreamweaver. My problem is that from certain locations people can't access any links on the page to the database. This occurs mainly in work environments where there is tighter security. I am wondering if there is any solution to this to allow access to the webpages from anywhere? Thanks Lorne

Once upon a time (FMP 5.5 and CDML) I could submit multiple records using a simple javascript function and inline frames. Now I'm using FMP Server 8 Advanced and CWP Has anyone figured out how to develop a xsl style sheet where the user can modify multiple records i.e., submit multiple forms on a single page? Or maybe there's a way to do this inside FMP

Hi have typed fmp7://IPnumber/filename.fp7 into safari and get a message saying OSX doesnt recongnise internat address starting with FM7. this is on my laptop and works fine on my desktop computer and both have same setups. i tried clicking a hyperlink in mail with that URL and it tried to open filemaker 6. when I deleted it says cant find associated application. Any ideas? thanks

My Javascripts that I have put in xslt stylesheets don´t execute. I have put them between the tags. Does anyone have an idea why this doesn´t work?

Hi - this is my first post, so please forgive me if it's in the wrong place! Having built a 'business tracking' solution some years ago under v5.5, I have taken on the challenge of building a similar solution to track contacts, stock, events and hires under v8. We have bought a single license of the software so that I can develop the solution and get familiar with the latest version. Following advice from other posts (this might be my first post, but I've been looking around for a wee while!) I've gone down the route of using a seperate 'interface' file - I guess you call this the Seperation Model. I've still to join a few things together, but the guts of the s…

I'm working on a web solution where I create a new record in a table populating two fields that serves as keys to a master table. When i create the record using FileMaker Pro Client and enter the two field values, the other fields get their auto-enter and look up values from the master table. The problem that I'm experiencing is that when I create the new record via web (CWP) and populate the two fields, the other fields that have auto-enter calculations or lookups don't get populated at all. If I however reduce the relationship to just a single field, it works fine. Is there a bug with the web publishing area in that auto-enter or lookup fields that are depend…

Hello All, I have a school db I am working on moving from 5.5 to 8 and using IWP to the web. Much of the database works however I am addressing a few problems. I am a novice but am motivated. I have been running this with 5.5 server on a lan for three years. Here is the issue. I have a button that triggers a find script: Set error capture (ON) Go to Layout [Find(print)] Enter find mode (pause) Go to field [select/perform, student::team] Perform Find this goes on to another layout with the found set The button on the find layout resumes the script The reason I am writing of course is that this is not working. IWP does not go into find mode. I …

Can anyone help me answer these questions: 1.) hosting - what are our options for filemaker server? does filemaker offer hosting plans themselves? have preferred partners? what are approximate costs? 2.) we've used instant web publishing to publish a database; however, there is a cap on concurrent users (5); further, we want read-only access rights to not require login; how can this be accomplished? via filemaker server? 3.) how can you tell filemaker to publish to a certain website that we have FTP access to, versus a pre-set IP address? Appreciate your comments CDCREEK

I am a relatively experienced web designer and programmer. Have used php/mysql for many site. Have a client running Filemaker Server 5.5 on Mac os X. Would like to display the database on the web-site. Can this be done? If so how? Can someone help and possibly forward a page that shows how it is done? IS the ip address sufficient to create a connection??? Any help greatly appreciated.

I am running FMP Server 7 and wonder if I upgraded to Advanced, would I be able to access the database remotely with an FMP client or would it just do Instant Web Publishing?

Current Contact List

Hello, I've done and managed a website made in ASP using an Access database. Since then, i've migrated to Mac while my client website remains ASP (on Windows). Before investing in FileMaker, I would like to know if I have any chance to use FileMaker instead of Access on the website, or should I rather consider migrating all the stuff into PHP and mySQL... The reason for me to chose FileMaker is that I could use this software not only for this website, but also for other purposes, with my Mac. Thanks in advance for any clarification given.

First, let me say I am not a very savvy database person, I have used FM 5/6 at work and have a bit of experience with relationships, defining fields, writing scripts, etc. but nothing to write home about. I am now looking into creating a database capable of web publication for an association (a home endeavor, not related to work). I did look into MySQL w/PHP (recommended repeatedly as being quick and easy) and was instantly overwhelmed, if that tells you anything. I only have a very basic set up at home - Microsoft Windows XP Home Edition, Version 2002, Service Pack 2 Dell Dimension DIM 4600, Intel® Pentium® 4 CPU 2.80GHz, 2.79 GHz, 512 MB of Ram with 55.9 GB of…

Hello, It seems like there should be a Simple solution to this but it's currently eluding me.... I have a multi-step process to fill out a record. The user inputs their info and clicks submit, which takes to a page to enter more info for the same record. However, the database naturally creates a new record for this second page instead of truncating it to the first. How do I tell it to use the first record, and how do I tell it which record to use?? I'm just using html. Thanks! Sarah

Hello, I don't know if this is where I'm suppose to post this, but here it is. I have a client that only has four users. They want to use FM 8 for a Client Rolodex. There would probably only one person adding entries to this and the othere would view it via the web, either locally or remotely, and also via hand held. Which version of FM 8 can I use for this type of setup? Thanks, Jay

We have been using the Web Publishing Engine to serve XML responses via Apache for about a year now. It works fine except that about once a week it just stops serving. The FM Server is still happily serving data to FM clients and the web admin interface still works too (although it says that the module is not running). The process appears to be running on the system, but parhaps just not in a happy state. Sometimes restarting the service works (although the times that it doesn't work may be a timing issue - ie not waiting long enough to see if it worked). By restarting the service, I mean issuing the following command: sudo SystemStarter restart "FileMaker Web P…

Hi can anyone help Im pulling my hair out. I have been working on a problem for days, I have a deadline and I cant find a solution. FM5.5 and CDML, recruitment company website, search and apply for vacancies. I have two problems. Firstly I have had to create a solution around an existing website which is in frames. My first problem is that I am passing tokens from page to page after the user logs in. Top frame - masking the URL so that that it appears that the user is on the correct (Original) website. Head frame - containing links to the current website which will be pages re-created in the Filemaker folder. Main Frame - this contains the main da…

I have a 6 file Filemaker solution that I would like use on the web. I expect a lot of web users....perhaps in the thousands (Thinking Big....lol). What can be done to expand Filemakers capacity. Can Filemaker 8 Server Advanced handle this? Should I rewrite the solution in another database? Thanks for any comments. I expect that this would primarily be a web application.

I have this date field (start date) that is set to a Monday within two weeks of the creation date of the record. I also have a date calculation field that runs through the same algorithm based on today's date (currrent start date). I'm trying to do a FIND through a URL where the start date equals the current start date. I'm not having any luck by using the field names in my query (i.e. &start_date=current_start_date) as I think it's looking for a start_date with a value of "current_start_date". How can I accomplish this? Can this even be done in FM? Thanks in advance! Jason

Does anyone know of a canned UserName/Password program available for purchase that I could integrate with my XSL pages. I am running the Filemaker Server Web Publishing Engine on a Mac G4 and have a separate Mac G5 running Filemaker Server 7 for my databases. Any thoughts would be appreciated. Also, if anyone has developed this type of routine and would be interested is selling it I would appreciate hearing from you. Thanks.........roadrunnerRay

Searched the archives for an answer to this question but came up empty. I am presenting a FM8.0 field from my database to a web page using the following XSL statement: Description: The field "EventDescription" displays correctly in my various database layouts over our network but when displayed using the web page the paragraphs all run together and other formatting features are not present. Any assistance would be greatly appreciated.........Ray

Hello, We currentlyhave FM5.5 and are looking at the best way to progress. We currently don't have a in house FM developer so training is something we would be looking at anyway. What i can't find out is...can we easily create a website/ecommerce site using fm8?? We have a product database which we wish to develop and we want everything to run from one root.. which makes sense. If anyone can advise me of the abilities of FM8pro in this area that would be appreicated. Thanks RF

I am quite intrigued by fxforge as I have a few web projects under way at the moment. However I'm also really skeptical. I have heard mixed reviews about the package. I of course don't want to part with my hard earned money by purchasing FXforge if it turns out to be a shonky packagage. Unfortunatley there is no demo of the software available to trial before purchasing. Has anyone had any practicle experience with the package? I would appreciate any feedback. If anyone knows of a demo copy of the packaged I would be quite interested in evaluating it. Thanks in advance Steve

Hi there! I´m beginning to explore xslt stylesheets. I´ve ran into two separate problems at the moment. 1) When I enter foreign signs, e g "å" (I´m swedish) in a field in a search page no records are found in spite of the fact that there are several records that contain this value in the specific field. Something about coding? 2) When trying to edit a record via a detailed record page everything seems to work, the right confirmation page is returned. However, no edit-action is performed in the database. I have this tag on the detailed page: but obviosly no record-id is passed to the database. Some help would be appreciated!

I have a field that has a calculated Auto enter value, which is the value of a calculated field in a related table. When I create a record using FileMaker, this works fine. When I create a record using WPE (PHP pages), the auto enter does not work. I have tried doing a calculated Auto enter value, which is the value of a non-calculated field in a related table and this works fine. So it appears to be something to do with the related calculated field!?! Does anyone know why this is and how I can fix. Thanks Halski

Hi, first hope I am not posting an orgument allready discussed. I am finding dificulties in publishing a databse over the internet, while I can through the intranet. I am doing this with Instant Web Publishing. I am using FileMaker 6, with it's own Web Companion plug-in. My LAN has a Router which runs on a Win95 PC. I use WinRouter for the routing process. I have configured it to pass the requests to my PC. But when I type in the adress bar, my static public IP , my browser response that can't establish a connection to the server. It's worth mentioning I'm using port 5100 for the sharing, I can't use port 5003 because Web Companion says it has a conflict. On my r…

I need to have a form on our web site to gather data from new and renewing members. The form would have a drop down menu to designate the type of membership, then calc fields based on the criteria selected. Then I would need data fields for information to be manually entered. The form would be emailed to an address, or dumped into a file on the server to be downloaded daily, and the information imported into a FM file or EXCEL spreadsheet. Can this be done using FM 7?

Hi, I don't need any specific help, just some help as to where I should be looking. I am confused by all the terminology out here. OK, I have a database working very nicely indeed on my Mac. It's on horse racing in the US. Course, number of runners, betfair odds, results, etc, etc. About 140,000 races logged so its fairly sizeable. I want a web page that people can load up, select a few options (i.e. favourite horse in every 7 runner race at Arlington) and get a page back that will list number of races and the profit/loss returned if you'd backed them all. So it would have to return some actual calculations. I'm not running a server at home - this will…