Re: ORDA to get "record number" value

[Gianluca Rigotti via 4D_Tech]

Thanks to all for the help!

Gianluca

> Il giorno 28 nov 2018, alle ore 20:52, John DeSoi via 4D_Tech 
> <4d_tech@lists.4d.com> ha scritto:
> If you only need to emulate the Record number function for a particular 
> entity, you could use getKey() to get the primary key and then Find in field 
> to get the record number.

Gianluca Rigotti
--
Via Rupi di via XXIX Settembre, 27
60125 Ancona (AN)
ITALY
--
T: +39 071 9987145
M: +39 335 1360105, +39 338 4550245
mail: gianluca.rigo...@me.com, gianluca.rigo...@gmail.com
skype: gianluca.rigotti

**
4D Internet Users Group (4D iNUG)
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: v13 - Exporting tab delimited

[Keisuke Miyako via 4D_Tech]

you can export related fields.

the component expects an object array as JSON.
you just use 4D commands to populate that array however way you like.

true, Selection to JSON does not activate automatic relations,
but it is by no means the only way to create an object array.

the component is quite flexible,
rows can have different number of columns, for example.

as you can see in the example,

https://github.com/miyako/4d-component-csv

export is done in 2 steps: create JSON, convert JSON to CSV.
likewise import is done in 2 steps: convert CSV to 2D text array, apply to 
selection based on the 2D array.

2018/11/29 15:19、Chip Scheide 
<4d_o...@pghrepository.org>のメール:
BTW - my impression on the CSV export is that it would work for a simple one 
table export, but that a complex export (like an invoice) would not really be 
possible using just you component.



**
4D Internet Users Group (4D iNUG)
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: v13 - Exporting tab delimited

[Chip Scheide via 4D_Tech]

I did get a copy, and opened it. - Thanks

I pulled some of the regex from it.
hence the questions earlier about why the results from the regex.

BTW - my impression on the CSV export is that it would work for a simple one 
table export, but that a complex export (like an invoice) would not really be 
possible using just you component.

Did I understand how the object(s) worked correctly? As I did not see a way to 
do relational data export.

Thanks

> that's fair, exporting XML spreadsheets only makes sense if the idea 
> is to open it with Excel.
> 
> for CSV or TSV with proper quotation of data that contains CR, LF, 
> quotes, commas, etc.
> the example https://github.com/miyako/4d-component-csv is for v15 and above
> but the core regex stuff might be portable to v13.
> 
> 2018/11/29 0:30、Chip Scheide 
> <4d_o...@pghrepository.org>のメール:
> And yes I realize the irony - intentional - in using xml/html style
> markers for the rant  :)
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: Integration with card payment terminal

[Keisuke Miyako via 4D_Tech]

it seems like they offer a REST API

https://epayments.developer-ingenico.com/documentation/sdk/

2018/11/24 16:24、macjimbo via 4D_Tech 
<4d_tech@lists.4d.com>のメール:

Has anyone integrated a 4D application with a chip & pin terminal eg
Ingenico?



**
4D Internet Users Group (4D iNUG)
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: v16.4 Desktop application, Rejected

[Keisuke Miyako via 4D_Tech]

2018/11/27 1:20、Carl Aage Wangel via 4D_Tech 
<4d_tech@lists.4D.com>のメール:
But I am at a bit of a loss as where to find OpenSSL in 4D and how to update
the libraries (same for jQuery).

the file names are libeay32.dll and ssleay32.dll on windows.
but again, the ones used by 4D (adjacent to 4D.exe) are up-to-date.
it is the one inside Resources/php/Windows that is being warned.
if you don't need PHP Execute, you could just trash the php folder altogether.

I see jquery.js inside \Resources\Internal 
Components\runtime.4dbase\Resources\js\lib which I guess is used by the welcome 
wizard.
I guess you could replace it with a copy from https://jquery.com if that's what 
you want.

I have been using 4D since version 1 (or
2?) but have never fiddled with OpenSSL. As I understand it OpenSSL v0.9.8
was part of 4D 2004, so it seems strange that the PHP include in 4D uses
this old version.

OpenSSL was at 0.9.8 for a very very long time.
it was kind of stable in its own rights.

As to jQuery isn't the time and date picker jQuery?

no. the widgets are pure 4D forms.

As mentioned I have no working experience with OpenSSL but as I understand
it, version 1.1.x or 1.0.x are the versions to download.


**
4D Internet Users Group (4D iNUG)
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: v13 - Exporting tab delimited

[Keisuke Miyako via 4D_Tech]

that's fair, exporting XML spreadsheets only makes sense if the idea is to open 
it with Excel.

for CSV or TSV with proper quotation of data that contains CR, LF, quotes, 
commas, etc.
the example https://github.com/miyako/4d-component-csv is for v15 and above
but the core regex stuff might be portable to v13.

2018/11/29 0:30、Chip Scheide 
<4d_o...@pghrepository.org>のメール:
And yes I realize the irony - intentional - in using xml/html style
markers for the rant  :)



**
4D Internet Users Group (4D iNUG)
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: PDF - TEXT CONVERSION

[Keisuke Miyako via 4D_Tech]

it generally fails you when passed a complex PDF (redundant text, etc) but you 
could try:

https://github.com/miyako/4d-component-poppler
https://github.com/miyako/4d-plugin-PDF2TEXT

this might work too (but you would have to research the syntax)

https://github.com/miyako/4d-plugin-gs



**
4D Internet Users Group (4D iNUG)
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: ORDA to get "record number" value

[John DeSoi via 4D_Tech]

If you only need to emulate the Record number function for a particular entity, 
you could use getKey() to get the primary key and then Find in field to get the 
record number.

John DeSoi, Ph.D.



> On Nov 23, 2018, at 11:10 AM, Gianluca Rigotti via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi all,
> anyone know if there is a way to get the same value returned by “Record 
> Number” using an ORDA query?

**
4D Internet Users Group (4D iNUG)
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: [off-ish] Regex help

[Chip Scheide via 4D_Tech]

Peter
Thanks for that explanation!

