Running v16.6 built application as a service on Windows SBS 2011

[Mike Beatty via 4D_Tech]

All-

Running into an issue trying to get a v16.6 built application to run as a 
service, wondering if anyone has this in place before we ramp up the 
troubleshooting.

A few notes — this is on a client remote server, which is administered  by a 
third party that will not allow us to have administrative access. The machine 
does have a 2003 app running as a service. We can run the application outside 
of services without an issue. We have switched between running as the local 
account to use interactive desktop, but when we try to view the message, we get 
kicked out of machine — the third party group loses connection for roughly 60 
seconds, then reports seeing both a power shell window and a command prompt. 
When running as an administrator account, as is the 2003 version, the service 
will start, then inexplicably stop. Windows logs don’t shed much light on the 
issue.

We are going to start trying other means to find cause/resolution, just wanted 
to see if anyone is running this config successfully.

Thanks!

Mike

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

Re: Data Merge from v13 to v15

[Mike Beatty via 4D_Tech]

Ronnie-

I often work with datafiles in size greater than 100GB, so please take that 
into consideration of your needs — small datafiles might not need as extensive 
an effort.

Based on my experience, I would highly recommend you use the sql export/sql 
import routines — they are the most efficient, assuming there is no level of 
data manipulation.

In the event there is any need for data manipulation (change in field 
order/data types, update UUIDs, etc.), then your best bet will be to create a 
generic series of routines that will allow you to monitor the export and import 
routines on a table level basis.


HTH, 

Mike

Mike Beatty
Objective Systems




> 
> A client has requested to decommissiona v13 database and merge the 
> data into a separate v15 database.
> The 2 database structures started the same (as in same tables and fields) but 
> has expanded in different directions down the years.
> It would be fair to say that the fields in the v13 structure would be a 
> subset of the v15 structure.
> 
> A send/receive record option would not be feasible.
> Tinkling with some ideas, perhaps exporting table data to CSV file (from v13) 
> and import into v15.   
> Or perhaps just exporting individual tables (individual) fields to text files 
> with custom delimiters….
> 
> What would be the best way to accomplish this? 

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

4D Authentication with SharePoint Online -- FedAuth cookie

[Mike Beatty via 4D_Tech]

All-

Trying to connect 4D to a Sharepoint Online repository. I can get there, but 
part of the process is to capture a “BinarySecurityToken”, then use that to 
populate a second request to capture the “FedAuth” cookie. The problem we are 
running into is that although the connection seems successful, and no error 
code is received, the data received does not contain a “FedAuth” cookie. 
Perhaps there’s a “verbose” http header option?

Has anyone been able to connect to Sharepoint Online successfully, and perform 
activities such as directory scans? Has anyone any experience w/the FedAuth 
cookie, that might be able to point us in the right direction?

Does Miyako have a “Bat Signal”?

Any advice appreciated! 

Thanks!

Mike

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

Re: Securing sensitive data in a 4D data file (Chip Scheide)

[Mike Beatty via 4D_Tech]

Chip-

Any chance you are going to World Tour? You might see something of interest ;-).

Mike

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

Re: Anyone using OBS Project?

[Mike Beatty via 4D_Tech]

Yes, I have taken a look at that, was hoping to build on the existing
framework rather than bringing in another piece of software to learn and
support ;-). However, that may be the route to take.

Thank you Tim -- I appreciate your efforts.

Mike

On Wed, Feb 14, 2018 at 3:40 PM, Timothy Penner  wrote:

> Mike,
>
> Maybe checkout OBSRemote.com - they seem to have a websock implementation
> to control OBS.
> Maybe you can hook into that from 4D's HTTP commands (or low level TCP
> commands)?
>
> -Tim
>
>
>
>
> Timothy Penner
> Senior Technical Services Engineer
>
> 4D Inc
> 95 S. Market Street, Suite #240
> CA 95113 San Jose
> United States
>
> Telephone : +1-408-557-4600
> Standard :  +1-408-557-4600
> Fax :   +1-408-271-5080
> Email : tpen...@4d.com
> Web :   www.4D.com
>
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy
> Penner via 4D_Tech
> Sent: Wednesday, February 14, 2018 12:26 PM
> To: Mike Beatty 
> Cc: Timothy Penner ; 4D iNug Technical <
> 4d_tech@lists.4d.com>
> Subject: RE: Anyone using OBS Project?
>
> I thought OBS was used more for livestreaming, rather than for recording
> videos…
>
> I have never tried to control OBS from the CLI - maybe someone in their
> community has?
>
> I think there is a large community for OBS on Reddit -
> https://www.reddit.com/r/obs/  <-- more updated
> https://www.reddit.com/r/OBSproject/ <-- less updated
>
> Lot’s of live streamers on Twitch use OBS and Twitch also has a subreddit.
> https://www.reddit.com/r/Twitch/
>
> I hope that helps!
>
> -Tim
>
>
>
>
>
> From: Mike Beatty [mailto:mikebeatty.li...@gmail.com]
> Sent: Wednesday, February 14, 2018 12:18 PM
> To: Timothy Penner 
> Cc: 4D iNug Technical <4d_tech@lists.4d.com>
> Subject: Re: Anyone using OBS Project?
>
> Tim-
> Ideally, we will interact with OBS control the start and stop of the
> video, capture file name, etc. We have used alternate software in the past,
> controlling via LEP, using the Macintosh command line interface. The issue
> I'm running into is that OBS is open source, and documentation is rather
> spotty. We have found some command line syntax, but not exactly what we
> need. Was hoping someone out there had experience or had even developed a
> plugin.
> Mike
>
> On Wed, Feb 14, 2018 at 3:09 PM, Timothy Penner  tpen...@4d.com>> wrote:
> I have played with OBS a bit - not with 4D though...
>
> How are you planning to use OBS with 4D?
>
> -Tim
>
>
> Timothy Penner
> Senior Technical Services Engineer
>
> 4D Inc
> 95 S. Market Street, Suite #240
> CA 95113 San Jose
> United States
>
> Telephone : +1-408-557-4600
> Standard :  +1-408-557-4600
> Fax :   +1-408-271-5080
> Email : tpen...@4d.com
> Web :   www.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
> **
>
>
**
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: Anyone using OBS Project?

[Mike Beatty via 4D_Tech]

Tim-

Ideally, we will interact with OBS control the start and stop of the video,
capture file name, etc. We have used alternate software in the past,
controlling via LEP, using the Macintosh command line interface. The issue
I'm running into is that OBS is open source, and documentation is rather
spotty. We have found some command line syntax, but not exactly what we
need. Was hoping someone out there had experience or had even developed a
plugin.

Mike

On Wed, Feb 14, 2018 at 3:09 PM, Timothy Penner  wrote:

> I have played with OBS a bit - not with 4D though...
>
> How are you planning to use OBS with 4D?
>
> -Tim
>
>
> Timothy Penner
> Senior Technical Services Engineer
>
> 4D Inc
> 95 S. Market Street, Suite #240
> CA 95113 San Jose
> United States
>
> Telephone : +1-408-557-4600
> Standard :  +1-408-557-4600
> Fax :   +1-408-271-5080
> Email : tpen...@4d.com
> Web :   www.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
**

Anyone using OBS Project?

[Mike Beatty via 4D_Tech]

Hello all-

Involved in a video recording project, wondering if anyone out there has
experience with OBS Project. If so, please shoot me a note.

Thanks!

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

Fwd: v13 - Number of field/array pairs for selection to array

[Mike Beatty via 4D_Tech]

Chip-

I know at one point the limit was 64, not sure when/if it became 256. I
demonstrated this to Thibeaux (sp?) many years ago at a Summit and he was
surprised ;-).

Regardless, to get around that, I recoded to use SQL commands, which allows
you to dynamically run table-to-table.

Here's the code that i used a few years ago to to a mass export. I'm sure
others have similar (or better) examples.


  // Method: pSQLSelectIntoArrays


*C_LONGINT*($vltablenum;$size1;$vlDataLoop2;$fieldnum;$vlCounter;
$vlFieldType;$vhTimeStampBegin;$vhTimeStampEnd;$vlLimit)
*C_POINTER*($array;*$1*)
*C_TEXT*($vtArrayName;$fieldtext;$vtValueText;$vtwhereText;$vtLimitText;
$vtOffsettext;$vtClientGroup;$clienttext;$vtExportType;$vtSelectText)
*C_TIME*($vhTime1;$vhTime2)
*C_LONGINT*($vlOffset;$vlLimit)
*C_TEXT*(*$2*;*$7*;*$8*)
*C_LONGINT*(*$3*;*$4*;*$5*;*$6*)

