4D Integration with Microsoft Dynamics AX 2012 "cube"

[Dan Ivy via 4D_Tech]

I am researching ways to integrate 4D with Microsoft Dynamics AX 2012. I feel
pretty sure what I need to do can be (or should be) easily accomplished
using 4D ODBC and SQL. But I've not done an integration with AX before so
you never know, right?  Looking for a sanity check. 

A key concept in this project will be exchanging data with something AX
people call "data cubes" or just "the cube" which is apparently an
intermediate summary MS Sql DB/or data warehouse feature of Dynamics AX. As
I understand, "the cube" is a periodically synchronized copy of certain
kinds of AX data configured in a way that is simpler and more accessible
than how it is stored in the production SQL server database.  This is
apparently part of the API that Microsoft Dynamics AX provides to third
party apps for report generation and data extraction for BI functions, etc. 

If this concept sounds familiar to any of you would you please let me know? 
Any comments, encouraging, DIScouraging, etc are welcomed. 

Even better, can anyone confirm for me that 4D has been successfully
integrated with AX in this way? 

Thank you 
Dan Ivy 
ivyleaf systems 



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: 2 instances of 4D connected to different 4D Servers

[JOHN BAUGHMAN via 4D_Tech]

Just to close this thread out. I finally have a windows 10 vm installed and can 
confirm what everyone has been telling me with regard to running multiple 
instances of 4D.


1. Using shift click in the task bar and Menu as well as double clicking a 
shortcut on the desktop - Works only with 64bit 4D. I tested with 2008 server, 
win 7, and win 10 with 16R6.

2. Using a copy of the 4D version folder in Programs (32 or 64 bit) works as 
well, but this is your only option if you are running 32 bit. 

Thanks to all who chimed in.

John


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

> On Jun 19, 2018, at 1:56 PM, JOHN BAUGHMAN  wrote:
> 
> Tiim,
> 
> Thanks for the clarification. In my client’s case they are using 64bit 
> version on Windows 10. I am testing on various versions of windows in 
> VirutalBox. In Windows 7 where I couldn’t get 2 instances of 4D I only had a 
> 32bit version.
> 
> I just tested in windows 2008 and confirm what you are saying about it being 
> 64bit only. While I can run multiple instances of 4D 64bit, cannot do the 
> same with a 32bit version. This is NOT a windows version issue, is it.
> 
> For you and Keisuke… Can one run multiple instances of 4D to connect to 2 4D 
> servers without a developer license? Tim you seem to suggest yes, but Keisuke 
> might be saying no. Don’t see any reason, license agreement wise, why one 
> would not be allowed to run multiple instances of 4D as clients.
> 
> Still waiting to hear back from my client with Windows 10.
> 
> John
> 
> 
> John Baughman
> 1331 Auwaiku Street
> Kailua, Hawaii  96734
> (808) 262-0328
> john...@hawaii.rr.com 
> 
>> On Jun 19, 2018, at 1:23 PM, Timothy Penner > > wrote:
>> 
>> Hi John,
>>  
>> > The blog post refers to developer edition. Is it also true of a standard 
>> > version of 4D?
>>  
>> Developer edition is a license, Standard edition is a license.
>> Both editions use the same executable (4D.exe on Windows or 4D.app on Mac) 
>> with different features enabled at runtime depending on the license found.
>>  
>> The feature you are trying to use - launching multiple instances of the 
>> application - takes place prior to the license being checked, so I don’t see 
>> why it wouldn’t work with a Standard Edition license.
>>  
>> I honestly think the blog is referring to 4D Standalone/mono when it 
>> mentions 4D Developer (as opposed to 4D Server).
>>  
>> Most importantly, are you using 32 bit or 64 bit? 
>> * This feature is 64-bit only!
>>  
>> I know in the most recent responses (3:39 pm) you mentioned using v16R6 
>> 64-bit but in an earlier email (3:24 pm) you posted some paths that are 
>> using the Program Files folder (x86) folder:
>>  
>> > Anyone have any warnings with regard to using a duplicate of the 4D 
>> > version folder? For example...
>> > 
>> > C:\Program Files (x86)\4D\4Dv16.0 
>> > C:\Program Files (x86)\4D\4Dv16.0  - Copy
>> > put a shortcut of  C:\Program Files (x86)\4D\4D v16.0 - 
>> > Copy\4D\4D.exe on the desktop.
>>  
>> So the paths above make it seem like you are using the 32-bit version of 4D 
>> v16.0 (not the R release, and not 64 bit); which does not have this feature.
>>  
>> -Tim
>>  
>> 
>> 
>> 
>> Timothy Penner
>> Senior Technical Services Engineer
>> Email:   tpen...@4d.com 
>> Web: www.4D.com  
>> 4D Inc
>> 95 S. Market Street, Suite #240
>> San Jose, CA 95113
>> United States
>> Telephone:   +1-408-557-4600
> 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Error on HTTP request on v16B6

