Re: [off] File will not open in excel

[Chip Scheide via 4D_Tech]

understood

Thanks

> of course, it is newer, but what I meant was that a feature available 
> in 2010 is not necessarily available in 2011.
> 
>> 2011 (Mac) is not newer than 2010 (Windows).
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: [off] File will not open in excel

[Keisuke Miyako via 4D_Tech]

technically, XLS is not a file format, it is just a file extension that 
associates the file with the MS Excel application.
the file content can be anything from CSV, TSV, OOXML to HTML.
what we often refer to as an XLS spreadsheet is actually a file in the BIFF8 
format.

https://www.openoffice.org/sc/excelfileformat.pdf

in other words, it is perfectly legal to name an HTML file as *.xls.

---

as for the Excel version, the progressive year numbers do not translate across 
platforms.
2011 (Mac) is not newer than 2010 (Windows).

for example:

the first version to accept UTF-8 (provided it has a BOM) was 2010 on Windows 
but 2016 on Mac.
you need to use UTF-16LE to force feed a text file (CSV, TSV) for Excel 
2011/2008 on Mac and Excel 2007/2003 on Windows.

--

in any case, the extension is not really the issue.

if Excel is capable of opening the file it will open it as a spreadsheet 
regardless of the extension.
if it opens it like a text file, the Excel version is simply too old.



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

Re: [off] File will not open in excel

[Keisuke Miyako via 4D_Tech]

of course, it is newer, but what I meant was that a feature available in 2010 
is not necessarily available in 2011.

> 2011 (Mac) is not newer than 2010 (Windows).




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

Re: [off] File will not open in excel

[Chip Scheide via 4D_Tech]

Thanks!

> Hi Chip,
> I get these from time to time as well. PITA.
> 
> The ones I get have some weird formatting at the beginning. If you look at
> it in your text editor you'll probably see some style tag (  ...
> ) followed by two tables. The first one probably has the column
> headers and the second one the data. After screwing around with trying to
> do it elegantly I resorted to quick brute force:
> 
> Delete the style tag.
> Delete the first   pair so that you've got a single table.
> Save the file.
> Open it in a browser.
> Copy and paste back into your text editor.
> Save.
> 
> No you've got the contents as a tab delimited plain file.
> 
> On Fri, Dec 15, 2017 at 12:57 PM, Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Got a file which claims to be an excel file (.xls) but will not open as
>> an excel spreadsheet (Mac Office 2011 Excel)
>> When the file opens in excel, it is opened as if it was a plain text
>> file, when opened in Windows Office 2010 Excel it opens, and opens as a
>> spread sheet.
>> 

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

Re: Microsoft Outlook Integration

[Douglas von Roeder via 4D_Tech]

Tim:

I don't recall the specific article but I think I saw something in the 4D
knowledge base during a recent visit there.

--
Douglas von Roeder
949-336-2902

On Fri, Dec 15, 2017 at 12:51 PM, Tim Nevels via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I have a client that wants to have me integrate his 4D application with
> Outlook.
>
> Basically I need to be able to create an html email, include attachments
> and send it via his Outlook client on his machine.
>
> I know there is a way to turn on some features on the Exchange server to
> allow sending emails without using the Outlook client, but this cannot be
> done. Corporate IT refuses to allow this.
>
> I am aware that there are some security settings that need to be turned
> off or disabled to allow an app to control Outlook and send emails with it.
> I have full control of the Windows 10 PC and can do whatever is needed to
> turn these off. (IT does not have access to this PC.)
>
> I know there have been some plugins that allow doing this kind of thing,
> but I can’t remember what they are or where to get them.
>
> Anybody doing this now and can provide info on how you are doing it?
>
> Can anyone provide me a link to where to find a plugin to do this?
>
> Tim
>
> 
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.com
> 
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: [off] File will not open in excel

[Kirk Brooks via 4D_Tech]

Hi Chip,
I get these from time to time as well. PITA.

The ones I get have some weird formatting at the beginning. If you look at
it in your text editor you'll probably see some style tag (  ...
) followed by two tables. The first one probably has the column
headers and the second one the data. After screwing around with trying to
do it elegantly I resorted to quick brute force:

Delete the style tag.
Delete the first   pair so that you've got a single table.
Save the file.
Open it in a browser.
Copy and paste back into your text editor.
Save.

