• Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by ggt667

  1. How can I get ESS access to PostgreSQL from FM11SA?
  2. I concatenate 2 PDF files using ghostscript on the Mac, not sure how to do that on Windows, should be a similar way. If you like your PHP approach I do recommend looking into the way I write about in my blog:
  3. You can design your solution for this make a designated folder in the Documents folder of the user running. Example: ~/Documents/designatedfolder If you run TimeMachine, make sure you disable your designated folder for the FileMaker file(s) in question For backups do yourself a favour and do an export records of the type FileMaker to the designated folder named with a timestamp; Example ~/Documents/designatedfolder/designated-2017-04-15.fmp12 Never use the same machine for FileMaker Server and other tasks at the same time; only exception is to keep FMPA installed on the server in case of emergency, do not launch until Server is stopped. And only use for repairing the broken files from the server. Never used a repaired file; only export its data.
  4. I have access to latest postgresql from FM11SA using ESS.
  5. 512 Record was already modified by another user You say nothing about how you UPDATE the data. Which OS does the machine that runs FM11SA run? When I do what you describe I export a selection of data AS XML and do an XML / XSLT / tr -d / tidy / xsltproc transformation on the command line and then do an UPSERT based on recid / modid.
  6. cron or php? Using cron you are usually better off using the system mailer.
  7. It looks like you should be able to do GetAsCSS( fieldname ) and then use the output of that in its own field. No need for supporting/shadow field: Yet you will have to override CSS font or be stuck with whichever font is put inside FileMaker by the looks of it.
  8. This is true for FileMaker 11, unless FileMaker made some serious upgrades to their php api after this; here is my piece of advice. As a rule of thumb what you export when you export to XML for FileMaker is what you can bring to the web. That said I'd imagine you can make a supporting field that holds the info you are after.
  9. Yes, this is quite simple in FileMaker you just make as many columns you'd like across on the layout and change the inital row for column; as pr image below, not sure about its dynamics though...
  10. 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.
  11. 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.
  12. 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.
  13. 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.
  14. 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.
  15. 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.
  16. 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.
  17. 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.
  18. 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>'; ?>
  19. Does the following output anything? <?php echo "Code: " . $result->code; #Check for an error if( FileMaker::isError( $result ) ) { ?>
  20. 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>"; } }
  21. What is wrong when Database appears unavailable to the scheduler, yet regular users are logged in?
  22. 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
  23. 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
  24. 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.