Re: Data Dictionary to Structure via XML ?

2016-10-30 Thread Arnaud de Montard
> Le 12 oct. 2016 à 13:10, Peter Jakobsson a écrit : > > [...] > To me, SQL is really a runtime, not design time tool and I prefer not to use > it when 4D has all these design-time specific options that are native. [...] Hi Peter, much later… Just to mention that yesterday I had to add a bun

Re: Data Dictionary to Structure via XML ?

2016-10-12 Thread Peter Jakobsson
On 12 Oct 2016, at 14:13, Arnaud de Montard wrote: > I seem to remember I saw that when some tables had comments - but far, far > ago! Ok, thanks. I’ll check. Peter ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.c

Re: Data Dictionary to Structure via XML ?

2016-10-12 Thread Arnaud de Montard
> Le 12 oct. 2016 à 13:10, Peter Jakobsson a écrit : > > [...] I always get an error message at the end, saying something like > “incompatible definition” [...] I seem to remember I saw that when some tables had comments - but far, far ago! -- Arnaud de Montard

Re: Data Dictionary to Structure via XML ?

2016-10-12 Thread Peter Jakobsson
On 12 Oct 2016, at 12:57, Arnaud de Montard wrote: > But, unless I'm wrong, about relations in a copy/paste process, they are in > the copy but ignored by paste (tried v14 R5 and compared export as xml data > vs copy items in structure). Hi Arnaud Yes, thats what I found also. The IMPORT S

Re: Data Dictionary to Structure via XML ?

2016-10-12 Thread Arnaud de Montard
> Le 12 oct. 2016 à 12:22, Peter Jakobsson a écrit : > > Yes - SQL could have been possible. I don’t like using SQL for making > permanent structure changes though, ever since I noticed that relations made > with SQL are somehow “different” from ones made in the structure editor. I > think th

Re: Data Dictionary to Structure via XML ?

2016-10-12 Thread Peter Jakobsson
Miyako - On 12 Oct 2016, at 02:28, Keisuke Miyako wrote: > you can add tables and fields via the clipboard or the new IMPORT STRUCTURE > command. Your answer gave me the confidence to go back and look harder at the solution. Turns out 4D had a problem with the formatting in the document head

Re: Data Dictionary to Structure via XML ?

2016-10-12 Thread Arnaud de Montard
> Le 12 oct. 2016 à 00:51, Peter Jakobsson a écrit : > > Hi > > I tried to write some code to convert 2 columns of data dictionary > (“Fieldname” “Fieldtype” definitions) from iWork’s “Numbers” spreadsheet > straight to a 4D structure but unfortunately it doesn’t work.[...] > > Is anybody do

Re: Data Dictionary to Structure via XML ?

2016-10-11 Thread Keisuke Miyako
there is really nothing special about the UUID, you can add tables and fields via the clipboard or the new IMPORT STRUCTURE command. it's actually better to use the command, not the pasteboard, because that way you can define relations and index settings too. either way, a new UUID is generated