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:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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,
Jeremy


> On Mar 7, 2018, at 12:15 PM, Timothy Penner via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I am not sure if it still works, but there is this tech note available:
> 
> Tech Note: PHPExcel Library with 4D v12
> Published On: April 15, 2011
> http://kb.4d.com/assetid=76312

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 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.

The exporting software is supposed to enclose strings and text inside “.
The importing software is supposed to be able to handle anything in a string or 
text cell, provided it is inside the enclosing ".

Agreed - sometimes Excel does not follow the cvs rules properly when it 
exports. 
But what should we expect? It’s not like they’re a large company with multiple 
programmers at their disposal… bless their little cotton socks!
Cheers, Keith
There are 3 kinds of mathematician. Those who can count, and those who can't.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 folder that time machine does backup you. If you do this you will ave to
manually handle how many backups are kept. Code for this is not that
difficult

Regards

Chuck

On Thu, Mar 8, 2018 at 2:43 PM, Robert C. Faucett via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> 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: 206-619-5569
> Fax: 206-685-3039
> rfauc...@uw.edu
> www.washington.edu/burkemuseum
> http://www.washington.edu/burkemuseum/collections/ornithology/index.php
> http://www.washington.edu/burkemuseum/collections/genetic/index.php
>
>
>
>
>
>
> On 3/8/18, 11:36 AM, "4D_Tech on behalf of Timothy Penner via 4D_Tech"
> <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:
>
> >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 enforce consistency of the files during that backup, therefore
> >the files restored from time machine will usually be corrupt or invalid.
> >
> >The only way to properly backup a 4D Database is to use the built-in 4D
> >Backup System. This will create a 4BK file every time the backup runs. In
> >addition to that, you should enable the journal file. The journal file
> >will contain all of the changes since the last backup. If you still want
> >to use Time Machine then you should configure it to back up the 4BK file
> >and the possibly even the Journal file.
> >
> >However, you mentioned the data file is listed as last modified 1 week
> >ago; I would venture to guess that maybe you are looking at the wrong
> >data file. You should probably double check the path to current data file
> >in 4D to confirm you are even looking at the correct one, for example
> >from the information page of the MSC:
> >http://doc.4d.com/4Dv16R4/4D/16-R4/Information-page.300-3330288.en.html
> >
> >-Tim
> >
> >
> >
> >
> >
> >**
> >4D Internet Users Group (4D iNUG)
> >FAQ:  http://lists.4d.com/faqnug.html
> >Archive:  http://lists.4d.com/archives.html
> >Options: https://lists.4d.com/mailman/options/4d_tech
> >Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> >**
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **




-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Server connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 state it was in unless you are assured all cache was
> flushed before copy
> 
> Regards
> 
> Chuck





-
--
Robert C. Faucett
Collections Manager
Ornithology
Burke Museum
Box 353010
University of Washington
Seattle, WA 98195-3010
Office: 206-543-1668
Cell: 206-619-5569
Fax: 206-685-3039
rfauc...@uw.edu
www.washington.edu/burkemuseum
http://www.washington.edu/burkemuseum/collections/ornithology/index.php
http://www.washington.edu/burkemuseum/collections/genetic/index.php
--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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: 206-619-5569
Fax: 206-685-3039
rfauc...@uw.edu
www.washington.edu/burkemuseum
http://www.washington.edu/burkemuseum/collections/ornithology/index.php
http://www.washington.edu/burkemuseum/collections/genetic/index.php






On 3/8/18, 11:36 AM, "4D_Tech on behalf of Timothy Penner via 4D_Tech"
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

