Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


mkos last won the day on February 17 2015

mkos had the most liked content!

Community Reputation

2 Neutral

About mkos

  • Rank

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

1,937 profile views
  1. Hi, I'm using Zulu v3. The "Publish Calendar" script opens a web page and instructs the user to log in with a full access account. Can this be set up to work with a non-full access account? Likewise, when setting up a new sync configuration in the Zulu admin interface, the admin has to specify credentials for a FileMaker account. Can we use a non-full access account here?
  2. I recently encountered this issue. Here's what resolved it for me: I re-ran the Deployment Assistant, turning ODBC off. I then re-ran it again, turning ODBC on. I'm not sure if this was needed, but prior to running the Deployment Assistant, we asked the users to log off and we closed the database files, so that they were no longer hosted. My FMS version:
  3. Barbara, FWIW, syncing open stored containers using EasySync seems to be working fine for me.
  4. I have a container field that's configured to use External Secure storage in the hosted file. When I sync a PDF that's stored in that field in the mobile file, it gets pushed up to the hosted file without any problems. But if I then modify that record on the hosted file, for example by changing a value in one of the text fields, and then sync again, the record gets pulled down to the mobile file, but the container data (in the mobile file) gets corrupted. When the container data is valid, GetAsText ( MyTable::MyContainerField ) returns something like this: remote:Transfer Request.pdf PDF :Secure/0D/63/4D03FB8E/064665D1/C08FFD43/C64C After the sync, it returns just this: C64C Changing the storage from Secure to Open fixes this problem, but the documents contain sensitive data, so that won't work. A workaround would be to embed the documents internally, but it would be better to have them stored externally. The Open Issues page talks about issues with compressed containers. Is that what's going on here too?
  5. 502 is "number value does not meet validation entry options", so it sounds like one of your number fields has some validation on it that's causing the problem. I would try to figure out which one exactly. One way to do that is to add the "EXCL_" prefix to the names of all your number fields. Try to sync then. If it works, then systematically start removing the prefix from the names until you find the problem field. This is a bit tedious of course, so a slightly faster way to identify the problem field might be to modify the SQL in the script that figures out which fields to sync. Assuming that the error is occuring when pushing data from the mobile file, you could modify the "Push Payload" script in the mobile file. Look for the comment "Get the names (and # of reps) of the fields in this table" and modify the Set Variable [$sync_fields] step below it. For example, if your number fields are names "Amount", "Units", and "Height", then you could modify it like this: Original: ExecuteSQL ( "SELECT FieldName, FieldReps FROM FileMaker_Fields WHERE ( TableName = ? ) AND ( ( FieldClass = 'Normal' ) OR ( FieldName LIKE 'B64_%' ) ) AND ( FieldName NOT LIKE 'EXCL_%' ) AND ( FieldName <> 'ES_Exclude' ) AND ( FieldType NOT LIKE 'global%')"; "|"; ¶; $sync_table ) Modified: ExecuteSQL ( "SELECT FieldName, FieldReps FROM FileMaker_Fields WHERE ( TableName = ? ) AND ( ( FieldClass = 'Normal' ) OR ( FieldName LIKE 'B64_%' ) ) AND ( FieldName NOT LIKE 'EXCL_%' ) AND ( FieldName <> 'ES_Exclude' ) AND ( FieldType NOT LIKE 'global%') AND ( FieldName NOT IN ( 'Amount', 'Units', 'Height' ) )"; "|"; ¶; $sync_table )
  6. I was getting this error but am not any longer. I discovered that I didn't copy over the contents of the EasySync_Payloads layout on the hosted file correctly. The 504 error hasn't shown up ever since I fixed that layout.
  7. I am also getting this error. I have an ID field in my table which is configured to auto-enter with Get ( UUID ) and which had "Require Unique Value" turned on. When I modify a field in a record in the mobile file and try to sync, I get the 504 error during the push-to-server part. When I turn the unique value requirement off, the sync goes through without errors, but a duplicate record is created in the hosted file. My ID field and the ES_Record_UUID field both have duplicated values in this new record. I am using EasySync v1.2. I double-checked that the relationship from the EasySync table to my table is set according to the documentation on both the hosted and the mobile files: EasySync_Payload_Details::ES_Child_Record_UUID = ES_MyTable::ES_Record_UUID.
  8. Tim and whoever else is involved - thanks for making EasySync available for free. I turned the ES_Exclude field into an unstored calc (per instructions in http://fmeasysync.com/docs-easysync-integration/) so that certain records can be excluded from the sync based on the user's privilege set and account name. However, now if user A logs in on their iPad and syncs, and then user B logs in on that same iPad and syncs, there may be some records whose ES_Exclude values will now be 0, but they won't get picked up if nothing else about that record changed, because the ES_UTC_Time field won't have been updated. (It gets updated when a record is modified, but since we changed the ES_Exclude field into an unstored calc, the changing of its value doesn't trigger ES_UTC_Time to update.) Turning ES_Exclude into an auto-enter calc (instead of an unstored field) won't work, because it's value depends on the account name of the person who's logged in; i.e. it's a session-based value. Two people syncing simultaneously with the hosted file could have two different values in that field. So it seems that if ES_Exclude is an unstored calc, it won't work to have multiple users using the same mobile device. If they do, then the user logging in second might not get all his records. The only way to make it work then is to pull ALL the records again (change $$sync_method from Merge to Replace in EasySync Settings script) whenever the user logging in is different from the last time the mobile file was used. But the problem with that is that doing a full sync takes quite a long time to complete in our situation. Or maybe I'm missing something. Is there some other way to make this work?
  9. Thanks for the post, Steven. Do you know if enabling Encryption At Rest will have any performance impacts?
  10. Thanks Michael, this is helpful. A followup question. A part of your instructions says to stop SuperContainer. How do I do this? (I have SuperContainer installed with FMS13 – i.e. not as a standalone application – on a mac.) Is it simply a matter of stopping the web server that FileMaker Server installs? (Which, in case this is helpful to others, on the mac is done as follows: open terminal, go to /Library/FileMaker Server/HTTPServer/bin/ and type sudo ./httpdctl gracefulstop .. to start it back up, type sudo ./httpdctl start)
  11. I renamed the "FileMaker Pro Advanced.app" file in the Applications folder to "FileMaker Pro Advanced 13.app" so I can distinguish it when doing command-tab.
  12. This is in reference to the Soap Client (http://www.360works.com/soap-client/) which 360Works provides for testing. (Thank you, btw.) When I enter in the WSDL URL and click Retrieve, I get this message: java.lang.RuntimeException: Could not find the java compiler at /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/javac.exe. You only have the JRE (Java Runtime Environment) installed Unexpected error As an example, let's use this WSDL: http://www.webservicex.net/stockquote.asmx?WSDL I am trying this on a mac (10.7.5). I have java 1.7.0_25 installed here: /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/ Per the instructions, the lib directory and SOAPClient.jar file are in the same directory. Any ideas?
  13. I stored a PDF in DocuBin. The text from the PDF is stored in the "_c_Text" field in table "Version". For the PDF that I'm using, the resulting text in _c_Text has all sorts of invisible characters which I would like to remove. Btw, the file I'm referring to is the standard Apple "About Stacks.pdf" file. I've uploaded it here, although I don't think this problem is due to this particular PDF file. These characters aren't visible in a text editor, but if you use the arrow key to move across the text characters, you can tell they're there, because the cursor all of a sudden stops moving. In TextWrangler, if you turn on 'Show Invisibles', the characters are shown as "?". In a Hex editor, they are shown as 00. I tried using char ( 0 ) and the Substitute FileMaker function, but that did not work. Can you provide a way to get the scanned (OCR'd) text that is stripped of these invisible characters? Thanks. About Stacks.pdf
  • Create New...

Important Information

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