Jump to content
Sign in to follow this  
Leather Knight

The Update Achieved??

Recommended Posts

Ok, so now we are on the right track, I think.. Does this feature of a sql database mean we can now keep the data stored in a separate source so we can make updates to our developed app without losing any data already created by adding fields/calcs/reports and so on?

Share this post


Link to post
Share on other sites

I'm not sure I completely understand the question. The new external sql source (ESS) was really "designed as a means to better integrate a FileMaker Pro solution with existing SQL data sources."

FileMaker has been very vocal in stating that ESS is not to be used as a front end. "The emphasis with ESS should be on integration. The ESS feature set is not intended to allow FileMaker Pro to act as a "front end" to SQL data sources"

A link to their ESS tech brief: http://www.filemaker.com/downloads/pdf/public_techbrief_ess_en.pdf

I really didn't understand what you were asking, so hopefully explaining what the feature is will help.

Share this post


Link to post
Share on other sites

Ok look at it this way.

Filemaker makes this program, "Filemaker 8.5v1". Then they have made "8.5v2". The end user, which is you and me, get the update and none of our work is lost but the new implemented features are intact. If I make a database for 200 clients, and add fields or forms, I can send them an update patch which will not overwrite their current data.

If the data is stored in a mysql seperate db, then the updates should work. This would be the main reason for me upgrading. However if not, then I will wait til it is achieved.

Question: Can I make updates to my distributed databases now without loss of data already input?

Share this post


Link to post
Share on other sites

Since this started out as a thread on FM9 and the separation model, I will append a related thought here.

I have not added the OBDC drivers yet. Can someone discount or prove that in a separation model scheme, I could publish my data files (made in FM) as OBDC and subscribe to those files from my UI database.

If it works I see a very useful feature. The OBDC subscribe allows for a user name and password different from the signed in user. This common password could work on multiple data files without all of the rigamarole of getting user names and passwords to all of the data files.

Would there be negative consequences to doing it this way?

Share this post


Link to post
Share on other sites

As the data is stored in the database and not the FileMaker application, yes you can make the upgrade without over riding the existing data.

Share this post


Link to post
Share on other sites

Just wondering, How one would achieve this. I mean, is there documentation on how to do updates this way? My databases I have developed in FM are highly detailed and elaborate to my way of thinking, so do I need to convert my db over and have each and every field direct the data to the sql?

Share this post


Link to post
Share on other sites

Do a search for the "separation model".

It is not a trivial amount of work.

Share this post


Link to post
Share on other sites

I believe Kevin's played with the separation model and found it wanting...

Share this post


Link to post
Share on other sites

Since FileMaker Pro 7 rolled out on Amrch 9th of 2004, every solution I have done uses TSM. I have found it robust. What was lacking?

Steven

Share this post


Link to post
Share on other sites

I said Kevin's found it lacking (if you run through his posts)... I have no real issues with it, except sometimes you do have to update the data layer...

and as far as i know the import still doesn't match properly with the addition of new fields...

Share this post


Link to post
Share on other sites

Well, you are right. Doing a separation model with my app is NOT a trivial amount of work which is why I was hoping for an easier way of storing data separate from the rest. However, I do see that Brilliant Database has perfected it, why can't Filemaker?

Share this post


Link to post
Share on other sites

I believe Kevin's played with the separation model and found it wanting...

Oh my! I have done more than play with it...LOL. it has been torn apart/ reassembled/ switched around and still failure. I have hundreds of fields and even more scripts and formulas, and I could not get it to work. Thus I am stuck with the heavy burdon of making sure my first release is "perfect" so I do not have to ask hundreds of customers to return for bug fixes. I have made major releases, and been ok, but would love to be able to make my job easier...

Share this post


Link to post
Share on other sites

It really isn't that much of a challenge. Perhaps you should consider retaining the services of a developer who perfected the concept or who has used it extensively. Contact me for a list of names.

Steven

Share this post


Link to post
Share on other sites

Hey Kevin,

