
skiss
Members-
Posts
14 -
Joined
-
Last visited
Everything posted by skiss
-
I am in layout mode when I edit my layout. I have a layout that's like this --Header --Sub-summary by error_type [error_type field] [summary field] --Footer But then I want to view the results right ? So I go to Browse mode. How do you see the results if you don't go to browse mode ? And in browse mode, I come pretty close to what I want, but I still have the duplicates. The closest I was able to get is by putting the two fields in the body part of the layout (cause if I put them in the subsummary and leave nothing in the body part, I get as I told you a blank result page when I go to browse mode). And I had to check the checkbox "running count" and "restart summary for each sorted group". I have also tried exactly what you told me but it didn't seem to work.
-
I have done that also. I clicked and chose "current table". I picked error_type and clicked sort. The window is still completely blank. It became blank when I moved my two fields "error_type" and "count" (my summary field) to the subsummary section instead of the body, and deleted the body. Also, you told me to sort by error_type, but it's a string, and I don't really want to sort by alphabetical order, I would like to sort by count. But my summary field is grey in the sort list we just talked about. Even when I go and pick "current table" instead of current layout. There must be something else.
-
I did have a body in my layout, sorry I'm a bit tired. But when I remove it, and place the two fields I told you about in my subsummary, the result I get in the "browse mode" is a complete blank page. Nothing at all. I have tried to untick the "running count", at first what it did is change the 1,2,3,4,5 pattern to the total of records I had in my table (basically it counted how many records had a value in the field error_type, and it put that result in each single record). But as soon as I moved the two fields from the boddy part of the layout to the subsummary part, the window became blank, whatever this checkbox setting. And then there's nothing to sort either cause the sort dialog doesn't give me any fields to choose from for the sort, since they aren't any. It seems what I'm trying to do is not that easy...
-
I have just done what you told me. My layout looks like this --Header --Sub-summary by error_type [error_type field] [summary field] --Footer The thing is I get this : [Error_type] [summary] D4690 1 D4690 2 D4690 3 FL4960 1 FL4960 2 J2800 1 J2800 2 J2800 3 J2800 4 My summary field for counting the error_type is setup this way : count of "error_type" when sorted by "error_type" "Running count" is checked "Restart summary for each sorted group" is checked also As you know, I would like to get only one line for each error_type, with the total number of occurences. Not a count from 1 up to the total value. What I'm looking for would be : [Error_type] [summary] D4690 3 FL4960 2 J2800 4 It's my second day in Filemaker, it's intense. It's not so complicated, it's just I wanna do very special things right from the beginning. Any ideas on how to get rid of all the duplicates and have only the total number of the count ? I could probably right a script but I don't have much time. I hope there is an easier way. Otherwise I'll export it as tab-delimited and write a perl script...
-
PHP/mySQL query on Filemaker Pro (non-server), with ODBC
skiss replied to skiss's topic in External Data Sources
I'll try to continue that tomorrow. For now I'm trying to start the work I need to do in File maker. I'm trying to do the equivalent of SELECT error_type, COUNT(error_type) AS error_type_count FROM table GROUP BY error_type ORDER BY error_type_count DESC If you could have a look at the topic I created in the "Calculation Engine" section of the forum, it would be really nice. Thanks for all your help, I appreciate it. -
Hi, I have about 60 000 records, that describe a list of incidents. Each record has an "error_type" field. It contains a string. What I would like to do is described very simply in SQL SELECT error_type, COUNT(error_type) AS error_type_count FROM table GROUP BY error_type ORDER BY error_type_count DESC Basically I want to get a count of how many incidents there has been for each type of error (each "error_type" value). What's the easiest way to do that in Filemaker ? What I have done so far is add a summary field, that I have set to be a "running count" of the field "error_type". I have also enabled the function "restart summary for each sorted group". I it gives me this kind of output : error_type_1 1 error_type_1 2 error_type_1 3 error_type_1 4 error_type_1 5 error_type_2 1 error_type_2 2 error_type_2 3 In this example, what I'm looking for would be : error_type_1 5 error_type_2 3 I have tried to export the records, and have them grouped then, but it gives me that : error_type_1 8 error_type_2 Basically it adds the total number of records and put them on the first line. Any ideas ? It would be sooo quickly done in SQL....
-
PHP/mySQL query on Filemaker Pro (non-server), with ODBC
skiss replied to skiss's topic in External Data Sources
I thought it would be more clear, here are the real values dsn_name = MBPLevel2Sys user = WebUser password = level2 I have changed the ODBC drivers location, from being installed just from one user to beeing installed for the whole system. It's getting a bit better, now it seems to find the drivers, but it still doesn't work : Warning: odbc_connect() [function.odbc-connect]: SQL error: [iODBC][Driver Manager]Specified driver could not be loaded, SQL state IM003 in SQLConnect in /Users/steph/Sites/index2.php on line 16 Warning: odbc_error(): supplied argument is not a valid ODBC-Link resource in /Users/steph/Sites/index2.php on line 18 Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in /Users/steph/Sites/index2.php on line 38 ******* ! Setting up ODBC is the most complicated thing I have ever tried to do on my computer... I guess if it had worked right away I would have found it easy. -
PHP/mySQL query on Filemaker Pro (non-server), with ODBC
skiss replied to skiss's topic in External Data Sources
Here's what I get. Any ideas ? I think the drivers are not working but I don't have a clue why. I followed exactly what's in the FMP manual. Warning: odbc_connect() [function.odbc-connect] SQL error: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded, SQL state IM002 in SQLConnect in /Users/steph/Sites/index2.php on line 16 Warning: odbc_error(): supplied argument is not a valid ODBC-Link resource in /Users/steph/Sites/index2.php on line 18 Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in /Users/steph/Sites/index2.php on line 38 -
PHP/mySQL query on Filemaker Pro (non-server), with ODBC
skiss replied to skiss's topic in External Data Sources
I had done all that already. It still doesn't work. What can it be ? I have no idea what's wrong. Is there a way to check if the ODBC drivers are running properly ? -
PHP/mySQL query on Filemaker Pro (non-server), with ODBC
skiss replied to skiss's topic in External Data Sources
I'm getting closer, but it still doesn't work. I have installed PHP 5.2.2 on OS X, which includes the ODBC functions. I have setup ODBC administrator (the OS X app) this way DSN : dsn_name Host : localhost Port : 2399 ServerDataSource : fmp_db_name I have set up fmp so that my database authorizes ODBC accesses, and I have set up a user with full access rights. Here is my PHP code : <?php $db = odbc_connect("dsn_name", "user", "password", "") or die(' Could Not Connect to ODBC Database! '); $query = 'SELECT * FROM table'; $result = odbc_exec($db, $query) or die(' Query error ! '); odbc_fetch_row($result); $res1 = odbc_result($result, 1); $res2 = odbc_result($result, 2); print("$res1 $res2n"); odbc_close($db); ?> I'm only trying to display the first result for now. I get the "Could not connect to ODBC Database" message, which tells me my odbc_connect has failed. I really need to get that to work. Any advice ? The problem I have is I don't have a clue what is working, what is not, and where to look. Thanks in advance for the help, Stephane -
PHP/mySQL query on Filemaker Pro (non-server), with ODBC
skiss replied to skiss's topic in External Data Sources
I'm using MAMP. Maybe that's the problem. -
PHP/mySQL query on Filemaker Pro (non-server), with ODBC
skiss replied to skiss's topic in External Data Sources
Thanks for your help. I don't have filemaker pro server, that's why I couldn't use the PHP API from filemaker. But I'll think about it. For now, I'm trying to get the PHP odbc to work. Should work fine with filemaker pro non-server, right ? I use PHP 5, but the problem I have is I don't seem to have the ODBC functions. When I test wether they are installed with function_exists(), PHP tells me they are not there. Is there a way to install them ? Thanks, Stephane -
Hello, I would like to display on a web page, using PHP and mySql queries, data from a FileMaker Pro 9 database. It's the opposite of what most people want to do. Is it possible without the server version ? I don't plan to access the database directly with PHP functions, I would like to pull data from Filemaker with mySql queries. How to do that ? Do I need the Filemaker ODBC client driver, the mySQL client driver, or both ? How should I set them up ? I have downloaded and installed the mySql odbc connector, and set it up in ODBC administrator in OS X, with these values Host : localhost Port : 2399 ServerDataSource : fmp_db (fmp_db is without the .fp7 extension) But I'm not sure it was the right thing to do. And what PHP/MySql commands should I write in my web page to get the data ? I have this at the moment : $db = mysql_connect('localhost', 'admin', ''); mysql_select_db('fmp_db', $db); $sql = 'SELECT * FROM table'; $req = mysql_query($sql) or die(' Erreur SQL ! '.$sql.' '.mysql_error()); I get an SQL error with these lines. Thanks in advance for your help / hints. Stephane