Custom Web Publishing

Hi: I am experimenting with Instant Web Publishing and can't find if this can be accomplished using FMP Server Software or if the databases need to be hosted using a client (stand alone ) version of FMPro? Can anyone give me a general idea of what the overall picture is with publishing online using the server software? Thank you,

i am using Custom Web publishing on Filemaker 5. when i am displaying a longer text field in an html page i can't get the Line Breaks to show up in the html page. is there some tag i can put in the filemaker text field that is going to show up in an html page? thanks

my users on the web first enter their usernames and passwords. if they match with the records in my database they can go other pages. but when they enter their passwords and usernames they are shown on the URL line of the browser. Do you know how can I manage to make them unvisible on URl line ? thanks in advance abdulkadir kaplan

As long as you are not attaching files to the email, you can use "Open URL" and the "mailto:" tag. As part of the mailto tag you can include cc, bcc, subject, and body. It will use the user's default email system and will work with both MAC's and PC's.

There were some appliscripts floating around the web some years ago that automated the process of importing messages from Eudora's inbox to a FMP database. I never used them and dunno where they are now. Maybe an alternative might be to set up a "forum" kind of system where people use a web form to post messages directly into the database, rather than using email.

I just stumbled onto this forum, so forgive me if this question has been asked and answered. I am an experienced filemaker developer with an assignment to create a web form for people to sign up for various events. All it needs to be is a single, secure form with a few links and a graphic or two. The problem is I don't know the web, HTML, web servers, nuthin. I wouldn't know a secure form if it bit me. Can someone direct me to a good starting point for getting our database live on the web? My employer and I have discussed HTML classes. Is that the best way to go? -Heather

Hello all, I'm relatively new to web publishing usin filemakers 'instant web publisher'. I've created a simple form-based database and have successfully been able to view it at 'http://localhost/'. Using the standard themes within the instant web publisher. However the 'submit' function in 'add record' is trying to target an htm doc called 'zformvwcss.htm'which is missing. The delete form 'zDeleteCSS.htm' seems to work - but what's driving me nuts is that I can't find where these forms are located within the applications directory. Am I correct in stating that any referenced .htm docs should be located within the 'web' directory of the Filemakers application folder? H…

We are running a Filemaker Pro 5 database via web browser, it works brialliantly. the only prblem that we are getting is the fact that when you print out the job sheet is either to small or to big. i have tried looking at all the printing prefs in Filemaker, also at the page setup but I've had no joy. Does anyone know a fix for this or has anyone else had this problem in the past. Thanks Carlosmc

sounds like you need to chage the method of your form from get to post.. should be something in your form tag that looks like method="get" change it to method="post" if you dont see that, then add method="post" to your for tag, like so; <form action="FMPRO" method="post"> that should fix the problem.

I am the technician at a local college, and I have been given the task of maintaining the college webserver (B&W G3, 256mb, 10gb HD, OS8.6). The person who set the machine up, has now moved to another job, and my knowledge of webserver applications is minimal. The problem started when the primary HD failed. I had backed up the web folder that contained all the files, so transfering it to the new HD was easy. The software used was "Webstar" "FileMaker 4.1" and "Lasso". Luckily Webstar and Lasso were on the "web" folder which I backed up, but FileMaker wasn't. And because I no longer have the FileMaker disks (I think the guy who left, took them with him), I downloaded t…