On Wed, 28 Nov 2018 20:27:40 +0100, Peter Bozek wrote:
> On Wed, Nov 28, 2018 at 7:30 PM Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Thanks Kirk,
>> 
>> According to Wiki :
>> . - matches any single character
>> ( ) - defines a marked subexpression
>> * - matches the preceding element zero or more times
>> so... as I read the definitions...
>> "(.*:)"
>> 
>> match any character(s), before a ":"
>> a file path (on a Mac) is  :  :  ... : 
>> 
>> Match Regex says:
>> "...If you pass arrays, the command returns the position and length of
>> the occurrence in the element zero of the arrays and the positions and
>> lengths of the groups captured by the regular expression in the
>> following elements."
>> 
>> so I would expect(ed)
>> Match regex($folderPathMotif;$File_Path;1;$path_pos;$path_len)
>> 
>> to populate the arrays with each occurrence of ":", as your supplied
>> code appears to do,
>> OR
>> if the Match Regex does not find/report all occurrences of ":" to
>> report the FIRST instance of a ":", not the last.
>> 
> 
> Regex behaves like that because, by default, its matching is greedy, what
> means it tries to match the pattern to as many characters as possible. In
> your case, it tries to find longest run that match pattern .*; - and the
> run consist of all characters up to last :.
> 
> If you want the match stop on first occurrence of : you need to make
> operator * ungreedy by attaching ? to it. If you try pattern (.*?:) it
> should return substring up to first :. While pattern .*: says "find the
> longest run of characters ending with :" pattern .*?: means "find the
> shortest run of characters ending with :
> 
> Size of array is number of matching groups, in your case 1. This is how it
> works, IMHO. If the whole pattern repeats itself several times, you need to
> run Match regex in loop.
> 
> HTH,
> 
> --
> 
> Peter Bozek
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
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: ORDA to get "record number" value

[Tim Nevels via 4D_Tech]

On Nov 28, 2018, at 1:27 PM, Christian Sakowski wrote:

> Oh… didn’t noticed this. Thanks for the hint.
> But anyways… i think he has the answer(s).

This thread is as bad as the 4D Forums thread. Nobody will give this guy a 
direct answer, so he can move on and get some real work done. 

Gianluca,

You cannot get the “Record Number” by using ORDA. So if you need the 4D record 
number, abandon using ORDA and go back to using the traditional 4D commands 
that do fully support Record Number. 

You may have a strong desire to use ORDA right now because it is new a great 
and all that. But in this particular case, you will not have success if you 
need Record Numbers.

Get your work done migrating your database to stop using Record Numbers. Once 
that is done, you can go back to using ORDA for database access.

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com
*

**
4D Internet Users Group (4D iNUG)
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: [off-ish] Regex help

[Peter Bozek via 4D_Tech]

On Wed, Nov 28, 2018 at 7:30 PM Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Thanks Kirk,
>
> According to Wiki :
> . - matches any single character
> ( ) - defines a marked subexpression
> * - matches the preceding element zero or more times
> so... as I read the definitions...
> "(.*:)"
>
> match any character(s), before a ":"
> a file path (on a Mac) is  :  :  ... : 
>
> Match Regex says:
> "...If you pass arrays, the command returns the position and length of
> the occurrence in the element zero of the arrays and the positions and
> lengths of the groups captured by the regular expression in the
> following elements."
>
> so I would expect(ed)
> Match regex($folderPathMotif;$File_Path;1;$path_pos;$path_len)
>
> to populate the arrays with each occurrence of ":", as your supplied
> code appears to do,
> OR
> if the Match Regex does not find/report all occurrences of ":" to
> report the FIRST instance of a ":", not the last.
>

Regex behaves like that because, by default, its matching is greedy, what
means it tries to match the pattern to as many characters as possible. In
your case, it tries to find longest run that match pattern .*; - and the
run consist of all characters up to last :.

If you want the match stop on first occurrence of : you need to make
operator * ungreedy by attaching ? to it. If you try pattern (.*?:) it
should return substring up to first :. While pattern .*: says "find the
longest run of characters ending with :" pattern .*?: means "find the
shortest run of characters ending with :

Size of array is number of matching groups, in your case 1. This is how it
works, IMHO. If the whole pattern repeats itself several times, you need to
run Match regex in loop.

HTH,

--

Peter Bozek
**
4D Internet Users Group (4D iNUG)
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: ORDA to get "record number" value

[Christian Sakowski via 4D_Tech]

Oh… didn’t noticed this. Thanks for the hint.
But anyways… i think he has the answer(s).
--

Grüße/Regards,
[heubach-media] | Christian Sakowski
christian.sakow...@heubach-media.de
Tel: +49/(0)40/52 10 59-23




> Am 28.11.2018 um 20:03 schrieb Lee Hinde via 4D_Tech <4d_tech@lists.4d.com>:
> 
> That’s his thread. :-) 
> 
> 
>> On Nov 28, 2018, at 10:48 AM, Christian Sakowski via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Hi,
>> 
>> see discussion here:
>> 
>> http://forums.4d.com/Post/FR/27391864/1/27436514#27436514
>> --
>> 
>> Grüße/Regards,
>> [heubach-media] | Christian Sakowski
>> christian.sakow...@heubach-media.de
>> Tel: +49/(0)40/52 10 59-23
>> 
>> 
>> 
>> 
>>> Am 23.11.2018 um 18:10 schrieb Gianluca Rigotti via 4D_Tech 
>>> <4d_tech@lists.4d.com>:
>>> 
>>> Hi all,
>>> anyone know if there is a way to get the same value returned by “Record 
>>> Number” using an ORDA query?
>>> 
>>> TIA,
>>> Gianluca
>>> 
>>> 
>>> Gianluca Rigotti
>> 
>> 
>> --
>> 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
>> =
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: ORDA to get "record number" value

[Lee Hinde via 4D_Tech]

That’s his thread. :-) 


> On Nov 28, 2018, at 10:48 AM, Christian Sakowski via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi,
> 
> see discussion here:
> 
> http://forums.4d.com/Post/FR/27391864/1/27436514#27436514
> --
> 
> Grüße/Regards,
> [heubach-media] | Christian Sakowski
> christian.sakow...@heubach-media.de
> Tel: +49/(0)40/52 10 59-23
> 
> 
> 
> 
>> Am 23.11.2018 um 18:10 schrieb Gianluca Rigotti via 4D_Tech 
>> <4d_tech@lists.4d.com>:
>> 
>> Hi all,
>> anyone know if there is a way to get the same value returned by “Record 
>> Number” using an ORDA query?
>> 
>> TIA,
>> Gianluca
>> 
>> 
>> Gianluca Rigotti
> 
> 
> --
> 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
> =

