Custom Web Publishing

This may be a hopelessly ignorant question, but I'll ask anyway. We have a number of files running on our OS X network, hosted by FM Server 5.5. It now looks like we will need to provide remote access to these files via the Web, but still have them served inhouse by FM Server. I see how one can serve files on the web using FM Unlimited, but what about Server? Do we need to purchase some special additional CGI? Thanks, Eric

Hello Gang! I was wondering if anyone can compare these two approches. Using Terminal Services vs. Using VNC http://www.realvnc.com/ to do the FM remotly. Sorry if I missposted in the form. Thank you all!

Our company is currently undergoing it's first Intranet setup. Through the years we have developed a large collection of Filemaker databases that we use regularly. Instead of re-creating the databases in say... MySQL to use on the Intranet, I am wondering how I could implement our existing databases with our new Intranet setup. Any direction would be appreciated. Cheers!

I'm planning to build a FileMaker database. As always, I have some minnor questions about what hardware & software is better to use in this specific case. The project configuration is: The Db has to be searchable (and nothing else) through the internet by a limited number of people at the same time (not more than 40). Every user on the internet will be using it's own login and password to make searchs. The DB will be less than 110000 registers. The DB will be populated through 2 Macs in the same lan as the server. The server will be administrate remotely from another location. In terms of software I thought of: For the two Macs --> Two licenses …

I am working on helping a buddy setup a more efficient business. I built a simple PHP based mailing list and shopping cart program for him a couple years ago, but his business needs have out grown it. My idea is to develop a invoicing/customer database with FileMaker and somehow synchronize the online mailing list with the customer database and the orders database with the invoicing functions. How have some of you worked with something like this? His website is done in PHP/mySQL. Right now he downloads orders and imports them into FileMaker (not the best solution but it works) to print invoices. The goal is to combine everything so all functions are centralized.…

Hi there, now starting learn web system. Now i'm planing to create a web system that able to let customer create/view/edit record/order online with web browser(eg. IE) and on the office will have a FMP to open the system and do further function like reporting and analysis. So, i need to learn the web language, after research, i think FM will work better with PHP or Lasso. So, i will choose one of them to learn. I already know the basic of ASP, so which one you think is more suitable for me and which one is more powerful add can do more function on the web. The other question is can somebody let me know what is the relationship for XML with all the tools(PHP, Lasso, C…

is anyone using Terminal Server to look up FileMaker 5.5 files? We are having an issue where someone using Terminal Server to access our network cannot open a file that is open by someone within the office. Nor could someone in the office open a FileMaker file that is open by someone using Terminal Server to open the file. Please provide some insight... cheers!

Dear All, I want to use the data from a filemaker 5.5 SERVER in an ASP(x) page (through ODBC or Fmconnetor) Until now it seems that all filemaker files have to be open through some sort of client also needed to be installed on the server. It is unaceptable for our organisation to have a NT server logged on and/or a (client) application open on a server. does anyone know if my statments and finding are correct. if all is true does anyone have a workaround? thanks in advance regards Richard Stolk

I have a web based solution which works fine when tested on stand alone machine using localhost however I appear to have missed a piece of the jigsaw when setting up to use FM Server. Ive installed FM server 5.5 on a Windows NT server and placed both my HTML & FP5 files in the same directory within the filemaker server folder (having changed all DB files to multi-user). Ive installed FM Pro6 on a Network client machine. I then opened FM Pro on the client, opened remote my master DB file then opened my browser to connect to my home page however upon attempting to access the Data Base files via the browser Im being given the following message HTTP Error …

Does anyone know of a method (AppleScript, standalone app, or otherwise) for taking raw "forms" data which has been received via email (using OSX's Mail.app) from a web site (e.g., name and address data), and converting it to tab-delimited text -- so that it can be imported into a FileMaker database?

I have read a white paper from filemaker downloads site in the address : http://www.filemaker.com/downloads/pdf/fmp_vs_browser.pdf So I can not understand it completely and my question is: Can I working a FM database between 2 remote PC's with an internet connection without a browser? And what I need for this to happen? Also I wnat to know if can it be with up to 2 PC's? Is that working fine without a browser? Thanks in advanced...

Hi I apologise if this has been covered before, but I could not find anything in my searches of these forums. Part of my Filemaker online project displays an image referenced from a container field in the relevant database. The CDML used goes like this... <img src="[FMP-Image: ARTISTEPICTURE]" width="142" height="213" border="0"> All was good until the new images were imported into the container field for almost all records. When viewing the web pages after the import the image was displaying as a very low quality JPG. Comparing a record with a new image next to a record using an old image showed the difference in quality. Has anyon…

any ideas on how I search within the current found set? i just can't figure it out since the format file for the search and search results would be different. any ideas would be appreciated. thanks, carrie

Hello, I am having two problems I can't figure out. When I use the database on the desktop, the problems do not occur. They only occur when looking at the database in a browser. I am using IWP. I know, I know, use CWP. I will, just not yet. 1. If I edit a field that has a pop-up list, the value remains in the field and so does the newly edited value I just chose. If I edit any other field that does not have a pop-up list, there is now problem with that field. However the pop-up list fields will have the values twice in the newly edited record. What causes that? #2 If I create a new record the fields with pop-up menus have a line break right before the chose…

I've installed the fmpro 6 web connector onto a test win2k advanced server and it can see the files I'm hosting from another desktop, but I can't get it to bring up a webpage of the hosted files. I've set the hosted files on port 591 and setup the web companion following the setup guide, but still no webpage from the IIS machine. The server is running a standard IIS setup with default port etc etc. I'm a novice FM user and any help would be great. Thanks. Flock.

Hi, everyone, We have FM 5.0v3, web companion v6, on Mac OS 8.1. We also have Webstar 4.0 on port 80. This setup has been working reliably for 2 years, but lately FM started crashing. Incidentally, it was after we increased our number of DBs being served, _and_ we moved the computer out from behind a firewall. Then two things happened: 1) It would play a chime that sounds like C-F-C-A on an electric organ. 2) Then a few days later FM began crashing every day or so. I reinstalled the operating system on the computer and this seemed to fix the problem for a few months. But recently I heard those chimes again, and now FM has crashed twice in two days. …

