Re: return to a position half way on a webpage after viewing details

[Ronald Rosell]

Hi Ernie,

There are two ways tackle this (probably others as well, but these come to mind 
quickly):

1) Instead of going to an entirely new page, leaving the current one, load the 
new page in an overlay.  There are several “ibox” javascript libraries that 
will do this.  Then, the confirmation page displays in the same overlay, and 
they can close the overlay using a close button, returning to the original form 
(which they actually never left).   One of my favorite scripts for this is 
tinybox. http://sandbox.scriptiny.com/tinybox2/ 
.

OR

2) Include an HTML anchor next to each of the form lines; your loop can create 
these.  The anchor ID might be some variation on a variable in that line or 
segment of the form.  So, variable15 might be associated with anchor15, etc.  
Since that variable name is being passed to your database, you’ll know what the 
associated anchor is.  Then, the confirmation page can include a link (either a 
header refresh or a button to click) that returns you to the original page with 
#anchor15 at the end of the URL.  That would case the page to redisplay and 
scroll to the element the user was working with.

__

Ron Rosell
President
StreamLMS


> On Feb 7, 2017, at 6:40 PM, ernie hilgers  wrote:
> 
> Hi All,
> 
> I am in need of a push in the right direction with the following situation I 
> cannot solve (for now):
> 
> I put up a web page and load it with 20 lines of information with a heigth of 
> about 1.5 inch. (a loop is used)
> The users normally has a laptop screen or a Pad (any brand), meaning they 
> have to scroll about 4 times if they have clicked a link some where at the 
> bottom of the list.
> 
> When they click a link to see detailed information, another web page is send 
> to the browser by 4D with information from the database.
> They must fill out some some information into the available fields and press 
> "submit". 
> 
> The submit sends this data back to the 4D database PUTS UP another screen 
> indicating the data is send.
> 
> (here it comes:)
> in order to show the 20 lines of information again, I build the web page 
> using the 4D loop then send the page to the browser. 
> Now the user has to scroll down (again) to find the link they clicked (to see 
> the details). 
> The users have approached me with the question if it is possible to make it 
> happen automatically.
> 
> I want to have that clicked link smack in the middle of the screen (or at the 
> top) again and eliminate the need for scrolling down to find it.
> Did some searches on the internet but the explanation to do this is too vague 
> for my current knowledge. 
> 
> recap: 
> 1) I build a webpage by filling it with data using a loop
> 2) send the page to the browser
> 3) user clicks a link
> 4) fills out the form, click submit
> 5) when receiving the data a form is send to the browser acknowledging data 
> is received, then after 4 seconds
> 6) go back to step 1
> 
> Question: 
> How do I approach this problem in order to find a solution ? 
> 
> Pressing the "back button" requires the user to press it 3x to get back to 
> screen 1 and see which link was clicked, yes that works.
> first back: the thank you, data received screen
> second back: the form with info
> third back: the original list AND yes in the visible part of the screen AND 
> the link has changed color
> 
> However I don't want to allow the users to press the back button.
> 
> Your input is much appreciated.  
> - either: wrong way do the web -thing-: tell me where to look
> - more javascript : tell me what topic
> - ..
> 
> greetings
> 
> ernie hilgers (aruba)
> **
> 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
**

return to a position half way on a webpage after viewing details

[ernie hilgers]

Hi All,

I am in need of a push in the right direction with the following situation I 
cannot solve (for now):

I put up a web page and load it with 20 lines of information with a heigth of 
about 1.5 inch. (a loop is used)
The users normally has a laptop screen or a Pad (any brand), meaning they have 
to scroll about 4 times if they have clicked a link some where at the bottom of 
the list.

When they click a link to see detailed information, another web page is send to 
the browser by 4D with information from the database.
They must fill out some some information into the available fields and press 
"submit". 

The submit sends this data back to the 4D database PUTS UP another screen 
indicating the data is send.

(here it comes:)
in order to show the 20 lines of information again, I build the web page using 
the 4D loop then send the page to the browser. 
Now the user has to scroll down (again) to find the link they clicked (to see 
the details). 
The users have approached me with the question if it is possible to make it 
happen automatically.

