Hello all,
Is there a way to change every field on a layout to bind to a different table?
I do a lot of copy and pasting of layouts/fields and it would save me a bunch
of time if I can change every field's "field/setup control" at once.
--
POST BY: lark with PHP News Reader ;o)
On Oct 17, 1:10 pm, lark
> Hello all,
>
> Is there a way to change every field on a layout to bind to a different table?
> I do a lot of copy and pasting of layouts/fields and it would save me a bunch
> of time if I can change every field's "field/setup control" at once.
> --
> POST BY: lark with PHP News Reader ;o)
Not that I'm aware of.
I agree it would be a nice feature. I too frequently duplicate a
layout bound to a different TableOccurrence of the same table in the
RG, and manually switching all the fields is a pain. (At least when
switching from one TO to another it defaults to the same field in the
new TO.)
But I can't really see how it could be efficiently automated. What
about fields that point to related tables... for example.
-cheers,
Dave
== Quote from d-42 (db.porsche@gmail.com)'s article
> On Oct 17, 1:10 pm, lark
> > Hello all,
> >
> > Is there a way to change every field on a layout to bind to a different table?
> > I do a lot of copy and pasting of layouts/fields and it would save me a bunch
> > of time if I can change every field's "field/setup control" at once.
> > --
> > POST BY: lark with PHP News Reader ;o)
> Not that I'm aware of.
> I agree it would be a nice feature. I too frequently duplicate a
> layout bound to a different TableOccurrence of the same table in the
> RG, and manually switching all the fields is a pain. (At least when
> switching from one TO to another it defaults to the same field in the
> new TO.)
> But I can't really see how it could be efficiently automated. What
> about fields that point to related tables... for example.
> -cheers,
> Dave
yes, that's exactly what i am talking about. maybe somebody has written a script
to automate it. don't know if it's possible to change field binding through
scripts though.
--
POST BY: lark with PHP News Reader ;o)
On Oct 17, 1:50 pm, lark
> == Quote from d-42 (db.pors...@gmail.com)'s article
>
>
>
> > On Oct 17, 1:10 pm, lark
> > > Hello all,
>
> > > Is there a way to change every field on a layout to bind to a different table?
> > > I do a lot of copy and pasting of layouts/fields and it would save me a bunch
> > > of time if I can change every field's "field/setup control" at once.
> > > --
> > > POST BY: lark with PHP News Reader ;o)
> > Not that I'm aware of.
> > I agree it would be a nice feature. I too frequently duplicate a
> > layout bound to a different TableOccurrence of the same table in the
> > RG, and manually switching all the fields is a pain. (At least when
> > switching from one TO to another it defaults to the same field in the
> > new TO.)
> > But I can't really see how it could be efficiently automated. What
> > about fields that point to related tables... for example.
> > -cheers,
> > Dave
>
> yes, that's exactly what i am talking about. maybe somebody has written a script
> to automate it. don't know if it's possible to change field binding through
> scripts though.
> --
> POST BY: lark with PHP News Reader ;o)
I know it can't be done within a filemaker script. A 3rd party
application might do it. But I'm not familiar with any that do.
On 2007-10-17 22:52:41 +0200, d-42
> On Oct 17, 1:50 pm, lark
>> == Quote from d-42 (db.pors...@gmail.com)'s article
>>
>>
>>
>>> On Oct 17, 1:10 pm, lark
>>>> Hello all,
>>
>>>> Is there a way to change every field on a layout to bind to a different table?
>>>> I do a lot of copy and pasting of layouts/fields and it would save me a bunch
>>>> of time if I can change every field's "field/setup control" at once.
>>>> --
>>>> POST BY: lark with PHP News Reader ;o)
>>> Not that I'm aware of.
>>> I agree it would be a nice feature. I too frequently duplicate a
>>> layout bound to a different TableOccurrence of the same table in the
>>> RG, and manually switching all the fields is a pain. (At least when
>>> switching from one TO to another it defaults to the same field in the
>>> new TO.)
>>> But I can't really see how it could be efficiently automated. What
>>> about fields that point to related tables... for example.
>>> -cheers,
>>> Dave
>>
>> yes, that's exactly what i am talking about. maybe somebody has written
>> a script
>> to automate it. don't know if it's possible to change field binding through
>> scripts though.
>> --
>> POST BY: lark with PHP News Reader ;o)
>
> I know it can't be done within a filemaker script. A 3rd party
> application might do it. But I'm not familiar with any that do.
You can do it with Clip Manager from FMButler.
You copy the layout in fmp 7-9, then in Clip Manger you "get" it, and
it shows up as xml text. This text you can copy into BBEdit or
something, do a find/replace, and then replace every instance of the
table information, and paste it back to Clip Manger and then use the
"set" button in clip Manger to get it back to fmp.
It works!
Nicolay
On 10/17/07 4:52 PM, d-42 wrote:
> On Oct 17, 1:50 pm, lark
>> == Quote from d-42 (db.pors...@gmail.com)'s article
>>
>>
>>
>>> On Oct 17, 1:10 pm, lark
>>>> Hello all,
>>>> Is there a way to change every field on a layout to bind to a different table?
>>>> I do a lot of copy and pasting of layouts/fields and it would save me a bunch
>>>> of time if I can change every field's "field/setup control" at once.
>>>> --
>>>> POST BY: lark with PHP News Reader ;o)
>>> Not that I'm aware of.
>>> I agree it would be a nice feature. I too frequently duplicate a
>>> layout bound to a different TableOccurrence of the same table in the
>>> RG, and manually switching all the fields is a pain. (At least when
>>> switching from one TO to another it defaults to the same field in the
>>> new TO.)
>>> But I can't really see how it could be efficiently automated. What
>>> about fields that point to related tables... for example.
>>> -cheers,
>>> Dave
>> yes, that's exactly what i am talking about. maybe somebody has written a script
>> to automate it. don't know if it's possible to change field binding through
>> scripts though.
>> --
>> POST BY: lark with PHP News Reader ;o)
>
> I know it can't be done within a filemaker script. A 3rd party
> application might do it. But I'm not familiar with any that do.
>
With FM8+ and OSX 10.4, there's myFMButler's (http://www.myfmbutler.com)
Clip Manager...
Copy fields, tables, scripts, script steps, layouts, modify them with a
text editor, paste them back to FM.
Matt
== Quote from Matt Wills (I'm@witz.end)'s article
> On 10/17/07 4:52 PM, d-42 wrote:
> > On Oct 17, 1:50 pm, lark
> >> == Quote from d-42 (db.pors...@gmail.com)'s article
> >>
> >>
> >>
> >>> On Oct 17, 1:10 pm, lark
> >>>> Hello all,
> >>>> Is there a way to change every field on a layout to bind to a different table?
> >>>> I do a lot of copy and pasting of layouts/fields and it would save me a bunch
> >>>> of time if I can change every field's "field/setup control" at once.
> >>>> --
> >>>> POST BY: lark with PHP News Reader ;o)
> >>> Not that I'm aware of.
> >>> I agree it would be a nice feature. I too frequently duplicate a
> >>> layout bound to a different TableOccurrence of the same table in the
> >>> RG, and manually switching all the fields is a pain. (At least when
> >>> switching from one TO to another it defaults to the same field in the
> >>> new TO.)
> >>> But I can't really see how it could be efficiently automated. What
> >>> about fields that point to related tables... for example.
> >>> -cheers,
> >>> Dave
> >> yes, that's exactly what i am talking about. maybe somebody has written a script
> >> to automate it. don't know if it's possible to change field binding through
> >> scripts though.
> >> --
> >> POST BY: lark with PHP News Reader ;o)
> >
> > I know it can't be done within a filemaker script. A 3rd party
> > application might do it. But I'm not familiar with any that do.
> >
> With FM8+ and OSX 10.4, there's myFMButler's (http://www.myfmbutler.com)
> Clip Manager...
> Copy fields, tables, scripts, script steps, layouts, modify them with a
> text editor, paste them back to FM.
> Matt
thanks guys, i think i can use myFMButler to make things a bit easier.
--
POST BY: lark with PHP News Reader ;o)
== Quote from lark (hamzee@sbcglobal.net)'s article
> == Quote from Matt Wills (I'm@witz.end)'s article
> > On 10/17/07 4:52 PM, d-42 wrote:
> > > On Oct 17, 1:50 pm, lark
> > >> == Quote from d-42 (db.pors...@gmail.com)'s article
> > >>
> > >>
> > >>
> > >>> On Oct 17, 1:10 pm, lark
> > >>>> Hello all,
> > >>>> Is there a way to change every field on a layout to bind to a different
table?
> > >>>> I do a lot of copy and pasting of layouts/fields and it would save me a bunch
> > >>>> of time if I can change every field's "field/setup control" at once.
> > >>>> --
> > >>>> POST BY: lark with PHP News Reader ;o)
> > >>> Not that I'm aware of.
> > >>> I agree it would be a nice feature. I too frequently duplicate a
> > >>> layout bound to a different TableOccurrence of the same table in the
> > >>> RG, and manually switching all the fields is a pain. (At least when
> > >>> switching from one TO to another it defaults to the same field in the
> > >>> new TO.)
> > >>> But I can't really see how it could be efficiently automated. What
> > >>> about fields that point to related tables... for example.
> > >>> -cheers,
> > >>> Dave
> > >> yes, that's exactly what i am talking about. maybe somebody has written a
script
> > >> to automate it. don't know if it's possible to change field binding through
> > >> scripts though.
> > >> --
> > >> POST BY: lark with PHP News Reader ;o)
> > >
> > > I know it can't be done within a filemaker script. A 3rd party
> > > application might do it. But I'm not familiar with any that do.
> > >
> > With FM8+ and OSX 10.4, there's myFMButler's (http://www.myfmbutler.com)
> > Clip Manager...
> > Copy fields, tables, scripts, script steps, layouts, modify them with a
> > text editor, paste them back to FM.
> > Matt
> thanks guys, i think i can use myFMButler to make things a bit easier.
i tried myFMButler's clip manager. i don't know if i am doing something wrong or
it may have limitations. here's what i did to try to copy and paste one layout
from one file to another file.
1-opened fm file (to copy from), this file has only one table in it
2-opened clip manager
3-found the desired layout in 1 and select all/copy on all of its fields
4-switch to clip manager and push get button
5-an xml file is imported into the clip manager. copy this to textedit
6-change all occurrences of table name in this file to the table of name in the
other file (the fields are the same).
7-select all and copy the edited xml file.
8-when i do a set in clip manager, it does not import the new file to its own
little window
9-when i switch back to fm to paste the contents of the clip board to it, it
copies; however, all fields are blank.
don't know if there's something i am missing and have failed to do.
thanks in advance for your help.
--
POST BY: lark with PHP News Reader ;o)
on 10/18/07 7:49 PM lark said:
> == Quote from lark (hamzee@sbcglobal.net)'s article
>> == Quote from Matt Wills (I'm@witz.end)'s article
>>> On 10/17/07 4:52 PM, d-42 wrote:
>>>> On Oct 17, 1:50 pm, lark
>>>>> == Quote from d-42 (db.pors...@gmail.com)'s article
>>>>>
>>>>>
>>>>>
>>>>>> On Oct 17, 1:10 pm, lark
>>>>>>> Hello all,
>>>>>>> Is there a way to change every field on a layout to bind to a different
> table?
>>>>>>> I do a lot of copy and pasting of layouts/fields and it would save me a bunch
>>>>>>> of time if I can change every field's "field/setup control" at once.
>>>>>>> --
>>>>>>> POST BY: lark with PHP News Reader ;o)
>>>>>> Not that I'm aware of.
>>>>>> I agree it would be a nice feature. I too frequently duplicate a
>>>>>> layout bound to a different TableOccurrence of the same table in the
>>>>>> RG, and manually switching all the fields is a pain. (At least when
>>>>>> switching from one TO to another it defaults to the same field in the
>>>>>> new TO.)
>>>>>> But I can't really see how it could be efficiently automated. What
>>>>>> about fields that point to related tables... for example.
>>>>>> -cheers,
>>>>>> Dave
>>>>> yes, that's exactly what i am talking about. maybe somebody has written a
> script
>>>>> to automate it. don't know if it's possible to change field binding through
>>>>> scripts though.
>>>>> --
>>>>> POST BY: lark with PHP News Reader ;o)
>>>> I know it can't be done within a filemaker script. A 3rd party
>>>> application might do it. But I'm not familiar with any that do.
>>>>
>>> With FM8+ and OSX 10.4, there's myFMButler's (http://www.myfmbutler.com)
>>> Clip Manager...
>>> Copy fields, tables, scripts, script steps, layouts, modify them with a
>>> text editor, paste them back to FM.
>>> Matt
>> thanks guys, i think i can use myFMButler to make things a bit easier.
>
>
>
> i tried myFMButler's clip manager. i don't know if i am doing something wrong or
> it may have limitations. here's what i did to try to copy and paste one layout
> from one file to another file.
>
> 1-opened fm file (to copy from), this file has only one table in it
> 2-opened clip manager
> 3-found the desired layout in 1 and select all/copy on all of its fields
> 4-switch to clip manager and push get button
> 5-an xml file is imported into the clip manager. copy this to textedit
> 6-change all occurrences of table name in this file to the table of name in the
> other file (the fields are the same).
> 7-select all and copy the edited xml file.
> 8-when i do a set in clip manager, it does not import the new file to its own
> little window
> 9-when i switch back to fm to paste the contents of the clip board to it, it
> copies; however, all fields are blank.
>
> don't know if there's something i am missing and have failed to do.
> thanks in advance for your help.
> --
> POST BY: lark with PHP News Reader ;o)
I just did a test conversion and it worked fine.
1. I duplicated a file, and just to make sure I was starting fresh,
deleted the CURL table.
2. In the original file, I copied the CURL table I had deleted, pasted
it into the copy file, renamed it CURL2, imported the records from the
original file. In this fashion I know I have the same fields and data in
a differently named table.
3. In the original file, I set a layout of the CURL table into Clip
Manager, copied the xml to a text editor, did a search and replace (CURL
to CURL2), and pasted all of that back to Clip Manager (you don't
mention pasting it back to Clip Manager in your Step 7).
4. In the copy file, created a blank layout of the CURL2 table, and used
clip manager to set the layout elements. It worked perfectly. The layout
elements are all there, displaying known data.
I also experimented a little to learn that the table name is not
case-sensitive: a layout with the "CURL" table identified as "cURL" in
the xml displays the same data (I had thought that this might be your
problem, but apparently not).
Hopefully I have not been too sparse in my description, but if you can
follow it, perhaps your problem will be fixed.
Matt