**
4D Internet Users Group (4D iNUG)
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: ORDA to get "record number" value

[Christian Sakowski via 4D_Tech]

Hi,

see discussion here:

http://forums.4d.com/Post/FR/27391864/1/27436514#27436514
--

Grüße/Regards,
[heubach-media] | Christian Sakowski
christian.sakow...@heubach-media.de
Tel: +49/(0)40/52 10 59-23




> Am 23.11.2018 um 18:10 schrieb Gianluca Rigotti via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Hi all,
> anyone know if there is a way to get the same value returned by “Record 
> Number” using an ORDA query?
> 
> TIA,
> Gianluca
> 
> 
> Gianluca Rigotti
> --
> Via Rupi di via XXIX Settembre, 27
> 60125 Ancona (AN)
> ITALY
> --
> T: +39 071 9987145
> M: +39 335 1360105, +39 338 4550245
> mail: gianluca.rigo...@me.com, gianluca.rigo...@gmail.com
> skype: gianluca.rigotti
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: [off-ish] Regex help

[Chip Scheide via 4D_Tech]

Thanks Kirk,

That will be useful, but mostly I am wondering based on what (very 
tiny) understanding I have of Regex why the previously posted statement 
does not do what your loop does.

According to Wiki :
. - matches any single character
( ) - defines a marked subexpression
* - matches the preceding element zero or more times
so... as I read the definitions...
"(.*:)"

match any character(s), before a ":"
a file path (on a Mac) is  :  :  ... : 

Match Regex says:
"...If you pass arrays, the command returns the position and length of 
the occurrence in the element zero of the arrays and the positions and 
lengths of the groups captured by the regular expression in the 
following elements."

so I would expect(ed) 
Match regex($folderPathMotif;$File_Path;1;$path_pos;$path_len)

to populate the arrays with each occurrence of ":", as your supplied 
code appears to do, 
OR 
if the Match Regex does not find/report all occurrences of ":" to 
report the FIRST instance of a ":", not the last.

Thanks
again
Chip

On Wed, 28 Nov 2018 10:16:01 -0800, Kirk Brooks via 4D_Tech wrote:
> Chip,
> 
> I think what you want is to parse the path into its component parts.
> 
> This this pattern for matching:
> 
> ([ \w\d-_]+):
> 
> This will match letters, numbers, spaces, underscores and dashes up to the
> semi colon. You will want to use it in a loop like so:
> 
> $pattern:="([ \\w\\d-_]+):"
> $start:=1
> While(Match regex($patters;$text;$start;$aPos;$aLen))  //  pass arrays for
> pos and len
> 
> //  $aLen[0]  will be the length of the entire match
> 
> // $aLen[1] will be the length of the match within the parens
> 
> APPEND TO ARRAY($aTheParts;Substring($text;$aPos{1};$aLen{1})
> 
> $start:=$aPos{0}+$aLen{0}  // move up to the next match
> 
> End while
> 
> 
> On Wed, Nov 28, 2018 at 9:51 AM Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> can anyone who has a clue help me?
>> 
>> I am looking at some code:
>> Match regex($folderPathMotif;$File_Path;1;$path_pos;$path_len)
>> 
>> where:
>> ARRAY LONGINT($path_pos;0)
>> ARRAY LONGINT($path_len;0)
>> $folderPathMotif:="(.*:)"
>> and
>> File_Path is, well.., a file path on a Mac (so folder separator is ":")
>> 
>> When the above regex runs, $Path_pos and $path_len each have 1 element,
>> and that element is a reference to the LAST occurrence of ":" in the
>> file path.
>> 
>> Why does the regex not populate the arrays with the location of ALL
>> occurrences of ":", or the first occurrence of ":"?
>> 
>> Thanks for any help...
>> and off Nug help is fine
>> ---
>> Gas is for washing parts
>> Alcohol is for drinkin'
>> Nitromethane is for racing
>> **
>> 4D Internet Users Group (4D iNUG)
>> 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)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

ORDA to get "record number" value

[Gianluca Rigotti via 4D_Tech]

Hi all,
anyone know if there is a way to get the same value returned by “Record Number” 
using an ORDA query?

TIA,
Gianluca


Gianluca Rigotti
--
Via Rupi di via XXIX Settembre, 27
60125 Ancona (AN)
ITALY
--
T: +39 071 9987145
M: +39 335 1360105, +39 338 4550245
mail: gianluca.rigo...@me.com, gianluca.rigo...@gmail.com
skype: gianluca.rigotti

**
4D Internet Users Group (4D iNUG)
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: PDF - TEXT CONVERSION

[Kirk Brooks via 4D_Tech]

Ferdinando,
Look in Miyako's github repos - he posted a plugin or component there some
time ago that does this.
https://github.com/miyako

On Wed, Nov 28, 2018 at 10:12 AM stardata.info via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi all,
>
> In one 4D application, I need to convert one pdf document in a text file.
>
> Someone know a plugin that does this?
>
> Thanks
>
> Ferdinando
>
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: [off-ish] Regex help

[Kirk Brooks via 4D_Tech]

Chip,

I think what you want is to parse the path into its component parts.

This this pattern for matching:

([ \w\d-_]+):

This will match letters, numbers, spaces, underscores and dashes up to the
semi colon. You will want to use it in a loop like so:

$pattern:="([ \\w\\d-_]+):"
$start:=1
While(Match regex($patters;$text;$start;$aPos;$aLen))  //  pass arrays for
pos and len

//  $aLen[0]  will be the length of the entire match

// $aLen[1] will be the length of the match within the parens