I want to have that clicked link smack in the middle of the screen (or at the 
top) again and eliminate the need for scrolling down to find it.
Did some searches on the internet but the explanation to do this is too vague 
for my current knowledge. 

recap: 
1) I build a webpage by filling it with data using a loop
2) send the page to the browser
3) user clicks a link
4) fills out the form, click submit
5) when receiving the data a form is send to the browser acknowledging data is 
received, then after 4 seconds
6) go back to step 1

Question: 
How do I approach this problem in order to find a solution ? 

Pressing the "back button" requires the user to press it 3x to get back to 
screen 1 and see which link was clicked, yes that works.
first back: the thank you, data received screen
second back: the form with info
third back: the original list AND yes in the visible part of the screen AND the 
link has changed color

However I don't want to allow the users to press the back button.

Your input is much appreciated.  
- either: wrong way do the web -thing-: tell me where to look
- more javascript : tell me what topic
- ..

greetings

ernie hilgers (aruba)
**
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 Requst via Proxy Server

[Keisuke Miyako]

the HTTP client command in 4D are designed to respect the system proxy settings.
what you are asking for might be beyond its reach.

> 2017/02/08 8:26、dov uhrmasher  のメール：
> Could you just help me with one more thing? I am getting a bit confused as
> to where to put/build the proxy server settings. Using the example below
> how do I build the url?




**
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: form events in v15

[Kirk Brooks]

Allen,
I'll add my voice to Keith's suggestion that you turn off all events on the
forms (except On Load) and try working with the form. Turn on the events
you actually need.

On Tue, Feb 7, 2017 at 11:47 AM, Allen Matlick  wrote:

> Hi,
>
> We have a database that we’re trying to transition from v13 to v15.  It
> originally began in v3.5 and has been updated as 4D has advanced.
>
> We have some detail forms which have variable fields where information is
> entered that is used for queries and a subform which displays the query
> results..
>
> The list form that is attached to the subform area has code which executes
> each time an ‘on display detail’ event occurs.
>
> In v13 we could type some info into one of the variable fields and then
> tab out to execute the query and the displayed records would execute the
> ‘on display detail’ event once for each of the displayed records.  With v15
> we are finding that the ‘on display detail’ events are being generated
> many, many more times than they were with v15.  In this specific case, each
> time a letter is typed into the entry variable the displayed info
> refreshes.  Net effect is a very, very sluggish user interface.
>
> In one case, the display detail events are being triggered so frequently
> that the form is barely usable.  We have restricted the activated events
> for the forms to the minimum we can.  We are also seeing some things which
> are confusing, e.g. each time we type a character into a data entry
> variable the entire form redraws, but if we turn off the ‘on clicked’ event
> then the redraws stop.
>
> It seems that form events are propagating very differently in v15 compared
> to v13.  Can anyone provide any insight, pointers to docs, … ?
>
> We’re using a subform for display because we want to display 2 lines of
> data for each record and in some cases we include graphic elements which
> behave like buttons so that the user can bring up more info about specific
> components of the displayed information.
>
> Any insight would be appreciated.  Thanks.
>
> Allen
>
>
> **
> 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
> **




-- 
Kirk Brooks
San Francisco, CA
===
**
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 Requst via Proxy Server

[Keisuke Miyako]

I don't think the URL would be any different,
proxy settings are normally part of system preferences.

2017/02/08 8:12、dov uhrmasher 
> のメール：
Could you just help me with one more thing? I am getting a bit confused as
to where to put/build the proxy server settings. Using the example below
how do I build the url?



**
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: Integrating Javascript Survey Libraries with 4D

[Keisuke Miyako]

Hello,

perhaps you could check some of the past Tech Note article that deal with the 
Web Area.

older ones (especially those that tie up with online services) may not work any 
more,
but there is a lot you can learn from the discussion as well as the demo.

