Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About TheLagosChap

  • Rank
  • Birthday 09/07/1965

Profile Information

  • Gender

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  1. Thank you Joshua (and Jesse). That re-opens the option for us. We still need to think about the (obvious) need to have the modification timestamp field updated for the record to be considered in the sync. But if our calculated field value changes due to a field value change in another table, the modification timestamp will have not been updated and the record will not sync. So it appears that to be sure any changed calculated field value is synced, we would have to forcefully modify the modification timestamp for ALL records in the table. That would defeat the principle of "sync"
  2. Thank you Joshua. I understand and it's not what I hoped for but what I expected We're actually trying to expose FM data to Microsoft Power BI and of course the unstored calculated field values don't get there by themselves. So we were thinking of putting a database in between (another FileMaker or some SQL - with stored data fields only) and use MirrorSync to transfer from solution's database to the intermediate source for PowerBI (transferring unstored calculations into stored data fields). Since we'd rather not duplicate all fields if possible (it's going to be a big da
  3. Hi Forum, Can anybody point me to the right direction on getting FileMaker unstored calculation field values synced into (any sort of) SQL database (one way sync)? I understand that unstored calculation fields do not contain any stored data and their value can be dependent on a Filemaker context (including relationships, global variables etc)... Rather than scripting some export from FileMaker itself, could MirrorSync do the job somehow? Thank you Serge.
  4. Hi Is there any way (Applescript, SQL via Filemaker ODBC or anything else) to automate the modification of a Filemaker database schema? I know that SQL CREATE TABLE and ALTER TABLE are possible but I am also looking at creating/modifying RELATIONSHIPS between tables. I do not think this is possible via SQL. The purpose is to automate the upgrade of a Filemaker database (vs. repeating each change manually using the "Manage Database..." dialogs). Thanks!
  5. Unfortunately there is no such option/tool at the moment. I recommend you look into the Separation Model. Updating a solution (UI, Business Logic) without changing the user's data one of the benefits of that design approach. There's a separate topic in the forums dedicated to the Separation model.
  6. Hi, I've been reading a lot recently about the separation model as I would like to develop a Filemaker application that needs to run on a (slow) WAN. I have found one "purist" approach that aims at avoiding anything else than just data in the data file, avoiding anything like calculations, summary fields etc This requires what I see as significant cost (work) in the User Interface file in order to reproduce the same functionality (additional local tables, fields, relationships, even mirror tables...) A very good example of this is shown in the videos from filemakermagaz
  7. WORKS! Thank you! I thought I knew a few things about Filemaker but I'm happy to say we all learn everyday.
  8. This sounds a very promising idea! I'll try it out and revert. Thanks!
  9. OK, I see I'm not very clear, sorry about that. It's partially because I'm trying to simplify the description of the problem (and reduce the number of tables & relationships to get there) I suppose... A machine can produce any number of items. A factory can also produce any number of items (but without any link to which item can be produced by machines). When placing a machine into a factory, the intersection of the items that can be produced by the machine and the ones that can be produced in the factory is what can actually be produced. Or explained otherwise, the list o
  10. All Items are in one table (Item). The 2 other tables have relationships to the Item table. And sometimes, I need to see which Items can be produced by a Machine X that has been assigned to a Factory Y, i.e. the Intersection of both.
  11. Hi, I think I've seen a similar problem posted recently (subject "Intersections" by eric.p on 10-02-09) but no useful answer. So am trying again, rephrasing the problem, it might help. I'd need a way to show a value list with records from one table that are linked to 2 different tables (it's an intersection indeed). There's no way to do this in the "Value List" interface, hence me posting this in the "Relationships" section. To be more practical, if the description above is too theoretical... I have an "Item" table linked to a "Factory Items" table and also to a "Machine
  12. I think I understand what you mean. "_" would be some kind of "operator" influencing the search result. It's just weird/sad it's not in the popup list of symbols. I'm going to use another way then. But thanks a lot for the hint. You saved me from the mental institution :-)
  13. Hi, I'm experiencing a rather weird behavior which I can't explain so far, hopefully sombedy out there can help. I have a text field containing "month periods", with the content formatted as YY_MM, like: 07_01 for January 2007 07_02 for February 2007 etc I'm trying a very simple "Find" on that field with something like: ">07_05" to give me all periods after May 2007. This returns 07_08, 07_09, 07_10 etc but NOT 07_06 or 07_07. I've tried to: - find with the condition >"07_05" (with quotes) - recover the file - optimise and compress the file
  14. I've seen a lot of interesting hints in all the links provided. I now need to spend the time and analyse but it really looks like one of them will do. Well done - Thanks!
  15. Hi sd, I'm talking about relationship between 2 tables (for instance to display a portal) rather than summary in a report layout. Sorry about the confusion. Actually, I want to "simulate", in a portal, what the summary function can do in report layouts. Not sure what you mean by "duping the TO" but, if I understand well, you suggest to use 2 relationship (and 2 layouts, 2 portals). It's not exactly what I'm looking for. Actually, I'm looking for a shortcut to avoid creating 2 instances of the same table and 2 different relationships, one with one criteria "Item Code = Item Code"
  • Create New...

Important Information

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