I don’t know why you’ve had so much trouble with the SM especially in 8 and up. Ender made an invaluable post for anyone wanting to convert to the SM and you need to really grab on to it because Ender doesn’t have all that many good ideas. :P Here’s the link

http://www.fmforums.com/forum/showpost.php?post/12...

I’m like the Old Advance Man regarding SM. Every solution I build anymore is using the Separation Model. Once you wrap your brain around it, it just makes sense. Follow the above link and you’ll not go wrong. The Old Advance Man didn’t get Old and Advanced just by being a Man, he did it in part by recognizing the write-of-it! Ok maybe that and a good woman! :blush2:

You need to tell us specifically what problems you’re having in your conversion to SM so we can help. And the time to do that is when you’re sitting there staring at the screen and you want to stop because you just don’t get it. Don't keep slogging through it, give us a shout! Hey I come from a long line of “Not getting it”. My family will tell you I’m from the shallow end of the Glosenger gene pool. : A lot of people are just smart, but most of us have to struggle and mess things up a number of times before we get it. The good news is there are people right here on this thread more than happy to jump in and help. That’s where I and most of us learned it our selves.

I would recommend you take the conversation over to the SM area under “Brain Food” so other interested parties can also get it in the conversation. I’ve read most of your posts and I think SM will serve you very well and believe me when I say that YOU CAN DO IT!

Otherwise just send the Old Advance Man and me 5 grand appease for council... We love that! :thumbup:

Harry

Edited by Guest

Share this post


Link to post
Share on other sites

Does anyone know of any good tutorials on implementing separation model in FileMaker ? I searched this forum for "+separation +model +tutorial" and came up with nothing.

Share this post


Link to post
Share on other sites

Uhmmm Harry are you sure that posted the correct link? : Unless Ender became Microstar... hmmm...

Share this post


Link to post
Share on other sites

Lol, Harry, you're sense of direction must really be off, you never seem to be able to copy the right link... that or you don't like Ender :

Share this post


Link to post
Share on other sites

Oops, sorry about that.

http://www.fmforums.com/forum/showpost.php?post/123239/

You guys have to go easier on me... Didn't you read the part about the Gene pool...

Harry

Edited by Guest

Share this post


Link to post
Share on other sites

Its got to be a Tampa thing. Spending too much time at Ybor. hehe...

Edited by Guest

Share this post


Link to post
Share on other sites

Hey Mr. Vodka,

We have a city not far from Tampa called “Thonotosassa”. One day while I was driving through town I stopped into a restaurant and said “How do you pronounce that name” and the girl behind the counter looks up at me with a disgusted look on her face and says “B-e-r-g-e-r -- K-i-n-g”!

Don’t you just hate when that happens!