>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 enforce consistency of the files during that backup, therefore
>the files restored from time machine will usually be corrupt or invalid.
>
>The only way to properly backup a 4D Database is to use the built-in 4D
>Backup System. This will create a 4BK file every time the backup runs. In
>addition to that, you should enable the journal file. The journal file
>will contain all of the changes since the last backup. If you still want
>to use Time Machine then you should configure it to back up the 4BK file
>and the possibly even the Journal file.
>
>However, you mentioned the data file is listed as last modified 1 week
>ago; I would venture to guess that maybe you are looking at the wrong
>data file. You should probably double check the path to current data file
>in 4D to confirm you are even looking at the correct one, for example
>from the information page of the MSC:
>http://doc.4d.com/4Dv16R4/4D/16-R4/Information-page.300-3330288.en.html
>
>-Tim
>
>
>
>
>
>**
>4D Internet Users Group (4D iNUG)
>FAQ:  http://lists.4d.com/faqnug.html
>Archive:  http://lists.4d.com/archives.html
>Options: https://lists.4d.com/mailman/options/4d_tech
>Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>**

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 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 advice?
>
> Thanks in advance.
>
> Rob
>
>
>
> --
> Robert C. Faucett
> Collections Manager
> Ornithology
> Burke Museum
> Box 353010
> University of Washington
> Seattle, WA 98195-3010
> Office: 206-543-1668
> Cell: 206-619-5569
> Fax: 206-685-3039
> rfauc...@uw.edu
> www.washington.edu/burkemuseum
> http://www.washington.edu/burkemuseum/collections/ornithology/index.php
> http://www.washington.edu/burkemuseum/collections/genetic/index.php
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **




-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Server connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 enforce 
consistency of the files during that backup, therefore the files restored from 
time machine will usually be corrupt or invalid.

The only way to properly backup a 4D Database is to use the built-in 4D Backup 
System. This will create a 4BK file every time the backup runs. In addition to 
that, you should enable the journal file. The journal file will contain all of 
the changes since the last backup. If you still want to use Time Machine then 
you should configure it to back up the 4BK file and the possibly even the 
Journal file.

However, you mentioned the data file is listed as last modified 1 week ago; I 
would venture to guess that maybe you are looking at the wrong data file. You 
should probably double check the path to current data file in 4D to confirm you 
are even looking at the correct one, for example from the information page of 
the MSC: http://doc.4d.com/4Dv16R4/4D/16-R4/Information-page.300-3330288.en.html

-Tim





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 advice?

Thanks in advance.

Rob



--
Robert C. Faucett
Collections Manager
Ornithology
Burke Museum
Box 353010
University of Washington
Seattle, WA 98195-3010
Office: 206-543-1668
Cell: 206-619-5569
Fax: 206-685-3039
rfauc...@uw.edu
www.washington.edu/burkemuseum
http://www.washington.edu/burkemuseum/collections/ornithology/index.php
http://www.washington.edu/burkemuseum/collections/genetic/index.php

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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
and makes implementing anything with JSON a lot easier. Over time you may
eliminate the need for the old fields or not.

Personally I never used date/time fields for scheduling preferring a DTS
(date time string) field instead. This is essentially the ISO string
without the markup. I find the searching and sorting on a single field much
easier and it made transitions like this very east too.

As cool as a lot of the new 4D features are, and I do think they are both
cool and tremendously useful, a lot of those advantages can be lost
attempting to hammer old structures into a shape that allows you to use
them. A little judicious refactoring and structure changes can yield a lot
of benefit.

On Thu, Mar 8, 2018 at 8:09 AM, Bill Hutten via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> 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 structure:
>   [Appts]Title
>   [Appts]Start_Date
>   [Appts]Start_Time
>
> I want to produce this sort of object:
>   { title: "foo", start: '2018-02-12T08:30:00Z' }
>
> Using "OB Copy"I can create a "template" object that will convert the
> pointer->[Appts]Title into the "title" attribute in the copied object. So
> far so good. But what's a clean method to convert the date & time fields in
> the record into a single field in the object?
>
> What I'm doing right now is manually processing the generated object via
> code that does OB SET and OB REMOVE. Not ideal, but it works. Obviously
> method pointers would be a perfect solution, but in the unfortunate absence
> of perfection is there another solution that I'm missing?
>
>
>
> Thanks for your help.
>
> - bill
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>



