Re: Scheduled ISP Maintenance @ 4D Office (France)

[Arnaud de Montard via 4D_Tech]

> Le 4 août 2018 à 00:25, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> [...]
> 
> The ISP @ our French Headquarters is doing a scheduled maintenance that 
> started 20 minutes ago and is planned to last another 4 hours 10 minutes. 

It seems they found refuge in an ice cream shop.  

-- 
Arnaud de Montard 




**
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: Scheduled ISP Maintenance @ 4D Office (France)

[Jeremy French via 4D_Tech]

The URLs are still unreachable as of Monday morning, August 6th Eastern 
Daylight Time.

It’s impossible to connect to:
Taow.4d.com 
Livedoc.4d.com 
Forums.4d.com 


> On Aug 3, 2018, at 6:25 PM, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> scheduled maintenance that started 20 minutes ago and is planned to last 
> another 4 hours 10 minutes. During this time frame, some of our services will 
> be unreachable

**
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: Export text columns containing carriage returns to Excel?

[Chip Scheide via 4D_Tech]

if you can get to the 'user' environment there is an export option for 
XML
(File -> export -> data to file -> File tab)
in the dialog there is an option for format - in the drop down list 
there is an xml option.

This may work for you -- do not know - never used it.
another option might be :
File -> Export -> Data to ODBC source

I am reasonably certain that Excel is/can be an ODBC source so you 
might be able to export that way. Again, never used this option.

One more idea:
File -> export -> Data to file -> Delimeters tab
there are options for you to supply your own delimiter instead of Tab, 
or Return
You could determine some unlikely character (char 254 & 255) come to 
mind.  The ascii chart in the 4D documentation includes the required 
keystroke combination to produce various 'special' characters

  
On Sun, 5 Aug 2018 20:26:15 +, Perkins, Bradley D via 4D_Tech wrote:
> Hi Tom,
> 
> I've been working  this with the QR Editor with some success. Another 
> challenge I've found is that the 4D text fields have carriage 
> returns, carriage return/new line pairs, and even some tabs.  
> Therefore I'll need to nest the calls to Replace string in the proper 
> order to place markers for all three.
> 
> 
> Thanks for pointing out the limitations I will need to see if any of 
> the text fields are larger than 32,767 characters. This is an older 
> system that started life in v3. The output file size will not be an 
> issue.
> 
> Best,
> 
> Brad
> 
> 
> From: Benedict, Tom 
> Sent: Friday, August 3, 2018 2:19:44 PM
> To: Perkins, Bradley D; 4d_tech@lists.4d.com
> Subject: Re: Export text columns containing carriage returns to Excel?
> 
> Brad Perkins writes:
> 
>> I've been asked to provide an export from a legacy 4D system 
>> delivered as an .xlsx file.
> 
>> The challenge I'm facing is that this table contains a number of 
>> text fields and
>> the customer requires the imported column cells to retain the 
>> returns or line feeds
>> in the original text fields. If I do a straight tab-delimited export 
>> with carriage returns
>> as the end of line marker, the imported result does not preserve the 
>> original row
>> because any returns encountered in the text fields are interpreted 
>> as end of row.
> 
>> My other challenge is that I need to do this with out-of-box end 
>> user capabilities
>> from a client (v15.4 remote) against a compiled server. I can't 
>> install plugins, create new methods, etc.
>> It has been many years since I've had to do this type of thing in 4D.
> 
>> Can I replace the carriage returns in the text fields with a special 
>> marker during export?
>> I could replace the Excel cells containing the any carriage return 
>> markers with actual returns after import.
> 
> Use the Quick Report Editor. You can put formulas in the columns 
> which include a call to Replace string.
> 
> There are some limitation which I’ve encountered:
> 
> 
> -  The Quick Report Editor is 32bit (evidently) which limits 
> the size of the output file to 4GB. Hopefully you don’t run in to 
> that limit. (I did recently).
> 
> -  Any given cell in Excel can only hold 32,767 characters. 
> If you have more than that you’ll have to do some fancy segmenting 
> into another column in the output.
> 
> HTH, let me know if you have further questions. I have very recent 
> experience doing just this.
> 
> Tom Benedict
> Optum
> 
> 
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may be used only by the person or entity
> to which it is addressed. If the reader of this e-mail is not the intended
> recipient or his or her authorized agent, the reader is hereby notified
> that any dissemination, distribution or copying of this e-mail is
> prohibited. If you have received this e-mail in error, please notify the
> sender by replying to this message and delete this e-mail immediately.
> **
> 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: SVG Overlay Layer

[John J Foster via 4D_Tech]

> Hi Jim,

I see!

I thought that was just a dialog.

Cool UI and smooth control.

John...

> The On Hover annotation balloon is another svg image on top of the data
> svg image

**
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 - marking field as 'Primary Key'

[Chip Scheide via 4D_Tech]

Arnaud,
Thanks

I did this:
on error call - just make the error go away
for every table
  for every field
is this my "primary key' field?
 sql command as text to set primary key on the field
 execute immediate(above sql command)
   (trying to set a primary key, as primary key generates an error 
which is suppressed by the above on error call)
   

it works to do what I needed, it is fast, and it is done  :)

Chip

On Sun, 5 Aug 2018 12:28:39 +0200, Arnaud de Montard via 4D_Tech wrote:
> 
>> Le 3 août 2018 à 18:12, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> a écrit :
>> 
>> Thanks,
>> I do not really use the online docs
>> but it is nice to know
> 
> SQL script example. 
> 
> ++
> /* tables and primary keys */
> 
> CREATE TABLE Agence
> (
> PK INT32 NOT NULL UNIQUE AUTO_INCREMENT,
> raisonSociale VARCHAR(80),
> complementAdresse VARCHAR(80),
> email VARCHAR(80),
> comments TEXT,
> PRIMARY KEY (PK)
> );
> 
> CREATE TABLE ContactAgence
> (
> PK INT32 NOT NULL UNIQUE AUTO_INCREMENT,
> nom VARCHAR(80),
> prenom VARCHAR(80),
> fonction VARCHAR(80),
> email VARCHAR(80),
> FK_agence INT32,
> comments TEXT,
> PRIMARY KEY (PK)
> );
> 
> /* indexes */
> 
> CREATE INDEX idx1 ON Agence (PK);
> 
> CREATE INDEX idx2 ON ContactAgence (PK);
> 
> /* relation */
> 
> ALTER TABLE ContactAgence ADD CONSTRAINT rel1 FOREIGN KEY (FK_agence) 
> REFERENCES Agence (PK);
> ++
> 
> Note: I never create such relations… 
> 
> -- 
> Arnaud de Montard 
> 
> 
> 
> 
> **
> 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: SVG Overlay Layer

[Jim Dorrance via 4D_Tech]

The annotation svg is much larger than the data svg so the annotation can
pass the boundaries
 of the data svg

On Mon, Aug 6, 2018 at 4:05 PM, John J Foster via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> > Hi Jim,
>
> I see!
>
> I thought that was just a dialog.
>
> Cool UI and smooth control.
>
> John...
>
> > The On Hover annotation balloon is another svg image on top of the data
> > svg image
>
> **
> 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
> **
>



-- 
Jim Dorrance
jim.dorra...@gmail.com
4...@dorrance.eu
www.4d.dorrance.eu

PS: If you know of anyone that needs an experienced 4D programmer to add
energy and experience to their team, please let me know. I have
experience in many areas. Reasonable rates. Remote or Paris only.
**
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
**

startup progress on server

[Randy Jaynes via 4D_Tech]

I’ve spent the morning trying to track down why our database started crashing 
when we quit 4D Server v16R6 on Mac OS…I haven’t tested yet to see if it 
affects the Windows version as well.

I have tracked down 2 contributors to the crash.

1) Calling SET MENU BAR during On Server Startup
- this crash will occur in a test database with only this line 
of code in the On Server Startup method

2) opening a small window for showing progress messages during the 
startup routine. Especially important while running internal data update 
routines

We use the same STARTUP method for both a client’s On Startup method and 
server’s On Startup method, putting checks for (Application Type = 4D Server) 
in appropriate places to skip over some pieces of code not needed on the server.

So, item #1 is easy to fix by checking if I’m running on server or not.

Item #2, however, I need to solve a different way.

So the question to everyone here is: how to do you give feedback to the user 
when starting up 4D Server?

My first attempt after this email is to move the current STARTUP method into a 
stored procedure on the server using New Process to see if it just runs as is.

