Re: Quickbooks 2014/4D 2014/QB SDK 13.0

2017-09-07 Thread John Baughman via 4D_Tech
Doug, I would say that the SDK is only a windows option. I could be wrong, but I do not believe that there is a Mac OS option for talking with QuickBooks for Mac desktop. Using a VM is absolutely doable. I did all of my development work on a mac using Oracle VirtualBox. I do

Re: 4D dot releases versus R releases - a metaphor

2017-09-07 Thread Lee Hinde via 4D_Tech
Not to drill too deeply, but no new features != no new changes. 16.2 for instance updates the Xerces engine, which apparently changed the case sensitivity of existing XML commands. And I think the company line is that R releases (the non-beta ones) are customer ready. But generally, yes, the

Re: 4D dot releases versus R releases - a metaphor

2017-09-07 Thread David Adams via 4D_Tech
This new keyboard is just killing me. Anyway, ignore the incomplete version of this method. I was reminded yesterday that it's pretty easy not to understand the difference between dot releases and R releases. I guess it's the numbering? I do understand it now (it took a few years), but it's still

4D dot releases versus R releases - a metaphor

2017-09-07 Thread David Adams via 4D_Tech
I was reminded yesterday that it's pretty easy not to understand the difference between dot releases and R releases. I guess it's the numbering? I do understand it now (it took a few years), but it's still hard to explain. I though of a new way so I'm tossing out two explanation.s 16.016.1 16.2

Re: macros documentation

2017-09-07 Thread David Adams via 4D_Tech
I fell in love with macros lately when I saw one in action that showed some custom UI. Awesome! I now have macros where you can do stuff like this: -- Take the highlight text (some Postgres SQL in a disabled Begin/End SQL statement.) -- Bring up a dialog with a bunch of bits you can adjust --

Re: Quickbooks 2014/4D 2014/QB SDK 13.0

2017-09-07 Thread Douglas von Roeder via 4D_Tech
John: Just getting back to this… Got a hitch in the git along - all the computers running 4D are on OS X. Their accountant is using a Mac for most of her work but she has a Windows laptop for QB. From a recent conversation, they're open to moving her to a MacBook + Parallels for QB. Since

RE: 4D Server 15.3 crashes a server when choosing a datafile

2017-09-07 Thread Vance Villanueva via 4D_Tech
Hi Paul, Have you updated any components and/or plugins since that update? Regards, Vance Villanueva -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Paul Lovejoy via 4D_Tech Sent: Tuesday, September 05, 2017 10:16 PM To: 4D iNug Technical Cc:

Re: Convert 4D data MSSQL

2017-09-07 Thread Charles Miller via 4D_Tech
One more thing. If you can create a true stored procedure in MS sql server. and execute by passing in that would be faster ads well Try this link https://technet.microsoft.com/en-us/library/ It will show you transact sql server commands etc On Thu, Sep 7, 2017 at 5:21 PM, Justin Will via

RE: Convert 4D data MSSQL

2017-09-07 Thread Justin Will via 4D_Tech
Thanks Chuck, I'll give that a try. Perhaps batches of 25k records as arrays will work and speed things up. > You might try to use arrays to update and not individual records Justin ** 4D Internet Users Group (4D iNUG) FAQ:

Re: macros documentation

2017-09-07 Thread Keisuke Miyako via 4D_Tech
Hello, on_load has been available since v11. perhaps your folder is not named "Macros v2" some macro examples: https://github.com/miyako?utf8=✓=repositories=macro (but I am not sure if any uses on_load in particular) 2017/09/08 1:48、Charles Miller via 4D_Tech

Re: [OFF] PCI/DSS compliance

2017-09-07 Thread Keith Culotta via 4D_Tech
Kirk, I can't say that I understand the nuances of the system to the point of having any details to contribute, but after lots of trying to figure it out the thing that finally allowed us to pass the scan was to use a VPN. We open only the VPN ports and the ports required by the credit card

Re: [ANN] 4D v16.2 ready for download

