Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About naio

  • Rank
    always learning

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I designed a FM Go app that uses a bluetooth scanner (Socket CHS 7). I can't find the way to control the active keyboard (scanner or ios). I tried the "Enable touch keyboard" script step but if I hide the keyboard, I loose the focus on the field that must get the scanned code, so it's like having no keyboard. That seems to be the problem: https://community.filemaker.com/thread/136708 a bug not fixed yet? So far the only way to hide the ios keyboard without loosing field focus is to turn off the ios keyboard is from the scanner itself, clicking twice the power button. Once the active keyboard is the scanner, I still have the edit bar that shows on the top of the ios keyboard covering the bottom of my FM Go app: Do you know if there's a way to hide this bar?
  2. I've found the solution besides the privilege set: the problem was the custom menu set, I had disabled the whole 'Insert' menu, so the command 'Insert file' wasn't available neither in the contextual menu. So it wasn't about permissions
  3. I use a local solution database with layouts and scripts only and data files are hosted in FMS16 under OSX. I've created a container field on one of the hosted database tables, the storage settings are set to "Store container data externally" and "Open storage". From the solution file, with my full privileged admin account, I can right-click on the container field, select "Import file" and select the file to be imported. Everything works as expected, when I'm done I can see on the server folder that the file I've uploaded is there. However under a user privilege set, it is not possible to "Import file", when right clicking I just get Cut, Copy and Paste. How can I allow my users to import files? On the hosted database file, the 'user' privilege set allows them to create, edit and delete records in all the tables but they have no access to layouts (because these are hosted layouts they do not need to access).
  4. I'm about to start a solution that needs quite an amount of layout forms and I would like to create a consistent design based on my own custom theme that has already been developed in a separate file. I use Material Design specs as style guideline and the solution is build under the separation model, so all the data is in a hosted file. I'm considering one of these two strategies: Create a repository of interface elements (text fields, tab controls, combos, portals, etc.) in a separate file (that's mostly done) and copy generic elements into my solution as I build the needed layouts or Create layouts quickly, overlooking style and apply my theme when all of them are functional I see a drawback on the first option: if I want my element repository to continue useful I will need to keep the theme updates simultaneously in both files The second option looks more practical because it will allow me to focus on the data and just worry about the look at the end of the process. What do you think is the most productive strategy?
  5. My solution is build according to the 'separation model', so I would like to keep control of the local file containing the layout and presentation of the data hosted in the server. I wonder if I could have a script to control wether the local file gets its structure, layout or scripting modified, so I need a function to control when a change to the file has been made before giving it a version number. When the file gets open only to work with the hosted data it's not a new version.
  6. Got it, this video has helped me a lot: https://www.filemakermagazine.com/videos/filemaker-rest-using-baseelements-plugin
  7. I'm trying to integrate my FM solution with Freshdesk, a helpdesk web app that uses GET and PUT commands over HTTP. My first challenge is to retrieve a ticket from Freshdesk. According to the API documentation, all I need to do is (for ticket ID 200): curl -v -u user@yourcompany.com:test -H "Content-Type: application/json" -X GET 'https://domain.freshdesk.com/api/v2/tickets/200' I'm happy I made it work in Mac OS Terminal! but now I would like to use it within FM and the Base Elements plugin seems a good option, so I made the following script: Set Variable [ $header; Value: BE_HTTP_Set_Custom_Header ( "Content-Type" ; "application/json" ) ] Set Variable [ $get; Value: BE_HTTP_GET ( "https://domain.freshdesk.com/api/v2/tickets/200"; "user@yourcompany.com"; "test" ) ] I expect to get the json data into the $get variable but I just get user@yourcompany.com in it. The documentation for BE plug-in is not for newbies like me and there's something I don't do right. Can you help me with this or at least point me to a place where I can learn a little about it? Thanks,
  8. I need to update a solution designed for FM9 to FM15, the whole solution has 68 value lists (VL) all of them based on tables but only a few of these are conditional VLs. All of the tables have a primary key and a value field. The solution is designed according to the separation model. In the user file layout, each of VL data fields is duplicated so one field stores the value id (as dropdown list) and the other -just on top- shows the related value. This design requires a lot of table occurrences just to show related values which makes the graph and layout design more complex and tedious. As most of the lists are static (their component values will never be changed) I wonder if I should transform these lists into the 'Custom value' kind. Given that the design is quite robust like this, it seems unnecessary to change it but the gains on design simplification and clarity are very tempting. I would like to know the best practice using VLs. I would also appreciate your criteria about the use of dropdown vs the use of popup menu in the layouts.
  9. Thanks for your suggestions, I wonder if the applications you mention are able to run completely unattended, I mean launched at startup, not at login. Anyway I've taken the 'hard way' and I am working on a shell script to take my copies off the FMS machine into the NAS and then to somewhere in the cloud, if this way is too hard for my little knowledge of bash then I'll look at the apps you suggest.
  10. Thanks for this valuable script. Shouldn't the rsync command include the option -H? This would preserve hard links, which is important if you are backing up a large amount of files, for example those on a managed container field folder.
  11. Understood: there is no way to have FMS backing up to an external hard drive, period. I'll look for script models that allow copy or sync of the internal drive backed up files, I've seen a couple in the articles you linked. I still have a question: the use of progressive instead of the standard backups would it ease or shorten the task to 'move' the files out of the server? Thanks,
  12. In the linked article is not clear that not even a backup called from FMS CLI can save the files into a non-local folder, is this what you are saying? If so, the only way to take a standard backup off the server is by using a system-level script that copies the files, right? But what about FMS performing a progressive backup? according to FM Support: Does a different hard drive include a NAS? is it safe? Thanks,
  13. I keep a backup copy of my hosted solution (under OS X) in the default FMS Data/Backup folder. The backup is scheduled twice a day (noon and night) and I keep 5 versions of each copy. The solution includes nearly 100.000 pdf files in managed container fields (RC_Data_FMS folder), in total only these files take 10GB of disk space. I would like to follow the 3-2-1 backup rule so I should be storing 2 more copies of the solution, I would use a Synology NAS in the LAN, so my plan is: Keep the 2 daily copies stored in the Data/Backup folder, in the server disk (Done!) Have 2 more daily copies of the database stored in the NAS (pending) Have a progressive backup executed by night (when no users are connected), saved in a NAS folder and have that folder backed up in Dropbox or Amazon (pending) There are two issues to take in account: All the backups must run unattended, I mean without the need to log into the server. The server machine should be ready for backup just after start up. I have a limited knowledge of LAN administration and command line. So far I tried to: Sync the backup folder with the NAS using GoodSync: the software is not reliable, sometimes simply doesn't sync and their customer support is useless. I've heard of rsync a system utility that should be more reliable but I'm I don't know how to use it. Sync the NAS copy with Dropbox: Synology Cloud Sync utility is limited by the hardware, in my case 15.000 files is the maximum. To have 200.000 files syncing every day seems unrealistic Have a FMS progressive backup on a NAS shared folder: so far I haven't been able to give FMS access to the remote folder, I can't validate the filemac:/volume/folder/ path Following the steps in this article (http://www.soliantconsulting.com/blog/2012/11/filemaker-backups-network-share), set up a shell script that sends a backup to the NAS. The script -based in FMS command line- is executed by the default user and goes simply: fmsadmin BACKUP -d filemac:/volume/folder/ It doesn't work, I get "Error 732 Invalid account name or password" and I am not sure if it's the script or simply the access to the remote folder (the path is invalid for progressive backup). My questions: How can I make fmserver own a remote folder in the Synology NAS? Do I need to create the users in the NAS? how can I create a fmserver user without knowing the user password? The shell script above, for backing up to the NAS is it correct? In addition to the local backup, do you think a progressive backup in two media (the NAS and the cloud) is safe enough in case of disaster? In sum, can you help me set up a rock solid backup system for my solution?
  14. You nailed it Wim, a thousand thanks, again.
  15. I've a hosted database with a container field that contains pdf stored externally and open (not encrypted). The database has thousands of pdfs that were imported from a disk by a record-by-record script, those pdf can be seen from any fm client without problem. Now I've uploaded a pdf from a OS X clients, but the file doesn't show in Windows machines, instead I get a "file not found" message, but the files are there because they can be seen from the OS X client. I remark that the problem is only with the files that were uploaded manually using the command 'Insert PDF' from the container field contextual menu from an OS X client, all the other pdfs (imported through a script) can be seen from any client. I've seen a couple of posts about it in the forum but none of them seems to 'hit the nail'. Thanks,
  • Create New...

Important Information

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