Moe

Thanks for writing back. I can only get into the admin console if I restart the fmserver service. When I restart it I can get in for a while both remotely and directly on the server, but then when I come back to it later I can't get in again unless I restart the service again. Do you still think this is Java related? I am running Java Platform, Standard Edition 1.6.0. When I tried upgrading Java previously it caused other problem with the console.

I still am having a problem with the admin console and I don't believe it's the Java version. I have been able to get around it for a while by using the command line but now I need to use the PHP site assistant. Any other ideas?

It is always running, but the problem still exists. Thanks, m

There are a lot of posts about the admin console not starting on Macs, but I have the same problem on Windows. The only way I can ever get it running is to restart the FM server service. Any ideas? Thanks, Moses

That's a huge help. Thanks.

I'm using external server authentication for single sign on. If I'm logged into the domain, is there some way to bypass SSO so I can log on to an internal account? Thanks, Moses

I did what you said so I assume it is open but hidden now. So how do I get into the file so I can make changes to scripts, etc? Thanks, Moses

How can I open a database without the start up script running (the one configured under file options)? The problem is that I need to edit the database but that script automatically exits out of the file. Thanks, Moses

I ended up using some other code. Here it is if anyone's interested: [color:green]function draw_pager($url, $total_pages, $current_page, $groupSize) { $URLExtend = '&org_unit='.$_POST['org_unit'].'&department='.$_POST['department'].'&jobFamiliesCombined='.$_POST['jobFamiliesCombined'].'&examplesCombined='.$_POST['examplesCombined'].'&areas_of_education='.$_POST['areas_of_education'].'&areas_other='.$_POST['areas_other'].'&category_employment='.$_POST['category_employment'].'&-lop='.$_POST['-lop'].'&go=Find+Records&-sortfield_1='.$_POST['-sortfield_1'].'&-sortorder_1='.$_POST['-sortorder_1'].'&'; if ( $current_page <= 0 || $current_page > $total_pages ) { $current_page = 1; } if ( $current_page > 1 ) { printf( "[start] n" , 0, 1); printf( "[Prev] n" , ($current_page - 1) * $groupSize, ($current_page-1)); } for( $i = ($current_page-5); $i <= $current_page+5; $i++ ) { $skip = ($i - 1) * $groupSize; if ($i < 1) continue; if ( $i > $total_pages ) break; if ( $i != $current_page ) { printf( "%2$d n" , $skip, $i); } else { printf("%2$d n", $skip, $i); } } if ( $current_page < $total_pages ) { printf( "[Next] n", $current_page * $groupSize, ($current_page+1)); printf( "[End] n", ($total_pages - 1) * $groupSize, $total_pages); } } $groupSize = 10; $pageGroupSize = 2; $pages = ceil($searchResults['foundCount']/$groupSize); $groups = ceil($pages/$pageGroupSize); $url = 'https://domain.edu/ii/search.php'; $current_page = isset($_POST['page']) ? $_POST['page'] 1; draw_pager($url, $pages, $current_page, $groupSize) ?>[/color]

I work for an IT department that manages a large number of databases, automated reports, desktop computers, etc. They have given me the task of finding an application which will inventory all of these components. For example, we will store database information such as filename, physical location, username, password, etc. As I see it, one of the key challenges of this project is to come up with an easy way to maintain the records, and I’m thinking a Web interface would be best. Additionally, some items need to be grouped together into a system. For example, a Web application may consist of several databases as well as a server. And of course we’re going to need to create reports. Does anyone have knowledge of an existing application that will do this? Many thanks, Moses

Did you ever find the answer? I am wondering the same thing and would appreciate it if I could see the code.

I have a bunch of emplyee records in a Filemaker database here, and I 'm publishing them to the web with PHP. I need a way for people to go to the web page and import the data into their Outlook contacts. The best thing would be if they clicked a link and it was automatic -- not a manual import. Anyone know a good way? Thanks, Moe

That's working! Thanks!

They are not in a portal.