No you've got the contents as a tab delimited plain file.

On Fri, Dec 15, 2017 at 12:57 PM, Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Got a file which claims to be an excel file (.xls) but will not open as
> an excel spreadsheet (Mac Office 2011 Excel)
> When the file opens in excel, it is opened as if it was a plain text
> file, when opened in Windows Office 2010 Excel it opens, and opens as a
> spread sheet.
>


-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

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

RE: [off] File will not open in excel

[Chip Scheide via 4D_Tech]

I *know* it is not an els file...
It is (from the header) HTML.

I pulled the DTD referenced in the header, it is HTML 4.0 - strict.

If I change the extension to .html and feed it to a browser it opens 
(mostly) correctly. i.e. it looks like a spread sheet, but there are 
some header and footer 'garbage'.

From what I know about it, it is an export (or report written to disk) 
from Oracle.

The oddest part is that Office 2010 (Windows) will open the file as a 
spreadsheet, but Office 2011 (Mac) will not, it is treated as a plain 
text file.

Thanks for the help, and any more ideas you may have.
Chip

On Fri, 15 Dec 2017 21:22:19 +, Timothy Penner via 4D_Tech wrote:
> From the snippet of the file you included it looks like an email, not 
> an Excel spreadsheet.
> 
> What does the file contents look like if you open it in a text editor 
> like TextWrangler (is it human readable)?  If it is human readable, 
> then it is not an XLS file.
> 
> -Tim
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://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)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Microsoft Outlook Integration

[Randy Engle via 4D_Tech]

Tim,

I'm pretty sure that Armin Deeg can help you out here.

http://node.de/indexplug.htm



Randy Engle, Director
XC2 Software LLC – XC2LIVE!

-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Tim Nevels via 
4D_Tech
Sent: Friday, December 15, 2017 12:51 PM
To: 4d_tech@lists.4d.com
Cc: Tim Nevels 
Subject: Microsoft Outlook Integration

I have a client that wants to have me integrate his 4D application with 
Outlook. 

Basically I need to be able to create an html email, include attachments and 
send it via his Outlook client on his machine. 

I know there is a way to turn on some features on the Exchange server to allow 
sending emails without using the Outlook client, but this cannot be done. 
Corporate IT refuses to allow this. 

I am aware that there are some security settings that need to be turned off or 
disabled to allow an app to control Outlook and send emails with it. I have 
full control of the Windows 10 PC and can do whatever is needed to turn these 
off. (IT does not have access to this PC.)

I know there have been some plugins that allow doing this kind of thing, but I 
can’t remember what they are or where to get them. 

Anybody doing this now and can provide info on how you are doing it?

Can anyone provide me a link to where to find a plugin to do this? 

Tim


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


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

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

RE: [off] File will not open in excel

[Timothy Penner via 4D_Tech]

From the snippet of the file you included it looks like an email, not an Excel 
spreadsheet.

What does the file contents look like if you open it in a text editor like 
TextWrangler (is it human readable)?  If it is human readable, then it is not 
an XLS file.

-Tim



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

[off] File will not open in excel

[Chip Scheide via 4D_Tech]

Got a file which claims to be an excel file (.xls) but will not open as 
an excel spreadsheet (Mac Office 2011 Excel)
When the file opens in excel, it is opened as if it was a plain text 
file, when opened in Windows Office 2010 Excel it opens, and opens as a 
spread sheet.

Anyone have any ideas on how to open this type of file in Excel (Mac) 
-- 
Thanks for any help


this is the header of the file:

From: Created by Oracle BI Publisher <>
Message-ID: 
<570709848.177478.1513289410195.javamail.ora...@anonymous.anonymous.com>
Subject: Created by Oracle BI Publisher
MIME-Version: 1.0
Content-Type: multipart/mixed; 
boundary="=_Part_177475_1398994286.1513289410191"

--=_Part_177475_1398994286.1513289410191
Content-Type: multipart/related; 
boundary="=_Part_177476_98513799.1513289410192"

--=_Part_177476_98513799.1513289410192
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit


http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>
http://www.w3.org/1999/xhtml";>



RTF Template

I have tried changing the extension from .xls to:
- rtf
- xlsx
- html
- xml

none of the options will open as a spread sheet, and mostly it will not 
open with the extension changes.

I can supply a bit more of the file's content - but - I can not provide 
the document or most of it's content as it is financial info from 
accounting.