I just wanted to see what others might suggest as well.

This STARTUP method has been working fine through many versions of 4D and 4D 
Server. I know every new version of 4D gets tighter and tighter in its behavior 
and coding needs and I have to adapt. Not complaining. Just need to find out 
how to get my code tighter. :-)

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.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: Scheduled ISP Maintenance @ 4D Office (France)

[Tai Bui via 4D_Tech]

Hi,

For some reason it appears that the internet has been down since the ISP 
performed their maintenance.
The ISP has been informed and should be working on it.

Apologies for the inconvenience.

Best Regards,
-Tai B.



**
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: startup progress on server

[Dennis, Neil via 4D_Tech]

Randy

There might be something else in the mix, all of my databases do a set menu bar 
during startup and open a window for progress. I'm not having the same crash 
you are. However I haven't tested with 4D v16r6.

Neil






Privacy Disclaimer: This message contains confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
**
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: startup progress on server

[Randy Jaynes via 4D_Tech]

Ok. So moving our STARTUP method into a stored procedure using
$procID:=New Process(“STARTUP”;512000;”On Server Startup)

takes care of BOTH problems.

So it looks like the Application Server process on 4D Server v16R6 and higher 
is more sensitive to interface related commands like
OPEN WINDOW
SET MENU BAR
DISPLAY RECORD

For the record, this startup method was fine up through 4D v15.4 HF3.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Aug 6, 2018, at 10:15 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> I’ve spent the morning trying to track down why our database started crashing 
> when we quit 4D Server v16R6 on Mac OS…I haven’t tested yet to see if it 
> affects the Windows version as well.
> 
> I have tracked down 2 contributors to the crash.
> 
>   1) Calling SET MENU BAR during On Server Startup
>   - this crash will occur in a test database with only this line 
> of code in the On Server Startup method
>   
>   2) opening a small window for showing progress messages during the 
> startup routine. Especially important while running internal data update 
> routines
> 
> We use the same STARTUP method for both a client’s On Startup method and 
> server’s On Startup method, putting checks for (Application Type = 4D Server) 
> in appropriate places to skip over some pieces of code not needed on the 
> server.
> 
> So, item #1 is easy to fix by checking if I’m running on server or not.
> 
> Item #2, however, I need to solve a different way.
> 
> So the question to everyone here is: how to do you give feedback to the user 
> when starting up 4D Server?
> 
> My first attempt after this email is to move the current STARTUP method into 
> a stored procedure on the server using New Process to see if it just runs as 
> is.
> 
> I just wanted to see what others might suggest as well.
> 
> This STARTUP method has been working fine through many versions of 4D and 4D 
> Server. I know every new version of 4D gets tighter and tighter in its 
> behavior and coding needs and I have to adapt. Not complaining. Just need to 
> find out how to get my code tighter. :-)
> 
> Randy
> 
> --
> Randy Jaynes
> Senior Programmer and Customer Support
> 
> http://printpoint.com   > • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
> Palisades, NY 10964 
> Please send all email contacts to supp...@printpoint.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 
> 
> **

**
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: startup progress on server

[John DeSoi via 4D_Tech]

Randy,

I'll be interested to hear if this permanently fixes the problem. I'm still 
having random crash on quit errors on 4D Server (16.3HF4, 64-bit). Never a 
problem in version 15, 32-bit. I have never connected crashing to a status 
interface, but in my case it has always run in a separate process. I just made 
a change to ensure that process is dead before QUIT 4D is called on the server. 
Maybe that will completely solve it.

Did you look at the backtrace from the crash log? I would be interested to see 
if we are experiencing the same issue. Below is what I see. I wonder if that is 
related to displaying the countdown timer - I'm quitting with QUIT 4D(60).

Thread 46 Crashed:: QUIT_SERVER (id = -11)
0   4d.com.Map Server.app   0x000108e88fbc 
V4DClientProcessManager::Clear(bool) + 128
1   4d.com.Map Server.app   0x000108e8c1eb 
V4DServer::Unpublish() + 87
2   4d.com.Map Server.app   0x000108e8d1e6 
V4DServer::_Shutdown(xbox::VTime&, xbox::VString const*, xbox::VString const*, 
VDatabaseStartupParameters*, xbox::VUUID const*) + 38
3   4d.com.Map Server.app   0x000108e8d300 
V4DServer::Shutdown(int, xbox::VString const*, xbox::VString const*, 
VDatabaseStartupParameters*, xbox::VUUID const*) + 120
4   4d.com.Map Server.app   0x00010915a636 
do_quit4d(runtime4dLink*) + 123
5   4d.com.Map Server.app   0x000108ce5028 
VDBLanguageContext::ExecuteCommand(runtime4dLink*) + 62
6   4d.com.Map Server.app   0x000108cd9530 
VDBLanguageContext_compiled::ExecuteRuntimeCommand(int, int, 
champvar_template<256>**) + 94
7   4d.com.Map Server.app   0x000108afeff1 rt_CallRuntime4D2 + 
45
8   ??? 0x00010e364a43 0 + 4533406275
9   4d.com.Map Server.app   0x00010907fbcb CallAsmPart2 + 65
10  ??? 0x7051e6e0 0 + 123145307678432
11  4d.com.Map Server.app   0x000108cd9354 
VDBLanguageContext_compiled::DoExecute(calcblock&, VCodeDescriptor*) + 164
12  4d.com.Map Server.app   0x000108ce3e18 
VDBLanguageContext::Execute(VDB4DTableProxy*, VFormContext*, short, int, int, 
champvar_template<256>**, VCodeDescriptor*) + 162
13  4d.com.Map Server.app   0x000108ce3a92 
VDBLanguageContext::ExecuteProjectMethod(VMethodInfo const*, int, 
champvar_template<256>**, VDB4DTableProxy*, VFormContext*, short, int) + 542
14  4d.com.Map Server.app   0x000108cbd08c 
V4DWorkerMessage::_Execute(VDBLanguageContext*, VFormContext*) + 110
15  4d.com.Map Server.app   0x000108cbd850 
V4DWorker::Run(V4DTaskConcrete*) + 208
16  4d.com.Map Server.app   0x000108e97da4 
Task4DStoredMethodProc(V4DTaskConcrete*, xbox::IRefCountable*) + 222
17  4d.com.Map Server.app   0x000108cb4360 
Task4DProc(V4DTaskConcrete*) + 910
18  4d.com.Map Server.app   0x000108cfb6c8 
V4DTaskManager::_Task4DProc(xbox::VTask*) + 160
19  com.4d.kernel   0x00010b0b02ee xbox::VTask::_Run() 
+ 78
20  com.4d.kernel   0x00010b0b54d6 
xbox::XMacTask_fiber::_ThreadProc(void*) + 70
21  com.4d.kernel   0x00010b0ef27f 
xbox::VMacFiber_thread::_ThreadProc(void*) + 31
22  com.apple.CoreServices.CarbonCore   0x7fff476e6072 CooperativeThread + 
282
23  libsystem_pthread.dylib 0x7fff6e6ba661 _pthread_body + 340
24  libsystem_pthread.dylib 0x7fff6e6ba50d _pthread_start + 377
25  libsystem_pthread.dylib 0x7fff6e6b9bf9 thread_start + 13




> On Aug 6, 2018, at 9:26 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Ok. So moving our STARTUP method into a stored procedure using
>   $procID:=New Process(“STARTUP”;512000;”On Server Startup)
> 
> takes care of BOTH problems.
> 
> So it looks like the Application Server process on 4D Server v16R6 and higher 
> is more sensitive to interface related commands like
>   OPEN WINDOW
>   SET MENU BAR
>   DISPLAY RECORD
> 
> For the record, this startup method was fine up through 4D v15.4 HF3.

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

LiveDoc Unresponsive

[Stephen J. Orth via 4D_Tech]

Is the livedoc website served out of France?  I'm unable to reach it.


Steve

*
  Stephen J. Orth
  The Aquila Group, Inc. Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.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 - marking field as 'Primary Key'

[Chuck Miller via 4D_Tech]

You can identify primary key with the following code
$TableLoop_l is table number
Begin SQL

SELECT CONSTRAINT_ID
FROM _USER_CONSTRAINTS
WHERE TABLE_ID = :$TableLoop_l AND CONSTRAINT_TYPE = 'P'
INTO :$ConstraintID_txt;