15-01Camera Interface - RevisedVance Villanueva
14-09Web Area InspectorTimothy A. Penner
14-17Web Area Callbacks in v14Timothy A. Penner
13-104D and Google Charts APIJean-Jacques Bleu
13-114D and Google Charts API - Part 2Jean-Jacques Bleu
12-06Music Player IntegrationSonya Rackwitz
12-12Image BrowserSonya Rackwitz
11-054D Credentials Manager: JavaScript Injection Using Data from 4DJoshua 
Fletcher
11-16The 4D v12 Rich Text Area ComponentTom Fitch
09-01Collapsible Lists with Web AreaJoe Resuello
09-12HTML Email ComponentThomas Maul
09-29Embedding Maps in 4D using Google Maps
09-30Geocoding Using Public DataThomas Maul
09-36Embedding Maps in 4D using Open LayersThomas Maul
09-42ZIP Codes in 4D v11 SQLLuis Piñeiros
09-44Chat Integration in 4D v11 SQLAtanas Atanassov
09-46QuickTime and YouTube movies in Web AreaJoe Resuello
08-25Web Area in 4D v11 SQLLuis Piñeiros
08-35Google Chart API and Web Area IntegrationChristopher Visaya
08-39MD5 Algorithm Implemented in 4D v11 SQLAtanas Atanassov
08-44Mashups with 4D v11 SQL Web AreaLuis Piñeiros



**
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 Request via Proxy Server

[Keisuke Miyako]

there are mentions of HTTP proxy here:

http://doc.4d.com/4Dv15/4D/15.3/HTTP-AUTHENTICATE.301-3152498.en.html

http://doc.4d.com/4Dv15/4D/15.3/WEB-SERVICE-AUTHENTICATE.301-3152793.en.html



**
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 Request via Proxy Server

[dov uhrmasher]

Thanks for your reply.

Would you mind pointing me to the correct documentation?

it is true that built-in HTTP clients prior to v13 (DOM PARSE XML Source,
CALL WEB SERVICE, etc) didn't work behind a proxy.
in the feature presentation of HTTP Get/Request, it was specifically
mentioned that it works well behind an HTTP proxy server.

2017/02/07 19:51、dov uhrmasher <[hidden email]

>>
のメール：
Is it possible to send requests using the in-built 4D HTTP Request via a
proxy server?
-- 

--
Dov Uhrmasher
+972 542 88 3612
**
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: 3rd Party Structure Repair Tools

[Keisuke Miyako]

rather than going to Design the normal way,
you could open the DB directly with the MSC.

> 2017/02/08 0:50、Douglas Cryer  のメール：
> I had a situation today where the database crashed when writing a method and 
> now when I open the design environment the methods start opening and the 
> database crashes.




**
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: XLS II plugin

[Keisuke Miyako]

Hello,

as others have already pointed out,
".xls" is just a generic extension used to imply MS Excel as the preferred 
application to open it.

what we usually refer to as an XLS file are BIFF8 files.

https://support.office.com/en-us/article/File-formats-that-are-supported-in-Excel-a28ae1d3-6d19-4180-9209-5a950d51b719

but a file with the ".xls" file could be any kind of file you would open with 
Excel, such as TSV, CSV or HTML.

it sounds like your file is an XMLSS file. (see link above)

XLS II is a simple plugin based on an old Code Project article,
a tutorial of how to parse BIFF8 files.

only very basic features are supported,
and of course no other ".xls" files can be opened except BIFF8.

if the file is XMLSS,
you could simply parse it with 4D XML commands.



**
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 Request via Proxy Server

[Keisuke Miyako]

it is true that built-in HTTP clients prior to v13 (DOM PARSE XML Source, CALL 
WEB SERVICE, etc) didn't work behind a proxy.
in the feature presentation of HTTP Get/Request, it was specifically mentioned 
that it works well behind an HTTP proxy server.

2017/02/07 19:51、dov uhrmasher 
> のメール：
Is it possible to send requests using the in-built 4D HTTP Request via a
proxy server?



**
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: form events in v15

[Keith Culotta]

Allen,

It's been my experience that more events fire in v15 forms than fired in older 
versions.  I started turning off as many unneeded events in converted forms as 
possible, and surrounding code with a test for the desired event.  Sometimes 
the test will include a flag.
It's mostly a clean up of (or working around) loose habits from 4Ds more 
accommodating days.

Case of 
: (Form event=On Display Detail) & (OKToUseODDFlag)
OKToUseODD:=False

End case 


Keith - CDI