APPEND TO ARRAY($aTheParts;Substring($text;$aPos{1};$aLen{1})

$start:=$aPos{0}+$aLen{0}  // move up to the next match

End while


On Wed, Nov 28, 2018 at 9:51 AM Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> can anyone who has a clue help me?
>
> I am looking at some code:
> Match regex($folderPathMotif;$File_Path;1;$path_pos;$path_len)
>
> where:
> ARRAY LONGINT($path_pos;0)
> ARRAY LONGINT($path_len;0)
> $folderPathMotif:="(.*:)"
> and
> File_Path is, well.., a file path on a Mac (so folder separator is ":")
>
> When the above regex runs, $Path_pos and $path_len each have 1 element,
> and that element is a reference to the LAST occurrence of ":" in the
> file path.
>
> Why does the regex not populate the arrays with the location of ALL
> occurrences of ":", or the first occurrence of ":"?
>
> Thanks for any help...
> and off Nug help is fine
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 4D Internet Users Group (4D iNUG)
> 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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

PDF - TEXT CONVERSION

[stardata.info via 4D_Tech]

Hi all,

In one 4D application, I need to convert one pdf document in a text file.

Someone know a plugin that does this?

Thanks

Ferdinando

**
4D Internet Users Group (4D iNUG)
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: Need to convert HTML page with table to JSON

[Tim Nevels via 4D_Tech]

On Nov 28, 2018, at 3:01 AM, Keisuke Miyakowrote:

> the web site you mentioned uses this file
> 
> https://github.com/abdmob/x2js
> 
> but the real challenge is to cajole HTML code that is not strictly XML

Good idea. I had not thought to try and do a "DOM Parse XML variable" on the 
web page source. I just tried it and it worked! This web page is super simple 
as it is from a medical instruments test device, so the DOM was easily loaded. 
Just basic HTML, some CSS and a little Javascript. 

Thanks for the idea. Now I can use 4D’s built in DOM XML commands to extract 
the data I need. Gonna be easy to make the JSON.

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com
*

**
4D Internet Users Group (4D iNUG)
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: Sending Attachment

[Jeffrey Kain via 4D_Tech]

Is SMTP_Attachment expecting a unix-style path? You might try converting it to 
a Mac style path since the 4DIC plug-in is so old. 

See: 
http://doc.4d.com/4Dv15/4D/15.6/Convert-path-POSIX-to-system.301-3817259.en.html

> On Nov 24, 2018, at 1:09 PM, C Michael Jones via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hello everyone,
> 
> I can’t figure out how to send an attachment (Mac OS 10.13.4): 
> 
> 
> //cmj project method Email_Complex
>  //trace
> C_TEXT($1;$ToAddress)
> C_TEXT($2;$Subject)
> C_TEXT($3;$Message)
> C_LONGINT($smtp_id)
> 
> $ToAddress:="jone...@me.com"
> $Subject:="Test For Sending Attachment"
> $Message:="This is the current time:"+string(current time)
> $error:=SMTP_New ($smtp_id)
> $error:=SMTP_Host ($smtp_id;"smtp.gmail.com")
> $error:=SMTP_From ($smtp_id;"tdc.rallymas...@gmail.com")
> $error:=SMTP_ReplyTo ($smtp_id;"cmichaeljo...@icloud.com")
> $error:=SMTP_Subject ($smtp_id;$Subject)
> $error:=SMTP_To ($smtp_id;$ToAddress;1)
> $error:=SMTP_Body ($smtp_id;$Message)
> $error:=SMTP_Attachment 
> ($smtp_id;"/Users/cmichaeljones/Desktop/Deer.jpg";2;0) 
> $error:=SMTP_Auth ($smtp_id;"tdc.rallymas...@gmail.com”;”MySecretPassword”)
> $error:=SMTP_Send ($smtp_id)
> 
> If ($Error#0)
>  BEEP
>  ALERT("Error: SMTP_Send"+Char(13)+String($Error)+Char(13)+IT_ErrorText 
> ($Error))
> Else 
>  ALERT("The message has been sent.")
> End if 
> 
> $error:=SMTP_Clear ($smtp_id)
> 
> The above sends the email but the attachment is missing.
> 
> Thanks in advance, Mike
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: v13 - Exporting tab delimited

[THOMAS BENEDICT via 4D_Tech]

Hi Chip,

The trick with Excel is that it uses a 'soft return' within a cell. To get that 
soft-return within Excel you type Alt-Return (on Windows) or 
Control-Option-Return (on MacOS).

I don't remember what the Character Code is for that character, but that's what 
you'll need to include in your extract script. I seem to recall that it is a 
newline. Google should be able to help you.

Hope this helps, and sorry it doesn't have more details.

Tom Benedict
Optum

> On November 27, 2018 at 2:07 PM Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 
> I would like to be able to embed a return and/or line feed into column 
> in a tab delimited file (opening with Excel).
>
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Sending Attachment

[C Michael Jones via 4D_Tech]

Hello everyone,

I can’t figure out how to send an attachment (Mac OS 10.13.4): 


 //cmj project method Email_Complex
  //trace
C_TEXT($1;$ToAddress)
C_TEXT($2;$Subject)
C_TEXT($3;$Message)
C_LONGINT($smtp_id)

$ToAddress:="jone...@me.com"
$Subject:="Test For Sending Attachment"
$Message:="This is the current time:"+string(current time)
$error:=SMTP_New ($smtp_id)
$error:=SMTP_Host ($smtp_id;"smtp.gmail.com")
$error:=SMTP_From ($smtp_id;"tdc.rallymas...@gmail.com")
$error:=SMTP_ReplyTo ($smtp_id;"cmichaeljo...@icloud.com")
$error:=SMTP_Subject ($smtp_id;$Subject)
$error:=SMTP_To ($smtp_id;$ToAddress;1)
$error:=SMTP_Body ($smtp_id;$Message)
$error:=SMTP_Attachment ($smtp_id;"/Users/cmichaeljones/Desktop/Deer.jpg";2;0) 
$error:=SMTP_Auth ($smtp_id;"tdc.rallymas...@gmail.com”;”MySecretPassword”)
$error:=SMTP_Send ($smtp_id)

If ($Error#0)
  BEEP
  ALERT("Error: SMTP_Send"+Char(13)+String($Error)+Char(13)+IT_ErrorText 
($Error))
Else 
  ALERT("The message has been sent.")
End if 

$error:=SMTP_Clear ($smtp_id)

The above sends the email but the attachment is missing.

Thanks in advance, Mike
**
4D Internet Users Group (4D iNUG)
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: Using a mirror for web serving

[THOMAS BENEDICT via 4D_Tech]

On November 25, 2018 at 8:41 AM David Rose via 4D_Tech <4d_tech@lists.4d.com> 
wrote: 

> Is anyone using New log file and INTEGRATE MIRROR LOG FILE to create a mirror 
> db on a remote cloud server, like Amazon EC2, for the purpose of providing 
> near-real-time read-only offsite web server functionality?
> If so, any advice for implementation? (I use WS_FTP for another process in 
> the same database to copy files from the db computer to a remote ftp site 
> every n minutes, and I'm guessing I can do likewise with log files.)
> 

Hi David,

There's no reason why this wouldn't work. You could mirror every minute (or 
less). Like you state, READ ONLY is mandatory. FTP, WebService or File Sharing 
will work to support the transport layer for log shipping.

Tom Benedict
Optum Inc
**
4D Internet Users Group (4D iNUG)
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: v13 - Exporting tab delimited

[THOMAS BENEDICT via 4D_Tech]

I spent many hours sorting this out a few months ago. The file needed to be 
easily read by Excel (as in your case) plus it needed to be importable into SQL 
Server. I ended up creating a CSV with CRLF record delimiters. But I also 
processed the embedded soft returns in a way that escapes me right now. I'll 
try to look that code up tomorrow, if it still exists.

Once you have a .csv, it can be double-clicked to open in Excel avoiding the 
Import Wizard entirely. BTW, the difficulty here is all due to Excel's bizarre 
and unique way of handling things.

I'll see whether I can shed any light on this tomorrow.

Tom

> On November 27, 2018 at 3:50 PM Chip Scheide <4d_o...@pghrepository.org> 
> wrote:
> 
> 
> Thomas & Chuck
> the intent is to create the export file in such a manner that NO user 
> intervention is required to open the file with the embedded returns.
> 
> changing the end of row marker will work, but then the user(s) need to know 
> that -- and they won't or they won't remember etc -- after all they are 
> users
> 
> typing Alt-return is not really an option s the data is already exported...
> The embedded character is listed as &Char(10)& for line feed, and &Char(13)& 
> for carriage return, however, replacing the return (4D) with either or both 
> of these strings does NOT result in return or line feed in Excel; just the 
> exact characters "&Char(10)&"
> A bit of experimentation shows that to get the character code to work 
> requires a formal where for example you have
> =A1+&Char(10)&+B3
> 
> any other ideas??
> 
> Thanks
> 
> > Hi Chip,
> > 
> > The trick with Excel is that it uses a 'soft return' within a cell. 
> > To get that soft-return within Excel you type Alt-Return (on Windows) 
> > or Control-Option-Return (on MacOS).
> > 
> > I don't remember what the Character Code is for that character, but 
> > that's what you'll need to include in your extract script. I seem to 
> > recall that it is a newline. Google should be able to help you.
> > 
> > Hope this helps, and sorry it doesn't have more details.
> > 
> > Tom Benedict
> > Optum
> > 
> >> On November 27, 2018 at 2:07 PM Chip Scheide via 4D_Tech 
> >> <4d_tech@lists.4d.com> wrote:
> >> 
> >> 
> >> I would like to be able to embed a return and/or line feed into column 
> >> in a tab delimited file (opening with Excel).
> >> 
> > 
> 
> Hell is other people 
>  Jean-Paul Sartre
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

[off-ish] Regex help

[Chip Scheide via 4D_Tech]

can anyone who has a clue help me?

I am looking at some code:
Match regex($folderPathMotif;$File_Path;1;$path_pos;$path_len)

where:
ARRAY LONGINT($path_pos;0)
ARRAY LONGINT($path_len;0)
$folderPathMotif:="(.*:)"
and 
File_Path is, well.., a file path on a Mac (so folder separator is ":")

When the above regex runs, $Path_pos and $path_len each have 1 element, 
and that element is a reference to the LAST occurrence of ":" in the 
file path.

Why does the regex not populate the arrays with the location of ALL 
occurrences of ":", or the first occurrence of ":"?

Thanks for any help...
and off Nug help is fine
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
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: Unusual crash / failure to start 4D

[Magnus Torell via 4D_Tech]

Dear Mike,

In my case I suspected that the installation of an International (UK / US /
...)
windows in combination with scandinavian languages as regional settings was
the cause.
With "in combination" I mean that during the first initial setup of windows
I choose
a scandinavian language i.e.. swedish in my case.
If i reinstalled windows from an swedish (in my case) usb installer and also
used
swedish regional settings, then 4D worked.
I can't say for sure that I tested to revert to some UK / US regional
settings
on the original windows installation, but I think I did test this and it
worked also.

Best Regards
Magnus Torell 



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
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: Unusual crash / failure to start 4D

[Michael McCall via 4D_Tech]

Hi Magnus,

That seems like a promising explanation. I misspoke. I will double check but I 
think we did also have them try a version of our software using 4D v17. So if 
it was corrected in 16.2 and we did it would appear that it may have regressed. 

Just to clarify, are you suggesting that it is a mix of installing Windows for 
one region and then attempting to change the settings after that.  If that is 
the case does it mean they would need to reinstall Windows again or just change 
the settings back to the original region they used at install?

Thank you for the assistance,
Mike McCall

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Magnus Torell via 
4D_Tech
Sent: Wednesday, November 28, 2018 8:19 AM
To: 4d_tech@lists.4d.com
Cc: Magnus Torell 
Subject: Re: Unusual crash / failure to start 4D

Dear Mike,

Maybe this is related to what I have experienced?
http://forums.4d.com/Post/EN/26586808/1/26586809
I did make 2 separate topics on this same issue.

I have not really understood what is the source of this problem.
However it seems to be related to localizations and regional settings.
If I install a swedish version of windows everything works.
I think that I could also change regional settings to some english/us settings 
and it worked. So maybe the combination of a an international install of 
windows and a regional settings containing "nordic countries" is problematic.
This can be related to problem with the command SET DATABASE LOCALIZATION under 
these combinations of Regional settings.

Not much of help, but maybe you can fill the gaps also for me.

Best Regards
Magnus Torell



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
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)
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: Unusual crash / failure to start 4D

[Michael McCall via 4D_Tech]

Thank you Lutz,

We are not deliberately doing any XML processing at startup. So unless 4D is 
doing something in the background that wouldn't appear to be this issue 
unfortunately. 

Mike

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Epperlein, Lutz 
(agendo) via 4D_Tech
Sent: Wednesday, November 28, 2018 8:20 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Epperlein, Lutz (agendo) 
Subject: RE: Unusual crash / failure to start 4D

Do you do some XML Processing?
If yes, you should request some data from this user try to reproduce the issue 
with this data. Maybe there is something wrong with parsong of XML in 4D.
The "" says only 4D is not able to produce a useful 
stacktrace of the crash.


HTH
Regards
Lutz

> Exception caught: EXCEPTION_ACCESS_VIOLATION
> Time: 2018-11-28T09:44:18
>
> xercesc_3_1::DOMImplementationRegistry::getDOMImplementation
> xercesc_3_1::DOMImplementationRegistry::getDOMImplementation
> 
> 
> 
> 
> 
> 
> 
> BaseThreadInitThunk
**
4D Internet Users Group (4D iNUG)
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)
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: Unusual crash / failure to start 4D

[Epperlein, Lutz (agendo) via 4D_Tech]

Do you do some XML Processing?
If yes, you should request some data from this user try to reproduce the issue 
with this data. Maybe there is something wrong with parsong of XML in 4D.
The "" says only 4D is not able to produce a useful 
stacktrace of the crash.


HTH
Regards
Lutz

> Exception caught: EXCEPTION_ACCESS_VIOLATION
> Time: 2018-11-28T09:44:18
>
> xercesc_3_1::DOMImplementationRegistry::getDOMImplementation
> xercesc_3_1::DOMImplementationRegistry::getDOMImplementation
> 
> 
> 
> 
> 
> 
> 
> BaseThreadInitThunk
**
4D Internet Users Group (4D iNUG)
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: Unusual crash / failure to start 4D

[Magnus Torell via 4D_Tech]

Dear Mike,

Maybe this is related to what I have experienced?
http://forums.4d.com/Post/EN/26586808/1/26586809
I did make 2 separate topics on this same issue.

I have not really understood what is the source of this problem.
However it seems to be related to localizations and regional settings.
If I install a swedish version of windows everything works.
I think that I could also change regional settings to some english/us
settings
and it worked. So maybe the combination of a an international install
of windows and a regional settings containing "nordic countries" is
problematic.
This can be related to problem with the command SET DATABASE LOCALIZATION
under these combinations of Regional settings.

Not much of help, but maybe you can fill the gaps also for me.

Best Regards
Magnus Torell



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Unusual crash / failure to start 4D

[Michael McCall via 4D_Tech]

We have a user trying to run our 4D compiled application on a new Windows 10 
computer they just purchased. We've never had a problem with anyone running our 
software on Windows 10 before. 

When they try to start up the application by double click the compiled .exe 
file the wheel next to the cursor briefly spins but then it stops and nothing 
happens. Below is a crash report they've sent. 

Exception caught: EXCEPTION_ACCESS_VIOLATION
Time: 2018-11-28T09:44:18

xercesc_3_1::DOMImplementationRegistry::getDOMImplementation
xercesc_3_1::DOMImplementationRegistry::getDOMImplementation







BaseThreadInitThunk

ADDITIONAL BACKGROUND

Our application is a standalone application which uses 4D's Web Server which 
starts automatically when you start our application. The user having the 
difficulty is in Denmark. They have tried a copy of our application based on 4D 
v14 and 4D v16. They have successfully run our application on Windows 10 before 
on other computers.

Does anyone have any ideas what might be causing this behavior?

Thanks,

Mike McCall 
Facilitate.com 


**
4D Internet Users Group (4D iNUG)
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: Transferring Build Mac Client via Google Drive Web Interface Fails

[Jeremy Roussak via 4D_Tech]

That’s really useful, Miyako. Thanks.

Jeremy

> On 28 Nov 2018, at 08:58, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> the target path can be found in the build project
> 
> for instance, in this example, the path is accessible with the code
> 
> If (Is macOS)
> $path:=$BuildApp.BuildMacDestFolder
> Else
> $path:=$BuildApp.BuildWinDestFolder
> End if
> $path:=$path+"Final Application"+Folder separator
> 
> https://github.com/miyako/4d-component-build-app
> 
> thereafter you can append the app name
> 
> $BuildApp.BuildApplicationName
> 
> with the appropriate extension.
> 
> if you intend to code sign via LEP, you need to convert the path to POSIX and 
> escape reserved characters.
> 
> 
> 
> On 20 Nov 2018, at 15:27, Dave Nasralla via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Is there an easy way to get the file path to the built client and
> server apps for the command line?
**
4D Internet Users Group (4D iNUG)
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: v13 - Exporting tab delimited

[Chip Scheide via 4D_Tech]

Keisuke,
a text file is being created (tab delimited, or CSV) as the exact use 
case for the export may vary by user. Some may/will want to open in 
excel, others may want to use the data in other programs. A text file 
is basic, can (in principle) be opened by anything.


(not) XML for 3 reasons
- one is the above
- while I can read, and can manually (by code) rip an xml file apart*, 
I am not comfortable(?) knowledgable in creating xml.  Sure I can setup 
"tags" ( data ) but F if I know if it is correct, or 
parsable by anything.
- for most (of my) uses xml is a waste of time and space.

* NOTE: I just had a situation where I had to import an "xml" file. The 
file format as provided (and required) does/did not follow xml 
standards (no line breaks, and other issues), so none of the xml 
commands work. Ended up tearing it apart as if it were a fancy 
formatted text file. So much work so much extra garbage in the file to 
skip over 
Converting 1 data block to tab delimited changes the size (characters) 
of the data block from 11 lines, and 400 characters to 1 line and 102 
characters. There is NO, ZERO, NONE advantage to using xml in this 
situation, as if there is any change in the format in the future, the 
code to manage the import will need to be revisited as the "xml" is 
invalid.


And yes I realize the irony - intentional - in using xml/html style 
markers for the rant  :)



On Wed, 28 Nov 2018 08:43:27 +, Keisuke Miyako via 4D_Tech wrote:
> I suppose the right way to create a "cell" with multiple lines in TSV 
> is to use vertical tab char(11) instead of CRLF,
> but the last time I checked, Excel doesn't handle VT well. (Numbers does).
> 
> for CSV with quotes I published
> 
> https://github.com/miyako/4d-component-csv
> 
> which follows the various rules explained here
> 
> https://en.wikipedia.org/wiki/Comma-separated_values
> 
> https://tools.ietf.org/html/rfc4180
> 
> in any case, it doesn't feel right to pretend that CSV or TSV is an 
> Excel spreadsheet.
> 
> why not at least use XML, if XLS or XLSX is a bit of an overkill?
> 
> the method has been around since v2004 (introduction of PROCESS 4D 
> TAGS and DOM/SAX XML commands)
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
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: v13 - Exporting tab delimited

[Chip Scheide via 4D_Tech]

Thanks
- I'll try that too

On Wed, 28 Nov 2018 08:30:01 +, Epperlein, Lutz (agendo) via 
4D_Tech wrote:
> You have to escape the data cell containing the linefeed with double 
> quotes. The linefeed has to be encoded as a LF (0x0a) or as CRLF 
> (0x0d 0x0a).
> 
> E.g.
> Data  data   data 
> data  data   "line1 
> line2"
> datadatadata
> 
> This text file you can drag onto Excel to open it (Windows).
> Double click on Windows Explorer doesn't work since it is a .txt file.
> 
> Better is to save it as a .csv file and use a semicolon ";" instead 
> of a tab. So you can use double click to open it (again on Windows).
> 
> Regards
> Lutz
> 
>> -Original Message-
>> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of 
>> Chip Scheide via
>> 4D_Tech
>> Sent: Tuesday, November 27, 2018 11:08 PM
>> To: 4D iNug Technical <4d_tech@lists.4d.com>
>> Cc: Chip Scheide <4d_o...@pghrepository.org>
>> Subject: v13 - Exporting tab delimited
>> 
>> I would like to be able to embed a return and/or line feed into column
>> in a tab delimited file (opening with Excel).
>> 
>> ex:
>> data  data  text data with return more data  data
>> 
>> 
>> Excel will give me:
>> Col1 Col2Col3
>> Data Datatext data with
>> more datadata
>> 
>> 
>> I can not see a way to do this.
>> Is it possible?
>> if so, how?
>> 
>> Thanks
>> Chip
>> ---
>> Gas is for washing parts
>> Alcohol is for drinkin'
>> Nitromethane is for racing
>> *
>> *
>> 4D Internet Users Group (4D iNUG)
>> 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)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
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: v13 - Exporting tab delimited

[Chip Scheide via 4D_Tech]

THANKS!

On Tue, 27 Nov 2018 16:06:39 -0800 (PST), THOMAS BENEDICT wrote:
> I spent many hours sorting this out a few months ago. The file needed 
> to be easily read by Excel (as in your case) plus it needed to be 
> importable into SQL Server. I ended up creating a CSV with CRLF 
> record delimiters. But I also processed the embedded soft returns in 
> a way that escapes me right now. I'll try to look that code up 
> tomorrow, if it still exists.
> 
> Once you have a .csv, it can be double-clicked to open in Excel 
> avoiding the Import Wizard entirely. BTW, the difficulty here is all 
> due to Excel's bizarre and unique way of handling things.
> 
> I'll see whether I can shed any light on this tomorrow.
> 
> Tom
> 
>> On November 27, 2018 at 3:50 PM Chip Scheide 
>> <4d_o...@pghrepository.org> wrote:
>> 
>> 
>> Thomas & Chuck
>> the intent is to create the export file in such a manner that NO 
>> user intervention is required to open the file with the embedded 
>> returns.
>> 
>> changing the end of row marker will work, but then the user(s) need 
>> to know that -- and they won't or they won't remember etc -- after 
>> all they are users
>> 
>> typing Alt-return is not really an option s the data is already exported...
>> The embedded character is listed as &Char(10)& for line feed, and 
>> &Char(13)& for carriage return, however, replacing the return (4D) 
>> with either or both of these strings does NOT result in return or 
>> line feed in Excel; just the exact characters "&Char(10)&"
>> A bit of experimentation shows that to get the character code to 
>> work requires a formal where for example you have
>> =A1+&Char(10)&+B3
>> 
>> any other ideas??
>> 
>> Thanks
>> 
>>> Hi Chip,
>>> 
>>> The trick with Excel is that it uses a 'soft return' within a cell. 
>>> To get that soft-return within Excel you type Alt-Return (on Windows) 
>>> or Control-Option-Return (on MacOS).
>>> 
>>> I don't remember what the Character Code is for that character, but 
>>> that's what you'll need to include in your extract script. I seem to 
>>> recall that it is a newline. Google should be able to help you.
>>> 
>>> Hope this helps, and sorry it doesn't have more details.
>>> 
>>> Tom Benedict
>>> Optum
>>> 
 On November 27, 2018 at 2:07 PM Chip Scheide via 4D_Tech 
 <4d_tech@lists.4d.com> wrote:
 
 
 I would like to be able to embed a return and/or line feed into column 
 in a tab delimited file (opening with Excel).
 
>>> 
>> 
>> Hell is other people 
>>  Jean-Paul Sartre
> 
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
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: "Failed to create WIC imaging factory"

[Pat Bensky via 4D_Tech]

Thanks Jeffrey - I did find that Microsoft article and sent it to the
client - he says he followed it and that didn't resolve the problem.
I'll suggest the new user account idea. Problem is that they are part of a
large organisation with a not-too-responsive busy IT dept. 

Pat

On Wed, 28 Nov 2018 at 14:21, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Looks like possibly a screwed up OS.
>
>
> https://answers.microsoft.com/en-us/windows/forum/all/fail-create-wic-imaging-factory/b01e6258-b7b5-4c6d-b0b9-65554958378c
>
> https://docs.microsoft.com/en-us/windows/desktop/wic/-wic-api
>
> I'd start by creating a new user account and see if the problem resolves.
> If not, move on to the safe mode with network booting suggestion.  I'd also
> check for third party anti-malware stuff that could be overly aggressive...
> so many problems in Windows seem to always come back to this.
>
>
> > On Nov 28, 2018, at 9:12 AM, Pat Bensky via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Our customer is running on Windows 2008r2. We are compiling on Windows 10
> > using 4D v17r3.
> > When he tries to run our compiled & merged 4D Server, he gets the error:
> >
> > Failed to create WIC Imaging Factory -2147221164
> >
> > I've researched this online but haven't found any helpful info.
> >
> > Anybody run into this, and do you have any idea how to fix it?
> >
> > Thanks!
> >
> > Pat
> >
> >
> > --
> > *
> > CatBase - Top Dog in Data Publishing
> > tel: +44 (0) 207 118 7889
> > w: http://www.catbase.com
> > skype: pat.bensky
> > *
> > **
> > 4D Internet Users Group (4D iNUG)
> > 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)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
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: "Failed to create WIC imaging factory"

[Jeffrey Kain via 4D_Tech]

Looks like possibly a screwed up OS.

https://answers.microsoft.com/en-us/windows/forum/all/fail-create-wic-imaging-factory/b01e6258-b7b5-4c6d-b0b9-65554958378c

https://docs.microsoft.com/en-us/windows/desktop/wic/-wic-api

I'd start by creating a new user account and see if the problem resolves.  If 
not, move on to the safe mode with network booting suggestion.  I'd also check 
for third party anti-malware stuff that could be overly aggressive... so many 
problems in Windows seem to always come back to this.


> On Nov 28, 2018, at 9:12 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Our customer is running on Windows 2008r2. We are compiling on Windows 10
> using 4D v17r3.
> When he tries to run our compiled & merged 4D Server, he gets the error:
> 
> Failed to create WIC Imaging Factory -2147221164
> 
> I've researched this online but haven't found any helpful info.
> 
> Anybody run into this, and do you have any idea how to fix it?
> 
> Thanks!
> 
> Pat
> 
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> 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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

"Failed to create WIC imaging factory"

[Pat Bensky via 4D_Tech]

Our customer is running on Windows 2008r2. We are compiling on Windows 10
using 4D v17r3.
When he tries to run our compiled & merged 4D Server, he gets the error:

Failed to create WIC Imaging Factory -2147221164

I've researched this online but haven't found any helpful info.

Anybody run into this, and do you have any idea how to fix it?

Thanks!

Pat


-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
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: TAOW (Mojave and CREATE THUMBNAIL)

[Keisuke Miyako via 4D_Tech]

TAOW is a support portal.

of course, a large portion of all support cases has an underlying bug,
but still, the primary objective there is to offer support.

partners who open a support case on TAOW,
has the advantage of communicating with a 4D member of staff.
the bug is prioritised because there is a support case attached.

---

now this is controversial,
but I really think "searching for an existing bug" is never going to work.

I happen to read every single bug report submitted every day,
but that is the only reason I know what is happening in 4D.

it is impossible to find a bug you do not know based on a combination of 
semantic key phrases,
because reports contain false assumptions all the time and the description is 
constantly updated.
also, it can be written in any language.

most of the time I search my emails using some identifier that has nothing to 
do with the bug itself,
I can pretty much find it effectively but only because I am already familiar 
with the context of that bug.

you can only look for "known knowns".

2018/11/27 7:26、JOHN BAUGHMAN via 4D_Tech 
<4d_tech@lists.4d.com>のメール:

So I must be going to the wrong place to see the bug list. I always end up at 
taow.4d.com but only see my support cases.
I thought I could search the TAOW for reported issues before reporting my own. 
Is this not the case? If not, how?


**
4D Internet Users Group (4D iNUG)
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: Transferring Build Mac Client via Google Drive Web Interface Fails

[Keisuke Miyako via 4D_Tech]

the target path can be found in the build project

for instance, in this example, the path is accessible with the code

If (Is macOS)
$path:=$BuildApp.BuildMacDestFolder
Else
$path:=$BuildApp.BuildWinDestFolder
End if
$path:=$path+"Final Application"+Folder separator

https://github.com/miyako/4d-component-build-app

thereafter you can append the app name

$BuildApp.BuildApplicationName

with the appropriate extension.

if you intend to code sign via LEP, you need to convert the path to POSIX and 
escape reserved characters.



On 20 Nov 2018, at 15:27, Dave Nasralla via 4D_Tech 
<4d_tech@lists.4d.com> wrote:

Is there an easy way to get the file path to the built client and
server apps for the command line?

**
4D Internet Users Group (4D iNUG)
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: v13 - Exporting tab delimited

[Keisuke Miyako via 4D_Tech]

I suppose the right way to create a "cell" with multiple lines in TSV is to use 
vertical tab char(11) instead of CRLF,
but the last time I checked, Excel doesn't handle VT well. (Numbers does).

for CSV with quotes I published

https://github.com/miyako/4d-component-csv

which follows the various rules explained here

https://en.wikipedia.org/wiki/Comma-separated_values

https://tools.ietf.org/html/rfc4180

in any case, it doesn't feel right to pretend that CSV or TSV is an Excel 
spreadsheet.

why not at least use XML, if XLS or XLSX is a bit of an overkill?

the method has been around since v2004 (introduction of PROCESS 4D TAGS and 
DOM/SAX XML commands)


**
4D Internet Users Group (4D iNUG)
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: v13 - Exporting tab delimited

[Epperlein, Lutz (agendo) via 4D_Tech]

You have to escape the data cell containing the linefeed with double quotes. 
The linefeed has to be encoded as a LF (0x0a) or as CRLF (0x0d 0x0a).

E.g.
Data  data   data 
data  data   "line1 
line2"
datadatadata

This text file you can drag onto Excel to open it (Windows).
Double click on Windows Explorer doesn't work since it is a .txt file.

Better is to save it as a .csv file and use a semicolon ";" instead of a tab. 
So you can use double click to open it (again on Windows).

Regards
Lutz

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip Scheide 
> via
> 4D_Tech
> Sent: Tuesday, November 27, 2018 11:08 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Chip Scheide <4d_o...@pghrepository.org>
> Subject: v13 - Exporting tab delimited
> 
> I would like to be able to embed a return and/or line feed into column
> in a tab delimited file (opening with Excel).
> 
> ex:
> data  data  text data with return more data  data
> 
> 
> Excel will give me:
> Col1  Col2Col3
> Data  Datatext data with
> more data data
> 
> 
> I can not see a way to do this.
> Is it possible?
> if so, how?
> 
> Thanks
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> *
> *
> 4D Internet Users Group (4D iNUG)
> 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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**