Custom Web Publishing

Apologies if this has been asked before, until recently I had not come across filemaker and then I was approached by a client who uses FileMaker 8 and now wants to allow certain information from the database to be viewable and updateable online as part of their website. From browsing around the vendor website and other sources I can see quite a bit on viewing information online but can anyone point me in the right direction for information on how to update a FileMaker field from a standard web form. I plan to use ASP with VB, is this possible? Also does the entire database need to reside online or can the database remain on-site in my clients office as long…

Here's a strange issue. I currently have a database setup for IWP (FM8 server advanced) on a Windows Server 2003 box. I can access and navigate the site inside our firewall using IE. I can also get to the database and to the main page when accessing it externally. The problem is when I select any of the links on the main page; it results with an error on page from IE. If I use Firefox (internally and externally) everything works great. Any clues on what the problem might be?

My client wants to migrate his databases to a hosted site. I'm just getting my feet wet here. I saw two earlier recommendations for buddysystems.com and pointinspace - but I want to be sure we will get fast response. I tried a free trial with a company called datatrium, but access is unacceptably slow. So, the big question: is the response speed 100% determined by our internet connection, meaning they're all going to be the same, or is there such a thing as faster servers? If so, who's got em? thanks

I've created a database using FM8. I have it setup so upon opening, the user is logged on as guest and a new record is created. The user can then proceed to enter data into the fields I've created. This works great from the Filemaker application. Then I publish this database on the web and, just as it should, a new entry is created. The only problem is that the user cannot enter data into any of the fields. It seems like they are locked, but I am unaware of any setting that would cause this. Does anyone know what would be causing this? Thanks in advance!

I finally upgraded to FMP7 advanced. My help tells me that now it's OK to use container fields to serve images on the web. Is that the best solution. My typical page contains at least 12 images (90x90 medium .jpgs each) and a few others. All in all the website includes over 3000 images (a growing product database). I want to do it right the first time. My old site running on FMP4 called the images with cdml/html and avoided containers all together. I've read about placing a reference into a container field, is that that a better solution? Oh yea, what's a reasonable hourly rate for PHP help. Much thanks to anyone who has an opinion about this. ran…

Total noob here... I've tried searching but can't find anything. Can anyone let me know the basic steps to getting my database onto my website or lead me to a thread that shows the steps? thanks!!!!

Hi all I need to publish a form on a site where people register for seminars. When the form is filled with info, a confirmation window with all info in it is shown. The person registering click OK or cancel. This should generate a record in a FileMaker file. Can anyone explain how to do this? I've been searching for this answer but can't find it, only a lot about publishing an entire database for remote access. Regards /U

Hello: I have a mac os X laptop that I would like to test some custom web pages with. I also have Filemaker 6 installed on the machine to launch the application. Could someone give me a high level overview of what i need to do in order to view these custom pages on my local web browser. I cant seem to get the custom web page to access the database. Could it be a port issue since I can't use port 80. How can i get the web page to look at port 591 to access the database? Dom

I hope this is just a syntax error, but I am using Lasso's File_Stream tag to deliver PDF files and have a problem with the -Name part: Text before a field works: [File_Stream: -File=( Field: 'filestream' ), -Name=( 'randomtext ' + Field: 'Title' ), -Type='application/pdf'] and gives eg. "randomtext documentone" as the filename But what I want is some text after the field: [File_Stream: -File=( Field: 'filestream' ), -Name=( Field: 'Title' + '.pdf' ), -Type='application/pdf'] This returns an error rather than giving eg 'documentone.pdf' as the filename. This is the error returned: Error Message: No tag, type or constant was defined under the name …

Hello: I have a FM 5 web hosted database with a FM 5 Server backend. Sometimes the webserver will not serve out the pages and the files need to be re-opened manually. Is there a way to automate the opening of these files or is this a limitation with FM 5? I was thinking of maybe a 3rd party plugin that would open up the necessary host files. Dom

Is there any way to attach or upload a word document via a web hosted file? Thanks in advance?

Hello I would like to sell some files I developed online. I would like to have a website that keeps track of about 200 files. I would like the user to be able to pay for the file by paypal and then download it. What is the best way to go about doing this. and the simplest. I am on a Macintosh Tiger Thanks Dave

I have 2 servers: Server A is a Mac G4 (OS 9, 512 RAM) running FMP Server 5.0 and Server B is a Mac G4 (OS 9, 768 RAM) INTRANET webserver running FMP 5 with the Web Companion Plug in. At least thats all I can see on both machines. General questions: (1) Can I assume that "Web Server Connector" will NOT run on OS 9. If it can how can I tell if it is in fact running on the webserver machine? I tried running http://IP address/Fmpro?config but got nothing so I'm assuming its not on the machine but I'm thinking its an OS issue since I'm assuming WSC will not run on OS9. (2) Is there a way to tell if FMP UNLIMITED is installed on my webserver machine? Again, if W…