Chip
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Microsoft Outlook Integration

[Tim Nevels via 4D_Tech]

I have a client that wants to have me integrate his 4D application with 
Outlook. 

Basically I need to be able to create an html email, include attachments and 
send it via his Outlook client on his machine. 

I know there is a way to turn on some features on the Exchange server to allow 
sending emails without using the Outlook client, but this cannot be done. 
Corporate IT refuses to allow this. 

I am aware that there are some security settings that need to be turned off or 
disabled to allow an app to control Outlook and send emails with it. I have 
full control of the Windows 10 PC and can do whatever is needed to turn these 
off. (IT does not have access to this PC.)

I know there have been some plugins that allow doing this kind of thing, but I 
can’t remember what they are or where to get them. 

Anybody doing this now and can provide info on how you are doing it?

Can anyone provide me a link to where to find a plugin to do this? 

Tim


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


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

Re: Call Chain

[Dani Beaubien via 4D_Tech]

Hi Jim, you can get the method name and line # of where the error occured.

From (http://doc.4d.com/4Dv16R4/4D/16-R4/ON-ERR-CALL.301-3316809.en.html):
The Error variable value is significant only within the error-handling method; 
if you need the error code within the method that provoked the error, copy the 
Error variable to your own process variable. You can also access the Error 
method, Error line and Error formula system variables which contain, 
respectively, the name of the method, the line number and the text of the 
formula where the error occurred (see Error, Error method, Error line 
).

Dani Beaubien


> On Dec 15, 2017, at 9:30 AM, Jim Medlen via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 
> Inside the error handling method set by ON ERR CALL is there a way to access
> the 
> CALL CHAIN similar to GET LAST ERROR STACK so that the Error method
> could log which method generated the Error?
> 
> Is there a way to identify the Method that generated the Error?
> 
> 
> Thanks,
> 
> Jim Medlen
> Computer & Information Systems
> Functional Devices, Inc.
> j.med...@functionaldevices.com
> phone (765) 883-5538 x 428
> fax (765) 883-4262
> http://www.functionaldevices.com
> 
> This email was transmitted on 100 percent recycled electrons
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: New Object passed as parameter question

[Douglas von Roeder via 4D_Tech]

John:

We spend a lot of time thinking "OK, but if…" so I see that as being part
of the job.


As I told a client of mine who's a big college football fan:

"Football is a game of inches that makes heroes. Programming 4D just
creates neurotics."

:-)


--
Douglas von Roeder
949-336-2902