I'm new to FX.php, and everything was working great but now if I run a query on a layout that contains fields from a related table I run into trouble. Instead of returning a handy array that is easy to work with an object gets returned that conatins layer on top of layer of other objects and arrays. I don't know why it was working normally before and now I am having this problem. This is what the beginning of the returned object looks like (it's too long to print the whole thing). Help please! FX_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 => 100 [message] => FX: ExecuteQuery XML error: Invalid document end at line 2 [userinfo] => [backtrace] => Array ( [0] => Array ( [file] => C:InetpubwwwrootFXFX.php [line] => 1362 [function] => FX_Error [class] => FX_Error [object] => FX_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => ExecuteQuery XML error: Invalid document end at line 2 )

Never mind! I figured out what is going wrong: http://fmforums.com/forum/showtopic.php?tid/181214/post/225246/hl/daily+task/

I need to import a text file into filemaker daily. I am using scheduled tasks in XP to open a local filemaker database. This database runs a script when opened that opens a networked database and closes itself. When the network database opens a script runs that imports the data and then closes itself. The issue is that when the task runs the local filemaker file either does not open, or it opens once but then will not open again. When I try to open the file manually I get a message that the file is in use and cannot be opened. This is frusterating. Is there another way to go about it? Thanks, Moses

First off, thanks for your replies, but how can this be the XSLT? I'll admit that my code is convoluted, but when the problem comes and goes mysteriously, and then disappears completely when the publishing engine is restarted, how can you blame the code? It's got to be the server, right?

I realize that. It's part of the error. Sometimes that page works properly and sometimes it doesn't. It's completely random, not dependent on circumstances. I have an update on this issue. I restarted the web publishing engine and now the pages are working normally. However, I am not convinced the problem is fixed for good, and I am running a critical application. Any advice would be highly appreciated.

I am using server advanced and I am getting a variety of erratic errors. Some do not make sense. For example on a search page I get the following error in Firefox but not in IE: An unexpected error has occurred File: Line: Column: Here is an error that appears sometimes but not others in Firefox or IE: The resource http://XXX.EDU&-find could not be loaded because the content-type was invalid (MCS-605) File: start.xsl Line: 85 Column: 300 Line 85 uses the document() function. I thought the problem was occuring because I was on a dual processor server but now I have a new machine with 1 processor. What could be happening? Thanks, Moses

Never mind! I got it. Here's the change I made: //$raceGenerQuery = new FX("18.142.4.107"); $raceGenerQuery = new FX("18.142.4.107","80","FMPro7"); I hope that helps somebody. Moses

Can anyone explain this error? Warning: fsockopen() [function.fsockopen]:/ unable to connect to XX.XXX.X.XXX:591 (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ) in c:InetpubwwwrootFXFX.php on line 610 My database is published online for XSLT and XML. I was able to access the XML through the web browser. Here is my PHP code: <?php // include fx.php include_once("../FX/FX.php"); ?> Untitled Document <?php //declare an instance $raceGenerQuery = new FX("XX.XXX.X.XXX"); // Specify database and layout details $raceGenerQuery->SetDBData("raceGender", "applicants"); // Specify the parameters that you wish to pass to the database using one line like this for each field: $raceGenerQuery->AddDBParam("nameFirst", "Moses"); $raceGenerQuery->AddDBParam("nameLast", "Blumenstiel"); $raceGenerQuery->AddDBParam("nameMiddle", "Aaron"); $raceGenerQuery->AddDBParam("gender", "male"); $raceGenerQuery->AddDBParam("race", "white"); $ReturnedData = $raceGenerQuery->FMNew(); //create a new record Thanks, Moses

I recently had to publish a filemaker database to tiered list menus on web. One menu changes options on another menu, for example you choose "United States" on one menu and then another menu is populated with all the states in the US. Maybe a better name would be cascading list menus. I don't know. Anyway, it took me a while to put it all together, so I wrote an article about it and posted it on my website. I hope this will help somebody save some time: http://www.flamingvan.com/community/filemaker/menus

I found the answer. %0a works. I'm not sure why, though.

How can I enter a set of break delimited values into a field by using a query? For example, I have the following: areas_of_education=GED/High School?2 year College degree (Associates)?4 year college degree (Bachelors) I want the '?' in the above string to equal breaks so that the values show up as checks in checkboxes. Thanks, Moses