
carsarecoffins
Members-
Posts
22 -
Joined
-
Last visited
Everything posted by carsarecoffins
-
Thanks. I didn't realize there were hard stop limits for the layouts. I know this is kind of a goofy exercise but I thought I would try it.
-
I have a layout that I want to extend several fields on and then slide them upward when necessary but it appears that I have reached the maximum possible length of a layout or at least the body part. I have stretched the total layout to 111 inches (all but 1/4 inch of which is the body) and I cannot stretch it any further. Has anyone else encountered this and if so any ideas about how to deal with it? Thanks in advance.
-
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 name Is there something I am missing and/or is there a test I could try? As an aside I have a testing server with the same configuration (they were set up at the same time) as the one I am troubleshooting and I cannot duplicate the problem.
-
I am trying to open a Microsoft Excel Template on our server using a script. The script sorts the records and exports them to a .mer file. The scrip then uses the send message step to open a Microsoft Excel template, which contains a macro to import the data from the .mer file. If I run FileMaker on my machine with the template and .mer file also local the script works beautifully. However when I place the files on our server the script does not find the template file. If I change the send message step from either machine on the network the script will find the file from only that machine (as expected). I have also tried the open URL step with a slightly different result. It finds the file (I know this because I have a show message step at the end that executes) but does not open the file either on the client machine or on the server.
-
Is FileMaker Pro 6 compatible with FMP Server 5.0?
carsarecoffins replied to Dorie's topic in FileMaker Server 11
Even if you load the plug-in from the server 5 CD in my experience the plug-in is not available to FMP 6. Following the same process of loading the plug-in using FMP 5.5 it works just fine. I also have not found a solution to this. Based on previous posts it has been an unanswered issued before. -
Server 5.5 and web companion
carsarecoffins replied to carsarecoffins's topic in FileMaker Server 11
Thanks for the response. I am working on the two machine setup at this very moment. -
I currently have server 5.5 hosting about 14 files. i would like to set up the ability to access these files from both a web browser (i.e. php) and FMP client machines. I understand from previous posts that server "hates" multiple IP addresses so are there any suggestions for possibly using multiple machines? Hopefully this post is clear enough.
-
Calc for finding the number of numbers
carsarecoffins replied to carsarecoffins's topic in Calculation Engine (Define Fields)
I agree about the Status(CurrentFileName) method, much more stupid resistant. Now I am trying to figure out how to make this calc work with only a found set. -
Calc for finding the number of numbers
carsarecoffins replied to carsarecoffins's topic in Calculation Engine (Define Fields)
Thanks! It can be awful dark where my head is sometimes. -
Calc for finding the number of numbers
carsarecoffins replied to carsarecoffins's topic in Calculation Engine (Define Fields)
I get the idea behind making a value list and counting the number of items in it, but I can't get it to work. I have attached a file showing how I set it up maybe you can tell me what I'm doing wrong. num_of_num Test.zip -
I have a Work Orders file that contains an order_no field and rev_no field. I want to find the number of numbers in the order_no field. For example, I could have: order_no 1234 rev_no 01 order_no 1234 rev_no 02 order_no 1234 rev_no 03 order_no 5678 rev_no 01 order_no 4321 rev_no 01 order_no 4321 rev_no 02 and I would want the result to be 3. So what I want to know is the number of groups of the same number. Sorry if this is confusing but I didn't know quite how to ask the question.
-
I have recently started working with PHP and FX.php to extract data from FileMaker. I have been looking at the sample files that come with FX and they seem to exhibit a strange search behavior. The FMP file is set up as a list of books with author, title etc. The sample index page has a small search form with the author and title fields available for search. If I put either a lowercase or uppercase b In the author field the one record that contains a b in the author field is returned. However when I put a k in the title field the record with FileMaker in the title does not come up, what does come up though are some records I added with random characters in the title field including k. Is there some thing I am missing?
-
Trouble acessing FMP through a reverse proxy
carsarecoffins replied to carsarecoffins's topic in Custom Web Publishing
I agree that our network support group needs a little motivational boost especially if IIS is no different than IWP. As for functionality on the LAN I have not had any problem at all, in fact I have even accessed all of the pages in the site from work using my home computer as a server. I do not know the port number but I will find out. P.S. If IIS is no different than FM for basic web serving then why would he recommend using it instead? (Because that is what he is familiar with?) Justin -
I am currently using filemaker pro 5.5 to publish about 5 db files through custom CDML/HTML pages. I would like to publish these pages outside our firewall and our network admin suggested using a reverse proxy which he set up but unfortunately it does not work. When I try to gain access I only get back a blank page. When I look at the source of the page it seems to contain the following errors: err200: "OKrrNo Error.", err400: "Bad RequestrrThe server could not process your request due to a syntax error.", err403A: "ForbiddenrrYou do not have authorization to access this server.", err403B: "User Limit ExceededrrThe maximum number of licensed users are connected. Try again later.", err404: "Not FoundrrThe requested URL "^0" was not found on this server.", err500: "Internal Server ErrorrrAn internal server error has occurred.", err501: "Not ImplementedrrThe server does not support the functionality required to fulfill this request.", err505: "HTTP Version Not SupportedrrThe server does not support the HTTP protocol version that was used in the request message." Our network guy has suggested MS-IIS server but I have no experience with such things. Any ideas as to why IWP would not work in this situation? Thanks, Justin
-
Thank you all for the help! I think I know how relationships work now and my files seem to be doing what I want. I appreciate your patience with me since I am very much a novice at this and feel like I am working WAY outside my league with this software but I guess we all have to start somewhere. Justin
-
I guess I don't understand what the relationships are for then. How do you access records in other files if you can't search for them? What I want is to search for a portion of a WO# (e.g. 0056 from the wo-0056-01C #)using a contains like operator and have all matching records come back out of, currently one but eventualy three, discrete files. Otherwise I would just have to make one file with about 65 fields. Although maybe this is what i should do, I don't know. I appreciate all the help! Justin
-
That makes sense. I see how I need relationships to the other fields as well. How does a find work in this set up? I looked at the modified files and tried to do a find for a particular record but with no success. For example if I do a find in Customer Feedback for WO# WO-0056-01C I get "No records match this request". I know this record only exists in the Work Order file. I don't think I understand how relationships work or something. Thanks for your patience. Justin
-
Yes that is exactly what I wish to do. The main field I want to search from is WO# however, I also want to show the rest of the fields from Work Order in Customer Feedback as they are set up in the feedback form layout. The reason I am not using just one file is that I hope to add at least two more files (Non-conforming components and corrective action reports) all searchable from one place by the WO# field. The WO# is entered by the user because it makes reference to documents outside our group. Hope this helps.
-
It is backwards even though I am trying to access data that is located in the Work orders file through a layout in the Customer feedback file? When I tried to create a relationship from the Work Order file I was left with no option to enter a related field in the layout of the Customer Feedback file. Sorry if I was unclear about my problem.
-
What am I doing wrong? I have two files (Work Orders/related, Customer Feedback/master) that I am using over a network with cdml/html based pages. I have tried to create a relationship between them so I can pull the data out of the Work Orders file into the Customer Feedback file with out importing. After going through the steps to create a relationship all seems fine until I try to search for data in the Work Orders file from the Customer Feedback file. Even with the exact text no records are found. Can the guru's out there helpa newbie like myself? I have attached the files. FMP Help Me.zip