• Content count

  • Joined

  • Last visited

  • Days Won


ggt667 last won the day on February 10

ggt667 had the most liked content!

Community Reputation

3 Neutral

About ggt667

  • Rank
    Street Stupid, Nerd Stupid, Geek Wiz

Profile Information

  • Gender
  • Location
  • Interests
    Trikke T12 Roadster

Contact Methods

  • Website URL
  • Skype
  • AIM
  • MSN

FIleMaker Profile

  • FM Application
    11 Advanced
  • Platform
    Cross Platform
  • Skill Level
  • Membership
  • Title
  • Industry
    Logistics, horticulture production

Recent Profile Visitors

3,107 profile views
  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="" xmlns:fmp="" 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', '', '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: 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 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.