Here my problem. The database is shared online by 3 user, each user insert or modify records. Each time we have to search in the database for one or more record and after the search insert a new record. When we repeat the search we do not find the new record, because the broswer keeps in memory the web page opened before with the first search ( see temporary files ) . This problems appears with all the option about temporary files proposed by the broswer. After each new record we have first to delete alla temporary file in the broswer and than we can check again the data. Does exist a solution? Thanks Sophia

Hello, I have an internal website running for my company I have most of the webpages located on my webserver and all of the others that pertain to the Filemaker links they are on the FM server. I have one user that if he clicks on a FM link he gets a page open but with errors, error and nothing is displayed on the page. He is running XP pro and using IE v6.0 with all of the most recent patches. His is the only computer out of 70 or so that can not open up the FM pages. Anyone have any troubleshooting solutions? Thanks, Jay

Dear All, I am buildang a CV database system to be used on my companies intranet. I have a simple database which is accessed by web pages to add and search records . All works fine, but I need to find a way for users to upload CVs to a network drive via the web pages. Is there a way I can do this and somehow link the documnet to the database record? So that when record details is displayed the user can push a button to view the CV. Thanks BW

Dear friends, i'm Maximiliano from italy... so i'm new user here ... but I'm an italian filemaker developer... if u want see something on line solution u can see this site: http://www.tuttocd.com --- thanks-- So I have now this problems and it' s incredible.. When u have a db you can share over internet, with web companion on port 591 and share with application, right when you select "Open Host".. Which port set on the router open for use fmpro in remote? Now I have open this port: 80,110,25,407,548,591 .... thanks in advance --maximiliano

I create a field with a valuelist. I make it a pop-up, so that users can choose a value. I publish this highly sophisticated db through the webcompanion. So far, all works OK. Then I change field format - popup: I allow the user to edit valuelists. That works ok when I change data in FMP6 itself, of course, but in the browser I never get to see 'edit'. Is that a failure on my side to change something regarding userrights/sharing/what have you, or does webpublishing simply not allow for this feature?

Hello Folks I have an equipment booking database which users have browse permisions online. The user enters from and to dates to search the database to determine if the item is free for the dates required. This works fine if the search returns some records. However when the found set has '0' records the results page shows all records. The find is performed through a script as it is required to find a date range using the from and to dates provided. Any ideas why this is happeing and can I get around it? Regards David

This may not be the correct forum for this question, but.... I have been using CDML and FileMaker for quite some time, and with the help of FM Forums, have produced some pretty nifty web applications that work well. What I want to know is if there is anything that I am missing out on by not using other server technologies. If so what sought of things can the other technologies do that FM Pro can't. If anyone has any info, or can point me to a good comparison, that would be great. Cheers

Basically I have a database of schools, teachers and students. When doing a search for a specific school, for example, I would like to see something like - Teachers - Mrs. Red - Mrs. White - Mrs. Blue Boys - Larry - Mo - Curly Girls - Hope - Joy - Faith Instead, what I get is - Teachers - Mrs. Red Teachers - Mrs. White Teachers - Mrs. Blue Boys - Larry Boys - Mo Boys - Curly Girls - Hope Girls - Joy Girls - Faith What modification do I need to make to my format file so that the category (Teachers, Boys, Girls) does not repeat for each record? Thanks in advance!

I want to create a URL that does a search in my FM database (all set up and working correctly) that searches for a blank date. In this case datedue=(blank). How can I pass this along in a URL? I can get normal valid dates to work fine, but I don't know how to format a blank one. Thanks for any help, Mark Durgee

Hi, I have been trying to validate that Field_B is not empty, but only if the value of Field_A has been set to "other." When I insert a calculation into Field_B's validation options in the database everything works as expected. The problem is that I cannot get Web Companion to return any error at all. At the moment I am using Filemaker 5.5 with WC 5.5.4.1 (Windows XP)

