Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


trevix last won the day on January 23 2019

trevix had the most liked content!

Profile Information

  • Gender
  • Location
    Turin, Italy

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

2,980 profile views

trevix's Achievements


Contributor (5/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Ok, I found the problem. One of the parameter, that would go in a FM text field of the new created record, trows the error response if it is true, as boolean, or even "true" as text, because in the json conversion wasn't inserted in between quotes. Changing it to 1 or 0 or else, doesn't return the error anymore. Just for completeness, I am creating new FM records from an external environment, in LiveCode. I can easily solve this particular problem but this wasn't my point: Is it possibile to find out which parameter or wrong field name or missing field in the destination layout, returns an error from FMS?
  2. Trying to create a record on FMS18 using its API, sometime I get an error response: {"messages":[{"code":"1708","message":"Parameter value is invalid"}],"response":{}} I know what this means, but i wonder if there is a way to get back from FMS, with the error message, which parameter (field) is the culprit. I am pretty sure that, having to deal with US and European date format, my seldom error depends on this. But the error message is so vague... Thanks
  3. Will google it. Thanks But do you think I would be much better learning how to SQL?
  4. Opps. Sorry. I forgot to mention that I am putting together a sort of dashboard. So there are other values (and PieChart), similar to the one I mentioned: like App version, Hardware type, language and similar. Beside the time it would take, I would then need multiple sort followed by a set field with the results; almost the equivalent of doing loops. Suppose there are thousands of records... One thing that baffles me is that, creating a relationship between the "OSversion" field and itself, a subsequent count calculated field and using this as the second field for the List, I can clearly see the total for each value of "OSversion", in the list (see screenshot). I wonder if it is possible to extract it...
  5. Without using SQL (that i find cumbersome) I would like to create a Pie chart, with a dynamically list of labels (?!) I want to do a small analytics using FM. My App, using the FM API, creates a record putting in the FM field "OSversion" the OS system they run in (that can be various, iOS 9.3, 10.1, 11.2, etc) I am struggling to come up, without looping trough the records, for a calculated field that gives me what i need for the PieChart: that is the total of each iOS version return delimited, no matter how different and how many they could be.. For the labels I can use off course a List from the field "OSversion". But for the totals, I cannot use relationships, since the next record could be a value (say 14.5) that I did not plan to have. Is it there a solution? Thanks
  6. On windows 7 (VMware on OSX), using FMP17 and Microsoft Access 2016 Trying to do a ODBC import and selecting the datasource, I get asked for Username and password, even if the Access DB is not password protected. The data sources are correct (tested from Livecode) and should be working without user name and password. On the properties of the ODBC pane setup the path seems correct (not pointing to 32): %windir%\SysWOW64\odbcad32.exe What am I missing?
  7. I have a developer subscription. My FMS17 works fine on OSX 10.12.6. I installed FMS17 on a Win7 (VMware) virtual machine (developer should allow up to 3 FMS) and FMS seems to work fine: I login, see the demo file, etc. The problem is that when I try to upload a DB from FMPA, both from OSX or from the VM Win7, I see the FMS but the login pane is greyed out. I reinstalled FMS to no avail. Is there a problem with Win7? Something else? Thanks Trevix
  8. So...now is 2018 and a lot of water went under the bridge. Would anyone with expertise update this discussion, please? How would I go on building a web site for a travel agency, that uses FMS to manage all its business, where users can login and exchange data with the agency about an enrolled travel? They tell me that ODBC/XML is not considered secure anymore. Custom web publishing hosted by the agency hardware? Thanks Trevix
  9. After a lot of research, I have not yet been able to understand how to recommend / fulfill my client's wishes. I created a management software (FMS16 on the client hardware server) for a travel agency, which at the moment communicates with customers with exchanges of e-mails and pdf, automatically generated by FM. Now the agency would like to allow customers (say 20 max concurrent users) to log in on the internet and exchange all the information, in the various pre-trip and post-travel phases, via the website: - secure web login, password generation, forgotten password management, etc. - entry of travel data on specific pages dedicated to the customer - possibility for the client to fill in personal data - signing of the contract (generated pdf, which was previously sent via email, downloadable, signed and rechargeable on the website) - update on payments, advance payment, wire transfer receipt, etc. (no payments on the web site) - linked pages for traveler's travel data (children, wife) - list of participants in the trip, meetings, technical notes, departure updates - downloadable invoice - travel evaluation form, privacy, etc. Briefly, all the above and other things. Almost immediately I discarded the idea of using web direct because of: - complexity and security in login management - have a "responsive" website I then proposed to those who manage their website (currently used only to present travels), to do an ESS synchronization with a website / MySQL on a host, I think it is quite traditional and therefore easy to implement (sigh?). The data to the agency would be local on a second FMS (so as not to have the possibility to corrupt the management FM) that, synchronized with MySQL remotely, would allow to update the tests and documents. They told me it's not a good idea, because data duplication (FM and MySQL) would make everything more complex and difficult to manage (they do not know FM). At this point remains Custom Web Publishing. I could not handle the problem, not knowing php, html etc. I find it difficult to find a supplier company that is not clearly biased towards FM or just web design. The question is: how do others do? Trevix
  10. On OSX 10.11.6, FM 14.04, FM 15.0.3, Adobe Acrobat Pro 11.0.20. No Acrobat reader (that I know of). A single FM test database with just one interactive container field, either saving externally or not. Dragging a PDF or using the menu (insert). Single page or multiple page PDF Works fine on FM12. Show only a black field on FM14 and FM15 with no possible interaction Works fine if the container is not interactive. Any solution? Thanks Trevix
  11. I am the developer of an application that, when launched, gets a URL to an internet web page where I have written the current version number for that application. Doing some parsing on the return from the URL, the application knows this way that it has to advice the user of a new version available. I would like to do the same thing with FMS 13 and webdirect: - have some text on the connection page/layout (the version, to be parsed by my application) - collect some data from the user app (that I will put inside the URL) may be triggering a new record for every call In this way, not only I will supply the correct version number, but I will be able to collect valuable bug data from the app. Like the data that get sent to Apple when your app bombs... Is this possible ? Can some one point me in the right direction ? How do software company usually do it ? I tried a URL ("http://IpNumber/fmi/webd#tcalversion" ) with a triggered script on the first window opening of the FM file, but it only works from a web browser (safari). From my app, built with LiveCode (RunRev) I got something like: "You have to enable javascript in your browser to use an application built with Vaadin." What is "Vaadin" ? Thanks for any input. Trevix <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=9;chrome=1" /> <style type="text/css">html, body {height:100argin:0;}</style> <link rel="shortcut icon" type="image/vnd.microsoft.icon" href="./VAADIN/themes/default/favicon.ico" /> <link rel="icon" type="image/vnd.microsoft.icon" href="./VAADIN/themes/default/favicon.ico" /> <meta name="apple-mobile-web-app-capable" content="yes" /> </head> <body scroll="auto" class=" v-generated-body"> <div id="fmiwebd-742712558" class=" v-app default"> <div class=" v-app-loading"></div> <noscript> You have to enable javascript in your browser to use an application built with Vaadin. </noscript> </div> <iframe tabindex="-1" id="__gwt_historyFrame" style="position:absolute;width:0;height:0;border:0;overflow:hidden" src="javascript:false"></iframe> <script type="text/javascript" src="./VAADIN/vaadinBootstrap.js"></script> <script type="text/javascript">//<![CDATA[ if (!window.vaadin) alert("Failed to load the bootstrap javascript: ./VAADIN/vaadinBootstrap.js"); if (typeof window.__gwtStatsEvent != 'function') { vaadin.gwtStatsEvents = []; window.__gwtStatsEvent = function(event) {vaadin.gwtStatsEvents.push(event); return true;}; } vaadin.initApplication("fmiwebd-742712558",{ "heartbeatInterval": 30, "versionInfo": {"vaadinVersion": "7.1.10"}, "vaadinDir": "./VAADIN/", "authErrMsg": { "message": "Prendere nota di eventuali dati non salvati e <u>fare clic qui</u> per continuare.", "caption": "Problema di autenticazione" }, "widgetset": "com.filemaker.jwpc.iwp.widgetset.UIWidgetSet", "theme": "default", "debug": true, "comErrMsg": { "message": "Prendere nota di eventuali dati non salvati e <u>fare clic qui</u> per continuare.", "caption": "Problema di comunicazione" }, "standalone": true, "sessExpMsg": { "message": "Prendere nota di eventuali dati non salvati e <u>fare clic qui</u> per continuare.", "caption": "Sessione scaduta" } }); //]]></script> </body> </html>
  12. It dose not. Somehow both on the iphone and on the iPad it report 640 on the screenWidth and on the desktop width. It works on the desktop computer tough. I tried other get funcions but it looks like the IWP does not distinguish iPhone from iPad. Weird !
  13. I noticed that nobody answered to how to choose a different layout on the opening script according to iphone, ipad or PC version (very different screen sizes...). I tried with several get functions but they seems not to report correctly on the web browser. Anybody with a solution ? To contribute, I report this: http://www.creative-networks.de/en/iwp-page-optimization-for-mobile-devices/ Trevix
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.