Custom Web Publishing
Interfacing FileMaker as a data source for the web.
2,562 topics in this forum
-
Whenever I perform a FIND in my online database, the results appear in a new browser window. Is there any way to prevent this?
-
- 0 replies
- 613 views
-
-
Dear all, I am currently making a cms system for a newspaper publishing their articles on the web. the problem I have got is that when try to submit, throught the web companion, more then 600 word in one go it
-
- 2 replies
- 693 views
-
-
Hello, I'd like to know if it's possible via intranet (a web browser, ie or firefox), to access preview mode.I want to sort and make sub totals, then print. I am using Fm pro 7, Is there any plug in i can use ? Or can i add a script to make the server switch to preview mode and print ?. ( the user's computers and the server are close). Or any other solutions ... Thanks.
-
- 0 replies
- 757 views
-
-
Steve T recommended a while ago that I include a false -edit command to prompt a login when using the Web Security Databases. I have a site that gives all web users limited search capabilities, while letting only certain users to have full search access. I have configured the WSD to allow all webusers to browse but only subscribers to edit. When users navigate to a "subscriber only" section I want to prompt a login (via a false edit) to allow only subscribers in. The following code (in the body) prompts the login, but it returns a javascript error saying it cannot find the record and the page gets bounced: <body onload="document.location='FMPro?-db=DB.fp5&…
-
- 12 replies
- 1.2k views
-
-
Hi, I am using FMP5.5 on OSX Jaguar. I have a small database for a local orginization that I am publishing on the web. Ihave a form set up to allow members to add thier information to a Member List. The information includes thier email address. I am trying to figure out if there is a way to hide the address from spammers yet make it available to other members. I am not including the mailto: tag Any Ideas. I did search many times but was un successful. Thanks in advance. I am using web companion and cdml. Dan
-
- 9 replies
- 1.2k views
-
-
When my users successfully complete a form, they are taken upon "submit" to an intermediary page that tells them the form is being submitted. A tag on the page sends them a confirmatory email with the following: <META HTTP-EQUIV="refresh" content = " 1; URL=FMPro?-db=DB_.fp5&-format=thanks.html&-mailto=[FMP-Field: Lister Email]&[email protected]&[email protected]&-mailsub=Thanks for your submission&-mailhost=server.my.com&-mailformat=mail.txt&-recid=[FMP-Currentrecid]&-Find"> This works fine so long as the user completes the form successfully before submitting. If, however, he forgets to add a required fiel…
-
- 2 replies
- 978 views
-
-
Is it possible to code a search form using CDML to use one of a couple format files to return the results, depending on a choice the web user makes? I have a couple search pages that are identical in format; the only difference is in their coded form info that specifies a different format file for returning the search results. It would simplify things if I could allow the user to choose which format file to use based on the kind of info they want returned (for example, online list with linked details, or printable copy, etc.) Any ideas? Thanks in advance, Peter Knowles
-
- 1 reply
- 669 views
-
-
We are presently running Filemaker 4 databases on a Windows NT webserver using IIS 5. We are soon going to replace the server and I'm trying to find out if we will be able to successfully run FMP 4 on a Windows 2003 server running IIS 6. Any thoughts?
-
- 2 replies
- 709 views
-
-
I have a website that is going to have viewers register, and then login each time they come to view the site - each html page must be protected so that only registered members can access the pages. There are million websites like this... I would really appreciate it if some one could point me towards a good resource or give any advice for how to so this using FM. Thanks in advance...
-
- 2 replies
- 701 views
-
-
I am having a problem with Server Advanced 7 on Mac OS X Panther 10.3.6. I cannot add a new record and get an error message when doing so. I can search, get search results, etc. but cannot add a new record. Also, I get a Javascript unknown error 6 when trying to access the server from another machine. Anyone have any ideas, or solutions? Thanks in advance.
-
- 0 replies
- 661 views
-
-
Anyone know if it is possble to run two identical databases? One will be "read only" using the Web Security Database privileges, whereas the other will be "read and write." Changes made to the read/write database should be automatically written to the read-only database. Can this be accomplished in a simple, straightfoward manner?
-
- 6 replies
- 873 views
-
-
We are using FMP 6 (not server version) for an on-line survey. The form was set up with HTML and CDML. Is there a maximum number of users that can be sending data to the server at the same time?
-
- 2 replies
- 782 views
-
-
-
Urg. Ok this is what i have ddb::crs | feild::crs_type | valuelist::crs_type Ive been working with claris homepage 3.0 becuase its the only thing i have found that dose CDML. I want to create a page where users can create a new cource. However I cant seem to make the pop up menu work. This is the code i have been using::::: <P><FORM ACTION="FMPro" METHOD="post"> <P><INPUT TYPE="hidden" NAME="-DB" VALUE="ihBHDSCource.fp5"> <INPUT TYPE="hidden" NAME="-Lay" VALUE="crs_edit"> <INPUT TYPE="hidden" NAME="-Format" VALUE="crs_view"> <INPUT TYPE="hidden" NAME="-Error" VALUE="error.htm"><Select …
-
- 2 replies
- 983 views
-
-
I wanted to have a simple form online to perform a find in a field that contains email addresses. The problem is the @ symbol in the email address. Of course FM recognizes that as a symbol for one or more charaters when performing a search. Anyone other than me find it strange that FM did not change this in the latest FM7? Is there a way I can work around this? I dont want to have to explain to users to enter some compicated string just to be able to use the @ symbol in their email address. Larry
-
- 2 replies
- 826 views
-
-
New day, new problem. I have a questionnaire page, it has check boxes, radio buttons and text boxes. I've double checked to be sure that the values on both the CDML page and the database match. At the top of the web page I have: [color:"red"] <FORM ACTION="FMPro" METHOD="POST"> <INPUT TYPE="hidden" NAME="-db" VALUE="HRWL.fp5"> <INPUT TYPE="hidden" NAME="-format" VALUE="WLSurvey2.htm"> At the bottom of the page is: [color:"red"] <INPUT type="submit" name="-edit" value=" Submit "> <input type="hidden" name="-recid" value="[FMP-CurrentRecID]"> I'm currently testing it on localhost. Whe…
-
- 8 replies
- 1.3k views
-
-
I want to limit the number of characters a user can enter into a text area on a form. before i put any scripts on my form when the user edits the fields and clicks update, everything works well and the db fields are updated. However once i put the javascript to limit the number of characters in my textarea and then submit the form i get an "unknown error number 102". I know filemaker says this error is about incorrect links or field names but not in this case. Below is the javascript that i have used: <head> <script language="javascript" type="text/javascript"> function limitText(limitField, limitCount, limitNum){ if (limitField.value.le…
-
- 1 reply
- 940 views
-
-
Hey, thanks for reading this! I've just put together a snazzy FM7+FM7 Server contact/inventory/sales db for a friend with a small business, including eAuthorize for credit card sales. It seems like it should be a small step to let her publish to the web, and I'm sure it's been talked about and implemented left and right, but I can't find any FM Forums posts on it, other than someone saying "Try a Lasso or PHP driven website with MySQL/FM databases." Huh??? Google isn't helping much, and FileMaker.com only has a .pdf doc on "The FileMaker Web Store", published in November 2000, so that's useless Any suggestions on how to go about doing this? Any ideas on re…
-
- 7 replies
- 1.3k views
-
-
I have a couple of issues with a hosted database I am trying to write the web interface connection for. It is part of a Course Request System for high school students. The part I am working on is a way for department heads to enter the eligible courses per student, and then have that list be a custom pop-up, based on each student's eligible courses. E.g, Math Head says Suzie Q can take Trig & pre-calc, but not robotics. Then when suzie q logs on, she only can choose from Trig & pre-calc. Right now I am just getting the basic mechanics working and have a few problems. The entry page for dept heads works. They find a set of students (11th graders for Mat…
-
- 2 replies
- 784 views
-
-
Hi folks, I have a client that has a bunch of proprietary data that they want to sell access to over the web. Currently that data lives in Filemaker. The client would like to permit users to purchase access to the database, and receive dynamically generated username/password combos immediately on purchase. We're exploring the possibility of serving this up using FMS7 Advanced, and one of my main conceptual stumbling blocks (aside from not having a copy of FMS7 Advanced) is figuring out how I can deliver on the dynamic username/password combo without some sort of human intervention every time a sale is made. Has anybody dealt with this kind of request?…
-
- 11 replies
- 1.5k views
-
-
Hi all -- I have a script (thanks Garry!) that calculates today's date and formats it MM/DD/YYYY. I have placed it after <HEAD>: <script> Today = new Date(); var sTodayDate = (Today.getMonth() + 1) + "/" + Today.getDate() + "/" + Today.getFullYear(); </script> I want to use the variable "sTodayDate" in performing searches so that outdated records are not pulled. For instance: <form method=post action="FMPro" <input type=hidden name="-find"> <input type=hidden name="-db" value="DesignCalendarDB.fp5"> <input type=hidden name="-format" value="onthecalendar.html"> <input type=hidden name="-op" value="gte"&…
-
- 2 replies
- 642 views
-
-
Finally FileMaker Custom Web Publishing Made Easy November 15, 2004 DAYTONA BEACH, FL- November 15, 2004- FMWebschool announces the release of FXForge V1.01 a powerful automated custom web page builder for use with FileMaker 5-7. http://www.fxforge.net FXForge puts the power of web publishing back where it belongs. Yes, within FileMaker Pro. FXForge works from within FileMaker making use of FileMaker
-
- 0 replies
- 677 views
-
-
We have been working with a company to develope a website that links to a database containing the product that we sell, where our customers can view the product, then place an order. Needless to say we are having problems with the company now. As I understand it our set up is that we go to the admin page on the website, click a button and the database on the server will update the website. The company that we are using is acting like we have asked them to perform some miracle. We are now having to entertain the idea that we might need to have someone else complete this project, but we are concerned that if we do not get the coding for database link that we will lose a sig…
-
- 9 replies
- 2.3k views
-
-
Our department's phonebook is in a FM 4.0 database; the database can be queried through an online interface (I've been told the middleware program is something called WebFM). My question is: how can we set a limit for query returns? For example, if a query is going to result in too many "finds," we want to return an error page that tells users they need to refine their search. Thanks.
-
- 1 reply
- 696 views
-
-
Hi I have a weird problem, where my Filemaker keeps sending a waaay old version of a CDML-document to my browsers, even if I have corrected it several times. My guess is FMP web companion has the documents in some sort of cache and won't let go of the older versions (it has the same name). How can I force FMP to "forget" and go get the newest version of the document?
-
- 3 replies
- 898 views
-
-
Hi, I have some issues regarding IWP. I have two files..a) a database file, and : a custom html file. I have set IWP option On for the database file. How do I tell IWP to display the customized html file? In version 6, in the Web Companion Configuration dialog box, in the Web Companion User Interface section, from the Home page drop-down list, i can select the custom html page. How do I do the same thing in Version7? Thanks Srilakshmi
-
- 2 replies
- 915 views
-
-
Is there a VB Script class with filemaker functions? thx Z
-
- 2 replies
- 890 views
-
-
This post is mostly to inform myself on the capabilities of FMP. I am the current web designer at our small company. The company would like to have more interaction on our site such as sorting tables by date, product type, product serial number. There is a possibility of having an online shopping cart but at present no prices are to be posted on the site hence no online shopping. Other uses of interaction are forms to fill out to apply for courses or events. I have spoken to the IT department and they want all of this to work with Filemaker. I am fairly new to Filemaker. I've been using it for about a year now and have been able to set up databases and publish them to the…
-
- 7 replies
- 1.4k views
-
-
I've used FMP Unlimited 6 to process convention registrations online for a few years now, and aside from the usual FMPU crashing (which I wrote an AppleScript to check for and restart--I posted it here in the forums), it works pretty well, registering well over 1,000 groups of people in a year's time, including up to 50-75 people a day at our peak. But there are always a handful of people--I'd say 1 to 5 percent, although I'm sure I don't hear from all of them--who insist that it doesn't work for them. Most of them seem to use Macs (which is what I use), and the ones I can get to cooperate with me say they've tried more than one browser on their computer and gotten t…
-
- 5 replies
- 864 views
-
-
This past week I was in a Goodwill store finding things I can afford. There I found (but did not buy 'cause I already have it) a copy of FMPro 4.0 with serial number and instruction book for all of $2.99! Ok. So 4 does not have inlineactions and only one token. But with my abilities to make ScriptMaker reliable on the web those shortcomings have never bothered me. What matters is that Pro 4 does not require unlimited or server versions and it allows CWP. If I had to get a new copy of Pro I would not get 7 but would have gotten that copy of 4 for a true savings and client service. Keeping in mind the idea is to provide service to data via the web, not restricted by th…
-
- 6 replies
- 1.1k views
-
-
A search for records using two parameters is setup. P1 is set by an entry in a form and P2 by a hidden script. Found records are displayed using [FMP=RangeStart], [FMP-RangeEnd] and [FMP-CurrentFoundCount]. This gives the correct number of records displayed on the first results page and the correct total of records meeting the search criteria. As the number of records displayed on ther page is less then the total found [FMP-LinkNext] and [FMP-LingPrevious] are used. However on moving to the continuation page the continuing count of records is correct but the count of total records is wrong. This latter is using the total of records using P1 only, set in the…
-
- 6 replies
- 1.2k views
-
-
A quick overview: I have a project where 8 interviewers are conducting face to face surveys of about 10-12 Churches each. I have a database of 100 churches, detailing all the information about each church, including a unique identifying field and fields for comments. I have another database of interviewers, with all the personal information on the interviewers, as well as fields for each interview including a unique identifier for the intrviewer--not the interview, date, status, and comments. I have an opening page (findinterviewer.htm) where the project manager chooses from a list of interviewers the person whose record she wants to check. This takes her to Int…
-
- 9 replies
- 1.6k views
-
-
I'm using the web security databases to secure the databases I've published using the CDML but I've noticed that once the user has loged in he will stay loged even if the browser is closed, I would like to let the possibility to the user to log out or make him log out if he closes the page (or both), does anyone knows how to do that ?
-
- 2 replies
- 749 views
-
-
Hello I have a peculiar problem I cannot see the solution of: I have a database where users are creating records via the web. I would like to "mark" the first record of a given type, but not the following of the same type, so that I can search for all the "first records" - You get the idea? I have a field that counts how many there are it is of its type (counts numbers of a relation). What I need is to "freeze" this value in another field, so that when there is only one relation (meaning it is the first of its kind), this field gets the value 1, and when the next is created, this will get the number 2 and so on. I thought i could do it by calculating it (if the co…
-
- 3 replies
- 737 views
-
-
I'd like to send a confirmation email once a record is created by a webuser. I was able to do so by redirecting the brower to an intermediate "submitting" page that included the following code: <META HTTP-EQUIV="refresh" content = " 3; URL=FMPro?-db=ABCD.fp5&-format=thanks.html&-mailto=[FMP-Field: Lister Email]&[email protected]&[email protected]&-mailsub=Thanks for your submission&-mailhost=mail.abcd.com&-mailformat=mail.txt&-recid=[FMP-Currentrecid]&-Find"> Then I moved the server in-house, and my new ISP requires SMTP authentication for all outgoing mail. Anyone know if I can drop authentication code in here?
-
- 2 replies
- 930 views
-
-
I have a web page that searches a database. I need to record the search term used in the search to a second database. I can't for the life of me figure out how to do this with CDML. Any suggestions?
-
- 0 replies
- 677 views
-
-
Dear All, When i insert an image into a container it works fine when i use the Filemaker application, however when i view it via the web nothing is displayed. I know this is not to do with access and privileges. Any help will be appreciated Thanks
-
- 3 replies
- 774 views
-
-
If I use the web security database to protect a DB published on the internet is that possible to get the login of the users who consult the database ? (I would like to get the login of the user to set a field automaticly if a new record is created by the user)
-
- 2 replies
- 668 views
-
-
Hello, Just got V 7. I was looking forward to the Web Publishing, wish is a lot easier then 5.5. My Questions 1) I have buttons that on my desktop, open other files. That tend to be a realtional. They do not work online. Is there a way for that to happen? 2) I have fields set to do Lookup, Stock# makes Item etc.. This does not work online. Any way to make this happen?? Thanks Salesman
-
- 5 replies
- 913 views
-
-
This is very simple question and I'm sure there is a simple answer. No matter what I do, the title of my FileMaker web page is "FileMaker Instant Web Publishing". How do I change this to what I want? I have tried a script that generates a New Window with my title. This works on my desktop, but on the web the title is still "FileMaker Instant Web Publishing".
-
- 3 replies
- 842 views
-
-
Dear All, I have made a few scripts that open dialogue boxes when you click on various buttons - they are used as an error prevention measure . i.e. a box will open if they try to view project milestone data and there are no milestones for that project, saying no milestones exsist for this project - press ok to continue. This works fine on my computer but because the custom dialogue script is not web capatible it doesn't work using instant web publishing. CAn i get around this - will using filemaker server solve this. Any help will be greatly appreciated. Regards
-
- 1 reply
- 598 views
-
-
FMAS 7 only supports up to 100 web users and 250 fm clients. what happens if u have more users? i mean... do u buy additional license or set another server up? if setting another server up... how do u share the file among 2 servers? do u have to have 2 set of the same file and have some code to sync between the 2?
-
- 7 replies
- 1.2k views
-
-
I have four files (layouts, not sure what the right terminology would be) that are online but only one seems to open correctly. All the other ones say "Layout not found: Unable to process your request b/c the layout "21" could not be accessed". Now I have all 4 of the files in the same folder on the server with the same permissions but it makes no sense that only one opens up. Any suggestions?
-
- 8 replies
- 1.1k views
-
-
I am totally niave here but can a FM Pro 6 database successfully integrate with an ecommerce web page that is in PHB, MySQL and an older version of OS Commerce? If so, to what degree and how .... OR what needs to be changed to make it work so that orders from the website can be accessed by FM in order to track inventory once those sales are made, etc.?
-
- 1 reply
- 646 views
-
-
I'm having similar crashing problems as others, having just installed FM5.5 Unlimited on an XServe, running with WSC. FM seems to crash, lockup, etc. about once every other day. I want to make sure I have the latest versions of the various components. FM5.5 Unlimited V5.5v2, Web Companion 5.5v4, and WSC 5.5v1. Is there a later version of WSC? Better yet... where would I get it? For the life of me, I can't find it on the FM site. As a side note... is FM6 Unlimited really that much more stable than 5.5? I'll have to pay $400 for an upgrade. This, in addition to an upgrade to FM7 Server Advanced. (Which is the reason I moved 5.5 Unlimited to the Xserve …
-
- 3 replies
- 1k views
-
-
Found some code in one of my old CDML web files that I can't figure out. Was wondering if anyone would know what this is? <a href="javascript:openReport('browser=Safari&browservernum=1&sid=SG636222&uid=63.xxx.xxx.145361&qid=Q6&name=&language=')"> Of course the part that is uid= is a IP address that I have swapped out xxx with. I am not sure what this type of javascript might do? LR
-
- 1 reply
- 686 views
-
-
Here is an example of how to do file uploads and access an FM database with PHP. First the form: <body> <form action="uploadtest.php" method="post" enctype="multipart/form-data"> <input type="file" name="myfile"> <input type="submit" value="Upload"> </form> </body> </html> Second the PHP file:<body> <?php $file_name = $_FILES['myfile']['name']; move_uploaded_file($_FILES['myfile']['tmp_name'], "/Volumes/Data/" . $_FILES['myfile']['name']); readfile ("http://10.0.1.2:1154/FMPro?-db=combotest.fp5&-lay=web&-format=hworld.html&name=" . $file_name . "&-new"); ?> File U…
-
- 9 replies
- 3k views
-
-
I tried publishing a new database. It shows up just fine but the old one is still up. I got rid of the files from the server yet it still somehow shows up and can be accessed. I just cant seem to get rid of these files for some reason. Any sugestions?
-
- 2 replies
- 741 views
-
-
Hello all, it has been many years since I've had to update a db for my customer. I can't remember for the life of me what settings to use upon uploading the db via FTP. Do I set it for Mode = TEXT (alternate choice is binary) Format = TEXT (alternate choices: raw data, mac binary III, binhex, apple single) Thanks in advance.
-
- 2 replies
- 804 views
-
-
For about 5 years I have been running sites with FMPro 4.1.1 and now 5.5 using CDML to search and display results. Never had any significant problems. On one site I am now adding container fields for images. These images are to be displayed when the rest of the data in the record is shown So far I have been unable to get the images to appear. Have used the CDML code as for displaying text [FMP-FIELD: image1] which doesn't work. Have also tried <img src="[FMP-FIELD: image1]"> also to no effect.. When I use the straight CDML (not img src) I get numeric characters displayed. I have made several changes in getting the image(JPG) into the container field, …
-
- 5 replies
- 899 views
-
-
Hello. I have a problem that I need to find a solution for. The scenario is to have users go to a web page, fill out a few form fields, and have that information sent to a filemaker db when they click submit. Now, I know this can be done easily, but I have a few snags I need to figure out. First, I am using filemaker pro 6. I understand that you can only do the above scenario when filemaker is open, and the database is running as well. This presents a problem, because the computer that hosts my website is not controlled by me. Therefore, it would be hard for me to say to them "please install filemaker on the server that hosts my site and always have xyz databas…
-
- 9 replies
- 2.3k views
-
-
I'm running FMP 5.5v2 (OS X 10.3) and my wife has FMP5.5v1 (OS X 10.2). I don't know how there came to be a difference -- I got the FMP boxes at the same time -- but I'm wondering if that is a problem in reestablishing our network. It has worked pretty well for three years now (occasionally, the top box in her host dialog is empty, but usually, restarting seems to help). Now the hosts dialog on her computer takes a long time to come up, and it is always empty. I've tried option-clicking Local Hosts, changing the type of file it is looking for to All Available, restarting and shutting down both computers. Should I reinstall? Which computer? David
-
- 4 replies
- 800 views
-
-
Hello. I come from an access and mysql background, and just recently started working with fmp 6. I am not used to it, but I would appreciate your help. I need to know how to take user input that is in form fields on a web page, and when they click submit, the data goes to the fmp database I have on the server. Similar to the way a .mdb file would handle this query. Does that make sense? In other words, you know how you can take an .mdb file, stick it on a server, and access it with a connection string and sql and queries? Can this simple action be done easily in fmp 6? Thanks for your help.
-
- 11 replies
- 1.4k views
-
-
We have small network of G3's and one IBM all using FM6 with one acting as host for all files. It works great, until I set the host computer to hook up to internet then no-one can connect to the host with filemaker anymore. What can I be doing wrong or how do I use internet and fm on same computer? All computers are hooked up with ethernet cat 5 cables to a central hub which also attaches to internet. clay
-
- 8 replies
- 1.4k views
-
-
Well, I'm completely new to databases and I'm doing a project that requires the use of a database. Here's the scenario, I need a database that will be on a webhosting company that will be accessed via web. Basically it will be a part of a website for an animal adoptiona agency. The website will have the organizations info on it like any other website, but it will also have a database of animals and their information and picture, that the end user (via the web browser) can sort through to see which animals are up for adoption. I thought FileMaker would be the one to do this, but it looks like i misunderstood their Instant Web publishing. Now, if I understand t…
-
- 5 replies
- 1.3k views
-
-
I apologize if this seems silly. I have a situation whereby a client is entering information into our fmp6 databases via a cdml web page. However, they do have their own fmp6 databases and are currently having to rekey or paste the information into theirs as well as our web page. Rather than go through all the complications of linking theirs with ours what seems to be the alternative is for the client to be able to export out the data to their desktop using the web browser. I know this probably means xml. I think i know the theory but am a little vague on the nuts and bolts. Can anyone give me any practical advive. Or has anyone actually done this.
-
- 5 replies
- 910 views
-
-
I am simply trying to capture the webpage from where users linked to my survey in a token, so that while the user is in the midst of my survey they can hit an exit button which will take them back to that webpage. I tried this, but it did not work: <input type="hidden" name="-token.9" value="[javascript:history.back(1)]" Thanks for your help SBFB
-
- 5 replies
- 955 views
-
-
i've got 6 unlimited installed on a W2k workstation that has IIS installed...i've got the port of the http service on IIS set to 81 and the web companion to 80...everything has been fine...i rebooted it yesterday and now it's complaing of a port conflict on 80...IIS is still set to 81 and there is nothing else using 80...any clues?
-
- 2 replies
- 755 views
-
-
When I try to open FMP 6, it hangs on the splace screen with initializing TCP/IP for 2 to 3 hours. During this loading process it uses 95-99% of my computer processing horses. I have uninstalled and reinstalled. I have removed fonts. I am tearing my hair out. I HAVE to use this program as a subcontractor on a project and it is driving me crazy.
-
- 2 replies
- 643 views
-
-
Hi there, I have published my site using instant web publishing. The database display is smaller than the browser area. Is there any way to fit the database fields etc to the browser size / resolution. I know i could manually change it for my view but this might be different for other users. Any help will be much appreciated.
-
- 1 reply
- 588 views
-
-
We are moving our FileMaker Pro 6 Database to a local server in hopes of using the Web Companion Plug In to make it a multi-user database for our small office of about 4 users. We need to have simultaneous access to records to do updates and searches throughout our work day. Right now only one person can access the database at a time. I'm not sure I understand how the access is set up. Either the server where the database is located will be the admininstrator and us users will have to have permissions set correctly, or that the database will be password protected and we get in using that one password. I have read that each of us will have to install the Web …
-
- 3 replies
- 875 views
-
-
I have a project going that works in the following way. I enter a date on the web search page and in a search page text field I enter the date of interest. I want to store the user inputted date into a token so I can use it in the results page. You might think why shouldn't I just use the found field in the results page? Well I am having people input multiple dates in the date field so searches can associate this single record with multiple dates. When the field shows on the results page it only shows the first date in the field. I want it to show the date of inquiry and thought passing the data though a token would be the way to go in my opinion. I can get the to…
-
- 4 replies
- 795 views
-
-
I'm trying to setup an ISP Billing package called Optigold, which runs off of Filemaker Pro. Included in this package is a web interface which uses the Web Server Connector. I have tried and tried but cannot seem to get the web interface and the web connector to work properly. I have FileMaker Pro 5.5 Unlimited and WebServer Connector installed on a Windows 2000 Server running IIS 5.5. I have another Windows 2000 Server running FileMaker Server 5.5, which hosts the database. The only time anything ever seems to work is when I have Optigold's database open in FileMaker on the db server. And it's only accessible by using the db server's IP address. Th…
-
- 1 reply
- 681 views
-
-
I'm getting ready to upgrade from FM6 to 7 and consequently need to find a replacement for my CDML web files. Is there an advantage to using either PHP or XSL/XSLT for accessing FM data from the web pages?
-
- 1 reply
- 1.3k views
-
-
OK, I've been using filemaker on the web for about 6 months now, for various low-traffic searches but now I'm looking to step it up to the next level. I have it set up using custom web publishing and including database queries using PHP on my remote site. Because I hear the web companion is only single-threaded meaning it can only process one request at a time. I'm not using the web server connector. I have it running using FileMaker Unlimited 5 and i've heard there's a way to make a RAIC with multiple copies of FileMaker Unlimited to process more than one request. How do I do this? Presumably I need to be running the web server connector? W…
-
- 6 replies
- 977 views
-
-
http://xxx.xxx.xxx/FMPro?-db=Research.fp...dback&-find When this URL is executed, the browser goes to the -format page which contains info from a related record. If I take a look at my main FM file (research.fp5) it seems to still be in find mode. Should it not return to browse mode once the -find in the above URL is completed? LR
-
- 3 replies
- 922 views
-
-
Hi again, I have a database we are using to track interviews. It consists of 15 interviewers who will be conducting 15-20 interviews each. We are tracking all aspects of the process from assignment through followup using web forms. How do I restrict each interviewer to their records only. I've assigned each one a unique ID to be used as a password when logging in, but how can I restrict them to their own interviews only?
-
- 8 replies
- 1.2k views
-
-
I'd like to require a login/password for access to certain areas of my site limited to specific "subscriber" users to whom I will assign a login/pass configured with the Web Security Database. However, I wish to allow the general public to access the homepage. The homepage generates an automatic "onsubmit" query of the database which displays certain information when users enter the site. Subscribers will be allowed to enter a "members only" search page where they will be allowed to perform more extensive multivariable searches of the database. How do I allow all users to display the homepage without entering a log/pass if I restrict searches to members only on …
-
- 2 replies
- 735 views
-
-
Here's something strange. I have a FMP form that generates a confirmation email to the user upon a successful submission of the form to the DB: <META HTTP-EQUIV="refresh" content = " 3; URL=FMPro?-db=DesignCalendarDB.fp5&-format=thanks.html&-mailto=[FMP-Field: Lister Email]&[email protected]&[email protected]&-mailsub=Thanks for your submission&-mailhost=mail.design-calendar.com&-mailformat=mail.txt&-recid=[FMP-Currentrecid]&-Find"> Using the file "mail.txt" the email to the user lists all of the information the user inputted into the form by field e.g., Event Name: [FMP-field: Even…
-
- 2 replies
- 615 views
-
-
boxes in web pages. I am using CDML to display the information from multi-line Filemaker text fields. I would like to include things like bolding, paragraphs etc. to format the text that is presented on the web page. Any assistance would be much appreciated.
-
- 6 replies
- 899 views
-
-
I currently have a FileMaker 5.5 database that we want to convert to MySQL. Once converted, we want to access the MySQL database with the GUI interface already developed in FileMaker. I am looking for a MySQL GUI to do the reporting and conversion. Our reason for switching is because FileMaker Database is too closely coupled with the FileMaker application and because we are unhappy with the reporting abilities of FileMaker. I found a product http://www.navicat.com . It claims it can build report while managing local or remote MySQL. Does anyone try that before and can give me some ideas? Thanks! Kevin
-
- 1 reply
- 942 views
-
-
Can data be transferred from a desktop FM application to an online form with multiple fields?
-
- 2 replies
- 685 views
-
-
FOR IMMEDIATE RELEASE September 7, 2004 iApp Server 1.0 Beta for FileMaker Pro 7 Now Available for Mac OS X New Application Server Enables Custom Web Publishing with FileMaker Pro 7 Palo Alto, CA -- September 7, 2004 -- MACWEB.COM announced today the immediate availability of iApp Server 1.0 Beta for FileMaker Pro 7. iApp Server 1.0 for FileMaker is a brand new application server middleware tool and installs as an Apache 1.3 module on Mac OS X. A plug-in version for 4D WebSTAR V is coming soon. iApp Server 1.0 for FileMaker enables custom web publishing with FileMaker Pro 7 client. Use it to quickly and easily build dynamic, database-driven web si…
-
- 0 replies
- 767 views
-
-
Hi there, I've have created a database that includes links to pdf files. When i use the open URL script it works fine when i run it on my own laptop. However i need people at work to access the files. When i access the database via the web the Open URL buttons don't work (this is not a problem with active scripts as this is enables in IE). The script i use looks like this: First Group Projects::File Path & "/" & "Definition-" & First Group Projects::ID & ".pdf" It calculates which file to get as a result o other fields in the database i.e. if i am on the record for project 255 it will get the ID=255 and open Definition-255.pdf Can anyboby…
-
- 3 replies
- 706 views
-
-
Hi, Can anyone tell me if it is possible to pass tokens to email content files ie mail.txt I can put tokens in the subject of emails sent out from FileMaker but they never appear in any links within the content.
-
- 0 replies
- 611 views
-
-
How well does Filemaker 7 perform over the internet client-to-client or client-to-server (not using Instant Web Publishing)? Will it work over a DSL connection, or is it just too slow? thanks, patrick
-
- 1 reply
- 737 views
-
-
I took over maintaning the database but have been stuck with one problem. When trying to do a sort using FM online, I dont know how to add field names to the list to choose from. I know how to add items to the "sort order" but not "fields".
-
- 2 replies
- 804 views
-
-
I am already starting to hate the old IT guy...ok I can access the database beng used online by opening the database remotely but I still dont know which database on our server (there are so many copies) that is being used. Everytime i try to access some of them, I get the error message "Sorry, Filemaker is unable to read the disk the file in on."
-
- 1 reply
- 678 views
-
-
I'm having an issue with checkboxes. I have a page that users will be returning to again and again and they will make selections using checkboxes. However, they may decide to turn off the checkboxes in the future and my code right now prohibits that from happening. I'm using FMP-IF statements to see if the checkbox is checked using the database liek the example below: <input name="field" type="checkbox" [FMP-If: field.eq.on] checked [/FMP-If] value="on"> Since a checkbox inherently has no value when it is unchecked, Filemaker doesn't recognize that the user wants to UNCHECK the field upon saving the form. Can anyone help with a solution?? Thanks!
-
- 1 reply
- 618 views
-
-
I am using FileMaker Pro 7 on Mac OS X software TRYING to give web access to my coworkers from their home offices to my database. When I use the "url" that FileMaker gives me in the Instant Web Publishing menu it works fine for ME - but noone else. Someone told me it's because the URL it is giving me is my "local address" or something like that and will not work for anyone outside my "local network". How do I give the group remote access to both my computer and the database???
-
- 2 replies
- 690 views
-
-
Hi, guys, our database is on a server http:// ipadress:89. Remote client search works well. But the display of hits is messy: to see the attachment please. Any suggestion. Thanks. messydisplayzip.zip
-
- 3 replies
- 682 views
-
-
OK I hope you all can help or point me in the right direction. I have DSL and wish to have a basic dbase up for around 2 to 3 people to access and use over the internet. I am running FM7 (5 users - Plenty). SO either i am missing something or the manual(help info) is lacking, probably the latter. Even if my IP is not static that is not a problem. I ofcourse am having no trouble accessing the dbase over my local network. now by locating my IP through http://www.showmyip.com/ would a person outside my LAN just need to attach a Colon and 591? Someone needs to wirte a dummies guide for doing this for the casual user. Thanks for any considderation in this matter.…
-
- 3 replies
- 577 views
-
-
On my Web Companion site, web users are required to input dates for events they wish to enter in the database. They are instructed to enter the year in four-digit format (ie 2004). People being people, some enter the year in two-digit format (ie 04). When operating locally, FMP assumes the two-digit dates are for the year 2000 and thereafter. Thus, if a user enters 5/10/04, FMP enters 5/10/2004 in the database. Operating online, however, two-digit dates default to 1900 when entered for some reason. That is, if a user inputs 5/10/04, the date entered in the database is 1904. Any idea why this is, and what I can do about it? Thanks, friends.
-
- 6 replies
- 1.5k views
-
-
Today I installed Windows XP Service Pack 2. On the first re-boot, it asked me if I wanted to allow FileMaker Pro 7 access to the Internet, and I responded "yes". But when I started FMP7 it took a longer than normal time to start, and informed me that it could not start the Instant Web Publisher - before FMP7 did, in fact, start - without, it turns out, IWP capability. I then tried to share a database that had previously been shared, and it would not let me, giving me a pop-up error message saying that I could not share on the Internet because Instant Web Publishing had not been installed. But when I checked the firewall section on XP's newly installed Security …
-
- 1 reply
- 626 views
-
-
Just a quick one asking if people could please test my site powered by FileMaker. http://www.dealer-world.com/presszone It's not yet live and there are a couple of problems I'll work on tomorrow. 1) The search box doesn't yet work 2) The 'last page' link button on each page doesn't work as expected. If you could all post any comments you have on the speed of the loading of the pages. Especially people from the US/Europe (our site is based in the UK). I have implemented a bandwidth throttling system to guarantee upload/download bandwidth to the web companion over our ADSL 500 connection. The pages are generated using PHP to include the various …
-
- 8 replies
- 1.1k views
-
-
Hey folks; I'm currently using myodbc to link fmp and a mysql database. I've been able to easily import sql tables into a fmp db... no problem there. My problem is in exporting back from fmp into a mysql table. I want to do this via odbc, not csv or any other means that involves extra steps. In terms of SQL script, I think that what I want to do is TRUNCATE sql_table, followed by INSERT into sql_table. What I can't figure out is how to script that from within FMP7... I can't make any sense of scriptmakers sql calculation area, which I assume is where one has to link FM fields to SQL columns. How, exactly do I build a script that funnels FM field…
-
- 1 reply
- 781 views
-
-
I have a datebase of events that contain a "Start Date" and an "End Date" field. I want web users to see all events running for the current week, i.e., from today's date and for one week thereafter. At the moment I have to hard code individual dates. For instance, if I wanted to pull up events for the week beginning 8/1/2004, I'd have to put a link in like this: <a href="FMPro?-db=DesignCalendarDB.fp5&-format=onthecalendar.html&-op=lte&Start%20Date=8/7/2004&-op=gte&End%20Date=8/1/2004&-find"> 1. Is there any way to write this link so that it automatically uses today's date for this calculation (i.e., substitutes today's date for the…
-
- 8 replies
- 1.2k views
-
-
Excuse my ignorance about networking issues, but here goes: I've published a served database via a workstation that has the database files open. While at the company, I can just enter the workstation's ip address, and view the database on the web. Outside the company, that doesn't work. How do I figure out the right web address? Is it "http://xCompany.com/something:591"? How do I figure out the "something"? In a related issue, I'd like a user to open a remote host to get into their company's network when they're out of the office. The IP address I have doesn't seem to work, and the DNS name I have ("xCompany.com") also doesn't work. Does this have something t…
-
- 5 replies
- 906 views
-
-
OK, if I want to upgrade to v. 7 then I am going to have to dump CDML in favor of XML for my custom web publishing. Question 1: Is there anything that is currently accomplished in CDML that can not be accomplished in XML? In particular, current CDML items such as: FMP-Include FMP-IncludeField FMP-If: fieldName .lt. 1 FMP-If: fieldName .gt. 0 name="-format" value="[FMP-field:Research::link1] The reason I ask is that I run a online survey system built around CDML that contains about 150 HTML pages. They all heavily use forms of the above listed CDML tags. Question 2: In order to accomplish custom web publishing, are we still waiting on FM to rel…
-
- 6 replies
- 1k views
-
-
Does anyone know if I can create a form that will allow the user to attach an excel spreadsheet along with the form. I don't need it to do anything fancy, just drop it into a folder on the machine running web companion. Also, does anyone know where i can get info about the standards that the web server supports, such as SSI? Thanks!
-
- 2 replies
- 689 views
-
-
Hi all -- Kind of a newbie here, but not too clueless . . . Here's what I'm trying to do. I have a Web Companion site up and running. It serves a small database containing a number of records of events having a "Start Date" and an "End Date." (There are fields with those names, each formated MM/DD/YYYY.) I want web users to be able to enter a specific date on a form, e.g., 12/12/2004, and have the server return all records of events that are happening on that date. Obviously, doing a straight search for events having a Start Date of 12/12/2004 only returns events starting on that date and misses events that start earlier but continue through that date. I guess I need a sc…
-
- 12 replies
- 1.3k views
-
-
Hi All, I have a webserver running on my intranet, separate to my filemaker webserver but on the same subnet, and I would like to have some of the pages on that webserver display some filemaker data. Is there any html/cdml code I can use to "pull" data from the filemaker server and display it on that page, or will I have to redirect over to the filemaker server? Hope that makes sense? Thanks, Sean.
-
- 7 replies
- 1k views
-
-
I'm about to dive headlong into a new area of FileMaker, namely using it online. I'll give you some background so you know where I'm coming from... I'll be starting a new job on Sept. 1. Part of my responsibility will be to get the website up and running. Right now there is nothing there for a website outside of a white page with an address and a phone number on it. So I'm starting unencumbered by any history. I have a blank slate. The website will be linked to a FM 7 database which I'll be building as well. This database will contain data for customers and general public consumption. Eventually this FM 7 database will be integrated with the shop's extens…
-
- 6 replies
- 1.4k views
-
-
Hi All! I'm trying to create a custom homepage for my db rather than using the built-in one in FileMaker. Creating the page is easy but what I can't figure out is to create a hyperlink that will link to my db. Is there some type of "special" code in FileMaker that you need to use to create a hyperlink that when clicked on the webpage will open my db? Thank you in advance! Jackie
-
- 2 replies
- 717 views
-
-
i have a network that connects to the internet through my computer (2 NICs) using Microsoft Internet Connection Sharing (Windows server 2003 enterprise). Before IWP is turned on and accessed on the client computer, they can all browse the internet. But as soon as IWP is turned on, and after they try to access the database, their internet connection is lost. i have the rest of the server's services turned off. not until i completely exit filemaker will they be able to access the internet again. this is rather an odd sympton. does anyone else run into a similar problem? now i have to use sygate network manager in order to use IWP and internet sharing at the s…
-
- 4 replies
- 712 views
-
-
We are trying to install Web Server Connector for FMP6 Unlimited and receive the following installation error: "Warning: Failed to configure Filemaker WSC5-IIS Filter. You will need to manually configure the Filemaker WSC5-IIS before it can be used." (Note that when installing, it has WSC6 on the splash screen, yet the error refers to WSC5) Has anyone had this error occur before, and or know how to manually install the filter? Thanks in advance for you help! Tricia
-
- 1 reply
- 850 views
-
-
I'm new here & using FMP 6.0 [MS-Windows]. I'm looking for a solution for publishing static webpages to a local server to be FTP-ed for remote servers. We have over 500,000 webpages so the solution must be fast. We are currently using a perl program known as Hyperseek with mySQL. It has certain limitations that I hope FMP can solve (mainly, local input/editing & non-English characters). Can anyone recommend 3rd party programs to assist in the creation of large amounts of static webpages, including full international language support? I am familiar with HTML coding (all of our webpages are currently created with a text editor). Or, are there simple …
-
- 5 replies
- 932 views
-
-
Hey there FM gurus, I've come to you guys for help. I currently have built a filemaker db that talks to asp. The only problem is that it seems like my searches are case sensitive. If I do a search for "Smith", it won't show "smith". Please help! I've copied my code below: <% Dim registration, oConn, sqlString, lname, lastName, firstName 'lname = request("strSearch") lastName = request("lastName") firstName = request("firstName") 'lname = Lcase(lname) 'sqlString = "SELECT * FROM Registration where NameLast = '" & lname & "'" sqlString = "SELECT * FROM Registration where nameLast = '" & lastName & "' AND nameFirst = '" &a…
-
- 1 reply
- 924 views
-
-
I need to send large Invoice requests to several people, so they can attach a purchase order number and return it. From FM I have been turning the layout to pdf file and attaching it to an email. They then have to print, add numbers I need and then fax it back. They do not have FM. Is there a way to email my layout to them in a form that they can type in their number and email it back without having to print, hand write number, and fax it back?
-
- 1 reply
- 747 views
-
-
I am using fmp6 with the web server connector to host a website. I am using cdml to process commands to the database. When I search for something on the site I type in what I am looking for and I press submit everything works fine. If I press return then I get the following error:
-
- 3 replies
- 678 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online