• Content count

  • Joined

  • Last visited

Everything posted by ggt667

  1. I have a MacMini running macOS Sierra with FM11PA that works; however this FM11PA was installed when there was MacOS X 10.10 on the MacMini. Attempting to install FM11PA on my MB15R fails, well the installer appears to work fine( as pr attached image, ) but launching the app( as pr attached image ) tells me somebody has been fiddling with the installation and that I have to reinstall the application.
  2. I tried copying a working FM11PA application and ~/Library/FileMaker from Mavericks and receive the same error as above after dragging in the app to Sierra. This work for me In /Applications folder of the system running Mavericks compress FileMaker Pro 11 Advanced Copy the archive and the ~/Library/Application\ Support/FileMaker folder to the sierra system's /Applications and Application Support folder respectively Decompress Launch For some reason copying the folder did not.
  3. I run FM11PA on a MacMini in macOS Sierra; I only use the ER diagram to draft new databases I do not know if it works with everything desktop, but it appears impossible to install under macOS Sierra, looks like it has to be preinstalled when you do the upgrade from MacOS X 10.10.
  4. @wattmhite if you are on a mac may or may not ease the work of making an XSLT aka stylesheet that @comment proposes you make. It works fine for 14 days without a license. I also do recommend you make 1 XML export from FileMaker with sample data and test your XSLT using xsltproc in or I have built integrations between FileMaker and several formats( most of them using XML, ) feel free to PM.
  5. When exporting XML as fmxmlresult.xml when does FileMaker populate the content of the layout attribute? Usually it looks like <DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="" NAME="Menu.fp7" RECORDS="51" TIMEFORMAT="k:mm:ss "/> Yet sometimes it looks like this <DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="menu" NAME="Menu.fp7" RECORDS="51" TIMEFORMAT="k:mm:ss "/> Then again when querying the XML RPC it always look like this <datasource database="Menu.fp7" date-format="MM/dd/yyyy" layout="menu" table="Menu" time-format="HH:mm:ss" timestamp-format="MM/dd/yyyy HH:mm:ss" total-count="0" /> Asking the question myself, answering the question myself as well. Checking the following checkbox populates the LAYOUT-attribute of FMPXMLRESULT
  6. Anything from 2-5 secs for PDF to write to disk in full depending on server spec may be needed. Or do shell script server side "sync;sync" if the server is a mac.
  7. I do this all the time in FileMaker since 2000 actually; however I only use FileMaker to trigger a script, in 2013 I shared my approach with the world on my blog: The example in the blog is in php from the time of implementing FX.php around the time of FM 5.5; however these scripts can be written in any language swift kitura, apache CGI/php/python, nginx FAST CGI, nodejs express, ruby sinatra, and so on just to mention a few; all those scripting languages can listen to a HTTP GET requests from FileMaker and call any HTTP request sync or async that populates a database. Captchas may or may not stop you; depending on the page.
  8. How can I get ESS access to PostgreSQL from FM11SA?
  9. I do recommend, it's for free unless you feel like buying an upgrade to gain features, it's endpoint to endpoint encrypted and it's only on the drives you share it with.
  10. I run MacOS X 10.6.4( and its default JDK / JRE ) with FM11SA; it works out of the box. Newer versions of MacOS X may work, but usually only as upgrades from what I mentioned in the previous sentence. The admin console crashes at times and it's a pity for schedules, however I have made a solution using postgreSQL's JDBC FDW that actually works more reliably than the admin console. I have published some writing on my blog:
  11. How would you query Nutch or SOLR from within FileMaker? SOLR and elasticsearch are both interfaces on top of lucene. SOLR does not have aggregation; and as such would not have the features I would need to speed up searches. I'm not sure which complexity you are trying to get rid of. "Don't forget about the aggregations ElasticSearch provides for those requiring OLAP like functionality. Solr cloud has only limited faceting. And if you need alerts on aggregations ES percolation delivers." –
  12. I'm not sure if I would involve logstash and kibana in such a matter, however writing the FileMaker data to Elasticsearch could improve search speed especially when search criteria is in related fields.
  13. Like Blackwell says: Stating your rights and enforcing them are two different items. What you ask is basicly a patent question; the short version of this is you are not interesting in the enforcing part, you would like your client to sign the papers that they understand the line between ownerships( your solution and their data ) this paper should be a threat enough for them not to steal from you. Neither you nor your client should be interested in bringing that paper to court, that would mean you both loose massive amounts of hours, however if you can invoice such a time spent on defending yourself based on the initial paper and this is clearly stated in the agreement you have effectively shrunk the upside of stealing your IP.
  14. I would really like to see FileMaker cloud run on triton containers / Joyent SmartOS [on-prem]
  15. That's my point exactly you can use test data as perfect as you like, but when there are actual exceptions 7 months or 5 years down the road, you can not cherry pick your situation. I also always fill in: <PRODUCT BUILD="LocalPathToDevFolder/opt/dev/TheIntegrationPartner/implementation" NAME="TheIntegrationPartner" VERSION="TimeStampOfImplentation"/> and: <DATABASE LAYOUT="TheExternalScriptNameInWhichAlsoHasItsOwnLayout" NAME="FileMakerSolution Name" in production with data that describes the situation, even though FileMaker never bothered to use any of them for anything at all( input or output, ) oh well NAME="filemakerfilename" and PRODUCT is used for exports, but useless in most integrations, yet valid for some web aspects.
  16. Without seeing the list you followed it's kind of hard to know if you skipped a step; or the author of the list did.
  17. True, but it makes me wonder if there is something really old being worked on. An this could be a part of the path to finding the actual issue. The simplest way to solve the issue is to make a text file on the destination system and find out which line break is used The attached example clearly uses the CRLF as pr <xsl:text>&#x000D;&#x000A;</xsl:text> xxd /home/user/99415-crlf-in-output-to-windows//test.csv | head -n 7 | tail -n 1 00000060: 6b74 0d0a 3830 3134 3339 3935 3030 3532 kt..801439950052 On the Mac newline is clearly: #10 or #x0A $ echo "" | xxd 00000000: 0a . I have tested the test.csv file from initial post in LibreOffice, and OpenOffice and I see no such symptoms as described. Makes me think it's an old Windows or Office.
  18. Debugging, easier distinct the different records from each other when there are monotonous data. Clarity is key to not waste time. Care to elaborate?
  19. Which troubles? I would like to know. I have spent quite some time on this FileMaker 5.0 Unlimited - FileMaker 14 Server Advanced and I have not been given any difficulties using this. My experience is that it's nice to have a counting number there in the case anything goes wrong, but that the import ignores them. MODID="0" I use as these are all new data to Filemaker.
  20. If you are exporting from FileMaker I doubt the encoding should be: <xsl:output method="text" encoding="ISO-8859-1"/> At least I have used:<xsl:output method="text" encoding="UTF-8"/> for FileMaker 5 and up, I doubt there is anything that uses ISO-8859-n after Windows 2000, MacOS X and linux was released.
  21. encoding="UTF-8" should be the default for any XML document.
  22. Or if you'd like to do them all in one go --- <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="" version="1.0"> <xsl:output method='xml' version='1.0' encoding='iso-8859-1' indent='yes'/> <xsl:template match="/*"> <FMPXMLRESULT xmlns=""> <ERRORCODE></ERRORCODE> <PRODUCT BUILD="" NAME="" VERSION=""/> <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="" RECORDS="{count(/channel/item)}" TIMEFORMAT="h:mm:ss a"/> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="comment" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="date" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="baseCurrency" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="currency" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="rate" TYPE="NUMBER"/> </METADATA> <RESULTSET FOUND="{count(/channel/item)}"> <xsl:apply-templates select="/channel/item"/> </RESULTSET> </FMPXMLRESULT> </xsl:template> <xsl:template match="*[name() = 'item']"> <ROW xmlns="" MODID="0" RECORDID="{position()}"> <COL><DATA><xsl:value-of select="title"/></DATA></COL> <COL><DATA><xsl:value-of select="pubDate"/></DATA></COL> <COL><DATA><xsl:value-of select="baseCurrency"/></DATA></COL> <COL><DATA><xsl:value-of select="targetCurrency"/></DATA></COL> <COL><DATA><xsl:value-of select="exchangeRate"/></DATA></COL> </ROW> </xsl:template> </xsl:stylesheet> --- Outputs based on: xsltproc /Applications/FileMaker\ Pro\ 11\ Advanced/English\ Extras/Examples/XML\ Examples/Import/floatrates2fmpxmlresult.xslt --- <?xml version="1.0" encoding="iso-8859-1"?> <FMPXMLRESULT xmlns=""> <ERRORCODE></ERRORCODE> <PRODUCT BUILD="" NAME="" VERSION=""/> <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="" RECORDS="92" TIMEFORMAT="h:mm:ss a"/> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="comment" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="date" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="baseCurrency" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="currency" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="rate" TYPE="TEXT"/> </METADATA> <RESULTSET FOUND="92"> <ROW MODID="0" RECORDID="1"> <COL> <DATA>1 USD = 0.88686408 EUR</DATA> </COL> <COL> <DATA>Sun, 17 Apr 2016 00:00:01 GMT</DATA> </COL> <COL> <DATA>USD</DATA> </COL> <COL> <DATA>EUR</DATA> </COL> <COL> <DATA>0.88686408</DATA> </COL> </ROW> <ROW MODID="0" RECORDID="2"> <COL> <DATA>1 USD = 0.70550060 GBP</DATA> </COL> <COL> <DATA>Sun, 17 Apr 2016 00:00:01 GMT</DATA> </COL> <COL> <DATA>USD</DATA> </COL> <COL> <DATA>GBP</DATA> . . . <COL> <DATA>6.86000000</DATA> </COL> </ROW> <ROW MODID="0" RECORDID="92"> <COL> <DATA>1 USD = 0.38450000 OMR</DATA> </COL> <COL> <DATA>Sun, 17 Apr 2016 00:00:01 GMT</DATA> </COL> <COL> <DATA>USD</DATA> </COL> <COL> <DATA>OMR</DATA> </COL> <COL> <DATA>0.38450000</DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT>
  23. Perhaps this page can be of inspiration?
  24. http://ipaddress/fmi/xml/fmresultset.xml?-db=DATABASE&-script=SCRIPTNAME&-layoutname=LAYOUTNAME&-findany
  25. Narrowing down the amount of data you work with is always good; but the part you are writing about is in the query, not in the layout.