> On Feb 7, 2017, at 1:47 PM, Allen Matlick  wrote:
> 
> Hi,
> 
> We have a database that we’re trying to transition from v13 to v15.  It 
> originally began in v3.5 and has been updated as 4D has advanced.
> 
> We have some detail forms which have variable fields where information is 
> entered that is used for queries and a subform which displays the query 
> results..
> 
> The list form that is attached to the subform area has code which executes 
> each time an ‘on display detail’ event occurs.
> 
> In v13 we could type some info into one of the variable fields and then tab 
> out to execute the query and the displayed records would execute the ‘on 
> display detail’ event once for each of the displayed records.  With v15 we 
> are finding that the ‘on display detail’ events are being generated many, 
> many more times than they were with v15.  In this specific case, each time a 
> letter is typed into the entry variable the displayed info refreshes.  Net 
> effect is a very, very sluggish user interface.
> 
> In one case, the display detail events are being triggered so frequently that 
> the form is barely usable.  We have restricted the activated events for the 
> forms to the minimum we can.  We are also seeing some things which are 
> confusing, e.g. each time we type a character into a data entry variable the 
> entire form redraws, but if we turn off the ‘on clicked’ event then the 
> redraws stop.
> 
> It seems that form events are propagating very differently in v15 compared to 
> v13.  Can anyone provide any insight, pointers to docs, … ? 
> 
> We’re using a subform for display because we want to display 2 lines of data 
> for each record and in some cases we include graphic elements which behave 
> like buttons so that the user can bring up more info about specific 
> components of the displayed information.
> 
> Any insight would be appreciated.  Thanks.
> 
> Allen
> 
> 
> **
> 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
**

Integrating Javascript Survey Libraries with 4D

[Benedict, Tom]

Anyone have experience integrating Javascript Survey libraries with 4D?

Creating and maintaining survey forms in 4D is tedious and time consuming. 
There are various Javascript libraries available which can generate survey 
pages on the fly and return results in JSON or XML. They even come with visual 
editors to create the survey. It seems simple enough, conceptually, to use 
something like this in a web area inside of 4D.

The use case here is telephone agents using 4D asking someone some screening 
questions. There may be data in 4D which will inform what survey questions are 
asked and the domain of possible answers and the result data needs to be stored 
in 4D.

BTW, I know very little about Javascript and only slightly more about 4D web 
areas.
I've looked at survey.js and surveyjs.org. It seems pretty full featured.

Anyone done this? Any recommendations? Issues to avoid?

Thanks,

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)
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: SagePay Direct from 4D [Solved]

[Balinder Walia]

Thanks for the kind words David, I am glad it is working now!

Cheers

On 7 February 2017 at 17:13, David Samson  wrote:

> The problem was that the "response" parameter variable was defined as text
> instead of BLOB. Although in connecting to other systems text was fine here
> it failed.
>
> Much thanks go to Balinder Walia who sorted it out in about 30 seconds. He
> has years of experience in both 4D and web programming and is very helpful.
>
>
> >Has anybody implemented card payments using the Direct version of SagePay.
> (They have a >product called SagePay Pi which I am not referring to.)
>
> >I have used "HTTP Request" with REST successfully in the past but in this
> case I am getting a >strange "arguments are incompatible" error which I
> suspect just means it was unable to connect >since I have double-checked
> all the parameters.
>
> >I have checked that our firewall is not blocking it.
>
>
> David Samson
> Manchester
> UK
> **
> 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: 3rd Party Structure Repair Tools

[Koen Van Hooreweghe]

Hi Doug,

One more thing...

If one of your methods is damaged (causes 4D crash), the Explorer could also 
crash when trying to display the method code preview.
Yet again the option key comes to rescue. If holding that key and selecting a 
method, the Explorer will not redraw the preview pane. This works at least from 
v6 up to v15.
But I just noticed this key combo does not work any more in v16 But then again, 
its obsolete as v16 won't crash at all, neither damage anything... ;-)

There is also the little grey triangle on the bottom to hide the preview pane. 
I guess this might work too.

HTH
Koen

Op 7-feb.-2017, om 17:33 heeft Koen Van Hooreweghe  het 
volgende geschreven:

> Have you tried to hold the alt key when opening the database or when going to 
> design environment.
> In standalone you will get the 'You pressed the "Option" key' dialog, just 
> click Continue, but keep pressing the alt key. The design environment should 
> not open any left open method windows.




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

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

Re: 3rd Party Structure Repair Tools

[Koen Van Hooreweghe]

Hi Doug,

Have you tried to hold the alt key when opening the database or when going to 
design environment.
In standalone you will get the 'You pressed the "Option" key' dialog, just 
click Continue, but keep pressing the alt key. The design environment should 
not open any left open method windows.

HTH
Koen
 
Op 7-feb.-2017, om 16:50 heeft Douglas Cryer  het 
volgende geschreven:

> I had a situation today where the database crashed when writing a method and 
> now when I open the design environment the methods start opening and the 
> database crashes.
> 
> No way to open the design environment AT ALL.  I have tried:




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

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

Re: 3rd Party Structure Repair Tools

[Charles Miller]

No longer data check and structure check are no more I know there was a beta of 
an upgrade but as far as I know never completed
Regards
Chuck

Sent from my iPhone

> On Feb 7, 2017, at 10:50 AM, Douglas Cryer  wrote:
> 
> Hi folks,
> 
> Are there any 3rd party structure repair tools for 4D v15?
> 
> I had a situation today where the database crashed when writing a method and 
> now when I open the design environment the methods start opening and the 
> database crashes.
> 
> No way to open the design environment AT ALL.  I have tried:
> Opening from Mac client, windows client mac/win standalone.
> Repairing structure (which comes up and says OK)
> Compacting structure (also OK)
> All of the above on different machines.
> I am going back to my backup but it worries me that this could happen and 
> that there is no way to get in.  Also is there some underlying issue that I 
> cannot know about because 4D says the structure is fine?
> 
> I have experienced issues like this a long time back and I was able to go 
> back to my backup and then export bits of code that I had been working on 
> with insider.  Now I guess I have to take more regular backups during the 
> development day?
> 
> 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)
> 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: v13+ - On After Double Clicked??

[Jeremy Roussak]

Yes, probably.

In the interim, I use a messaging system using CALL PROCESS and a message 
queue. It works well.

Jeremy


Jeremy Roussak
j...@mac.com



> On 7 Feb 2017, at 15:32, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
> I can not get any event to fire after closing an entry form from an 
> 'included' listbox.
> 
> On close detail - does not fire
> - on selection change -  fires BEFORE double click
> - on after edit - does not fire, as nothing is editable
> - on losing focus - does not fire as the listbox does not (apparently) 
> lose focus on a double click
> - on data change - does not fire
> 
> 
> so.. I still need an On After Double Click
> does anyone else think this would be useful?
**
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
**

3rd Party Structure Repair Tools

[Douglas Cryer]

Hi folks,

Are there any 3rd party structure repair tools for 4D v15?

I had a situation today where the database crashed when writing a method and 
now when I open the design environment the methods start opening and the 
database crashes.

No way to open the design environment AT ALL.  I have tried:
Opening from Mac client, windows client mac/win standalone.
Repairing structure (which comes up and says OK)
Compacting structure (also OK)
All of the above on different machines.
I am going back to my backup but it worries me that this could happen and that 
there is no way to get in.  Also is there some underlying issue that I cannot 
know about because 4D says the structure is fine?

I have experienced issues like this a long time back and I was able to go back 
to my backup and then export bits of code that I had been working on with 
insider.  Now I guess I have to take more regular backups during the 
development day?

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)
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: v13+ - On After Double Clicked??

[Chip Scheide]

I can not get any event to fire after closing an entry form from an 
'included' listbox.

On close detail - does not fire
- on selection change -  fires BEFORE double click
- on after edit - does not fire, as nothing is editable
- on losing focus - does not fire as the listbox does not (apparently) 
lose focus on a double click
- on data change - does not fire


so.. I still need an On After Double Click
does anyone else think this would be useful?


On Mon, 6 Feb 2017 23:11:09 +, Keisuke Miyako wrote:
> the "On (Open) Close Detail" event for the selection based listbox
> is only triggered if you have set the double click property of the 
> listbox to edit or add a record.
> 
> if it is set to "do nothing", I don't think the event won't fire.
> 
> 2017/02/07 7:01、Chip Scheide 
> <4d_o...@pghrepository.org> のメール
> ：
> maybe I've missed an existing event which covers this
> 
> 
> **
> 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: XLS II plugin

