Wim Decorte

Moderators
  • Content count

    5,210
  • Joined

  • Last visited

  • Days Won

    132

Wim Decorte last won the day on April 21

Wim Decorte had the most liked content!

Community Reputation

430 Excellent

4 Followers

About Wim Decorte

  • Rank
    member
  • Birthday 12/17/1968

Profile Information

  • Gender
    Male
  • Location
    Toronto

Contact Methods

  • Website URL
    www.soliantconsulting.com

FIleMaker Profile

  • FM Application
    15 Advanced
  • Platform
    Cross Platform
  • Skill Level
    Expert
  • Certification
    7
    8
    9
    10
    11
    12
    13
    14
    15
  • Membership
    TechNet
    FileMaker Business Alliance
    FIleMaker Platinum Member
  • Title
    Sr. Technical Architect
  1. Of course it is working, for most people under most circumstances. Since this is an integration there are always a lot of different variables involved that can run interference especially in a Citrix environment that multiplies the number of moving parts. Do a search on this forum and other forums for 'server busy'; it is something that has come up for other people.
  2. to expand on that; you have this isEmpty ( Sub9First_Semester or Sub9Second_Semester) this part: Sub9First_Semester or Sub9Second_Semester will result in a boolean result; 0 or 1, so it will never be empty
  3. You may consider at least getting FM16 and getting familiar with all the features; because at some point you'll have to switch strategies and when you must, that would be a particularly bad time to have to catch up on what there is...
  4. Try to format your formula so that it is easier to read and follow: Case( Sub1E1 = ""; ( Sub1Q1 + Sub1Q2 ) / 2; Sub1Q2 Sub1E1 = ""; Sub1Q1; Grade_Level ≥ 11; ( Sub1Q1 * .4 ) + ( Sub1Q2 * .4 ) + ( Sub1E1 * .2 ); Grade_Level < 11; ( Sub1Q1 * .45 ) + ( Sub1Q2 * .45 ) + ( Sub1E1 * .1 ) ) The 2nd test in there: is "sub1q2 sub1e1' one field name?
  5. @comment mentioned the solution already; since you don't care when you increment; just a have a scheduled script that runs on January first and increments the age field by 1. If you want to use that new field you just created then create a nightly schedule that does the same but just for those records where that date field is exactly a year ago. Do a search on that new date field for Date( month(<your date field>) ; day( <your date field> ) ; year(<your date field>) - 1 ) If you find records then loop through those. If no records are found, exit the script.
  6. You have a 'parcels' key/node that is not correct. It should immediately start with an array as per their API, you start it as another piece of JSON with another 'parcels' key name
  7. and if you want to keep it more readable and at the same know what options are supported in FM, you can use this: https://community.filemaker.com/docs/DOC-8177
  8. If you take that piece of your code and put in the data viewer it will tell you what is wrong. Look at the output and compare it to what is required. Some quick ones: - you don't need the ampersand after the first -H - you don't add spaces between the different sections
  9. Agreed. It usually does not take 360 attributes to describe something. And having that many calculated fields will end up being some performance problem somewhere along the line. So instead of helping you do that; describe what that table is all about and we can probably help you with a better solution.
  10. What kind of unproductive statement is this? You do realize I hope that this just antagonizes? I'm assuming that you are frustrated; if so then say that instead of making these kind of statements. Having said that, of course there is beta testing. But beta testing is no guarantee that there will be no bugs or unintended behaviors.
  11. We'd need more information about the actual call, the configuration, the FM file, etc. I did a test a few weeks ago to compare the new FMS16 Data API to the XML API for speed and was asking for 10,000 records. No errors. So I don't think it is the # of records necessarily that is causing this. What is the result if you just use the -findany command?
  12. You have to uninstall FMS14 before installing FMS16 and provided you configure it the same way (all the settings) then the files will be have exactly like they did before. As to where the files actually reside; I'm assuming that you are talking about the Remote Container feature/ If so it really all depends on how you configured the container field and FMS.
  13. Do you really want to get 1000+ records in one go? Is this for a user-facing routine?
  14. That's not how I understood @rondawes's setup. Commercial hosting is where clients upload & host their own files on your infrastructure. And in that scenario: yes: each client will need their own FMS and license. But if all clients use rondawes's solution then it is not commercial hosting of the type that FMI restricts.
  15. No, the old concurrency is still there. On the their website, follow the 'legacy' link.