In FileMaker 6 the use of -lop in CWP was limited to "AND" or "OR" but not both. I read in a forum topic on this site that FM 7 carried this limitation as well. Does anyone know if FM 8 has changed this option so I can accomplish this query? Simplistically, I am trying to query FileMaker for "(A OR AND C." Thanks.

Does anyone here have suggestions of which company is good for hosting a FileMaker based web site? I've been working on a custom web publishing solution, and need to find a place to host it. I've looked around, but each of the places I've found doesn't seem to offer much in the way of space. The database to be hosted is going to have only a modest number of records, but many of the records (a few thousand) will be 1024x768 images uploaded by the user. I figure I'm going to need at least 2-3 GB of space, and perhaps more, but all of the plans I've seen offer less than 1 GB for their most expensive plan. I also prefer that the files be hosted on Mac OS X, but that…

I've been trying to wrap my mind around a way to serve a variety of information to different audiences based on their status, and figure it must be a common procedure, so someone out there has it figured out. If so, I'd love to know how best to give different groups access to different records. Here's what I want to do: In our school's calendar database some events are primarily for staff, some are for staff & students (basically, the school community) and some are for everyone (general public, staff & students). Currently, when the records are created they're coded in the "audience" field as "staff", "students", or "general". However, when searching for staf…

This is yet another issue with using FMP7 Adv and Custom Web Publishing. Scenario: I have two DB

hello folks, I've published a large solution using FMP7SA along with FMP8 Server on an XServeG5. My clients use IE 6.x windows XP SP2. The problem I am seeing is that at times IE displays 10 records of data but shifts lines horizontally so that they overlap. Not user interaction solves this problem. They log back in and everything works fine. Only 2 or 3 users of 50 seem affected and the 2 or 3 can be any of the 50. Has anyone else seen a situation where IE displays the data screwy for no apparent reason. I can't even recreate this even if I try... Cheers.

Is it possible to pull text data from a website into FileMaker. If so, how would you go about doing it? I've never done this before so I am quite new to the idea.

Hi all, I have a simple log-on page that I want to add a password to or just use a canned log-on/password routine. Martin Brandle gave me his routine a while back but I have managed to misplace it. I would like to have a cookie function to simplify log-on's for returning users. We have about 1600 users with user-names already established in the database. If anyone is aware of a canned package that would integrate easily please let me know.........Thanks, Ray

I'm looking into using CWP for event registrations, but it must stand up to several hundred hits in an hour. Can anyone advise? Our email invitations go out to several hundred people simultaneously, and many respond quickly. Till now, we used a MySQL database online and downloaded the data into our office FileMaker DB after all the registrations had come in. I'm the FileMaker guy; another team did the web side and I know little about it. Now, we wonder if it makes more sense to have registrants interact directly with a FileMaker DB using CWP. We would use a commercial service to host the FileMaker DB. Because our clients are demanding, we can't…

hi, i develop filemaker and i ned to put some forms online to users to fill they do note see any data in database, do not browse or find records, just fill the form i have filemaker advanced server and i want publish with a custom html page, not instant web publishing. my experience with html and others web languages is little, if anyone know somme simple tutorial or help i appreciate tks sorry my english

A basic question. I want to publish a modified "Faculty Staff" template to a customers website so they can enter new staff members and allow it to be searchable. This is all a bit confusing, but does the external ISP that I use (a Windows 2003 server) need to have Filemaker Server running? Or can I simply save the files somehow to put them in a folder on the site? Also, please point me in the right direction if I can do it without the Sever version. The instructions are confusing, and I appreciate the help. Thanks!

Dear List Members, Instant Web Publishing and Custom Web Publishing sound great. But can FileMaker be seriously used as a content management system for a content website with text and images and tables mingled (text runs around the image or table) on any given webpage? Can an image (say stored in a container field) be positioned anywhere on the webpage at a specified scale (say the image stored in the container field has a size of 500x500 pixels, but I want it to be displayed as a size of 100x75 pixels)? Can all these be accomplished in FileMaker in conjunction with XSLT or PHP? I really appreciate your guidance on these.

Any one using fx forge? Does fx forge create the link between the web page and the db? Is it easy to use and learn? thanks in advacne.

I am completely mystified. I would like to set up a website/page that collects information into an online database (sql?) that then integrates or downloads this collected info into FMP6. I see info on plugins, odbc, etc., but am stuck trying to understand this. Can anyone help? Thanks

Is it possible to change the port number that FM serves web pages on? My port 80 is in use and I'd rather change FM than Apache if possible. David

