ggt667

Members
  • Content count

    263
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by ggt667

  1. This is an XSLT stylesheet to convert from FileMaker's fmpxmlresult to sitemap and vice-versa. https://github.com/TyrfingMjolnir/fmpxmlresult2sitemap
  2. If you are doing transfers across http, make sure you enable gzip in nginx or similar. If you are able to, i e
  3. 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/
  4. 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
  5. 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.
  6. 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.
  7. 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;" )
  8. 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.
  9. You did not export your FMPXMLRESULT from the table where you would like to import from or export to...
  10. The way to do such translations is To make export of 1 record pr table that you would like to import to with as low amount of fields as possible, yet as many as needed. Make one XSLT pr table you would like to translate your XML to; UBL as an example, using the exports from pt 1 as template Import once pr XSLT and you will have populated that field you exported in pt 1
  11. I always pipe output through cat data.fmpxmlresult.xml | tidy -i -xml -wrap 0 -utf8 for indenting If you export just a couple of hundred records white space does not really matter, but when you exceed a couple of thousands pr day, size actually makes a difference.
  12. https://github.com/TyrfingMjolnir/FMPXMLRESULT2psqlCOPY
  13. https://github.com/TyrfingMjolnir/fmpxmlresult2SwiftyJSONModel
  14. https://github.com/TyrfingMjolnir/fmpxmlresult2xcdatamodel
  15. 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.
  16. 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.
  17. 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.
  18. @wattmhite if you are on a mac http://xmplifyapp.com 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 iTerm2.app or Terminal.app I have built integrations between FileMaker and several formats( most of them using XML, ) feel free to PM.
  19. 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
  20. 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.
  21. 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: http://wethecomputerabusersamongst.blogspot.com/2013/10/execute-php-script-from-filemaker-with.html 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.
  22. How can I get ESS access to PostgreSQL from FM11SA?
  23. I do recommend http://www.getsync.com, 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.
  24. 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: http://wethecomputerabusersamongst.blogspot.com/2016/08/building-filemaker-cache-in-postgresql.html
  25. 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." – http://stackoverflow.com/questions/10213009/solr-vs-elasticsearch