2017-09-07 Thread Brian Young via 4D_Tech
Hello Piotr, I’m sorry it has taken me so long to respond. I don’t have any knowledge about this specific bug. The process of letting 4D Engineering know about this depends on if you are a 4D Partner or not. Partners may submit it through their Tech Support engineers (or TOAW if used in

[OFF] PCI/DSS compliance

2017-09-07 Thread Kirk Brooks via 4D_Tech
If anyone has experience with successfully completing a PCI/DSS audit and certification for your network, not just the 4D part, I would really appreciate talking with you. Ping me off line. Thanks -- Kirk Brooks San Francisco, CA === *The only thing necessary for the

[ANN] 4D Summit 2018 • Call for Speakers

2017-09-07 Thread Brian Young via 4D_Tech
Now is your opportunity to share your expertise and knowledge with the 4D community. Speaker submissions for the 2018 4D Summit in Washington D.C. are being accepted through November 30th. Presentations should be about 45 minutes long, leaving time for 10 minutes of questions. A 4D team member

Re: macros documentation

2017-09-07 Thread Charles Miller via 4D_Tech
OK I found it I have added the following macro The method below exists ut_OpenMethod ("") Is the on_load not available in v15. If so is there any way to identify Thanks and regards Chuck On Thu, Sep 7, 2017 at 11:43 AM, Olivier Deschanels via 4D_Tech < 4d_tech@lists.4d.com> wrote: >

Re: Convert 4D data MSSQL

2017-09-07 Thread Arnaud de Montard via 4D_Tech
> Le 7 sept. 2017 à 17:42, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I think this is what SQL EXPORT DATABASE and SQL EXPORT SELECTION do. You > might have some issues with date/time fields as well as object fields. Unfortunately these commands have been written in a

RE: Convert 4D data MSSQL

2017-09-07 Thread Justin Will via 4D_Tech
Jeffrey, Thank you, I was not aware of SQL EXPORT DATABASE. I might be able to make it work by dumping to an intermediate SQL database and then converting the data to the slightly modified schema from there. Thanks Justin **

Re: Convert 4D data MSSQL

2017-09-07 Thread Randy Jaynes via 4D_Tech
Sure looks like it! I wasn’t even aware of this command in 4D, but it calls it a ‘dump’, so that’s the kind of text file I would expect this to create. Randy -- Randy Jaynes Senior Programmer and Customer Support

Re: macros documentation

2017-09-07 Thread Olivier Deschanels via 4D_Tech
Hello, Here is the documentation : http://doc.4d.com/4Dv16R3/4D/16-R3/Creating-and-using-macros.300-3230741.en.html Regards, Olivier > Le 7 sept. 2017 à 17:40, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Hi All I have looked on 4d and perhaps I am blind, but I am

Re: Convert 4D data MSSQL

2017-09-07 Thread Jeffrey Kain via 4D_Tech
I think this is what SQL EXPORT DATABASE and SQL EXPORT SELECTION do. You might have some issues with date/time fields as well as object fields. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 7, 2017, at 11:40 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Maybe you can

macros documentation

2017-09-07 Thread Charles Miller via 4D_Tech
Hi All I have looked on 4d and perhaps I am blind, but I am looking for documentation on Macros. Where might I find it Regards Chuck -- - Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed

Re: Convert 4D data MSSQL

2017-09-07 Thread Randy Jaynes via 4D_Tech
Maybe you can write 4D code to create blocks of insert statements in a text file like LOCK TABLES `CatalogPricing` WRITE; INSERT INTO `CatalogPricing` (`catPriceID`, `catPriceCatalogID`, `catPriceQty`, `catPriceAmount`, `catPriceStatus`) VALUES (2,2,1,15.00,'1'),

Re: Convert 4D data MSSQL

2017-09-07 Thread Chuck Miller via 4D_Tech
You might try to use arrays to update and not individual records Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Convert 4D data MSSQL

2017-09-07 Thread Justin Will via 4D_Tech
Does anyone have any advice on converting a 4D Database to MSSQL. The database is quite large at 75+gb of data and doing the conversion with an SQL Login and looping the 4D records using Inserts into MSSQL is taking quite literally days to convert. Any ideas are welcome. Thanks Justin Will