Hi all, I have a client who has an old version of FileMaker (4 I think) They want to publish a simple database up to the web but don't want to use Instant publishing. Time to dig the old copy of Claris Home Page I thought! I found the CD and license key but the CD is badly scratched and will not install. I have trawled through the Internet for a few days now and cannot find Claris Home Page 3.0 anywhere! Can anyone give me a pointer? Many thanks

Was just at a customer site doing some changes to the a Web Form layout I created. After some time, when I went to localhost to see view the layout, it started showing me the Main Form layout. I'ave double checked that the Web Companion Form View has "Web Form" layour selected and not "Main Form". However, Main Form keeps being published. I have cleared cache and restarted FM (v6) and web browsers but still shows the wrong layout online. Is there something I'm missing? David

I'm looking for a way to format an editable new record reply page to make sure that the user edits made there conform to the contents in each database field. Here's what I mean: When users make a new record online in a calendar database, several fields use drop down value lists to constrain their responses. For example, there are three schools in our district, and users can select one of them as the location for a school activity. When users submit an event to the db, they get an editable record_reply form, including their posted choices, returned as text fields filled with [FMP-FIELD] contents. Now, if they want to change one of their field replies, they are f…

Good Day All - We access a listing service who uses FileMaker Pro. We use Mac's and Win XP PCs. Some of our Mac's have a major problem accessing the website. All XP PCs work fine and most of our Mac's work fine, but a few will not load properly. We've tried Safari and Internet Explorer...same problem. Is there something we are missing? Is there a File Association, Extension, or plug-in we should be using??? ANY help would be greatly appreciated. Thx, Acktom

Hello when i see in the publishing engine the number of user online always is the same number, an there is no user connected to the database??, Can I logout user automatically?? Thank you very much??

Can I see the number of user connected online to my database??

I have a field that refuses to appear in a record_detail page, and can't figure out why. The field is in the same database and layout as 5 or 6 others on the same detail page that show perfectly. They're all called by a [FMP-Portal] command. Any ideas how/why that one field doesn't want to show in my detail page? I'm stumped. Thanks for any insight.

First the set up: On Windows 2000, we are running Filemaker Server 5.5 and Filemaker Pro 5.0 as the web client (separate machines). In recent days, the Filemaker Pro client has been maximizing CPU usage and refusing any additional work. Twice I had to restart the client machine with the hardware switch. I could get Task Manager up and see the CPU usage, but could not end the FM task using Task Manager and could not get the PC to restart from the start menu. We moved the client to a newer machine and the CPU problem recurred, but I could at least kill the task and restart FM. Does anyone have any advice about how to track down the source of the problem? …

First off, I am using Filemaker Server 5.5 for my server machine, and Filemaker Unlimited 5.5 for my client which is running on a G4 w/ Panther. I am having huge problem with Filemaker crashing at strange times. It will happen when the databases are performing finds, and when they are adding records, but I cannot figure out the exact problem. I have been told to move my client machine to a PC and this could fix the problem, that Macs are unstable for Client machines. Does anyone know anything about this or have had similar problems? Also, what is the best way to find out the problem? I really want to keep using FM because it is so wonderful, but I am tempted to swit…

Hi guys, Trying to properly display information....A user fills in the form by checking radio buttons and a menu where you hold down cntrl to select multiples. After submission, they can pull it back up to edit their information, but none of the radio buttons are checked, nor are the menu items highlighted. I know there must be a way to fix this! but what is it??? Thanks!

