Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


trevix last won the day on January 23

trevix had the most liked content!

Community Reputation

2 Neutral

About trevix

  • Rank

Profile Information

  • Gender
  • Location
    Turin, Italy

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

2,390 profile views
  1. 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?
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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>
  7. 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 !
  8. 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
  9. I thougth about this, but most of my potential clients will find the search for the Ip number too cumbersome...(in my opinion). I must explain that I have an external application that acts as a web server, to wich from FileMaker I send URL's, so I need both to nail the correct IP. The fact is that both the OSX network preferences and Win7 lan setup show the correct IP. And a shell call on the PC at least put the correct one in top of the listed. I wonder if using applescript (shell) and vbscript from Filemaker I could isolate the IP that I need...instead of using get(SystemIpAddress). A similar problem is getting the NIC address (I would like to use it to do licence checking). Filemaker report 2 NIC address, the first for the WiFi card and the second for the Ethernet card, without being able to tell wich is wich. In my external app, I do a shell call (en0 or en1) and I get the wright one (I hope this would be consistent on any PC...)
  10. I have limited knowledge of Ethernet and TCP/IP so you will excuse my ignorance... I have FileMaker Pro 12 that host a file on OSX. I need to get, on the hosting FileMaker Pro, the ip address of this same computer. On the network preference of the Mac I've IPv4: (the router is This is the IP that I need to get in my calculation...but: On the sharing of FM I have; A get(SystemIpAddress) gives me: I could easily pull the second line from the list, but this list seems to change often (the wasn't there a few days ago). For example on the VMware Windows 7 partition of the same machine, the function gives me (that is correct), without other values on the list. On another Mac on the same intranet I get (correct). One value only. Since this is going to be a solution to be sold, I need a way to nail it down... I feel that this is related to DNS, but this info does not help me. Thanks for reading. Trevix
  11. While I agree with what you said, I don't understand how can I convince my customer that a 4 user network should shell out 1.000,00 euros (1.250 $) for FMS when FMP can work as well. Beside it was a requirement to fire DDE (I don't think FMS can do it, so I may have needed an extra robot licence), save PDF from iPad on a server HD, print from iPad without a airprinter (they already owned a big one that was not). What I don't understand, on the FileMaker people, is what I perceive as a stubborn decision not to give easy access to FM from external application (applescript is in limbo, Vbscript is minimal, ODBC require cumbersome setups and driver, URL (only on 12) is crippled as it was not intended for that.) Small companies may use FM for recording jobs, tasks, personal data. But I don't think it is convenient for accounting or calendar application. But, after all, it could only be that XML and PHP are tough if you don't know them :laugh:
  12. Update (still on FMP12, no interest on FileMaker Server) on runnning a FM script using a URL (I know that there are plugin but I rather not...) I tried to run the script from URL on the same PC and I've got a strange result. If, on the same PC (windowsXP, ip with the "Prova.fmp12" already open, you fire (from LiveCode (RunRev) for example but you can do it also from the browser if you got the "fmp" application on the options) a: "FMP://UserName:UserPass@" FileMaker opens inside the same copy of FMP a "new instance" of the DB (without closing the old one), a clean one...with passed username, no previous global, etc (like if you would open it from scratch) and run the script on this (with parameters received). If you do a "close window", the new instance will close while the old will still be there (during the "prova" script, if you close the windows the script will stop). I managed anyway to do what I wanted (run a FM script from URL) but I find no way to get back a result of some sort, which is essential to me. So the question is: FMP://...does not answer anything ? (on the browser you get a failed connection...) Comments ?
  13. HI. I've been fighting with the same problem, but I think I found a solution. Put a trigger (on object modify) on the pop field with a script that: - commit the record - halt the script The "halt" script seems to work on avoiding the keyboard to come back. Trevix
  • Create New...

Important Information

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