[Keisuke Miyako via 4D_Tech]

as discussed in the link given by Koen,
the issue seem to happen on certain machines and with certain sites,
(100% reproducible when it happens).

until we get to the bottom of what is causing the error,
may use an alternative http client?

https://github.com/miyako/4d-plugin-curl-http

> 2018/06/21 18:00、David Samson via 4D_Tech <4d_tech@lists.4d.com> のメール：
>
> SSL internal error : error:14141152:SSL
> routines:SSL_SCAN_SERVERHELLO_TLSEXT:unsafe legacy renegotiation disabled




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Error on HTTP request on v16B6

[Koen Van Hooreweghe via 4D_Tech]

Hi David,

If you have access to the 4D forums, check out: 
http://forums.4d.com/Post//24265962/1/

You could change the TLS minimum version just before your http request call:  
SET DATABASE PARAMETER(Min TLS version;TLSv1_1)
Its worth a try, but for me it did not work.

There seems to be a bug in 4D v16R6 (and v17), which makes certain https sites 
(like https://www.google.com) unreachable from within 4D and only happens in 
certain situations. But I don't have details.

I've been hit by this issue a few weeks ago. I recently did a new test and 
suddenly all was working fine again. No changes in my network config. ISP?.

My findings are:
- macOS (two different versions 10.11.x and 10.13.x) on two different machines 
(iMac MacBook Air) in the same network
- 4D v 16R6 and v17ß
- rebooting machine did not help
- curl from terminal was OK
- 4D Windows in Parallels on the iMac was also working fine
- MacBook in different network was working fine again
- iMac connected through iPhone G4 hotspot was working fine too

4D Tech assistance confirmed the issue was reproduced by QA and is under study 
by Engineering.
Lets hope they find a quick fix.

HTH
Koen

> Op 21 jun. 2018, om 11:00 heeft David Samson via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> This is an urgent issue since it is holding up card payments.
> 
> We are getting the error below on executing HTTP request to a payment
> gateway. They assure me they are on TLS1.2.
> 
> This was after un upgrade from 4D v16.3 to v16R6 all Windows and 64bit
> server.
> 
> Error when executing the method "SagePay_PaymentRequest" at line number 131
> 
> Error #30
> 




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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Error on HTTP request on v16B6

[David Samson via 4D_Tech]

This is an urgent issue since it is holding up card payments.


We are getting the error below on executing HTTP request to a payment
gateway. They assure me they are on TLS1.2.



This was after un upgrade from 4D v16.3 to v16R6 all Windows and 64bit
server.



Error when executing the method "SagePay_PaymentRequest" at line number 131



Error #30



Error code: 30 (4DRT)

Error #30

component: '4DRT'

task -7, name: 'Process_ContractList'



Error code: 5 (xbox)

Access denied {path}

xtoolbox

task -7, name: 'Process_ContractList'



Error code: 49 (srvr)

SSL internal error : error:14141152:SSL
routines:SSL_SCAN_SERVERHELLO_TLSEXT:unsafe legacy renegotiation disabled

component: 'srvr'

task -7, name: 'Process_ContractList'



Error code: 49 (srvr)

SSL internal error : error:140920E3:SSL
routines:ssl3_get_server_hello:parse tlsext

component: 'srvr'

task -7, name: 'Process_ContractList'


Any suggestions?


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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Uppercase Lowercase

[stardata.info via 4D_Tech]

Other good suggestion..

Thanks
Ferdinando

Message: 2
Date: Wed, 20 Jun 2018 15:19:22 -0400
From: Jeffrey Kain
To: 4D iNug Technical<4d_tech@lists.4d.com>
Subject: Re: Uppercase Lowercase
Message-ID:
Content-Type: text/plain;   charset=utf-8

How about

C_BOOLEAN($0)
C_TEXT($1;$2)
$0:=(Replace string ($1; $2; *) = “”)

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Any way to detect change to 4D Write Pro orientation.

[JOHN BAUGHMAN via 4D_Tech]

Hi Piotr,

I highly recommend the 4D Write-Like toolbar…

http://download.4d.com/4DBlog/Tips/4DWriteLikeToolbarDemo.zip

It has nearly everything needed including zoom and view mode that you 
mentioned. If for nothing else it’s  great to use as an example of how to 
manage most of the 4D Write Pro attributes. I have adopted it for all my 4D 
Write Pro areas with only a couple of additions. I added “4D Expressions” to 
the Insert menu and added the orientation icons I mentioned earlier. Both were 
very easy to add using the tool bar's example.


John

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

> On Jun 20, 2018, at 9:45 PM, Piotr Chabot Stadhouders via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi John,
> 
> I am on your side with this.
> Especially the need to use INVOKE ACTION to set specific attributes is 
> something I don't understand.
> 
> Our users want to be able to set some defaults for the Write Pro area, for 
> example the default zoom % and the default view mode
> Now I have to use for example INVOKE 
> ACTION("pageMode?value=draft";WP_WriteProArea) and INVOKE 
> ACTION("zoom?value=150%";WP_WriteProArea) to accomplish this.
> Even further, the Write Pro area needs to have the focus or else the invoke 
> action command doesn't work
> 
> I know there are some workarounds / hacks for this, but I don't like it.
> 
> Gr,
> 
> Piotr
> 
> 
>> On Jun 10, 2018, at 10:18 AM, JOHN BAUGHMAN wrote:
>> 
>> 2. Have 2 icons in my tool bar, like in the print dialog, for Portrait and 
>> Landscape and be able to use them as one can from the contextual menu.
>> 
> 
> There is a way to do set ordination programmatically...
> 
> INVOKE ACTION("pageOrientation?value=landscape";WP_WriteProArea)
> 
> Does anyone else find finding how to do something in 4D Write Pro a painful 
> proposition. Everything is spread out...
> 
> WP commands
> ST Commands
> OB Commands
> Standard Actions/4D Write Pro Standard Actions/Invoke Action
> etc., etc...
> 
> I would love a single place to go where I can find what is needed without 
> having to guess what section of the LRM to go to?
> 
> John
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Write Pro: programmatically manipulate text expertise needed

[Justin Carr via 4D_Tech]

On 21 Jun 2018, at 4:49 pm, Piotr Chabot Stadhouders via 4D_Tech 
<4d_tech@lists.4d.com> wrote:
> 
> Hi Justin, Pat,
> 
> Using WP SELECT that is called in a method via CALL FORM seems to work, 
> thanks for that!
> 
> I must say, I can't believe it's 4D's intention that we constantly have to 
> use CALL FORM for thinks to work.
> Maybe they implement a more sophisticated way for doing this.

I have to say it's annoying. What's even more annoying is that most of the time 
CALL FORM isn't enough. You have to use SET TIMER(-1) and set some info 
somewhere to let the timer know what to do when it triggers. I don't find it 
anwhere near as simple or intuitive as working with 4D Write was. I live in 
hope that things will become easier to manage as the product improves. 
Certainly there are steps forward with each new release.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Re: Any way to detect change to 4D Write Pro orientation.

[Piotr Chabot Stadhouders via 4D_Tech]

Hi John,

I am on your side with this.
Especially the need to use INVOKE ACTION to set specific attributes is 
something I don't understand.

Our users want to be able to set some defaults for the Write Pro area, for 
example the default zoom % and the default view mode
Now I have to use for example INVOKE 
ACTION("pageMode?value=draft";WP_WriteProArea) and INVOKE 
ACTION("zoom?value=150%";WP_WriteProArea) to accomplish this.
Even further, the Write Pro area needs to have the focus or else the invoke 
action command doesn't work

I know there are some workarounds / hacks for this, but I don't like it.

Gr,

Piotr


> On Jun 10, 2018, at 10:18 AM, JOHN BAUGHMAN wrote:
>
> 2. Have 2 icons in my tool bar, like in the print dialog, for Portrait and 
> Landscape and be able to use them as one can from the contextual menu.
>

There is a way to do set ordination programmatically...

INVOKE ACTION("pageOrientation?value=landscape";WP_WriteProArea)

Does anyone else find finding how to do something in 4D Write Pro a painful 
proposition. Everything is spread out...

WP commands
ST Commands
OB Commands
Standard Actions/4D Write Pro Standard Actions/Invoke Action
etc., etc...

I would love a single place to go where I can find what is needed without 
having to guess what section of the LRM to go to?

John
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Write Pro: programmatically manipulate text expertise needed

[Piotr Chabot Stadhouders via 4D_Tech]

Hi Justin, Pat,

Using WP SELECT that is called in a method via CALL FORM seems to work, thanks 
for that!

I must say, I can't believe it's 4D's intention that we constantly have to use 
CALL FORM for thinks to work.
Maybe they implement a more sophisticated way for doing this.

Thanks again,

Piotr

> -Oorspronkelijk bericht-
> Van: Justin Carr 
> Verzonden: maandag 18 juni 2018 5:00
> Aan: 4D iNug Technical <4d_tech@lists.4d.com>
> Onderwerp: Re: Write Pro: programmatically manipulate text expertise needed
> 
> On 15 Jun 2018, at 10:01 pm, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> > Hi Piotr,
> > I think you can use WP SELECT to do this - WP SELECT ( {* ;} wpArea {;
> > targetObj} | {; startRange ; endRange} )
> >
> > Let me know if you can't get that to work and I'll take a closer look at it.
> >
> > HTH
> >
> > Pat
> >
> > On Wed, 13 Jun 2018 at 07:35, Piotr Chabot Stadhouders via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> >> Hi Pat,
> >>
> >> Your tips seem to work, but I am hoping you also know the answer to
> >> the next problem.
> >> See example 1 : After replacing the text with ST SET
> >> TEXT($wp_obj;$text;$start_pos;$end_pos) the cursor must be set after
> >> the last inserted character. This replacing is done in the On After
> >> Keystroke event of the Write Pro area and is triggered when the user types 
> >> a
> space.
> >> However, I don't succeed in setting the cursor at the end of the
> >> inserted text, it stays at the position where it was (position after
> >> the original
> >> space)
> >>
> >> Do you also have a tip how to set the cursor to a different position
> >> in the "On After Keystroke" event of the Pro Area?
> 
> WP SELECT is the way to go but, like many things in 4D Write Pro, you need to
> do it in a separate execution cycle (from the ST SET TEXT).
> 
> CALL FORM will work in this instance (it doesn't work in most of the instances
> where 4D Write Pro needs to complete the current execution cycle before any
> new changes can be applied).
> 
> So, have a separate method to which you pass your 4D Write Pro object and
> your $endpos and run the WP SELECT from there. Call the method after your ST
> SET TEXT using CALL FORM.
> 
> J
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**