Procedurally set Movable Rows option for a listbox

2018-03-08 Thread Piotr Chabot Stadhouders via 4D_Tech
Hi, 4D v16R5 I must be overlooking it, but how can I procedurally set the Movable Rows option for a listbox? Gr, Piotr ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

Re: Import from Excel

2018-03-08 Thread Jeremy French via 4D_Tech
Hi Tim, Just tried the Tech Note using v16 without success. Apparently PHPExcel is deprecated. It’s successor is PHPSpreadsheet at: https://github.com/PHPOffice Could you possibly do a new edition of your Tech Note using PHPSpreadsheet and v16? Best regards,

Re: Import from Excel

2018-03-08 Thread Keith Goebel via 4D_Tech
Pat, > Yes ... We wrote a procedure to import csv files. My point was that you can't > just use the basic 4D Import option to import such files. We don’t use 4D’s import, so I can’t comment on whether it works correctly or not. Chip, > >> the problem I have found with csv is that different

Re: Time Machine on Mac not detecting Data File Changes

2018-03-08 Thread Charles Miller via 4D_Tech
Just make sure to stop copying live data file and implemet journal. Back ups of those is fine as long as time machne does not try and copy them when you are creating them. One thing you could do is to back up to a folder that time machone skips and upon completion move documents .4BK and .4BL to a

Re: Time Machine on Mac not detecting Data File Changes

2018-03-08 Thread Rob Faucett via 4D_Tech
Thanks Chuck. I did and that doesn't work as noted above and in conversations with a tech @ 4D. Lesson learned. I appreciate you taking the time to reply. Best Rob 4D Tech mailing list wrote > Did you use it to copy a running data file or was it stopped. If running > you can not tell what

Re: Time Machine on Mac not detecting Data File Changes

2018-03-08 Thread Robert C. Faucett via 4D_Tech
Awesome Tim, thanks for taking the time. I have a 4BK file from 0400 yesterday so will only have to redo the work from yesterday. Best Rob -- Robert C. Faucett Collections Manager Ornithology Burke Museum Box 353010 University of Washington Seattle, WA 98195-3010 Office: 206-543-1668 Cell:

Re: Time Machine on Mac not detecting Data File Changes

2018-03-08 Thread Charles Miller via 4D_Tech
Did you use it to copy a running data file or was it stopped. If running you can not tell what state it was in unless you are assured all cache was flushed before copy Regards Chuck On Thu, Mar 8, 2018 at 2:18 PM, Robert C. Faucett via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Folks - I'm

RE: Time Machine on Mac not detecting Data File Changes

2018-03-08 Thread Timothy Penner via 4D_Tech
If you are not using the built-in 4D Backup System, then it will be near impossible to get a good backup of the 4D files. This is because the changes are made in memory and periodically flushed to disk (default interval of 20 seconds). There is no mechanism between 4D and time Machine to

Time Machine on Mac not detecting Data File Changes

2018-03-08 Thread Robert C. Faucett via 4D_Tech
Hi Folks - I'm running Mac OS 10.13.3 and 4D v16.3 and am hoping to restore from a Time Machine backup, but . . . In every Time Machine "snapshot" I have the .4DD & .4DB files show a "Date modified" of 3/2 (which is a week ago). Writing b/c it looks like Dave some how had it working. Any

Re: "Record to Object" or "Selection to Object"?

2018-03-08 Thread Kirk Brooks via 4D_Tech
Bill, Given that we now have a viable option for storing date/time values in a single field (eg: string(date;ISO date;time)) why not just modify your structure, create a new field and write both values to it. Even if you decide to retain the discrete date & time fields this is not much overhead

Re: Import from Excel

2018-03-08 Thread Chip Scheide via 4D_Tech
the problem I have found with csv is that different software creates different formats. sometimes, everything is quoted, sometimes only certain values are quoted, and similar to the problem of a tab delimited text file, if the text contains a equation mark(s) everything gets screwed. In my

Re: "Record to Object" or "Selection to Object"?

2018-03-08 Thread Bill Hutten via 4D_Tech
On Thu, Mar 8, 2018, at 11:17 AM, Keisuke Miyako via 4D_Tech wrote: > OB Copy with pointers is effectively the "record to object" feature. Ahh - that's useful. Now if only 4D supported pointers to methods. :) Here's the specific issue: I have a record (many, actually heh) that has this sort of

Re: "Record to Object" or "Selection to Object"?

2018-03-08 Thread Keisuke Miyako via 4D_Tech
it's not often the case that you'd need all the fields represented in the object. on top of that, sometimes the structure defined field names or even their order of appearance may not be ideal. OB Copy with pointers is effectively the "record to object" feature.

Re: "Record to Object" or "Selection to Object"?

2018-03-08 Thread Milan Adamov via 4D_Tech
> On Mar 8, 2018, at 15:41, Bill Hutten via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> On Thu, Mar 8, 2018, at 10:31 AM, Christian Sakowski via 4D_Tech wrote: >> >> have you looked at "Selection to JSON" and "JSON TO SELECTION"? But it >> will not cover all field types. > > Yeah - I'm

Re: "Record to Object" or "Selection to Object"?

2018-03-08 Thread Bill Hutten via 4D_Tech
On Thu, Mar 8, 2018, at 10:31 AM, Christian Sakowski via 4D_Tech wrote: > have you looked at "Selection to JSON" and "JSON TO SELECTION"? But it > will not cover all field types. Yeah - I'm currently doing: "Selection to JSON" and then "JSON PARSE ARRAY" but that's kindadumb. Also there's

Re: "Record to Object" or "Selection to Object"?

2018-03-08 Thread Christian Sakowski via 4D_Tech
Hi, have you looked at "Selection to JSON" and "JSON TO SELECTION"? But it will not cover all field types. -- Grüße/Regards, [heubach-media] | Christian Sakowski christian.sakow...@heubach-media.de iChat/AIM: SakowskiF Tel: +49/(0)40/52 10 59-23 > Am 08.03.2018 um 15:27 schrieb Bill Hutten

"Record to Object" or "Selection to Object"?

2018-03-08 Thread Bill Hutten via 4D_Tech
I admit I've not been keeping 100% up to date with the many language changes in 4D v16 - so before I go write a bunch of test code (or worse, read the documentation) - do current versions of 4D have commands to convert from a record to an object, or selection to object array, and ideally

Re: What's the easiest way to edit an existing constants file?

2018-03-08 Thread Koen Van Hooreweghe via 4D_Tech
Hi Dave, Is there a reason why you cannot edit your existing constants file using the same 4D Pop component? Kind regards, Koen > Op 8 mrt. 2018, om 00:31 heeft Dave Nasralla via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > I found the 4DPop_Constant_Editor for creating a