Migrating Tables with Relations Between Structures

2017-04-05 Thread Peter Jakobsson via 4D_Tech
Hi I visited this subject a few years ago and was wondering what people prefer to do in this situation. Let’s say you have a group of tables with complex relations. You want to copy them from one structure to another as a coherent block, retaining the relations. What’s the best way ? - drag

Re: Migrating Tables with Relations Between Structures

2017-04-05 Thread John DeSoi via 4D_Tech
You could export the XML structure definition and then edit it to only include the tables and relations you want. Then import it into the target structure. John DeSoi, Ph.D. > On Apr 5, 2017, at 5:34 AM, Peter Jakobsson via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Let’s say you have a gro

Re: Migrating Tables with Relations Between Structures

2017-04-05 Thread Peter Jakobsson via 4D_Tech
Hi John Thanks for that suggestion. I tried that but in a complex structure it’s quite a footery and unsystematic process. You’ve got to identify tag blocks indirectly by UUID and so on and I found it didn’t save much time over just redrawing the relations manually. It probably works better wh

Re: Migrating Tables with Relations Between Structures

2017-04-05 Thread John DeSoi via 4D_Tech
Hi Peter, I have not implemented this, but I'm contemplating it for a component that would need to initially create some table structure in the host component. If you want to export/import a subset of tables, it seems not too hard to export the XML structure and then parse it to create a new XM

Re: Migrating Tables with Relations Between Structures

2017-04-05 Thread Keisuke Miyako via 4D_Tech
when you copy multiple tables in the structure editor, you get the table as well as the relation. pasting it back to the structure editor removes all ancillaries such as indexes and links, but the plugin entry-point allows you to re-create them. https://github.com/miyako/4d-plugin-structure-acce

Re: Migrating Tables with Relations Between Structures

2017-04-06 Thread Peter Jakobsson via 4D_Tech
Many thanks Miyako ! I’ll look into both of those approaches. Very promising. Peter On 6 Apr 2017, at 02:37, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> wrote: > when you copy multiple tables in the structure editor, > you get the table as well as the relation. > > pasting it back to t