[Koen Van Hooreweghe]

Hi Magnus, Kirk,

This is indeed a trick I have to admit I've been using too.
Excel is capable of opening files in html format, even if the file extension is 
.xls. Because the html format is (for my purpose) easier to generate from 4D 
than native xls, I use that  etc html format. But to make sure the file 
is opened with Excel when a user double clicks it in the macOS Finder, the file 
extension .xls must be used. Otherwise it is opened in the default browser.

Obviously quick and dirty, but probably used by the big guys (SalesForce) too! 
:-)

Kind regards,
Koen

Op 7-feb.-2017, om 14:45 heeft Kirk Brooks  het volgende 
geschreven:

> I don't know that the issue is specific to the plugin. A couple of weeks
> ago I downloaded some files with a .XLS file extension from a vendor who
> uses SalesForce. They could not be opened by anything except xcel. Even
> google sheets which is probably the most robust option for importing
> anything.




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

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

HTTP Request via Proxy Server

[dov uhrmasher]

Good morning

Is it possible to send requests using the in-built 4D HTTP Request via a
proxy server?

Can the TCP/IP commands be utilised? Or would I need to build a custom
Request or use cUrl?

TIA

Dov

-- 

--
Dov Uhrmasher
+972 542 88 3612
**
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: Convert Picture Crashing 4D

[Nigel Greenlee]

Bruno.

Nice code.-solid bit of work there..don't mind if I take a copy do you.

Nigel Greenlee


> On 7 Feb 2017, at 09:54, Bruno LEGAY  wrote:
> 
> Hi,
> 
> Take a look here :
> http://forums.4d.fr/Post/FR/17329223/1/17329529#17329529
> 
> It is 4D code to parse internal 4D picture format (and extract the various 
> original format picture data).
> 
> You can test it to see what's wrong with your pictures…
> 
> HTH
> **
> 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: Convert Picture Crashing 4D

[Nigel Greenlee]

Sannyasin

Sorry i should have been more explanatory there..something like this(this all 
assumes the picture does load in the record)

