Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About DataCruncher

  • Rank

Recent Profile Visitors

2,324 profile views
  1. Well I fixed it! It was a little workaround - I basically broke it down in two steps: 1) establish a relation between Client in the Orders table and Client in the Assignment table. 2) Then use ValueCount ( FilterValues ( List (Assignment::Agent) ; $$accountname ) ) to filter the related records... I hope this helps someone.
  2. Mirrorsync 4.0027 I have dealt with many an error 502 during initial sync with earlier versions of FMS - 12,14,15. The easy fix was to simply increase the PoxyPass timeout in /Library/FileMaker Server/Admin/admin-helper/WEB-INF/conf/mod_proxy.conf. The problem now is that FMS18 does not have /Library/FileMaker Server/Admin/admin-helper/WEB-INF/conf/mod_proxy.conf. Any guidance here, please? I remain very confused why a mirror copy of the same database file needs to sync well over 5000 records on initial sync, BTW. Thank you!!!
  3. The first part is correct. However, in the second part when Orders::Agent is empty, record should ONLY show what that oder is from a Client that would match a specific Assignment::Client-Assignment::Order record. If I have agent Senior and agent Junior, Senior may see all orders from Client A, B, C, D, E but agent Junior may only see orders from Client C and E. The Assignment table would thus contain records: Agent - Client Junior - C Junior - E Senior - A Senior - B Senior - C Senior - D Senior - E I hope this outlines my problem more clearly? Thank you!
  4. Wow. I was unable to make this work - I need someone to help guide me in the right direction, I figure it should be easy enough. Here is an example of what I need to achieve: - Imagine a simple online ordering system. - I have a table called Assignment where I have records with two fields: Assignment::Client and Assignment::Agent. The idea is every agent can work with only certain clients. I use the agent's account name to create this table. If a matching Client-Agent record exists, the Agent shall be able to see orders from that client; if no such record exists, then the agent should not see that client's orders. Throughout my solution, I use $$accountname for the filemaker username. - In my Orders table, a new incoming order does NOT have an agent assigned yet. Orders::Agent is empty. That means I can't yet establish a relationship to decide which orders to show to an agent. - I need to create an order inbox where every agent should only be able to see the new orders from Clients that agent is 'credentialed' for in the Assignment table. So these are the approaches I have considered already but was unable to get to work: - A relationship to the Assignment table. This approach does not work as the incoming case does not have the Orders::Agent field populated yet. - An ExecuteSQL statement which, in theory, should work but as I have 300k records in my database, I found it slows down FileMaker Server too much for some reason. Plus, I did not get it to work properly. I tried ExecuteSQL ( "SELECT COUNT ( ID ) FROM Assignment WHERE Client=? AND Agent=?" ; "" ; "" ; Orders::Client ; $$accountname ) but this returns '?' only I am sure there must be an excellent and straightforward way to get this to work, but I am at a loss. Thank you for any suggestion! DataCruncher
  5. Just to follow up, this was resolved by removing the entire FileMaker installation and re-installing with all current versions of plugins. Works just like it used to!
  6. I am investigating this further - it seems to be not isolated to Catalina; but instead to FMPA 18 on Mac. There may be something different in how Filemaker 18 handles the rendering of the web viewer component; it seems the web viewer is caching some information.
  7. I am having a similar issue - only I don't think word document encoding is to blame. When I run Scribe FileAsTxt on the .docx file locally, I get the correct readout. However, the very same directive, on the very same .docx run on a server side script, returns the PK0????[Content_Types].xml???N?0?_??%.,?j??K@???3i ??=???3N B?m??D?g?9_?2?^[?? &?]??? g??o??W???]q?YB?i???o ????y 1ҺT?b?#DR?2?>??J룕H?q.?T?r?b2??;?f>??@+??]?z??-g?ƜUqm?????]?|?(???7??h% kind of output. Is there anything else I am missing? The .docx file is stored in a SuperContainer location.
  8. I have a web viewer in my FMP solution that I run on FMPA 18 on macOS. When I ran it on High Sierra, everything worked just fine. Since I upgraded to macOS Catalina (I know, I know...), the web viewer does not handle changes to the Supercontainer contents well. For instance, when I hit the delete button, the SuperContainer deletes the contents, but the web viewer will still show the old word document. This may prompt the user to hit the delete button again, when SuperContainer will throw an error because no file is there to be deleted? Worse, it will still show the old file when in fact the SuperContainer is empty. I am able to manually fix it by force reloading the web viewer - but that' s not the behavior it had before. My SuperContainer Server is a tomcat8 instance that works fine on all non-Catalina client machines. As the web viewer is rendered through a Safari component, I am wondering if Safari is now caching something it is not meant to cache in conjunction with running Supercontainer on FMP 18 on Catalina? Thank you for any hint as to why this is happening!
  9. I have downloaded the lates Java version for Mac, Java 8 Update 231. All of a sudden, none of my plugins will load? I have Scribe, SuperContainer companion in the latest versions but they simply won't show under plugins? What am I doing wrong?
  10. Before I try this I want to run this by someone who is more experienced than I am: Syncing 4 Filemaker Servers one on each continent, with about 20 sync layouts on each machine. Let's call my synced Servers FMS1, FMS2, FMS3, FMS4. One of my sync layouts, let's call it sync_LOTSOFDATA, contains large text fields. However, only FMS1 and FMS2 need to sync sync_LOTSOFDATA. Currently, all that data is also synced to FMS3 and FMS4, where I don't need sync_LOTSOFDATA. Can I just delete the sync_LOTSOFDATA layouts on FMS3 and FMS4, but still have MirrorSync continue to sync sync_LOTSOFDATA between FMS1 and FMS2, while syncing all remaining 18 sync_LAYOUTS between all 4 servers? I guess my question is as to how MirrorSync behaves when a sync layout is missing on one of the FMS machines - skip and continue with the remaining servers - or halt and die? I would equally not be surprised that if I deleted all fields from the sync_LOTSOFDATA layout on FMS3 and FMS4 only in an attempt to selectively spare the extra sync effort to FMS3 and FMS4 only, MirrorSync would then interpret these missing fields to trigger deletion of all records on sync_LOTSOFDATA on FMS1 and FMS2 also? Lots of concerns here. I'm mainly asking because MirrorSync likes to stop altogether if one of the four FMSx machines drops offline rather than to keep syncing the remaining three FMSxs until the failed one comes online again? Thank you!
  11. So SuperContainer works well for us. That is, when you finagle the upload and download matters for Word Documents and then edit said document in an offline Word version. The problem now occurs more and more access to our website is from iPads and other mobile devices, which naturally lack a proper filesystem and Word applications on these devices, leaving us stuck. Is there any good website embeddable MS Word compatible online editor that will our users to edit the Worddocuments we have stored in supercontainer to be edited online? I am struggling to find a good answer myself as most of the 'online Word editors' yield results about google or Microsoft services that work with documents in the respective cloud. What I need is a plugin that we can run on our own server infrastructure. Any advice is appreciated! Thank you
  12. I just realized 360works has an email plugin. Do you think that could help me attach my files server-side?
  13. HELP! This is driving me nuts. Need to send emails with an attachment from server side script. The attachment path calculates correctly, as far as I can tell. Permissions are 777 (I Know...), but the file still does not attach! This is the variable calculation that yields the path: "/Samsung SSD/Library/FileMaker Server/Data/Documents/"&$filename Only problem is: attachments don't attach! I have tried every iteration I could think of: "filemac:/Samsung SSD/Library/FileMaker Server/Data/Documents/"&$filename "/$filename" "<Documents>/"&$filename What am I missing here??? Thank you!! I can't believe I'm the only one who ran into this issue?
  14. That worked for the download part- the file now correctly downloads to the folder. However, when attaching to the attachment path, it still does not attach. I have no idea how to track the problem down here. The $path variable correctly comes through as: filemac:/Library/Filemaker Server/Documents/TEST.docx Only it does not attach.... This is on FMS18 on a Mac.
  15. Well look at that: java.lang.IllegalStateException: Could not create directory: /Library/FileMaker\ Server/Data/Documents But the directory already exists. Weirdness. Also, all permissions are set properly. I am wondering if I am not escaping the empty space in the path correctly? Solved the download part of it. The file is now stored in Documents/Filename. This path is then set as a variable: $path="file:Documents/Filename" Only, when I add $path as attachment path to the send email server side script, nothing is attached?
  • Create New...

Important Information

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