Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


naio last won the day on March 2 2020

naio had the most liked content!

Profile Information

  • Slogan
    always learning

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

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

naio's Achievements


Enthusiast (6/14)

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

Recent Badges



  1. Thanks for your reply, it's not that I didn't think about your suggestion but the latest version is sold bundled with a lot of stuff I don't really need, and it's not cheap.
  2. I have FMDataMigration version, I haven't used it since long ago, do you know if it works well with files created by FileMaker 19?
  3. My solution is hosted in FMS on a Mac and there are a couple of Windows 10 clients. Some layouts include container fields set up to display PDF files (optimized for interactive content). Those pdf files are stored externally in the server but clients run the solution through a local file. Under Mac it's all right, but under Windows 10 it's a nightmare: it happened before, suddenly those PDFs don't display and it all seems caused by a software update (I can't tell if it's Windows 10 or Adobe Reader). The error message comes from Reader: "There is a problem with Adobe/Reader. If it is running, please exit and try again. (507:507)" it is not running alone, only through FileMaker. I remember once I fixed it by downgrading Reader to an older version but this time it doesn't work. So I thought of displaying them through a web viewer instead of a container field, I set it up this way: "data:application/pdf;base64," & Base64Encode (myFile::pdfContainer) This works in Mac but not in Windows, I conclude that there is no difference between using a web viewer or an interactive container, the problem seems to be Adobe Reader. Do you know of a robust solution to display those PDF files stored in container fields in Mac AND Windows?
  4. Finally, after a couple of weeks researching, I've got a reply from FileMaker Support: it's a bug in FMS, it happens with a hosted file related to another hosted file using fmnet:. The workaround is to use file: instead, however this prevents to have the external file in a sibling folder.
  5. I've tried to reproduce the issue with a brand new file: I've made the same relationship with the problematic 'not-properly-sorted' field which is hosted in FMS. When I created the new file in my machine, sorting worked as I expected. Then I uploaded the new file to FMS, and sorting didn't work (at least not the same way as local), as you can see in the enclosed screenshots: Local file, the 'id' field was filled as records were created. In the first image it is unsorted in the second is sorted by the 'engagement' field, it looks all correct. The file now hosted and sorted by the 'engagement' field only, please note the sorted icon in the column header: FMS hasn't found any problem after verifying both hosted files. You're right about the difference of expectations between me and FileMaker, it happens very often , but you'll agree that sorting should work exactly in the same way regardless of the file being local or hosted, otherwise I'd love to learn why.
  6. It's been a while for me using FM, I've always sorted records by a related field and got records sorted without problem. Today this doesn't seem to work, execute 'Sort records' changes the initial sort order but they don't get properly sorted. This is happening in table view with records from two files hosted in FMS. Any idea of why this may be happening? Thank you in advance.
  7. You're absolutely right, I'm discovering the world of JSONSetElement with brackets, already got rid of that JSONFormatElement... Thank you,
  8. Oops! you are right, actually those characters are in the source data but invisible within FM. Regarding the use of JSONSetElement: I think that, for large JSON objects, JSONFormatElements avoids the nesting of several JSONSetElement functions. Anyway I'll consider your advice. Thanks for your help!
  9. The content of myField is: text before quotes "quoted text" and I want to format a JSON object: JSONFormatElements ( "{\"object\":\"" & myTable::myField & "\"}") the quotes within my data make invalid JSON, so I escape quotes: JSONFormatElements ( "{\"object\":\"" & Substitute ( myTable::myField; "\""; "\\\"") & "\"}") Then I get valid JSON like this: {"object" : "text before quotes \"\u0016quoted text\u0016\""} I wonder where these \u0016 characters added around the quoted text come from, I don't want them there How should I escape quotes without this problem?
  10. This issue seems related to Windows 10 file permissions because I've tried to run the script under a windows admin account and it worked well, so it doesn't look like a FileMaker problem but I'm completely lost. jaboda: Thanks for the filewin tip anyway.
  11. My script in a hosted file needs to export records as pdf into the user Downloads folder, needs to run under Mac and Windows, so I set the variable $path_filename to: Case ( Get ( SystemPlatform ) = 1; "filemac:"; Get ( SystemPlatform ) = -2; "filewin:"; "file:" ) & Substitute (Get (DocumentsPath); "Documents"; "Downloads" ) & "file.pdf" And then: Save Records as PDF [With dialog: Off; $path_filename ; Records being browsed ; Create folders: Off] The script it works in Mac but not in Windows: I get an 800 Error and a message warning that it can't create the file. I don't get what's wrong with the windows version, any idea?
  12. Again, another picky API: https://developers.sendinblue.com/reference#updatecontact With this PUT command, I can't find the way to send the --data parameter to the server. These are the cURL options I'm using: --request PUT \ --header \"accept: application/json\" \ --header \"api-key: " & $$my_api_key & "\" \ --header \"content-type: application/json\" \ --data @$parametre I've tried to set the $parametre variable to: JSONSetElement ( "{}" ; "emailBlacklisted" ; True ; JSONBoolean ) JSONFormatElements ( "{\"emailBlacklisted\":true}" ) and simply: "{\"emailBlacklisted\":true}" none of these options satisfies the server, which always returns the following error message: {"code":"bad_request","message":"Input must be a valid JSON object"} There may be something wrong in the syntax of the --data parameter but I can't find what it is. I've also tried to quote the parameter: with single quotes --data '@$parametre' and escaped double quotes --data \"@$parametre\" None of this seems to work. I'm completely lost...
  13. I have a master table that needs to calculate the total value from many fields in a related, child table. The total must be shown –not necessarily stored– in the master table layout. I wonder what's the best option: Create a non-stored calculation field in the master table with Sum (child::value) or Just display a child table summary field with the total of child::value Both options seems to work but I would like to know if there's any difference in performance, is option 2 better than 1?
  14. I didn't mean import into another file but import between tables in the same file, so shortening the "export/import" process. Export to temporary folder and importing afterwards is fine, at least in csv format.
  15. Although I haven't read it in any documentation, it seems that FileMaker Server cannot handle self imports, so I had to export and import to and from a temporary file.
  • Create New...

Important Information

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