$Path:=System folder(Documents folder)
$Path:=$Path+"Pictures"
If (Test path name($Path)#Is a folder)
CREATE FOLDER($Path)
End if 
$OutPath:=$path+Folder separator+"Converted_Pictures"
If (Test path name($OutPath)#Is a folder)
CREATE FOLDER($OutPath)
End if 
$OutPath:=$OutPath+Folder separator
ALL RECORDS([TABLE])
PICTURE CODEC LIST($Codecs;$Names)

For ($i;1;Records in selection([TABLE]))
If (Picture size([TABLE]Picture_pic)>0)
$_t_DocName:=[TABLE]RECORDIDSTRING

PICTURE TO BLOB([TABLE]Picture_pic;$_aPicBlob;".jpg”)<-if this does not work 
try something else
$doc:=Create document($Path+Folder separator+$_t_DocName+".jpg")
CLOSE DOCUMENT($doc)
BLOB TO DOCUMENT($Path+Folder separator+$_t_DocName+".jpg";$_aPicBlob)
$PosixPath:=Convert path system to POSIX($Path+Folder 
separator+$_t_DocName+".jpg")
$OutPosixPath:=Convert path system to POSIX($OutPath+$_t_DocName+".png")
$_t_Script:="sips -s format png "+$PosixPath+"  --out "+$OutPosixPath
LAUNCH EXTERNAL PROCESS($_t_Script)
end if
//here you would get the image from the new document back into the record if 
that is what you are planning to do
NEXT RECORD([TABLE])

End for 

I cant say if that will be any better-but if this will convert the picture(or 
even just export it in JPEG format) then you can open the image in preview and 
if it is loading there can then bring the JPEG back into the record.

> On 7 Feb 2017, at 09:36, Nigel Greenlee  wrote:
> 
> Sannyasin
> 
> Hi-if you having trouble with 4D crashing it you might consider exporting the 
> picture in the what ever format it currently is and then using LEP to call 
> the command line to convert it to a JPG, then you can re-import the new 
> picture.
> 
> https://developer.apple.com/legacy/library/documentation/Darwin/Reference/ManPages/man1/sips.1.html
>  
> 
> 
> Nigel Greenlee
> 
> 
> 
>> On 6 Feb 2017, at 22:02, Sannyasin Siddhanathaswami  wrote:
>> 
>> Aloha,
>> 
>> We are starting the preparations for v16, and dealing with the picture 
>> issues. Let’s just say we have tons of ancient photos in our database! We 
>> are currently using v15.3 on a Mac (server - client).
>> 
>> Basically, we are trying to convert all pictures to jpg. Unfortunately, 
>> doing this crashed 4D:
>> CONVERT PICTURE([Members]Picture;".jpg";0.8)
>> 
>> Even putting the picture field into a variable before converting crashes 
>> during the “Convert Picture.” It’s not all picture, just many of them. By 
>> crash, the 4D.app just quits to the desktop with a crash report.
>> 
>> I can view these pictures just fine in an input form. If I copy the picture 
>> out of the input form, into another app, then back in, the conversion works 
>> fine.
>> 
>> Anyone have any tips on how to approach this? If I run the method to execute 
>> on server, the whole server crashes…
>> 
>> Thanks,
>> 
>> 
>> Sannyasin Siddhanathaswami
>> **
>> 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
> **

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

XLS II plugin

[Magnus Torell]

I am using XLS 11 for importing stock level from another system. (Many
Thanks)
I just receive excel files (.xls). It has been working for a year since I
started.
However the files that started to come a week ago will not be read with XLS
II
They open just fine in Excel, but the most simple commands with XLS II seem
to fail?
I just do following to see a difference between old and new files.
Ever since beginning with XLS II I have had to do a trick, and that is to
open and save
the file with excel -Mac excel 2011- on my computer. That seems to have
triggered
something that makes the file recognized by XLS II plugin)

C_TIME($dref)
$dref:=Open document($vName2;"*";Read mode)
If (OK=1)
$filePath:=Document
CLOSE DOCUMENT($dref)
$wb:=XLS Load ($filePath)
$sheet:=1
$cols:=XLS Get total columns ($wb;$sheet)
$rows:=XLS Get total rows ($wb;$sheet)

With the failing files I get no $cols or $rows at all.
Files seems identical to me. What can be the reason?
The supplier have automatic generated xls files and they do not know of any
changes.

What can be the change? Any ideas are appreciated.

Best Regards

Magnus Torell



--
View this message in context: 
http://4d.1045681.n5.nabble.com/XLS-II-plugin-tp5750156.html
Sent from the 4D Tech mailing list archive at Nabble.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: Convert Picture Crashing 4D

[Nigel Greenlee]

Sannyasin

Hi-if you having trouble with 4D crashing it you might consider exporting the 
picture in the what ever format it currently is and then using LEP to call the 
command line to convert it to a JPG, then you can re-import the new picture.

https://developer.apple.com/legacy/library/documentation/Darwin/Reference/ManPages/man1/sips.1.html
 


Nigel Greenlee



> On 6 Feb 2017, at 22:02, Sannyasin Siddhanathaswami  wrote:
> 
> Aloha,
> 
> We are starting the preparations for v16, and dealing with the picture 
> issues. Let’s just say we have tons of ancient photos in our database! We are 
> currently using v15.3 on a Mac (server - client).
> 
> Basically, we are trying to convert all pictures to jpg. Unfortunately, doing 
> this crashed 4D:
> CONVERT PICTURE([Members]Picture;".jpg";0.8)
> 
> Even putting the picture field into a variable before converting crashes 
> during the “Convert Picture.” It’s not all picture, just many of them. By 
> crash, the 4D.app just quits to the desktop with a crash report.
> 
> I can view these pictures just fine in an input form. If I copy the picture 
> out of the input form, into another app, then back in, the conversion works 
> fine.
> 
> Anyone have any tips on how to approach this? If I run the method to execute 
> on server, the whole server crashes…
> 
> Thanks,
> 
> 
> Sannyasin Siddhanathaswami
> **
> 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
**