Harry

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • By Justin Close
      I was doing a bit of work for a client who is running FM9 clients, connecting to a file hosted on an FM11 server.  I don't have FM9, so was doing development on FM11.  I thought I had checked out that everything was compatible, but I somehow generated a calculation that doesn't evaluate on 9, but does on 11.  The components of the calculations and custom functions used all appear to be innocuous...  I  am hoping someone here knows what I tripped up on.
      Here's the field calculation, and the 2 custom function definitions that it uses.  The entire point of this calculation is to take a mish-mash text field that they have and make it sort nicely.  For this bit I added, I'm just concerning myself with sorting some suffix numbers that occur between parentheses, e.g. 12345(A-1).
       
      Field calculation definition: Let ( [ _fileNum = Files::File Number ; //Position of 1st open/close parens, and then extract the text between them: _sParen = Position ( _fileNum ; "(" ; 1 ; 1 ) + 1; _eParen = Position ( _fileNum ; ")" ; 1 ; 1 ) ; _suffix = Middle ( _fileNum ; _sParen ; _eParen - _sParen) ; //Count the leading digits before any non-digit character, e.g. an alpha, or dash or space, etc. _count = CountPrefixDigits ( _suffix ; 0 ) ; //Remove extraneous characters (dash, space): _suffix = Substitute ( _suffix; ["-";""]; [" " ; ""] ) ; //Pad out the string to min 5 characters (helps 75-A sort next to 75): _suffix = _suffix & Left ( "!!!!!" ; 5 - Length (_suffix) ); //Reverse the character sequence (so the Code() call works out better): _suffix = ReverseString ( _suffix ) ]; _count & Code ( _suffix ) //prepend the digit count, but don't encode that count, just the rest of it ) -------------------- 'CountPrefixDigits ( aString ; aCounter )' custom function: If ( IsEmpty ( GetAsNumber ( Left ( aString ; 1 ) ) ) ; aCounter ; CountPrefixDigits ( Right ( aString ; Length ( aString) - 1 ) ; aCounter + 1 ) ) -------------------- 'ReverseString (aString)' custom function: If ( Length ( aString ) > 0 ; ReverseString ( Right ( aString ; Length ( aString ) - 1 ) ) & Left ( aString ; 1 ) ; Left ( aString ; 1 ) )  
      Thanks,
      Justin
       
    • By Tumma K
      Hello, All!

      I am an aspiring developer for Filemaker. The company I work with is stuck in the past working off of Filemaker Pro 4.1

      I was given the task of bringing us up to Filemaker Pro/Server 13. So far my conversion prototypes are successful but we recently had a layout issue that can only be fixed in versions 3-6 (as the file is an .fp3) I work off of a macbook while our network is all Windows 7. In order for me to repair the layouts without tampering our active database, I decided the best option is to repair a copy of our solutions off the network. Unfortunately, when I go to download the trial version of Filemaker Pro 6 off of the respected website, the file is corrupt! I've tried multiple times, with different extraction apps and in different directories.

      My question is;

      Does anyone know a place where I could obtain version 6 (or better yet, 4.0) for an OSX computer? I've looked everywhere!
       
      Thank you for your time,
      Tumma K.
    • By MacSig
      Hello everyone.
      How can I set the calculated value of field C to the number of records having field A equal to the value inserted to field A and field B equal to the value inserted to field B?
       
      For instance with the following situation
       
      record 1  =>  A = "house", B = "pay" 
      record 2  =>  A = "house", B = "win" 
      record 3  =>  A = "car", B = "pay" 
      record 4  =>  A = "house", B = "pay" 
       
      when I create a new record having  A = "house", B = "pay"  C should automatically be 2 (since record 1 and 4 have the same A, B.
       
      Thanks
    • By MrEddByrnes
      I'm hoping my question can have a happy ending. In the mid-90's, I purchased Filemaker 3. When Filemaker 5.5 Pro was released, I bought the update CD, which requires the user to either have FM 3 installed or to have the installation CD for FM 3. I've used it all these years, most recently with Windows XP Pro, and it has worked just fine. The databases I began with were long ago converted to FM Pro 5.5 databases.
       
      I'm still using FM Pro 5.5 on a laptop with WinXP Pro, but in 2013, I purchased a PC with Windows 8. I haven't been able to install FM 3 on it, therefore can't install FM Pro 5.5. I am retired and rarely use Filemaker, but I have a few Filemaker databases I'd like to add to my Win 8 machine. I don't feel it's worth upgrading FM for the sake of using a couple of databases.
       
      Has anyone else run into this situation and/or have a (possible) solution? Is there perhaps any other software that can read FM 5.5 databases? Thanks in advance for your help.
       
    • By bmill
      I am using a custom filemaker solution for medical office billing written with fp5 running on a mac with snow leopard. In addition, I have a patient management db (which I wrote) that is linked through pt. ID number to the billing program allowing transfer of some demographic information (name, DOB, etc).
       
      Other than being limited by hardware restrictions, the billing program serves our needs for now and upgrading to fp12 will take some time (and money).  In the meantime, I am upgrading my pt. management program to fp13 and would like to move new patient demographic information from the billing program ( fp5 running on snow leopard through Parallels) and the new pt management program ( fp13 running on OS X 10.9) on the same mac.   
       
      Ideally, demographic information would be entered once into fp5 and then a scipt would make the data available for fp13.
       
      Any ideas on how to make this work?
×

Important Information

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