Re: ORDA to get "record number" value

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 >

Re: v13 - Exporting tab delimited

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

Re: v13 - Exporting tab delimited

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

Re: Integration with card payment terminal

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?

Re: v16.4 Desktop application, Rejected

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

Re: v13 - Exporting tab delimited

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

Re: PDF - TEXT CONVERSION

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

Re: ORDA to get "record number" value

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

Re: [off-ish] Regex help

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

Re: ORDA to get "record number" value

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.

Re: [off-ish] Regex help

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

Re: ORDA to get "record number" value

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

Re: ORDA to get "record number" value

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 >

Re: ORDA to get "record number" value

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

Re: [off-ish] Regex help

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

ORDA to get "record number" value

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

Re: PDF - TEXT CONVERSION

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

Re: [off-ish] Regex help

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

PDF - TEXT CONVERSION

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

Re: Need to convert HTML page with table to JSON

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

Re: Sending Attachment

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 >

Re: v13 - Exporting tab delimited

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

Sending Attachment

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

Re: v13 - Exporting tab delimited

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

[off-ish] Regex help

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

RE: Unusual crash / failure to start 4D

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

RE: Unusual crash / failure to start 4D

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

RE: Unusual crash / failure to start 4D

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

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

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.

Unusual crash / failure to start 4D

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

Re: Transferring Build Mac Client via Google Drive Web Interface Fails

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

Re: v13 - Exporting tab delimited

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

RE: v13 - Exporting tab delimited

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 >

Re: v13 - Exporting tab delimited

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

Re: "Failed to create WIC imaging factory"

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.

"Failed to create WIC imaging factory"

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

Re: TAOW (Mojave and CREATE THUMBNAIL)

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

Re: Transferring Build Mac Client via Google Drive Web Interface Fails

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

Re: v13 - Exporting tab delimited

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

RE: v13 - Exporting tab delimited

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