SELECT COLUMN_ID
FROM _USER_CONS_COLUMNS
WHERE CONSTRAINT_ID = :$ConstraintID_txt
INTO :$Primary_key_field_id_L;
End SQL
Hope this helps someone else

Regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase 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. 

> On Aug 6, 2018, at 10:11 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Arnaud,
> Thanks
> 
> I did this:
> on error call - just make the error go away
> for every table
>  for every field
>is this my "primary key' field?
> sql command as text to set primary key on the field
> execute immediate(above sql command)
>   (trying to set a primary key, as primary key generates an error 
> which is suppressed by the above on error call)
> 
> 
> it works to do what I needed, it is fast, and it is done  :)
> 
> Chip
> 
> On Sun, 5 Aug 2018 12:28:39 +0200, Arnaud de Montard via 4D_Tech wrote:
>> 
>>> Le 3 août 2018 à 18:12, Chip Scheide via 4D_Tech 
>>> <4d_tech@lists.4d.com> a écrit :
>>> 
>>> Thanks,
>>> I do not really use the online docs
>>> but it is nice to know
>> 
>> SQL script example. 
>> 
>> ++
>> /* tables and primary keys */
>> 
>> CREATE TABLE Agence
>> (
>> PK INT32 NOT NULL UNIQUE AUTO_INCREMENT,
>> raisonSociale VARCHAR(80),
>> complementAdresse VARCHAR(80),
>> email VARCHAR(80),
>> comments TEXT,
>> PRIMARY KEY (PK)
>> );
>> 
>> CREATE TABLE ContactAgence
>> (
>> PK INT32 NOT NULL UNIQUE AUTO_INCREMENT,
>> nom VARCHAR(80),
>> prenom VARCHAR(80),
>> fonction VARCHAR(80),
>> email VARCHAR(80),
>> FK_agence INT32,
>> comments TEXT,
>> PRIMARY KEY (PK)
>> );
>> 
>> /* indexes */
>> 
>> CREATE INDEX idx1 ON Agence (PK);
>> 
>> CREATE INDEX idx2 ON ContactAgence (PK);
>> 
>> /* relation */
>> 
>> ALTER TABLE ContactAgence ADD CONSTRAINT rel1 FOREIGN KEY (FK_agence) 
>> REFERENCES Agence (PK);
>> ++
>> 
>> Note: I never create such relations… 
>> 
>> -- 
>> Arnaud de Montard 
>> 
>> 
>> 
>> 
>> **
>> 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
> **

**
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: LiveDoc Unresponsive

[Add Komoncharoensiri via 4D_Tech]

Hi Steve,

http://Doc.4d.com is online and functioning. Please connect to it in the 
meantime while we are sorting out the problem.

Regards,
Add




On 8/6/18, 8:12 AM, "4D_Tech on behalf of Stephen J. Orth via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Is the livedoc website served out of France?  I'm unable to reach it.


Steve

*
  Stephen J. Orth
  The Aquila Group, Inc. Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.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
**

**
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: LiveDoc Unresponsive

[Stephen J. Orth via 4D_Tech]

Add,

Thanks for getting back to me!  I did get my answers the "manual" way.  It's 
funny how accustomed you become to simply clicking F1...

Best,


Steve

*
  Stephen J. Orth
  The Aquila Group, Inc. Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.com
*


-Original Message-
From: Add Komoncharoensiri [mailto:akomoncharoens...@4d.com] 
Sent: Monday, August 06, 2018 10:42 AM
To: s.o...@the-aquila-group.com; 4D iNug Technical <4d_tech@lists.4d.com>
Subject: Re: LiveDoc Unresponsive

Hi Steve,

http://Doc.4d.com is online and functioning. Please connect to it in the 
meantime while we are sorting out the problem.

Regards,
Add



Add Komoncharoensiri
Director of Technical Services

4D Inc
95 S. Market Street, Suite #240
CA 95113 San Jose
United States

Téléphone : +1-408-557-4600
Standard :  +1-408-557-4600
Fax :   +1-408-271-5080
Email : akomoncharoens...@4d.com
Web :   www.4D.com





On 8/6/18, 8:12 AM, "4D_Tech on behalf of Stephen J. Orth via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Is the livedoc website served out of France?  I'm unable to reach it.


Steve

*
  Stephen J. Orth
  The Aquila Group, Inc. Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.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
**



**
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: startup progress on server

[Tim Nevels via 4D_Tech]

On Aug 6, 2018, at 10:21 AM, Randy Jaynes wrote:

> Ok. So moving our STARTUP method into a stored procedure using
>   $procID:=New Process(“STARTUP”;512000;”On Server Startup)
> 
> takes care of BOTH problems.
> 
> So it looks like the Application Server process on 4D Server v16R6 and higher 
> is more sensitive to interface related commands like
>   OPEN WINDOW
>   SET MENU BAR
>   DISPLAY RECORD
> 
> For the record, this startup method was fine up through 4D v15.4 HF3.

Just curious, does SET MENU BAR actually work from a Stored Procedure process 
on 4D Server?I thought this was not supported. 

You can open a window from a Stored Procedure on 4D Server but I didn’t think 
you could install your own menu bar, and have your own items in the menu bar 
that you could select and have them perform actions. 

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

TAOW down?

[Bob Miller via 4D_Tech]

Since about 3pm on Friday I've been trying to file a tech support case on 
taow.4d.com, but I get, "This site can't be reached".

Anyone else seeing this?


Bob Miller
Chomerics, a division of Parker Hannifin Corporation


ll
"PLEASE NOTE: The preceding information may be confidential or privileged. It 
only should be used or disseminated for the purpose of conducting business with 
Parker. If you are not an intended recipient, please notify the sender by 
replying to this message and then delete the information from your system. 
Thank you for your cooperation."
**
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: startup progress on server

[Randy Jaynes via 4D_Tech]

We call QUIT 4D directly with no timer.

Our On Exit and On Server Shutdown methods already do checks to be sure the 
processes we started are dead.

I’m hoping for sure this is all that is needed. I didn’t think to test if this 
was only an issue related to 64bit version of server on Mac.

I’ll have to give that a shot as well. Regardless, at the moment at least, 
starting a new Stored Procedure to run the startup code seems to have done the 
trick for me.

I’ll test 32bit server on Mac later today. Have some other TS issues to catch 
up on first.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Aug 6, 2018, at 10:54 AM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Randy,
> 
> I'll be interested to hear if this permanently fixes the problem. I'm still 
> having random crash on quit errors on 4D Server (16.3HF4, 64-bit). Never a 
> problem in version 15, 32-bit. I have never connected crashing to a status 
> interface, but in my case it has always run in a separate process. I just 
> made a change to ensure that process is dead before QUIT 4D is called on the 
> server. Maybe that will completely solve it.
> 
> Did you look at the backtrace from the crash log? I would be interested to 
> see if we are experiencing the same issue. Below is what I see. I wonder if 
> that is related to displaying the countdown timer - I'm quitting with QUIT 
> 4D(60).

**
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: startup progress on server

[Randy Jaynes via 4D_Tech]

There could be, sure.

John DeSoi makes  a good point that it could b the 64bit version as opposed to 
32bit.

As I mentioned, the startup method was working fine up through v15.4 HF3, which 
was the last version before jumping to v16R6, but we went right to the 64bit 
version of that so I’ll have to test to be sure on that.

For now, I’m fine with using a stored procedure for the startup method.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Aug 6, 2018, at 10:24 AM, Dennis, Neil  > wrote:
> 
> Randy
> 
> There might be something else in the mix, all of my databases do a set menu 
> bar during startup and open a window for progress. I'm not having the same 
> crash you are. However I haven't tested with 4D v16r6.
> 
> Neil

**
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: Export text columns containing carriage returns to Excel?

[Douglas Cryer via 4D_Tech]

Brad,

My stock answer to questions like this is.  Get yourself a copy of : 
http://www.pluggers.nl/product/xl-plugin/

If you are doing anything serious with excel files this is the easiest and best 
solution and well worth the outlay.

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.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: SVG Overlay Layer

[John J Foster via 4D_Tech]

Hey Jim,

> The annotation svg is much larger than the data svg so the annotation can
> pass the boundaries of the data svg

I assume you mean that you can annotate outside the viewable area of the svg 
data image?

Kind of like drawing programs where the image is confined to pre-sized 
rectangle (artboard) and then you can place graphics, images or text outside of 
the rect area for whatever purposes are required.