OK !.. I have found the solution !.. here : I can put my record"s" in an edit form on the web so I can only edit the first record. But on the list I can see all my records and I can write in to the fields but when I click on the edit button, my inputs on my records go in to the field of the first record. That is OK . while editing I run a script in my database. That script find my records which I see on the web, put them in the same sort order with the web and than the script goes to the first record takes the data written from the web , put it into a dummy global field, and takes the words or letters one by one according to the current record number ( or current protal …

I am running FMPro web services off a MAC and would like to know how many hits my web pages are getting. I don't want a hits counter on my pages but would like to be able to run a report showing me the information (hits per day, hits per month, etc.). Is there some kind of software I need to install on my FMPro Web server? Thanks.

I need to put a bulletin board on a website and wonder if anyone's made one using FMP5??

I work at a K-12 school district and I have setup a simple FMPro database to keep track of repair requests for our department. I am using the web companion to enable the other schools to add records ( work orders ) and search the database. The down side is that I have it running on my PC that I do most of my other work on and I have to keep it running all the time. Is there a dedicated FMPro server product that has web access ? I can't imagine that the web companion can really handle that much load. The reason I'm concerned is that the general maintenance department is looking into a web accessable solution for their work request DB as well. they have a lot more volumn …

Does anyone know if it's possible to show checkboxes within a portal on a web page? I'm using FM 4.0 and Home Page to create the pages. Anybody got any ideas on this? cheers.

My database has 39 records and the source code correctly states that 39 records have been found. However, thegenerated code stops at record 25. This is the url I used to generate the results: http://129.7.44.89/FMPro?-db=stats.fp5&-lay=English_Table&-format=-fmp_xml&-styletype=text/xsl&-stylehref=detail.xsl&-findall I need to have all 39 records displayed.

We have a catalog with picts embedded in the file via the conainer fields. If we put this file on the web, I assume that it will fail since the images were put in as picts (don't ask me why ) If they were .jpg or .gif embedded would it have worked. Thanks, Barrett

Someone will think I am off my rocker, but he it goes. For security reasons, I need to keep the machine containing behind our company firewall. Does anyone have a PERL or PYTHON script build that will take take the information sent to the web server from a form and format the data to then send to the database? the Firewall will be configured to accept requests from the web server to go to the specific machine with the FM database. I am not doing any tricky queries. I am actually doing searches on three fields. TIA

Hi Dennis, You can do all the things on your list except the uploading of images. Hope this helps, Martin Wiedemann

How to use AND OR both in the same page. I have a problem when working with "AND" and "OR" using CDML. My problem is "I have a search page for searching the database.In that search page i have 2 sets of input fields.For one set of fields the logical operator AND/OR should be assigned according to the user selection.And for the second set of records the logical operator should be always "AND". I think you guys understand the exact problem.I don't know how to implement this in my search page.Is that possible to assign "OR" for oneset of fields and "AND" for other set of records in the same page? If so please let me know. I'm eagerly waiting for your replies. Adv…

I want to create a search page. On this page I want people to select the minimum price they want to pay for a house and the maximum price. (using to value lists). The results have to be the houses that have a price in between these min. an max price. In the database i have fields of adres and price for the houses. I am using fm4.1 Any one got any sollutions?

I've working on getting a FMP5 data base available to web clients using instant web publishing The main data entry window contains two portals that lead to related files. In FMP, data entry in the portal creates new entries in the related files. However, in the web browser (Internet Explorer), after clicking on New Record, I can enter data in the main file, but am unable to enter data for the related files. What can I do (if anything) to allow a web browser to create new related records? TIA Mike Willis, Purdue University News Service FMP newbie [email protected]

Hope ya'll can help me? I have a database online. Everything works fine. What I would like to do is track the users based on specific fields in a seperate database or in a text file.

Is anybody using FM4.1 with WebStar Server 4 lasso publisher plug-in?? I am having problems accessing my database. Any help would be appreciated. H.H.Lim

is there a way that i can add an image through the web, like in filemaker i can have a containor field that can hold images. but how can i do something like that over the web.

I am trying to create a search page which allows the web user to perform a find on a single field but with multiple selection - BUT using an OR statement across that field. i.e Hair Colour, search for people with hair colour BROWN or BLONDE, but not RED ...using check boxes As far as I can tell, filemaker predermines that the search criteria is BROWN and BLONDE - which of course is impossible! :-) Any help much appreciated. J

Hi, I'm hosting a database on Mac 0S 9.1 using FM pro 5. Folks access that database on that machine via FM Pro (not via internet.). When I access that DB via WWW on W95, when I do a search using my web browser it changes the set of records selected by the user on the Mac in FM pro. What am I doing wrong? Thanks ------------------ Never drop your gun to hug a grizzly.

I think this is a really basic question, so I hope there's a simple answer. I'm running a small (100) record database on Filemaker 4.1 over the web. I've set it up, and it works okay. However, when someone accesses the search field, once they've typed in their search, they can't just hit return to start the search; they have to click on the 'search' button. Does anyone know what I might be doing wrong? The relevant page is linked from http://www.hastings.ac.uk:7776/courses/ Thanks in advance. John

There are a few issues here: firstly, the user's details have to already be in a database somewhere: either you create this details db or you access an existing db through ODBC. Second issue is the need for common "keys" to identify people. Common isn't the right expression for the key, it should be "unique and consistent." Making the lookup on a person's name won't work, there will be two or more people with the same name. E-mail is a good solution since almost everybody has one. Or make an ID number but then people need to remember it. But remember that this identification "key" needs to be used in both databases for it to work. So the system could work like this: the…

I'm new to web publishing and have a databse with scripts in it. When i publish online the scripts don't run. Do i need to use CDML for this? If so is there any easy way to make scripts run? Thanks

I'm developing a form on the web, which will be driven by a FM database, could you tell me if it is possible to send an email notification with the new records data to a specific email address?

Can someone help me on a FMP web problem I've been having? I need to input data into an existing file with a repeating field using a form. Each time the "Submit" button is pressed, the old/existing data is replaced with the new data, OR a new record is created (depending on whether I use -edit, or -new) when I just want to add new data into the repeating field of the existing file. Is there a way to do this? ANY help would be appreciated. ) Kelly

I created a 'date' field in my FMPro database. I am using a custom web interface to publish it. When I use the [FMP-CurrentDate] tag in Internet explorer, I get a 2 digit year (1/31/01). When I submit this to the database, the date is automatically changed to a 4 digit year and reads 1901. How can I fix this?

Can somebody provide a link or a list of web hosting firms that support File Maker Pro...? Thanks John M

I host an FMP database online that is maintained by someone who lives in another city. Once a year, she needs to be able to replace the ENTIRE database from that remote location. I could give her FTP access to the folder that contains the database and she could theoretically replace the file, BUT since the file is open and in use by FMP all the time the server computer won't let her over-write the file. Does anyone have a suggestion for how to replace an entire database remotely? Thanks! --Jeremy P.S. I'm running FMP 5 Unlimited on Windows NT 4.

I hope you can help me, or at least point me in a good direction. when some one does a search on the web, and it goes to a search results page. i want to be able for the user to select one or more records, and click on a link and goto a print page that will have the records selected, listed in plain text.. for example.. Record: 1 First name: Jon Last Name: Henderson ------------------------- Record: 2 First Name: Jenny Last Name: Hendrix ------------------------- Record: 3 First Name: Bob Last Name: Jones and so on like that. so that the user can print those records in plain text. i am useing my own web page's for the database, not the web compan…

Hi all, I have been reading the website and it looks as though this program can help me out. My problem is this. I have a database online so that my webpages interact with it and it displays the correct information from the database. It allows people to make changes and stuff. I also have a database on my machine, the same database that a program on my machine interacts with. I want to be able to sync them, or something like that so there is current information in both. Is this the program I am looking for? Can someone help.....thanks

How can we print a series of records from a FMP data base on our website, and control the page breaks, so the report looks as close as possible to a Word document, and does not break mid-record?

I'm using V4 with Web Companion on a Mac. I want to build a web database that includes a list of postcodes (zip codes) and reps. Each rep has a number of different postcodes associated with them. I want the end user to be able to put in their postcode and find the nearest rep. Due to the nature of the data not all possible postcodes are included in the database, so I want the system to: (a)Firstly search for an identical match to the user input. (b)If this fails, search again looking for only the first 4 characters of the postcode. ©If this fails look only for the first 3 characters of postcode. Any advices would be gratefully received. Thanks

Hi, I have a purchase order file with a related line items file associated with it. Offline, I view the line items on the purchase order form through a portal. When I view the file on the web I do not see any of the line items (portal records), just the records on the purchase order itself. Is there a way to view the actual purchase order including the line items. Thank you very much for your help. Jeremy

If I have a web page on a site and want to query a FM database at another IP - but want the results to be placed inside that page on the original site - how can I do this? ie) I want the database to serve the information to another site... I'm sure this is simple - but I have a mental block and can use some help. thanks

