ggt667

Members
  • Content count

    265
  • Joined

  • Last visited

  • Days Won

    2

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
  • Birthday

Profile Information

  • Gender
    Male
  • Location
    Tellus
  • Interests
    Trikke T12 Roadster

Contact Methods

  • Website URL
    wethecomputerabusersamongst.blogspot.com
  • Skype
    ggt667
  • AIM
    fxphp
  • MSN
    iMessage: ggt667@me.com

FIleMaker Profile

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

Recent Profile Visitors

2,953 profile views
  1. 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.
  2. 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.
  3. This is an XSLT stylesheet to convert from FileMaker's fmpxmlresult to sitemap and vice-versa. https://github.com/TyrfingMjolnir/fmpxmlresult2sitemap
  4. If you are doing transfers across http, make sure you enable gzip in nginx or similar. If you are able to, i e
  5. 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/
  6. 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
  7. 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.
  8. 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.
  9. 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;" )
  10. 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.
  11. You did not export your FMPXMLRESULT from the table where you would like to import from or export to...
  12. 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
  13. 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.
  14. https://github.com/TyrfingMjolnir/FMPXMLRESULT2psqlCOPY
  15. https://github.com/TyrfingMjolnir/fmpxmlresult2SwiftyJSONModel