ggt667

Members
  • Content count

    281
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by ggt667

  1. I'm not sure if you want to debug that, after all you have no access to the source code and for better or worse making a change is not really appreciated by FileMaker, Inc My 2 cents worth install nginx, configure reverse proxy. Then close the file, and reopen the file. You should be set for weeks of non-interrupted FileMaker WPE action.
  2. You could write a script for server that is triggered every 5 mins by the server's script scheduler that checks if a record has a creation timestamp last 5 mins by your php script user, and if so issue an email.
  3. Without seeing your tables it's hard to give an exact answer, my immediate guess is that you would use a combination of relationships and layouts( triggers may also apply to your use case ) to achieve some kind of OLAP/CUBE kind of thinking. I just did something similar a couple of weeks back, if you would like my 2 cents worth, PM. Which properties do you sequence? Do you file for both polarities of the helix as well as the regular ATCG? What I did was to export key fields from a selection of records to temp folder and reimport them in the tables are needed according to primary keys and rules.
  4. So you are basically spreading the information to everybody no need for 1 person to verify the data and then inform the others. Then what @rwoods suggest is probably the better option.
  5. I believe you are asking the wrong question, both FileMaker and the web can send email perfectly fine. Is this a spread point for information? Then letting the submit button on the web may be the way to go, as mentioned by @rwoods Is this a starting point for somebody to prepare something inside FileMaker? Then letting the preparations be done first and click at the end of the preparations to trigger an email may give a more live feeling to the other pariticipants.
  6. The combination thereof could prove otherwise... However if it's all defined in UBL or any other open standard, it should be hard to patent.
  7. If you would like help; Please show your script; usually on the top of stylesheets the output is defined( as on the 3rd line in the paste below ) <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" version="1.0"> <xsl:output method="text" version="1.0" encoding="UTF-8" indent="no"/> There should be no need for CRLF these days; unless you use an old matrix printer, CRLF is for old matrix printers. All systems after Windows 2000, MacOS X and linux of 2000 should comply to Unicode standards. There should really not be any reason to use legacy ANSI or ISO-8859-n this side of the year 2000.
  8. My 2 cents worth; As long as you do not claim the content to be yours you should be fine. You provid an entry point that may or may not be more appropriate for the users of your app to already existing public services AFAIK.
  9. If I were you I'd create a new file with the following( still from the same link ) and adapt this to my database settings. To see if I could learn anything from this setup. <?php require_once ('Filemaker/Filemaker.php'); $fm = new FileMaker('TimeTracker.fp7', '127.0.0.1', 'esmith', 'f!r3crack3r'); $request = $fm->newFindAllCommand('associate_layout'); $request->addSortRule('Status', 1); $request->addSortRule('Type', 2); $request->addSortRule('Account Name', 3); $result = $request->execute(); echo '<table border="1">'; echo '<tr>'; echo '<th>Status</th>'; echo '<th>Type</th>'; echo '<th>Account Name</th>'; echo '</tr>'; if (FileMaker::isError($result)) { if (! isset($result->code) || strlen(trim($result->code)) < 1) { echo '<tr>'; echo '<td colspan="3">A System Error Occured</td>'; echo '</tr>'; } else { echo '<tr>'; echo '<td colspan="3">No Records Found (Error Code: '.$result->code.')</td>'; echo '</tr>'; } } else { $records = $result->getRecords(); foreach ($records as $record) { echo '<tr>'; echo '<td>' . $record->getField('Status') . '</td>'; echo '<td>' . $record->getField('Type') . '</td>'; echo '<td>' . $record->getField('Account Name') . '</td>'; echo "</tr>"; } } echo '</table>'; ?>
  10. Does the following output anything? <?php echo "Code: " . $result->code; #Check for an error if( FileMaker::isError( $result ) ) { ?>
  11. There is an example on this page: https://jonathanstark.com/fm/web-publishing-with-filemaker-and-php.php What you are looking for in this case is the part that gives "No Records Found," but there should really be some sort of $result.count() or similar like in FX.php where there is $result['foundCount'] as foundcount = 0 is not really an error; it's perfectly valid search result. if (FileMaker::isError($result)) { if (! isset($result->code) || strlen(trim($result->code)) < 1) { echo '<tr>'; echo '<td colspan="3">A System Error Occured</td>'; echo '</tr>'; } else { echo '<tr>'; echo '<td colspan="3">No Records Found (Error Code: '.$result->code.')</td>'; echo '</tr>'; } } else { $records = $result->getRecords(); foreach ($records as $record) { echo '<tr>'; echo '<td>' . $record->getField('Status') . '</td>'; echo '<td>' . $record->getField('Type') . '</td>'; echo '<td>' . $record->getField('Account Name') . '</td>'; echo "</tr>"; } }
  12. What is wrong when Database appears unavailable to the scheduler, yet regular users are logged in?
  13. In achieving your custom app( Applications built to make available your FileMaker business logic on web or mobile ) I have built some FileMaker XSLT-tooling to save you some typing. To see some of them have a look in these !gh repos: fmpxmlresult2SwiftyJSONModel iOS frontend fmpxmlresult2nodeexpress Backend FMPXMLRESULT2psqlCOPY Backend fmpxmlresult2sitemap Full stack
  14. Is there a way in AppleScript to trap if the connection is lost and have an AppleScript act on this? At the risk of asking and answering myself( AppleScript below ) repeat tell application "FileMaker Pro" try database "db" on error do shell script "sudo shutdown -r now" with administrator privileges end try end tell delay 59 -- 59 secs end repeat
  15. Answers to your questions 1) sudo apachectl stop 2) There should be instructions inside, at least brew tells you have to enable your packages. However What I would do in this case would be to leave what works running, change the IP of presinstalled apache to 127.0.0.1( to make the apache server only me available on localhost,) install nginx as reverse proxy( as pr this example ) on the same node and make a https accessible proxying through localhost, that way you get the benefit of reverse proxy in 2 ways; speed/performance, and security.
  16. The only thing that is crazy expensive is the stuff FileMaker is no good at anyway; high load at high speeds. FileMaker is good at massaging small chunks of data visually, and for generating reports from smaller amounts of data( less than 10 million records ) not to mention the quick development of user interface for it's platforms. You are better off writing your own publish scripts to communicate with other databases for web such as: REDIS, PostgreSQL, couchDB, SOLR/elasticsearch. I write my publishing scripts in XSLT and use XML export to accomplish the action. I believe the high prices is a polite way to say no interested in doing those features.
  17. FileMaker 11 works for one of my clients in Windows 10, however it's not compatible with office 2016; no more Excel exports if your upgrade office to 2016.
  18. This is an XSLT stylesheet to convert from FileMaker's fmpxmlresult to sitemap and vice-versa. https://github.com/TyrfingMjolnir/fmpxmlresult2sitemap
  19. If you are doing transfers across http, make sure you enable gzip in nginx or similar. If you are able to, i e
  20. fmpxmlresult2nodeexpress This is an XSLT stylesheet to convert from FileMaker's fmpxmlresult to JSON route node for ExpressJS, no records involved. Fieldnames as parameters; use a layout to limit the amount of fields used. I used a slightly modified version of this script to generate 280 nodes in the same API. When it comes to naming of the API I always use singular for nodes that are able to manipulate data, and plural for reports that risk responding with more than 1 record. car by :id will usually have full CRUUx/CRUD implementation and return 0 or 1 items http://localhost/api/car/1234 Showing which cars are parked in a specific car park can return anything from 0 to n http://localhost/api/cars/?park=12 https://github.com/TyrfingMjolnir/fmpxmlresult2nodeexpress/
  21. We released FMcURL back in 2003 IIRC it was for FileMaker 5/6 on Mac OS X, not sure if it still works. Version 6 of cURL is 17 years old. Perhaps I can compile it again for newer versions, if I am still able to find the source code, i e
  22. Care to elaborate? A string in OMG IDL is mapped to char * in C++. Both bounded and unbounded strings are mapped to char *. CORBA strings in C++ are NULL-terminated and can be used wherever a char * type is used. omniORB is a robust high performance CORBA ORB for C++ and Python.
  23. There are a couple of issues with 0x00 it can not be inserted with Char( 0 ), Substitute ( fieldname; Char( 0 ) ; " _There was a 0x00 here_ " ) it can not be substituted by Char( 0 ) as in the example directly above, also tried pasting the 0x00 that looks like a line break in FileMaker into the script as follows Substitute ( fieldname; " " ; " _There was a 0x00 here_ " ) when copy pasted it sometimes become Char( 13 ) – 0x00 is untouchable in many ways. 0x00 is an invalid search criteria when copied from a field in browse mode and pasted into the same field in find mode In essence Char( 0 ) means end of string, it is fully capable on making its way into a FileMaker field, actually it probably is what terminates all FileMaker fields. It exports fine to FileMaker files. #include <stdio.h> int main () { char greeting[6] = {'H', 'e', 'l', 'l', 'o', '\0'}; printf("Greeting message: %s\n", greeting ); return 0; } After copy / pasting using the keyboard into the same field Char( 0 ) turns into Char( 13 ) [ Solved ] When Checking the box "Apply current layout's data formatting to exported data" for formatting the issue of 0x00 is no longer present for XML exports.
  24. Char ( 1 ) & Char ( 2 ) & Char ( 3 ) & Char ( 4 ) & Char ( 5 ) & Char ( 6 ) & Char ( 7 ) & Char ( 8 ) & Char ( 11 ) & Char ( 12 ) & Char ( 14 ) & Char ( 15 ) & Char ( 16 ) & Char ( 17 ) & Char ( 18 ) & Char ( 19 ) & Char ( 20 ) & Char ( 21 ) & Char ( 22 ) & Char ( 23 ) & Char ( 24 ) & Char ( 25 ) & Char ( 26 ) & Char ( 27 ) & Char ( 28 ) & Char ( 29 ) & Char ( 30 ) & Char ( 31 ) That will cover most of them, it's not a problem that the characters are there, it's just that when doing an export with FileMaker there will be an error as these characters are not correctly escaped when exporting to XML. Tab, LF and CR as Char ( 9 ) & Char ( 10 ) & Char ( 13 ) would also work fine if escaped The application used to open the output XML is Xmplify, but tidy, xmlstartler and xsltproc all agree this is improper XML. This is the closest I have come to a solution( in this case the numbers are kept as a debugging tool to see if it's possible to find the source ): ( Too bad it locks and returns errors when users are in that field ) Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( // Substitute( Substitute( Substitute( // Substitute( // Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute ( fieldname; Char ( 1 ); "&#1;" ); Char( 2 ) ; "&#2;" ); Char( 3 ) ; "&#3;" ); Char( 4 ) ; "&#4;" ); Char( 5 ) ; "&#5;" ); Char( 6 ) ; "&#6;" ); Char( 7 ) ; "&#7;" ); Char( 8 ) ; "&#8;" ); // Char( 9 ) ; "&#9;" ); // Char( 10 ) ; "&#10;" ); Char( 11 ) ; "&#11;" ); Char( 12 ) ; "&#12;" ); // Char( 13 ) ; "&#13;" ); Char( 14 ) ; "&#14;" ); Char( 15 ) ; "&#15;" ); Char( 16 ) ; "&#16;" ); Char( 17 ) ; "&#17;" ); Char( 18 ) ; "&#18;" ); Char( 19 ) ; "&#19;" ); Char( 20 ) ; "&#20;" ); Char( 21 ) ; "&#21;" ); Char( 22 ) ; "&#22;" ); Char( 23 ) ; "&#23;" ); Char( 24 ) ; "&#24;" ); Char( 25 ) ; "&#25;" ); Char( 26 ) ; "&#26;" ); Char( 27 ) ; "&#27;" ); Char( 28 ) ; "&#28;" ); Char( 29 ) ; "&#29;" ); Char( 30 ) ; "&#30;" ); Char( 31 ) ; "&#31;" )
  25. 0x00 alone as an isolated issue was never really an issue for me, FileMaker exports many characters such as 0x0X unescaped. What I do is to do an export without the stylesheet, then I clean it manually after, that however is an extra step in which a proprietary application such as FileMaker should have ironed out; and preforably escaped correctly. A retroactive patch would be appropriate for this case.