I have a online form that requires a password. The form ask for a password upon submitting the data. Is there a way to ask for a password before the form shows up?? Thanks in advance for any help.

OK, I need to publish a FM 4.0 database to the web. The basic structure of the database is four files with a very straight forward relationship. File one to two, two to three, three to four. Every layout uses a portal. The lines in the portal open up a new layout in the related file with a portal to the next file down the list. Now, I would like to be able to click on the line in the portal and have it open up the linked file in the next layout using a web interface. Is this easy, or difficult? Thanks

Hello, first at all, I'm spanish so sorry about my english. I'm a newcomer FileMaker with a trouble that I'm not able to solve. I want to publish a database in the web with Web Companion, where is a HUGE form. The users start to fill the form, save the results, return later, write two or three fields of the form (or a password, I don't mind) and the form fills with the saved data. So the user can fill the form in more than a time. My question is: How can I do that the user can access only to his register and not to others? If you don't know how to do it, but know a book with answers to this, please tell me. Thank you very much.

Here it goes : I'd like to write my own home page, but I don't know how to link it with FMPro databases. I also would like to have a script (Open URL) ran directly as a web link and not with a button. Are both these things possible? Since I still only have the evaluation product, I can't access the Help file where all this should be explained. Thanx a lot! Nico

Is it possible to do the following using FM's instand publishing: In a sales leads database, limit access of leads to the leads for just that salesperson? I know how to do this with custom publishing, but I don't think this can be done with instant publishing...

