Jump to content

Switching BackEnd....maintaining current layout ?

This topic is 2048 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello Eeverybody,


I am working with FM 11 Advanced Server on Win 2012 Server. Clients are all FM 11 Advanced from both Mac and win platforms. The database we have defined is working fine but we need to open to the web, so a clone of the initial FM database has been created (essentially same TO, and same fields per table) in MySQL 5.4 to be able to add records through the browser with JQuery/PHP.

we would like to keep working with FM, using it as an INTRANET front-end of the MySQL database (which would receive data from the INTRANET through filemaker and from the Internet through the web).

ESS is working Ok, and we have been able to import shadow tables in filemaker. Now...the original solution is based on many (> 10) layouts, quite complex and with a lot of conditional formatting...here it is the question: since the fields have the same name and TO have the same name, would it be possible to simply "copy and paste" current layouts so to link current fields with the MySQL backend ? I know this was not possible in the past, maybe something happened in the meanwhile ? We are also open to use  aplugin as necessary or upgrade to FM 13 if helpful.


Thank you always,



Link to post
Share on other sites

You might want to have a look at Clip Manger 4 for Mac or Clip Manager Express for Windows. I think this will let you do what you are looking for. It will allow you to make global edits to every element in your layout without all of the tedious clicking and scrolling that it would take to do this manually.


To give you an idea, this is one of the things that you can do with Clip Manager 4 for Mac (and I assume that it's same on their windows version)...


1.) From Layout Mode in FileMaker you copy everything on the entire layout to your clipboard.


2.) Switch over to the Clip Manager App and select the "Get" option. This will convert everything from your layout into an readable and editable text document.


3.) Now you can simply perform a global find and replace from the text editor that is built-in to Clip Manager or you can copy and paste the layout into your favorite text editor.


4.) After performing your edits you simply tell Clip Manger to "Set" your modified text into a layout and it will magically paste all of your modified elements into your layout which are now linked to the new data source or tables (or whatever edits you have made in the text editor).


Learn more here: http://www.myfmbutler.com/


They have a 30 day demo that is fully functional.


Here is a demo video that shows some of the features:


Link to post
Share on other sites

This topic is 2048 days old. Please don't post here. Open a new topic instead.

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
  • Similar Content

    • By Will_Logic
      Hi, I have been using Base Elements command BE_FileMakerSQL in FileMaker script to SQL select data, and return with '<c>' as field(column) delimiter, and '<r>' as the row delimiter. The below line worked before, I dumped a whole FM database with these delimiters showing in text files. But somehow, now if I run below line, it seems to have changed to ?only allow? 1 character for the delimiter, which of course doesn't make sense anyway with varied characters in the data:
      BE_FileMakerSQL ( $sql_select;  "<c>" ; "<r>" ; $fm_file ) The string this returns now looks like for example: 352265<gwgwh<474848<<wegwgw<65755<gwgw ....
      i.e. it has only taken the first character of the delimiter, I changed delimiter string to test with eg "A≠" instead of "<c>", same problem, it then only inserts "A" as delimiter. Just wonder if anyone can guess what might have happened here?
      Thanks kindly any suggestions!
    • By Answers
      We have a layout that has multiple tab panels, I want to add a field in the same place in all the tab panels at once without clicking on each panel. It's probably simple but I can't seem to figure it out.
      Thank you for your help in advance!
    • By Will_Logic
      Hi, I am using the Base Elements plugin Execute SQL command to select SQL on a table in another FileMaker file. For a file with many fields and quite a lot data in some fields, this times as about 1 minute just for SQL SELECT command for 1,000 rows. I haven't used MBS (monkeybread software) plugin yet, but I wonder if anyone knows if it is significantly faster?
      I.e. BE_FileMakerSQL vs. MBS(FM.SQL.Execute..) - is one significantly faster?
      Here's the code to select 1,000 rows for reference, $timer_seconds comes as about 60 seconds here. If I export same table internally in FileMaker using the menu export to Excel, it takes 29 minutes for all 41,000 rows, so timing seems similar for the Base Elements SQL. (NB there is some flag going on here in the FileMaker database so internal export gets 41,000 rows but script SQL SELECT COUNT(*) gets 200,000 rows for same table, but I don't think that is relevant to my question).
      Set Variable [$time1; Value: Get(CurrentTimeUTCMilliseconds)] Set Variable [$part_ca; Value: BE_FileMakerSQL ( "SELECT * FROM Contact_ACTIVITY OFFSET 100000 ROWS FETCH FIRST 1000 ROWS ONLY" ; "&≠≠&" ; "EOR≠≠EOR" ; "DataContacts11" )] Set Variable [$timer_seconds; Value: (Get(CurrentTimeUTCMilliseconds) - $time1) / 1000] MBS command I think would be something like:
      MBS( "FM.SQL.Execute"; "DataContacts11"; "SELECT * FROM Contact_ACTIVITY OFFSET 100000 ROWS FETCH FIRST 1000 ROWS ONLY" ; ...delimiters here I'm assuming.. ) We only have base FileMaker here on machine I am using, which can run the Base Elements plugin, but to run MBS plugin, needs FileMaker Pro Advanced to install it I think, am getting several databases in roughly same FM format where script workspace disabled, hence need to use SQL select run from script in my own external FileMaker file. Might consider getting FMP Pro Advanced if MBS is faster.
      Tx any suggestions!
    • By Peter Barfield
      Well, I'm new to SQL and have used it in it's basic select  mode. 
      Now I have been asked too create a dashboard using data from different tables to display. Which on the most part is OK and working great.
      I have had a request for a top customer list for the month and previous month (say best 5 ranked from 1-5.) and not together so 2 seperate views
      I am able to pull customers and SUM totals (seperately)for the month using SELECT DISTINCT I am able to get a list of the customers for the month. How would you then get a total or SUM of the invoice amounts for the given month with the customer name and their total ? also is there a similar function to FRACTION in filemaker?
      Listed is my SQL Statement that just returns a ?
      Which I understand to mean a syntax error however, being a SQL "Virgin" any halp would be appreciated. I know I am able to do this natively through filemaker however, as I said this is for a dashboard that uses data from a number of tables.
      Here is my calc that is obviously wrong.
      Currently working with Filemaker 15 Advanced.
      Let ( [ 
      ReturnSub = "\n" ; 
      SQLResult = ExecuteSQL ( 
      "SELECT DISTINCT (a.\"Customer Name\"), SUM(a.\"InvoiceTotal\")
      FROM \"Invoices \" a
      WHERE a.\"Invoice Sub Total\" > ? AND a.\"InvoiceMonth\" = ? AND a.\"InvoiceYear\" = ? AND a.\"Job Status\" <> ?" 
      GROUP ON a.\"Customer Name\" ASC; 
      "    " ; "|*|" ; 

       "0" ; Month(Get(CurrentDate))-1 ; Year(Get(CurrentDate)); "Giveaway"

       ) ] ; 
      Substitute ( SQLResult ; [ ¶ ; ReturnSub ] ; [ "|*|" ; ¶ ]  )

    • By Calvin Tomm
      In list view I want to be able to "grab" an object so I can move the record up or down in the found set. Is there a way to do this? It would be just like how an item on an list in an iPhone gets moved up or down. For example, on a play list in Music, I can change the order of songs to be played.
      Also, I would like to have this capability when I move my solution over to FileMaker Go

  • Create New...

Important Information

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