That’s likely what I will do as well. I’ll likely make the annotation area 
larger than the actual underlying image.

Good to keep this in mind when I begin the UI design.

Appreciate,
John…


**
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 down?

[Add Komoncharoensiri via 4D_Tech]

Hi Bob,

Currently our ISP in office in Paris is experiencing some issue that impact a 
few of our Online system, including TAOW. If you have an urgent need for Tech 
Support, please call our tech support directly by phone.

Regards,
Add





On 8/6/18, 8:56 AM, "4D_Tech on behalf of Bob Miller via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Since about 3pm on Friday I've been trying to file a tech support case on
taow.4d.com, but I get, "This site can't be reached".

Anyone else seeing this?


Bob Miller
Chomerics, a division of Parker Hannifin Corporation


ll
"PLEASE NOTE: The preceding information may be confidential or privileged. 
It only should be used or disseminated for the purpose of conducting business 
with Parker. If you are not an intended recipient, please notify the sender by 
replying to this message and then delete the information from your system. 
Thank you for your cooperation."
**
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: startup progress on server

[Randy Jaynes via 4D_Tech]

SET MENU BAR has never actually done anything to change the menu bar on the 
server, so I think it’s just been ignored all these years.

It’s never been a problem until v16R6 Server. Of course, this is the first time 
we’ve had 64bit on Mac, so it may be related to that.

Either way, starting a stored procedure on server seems to be ignoring it 
again, so I’ve got that going for me.

Will test the 32 vs 64bit questions later.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Aug 6, 2018, at 11:54 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Just curious, does SET MENU BAR actually work from a Stored Procedure process 
> on 4D Server?I thought this was not supported. 
> 
> You can open a window from a Stored Procedure on 4D Server but I didn’t think 
> you could install your own menu bar, and have your own items in the menu bar 
> that you could select and have them perform actions. 

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

Automated Generation of Form Variables

[Guru via 4D_Tech]

Is there a way to generate the Form.table.dataClassAttribute and their labels
to populate a form like is done for fields and labels when creating a form
via the wizard?



--
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: Automated Generation of Form Variables

[Douglas von Roeder via 4D_Tech]

That is a logical step but it's not available that I'm aware of.

Perhaps this would be a good feature request.

--
Douglas von Roeder
949-336-2902


On Mon, Aug 6, 2018 at 9:25 AM Guru via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Is there a way to generate the Form.table.dataClassAttribute and their
> labels
> to populate a form like is done for fields and labels when creating a form
> via the wizard?
>
>
>
> --
> 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: startup progress on server

[Timothy Penner via 4D_Tech]

Regarding  the menu bars on server -

> Calling SET MENU BAR during On Server Startup
> - this crash will occur in a test database with only this line of code in the 
> On Server Startup method

This *was* a known issue, it was filed as ACI0097391. It should be fixed in the 
latest v16 and v17 releases, I am not sure about the R release.

However, keep in mind that the command SET MENU BAR is documented to have no 
effect on the server;
http://doc.4d.com/4Dv17/4D/17/Stored-Procedures.300-3743249.en.html
^ So calling SET MENU BAR on the server is a mistake.

A wrapper for the SET MENU BAR command could look like this:

If(Application type#4D Server)
SET MENU BAR($1)
 End if

Regarding the progress window -

>opening a small window for showing progress messages during the startup 
>routine. Especially important while running internal data update routines

The documentation summarizes it like this:
{
Generally speaking, stored procedures executed on the server should not deal 
with interface items (such as menus, windows, forms...). Indeed the interface 
is not managed on the server's side.
Commands displaying dialog boxes on the server machine as well as dialog boxes 
dealing with data entry should be avoided.
}

So I think this should probably be avoided also.

Kind Regards,

Tim PENNER




**
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: Automated Generation of Form Variables

[John DeSoi via 4D_Tech]

I don't use the form wizard, so I'm not sure I understand what you mean about 
Form.table.dataClassAttribute. But you can certainly generate your own form 
with fields and labels in version 17. To generate a field, I use a method like 
this:


 //Create field object.

  //$0 - Field object.
  //$1 - Field pointer.

C_OBJECT($0)
C_POINTER($1)

$0:=New object
$0.type:="input"
$0.dataSource:=TB_Field_full_name ($1) `Like [Table_Name]Field_Name

John DeSoi, Ph.D.




> On Aug 3, 2018, at 9:42 AM, Guru via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Is there a way to generate the Form.table.dataClassAttribute and their labels
> to populate a form like is done for fields and labels when creating a form
> via the wizard?

**
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: startup progress on server

[Randy Jaynes via 4D_Tech]

> On Aug 6, 2018, at 12:39 PM, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Regarding  the menu bars on server -
> 
>> Calling SET MENU BAR during On Server Startup
>> - this crash will occur in a test database with only this line of code in 
>> the On Server Startup method
> 
> This *was* a known issue, it was filed as ACI0097391. It should be fixed in 
> the latest v16 and v17 releases, I am not sure about the R release.
> 
> However, keep in mind that the command SET MENU BAR is documented to have no 
> effect on the server;
> http://doc.4d.com/4Dv17/4D/17/Stored-Procedures.300-3743249.en.html 
> 
> ^ So calling SET MENU BAR on the server is a mistake.
> 
> A wrapper for the SET MENU BAR command could look like this:
> 
> If(Application type#4D Server)
>SET MENU BAR($1)
> End if

Already done. We knew it was being ignored on server so hasn’t been an issue 
until now. It was the first change I made in trying to track this all down.

> 
> Regarding the progress window -
> 
>> opening a small window for showing progress messages during the startup 
>> routine. Especially important while running internal data update routines
> 
> The documentation summarizes it like this:
> {
> Generally speaking, stored procedures executed on the server should not deal 
> with interface items (such as menus, windows, forms...). Indeed the interface 
> is not managed on the server's side.
> Commands displaying dialog boxes on the server machine as well as dialog 
> boxes dealing with data entry should be avoided.
> }

Which we do in general, yes.

> 
> So I think this should probably be avoided also.

So what’s the recommendation on giving startup progress so they know that the 
server hasn’t frozen at some point during the startup method?

We do a simple order like
open window
… do stuff
DISPLAY  RECORD   <——displays a form with a picture and a text variable that we 
update
…do stuff
DISPLAY  RECORD
…do stuff
close window

We’ve been doing this for at least 18 years.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.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: Automated Generation of Form Variables

[Douglas von Roeder via 4D_Tech]

John:

The current version of the form editor allows us to put fields on a form
that are coupled to the underlying record. We can now pass an object as $3
to the dialog command and, if the value in Expression/Variable name is
Form., that form object is coupled to the object at $3.

With that new feature, it's a natural extension of the form wizard to have
the form wizard populate the form with form objects that have the value in
"Expression/Variable Name" already populated. It will save a huge amount of
mindless grunt work.

I'm thrilled to see this new feature because it saves a lot of code to bind
form locals to objects (I've been using ObjectTools). Until the form wizard
can create forms with form objects that tie back to objects, we're still
doing things by hand, one object at a time.

--
Douglas von Roeder
949-336-2902


On Mon, Aug 6, 2018 at 9:50 AM John DeSoi via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> I don't use the form wizard, so I'm not sure I understand what you mean
> about Form.table.dataClassAttribute. But you can certainly generate your
> own form with fields and labels in version 17. To generate a field, I use a
> method like this:
>
>
>  //Create field object.
>
>   //$0 - Field object.
>   //$1 - Field pointer.
>
> C_OBJECT($0)
> C_POINTER($1)
>
> $0:=New object
> $0.type:="input"
> $0.dataSource:=TB_Field_full_name ($1) `Like [Table_Name]Field_Name
>
> John DeSoi, Ph.D.
>
>
>
>
> > On Aug 3, 2018, at 9:42 AM, Guru via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> > Is there a way to generate the Form.table.dataClassAttribute and their
> labels
> > to populate a form like is done for fields and labels when creating a
> form
> > via the wizard?
>
> **
> 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: startup progress on server

[Timothy Penner via 4D_Tech]

> So what’s the recommendation on giving startup progress so they know that the 
> server hasn’t frozen at some point during the startup method?

To the best of my knowledge, we do not recommend any sort of UI on the server.
So, it is hard to make a recommendation for something we don’t recommend.

Trying to help even though we don’t recommend a UI on the server -

If this was on a client or standalone I would suggest the Progress component:
http://doc.4d.com/4Dv15/4D/15/Progress-New.301-2399698.en.html
http://doc.4d.com/4Dv15/4D/15/Progress-SET-TITLE.301-2399709.en.html
http://doc.4d.com/4Dv15/4D/15/Progress-QUIT.301-2399699.en.html

C_LONGINT($vlProg)
$vlProg:=Progress New
Progress SET TITLE($vlProg;"Title of window for doing stuff 1";-1;"description 
of stuff being done")
// do stuff 1
Progress SET TITLE($vlProg;"Title of window for doing stuff 2";-1;"description 
of stuff being done")
// do stuff 1
Progress QUIT($vlProg)

However, I don’t think that using the progress component would be appropriate 
for the server because it is still a UI and in general our documentation 
suggests against any sort of UI on the server..

Regarding notifying the administrator about ongoing startup tasks - what about 
using the DISPLAY NOTIFICATION command?
http://doc.4d.com/4Dv15/4D/15.6/DISPLAY-NOTIFICATION.301-3818361.en.html
-Tim



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

How to access formsSchema.json in the 4D app?

[Kirk Brooks via 4D_Tech]

Working with dynamic forms and want to validate a form object. Laurent
Esnault showed how to do this is his presentation in DC. He mentioned that
formsSchema.json in the 4D app is the thing to use.

How can I reference this document from within 4D?

I tried various iterations starting with Application file but can't seem to
make it work. I know I can manually go in and get it but I'd like to be
able to mange it via code.

Thanks
-- 
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: Export text columns containing carriage returns to Excel?

[Benedict, Tom via 4D_Tech]

Brad,

Here's a hint that you may (or may not) find useful.

I used a single column in the QR Editor to hold the full 'record' I was 
exporting. I wrapped all the fields with double-quotes and used commas as field 
delimiters. I also had to escape any embedded quotes by replacing them with 
double-double quotes. The result was a CSV file which can be opened in Excel 
(double-clicked on Desktop, not via File>Open. Excel is strange). Use CSV 
avoided the didn't need to restore any of the embedded characters.

My data source ended up being too large to use this approach, as the output 
file exceeded 4GB, so I end up writing similar code to generate the CSV. But if 
your data is modest sized the QR approach avoid the code-test-release cycle 
(unless your system is running interpreted).

Tom Benedict
Optum



From: Perkins, Bradley D [mailto:bperk...@lanl.gov]
Sent: Sunday, August 05, 2018 1:26 PM
To: Benedict, Tom; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?


Hi Tom,

I've been working  this with the QR Editor with some success. Another challenge 
I've found is that the 4D text fields have carriage returns, carriage 
return/new line pairs, and even some tabs.  Therefore I'll need to nest the 
calls to Replace string in the proper order to place markers for all three.



Thanks for pointing out the limitations I will need to see if any of the text 
fields are larger than 32,767 characters. This is an older system that started 
life in v3. The output file size will not be an issue.

Best,

Brad


From: Benedict, Tom 
Sent: Friday, August 3, 2018 2:19:44 PM
To: Perkins, Bradley D; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?

Brad Perkins writes:

>I've been asked to provide an export from a legacy 4D system delivered as an 
>.xlsx file.

>The challenge I'm facing is that this table contains a number of text fields 
>and
>the customer requires the imported column cells to retain the returns or line 
>feeds
>in the original text fields. If I do a straight tab-delimited export with 
>carriage returns
>as the end of line marker, the imported result does not preserve the original 
>row
>because any returns encountered in the text fields are interpreted as end of 
>row.

>My other challenge is that I need to do this with out-of-box end user 
>capabilities
>from a client (v15.4 remote) against a compiled server. I can't install 
>plugins, create new methods, etc.
>It has been many years since I've had to do this type of thing in 4D.

>Can I replace the carriage returns in the text fields with a special marker 
>during export?
>I could replace the Excel cells containing the any carriage return markers 
>with actual returns after import.

Use the Quick Report Editor. You can put formulas in the columns which include 
a call to Replace string.

There are some limitation which I've encountered:


-  The Quick Report Editor is 32bit (evidently) which limits the size 
of the output file to 4GB. Hopefully you don't run in to that limit. (I did 
recently).

-  Any given cell in Excel can only hold 32,767 characters. If you have 
more than that you'll have to do some fancy segmenting into another column in 
the output.

HTH, let me know if you have further questions. I have very recent experience 
doing just this.

Tom Benedict
Optum


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
**
4D Internet Users Group 

Re: Export text columns containing carriage returns to Excel?

[Perkins, Bradley D via 4D_Tech]

Tom,

That sounds extremely useful. In addition to "" any "s in the text do I also 
need to \, any commas?

I doubt the data source will be too large, but if it is can break the export 
into a couple of files. We'll only need to do this once.

Thanks,

Brad Perkins

From: "Benedict, Tom" 
Date: Monday, August 6, 2018 at 1:26 PM
To: Bradley Perkins , "4d_tech@lists.4d.com" 
<4d_tech@lists.4d.com>
Subject: RE: Export text columns containing carriage returns to Excel?

Brad,

Here’s a hint that you may (or may not) find useful.

I used a single column in the QR Editor to hold the full ‘record’ I was 
exporting. I wrapped all the fields with double-quotes and used commas as field 
delimiters. I also had to escape any embedded quotes by replacing them with 
double-double quotes. The result was a CSV file which can be opened in Excel 
(double-clicked on Desktop, not via File>Open. Excel is strange). Use CSV 
avoided the didn’t need to restore any of the embedded characters.

My data source ended up being too large to use this approach, as the output 
file exceeded 4GB, so I end up writing similar code to generate the CSV. But if 
your data is modest sized the QR approach avoid the code-test-release cycle 
(unless your system is running interpreted).

Tom Benedict
Optum



From: Perkins, Bradley D [mailto:bperk...@lanl.gov]
Sent: Sunday, August 05, 2018 1:26 PM
To: Benedict, Tom; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?


Hi Tom,

I've been working  this with the QR Editor with some success. Another challenge 
I've found is that the 4D text fields have carriage returns, carriage 
return/new line pairs, and even some tabs.  Therefore I'll need to nest the 
calls to Replace string in the proper order to place markers for all three.



Thanks for pointing out the limitations I will need to see if any of the text 
fields are larger than 32,767 characters. This is an older system that started 
life in v3. The output file size will not be an issue.

Best,

Brad


From: Benedict, Tom 
Sent: Friday, August 3, 2018 2:19:44 PM
To: Perkins, Bradley D; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?

Brad Perkins writes:

>I've been asked to provide an export from a legacy 4D system delivered as an 
>.xlsx file.

>The challenge I'm facing is that this table contains a number of text fields 
>and
>the customer requires the imported column cells to retain the returns or line 
>feeds
>in the original text fields. If I do a straight tab-delimited export with 
>carriage returns
>as the end of line marker, the imported result does not preserve the original 
>row
>because any returns encountered in the text fields are interpreted as end of 
>row.

>My other challenge is that I need to do this with out-of-box end user 
>capabilities
>from a client (v15.4 remote) against a compiled server. I can't install 
>plugins, create new methods, etc.
>It has been many years since I've had to do this type of thing in 4D.

>Can I replace the carriage returns in the text fields with a special marker 
>during export?
>I could replace the Excel cells containing the any carriage return markers 
>with actual returns after import.

Use the Quick Report Editor. You can put formulas in the columns which include 
a call to Replace string.

There are some limitation which I’ve encountered:


-  The Quick Report Editor is 32bit (evidently) which limits the size 
of the output file to 4GB. Hopefully you don’t run in to that limit. (I did 
recently).

-  Any given cell in Excel can only hold 32,767 characters. If you have 
more than that you’ll have to do some fancy segmenting into another column in 
the output.

HTH, let me know if you have further questions. I have very recent experience 
doing just this.

Tom Benedict
Optum


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by t

RE: Export text columns containing carriage returns to Excel?

[Benedict, Tom via 4D_Tech]

I didn’t have to escape the embedded commas. I think the quotes around all the 
fields took care of them. You will likely need to experiment. I found that 
Excel is fussy about CSV. It definitely doesn’t like importing CSV via the 
import wizard unless there are no embedded delimiters.

Tom

From: Perkins, Bradley D [mailto:bperk...@lanl.gov]
Sent: Monday, August 06, 2018 12:34 PM
To: Benedict, Tom; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?

Tom,

That sounds extremely useful. In addition to "" any "s in the text do I also 
need to \, any commas?

I doubt the data source will be too large, but if it is can break the export 
into a couple of files. We'll only need to do this once.

Thanks,

Brad Perkins

From: "Benedict, Tom" 
Date: Monday, August 6, 2018 at 1:26 PM
To: Bradley Perkins , "4d_tech@lists.4d.com" 
<4d_tech@lists.4d.com>
Subject: RE: Export text columns containing carriage returns to Excel?

Brad,

Here’s a hint that you may (or may not) find useful.

I used a single column in the QR Editor to hold the full ‘record’ I was 
exporting. I wrapped all the fields with double-quotes and used commas as field 
delimiters. I also had to escape any embedded quotes by replacing them with 
double-double quotes. The result was a CSV file which can be opened in Excel 
(double-clicked on Desktop, not via File>Open. Excel is strange). Use CSV 
avoided the didn’t need to restore any of the embedded characters.

My data source ended up being too large to use this approach, as the output 
file exceeded 4GB, so I end up writing similar code to generate the CSV. But if 
your data is modest sized the QR approach avoid the code-test-release cycle 
(unless your system is running interpreted).

Tom Benedict
Optum



From: Perkins, Bradley D [mailto:bperk...@lanl.gov]
Sent: Sunday, August 05, 2018 1:26 PM
To: Benedict, Tom; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?


Hi Tom,

I've been working  this with the QR Editor with some success. Another challenge 
I've found is that the 4D text fields have carriage returns, carriage 
return/new line pairs, and even some tabs.  Therefore I'll need to nest the 
calls to Replace string in the proper order to place markers for all three.



Thanks for pointing out the limitations I will need to see if any of the text 
fields are larger than 32,767 characters. This is an older system that started 
life in v3. The output file size will not be an issue.

Best,

Brad


From: Benedict, Tom 
Sent: Friday, August 3, 2018 2:19:44 PM
To: Perkins, Bradley D; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?

Brad Perkins writes:

>I've been asked to provide an export from a legacy 4D system delivered as an 
>.xlsx file.

>The challenge I'm facing is that this table contains a number of text fields 
>and
>the customer requires the imported column cells to retain the returns or line 
>feeds
>in the original text fields. If I do a straight tab-delimited export with 
>carriage returns
>as the end of line marker, the imported result does not preserve the original 
>row
>because any returns encountered in the text fields are interpreted as end of 
>row.

>My other challenge is that I need to do this with out-of-box end user 
>capabilities
>from a client (v15.4 remote) against a compiled server. I can't install 
>plugins, create new methods, etc.
>It has been many years since I've had to do this type of thing in 4D.

>Can I replace the carriage returns in the text fields with a special marker 
>during export?
>I could replace the Excel cells containing the any carriage return markers 
>with actual returns after import.

Use the Quick Report Editor. You can put formulas in the columns which include 
a call to Replace string.

There are some limitation which I’ve encountered:


-  The Quick Report Editor is 32bit (evidently) which limits the size 
of the output file to 4GB. Hopefully you don’t run in to that limit. (I did 
recently).

-  Any given cell in Excel can only hold 32,767 characters. If you have 
more than that you’ll have to do some fancy segmenting into another column in 
the output.

HTH, let me know if you have further questions. I have very recent experience 
doing just this.

Tom Benedict
Optum


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by t

Re: How to access formsSchema.json in the 4D app?

[Kirk Brooks via 4D_Tech]

OK, I typed the name incorrectly. Duoh!

This works on Mac:

$path:=*Application file*+Folder separator+"Contents"+Folder separator
+"Resources"+Folder separator+"formsSchema.json"

Can someone verify it works on Windows too?

Thanks

On Mon, Aug 6, 2018 at 11:14 AM Kirk Brooks  wrote:

> Working with dynamic forms and want to validate a form object. Laurent
> Esnault showed how to do this is his presentation in DC. He mentioned that
> formsSchema.json in the 4D app is the thing to use.
>
> How can I reference this document from within 4D?
>
> I tried various iterations starting with Application file but can't seem
> to make it work. I know I can manually go in and get it but I'd like to be
> able to mange it via code.
>
> Thanks
> --
> Kirk Brooks
> San Francisco, CA
> ===
>
> *We go vote - they go home*
>
>

-- 
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: Export text columns containing carriage returns to Excel?

[Perkins, Bradley D via 4D_Tech]

My initial tests using this technique look pretty good. I exported 100 rows and 
all but one imported into Excel OK. Most of the text fields don't contain any 
"s, but one that does caused the import to fail. How are you doubling the "s 
when using Replace String?

I tried Replace string([table]text_field;Char(34);Char(34)+Char(34))

Thanks,
Brad


From: "Benedict, Tom" 
Date: Monday, August 6, 2018 at 1:50 PM
To: Bradley Perkins , "4d_tech@lists.4d.com" 
<4d_tech@lists.4d.com>
Subject: RE: Export text columns containing carriage returns to Excel?

I didn’t have to escape the embedded commas. I think the quotes around all the 
fields took care of them. You will likely need to experiment. I found that 
Excel is fussy about CSV. It definitely doesn’t like importing CSV via the 
import wizard unless there are no embedded delimiters.

Tom

From: Perkins, Bradley D [mailto:bperk...@lanl.gov]
Sent: Monday, August 06, 2018 12:34 PM
To: Benedict, Tom; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?

Tom,

That sounds extremely useful. In addition to "" any "s in the text do I also 
need to \, any commas?

I doubt the data source will be too large, but if it is can break the export 
into a couple of files. We'll only need to do this once.

Thanks,

Brad Perkins

From: "Benedict, Tom" 
Date: Monday, August 6, 2018 at 1:26 PM
To: Bradley Perkins , "4d_tech@lists.4d.com" 
<4d_tech@lists.4d.com>
Subject: RE: Export text columns containing carriage returns to Excel?

Brad,

Here’s a hint that you may (or may not) find useful.

I used a single column in the QR Editor to hold the full ‘record’ I was 
exporting. I wrapped all the fields with double-quotes and used commas as field 
delimiters. I also had to escape any embedded quotes by replacing them with 
double-double quotes. The result was a CSV file which can be opened in Excel 
(double-clicked on Desktop, not via File>Open. Excel is strange). Use CSV 
avoided the didn’t need to restore any of the embedded characters.

My data source ended up being too large to use this approach, as the output 
file exceeded 4GB, so I end up writing similar code to generate the CSV. But if 
your data is modest sized the QR approach avoid the code-test-release cycle 
(unless your system is running interpreted).

Tom Benedict
Optum



From: Perkins, Bradley D [mailto:bperk...@lanl.gov]
Sent: Sunday, August 05, 2018 1:26 PM
To: Benedict, Tom; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?


Hi Tom,

I've been working  this with the QR Editor with some success. Another challenge 
I've found is that the 4D text fields have carriage returns, carriage 
return/new line pairs, and even some tabs.  Therefore I'll need to nest the 
calls to Replace string in the proper order to place markers for all three.



Thanks for pointing out the limitations I will need to see if any of the text 
fields are larger than 32,767 characters. This is an older system that started 
life in v3. The output file size will not be an issue.

Best,

Brad


From: Benedict, Tom 
Sent: Friday, August 3, 2018 2:19:44 PM
To: Perkins, Bradley D; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?

Brad Perkins writes:

>I've been asked to provide an export from a legacy 4D system delivered as an 
>.xlsx file.

>The challenge I'm facing is that this table contains a number of text fields 
>and
>the customer requires the imported column cells to retain the returns or line 
>feeds
>in the original text fields. If I do a straight tab-delimited export with 
>carriage returns
>as the end of line marker, the imported result does not preserve the original 
>row
>because any returns encountered in the text fields are interpreted as end of 
>row.

>My other challenge is that I need to do this with out-of-box end user 
>capabilities
>from a client (v15.4 remote) against a compiled server. I can't install 
>plugins, create new methods, etc.
>It has been many years since I've had to do this type of thing in 4D.

>Can I replace the carriage returns in the text fields with a special marker 
>during export?
>I could replace the Excel cells containing the any carriage return markers 
>with actual returns after import.

Use the Quick Report Editor. You can put formulas in the columns which include 
a call to Replace string.

There are some limitation which I’ve encountered:


-  The Quick Report Editor is 32bit (evidently) which limits the size 
of the output file to 4GB. Hopefully you don’t run in to that limit. (I did 
recently).

-  Any given cell in Excel can only hold 32,767 characters. If you have 
more than that you’ll have to do some fancy segmenting into another column in 
the output.

HTH, let me know if you have further questions. I have very recent experience 
doing just this.

Tom Benedict
Optum


This e-mail, including attachments, may include confidentia

Re: Export text columns containing carriage returns to Excel?

[Chip Scheide via 4D_Tech]

try:
Replace string([table]text_field;Char(34);"\\"+Char(34))

On Mon, 6 Aug 2018 20:07:39 +, Perkins, Bradley D via 4D_Tech wrote:
> My initial tests using this technique look pretty good. I exported 
> 100 rows and all but one imported into Excel OK. Most of the text 
> fields don't contain any "s, but one that does caused the import to 
> fail. How are you doubling the "s when using Replace String?
> 
> I tried Replace string([table]text_field;Char(34);Char(34)+Char(34))
> 
> Thanks,
> Brad
> 
> 
> From: "Benedict, Tom" 
> Date: Monday, August 6, 2018 at 1:50 PM
> To: Bradley Perkins , "4d_tech@lists.4d.com" 
> <4d_tech@lists.4d.com>
> Subject: RE: Export text columns containing carriage returns to Excel?
> 
> I didn’t have to escape the embedded commas. I think the quotes 
> around all the fields took care of them. You will likely need to 
> experiment. I found that Excel is fussy about CSV. It definitely 
> doesn’t like importing CSV via the import wizard unless there are no 
> embedded delimiters.
> 
> Tom
> 
> From: Perkins, Bradley D [mailto:bperk...@lanl.gov]
> Sent: Monday, August 06, 2018 12:34 PM
> To: Benedict, Tom; 4d_tech@lists.4d.com
> Subject: Re: Export text columns containing carriage returns to Excel?
> 
> Tom,
> 
> That sounds extremely useful. In addition to "" any "s in the text do 
> I also need to \, any commas?
> 
> I doubt the data source will be too large, but if it is can break the 
> export into a couple of files. We'll only need to do this once.
> 
> Thanks,
> 
> Brad Perkins
> 
> From: "Benedict, Tom" 
> Date: Monday, August 6, 2018 at 1:26 PM
> To: Bradley Perkins , "4d_tech@lists.4d.com" 
> <4d_tech@lists.4d.com>
> Subject: RE: Export text columns containing carriage returns to Excel?
> 
> Brad,
> 
> Here’s a hint that you may (or may not) find useful.
> 
> I used a single column in the QR Editor to hold the full ‘record’ I 
> was exporting. I wrapped all the fields with double-quotes and used 
> commas as field delimiters. I also had to escape any embedded quotes 
> by replacing them with double-double quotes. The result was a CSV 
> file which can be opened in Excel (double-clicked on Desktop, not via 
> File>Open. Excel is strange). Use CSV avoided the didn’t need to 
> restore any of the embedded characters.
> 
> My data source ended up being too large to use this approach, as the 
> output file exceeded 4GB, so I end up writing similar code to 
> generate the CSV. But if your data is modest sized the QR approach 
> avoid the code-test-release cycle (unless your system is running 
> interpreted).
> 
> Tom Benedict
> Optum
> 
> 
> 
> From: Perkins, Bradley D [mailto:bperk...@lanl.gov]
> Sent: Sunday, August 05, 2018 1:26 PM
> To: Benedict, Tom; 4d_tech@lists.4d.com
> Subject: Re: Export text columns containing carriage returns to Excel?
> 
> 
> Hi Tom,
> 
> I've been working  this with the QR Editor with some success. Another 
> challenge I've found is that the 4D text fields have carriage 
> returns, carriage return/new line pairs, and even some tabs.  
> Therefore I'll need to nest the calls to Replace string in the proper 
> order to place markers for all three.
> 
> 
> 
> Thanks for pointing out the limitations I will need to see if any of 
> the text fields are larger than 32,767 characters. This is an older 
> system that started life in v3. The output file size will not be an 
> issue.
> 
> Best,
> 
> Brad
> 
> 
> From: Benedict, Tom 
> Sent: Friday, August 3, 2018 2:19:44 PM
> To: Perkins, Bradley D; 4d_tech@lists.4d.com
> Subject: Re: Export text columns containing carriage returns to Excel?
> 
> Brad Perkins writes:
> 
>> I've been asked to provide an export from a legacy 4D system 
>> delivered as an .xlsx file.
> 
>> The challenge I'm facing is that this table contains a number of 
>> text fields and
>> the customer requires the imported column cells to retain the 
>> returns or line feeds
>> in the original text fields. If I do a straight tab-delimited export 
>> with carriage returns
>> as the end of line marker, the imported result does not preserve the 
>> original row
>> because any returns encountered in the text fields are interpreted 
>> as end of row.
> 
>> My other challenge is that I need to do this with out-of-box end 
>> user capabilities
>> from a client (v15.4 remote) against a compiled server. I can't 
>> install plugins, create new methods, etc.
>> It has been many years since I've had to do this type of thing in 4D.
> 
>> Can I replace the carriage returns in the text fields with a special 
>> marker during export?
>> I could replace the Excel cells containing the any carriage return 
>> markers with actual returns after import.
> 
> Use the Quick Report Editor. You can put formulas in the columns 
> which include a call to Replace string.
> 
> There are some limitation which I’ve encountered:
> 
> 
> -  The Quick Report Editor is 32bit (evidently) which limits 
> the size of the output file to 4G

Re: Export text columns containing carriage returns to Excel?

[Perkins, Bradley D via 4D_Tech]

Tom,

Actually in this case the problem is that the text field for that row is larger 
than the 32,767 character limit. All of the text after that blows up the import 
until we start on the next valid row.
I think the original replace string was working as intended
There are only 11 cases where we have texts larger than 32,767 characters. I'll 
substring the output to be safe and we can manually update those 11 records to 
include the truncated text.

Chip Scheide wrote:
Try Replace string([table]text_field;Char(34);"\\"+Char(34))

I'll do that if limiting the text field output to 32767 characters doesn't 
solve the problem.

Thanks,

Brad


From: Bradley Perkins 
Date: Monday, August 6, 2018 at 2:07 PM
To: "Benedict, Tom" , "4d_tech@lists.4d.com" 
<4d_tech@lists.4d.com>
Subject: Re: Export text columns containing carriage returns to Excel?

My initial tests using this technique look pretty good. I exported 100 rows and 
all but one imported into Excel OK. Most of the text fields don't contain any 
"s, but one that does caused the import to fail. How are you doubling the "s 
when using Replace String?

I tried Replace string([table]text_field;Char(34);Char(34)+Char(34))

Thanks,
Brad


From: "Benedict, Tom" 
Date: Monday, August 6, 2018 at 1:50 PM
To: Bradley Perkins , "4d_tech@lists.4d.com" 
<4d_tech@lists.4d.com>
Subject: RE: Export text columns containing carriage returns to Excel?

I didn’t have to escape the embedded commas. I think the quotes around all the 
fields took care of them. You will likely need to experiment. I found that 
Excel is fussy about CSV. It definitely doesn’t like importing CSV via the 
import wizard unless there are no embedded delimiters.

Tom

From: Perkins, Bradley D [mailto:bperk...@lanl.gov]
Sent: Monday, August 06, 2018 12:34 PM
To: Benedict, Tom; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?

Tom,

That sounds extremely useful. In addition to "" any "s in the text do I also 
need to \, any commas?

I doubt the data source will be too large, but if it is can break the export 
into a couple of files. We'll only need to do this once.

Thanks,

Brad Perkins

From: "Benedict, Tom" 
Date: Monday, August 6, 2018 at 1:26 PM
To: Bradley Perkins , "4d_tech@lists.4d.com" 
<4d_tech@lists.4d.com>
Subject: RE: Export text columns containing carriage returns to Excel?

Brad,

Here’s a hint that you may (or may not) find useful.

I used a single column in the QR Editor to hold the full ‘record’ I was 
exporting. I wrapped all the fields with double-quotes and used commas as field 
delimiters. I also had to escape any embedded quotes by replacing them with 
double-double quotes. The result was a CSV file which can be opened in Excel 
(double-clicked on Desktop, not via File>Open. Excel is strange). Use CSV 
avoided the didn’t need to restore any of the embedded characters.

My data source ended up being too large to use this approach, as the output 
file exceeded 4GB, so I end up writing similar code to generate the CSV. But if 
your data is modest sized the QR approach avoid the code-test-release cycle 
(unless your system is running interpreted).

Tom Benedict
Optum



From: Perkins, Bradley D [mailto:bperk...@lanl.gov]
Sent: Sunday, August 05, 2018 1:26 PM
To: Benedict, Tom; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?


Hi Tom,

I've been working  this with the QR Editor with some success. Another challenge 
I've found is that the 4D text fields have carriage returns, carriage 
return/new line pairs, and even some tabs.  Therefore I'll need to nest the 
calls to Replace string in the proper order to place markers for all three.



Thanks for pointing out the limitations I will need to see if any of the text 
fields are larger than 32,767 characters. This is an older system that started 
life in v3. The output file size will not be an issue.

Best,

Brad


From: Benedict, Tom 
Sent: Friday, August 3, 2018 2:19:44 PM
To: Perkins, Bradley D; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?

Brad Perkins writes:

>I've been asked to provide an export from a legacy 4D system delivered as an 
>.xlsx file.

>The challenge I'm facing is that this table contains a number of text fields 
>and
>the customer requires the imported column cells to retain the returns or line 
>feeds
>in the original text fields. If I do a straight tab-delimited export with 
>carriage returns
>as the end of line marker, the imported result does not preserve the original 
>row
>because any returns encountered in the text fields are interpreted as end of 
>row.

>My other challenge is that I need to do this with out-of-box end user 
>capabilities
>from a client (v15.4 remote) against a compiled server. I can't install 
>plugins, create new methods, etc.
>It has been many years since I've had to do this type of thing in 4D.

>Can I replace the carriage re

Re: startup progress on server

[Keisuke Miyako via 4D_Tech]

c.f. ACI0096115 (fixed in v17), ACI0094811 (fixed in v17, 16.3.HF5), ACI0097654 
(fixed in 16R6)

I recall the workaround prior to the fix was to duplicate the numeric menu 
reference ( i.e. $menu:=Create menu(1) )
instead of using design mode directly ( SET MENU BAR(1) )

but I may be wrong.



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

Tinkering with SQL

[Robert McKeever via 4D_Tech]

4D v15

I run the following code:  The SQL Login goes to the database that is running. 


DA_SQL_Login2

C_TEXT(tLookFor)

tLookFor:="%Mc%"

ARRAY TEXT(aFoundNames;0)
ARRAY TEXT(aFoundPhones;0)

Begin SQL
Select FullName, Phone FROM PatientBase WHERE (FullName like :tLookFor) INTO 
:aFoundNames, :aFoundPhones ;
End SQL
DA_SQL_Logout 

  //TRACE
OpenWindow (530;345;Regular window;"")
set window title("Records found "+string(size of array(aFoundNames)))
DIALOG("NamesAndPhonesFound")
CLOSE WINDOW
`TRACE

QUERY([PatientBase];[PatientBase]FullName="@mc@")
SELECTION TO 
ARRAY([PatientBase]FullName;aFoundNames;[PatientBase]Phone;aFoundPhones)
OpenWindow (530;345;Regular window;"")
set window title("Records found "+string(size of array(aFoundNames)))
DIALOG("NamesAndPhonesFound")
CLOSE WINDOW

The SQL Login goes to the database that is running. 

The SQL select returns 34 records. The 4D Query returns 404.

So what is wrong?
_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@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: How to access formsSchema.json in the 4D app?

[Jeremy French via 4D_Tech]

Hi Kirk,

No, the Mac path does not work on Windows. 

Obtaining the path to the schema document on Windows is slightly different than 
on the Mac.

On the Mac, the command "Application file" returns a path to a folder (i.e., 
package.).

But on Windows, the "Application file" command returns a path to an actual file 
(i.e., the executable). Both the executable and the "Resources" folder are 
contained within the same folder at the same level.

The location on Windows is:
Program Files
   4D
  4D.exe
  Resources
 formsSchema.json

So get the desired path in 3-steps:

1) Specify the relative path "Resources"+Folder separator+"formsSchema.json".
2) Use the command commands "Application file" and "Path to object" to get the 
parentFolder to the executable.
3) Build the actual path as "parentFolder + relativePath".

Something like this:

—
C_OBJECT($path_obj_o)
C_TEXT($path_t)
C_TEXT($relative_path_t)

$relative_path_t:="Resources"+Folder separator+"formsSchema.json"

$path_t:=Application file
$path_obj_o:=Path to object($path_t)
$path_t:=$path_obj_o.parentFolder+$relative_path_t
--

- Jeremy



> On Aug 6, 2018, at 3:54 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> This works on Mac:
> 
> $path:=*Application file*+Folder separator+"Contents"+Folder separator
> +"Resources"+Folder separator+"formsSchema.json"
> 
> Can someone verify it works on Windows too?

**
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: Tinkering with SQL

[Keisuke Miyako via 4D_Tech]

4D query is case insensitive whereas SWL by default is not.



**
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: Tinkering with SQL

[Robert McKeever via 4D_Tech]

So, how do I make the SQL case-insensitive?

> On Aug 6, 2018, at 4:57 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 4D query is case insensitive whereas SWL by default is not.
> 
> 
> 
> **
> 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
> **

_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@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: Tinkering with SQL

[Timothy Penner via 4D_Tech]

> So, how do I make the SQL case-insensitive?

http://doc.4d.com/4Dv16R5/4D/16-R5/Database-Parameters.302-3480842.en.html

Set Database Parameter (SQL Engine case sensitivity) = selector 44

-Tim



**
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: Tinkering with SQL

[Robert McKeever via 4D_Tech]

Thanks, Tim.

> On Aug 6, 2018, at 5:27 PM, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
>> So, how do I make the SQL case-insensitive?
> 
> http://doc.4d.com/4Dv16R5/4D/16-R5/Database-Parameters.302-3480842.en.html
> 
> Set Database Parameter (SQL Engine case sensitivity) = selector 44
> 
> -Tim
> 
> 
> 
> **
> 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
> **

_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@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
**

Getting A Colon In The Root Node Of XML File

[Stephen J. Orth via 4D_Tech]

Anyone,

Is there a way to get a colon character in the root node of an XML structure?  
The following is not working:

$root:=DOM Create XML Ref("dmm:Production_Order_Confirmations")

This will not create the XML structure, however if I remove it, then it will.  
Our customer is dictating this format, so I need to find a way around this 
issue in 4D please.

Best,


Steve


**
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: Getting A Colon In The Root Node Of XML File

[Stephen J. Orth via 4D_Tech]

Well,

Apparently it's not allow to do the following:

 $root:=DOM Create XML Ref("Production_Order_Confirmations")

However, you can do this:

 $root:=DOM Create XML Ref("Production_Order_Confirmations")
 DOM SET XML ELEMENT NAME($root;"dmm:Production_Order_Confirmations")

Go figure...


Steve


-Original Message-
From: Stephen J. Orth [mailto:s.o...@the-aquila-group.com] 
Sent: Monday, August 06, 2018 7:49 PM
To: '4D iNug Technical' <4d_tech@lists.4d.com>
Subject: Getting A Colon In The Root Node Of XML File

Anyone,

Is there a way to get a colon character in the root node of an XML structure?  
The following is not working:

$root:=DOM Create XML Ref("dmm:Production_Order_Confirmations")

This will not create the XML structure, however if I remove it, then it will.  
Our customer is dictating this format, so I need to find a way around this 
issue in 4D please.

Best,


Steve


**
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: Getting A Colon In The Root Node Of XML File

[Keisuke Miyako via 4D_Tech]

the colon symbol is a "namespace" delimiter in XML.

if you want to create a root element like dmm:Production_Order_Confirmations
you must first define what the "dmm" namespace prefix stands for.

the identifier should be a globally unique string, by convention a URL.
(it doesn't have to be a real URL, it's just a convenient way to define unique 
string)

e.g.

$root:=DOM Create XML 
Ref("dmm:Production_Order_Confirmations";"http://www.my-company.com/2018/dmm";)

in the example above, the default namespace becomes "dmm" instead of "xml".

$e:=DOM Find XML element($root;"Production_Order_Confirmations")
$e:=DOM Find XML element($root;"dmm:Production_Order_Confirmations")

both are valid references.

you might have not thought about it, but every element/attribute has the 
namespace prefix  "xml".



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