quote: Originally posted by Anatoli: Is the connector serving the web server? Yes. And I have configured the Web Server Connector to point to two hosts (my two workstations running Unlimited) and one database.

hi, I have a survey that runs from 3-5 pages. What I have done is created a 5 page website that links to the database. My first page is set to create a -new record. the second &3rd & 4th & 5th page is set up to -edit the -recid value="[FMP-currentREcID]. This seem to work fine, but my only problem is when there are two users input data at the same time it scrambles the data around. Another word if user (A) creates a new record and go to the next web page. While User (A) is on the second page, another user goes in and create a new page, which cause User (A) to edit or update the incorrect record. Does anybody have any ideas on how to avoid this??? Thanks …

Has anyone used Filemaker Pro with Cold Fusion? if yes than what are the adv. or disadvantages? please advise!

This is not a question about fmp web companion. I need to know how to get information from an on-line database (non-fmp) into an off-line database (fmp). I have a feeling that this uses the http GET command but I am very unfamiliar with http protocol.

I've developed a database system and related http access via web browser. All section are under restricted access (logign+pswd). I am wondering if there's a way to expire the access on the browser after the navigation and use of the database has been interrupted for a certain continuos amount of time (say 5 minutes). The user should then be propmted to re-enter his password again to continue using the database (e.g.like hotmail). Any suggestion will be welcomed, thanks.

I am looking for some time saving advice on building a web guestbook in FM to integrate with the site I have built in Adobe PageMill (hosted by an off-site internet provider). Can I create a database and store it in my public file on the Server and just create a script that will import form info. from the PageMill page to the database? Any quick tips or alternatives would be appreciated. Thanks!

Hi! I have been put in charge of building a web site for a university that has a database that a select few admin people can go into to update alumni info. It will be hosted on a Solaris box. The db won't be too complex. Can FM live on a Solaris machine? Which FM software would be best to purchase for establishing a connection to it? Any security issues to worry about with FM? Thank you in advance, Christina

Help! I've created my databases that I want to share with 5 people via the web. I've created a directory on the external site where my webpage is hosted and added security to it. I'm now ready to publish my databases to it. In reading the documentation, it sounds like you are required to publish to the web on a local machine. Since my website is hosted elsewhere I need to know how to publish to an external web host. Is it possible? Thanks for your help.

Is there a way to automatically export into a form and dump to clipboard? Situation, i have a bunch of fields used for e-bay, and i'd like to have it automatically drop all the fields into a html template that i can just paste (it doesn't have to go to an external program, just to clipboard) Hopefully you can make sense of that. Thanks File Maker Pro Version 5

hi, some colleagues of mine have created a database in filemaker pro and would like to publish it on our departments website. for security reasons the network administrator would rather not have the database reside on the main server. i have a g4 server running appleshare ip 6.3 which i use for the departmental intranet which is inside the firewall. if i set up the fmp database on the g4 server does anyone know if it is at all possible to create an interface in a web page that the public would access from the main site. The interface would be used to send queries the the fmp database on my g4 server inside the firewall and have the queried data returned to the user o…

I downloaded Claris homepage3.0 and is using it .I am trying to connect to Filemaker-server using the filemaker Assistant but it is is returning a message like "Server not Responding ".But I have given proper IP address .Where is the mistake can any body help me ? ------------------

Hello, I need to add "Shopping Cart" capabilities to my online store that is currently hosted inside FMP4. Should I use a standard shopping cart program or should I build one somehow in Filemaker? All of my items are unique and I want the current DB to automatically update with "Sold" information immediately upon a transacted sale. Can anyone help? I really appreciate it! Cael.

I downloaded the trial version of FM5 server and loaded it onto my NT workstation. I have a few test databases that I dropped into the FM server folder but I cannot see my server when I click the host button from another machine. What do I need to do to make the server host these files? Do these files need to be open in FM5 to be active? Thanks any basic instructions.

Does anyone know if FMP V is Secure Socket Layer compatable. Version IV wasn't according to "FileMaker and the www" book. This would be helpful (necessary) in order to interact with some of the CC clearing software out there. If not, has anyone implemented a CC application, how? Regards, D Snow

hey guys, i'm a small web developer. i'm looking to relocate my sites to a cool new provider that will give me excellent service coupled with reasonable rates and FM databases. I'm in the Los Angels area. Anyone have suggestions? Most FM hosts seem to be MacOs, which is fine. Are there any on Unix of Linux? thanks, Feel free to email me directly if you like, or post back here so others can see.

Somebody is trying to develop Database driven web sites with FMPro 5 Unl. and Drumbeat or Know something about the incoming UltraDev from Macromedia?. Thanks