Jump to content

TJ53

Members
  • Content count

    159
  • Joined

  • Last visited

Community Reputation

3 Neutral

About TJ53

  • Rank
    member

Profile Information

  • Title
    Consultant
  • Gender
    Male

FileMaker Experience

  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    El Capitan

FileMaker Partner

  • Certification
    9
    10
    11
    12
    13
    14
    15
    16
  • Membership
    FileMaker Business Alliance

Recent Profile Visitors

2,760 profile views
  1. Hi, we have a “log” table where a new “session” record is created when a user enters in the system, and when closing the database the is edited in order to keep the timestamp when the user enters and exit. This way we keep track of database usage time. The problem is when a user gets disconnected from the server (lost internet connection, or some issue with iPhones or iPads). Is there any way to get the approximate time when a user gets disconnected? is there any workaround to know how long a user has been connected to a database after loosing connection? Any tip would be appreciated, thanks!
  2. I didn't find a way to use a path ... it seems that it only works with container fields.
  3. I´m not sure why but the WV shows the correct result in some computers and devices, but in other just shows an empty page (please see attached file with WV including code). This is the result after testings: - It doesn't work on my Mac (10.11.06) - It works on my iPhone - It works on my iPad - I works on one of my colleague´s Mac (10.12 I believe) - It doesn't work on another collegue's Windows I have attached the file with the wv, is this working for you? any clue why this is happening? any help would be very much appreciated!! WV_Table.fmp12
  4. TJ53

    PSOS Export Records Error 800

    Thank you for the tip. Yes, this is used to then import into a temporary table for running a report, that is faster than a loop. It works fast enough now (it takes about two seconds), but I'll consider your suggestion for the future, thanks.
  5. Hi, when using the FTP upload function: BE_FTP_Upload ( url ; data {; username ; password } ) Can "data" be a path to a file in the local drive? or otherwise it can only be a file inserted in a container field?
  6. Hi, is it possible to install FMServer 16 in the Essentials version of Windows Server 2016?
  7. Hi, I have the Troi file plugin installed (FM 13 Windows 7 Home) and when using the "select folder" function the network drives don't show as selectable. This works well with Mac though. Since I thought it was something wrong with the plugin, I installed Base Elements plugin and used the equivalent "select folder" function. Same result, the network drives are not visible in the select folder dialog. Then I installed FM 14 in the same machine and the problem disappears: with the Troi plugin function "select folder" the network drives appear as selectable and folders can be created using the plugin in that network drive. Any clue why this can be happening? the only thing I can think of is (I believe) FM 13 is 32 bits on Windows but FM 14 can be installed for 64 bits. Any help is appreciated, thanks!
  8. TJ53

    PSOS Export Records Error 800

    Thank you very much! that was it, I just learnt about that and was about to post it here... I changed it to export as xlsx and it works perfectly.
  9. Hi, I get error 800 in the "Export Records" script step when executing it as PSOS. The file path is set in a variable ($path) as a calculation: Get(TemporaryPath)& "tmp.fmp12" This script works well when executing it to save the file to the local temporary folder (OS X El Capitan), but returns an error when executing it as PSOS (Windows Server). I believe it can be a permissions issue, but I thought the temporary path was accesible from FM Server "by default". Anyway, any insights are appreciated, thanks!
  10. Is there a way to use JSONPath with FM JSON functions? it would be great if I could use wildcards.
  11. Thank you! the exit script (false) on record commit script trigger comes handy for this situation. Thank you for the tip about GTRR, I was thinking on a situation where the portal record needs to created or updated from different contexts.
  12. I guess people are using a similar technique for creating and editing portal records after the new FM16 card window feature, any posts or links about this? In any case, this is how I'm doing it (sample attached) ... any feedback appreciated! Create or edit portal records.fmp12
  13. TJ53

    Virtual list using JSON

    That's some great information to take into account, thank you!!
  14. Thank you for the tip! I'll definitely keep it in mind.
×

Important Information

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