*pMethodAuditBegin *(*Current method name*)

vpTablePtr:=*$1*
$vtArrayName:=*$2*
$vhTimeStampBegin:=*$3*
$vhTimeStampEnd:=*$4*
$vtClientGroup:=""

$vltablenum:=*Table*(*$1*)
*If *(*Count parameters*>=5)
$vlLimit:=*$5*
$vlOffset:=*$6*
$vtExportType:=*$7*
$vtClientGroup:=*$8*
*Else *

$vlLimit:=10
*End if *

$vlCounter:=*Get last field number*($vltablenum)

$vtValueText:=""

*For *($vlDataLoop2;1;$vlCounter)
*GET FIELD PROPERTIES*($vltablenum;$vlDataLoop2;$vlFieldType)
*Case of *
*: *($vlFieldType=7)  // subtable
  //: ($vlFieldType=11)  // time - treat as a longint
$vtValueText:=$vtValueText+":"+$vtArrayName+*String*($vlDataLoop2)+","
*: *($vlFieldType=30)  // blob
  // INSERT IN ARRAY(atDataArray;$dataloop;1)
$vtValueText:=$vtValueText+":"+$vtArrayName+*String*($vlDataLoop2)+","
*Else *
$vtValueText:=$vtValueText+":"+$vtArrayName+*String*($vlDataLoop2)+","
*End case *
*End for *
$vtValueText:=*Substring*($vtValueText;1;*Length*($vtValueText)-1)

*C_TEXT*($tQueryTxt)
  //$tQueryTxt:="SELECT * FROM "
$vtSelectText:=*fSQLSelectFromClause *($vltablenum)
$tQueryTxt:=$vtSelectText  //$tQueryTxt+Table name($vltablenum)
$vtwhereText:=*fSQLSelectWhereClause *($vltablenum;$clienttext;$
vhTimeStampBegin;$vhTimeStampEnd;$vtExportType;$vtClientGroup)
  //if($clienttext#"")
  //$vtwhereText:=" WHERE "+$clienttext
  //$vtwhereText:=$vtwhereText+" AND time_stamp >
"+String($vhTimeStampBegin)+" AND time_stamp <= "+String($vhTimeStampEnd)
  //else
  //  $vtwhereText:=" WHERE time_stamp > "+String($vhTimeStampBegin)+" AND
time_stamp <= "+String($vhTimeStampEnd)
  //end if
$tQueryTxt:=$tQueryTxt+$vtwhereText
$vtLimitText:=" LIMIT "+*String*($vlLimit)
$tQueryTxt:=$tQueryTxt+$vtLimitText
$vtOffsettext:=" OFFSET "+*String*($vlOffset)
$tQueryTxt:=$tQueryTxt+$vtOffsettext
$tQueryTxt:=$tQueryTxt+" INTO "+$vtValueText+";"

*C_TEXT*($tQueryTxt)
  //$tQueryTxt:="INSERT INTO "+Table name($vltablenum)+" ("+$fieldtext+")
VALUES ("+$vtValueText+");"
$vhTime1:=*Current time*
*Begin SQL*
*EXECUTE* *IMMEDIATE** :*$tQueryTxt*;*
*End SQL*
$vhTime2:=*Current time*
*FLUSH BUFFERS*

*pMethodAuditEnd *(*Current method name*)



Mike


On Jan 29, 2018, at 3:00 PM, 4d_tech-requ...@lists.4d.com wrote:

I seem to remember that there is limit of 256 pairs for this command.

I am building the command in text to be used by Execute Formula, I want
to be sure that I do not exceed the maximum number of pairs allowed.
**
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: 4D v16 issues - speed on VM

[Mike Beatty via 4D_Tech]

> On Sep 22, 2017, at 5:49 PM, 4d_tech-requ...@lists.4d.com wrote:
> 
> I ask because we have been upgrading our customers to V15 R5 and are seeing 
> the opposite, especially on all our VM systems.


I can confirm speed issues with v15 and VM machines — verified on multiple 
servers, with different databases. I had posted an earlier message some time 
ago, but can’t find in reviewing past email.

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