-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 Txtutl component, 
(https://www.dropbox.com/s/wj3w55p3gvzp5h5/Txtutl_Component_v1.0.0.zip?dl=0) 
there is an option export records to text, and a corresponding import, 
where returns, line feeds, and tabs which maybe embedded in the data are 
replaced with the following actual characters:
, , and 
this eliminates the issue of embedded field or line markers.

There is another way, slightly more generic way to resolve the issue of 
embedded delimiter characters, replace the default delimiters!

I did a bit of google-fu, and came across these ideas for saving excel files as 
cdv with custom delimiters:
https://www.howtogeek.com/howto/21456/export-or-save-excel-files-with-pipe-or-other-delimiters-instead-of-commas/
TLDR;
go to control panel/system preference change the 'List separator' character.
I imagine it would not be hard to write an applescript, or batch file or VBA 
script (embedded in the excel file(s)) to commands to do this change and then 
switch it back to default.

https://social.technet.microsoft.com/Forums/scriptcenter/en-US/e1a75bbc-82ab-4afb-a082-731dacb04a3e/export-to-csv-but-with-a-custom-delimiter?forum=ITCG
TLDR;
Run the script given in the thread

Chip


> Pat,
> As I understand it, in a cvs file, all string values should be 
> enclosed inside “.
> This means that a CR is simply part of the cell’s string.
> If you open the exported file with a text editor, you should see the 
> CR enclosed inside “.
> If it isn’t, the Excel export is not working correctly.
> If it is enclosed, I would be looking at the code doing the import - 
> it is not working correctly.
> Cheers, Keith
> 
>> Keith - if you export from Excel to csv, you still have the problem with
>> embedded Return characters.
> 
>>> Sometimes an Excel csv export doesn’t comply completely with the cvs
>>> rules, but mostly it does.
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

Hell is other people 
 Jean-Paul Sartre
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 structure:
  [Appts]Title
  [Appts]Start_Date
  [Appts]Start_Time

I want to produce this sort of object:
  { title: "foo", start: '2018-02-12T08:30:00Z' }

Using "OB Copy"I can create a "template" object that will convert the 
pointer->[Appts]Title into the "title" attribute in the copied object. So far 
so good. But what's a clean method to convert the date & time fields in the 
record into a single field in the object? 

What I'm doing right now is manually processing the generated object via code 
that does OB SET and OB REMOVE. Not ideal, but it works. Obviously method 
pointers would be a perfect solution, but in the unfortunate absence of 
perfection is there another solution that I'm missing?



Thanks for your help.

- bill
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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.

http://doc.4d.com/4Dv15/4D/15.5/OB-Copy.301-3576906.en.html

for a selection, you could call APPEND TO ARRAY and OB Copy inside APPLY TO 
SELECTION.

like you say, the JSON commands are not the right tool for this kind of task 
because there is no need to produce text.

2018/03/08 23:41、Bill Hutten via 4D_Tech 
<4d_tech@lists.4d.com> のメール:

Yeah - I'm currently doing: "Selection to JSON" and then "JSON PARSE ARRAY" but 
that's kindadumb. Also there's no "Record to JSON" or "Record to Object", 
so when I want to do that I've got to do a ONE RECORD SELECT which is also a 
hassle... hm.



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 currently doing: "Selection to JSON" and then "JSON PARSE ARRAY" 
> but that's kindadumb. Also there's no "Record to JSON" or "Record to 
> Object", so when I want to do that I've got to do a ONE RECORD SELECT which 
> is also a hassle... hm.
> 
> 

I am using Cannon’s Object code library for this.

Milan

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 no "Record to JSON" or "Record to Object", 
so when I want to do that I've got to do a ONE RECORD SELECT which is also a 
hassle... hm.


- bill
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 via 4D_Tech <4d_tech@lists.4d.com>:
> 
> 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 vice-versa as 
> well? Or do I still have to write these?
> 
> 
> Thanks, apologies for the "please do my homework" question, etc.
> 
> 
> - bill
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **


--
heubach media
Osterfeldstr. 12-14 | Haus 1 | Eingang Nord
22529 Hamburg
tel: 040 / 52 10 59 - 10 | fax: -99
mail: i...@heubach-media.de
home: www.heubach-media.de
Geschäftsführer|CEO: Matthias Heubach

Mieten Sie Ihre Computer, iPads & Drucker für Ihre Events bei:
http://www.milo-rental.com

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten 
haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht 
gestattet.
 
This e-mail may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail.
Any unauthorized copying, disclosure or distribution of the
material in this e-mail is strictly forbidden.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

"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 vice-versa as 
well? Or do I still have to write these?


Thanks, apologies for the "please do my homework" question, etc.


- bill
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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 new constants file.
> How do I edit one that already exists? I'd rather not use a text
> editor. (I looked at a custom constants .xlf file and the syntax did
> not seem overly obvious to me.)




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**