I use FM6 and CDML for my publishing. I am thinking on moving to FM7 or FM8, but I understand that CDML is not supported. I use CDML to make quite a few text files: files not to be seen by a web browser. Is there a way in FM7/8 to create text files when there is a web request? I understand that XML sends 2 files, but most of my clients are not using a web browser, let alone something that can actually handle XML. (For examples, I send a tab separated file to Excel) Can I just send HTML with FM Data? Or is the only customizing option for web pages with XML? Thanks (Regardless of what it says to the left, I am not using MAC OS9, I am using XP. I cha…

I have a Windows 2003 server running FMSA 7, IIS 6.0 and PHP. All of the PHP scripts can access and manipulate the database as expected. However when I try to pull xml from the server I get an 802 error code "Unable to Open File". Also when I look at the web admin console, the database file does not show up as being published by the server. Here are some of the parameters I have set: - File opens using Guest account - Guest account has fmxml set as an extended privilege - XML publishing is enabled in the web admin console - XSLT publishing is also enabled inthe web admin console - Database file has been given full access rights for the IUSR_SERVER user n…

Hi all, Is it possible in FM6 using CDML to create a HTML results page that goes across the page as well as down. So example would be :- ----------------------------- record1 | record2 | record3 ----------------------------- record4 | record5 | record6 ----------------------------- etc, etc. Just listing the records one after the other in a list is easy, just wanted to know if I could achieve the above as an alternative. Many thanks, Zenoah

Sorry if this has been answered before. I'm new to this forum and to FM. I am considering buying either FM7 or FM8 and would like to know the difference, if any, in how they perform over the Internet. I won't need Server 7 or 8 because I'll have the eventual database hosted. Are there the same number of script steps or more that can be used over the web in 7 or 8? Can I create Excel files for reports over the web and then email them to myself or others? Is there any difference between 7 and 8 in the look of layouts as seen in a browser? Are there any other differences I should know about? Pat

Hi everybody. I have just been asked to help out my Dad (who knows a lot about Filemaker, but nothing about web/other development) by making a webpage which will have a form to enter user data before downloading a piece of trial software. All the form needs to do is send the data (name, email etc.) to FMPro, and make a new record in my database with said information. I will set up the page on Apache, and put the web companion on another port on the same server. I am thinking that I will create a layout with a copy of all the user data fields as global fields, then I will use a script to create a new record, copying all of the global fields data into the new rec…

Hello there, I have perused this section of the forum for answers to my ever-growing questions and just wanted to clarify some information and perhaps ask some additional questions regarding web forms. What I want essentially is an FM based web form on our web page that allows a user to enter their personal information in order to request a brochure. The information would be automatically entered into the database. Currently the person enters their information on a web form which sends an email to me, and I copy & paste the information into the database and discard the email. I understand this is possible using IWP (which I don't really have any k…

Hi all, Another problem I'm having atm is making a search form bring back specific records. I have several fields that have numbers in the data for insance - '100 things', "1000 things", etc. I've made a form that alows the searching of records using the field data above. Problem is if you type in '100 things' it finds both 100 & 1000 entries. Is there anyway of making the search more specific and only return the '100..' entries? I've tried -op but that doen't seem to help. Thanks, Zenoah

I created a database for tracking PC inventory and trouble tickets last summer. It took a fair amount of help from users here to get the web portion going and now I've been away from it that I'm not even sure where to start looking on this issue. at http://helpdesk.chesaningschools.net/FMPro?-db=Helpdesk.fp5&-format=helpdesk.html&-lay=Technicians%20View&-view (password is support) I've got a form that brings up a room list based on the building selected. That list should come from a filemaker database called room. I've attached all of the related files. If someone could help me get this resolved I would greatly appreciate it. Thanks, Brad …

Hi all, I've created a form in HTML that allows searching of a filemaker db I'm devolping. When I enter text and click the submit button the results come back as I expect. When I enter text and hit return though it doesn't find any records. I presumed that return on the keyboard would just submit the form, seen many sites that you can do this on so guessing i'm just missing something. Any ideas? Thx, Zenoah

Hello, I need to get data in (from a fm db) and out (to a fm db) a mysql database on a remote server. FtpIt would be an option,uploading mysql instructions (created with calculation fields) on text files where the server picks them up (php instructions)or the mysql creates text files using php that are picked up by the fm db using ftp-it or is there another way? Anybody ever had the need to work with a mysql datase on a remote server? Please give me advice (and no, I can't change the remote database to filemaker -) ) Thank you for reading and eventually answering my question.

I'm currently trying to show a client how to use Filemaker Pro 7 databases remotely. I've set it up on my pc, created a new database with a few entries in it and published it to the web and it all works fine as it should. On my clients pc however, after publishing to the web, we tried accessing the webpage from a remote computer. It came up with the first screen that lets you select the database/file you want to view so we clicked it. Then the page starts to load and eventually shows us, well, nothing. It has the left and righthand frames and some graphics, but nothing we can make out. No text, no symbols, nothing. His host has a slow internet connection (a…

Hello, I am having problems viewing portals through IWP. I can see the portal, but I can not see the data in the protal. All files that are linked are shared and can be acccessed through IWP. I use FM Server to share, and chance it could be a set up thing? I am using IE 6.0.2. It works great just using pro. I have run in to this on more thne one file. O' yeah I also tried this on other machines, and I have the same problem. Any help trouble shooting this would be great. Thanks!!!

Hi all, Pretty sure I've posted this before but I can't find the post so I'll try again. Using FM6 & CDML I want to be able to have page number navigation on the results page of a set of records. So if the result brought back 50 records for example at the bottom of the page there would be a line similar to: - [Prev] 1 - 2 - 3 - 4 [Next] The Prev & Next would just take u to the next/prev set of 10, no prob with that. Bit I cant work out is i want the 1,2,3,4 text to have hyperlinks that would send you to that section. So clicking on 3 would bring up records 20-29 for example. Anyone know of how I could accomplish this? Example code if …

I have been trying to include a JavaScript Function call in the following HREF without success, any suggestions would be greatly appreciated. >event_added.xsl?-db=Web_TA_Pre_Reg_DB&-lay=Registration Evaluation Form-2&-token.participantid= select="$request-query/fmq:query/fmq:parameter[@name= '-token.participantid']"/> &-token.fullname= select="$request-query/fmq:query/fmq:parameter[@name= '-token.fullname']"/> &-token.status= select="$request-query/fmq:query/fmq:parameter[@name= '-token.status']"/> &-token.p…

It seems that there are lot of talks about using Filemaker for web shopping carts. But there is only one filemaker shopping cart in the market : CH Ching. Well, Ch Ching is not really 100% filemaker - it's Lasso based. And costs a hell! Has anyone made a Pure Filemaker based shopping cart? The knitting factory example that comes with filemaker is really dumb. Has anyone tried to build one and then given up because it's unachievable + nonsecure? What sort of hardles did you face? Very interested to hear your thoughts!

I'm working on my first FM web-enabled project and want to keep it VERY simple. The task is to allow individuals to register for our company events directly into a FM database. We currently have a consulting company that maintains our web site and has a page where registrants enter their info and an email is sent to us. We then have to manually update our FM files. We want to automate this. Can I use IWP with FM7 Server Advanced with MS IIS as the web server (Windows platform)? Or do I need to do Custom Web publishing? Can you call a FM web page from a HTML web page? It is very confusing as to the approach to take for this first project. If I have to…

search field is left blank. I have a form the user enters their "USER ID" into and then clicks Log-In to search for their data. Using CDML, Garry Claridge said to Use "==" for the operator to avoid a problem getting an incorrect record when the user left the field blank. This worked fine. Now under XSLT (and Filemaker 7) this does not work, when the user leaves the field blank the first record of the database is returned. Here is the form I am currently using. ================================================= verify_data.xsl User…

I'm looking into using FMPro for the companies Purchase Request system and I like the demo of FMP7. I would like to know how I can trigger the printer properties via a script I did. From the client it works fine but when I click on the print script via the web nothing happens. Is there such a way for this? I would like people to use adobe signature on the PR's because sadly some paperwork needs to be created. Thanks, Lostboy "Need to be found"

is it possible to display more than five records at a time in list view on iwp

I seem to have a problem to get my valuelists from the db to my webinterface. I've used the following code in my html pages choose [FMP-option: field1, list=list1] I've copied this from a working solution and adapted it to my fields and lists. I've tried the help function on this forum and i've tried google but can't find the solution... A simple version of the db and html pages can be found here I use filemaker pro 6 and panther. Thanks

I have a feeling I know the answer, but does anyone know of a function that will change everything in a field to upper case? In other words I have a field in the database that has information in it that is not uppercase. When I call that field on the web I would like to display all the information in that field in uppercase. Can this be done? Thanks, Nick

Hello, [ INTRODUCTION ] We use Filemaker 6 Unlimeted to show our products online Using CDML tags. Now I want Google to index my FMP database, but there are "&" and "=" punctuation marks used in the hyperlink, [see below], but the googlebot does not index pages using the punctuation marks mentioned above. [ EXAMPLE HYPERLINK ] [http://]databases.sj-solutions.nl/STORE/FMPro?-DB=producten SJS.fp5&-lay=WEB&-format=Results.htm& Prijzenlijst_sjsolutions::productnaam=xwall&-max=1&-Find or visit our website: SJ-Solutions B.V. to find out! [ QUESTION ] Is there anybody who can help me to change my CMDL hyperlinks to hyperli…

Hello, I'd like to insert a multimedia field in a portal (My files are made with html / cdml). It works with text and number fields. Is there someting special to do with pictures ? Thanks Max

I think I'm missing something simple here. I'm trying to identify if a user logs in via a desktop or the Internet so I can direct them to the appropriate layout via a login script. I would swear there is a function for this but can't find it!!! Any help? Thanks in advance.

Hello all Is there anywhere on the web, a list of the limitations that exist when using IWP. Specifically a list that tells what features within Filemaker that will not work when using IWP, such as Conditional Value Lists, etc. Rather than searching throughout the Forums for the info, or trial-and-error attempts? Thanks to all for your help (this is a great place for info!).

I work for a small company. We are currently using FMP 5 for all our records - ie client and customer databases, archives, product listings etc. Thing is, we're looking at upgrading to version 7, and at the same time building a new website capable of serving some of the information in the databases to internet users. I was looking at the custom web publishing features of the Web Companion in FMP 5, as I'm not foreseeing vvery much traffic, but I see that this functionality has been removed from all versions of FMP 7 except server advanced. So I need some advice. We're looking at running the database off a dedicated server. Now, what would be the best way t…

i have a script that works perfectly in the program, and it is made completely of web compatible scripts but it doesn't work online...why not?

hi, so, can you get ASP and filemaker to talk to each other in pro 6 or pro 7? seems to be a lot of topics about other web programming languages, but i couldn't see much on ASP. any tips would be appreciated, jd.

Dear FM Geeks. Please could you help me with the best way forward to the following CDML Html questions. Some history, database1 displays a related field (through User ID relationship)from database2 in a html file. 1) I want o be to able to edit a related record in database2 from database1. through User ID relationship. 2) How do I just view the related record in database2 from database1, through relationship user ID. 3) How can I created a related record to database2 from database1, through relationship user ID. I do have some experience of using CDML, but I want to hear other opinions. Please submit some example code. I am very greatf…

Hi, Is it a known issue that when trying to calculate a related field (or a calculation with a related field) with javascript, then it is not working? any workarounds? why it is not working?

when i publish to the web under developer i solved all the problems i had before of geting the default web layouts...but developer did improve on that and put a side panel....unforunatly my supervisor doesn't like that either anyway to get rid of it...and not just hide it?

Hi, I have a FileMaker database published with XSLT. When users access it on the web, it asks for username and password - as it is supposed to do. However, every time they browse pages or refresh, it asks for a password again and again and it becomes very annoying..(( They mostly use IE 6. Any help is very appreciated! Thank you

in my handy fmp developer 7 i created a search layout that returns the results in another layout as a list view...it works great except when viewed in a browser after you do the search moves the list up so that hte field you edit is the top most field pushing any others up out of view...email me at [email protected] if you understand my problem or would like to help but don't uderstand

Hello! I have a webpage that talked with Filemaker 6 with webcompanion before. Now we have gone to Filemaker 7 and it

ok my script, button, and layout problem have been solved....sorta....everything works great and dandy when logged in under admin...and if that is the only active account...but when i add guests..and such...nothing works anymore...wtf? any answers?

when you share outa database on the web it makes you choose a view such as the soft grey or fern green, what if i don't want any of them and i want my database to show up as is, with all the buttons i put in and all the scripts working?

ok this is my deal, i'm 17 and have been working at a company that designs and manufactures roofs for subdivisions in the Virginia, DC, and Maryland area for a year now. i used to be a designer but due to school i didn't get to work to much, i am graduated now and workin here full time and going to college, and i thought i was going to do more desgining but...about 2 1/2 weeks ago my boss came to me with FMpro 5 and a manual. i had to create a data base to track shop workers hours, it took me those 2 1/2 weeks to get the program and make the amazing data base that i have, but i can't publish it on the web. i used the manual, didn't work, i looked on the FM website for hel…

I did a search and the problems did not seem to be the same. I use FM7 - one copy runs on a dedicated server with 3 users max - 2 computers access the database on a local network and one accesses the database remotely. I have 5 licenses and sometimes use one on a portable. My remote user has a satellite connection with a 1500 ms ping time, but that does not seem to be a problem. Sometimes when she tries to log on she gets: "The maximum number of licensed users are currently using this copy of FileMaker Pro. Please refer to the license key section of your software documentation for further instructions. License key conflict occurred with user herma…

Hi Sometimes the admin need to run some scripts from the console (FMP6 U!). This caused some problems beacause of simultaniously runing a local script and a web request, and it got really messy..... Is there way in FMP script steps to block/unblock web requests?? (I use FMP6 U! as a web server and a host) Tnx

I have a 6-file database that was converted to FMP-7 without merging the files. I use the Web Publishing Engine on a Mac G5 and Filemaker Server on another Mac G5. My web pages are turning 10 to 15 times slower than they were under FMP-6 using CDML. Does anyone have any thoughts on improving the speed? I have searched the forum archives for similar questions regarding this problem and was unable to locate any discussions. Thanks, roadrunner(Ray)

Hi - I'm getting to grips with FMSA custom web publishing and have a question regarding the conversion of a input date field on a form, from dd/MM/yyyy, to the standard "fm" format of MM/dd/yyyy. I've researched enough to realise this should be done client side with JavaScript but my javascript skills aren't that advanced. Does anyone know how to achieve this? So far I figure that the date field submitted to the database (Booking Date in MM/dd/yyyy format), should be a hidden input field on the form. Then on submitting the form, the field the user completed, tempDate (in dd/MM/yyyy format) should be converted using javascript to MM/dd/yyyy and copied to the Booking D…

I have 2 questions. 1. I have a client who asked if it was OK for his database person to develop a database in FileMaker Pro 5 and then have me put it on the web for him. Users would query, add to and update this database. I know Access, but nothing about FileMaker. What are some pros and cons in using FileMaker vs Access? 2. Does anyone know the ODBC connection for FileMaker? I'm getting the following error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed for this code: Set conntemp = server.CreateObject("adodb.Connection") conntemp.Open "DRIVER={FileMaker Pro}; DBQ=e:webfpdb…

Hi all, I'm trying to create a results page that instead of having the standard 'showing records 1 through 10 of 100 records found' to instead show page numbers. E.g - Page 1 of 10 -- Jump to page [1] [2] [3] Page numbers in the [ ]s would be hyperlinks to that section of the find request. I see this system being used in most forums, etc and would like to accomplish the same type of thing in FM6 using CDML. Any thoughts? Thx, Zenoah

Hello all, First, a background: We have been using FileMaker Server 5.5 on Mac OS 10.2 for several years, connecting to our web server via a Windows XP machine running FileMaker Pro 5.5. The web server is running Lasso Professional 5, connecting to the databases via the web companion box. We have recently begun a new project with a new set of servers. We have a Mac OS 10.3 server running FileMaker Server 7, which we would like to connect to another web server running Lasso 7. However, things appear to have changed. We had previously used the Web Companion feature in the FileMaker Pro 5.5 machine; in FileMaker 7, this option appears to have disappeared. …

Hi there. I am looking for a way that I can have online forms that submit straight to my database. I was told about CDML in FM6, and XML in FM7, but am not sure which one to use. Thanks

Hi Using FMSA on Windows Server 2003. returns within a textarea form field via IWP or XSL or PHP result in a rectangle box at the end of each line when viewed via filemaker client. I have looked through many posts and have found a couple of people have had the same type of problem but I have not seen a solution. I first thought this was only an XSL problem so I asked there and Martin was kind enough to make a couple of suggestions but now it looks like a more global problem for me. thanks! steven durow

I've got a web page that shows found records, but for some reason it only shows the first 25. I don't have the -max command set, so I'm confused about by its restricting the records shown to 25.

Hello I work for a small charity and we manage our website (ww.wrc.org.uk) in-house. It gets updated each week and currently takes 6 or so hours to do. This time is mostly spent entering event details into various tables on different pages. It's a really inefficient way of doing things and as we have filemaker in the office, I thought I'd try to look into using it to speed things up. What I reckon is, we have an events database in the office. In it we store the details for a variety of events we and our members are running. It's a useful tool for the office to see what's happening when, but I'd also like it to 'feed' the website. That's just one example. We also h…

Hello, I have a database online and I'm kind of stuck on a user name issue.I have created a custom login layout that works fine. When the user logs in the user name is a global field. What I'm trying to do is match the current user name to a record in a different table. Example: Table 1 is an order form. Table 2 is client information. When user "Bobby10125" logs in, I want him to be recognised by his client information in table 2. In table 2 the record would have the client code (10125) and information for that account. When "Bobby10125" logs in to table 1, I want it to match the global user name with the appropriate account, and display order information …

I have a project coming up soon where I will need to write a FileMaker database which will be accessed exclusively via a browser, both locally and on the web. I've done quite a bit of FileMaker development but none on the web. I understand that Instant Web publishing is not the way to go...as I'm going to want to design the look and feel somewhat myself and I'll need more control than it allows. To my point...I need resources on learning more about publishing FM7 databases on the web. Can anyone suggest books, web sites, tutorials, sample code, anything that I can use to guide me through this process? I've looked at a few books about FileMaker 7, but I fear they focu…

I am new to Filemaker and have inherited a single table db which is published via the web companion and uses a single search page built using HomePage 3.0. The database holds information on accommodation for students such as location, size, smoker - non-smoker preferred etc. The problem I have is that users can only do OR searches in the form therefore if they choose a room for a non-smoker in a particular area it pulls back all non-smoker rooms and also all rooms in said area. I need to do an AND search but changing the -LOP value in the search page to AND results in no records being found. The search page uses dropdowns and checkboxes built on value-lists and so I…

We have Filemaker Server 7 installed on one machine (a PC Win 2003 Server) and Lasso 8.0.5 and the Filemaker Web Publishing engine installed on Mac, OS X 10.4. Everything was working fine after the installation. The databases where showing in the Filemaker Admin console and also in the Lasso Site Admin. Then a few hours later suddenly all the databases are "Not Available" in the Lasso Web Admin and the error message is "FILEMAKER_CONNECTOR error 9 after select()2/timeout os msg Bad file descriptor". We can still see the databases in the Filemaker Admin console. The machines has not been upgraded and there is nothing wrong with the databases. What could possibly cause…

I have a runtime which I've distributed on CD. Works like a charm. Now I need to be able to "webify" my solution. I spent many months creating the runtime and want to maintain the look and feel; each layout has its own jpeg background, there are some pretty intricate relationships and some serious scripting as well. Can anyone speak to pros and cons and possible pitfalls I might encounter were I to move forward with FMP? Or would I be better of migrating to another DB (possibly MySQL with a PHP front end, or something similar)? Thanks for any help!

I'm new to this and seem to be missing some crucial step. When trying to use Site Assistant to generate the XSL files I'm unable to access the layouts in the pulldown options. The code still generates, and home.xsl works fine, and can be viewed at the URL given by site assistant. Clicking on any of the link on home.xsl, however, generates a variety of errors (listed below). The .fp7 file I'm testing has three records, two fields, all text, one layout. I first tried testing a more complicated file and got the same problem and results. Would greatly appreciate if anyone could tell me what option I neglected to enable. Show All Records & View R…

I have FM Developer 6 installed on our web server. My web pages (CDML & HTML)are in the "web" folder and I have my online database in another folder. The main page is a search page. After results are displayed, a specific record can be selected which then retrieves/displays the detail page for 1 record. URL to search page: http://www.herdease.net:591/FMPro?-db=Co...h.htm&-view I have a few questions: 1. What is the 10 IP limitation (is that simultaneous access?), and how can I expand that? 2. Can I create a field in the database, (ie. "Hits"), that can be automatically updated/incremented when that detail record is displayed (selecte…

Is there a way to create a database that can have people access online to use it as a sign up tool for courses. So that the database would track how many people signed up in real time? FKSStechguy

I have done a straignt conversion of my 6-file database to FMP 7.0 and am having problems displaying passed token data on my web pages. (this problem did not exist in FMP 6.0) I need to know the best way to handle tokens that are passed onto and displayed in a number of subsequent web pages. I have used "fmxslt:url_decode" successfully in displaying tokens on the FIRST page after their creation, but on subsequent pages this does not work. The token data I use in newly created records does not appear to be a problem even 3 or 4 pages downstream from where the token was created. Any assistance will be greatly appreciated.......roadrunner(Ray)

We're in the process of upgrading our web-enabled (via Lasso) FMP databases from FMP Unlimited to FMP Server 7 Advanced and have hit a real problem with PDF generation. In the old system, the web client user would click a button which triggered a script that printed the current record to a PDF, which SMTPit then emailed to the user. SMTPit isn't currently FMS7A compatible, but I figure Lasso can handle the emailing chores. However, I'm puzzled how to take care of the PDF generation step, now that we no longer have the flexibility of interacting with the FMP Unlimited client. FMS7A is running on Mac OS X 10.3.9 and Lasso 8 is running on OS X 10.4.1. Any sugge…

Hi there. I am looking for a way to put some databases online so people can input info into them and it comes back to me. I do not want to use instant web publishing since I dont have a server. Any good methods anybody can sugest? Thanks

I have project to upgrade from 5.5 to 7 including FM Server 7. I think that will be fairly easy but wonder if there are any specific issues I should know about before taking this on? Maybe more importantly, I need to get info created on our website in MYSQL during a registration process to dynamically cooperate with FM; ie., is there a way to automate FM such that when the info is entered on the website it will be entered into the "Customer" DB? Also, out there in dream land, is there a way to get the data created in MAS 90 to cooperate with FM 7? Is there other information needed to answer these question? Are there scripts or plugings, etc.?

Hi all, I have spent a lot fo time reading posts and they have been very help full, but I have been unable to find an answer for my latest problem.. So if anyone can help I would be very greatfull. I have a database of books online, giving details of each book etc, and a buy now link to an external shop site. Some of the books in the database are not as yet in print, so I don't want a user to be able to click on the link to buy them. I have been trying achieve this by using an If/ else statement with the current date and the date field I have in the database (the date field is when the book comes into print ie in the future), but I have been unable to get it to …

Can I run online my filemaker pro 7 database with only Filemaker Server 7 installed (without FM Pro 7 and FMSA 7) and using ODBC/JDBC and PHP or JavaScript? And I need many connections (not 5) and good desogn (not like Instant Web Publishing) I need it working with MAC.

Ok I have a database called company which stores information about the companies we deal with. I already have certain sections of our database shared onto the internet, but not this company information file. The way I've always done this is to use the PHP include() function... include("http://web.domain.org:591/FMPro?-DB..."); I use the web security db, and I have filemaker unlimited 5 (not 5.5 or 6) running on a windows box. In the web security db this database has browse permissions. Could someone download all my data? I've written CDML code in all my format files so that only the IP address of the php server performing the include can…