Jump to content

Justin Close

  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About Justin Close

  • Rank

Profile Information

  • Gender
  • Location
    Salem, OR
  • Interests
    FileMaker, programming, soccer, hiking...

Recent Profile Visitors

8,231 profile views
  1. I have run into this error as well. It seems to only happen on Safari, though; Chrome and Firefox (yeah, I know - not official) don't show the error. In my case it only shows up briefly as the user is loading the WebD layouts, and then it goes away and the proper layout is displayed - so there is no loss of functionality.
  2. Diver, 2 things: First, your string of values must be in a specific format to function in the IN clause. Something like "23, 432, 523". If you are using strings in the values, they have to be quoted. A return-separated list won't work. Second, in your first example it doesn't look like you are correctly using the variable "$itemIDs" - you don't exit the FileMaker string-mode, so it is using the literal string "$itemIDs" and not variable replacement. Here's what it should look like: "...IN ( " & $itemIDs & " ) ..."
  3. Hmmm...maybe the page wasn't loading fully for me when I was starting it, because I didn't see all the various sub-forums lower down the page that I was expecting. It was just the first block, the 'FileMaker Platform' group, which is the 'General', 'Web Direct', and 'iPhone/iPad'. This specific instance is a FMGo deployed file synching to FMServer, but it seems that this issue with the modification time stamps being updated in an entire transactional block could happen in many different configurations. Not that I have tested that... This is one of those things that seems to cover so many a
  4. I'm having an issue with and offline sync setup that I created. I used the basic outline as described in the FM white paper for offline syncing. I'm using a transactional model for the whole sync process, so there is a final commit at the end if things don't throw an error. It is this final commit that is currently giving me problems. When this commit fires, all of the records that were created during the sync process are once again tagged as being 'modified', and so the modification timestamps are updating again. Here's an example: say I sync 3 records at 22:43. During the sync process
  5. Olger, I have run into this issue a few times with Selector technique as well: you can't create new records in a table if there are no records in that table to begin with. Yes, this is a situation where the Source and Target tables are the same base table. The root cause of this problem is the fact that without a record, it can't evaluate the relationship to the Selector TO. At least that's my understanding. And this happens if you have a found set of 0, too. So you can't fix it by just having ANY records in the table, but you have to be showing a record. In my current scenario I
  6. Ah, clever! I was wondering how a file might be deleted from the device. I like it!
  7. Thanks Barbara for pointing me at EasyDeploy. I ended up implementing the EasyDeploy parts from EasySync and got it working in our solution. There are more moving parts but it is working well, where-as One-Click was giving me the errors mentioned in my original posting. I was able to get One-Click to work using their demo files, so I don't believe that it is a technique. I actually kind of like it better from the point of view that it has fewer moving parts and less debris (EasyDeploy leaves a stray file on the device that is visible on the 'Recent' and 'Device' file lists in FMGo). There
  8. Well, no dice so far. I have tried a different server, one that doesn't have a PW protected list of files, and that didn't work. Just to be sure, I tried the vanilla files on the client's server and that DID work. I also tried deploying the vanilla 'mobile' file from the client's solution, and that also DID work. I then copied all of the original scripts in from the vanilla file to my file, only make some minor changes to try and make sure I hadn't messed up anything there. (I do have to make some changes as the server name is different, I had a different file name for a while, etc.) Tha
  9. Has anyone ever implemented the update-in-place technique from Colibri Solutions? http://www.colibrisolutions.com/2011/08/24/one-click-updating-of-a-filemaker-go-solution-on-a-mobile-ios-device/ The general outline is that the infrastructure is all in place in a deployed file and a hosted file. The deployed file is opened on the iOS device; from inside that file you hit a button to start the update script, which then does all the heavy lifting. The trick behind this technique is to start an on-timer script on the device, and then close the file on the device. The on-timer script apparent
  10. Ah, I think I get what you were originally saying: the customer sees the initial ID generated in the field, and perhaps not the one generated by the central system. But as you were also saying...then why need a new central ID? Erm...guess it doesn't really matter if there is a new CentralID as long as the ID generated in the field is unique and human readable. If it's unique across the system, including other offline, in the field generated numbers, then it solves the problem. That's the real root of the question - how to generate those numbers and keep them unique? I believe the idea be
  11. Yes, they all end up back on the server eventually (within a few hours or a day most likely). The salespeople are out driving around, visiting potential clients - they are selling ad-space. Yes, I think a TempID and FinalID, both persistent, is a good idea. But wouldn't you want the customer to have the OrderID? They could have multiple Orders over time. Makes them feel more...secure or certain? The idea was to generate all this on the iPad, have the customer sign it even, and give them a receipt/invoice of their Order all at the same time. Immediacy, not having to wait for othe
  12. Do folks have recommendation on setting up a system for creating regular, human readable and consumable, IDs with an offline/online-sync and hosted solution? The offline part of the solution allows full creation of new Orders. These Orders will (should? could?) have an OrderID will be visible to the customer and given to them on an invoice at the time of creation in the offline world. (The invoice is generated along with the order and will be emailed to the customer, so the OrderID will be there.) But someone else in a different offline copy, or someone who creates an Order on the server,
  13. Salim, I'm a bit late to the party on this one, but you could start with what Kris was saying: unhost the file from the server. However, it sounds like you want to work on the file while you aren't connected to the host. For example, your host server is somewhere safe and sound, but you want to work on the file at your home or on your laptop while you don't have a network connection. Is that right? You didn't mention what version of FMServer you are using. I will assume 14 for now - other versions can do this same thing but with a different series of steps. For FMS 14, I would close t
  14. Hey Cable (Dan), A very interesting post; thanks for taking the time to write this up and to put metrics on your efforts! We have just done a very similar thing to yourself: had a client that had a need for offline iPad use, but wanted to sync with the home-server when they had a good WiFi connection. We also rolled our own sync mechanism, using (it sounds like) very similar techniques: a connector file to establish the link to the host file and then a script that does field-by-field copies. We went with field-by-field because we wanted to take advantage of transactional methods (i.e
  15. I'm having a bit of an issue with an ESQL query. I would like it to always return 2 decimal places on the value retrieved. This is a currency field, and "$45.5" looks weird. I am generating a list of payments to displayed (via a global variable in the UI) to the user, so it should look money-like. It's a simple 'here's what you currently have set up' kind of display. So here's the basic query (I believe folks here are familiar with the GFN() and GTN() functions - they are just a way to robustify the query in FileMaker): ExecuteSQL ( "SELECT '$' || " & GFN ( Payments::Amount ) &am
  • Create New...

Important Information

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