On Fri, Dec 15, 2017 at 9:01 AM, John Baughman via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Thanks Doug. My mind can rest easy now. I think I sweat the small stuff
> too much on occasion.
>
> John
>
>
> > On Dec 15, 2017, at 6:51 AM, Douglas von Roeder via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > John:
> >
> > Objects respect scope so they don't have to be explicitly cleared. That's
> > different than an hList or our favorite word processor. :-)
> >
> > Also, 4D uses "ref counting" when it works with C_Object so that makes
> them
> > even more memory efficient.
> >
> >
> >
> > --
> > Douglas von Roeder
> > 949-336-2902
> >
> > On Fri, Dec 15, 2017 at 8:44 AM, John Baughman via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> >> If I am making multiple calls to a method and passing parameters via a
> >> C_OBJECT, is their any memory issues using New object. For example…
> >>
> >> $printedHeight:=Timesheets_BuildReport (New
> object("line";"employeeLine1";
> >> "employee";$employeeName;"taskdate";!2017-01-02!))
> >> $printedHeight:=Timesheets_BuildReport (New
> object("line";"employeeLine";"
> >> employee";$employeeName;"taskdate";!2017-01-03!))
> >> $printedHeight:=Timesheets_BuildReport (New
> object("line";"employeeLine";"
> >> employee";$employeeName;"taskdate";!2017-01-07!))
> >>
> >> // Timesheets_BuildReport  consumes the passed parameter...
> >> C_OBJECT($oLineParams;$1)
> >> $oLineParams:=$1
> >>
> >> I got to thinking about what happens to the C_OBJECT after
> >> Timesheets_BuildReport consumes it. Does it hang around in memory? My
> >> thinking is that since it’s being saved to a local variable, it will die
> >> when Timesheets_BuildReport ends.
> >>
> >> Should I rethink this and populate a single C_OBJECT as I go?
> >>
> >> thanks,
> >>
> >> John
> >>
> >> John Baughman
> >> Kailua, Hawaii
> >> (808) 262-0328
> >> john...@hawaii.rr.com
> >>
> >>
> >>
> >>
> >>
> >> **
> >> 4D Internet Users Group (4D iNUG)
> >> FAQ:  http://lists.4d.com/faqnug.html
> >> Archive:  http://lists.4d.com/archives.html
> >> Options: http://lists.4d.com/mailman/options/4d_tech
> >> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> >> **
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: http://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > **
>
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.com
>
>
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: New Object passed as parameter question

[John Baughman via 4D_Tech]

Thanks Doug. My mind can rest easy now. I think I sweat the small stuff too 
much on occasion.

John


> On Dec 15, 2017, at 6:51 AM, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> John:
> 
> Objects respect scope so they don't have to be explicitly cleared. That's
> different than an hList or our favorite word processor. :-)
> 
> Also, 4D uses "ref counting" when it works with C_Object so that makes them
> even more memory efficient.
> 
> 
> 
> --
> Douglas von Roeder
> 949-336-2902
> 
> On Fri, Dec 15, 2017 at 8:44 AM, John Baughman via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> If I am making multiple calls to a method and passing parameters via a
>> C_OBJECT, is their any memory issues using New object. For example…
>> 
>> $printedHeight:=Timesheets_BuildReport (New object("line";"employeeLine1";
>> "employee";$employeeName;"taskdate";!2017-01-02!))
>> $printedHeight:=Timesheets_BuildReport (New object("line";"employeeLine";"
>> employee";$employeeName;"taskdate";!2017-01-03!))
>> $printedHeight:=Timesheets_BuildReport (New object("line";"employeeLine";"
>> employee";$employeeName;"taskdate";!2017-01-07!))
>> 
>> // Timesheets_BuildReport  consumes the passed parameter...
>> C_OBJECT($oLineParams;$1)
>> $oLineParams:=$1
>> 
>> I got to thinking about what happens to the C_OBJECT after
>> Timesheets_BuildReport consumes it. Does it hang around in memory? My
>> thinking is that since it’s being saved to a local variable, it will die
>> when Timesheets_BuildReport ends.
>> 
>> Should I rethink this and populate a single C_OBJECT as I go?
>> 
>> thanks,
>> 
>> John
>> 
>> John Baughman
>> Kailua, Hawaii
>> (808) 262-0328
>> john...@hawaii.rr.com
>> 
>> 
>> 
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: http://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.com





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

Re: New Object passed as parameter question

[Douglas von Roeder via 4D_Tech]

John:

Objects respect scope so they don't have to be explicitly cleared. That's
different than an hList or our favorite word processor. :-)

Also, 4D uses "ref counting" when it works with C_Object so that makes them
even more memory efficient.



--
Douglas von Roeder
949-336-2902

On Fri, Dec 15, 2017 at 8:44 AM, John Baughman via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> If I am making multiple calls to a method and passing parameters via a
> C_OBJECT, is their any memory issues using New object. For example…
>
> $printedHeight:=Timesheets_BuildReport (New object("line";"employeeLine1";
> "employee";$employeeName;"taskdate";!2017-01-02!))
> $printedHeight:=Timesheets_BuildReport (New object("line";"employeeLine";"
> employee";$employeeName;"taskdate";!2017-01-03!))
> $printedHeight:=Timesheets_BuildReport (New object("line";"employeeLine";"
> employee";$employeeName;"taskdate";!2017-01-07!))
>
> // Timesheets_BuildReport  consumes the passed parameter...
>  C_OBJECT($oLineParams;$1)
>  $oLineParams:=$1
>
> I got to thinking about what happens to the C_OBJECT after
> Timesheets_BuildReport consumes it. Does it hang around in memory? My
> thinking is that since it’s being saved to a local variable, it will die
> when Timesheets_BuildReport ends.
>
> Should I rethink this and populate a single C_OBJECT as I go?
>
> thanks,
>
> John
>
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.com
>
>
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Call Chain

[Timothy Penner via 4D_Tech]

Hi Jim,

There are multiple feature requests for what you are asking for:
http://forums.4d.com/Post/EN/16024769/1/16024787#16024770
http://forums.4d.com/Post/en/13593874#13593875
http://forums.4d.com/Post/EN/3470460/2/15607676#3470461
http://forums.4d.com/Post/EN/7943985/1/14895126#7943986
http://forums.4d.com/Post/EN/1208761/1/14895121#1208762
http://forums.4d.com/Post/EN/17184906/1/17185033#17184907

Please vote if for them if you haven't already done so.

-Tim



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

Re: HTTP Get and HTTP Request Blocking Server?

[Cannon Smith via 4D_Tech]

Hi John

Thanks for the confirmation. I appreciate it!

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Dec 15, 2017, at 9:40 AM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> The 4D HTTP commands are non-blocking. I claim this because I use them for a 
> 4D to 4D remote procedure call implementation. Sometimes I test with both the 
> client side and server side in the same application instance. This is slower, 
> but it works and you can trace method calls on both sides of the interface. 
> There is no way this would work if the client blocked execution until the end 
> of the response.

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

New Object passed as parameter question

[John Baughman via 4D_Tech]

If I am making multiple calls to a method and passing parameters via a 
C_OBJECT, is their any memory issues using New object. For example…

$printedHeight:=Timesheets_BuildReport (New 
object("line";"employeeLine1";"employee";$employeeName;"taskdate";!2017-01-02!))

$printedHeight:=Timesheets_BuildReport (New 
object("line";"employeeLine";"employee";$employeeName;"taskdate";!2017-01-03!))
$printedHeight:=Timesheets_BuildReport (New 
object("line";"employeeLine";"employee";$employeeName;"taskdate";!2017-01-07!))

// Timesheets_BuildReport  consumes the passed parameter...
 C_OBJECT($oLineParams;$1)
 $oLineParams:=$1

I got to thinking about what happens to the C_OBJECT after 
Timesheets_BuildReport consumes it. Does it hang around in memory? My thinking 
is that since it’s being saved to a local variable, it will die when 
Timesheets_BuildReport ends.

Should I rethink this and populate a single C_OBJECT as I go? 

thanks,

John

John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.com





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

Re: HTTP Get and HTTP Request Blocking Server?

[John DeSoi via 4D_Tech]

Cannon,


> On Dec 15, 2017, at 10:18 AM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Thanks, Arnaud. I was hoping to find someone that could say “Hey, we do that 
> now and it isn’t a problem” to give me some confidence going forward. But 
> you’re right, there are other possibilities if it doesn’t work.

The 4D HTTP commands are non-blocking. I claim this because I use them for a 4D 
to 4D remote procedure call implementation. Sometimes I test with both the 
client side and server side in the same application instance. This is slower, 
but it works and you can trace method calls on both sides of the interface. 
There is no way this would work if the client blocked execution until the end 
of the response.

John DeSoi, Ph.D.

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

Call Chain

[Jim Medlen via 4D_Tech]

Inside the error handling method set by ON ERR CALL is there a way to access
the 
CALL CHAIN similar to GET LAST ERROR STACK so that the Error method
could log which method generated the Error?

Is there a way to identify the Method that generated the Error?


Thanks,

Jim Medlen
Computer & Information Systems
Functional Devices, Inc.
j.med...@functionaldevices.com
phone (765) 883-5538 x 428
fax (765) 883-4262
http://www.functionaldevices.com

This email was transmitted on 100 percent recycled electrons




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

Re: HTTP Get and HTTP Request Blocking Server?

[Cannon Smith via 4D_Tech]

Thanks, Arnaud. I was hoping to find someone that could say “Hey, we do that 
now and it isn’t a problem” to give me some confidence going forward. But 
you’re right, there are other possibilities if it doesn’t work.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Dec 15, 2017, at 1:50 AM, Arnaud de Montard via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I've heard about blocking too, but no more than hearing… If it's true, a web 
> server on a 4D client could be a turnaround, or using a plugin like NTK. 

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

Re: HTTP Get and HTTP Request Blocking Server?

[Cannon Smith via 4D_Tech]

Hi Miyako,

Hmm, sounds like I should be able to make something work, then. Worth trying.

Thanks.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Dec 14, 2017, at 5:45 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I have only started to learn using libcurl so my understanding is limited,
> but I think the general idea goes like this:
> 
> for a time consuming operation like HTTP where the slowness is largely 
> external to the application (i.e. network, server response), it could be 
> better to have a single thread performing multiple requests in a round robin 
> manner, where it will alternate between waiting (no point in stressing the 
> system) and calling select() with a decent timeout for each request. ideally, 
> you could get near completing 3 requests that each take 3 seconds to complete 
> in 3 seconds, not 9 seconds.
> 
> so it is not enough to just be non-blocking, or yielding to other threads. 
> the caller must also be nicer to other threads by alternating between idle 
> and busy while it waits for data, especially when the server takes time to 
> respond.
> 
> it might be interesting to call HTTP Request in a preemptive worker, but 
> whether the call relieves the application from stress may depend on other 
> factors as well.

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

Re: Pictures beside text in 4D Write Pro

[Pat Bensky via 4D_Tech]

John (and anybody else who wants columns) - please vote for my feature
request on the Beta forum:
http://forums.4d.com/Post/EN/19736637/1/19736638#19736638

Pat

On 15 December 2017 at 01:17, John Baughman via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> In that particular case I think it could be a table. as the 2 columns
> could be of equal height. A 1 x 2 table.
>
> What I need is a block of text the full height of the page next to several
> images stacked on top of each other vertically. Now that I am thinking of
> it, perhaps I could add the images together into a single image and then
> use a 2 column table set to the height of the page.
>
> What I really need, thinking about it over the last few days, is the
> ability to create columns in 4D write Pro that are not tables but real
> columns.
>
> Of course the easiest solution is to provide an option to paste pictures
> behind text as we could in 4D Write. Perhaps that is not possible in Pro??
>
> John
>
>
>
> > On Dec 14, 2017, at 3:07 PM, Pat Bensky via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > John,
> > I believe the way to accomplish this would be to apply columns to a block
> > of text. Unfortunately that option isn't (yet) available ): So I too
> would
> > like to know how it was done ... perhaps he used a development version
> ...
> > I will ask Roland (who wrote the blog) about it.
> >
> > Pat
> >
> > On 13 December 2017 at 03:18, John Baughman via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> >> in the blog post about tables…
> >>
> >> https://blog.4d.com/4d-write-pro-supports-tables/
> >>
> >> The 4D Write Pro document in the video has 3 pictures in it with text
> >> blocks beside them. Can someone tell me how that was done?
> >>
> >> I only see the ability to insert pictures in line with the text or in
> >> background.
> >>
> >> I was hoping that I could accomplish this in tables, but playing around
> >> with tables I think tables won’t do the trick either.
> >>
> >> What I need is to have a block of text from the left side along side 5
> or
> >> 6 images aligned vertically on the right side of the document.
> >>
> >> This was easily done in 4D write given the ability to insert images
> behind
> >> the text (not in background). The images could be selected with a
> >> command-click and moved to the desired positions. I created a template
> that
> >> contained the text area and 6 pictures (blank place holder images)
> >> positioned properly behind the text on the right side of the document.
> When
> >> the template was used 4D programmatically repopulated the empty pictures
> >> from the database.
> >>
> >> I still do not see anyway to do this in 4D Write Pro.
> >>
> >> Thanks,
> >>
> >> John
> >>
> >>
> >>
> >>
> >> John Baughman
> >> Kailua, Hawaii
> >> (808) 262-0328
> >> john...@hawaii.rr.com
> >>
> >>
> >>
> >>
> >>
> >> **
> >> 4D Internet Users Group (4D iNUG)
> >> FAQ:  http://lists.4d.com/faqnug.html
> >> Archive:  http://lists.4d.com/archives.html
> >> Options: http://lists.4d.com/mailman/options/4d_tech
> >> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> >> **
> >
> >
> >
> >
> > --
> > *
> > CatBase - Top Dog in Data Publishing
> > tel: +44 (0) 207 118 7889
> > w: http://www.catbase.com
> > skype: pat.bensky
> > *
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: http://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > **
>
> John Baughman
> Kailua, Hawaii
> (808) 262-0328
> john...@hawaii.rr.com
>
>
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: HTTP Get and HTTP Request Blocking Server?

[Arnaud de Montard via 4D_Tech]

> Le 15 déc. 2017 à 00:07, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Hi All,
> 
> I’m using 4D Server with the web server on. 

Hi Cannon, 
I've heard about blocking too, but no more than hearing… If it's true, a web 
server on a 4D client could be a turnaround, or using a plugin like NTK. 

-- 
Arnaud de Montard 




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