Jump to content
Sign in to follow this  
ssaucedo

Copy Layout to Another Database

Recommended Posts

ssaucedo    0

Is it possible to copy a layout to another database? Relationships, field names etc are not a factor. Have a backup copy of my database. Messed up a layout and want to restore it by copying the layout from my backup copy of my database.

Share this post


Link to post
Share on other sites
-Queue-    2

Go into Layout Mode, select all objects, copy, and paste into the other file, or drag-and-drop them if that's an option.

Share this post


Link to post
Share on other sites
_henry_    0

Hi,

You can also use T-Square (View -> T-Square) or Ctrl-T in arranging your objects or items in the layout.

Object Info (View -> Object Info) would be also helpful tool in modifying your layout.

Hope that helps...

Share this post


Link to post
Share on other sites
Ocean West    106

If you are on a mac I recommend ClipManger http://myfmbutler.com/index.lasso?p=422

Share this post


Link to post
Share on other sites
MHAriete64    0

I want to re-ask this question b/c I don't know as though the answers addressed the question. You can copy/paste scripts and fields and such between one file (database) and another. But, you cannot copy/paste LAYOUTS from one file (database) to another. Is that correct? If not, please tell me how you can.

Thanks.

- Michael

Share this post


Link to post
Share on other sites
bcooney    102

What part of this is confusing?:

"Go into Layout Mode, select all objects, copy, and paste into the other file"

Share this post


Link to post
Share on other sites
Lee Smith    147

The difference between using [color:blue]Clip Manager (a commercial product by myFMbutler), and the [color:blue]Copy and Paste mention in your question, and replied to by [color:orange]Barbara's, is that the [color:blue]Clip Manager can retain your better efforts in a convenient place inside Clip Manager, for access at will, and the Copy Paste is a limited to the clipboard activity.

For more about [color:blue]Clip Manager, go to their site Link

I use, and like Clip Manager.

Lee

Edited by Guest
Clarify a few points better.

Share this post


Link to post
Share on other sites
comment    1,392

you cannot copy/paste LAYOUTS from one file (database) to another. Is that correct?

Yes, that is correct. You can only copy/paste layout OBJECTS from one layout to another. Which means you want to make sure the target layout has all the required parts and sufficient size to accommodate the pasted objects.

Share this post


Link to post
Share on other sites
MHAriete64    0

THANK YOU! I thought I was crazy, all these posts about just "copy and paste" ease. I've wanted to be able to do this for some time but was pretty darn sure you couldn't.

What is FileMaker waiting for? Why don't they give us this capability?

Share this post


Link to post
Share on other sites
bcooney    102

Because it's pretty rare that two databases would have the exact same fields, TOs, etc. If you need an exact copy, Save As Clone.

Share this post


Link to post
Share on other sites
MHAriete64    0

I have built a solution that is housed on a server at a local community college and I keep a copy of the DB on my office computer. I build and test new options for the DB at the office, then go to school to implement them I cannot build whole LAYOUTS and then copy and paste the new LAYOUT into the solution. I essentially must recreate it. This, in my opinion is where FMP could be improved - for developers who test functionality before implementing it in an online solution.

Share this post


Link to post
Share on other sites
bcooney    102

I understand. I don't update an existing live solution. We import the data from the old version into the new structure and then upload. It does involve downtime.

There is so much that the layout would need (as it does if you copy/paste its objects). I would imagine that you've created new relationships (TOs), scripts and fields that the old version doesn't have and that would need to remap if you pasted layout objects. This lack of the needed TOs, scripts and fields would still haunt you if you could paste a layout. In fact, the layout may need to be based on a TO that doesn't exist in the old version.

That's why I don't see this as a huge void in FM's functionality.

Share this post


Link to post
Share on other sites
MHAriete64    0

Yes, very good point. Either way, you'd have to do a lot of background work to make the new layout compatible with the existing infrastructure. I just found it surprising that (up until v.10) you could copy and paste scripts, fields, and tables, but not layouts.

BTW, I just noticed they took away the ability to copy/paste scripts and changed it to an "Import" function. I found that odd. I skipped over 9, so it might have been there. Have you any idea why they did that?

Share this post


Link to post
Share on other sites
bcooney    102

It's there, it's under Edit or Cmd-C

Share this post


Link to post
Share on other sites
MHAriete64    0

Oh, sure, there it is. They just took away the buttons in the interface but left the functionality. Interesting.

Thx.

Share this post


Link to post
Share on other sites
cellmaker    0

[using FM 12 Advanced]  

There does seem to be some inconsistency with things.  You can copy a table with cmd-c (mac), but it appears you can't cmd-v paste it in the table manager.  You have to use the "paste" button at the bottom of the screen.

 

But you can just copy/paste by keyboard the scripts.

 

As for layouts, I find I can copy the objects, but they lose their field definitions, even if the same field names exist in the new based-on table.

 

Just an observation, so I could be wrong.

Share this post


Link to post
Share on other sites
bcooney    102

If both layouts are based on the same Table Occurrence, then the fields will copy over just fine.

  • Like 1

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  

×

Important Information

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