I am running FMP 5.5 unlimited on a Win 2k server with IIS 5. The install seems to go fine with web connector, but I cannot access the config. page. I have tried both using the local host address and the server IP address and just get the old 404 not found. I checked the logs and connector is initiating at startup but is shutting down shortly thereafter. I have checked and rechecked the documentation (and there ain't much of it) and can find absolutely no reason for this. I tried installing on a win2kpro machine with IIS and it works without a hitch. Any suggestions would be greatly appreciated. I will be calling FM support, but I fear that if their response is anything l…

I am using IWP and all forms render just fine in Safari but when I go to print the form is substantially reduced in size. I have printed non-filemaker sites and have no problems with them printing correctly. Any thoughts? Thanks so much!

Hi Folks, I've been trying to access my FMP6.0 DB's in my LAN using the FMP5://ip.address/filemakerDB.fp5 with absolutely no success. I can see my databases if I use the File>Open>Hosts or if I type in my ip address, but I cannot see it if I type the FMP5://... information in my browser. As this is internal, firewalls are not the issue. My configuration is: 1) Windows 2k server (brand new) 2) FMP6.0 Unlimited using port 591 because of IIS using port 80 3) Databases are multiuser and set to share remotely 4) Instant web publishing is being used I'm hoping you kind folks can help me through this. Cheers.

I have created some simple published databases using CDML. For example: http://www.bisd.net:591/directory/directory.html I would like for my published databases to work through the Palm Web Browser through our internal wireless network. In doing some research on FMP's Tech Info Knowledge base I found instructions for creating a PDQ file. However, in reading about the new Palm Web Browser 2 on Palm's site, it no longer uses a proxy and is not compatible with PDQ files. The new Web Browser is supposed to be standards based. See excerpt below: HTML Support Web Browser 2.0 supports the WC3 HTML 4.01 standard, plus some extra tags for compatibility. Scripting S…

inserting a pdf into a container and viewing through the web - generates a higher kb size of the jpeg preview then the pdf itself - how do I make the jpeg smaller. users need to see a thumbnail of the pdf prior to dowloading the actual pdf - I only really want to deal with one image format and it needs to be pdf.

Because of changing policy's and laws up here in the Netherlands we are forced to collect our email addresses by secure/verified opt-in. I've done quite some research lately but still haven't found a single software package that does such a thing, let alone in combination with our filemaker database. I hope that somebody here has experience with such systems running on a Mac of course and in combination with filemaker. Thanks! Alex

Hi there, i have a online quotation system which create by ASP and host by a server. It will let the sales person online to create a quotation for their customer, then the record will keep in a database on the server. The database i'm using is Access, but now i need to change it to filemaker database, so that i can using filemaker to create a system to view and manage the quotation record on the office. Now the problem is i need to know how can i link ASP with FM db. This is the first time i create a record from ASP to FM. So can somebody give me some advice. If it can done then i will like to used FM db for fulture website project. And another thing is if for this k…

The college I work for uses FileMaker exclusivly, and I am in charge of most of the Filemaker development for database work on campus, we are starting to expand into using more web databases, and at the same time some new work is being done on the College website as a whole. One of our Network Team members who is working closely with the Web developers is very anti-filemaker (primarily because he says that it is too limiting for web work, but since we have not used it in this way, I think his assumptions are a uninformed) He prefers to use ASP or PHP, and says that FileMaker can't do the same things, Since I have not done extensive web work (in filemaker or in anyth…

Hello all- I have attached a PDF diagram of the two routes to access my databases. I would love it if a few people could chime in about the security issues. My database holds information that is sensitive and security is important. In the attached diagram, I am assuming that I could set FileMaker unlimited to only allow access to the Web Server IP address. Would that work? Is a system set up like this vulnerable to the xml security issues I have been reading about (ie -dbnames,etc)? All of the record level access is not handled through the Web Security database but rather built into the system. Thanks- Courtney CRUAccessDiagram.pdf

I have a database up on the web using CWP. Problem: I'm using several drop down value lists on one form. In a read only view it looks great! When I put into "edit"(HTML form) and edit the form, SOME of the drop downs loose their value. All of my HTML code is correct, the CDML looks good... Is this a bug in FMP? I can't see ANY reason why this could be happening. ~Addam~

I've got a search page that displays all the values in a value list as checkboxes. Does anyone know how I could possibly format the value list so it is more than one column? custom web publishing, FMP 5.5 on Windows. Javascript is really my only scripting option. For example: current formatting: [_] Item 1 [_] Item 2 [_] Item 3 [_] Item 4 [_] Item 5 [_] Item 6 desired formatting: [_] Item 1 [_] Item 4 [_] Item 2 [_] Item 5 [_] Item 3 [_] Item 6 acceptable formatting, but not preferred: [_] Item 1 [_] Item 2 [_] Item 3 [_] Item 4 [_] Item 5 [_] Item 6 Thanks for your help and ideas, Carrie

I am trying to process a form on the web, and break it up into several smaller forms, as the form is HUGE. Is there an easy way to get the web companion to exit the record and continue to the next form without using scripting, which obvsiously doesn't work on the web? Any help would be appreciated. Thanks!

I have just posted a couple databases to our intranet using the web companion. Everything seems to work fine EXCEPT when you try to change any of the Data you get an error message, "Data Entry Error - Your attempt to save current record failed because of the following - Unknown error number 102" As it is posted right now there are no passwords for either of the database,everyone can change everything. I have not changed the web layout, in fact after I enabled the sharing, I have not changed any of the "web" components from what the web companion set up originally. Can anyone help?

Is it even possible to assign (for LAN access only) a virtual domain name for the builtin web server on FM Pro 6? eg. 192.168.0.55:69 ---> type.some_name.com Thank you!

I'm being asked to develop a web site where much of the content will be drawn from a FileMaker database. The site owner will be able to add, edit and delete content by using forms that hit on the database. The problem is that where the site is being hosted (a shared server that is serving up many databases for many other sites) I won't be able to use the Web Security Database or FileMaker's Access Privileges to control security. Users will still need to log in to view the site or make changes and I've made a simple user database to store usernames, passwords, etc. to control access while browsing the site but I can't think of a way to prevent FileMaker-savvy hackers from …

Our current setup is FileMaker Pro 5 on Classic. I have two database files. One requires that I use Web Security database to manage users who wish to access it through the web. The other file needs to be configured so that anyone can see it and browse it. Is there a way to embed a password in a form so that the user is not prompted to enter one from either the db file's settings or the Web Security database? Thanks!

I have a query regarding record level access on the web. I have a database in which I would like selected records open to browsing by all users, while the remaining records are viewable only by around 500 users, each with unique IDs and passwords (in the Web Security databases). Any ideas on how this can be achieved?

I work for an organisation with its main offices in London. There are about 15 staff here and I'm thinking of introducing a FMPro database. However, there's an office in Northern Ireland with one member of staff and an office in Glasgow with three members of staff who would also need access to the data. I've never had to think about this before. I've used the server version and that's what I would use here except I wouldn't know the best way to get the other two offices linked up. Is the web a solution? I've not see the web version so I've no idea how different or similar it is. Any advice would be great. I've checked other threads and come across references to Timbuktu a…

I have just developed a method (still testing) for restricting "-raw", "-fmp_xml" and "-dbnames". This is used in conjunction with an Apache server. The "Filter" is a php script, I've named it "fmpro.php": <?php if ($_SERVER["QUERY_STRING"] != "") { if ((strstr($_SERVER["QUERY_STRING"], '-raw')) || (strstr($_SERVER["QUERY_STRING"], '-fmp_xml')) || (strstr($_SERVER["QUERY_STRING"], '-dbnames'))) { echo "This request is not allowed."; } else { include("http://10.0.1.107:1154/FMPro?" . $_SERVER["QUERY_STRING"]); }; } else { echo "POST method is not yet implemented"; }; ?> To get to the php script, "fmpro.ph…

Hi all, I have a Linux box acting as a gateway for Internet connection. I also have a Windows 2000 box hosting Filemaker Server. I can connect on local network to the Filemaker hosted files, however i would like to connect (through the Linux box) to the Filemaker hosted files from outside our internal network. The filemaker box has a local network IP address. I can connect to the Linux box from outside through a VPN, but i dont know how to connect then to the Filemaker hosted files? is this something to do with port forwarding? Any suggestions would be appreciated Thanks Mike

Am I limited to view one record at a time or can I have multiple results from a FileMaker DB search on a custom web page? How would I handle this? Thanks!

Hello there! I'm trying to get CDML to work with my FileMaker database, with no luck so far. My problem now is that when I try to submit a page with CDML using this: <form method="post" action="FMPro"> I get the message: No file exists at

What is the best way to implement NEXT and PREVIOUS buttons on a custom search form? Thanks!

I work for a printing firm and we are looking for an online ordering system for variable printing such as business cards. To see the type of system we are needing, you can check out iWay . However, most of those type of systems are slightly more robust (read: much more expensive) than we need. If there are no other options, we will be forced to spend the money. I am familiar with Filemaker and have successfully completed many online ordering systems for our customers using CDML, but on screen proofing has eluded me. We need a solution that creates both a PDF for downloading and an image file (.gif or .jpg) to embed on the screen at the time of submission, with exact …

I have been trying to use a cookie to pass data from one page to another. So far without success. I can create the cookie, the browser says it's there and enabled, but I can't read it back into the next page. There has been a lot of discussion about using Javascript to do this rather than [FMP-Cookie:data] or [FMP-CurrentCookie]. Can anyone explain what's going on and does anyone have an idea of the JS i could use just to test the theory?

I am beginning to add a shopping cart capability into an existing online database. (I hope everyone will be helpful with my little stumbling blocks along the way. I don't have much time to complete this, but there is plenty of pressure!!http://www.fmforums.com/threads/images/graemlins/wink.gif) I would like to have the shopping cart order form in a separate window, floating above the products pages. Is this possible/wise, or should I recommend otherwise? Thanks, SoCalMacDude

hello, i was hoping someone might help me determine why my online search feature is limiting the results to 25 records? i am using [FMP-Record] & [FMP-FIELD] to display the results. is there supposed to be a limit to how many records [FMP-Record] will deliver? thanks for your time, EnderL25

Hello people! We have a relational database (2 files) that we want to put on the Web. Right now just to test it and all, I am using regular FM5.5 and the Web Companion and Remote Data Access Companion. I can access the file using the instant web publishing. The system will have multiple users (agents) logging in, and they will only be able to browse the records (prospects) that they have created. I specified a simple data entry layout as my form view. Once the users log in, they will access the prospects file to begin entering records. 2 questions: 1. How would I have records that were created in the prospect file relate to the agent stored in the age…

I have a little script that formats a work order number to 'YYYYMMDD.n' where 'n' is the nth work order submitted for the day. I want the script to be executed when a new record is created in the database. The users enter work orders via a custom web form that creates a new record in the database. How can I do this? Thanks!

My client has existing web forms and would like me to create a database that will read these forms when their clients fill them out and put them into a database to store information such as (name, age, etc.). I was wondering if this is possible. Do I need to recreate their forums in FM? Do they need a FM server? How do I get filemaker to interact with the webserver. Thanks for your help!

I am trying to restrict a particular user (password) to only creating records in FileMaker. This user would access my custom web form, fill it out, and click the submit button. This form has "-NEW" as the name of the submit button. I've unchecked all privileges except 'Create record' under File > Access Privileges > Passwords. When I try to submit the form, I get an error: Access Restriction: You do not have access privileges to perform the action: new. How to I set up this password to allow the user to only ADD records to the database? Thanks!

Hi all, A client has requested a 'intelligent' search feature for their website which has me slightly stumped. The theory is this: Customer enters product code in search box, the web site returns all results with matching characters in consequtive order... without necessarily being the same string. So, 'DFG100' would return: DGF-100, DFGQ100, DFG1100 but not DGF100 I've been thinking of performing a 'findall' request then sending the search term to the results page as a token, then displaying the valid hits using a pattern count if statement / inline action... although i'm not sure this is feasable / efficient. Anyone out there with experience of …

Hi Everyone, I am using FileMaker Pro 5.0v3 on a W2K server to share 8 databases that web forms plug in to. Seven of the eight work great, but one of these databases does not work well. After being open for about a day or so, someone will go to the form online and will get the following message: Database Not Open: Unable to process your request because the database "staffapplication.fp5" is not open. The problem here is that the database is open. When I go to the server it is up and runs fine. I either have to close the database and reopen it, or close the entire application and reopen all eight databases, and then the web form will work fine again…

I want to create a user (password) in FileMaker that would allow the user to use the web to submit a custom HTML form that would add a new record to the database. I would like to embed the password as the value of a hidden HTML form tag so that the user doesn't have to enter a password after clicking on the submit button. Is this possible? Is this a good/bad idea? How should I accomplish this (is it a matter of implementing a FMP tag)? Thanks!

On my custom web form, I would like to have a text input field to allow the user to enter an email address. When the user submits the form, I want to create an email that would be sent to the address entered (if one was entered). I don't want to save the email address in the database as it would only be for this purpose. When I try to submit the form with this text element included, FileMaker complains. How should I do this? How do I get FileMaker to do this process of sending an email when a new record is entered? Thanks for your help!

Excuse my ignorance but... Why do I need to designate a layout if I have a custom web form? What is the purpose of the layout tag? Thanks, Jason

Been running 5.5. I just updated to version 6. Now the pages I am serving up has broken links for all the images. I checked my raw html files and the images show up there. It is just as the pages are being run thru filemaker that all the images just do not show up. Just the image placeholder with a ? in it. Anyone have any ideas what happened? I cant seem to find what has happened? Larry

Hello - its the first time i am using FMP 5 on the web. To test the CDML tools, i created a simple small DB. I am able to add and delete records but the display of the fields doesnt work. Instead of the "real" field data the i get the "[FMP-field:Name]" displayed in the textfield (i.e. for the field: Name). When i understand right, this tag should be translated to the real fieldvalue. I checked all entrys on top (DB-Name, Rec etc.) with no result. What is wrong?

I should preface this by telling you that I am a genuine newbie! With that said... I have FMPro 6 installed on my Mac (G4 - OS X). The Local Data Access Companion, Remote Data Access Companion and the Web Companion have all been enabled under the Application Preferences (I've also got these options checked under File > Sharing). The WebCompanion plug-in config for the application has IWP enabled. I have a small html form (test.html -- this is appended to the end of my post) set as the Home Page and my TCP/IP port is set to 591. Apparently I am wrong to assume that if I type 'http://localhost:591/' into the location bar of my browser that it will replace the FM tag…

I would like to publish a searchable FAQ database onto the web. We are using FileMaker Pro 6.0. We do have Unlimited here but it is not installed yet. The FileMaker Server 5.5 is installed on a Mac OS 9.x system and our web server is located off-site. The client machines are both Mac and Windows. What is the process in which we can implement this searchable database for our configuration? I appreciate your help as we would like to implement as soon as possible. Thank you, Elana

I am using FM pro 4 with CHML on a G4, 450 processor. A client can enter through an ISP link and search a data base. It's been working fine for months now. But yesterday the search suddenly started taking forever and I don't understand why. Searching the data base on this computer is instantaneous. Using Explorer or Netscape to go to other sites is very fast. So I assume by themselves, each is okay. I use a specific port for access to the data base. The firewall allows for that. I use vicomsoft gateway to network several computers for internet access. This slowdown is bad for survival. Does anyone have any ideas of what might be wrong? The data base fields are inde…

Hi, I have resently enhereted a filemaker 4, webcompaion and claris home page solution. I would like to get some decent web statistics. Any suggestions? (the log file is a bit poor) Kind regards Vilhelm

Hello everyone! First time poster - I hope you can help me out! I'm creating a slide database, and have made a layout for each stage of the search process: 1) Search - shows fields the person would be likely to use to search 2) Search Results - shows a list of thumbnails, and the appropriate fields 3) Slide View - shows the image, and the other relevant info. I put a button on the "Search" layout which process the search results and switches to the "Search Results" page. On the "Search Results" layout I made everything buttons (the thumbnail, the title, etc) which switches to "Slide View" layout. Everything works just fine and dandy on the…

Hello all! I am new to FileMaker (about 5 hours new) and this is my first post! I'm not too sure if it's the right place but I think I might be close. I designed a web page that has an HTML form on it. I would like to have the information from the form processed and inserted into a database in FileMaker. Can FileMaker do the processing of the form information and then stick the data into the database? Where should I look for information regarding the URL to submit my form to and what would I use to process the form data? Thanks for your help! Jason

Hi there, I am using CDML to publish the data online. I want users to search the database and download the results. I could easily manage search database screens etc but how can I allow them to download the data they have filtered ? Any suggestion???

Hi I have been using web component of FM Pro (using CDML), but the problem is I have to make sure FM Pro unlimited is open with the database at the webserver. Is it possible to use FM Pro server to act as data source instead of FM Pro ?? Thanks in advance

I am sure the answer is obvious, but I just have no clue at this point. I have made a link.. <p><A href="http://65.69.30.194/downloads/[FMP-Field:Img1_downloadlink]"><strong>Begin Download</strong></A></p> I would like to add a script... <p><A href="http://65.69.30.194/downloads/[FMP-Field:Img1_downloadlink]&-script=Img1_downloadcounter"><strong>Begin Download</strong></A></p> Why isn't this working for me? What can I do to solve this problem? I should also note that this link is inside of an existing form, but I need the sript to run when clicking the link, not when sub…

Hey Everyone! I've got another humdinger! Problem: I have a web application that my clients have been using for a while. They came to me asking if we could make it so that they can put type in things like "Bolds, Colors, List items, etc.". I know there are several ways to do this. They made mention that they liked the "yahoo" way of doing rich text work. I was able to get my hands on a rich text web interface, but I wasn't quite sure how to get it to talk to FMP. I'm not sure how they would like UBB Codes... Has anyone had any success with this and FMP?

Hi there, i just want to ask if i have created a fm system which have database, member.fp5 and related.fp5. Now i want to link this 2 files to a website which created using ASP. So that i using the web to let user join as a member and key in their data and do something else, then i can use the system to check or regenerate the record. I know how to use ASP to link o other database link Access, but i don't know how to link with FM database. Regards, Henry

I've just been asked by a client to plan to make his intranet FMServer system accessible to staff via the internet, and I've never dealt with FileMaker's web publishing capabilities before, so I'm looking for some basic information here. The setup is as follows: FM Server running on OS 8.6 Client computers on various platforms, all running FMP 5.5 DSL connection to the internet, without a static IP (I realize this will have to change) I have two basic choices - the sales staff is small (4 or 5 people) so the client can afford licenses for them to have FMP on their laptops; however, because some of them have multiple computers, and may want to access the data…

I've been using FileMaker for years. HTML is a blind spot for me. Where can I get basic information to get started making my own webpages to use with Filemaker? I've created webpages with the default web templates with limited success. Any guidance would be appreciated. Thanks.

I have it working fine as long as a password is NOT required in the Web Companion Config box. So the open and close codes (whether the DB needs a password or not) all seem to be in order. As soon as I require a password, however, I always get an error message as shown here: I'm using FM Unlimited 6.0v4. I try with and without a "User ID." And of course I've typed the password very carefully, many times. Anyone have any ideas on what I'm missing? Thanks.

I have looked hard for answers to this but no luck---maybe y'all can help: The FM5 file appears locally through FileMaker Open Remote. It appears by typing the local IP address in the browser but if I type the actual IP address (the one provided through checkip, the one I use to connect remotely through Timbuktu) I get nothing. I have opened up Port 80 on my Mac OS X 10.2.6 iMac, but no luck. I have turned port-forwarding for port 80 on my Linksys router, but no luck. Suggestions? Thanks. Brad

Valuelist from field in another file not displaying in CDML! I have created a database called "CategoryDB.fp5", inside it has 2 important fields : "Category" and "CustomerID" - at the moment it contains 11 records. Next I have a DB called "LabelDB.fp5", it has several records and also has the fields "Category" and "CustomerID" in common. "LabelDB" has a relationship to "CategoryDB" with the field "CustomerID" wich relate to eachother (Relationshipname: CategoryDB). I have created a valuelist in "LabelDB" wich is ment to display values from the field "Category" in the "CategoryDB" related to a spesific "CustomerID" (E.g all categories in the CategoryDB for a selected cus…

I have configured FMP 6 to run on the web. Everything is fine except the "new" row in the portal is not accepting entry properly. The choices in the dropdowns can be selected as expected, but the fields in the new row that are supposed to accept free form text are not accepting entry. Any idea how to fix? I searched the forum history without finding a solution... p.s. Upgrading from 5 to 6 made the existing portal rows appear properly on the web. With, V5 I had to submit a change to the record before the existing portal data would appear at all.

Gee Wow. Sounds like the folks at FMI have done developers another favor in their latest version (FMPro 6.x) by opening a BRAND NEW security hole through which a cracker can drive data. It seems that in FMPro 5.x a developer did not need to place a calculated field on a layout in order to display the data therein via a browser. And - as a matter of security - fields which are not on layouts do not appear in many cracking tools and techniques. That functionality of security has disappeared in version 6.x thanks to the wonderful family of engineers at FMI. No, no, don't thank me. Send the good folks at FMI your thanks and let them know how wonderful they are.

I have a IWP enabled site which works perfectly apart from a value list - when the value list is edited through a browser ie checked and submitted - a dialog box comes up "Data Entry Error - Your Attempt to save changes to the following record failed because of - Unknown Error 102" The value list is assigned to a field with allow enrty into field enabled - and no validation is required for the field. Any Ideas

Hi, I hope someone can help me with a few examples or at least point me in the right direction as to where I can find helpful information. I have created a Family Investment Fund where members of my family can deposit funds into a master investment account which I use to trade and then distribute the profits to all members of the fund depending on their % of ownership of the fund. I have created 6 tables (databases) with all the information I need: -UserInfo (Contains user information including a UserID (key) and Password fields.) -Deposits (Contains info on deposits made by users to the fund.) -Withdraws (Contains info on money taken o…

I need to add a thousand separator to a calculated field that is being displayed on the web. I need to show formated amopnts (ie: $2,875.20).

here it is guys: http://www.evolt.org/article/comment/18/22880/ AND ASP lovers get it done over the free ISAPI filter http://www.cfdev.com/products/productdetail.cfm/id/1023 All the best!

Hey all. I have a FM database that I a currently serving using custom web publishing. When a user creates a new record it is date and time stamped. I am currently displaying the date and time the record was created using CDML, something like record created [FMP-Field: issued date] at [FMP-Field: issuedtime] the resulting text on the web page looks something like this: record created 2/21/2003 at 2:12:04 AM QUESTION how can I manipulate the format? I would love to see something more like: Record created Febuary 21, 2003 at 2:12 AM TIA JErry

I have a web companion form that has a check box in it. After the form is submitted via the web, I can view the record and see that the checkbox is marked. But when I run a calculation on the field, its as if it is not marked. The checkbox is using a value list that only has "Yes" in it. Therefore, checked = yes. I then have a script that does "If <checkbox-field> = "Yes" insert text "1" in <another-field>. Oddly enough, if I fill out the form within filemaker, the script inserts a 1 into the other field whenever I run the script and the checkbox is marked. What is different between the web companion and filemaker? I can't figure this out. Than…

I was getting ready for FM Unlimited anyway, but there have now been two episodes of strange flurries of activity that maxed out my 10-user limit. I'm wondering if it's an attack of some kind, or if anyone has seen anything like this: 205.188.208.76 - - [24/Aug/2003:16:42:44 -0600] 205.188.209.70 - - [24/Aug/2003:16:42:46 -0600] 205.188.209.141 - - [24/Aug/2003:16:42:46 -0600] 205.188.209.20 - - [24/Aug/2003:16:42:46 -0600] 205.188.208.8 - - [24/Aug/2003:16:42:47 -0600] 205.188.209.109 - - [24/Aug/2003:16:43:09 -0600] 205.188.209.20 - - [24/Aug/2003:16:43:11 -0600] 205.188.208.101 - - [24/Aug/2003:16:43:21 -0600] 205.188.209.109 - - [24/Aug/2…

I have enabled my database to show the Status Area when it is on the web. However, it appears to be missing several options and I can't figure out why. In Form View the following buttons normally appear, as I read in FM books and as I see in other databases online: Edit Record New Record Delete Record Sort Find All Search However, in my database I only see: Search Show All I am using the Lavender Set Up View. I've tried other views and get other status areas but they all consistently are missing the same options. Any ideas? Tom

Hello everyone. My name is Aric Hoek, and I am a digital retoucher in Houston, Texas. I have owned my own business for over 6 years now, and I have accumulated a vast number of images that I have retouched. All the work I do is for professional portrait and commercial photographers in the area. Pretty much every day now, one of my clients is purchasing a reorder from me. Which is to say that they want to purchase a copy of an image that I have already retouched. So, I find the image on CD and either email it to them, or burn it to a CD, or I make a print. I would like to create a system that would allow my clients to see my data base online, which I just ma…

Hi! I have a search page with this code: <P><INPUT TYPE="text" NAME="_cday" VALUE="01/01/2003" <P><INPUT TYPE="text" NAME="_cday" VALUE="31/12/2003" This code works fine, but I would like to have the date in the second line to show the date today. I have tried to do this: <P><INPUT TYPE="text" NAME="_Cday" VALUE="[FMP-Currentdate]" But this only show up as [FMP-Currentdate] in the text box. The DB is located in another folder than the Web-folder. In the browser I open the URL: http://localhost/search.htm Maybe there is another way to get the wanted result. I hope someone can give me a clue on what to do. …

In certain fields of my database I have value lists in the form of a pop up list. A person can either choose from the list or enter text that is not yet on the list. Then it becomes another entry on the list. However, when I publish this database on the web (Instant Web Publishing) I can no longer enter any text that is not in the pop up list. I changed the pop up to a drop down menu because there is an option for "other" this way. But the drop down menu is very long and slow to scroll. Moreover, the "other" option doesn't work on the Web, just only when viewing the database directly. Any ideas on how to solve this? Thanks, Tom

Hi, I am running FileMaker Pro 5.0v3 on a Windows 2003 server. It is hosting 8 Filemaker Databases using CDML to create web forms on a website. Occasionally, one of the web forms will bring up an error dialog that the form cannot be opened because the database is not open. Once I find out about the error, I go onto the server, close the database and immediately re-open it, and the error is resolved. Does anyone know how I can prevent this error from occurring? Thanks, Chris

I am developing a FM database (my first) that is to be published on the Web. It will be an index of articles for a newspaper, going back to 1928. The database I have created on my home computer is nifty enough It does everything I intend it to. But when I look at it in my browser I am confronted with a number of problems. The biggest one that I need help on is the results of a Find command. I want the results of the Find command to return a form, the same form that I have for Browse as well as for Find modes. But on the Web I am returned a table. How can I solve this? Thanks, Tom

For those of you experienced in hosting FM, I'd appreciate a little of your experience. I'm currently hosting for a single not-too-demanding client, on a Mac G4 with OS 10.1.5. I'd like to branch out a bit, but I'm wondering about "accepted practices." 1. SPEED. When I was still in IWP, I upgraded my ISP's upload speed from 128K to 512K (download in theory is 3MB), and it made quite a difference. Quite a jump in price, too! Now that I've graduated to CWP, I'm wondering if I really need to pay for that 512K. Someone has said 128 should be fine. Each view in the database has a thumbnail, stored as URLs, and the JPEGs don't get much bigger than 16 or 20K. If I …

I'm in need of a cheep way to host my FM database web site. The site I've built is a community service site (lots of time in it, no money). All the hosting site out there want $50 - $100 per month. Is there anything out there a lot cheeper? Thanks

Hi, I am upgrading my old filemaker database FM3 to FM6 pro, and trying to setup the web companion so my database can be viewed from computers around the office. The way I understand it is that the web companion is the best way to do this, otherwise I would need a copy of filemaker on every machine that accesses the databases...right? Anyway, the most pressing Question for now is....When I access my databases through the web browser, my data is not updating. The best way I can explain this is, I have a Customer database, and when I want to write a Quote, I open the Quote File, Enter customer number, and the customer information pops up. It is not doing this whe…

I've used FM to set up a handful of databases for my studio. Now I'm planning to set up an e-commerce site that would link to one -- a first for me! I would like to be able to gather a variety of marketing/profile data, as well as receive orders for a modest product line. I'm currently using FM 5.5 and will be hosting the site and db on an OS X server. I realize that FM 5.5 only allows access for 10-12 unique IP address during a 12-hour period. However, the OS X server allows for unlimited client access. Do I need to upgrade to FM Unlimited? Or is there a viable solution for the version I already have. I have just confused myself on this issue. Any sugges…

Ok guys, I have been using IWP for about a year now, and it serves most of my needs for one of my databases. I am using CDML on all of the other databases, so I am not a stranger to it. How much traffic can IWP handle simultaneously? I need to be able to accomodate site traffic of approximately 6 users, simulaneously, entering about 50 records each. Any knowledge out there that I can benefit from would be greatly appreciated.