Re: Current User and 4D User on Server Are Different

[Dave Nasralla via 4D_Tech]

Hi Keisuke,

Sorry for the delayed response. I’ll have to come up with a way to check (when 
it happens have the user make a change.)
I didn’t realize the literal user alias name (and not just an ID) is stored in 
the Journal record.
I’ll contact Tony Ringsmith (in case he does see this!) and ask if LogTools 
reads the user alias field.
If it does, I’m less concerned about what shows up in the Admin window 
(assuming the user alias is recorded correctly.)

Thanks for your insights.

dave

> On Jan 25, 2022, at 5:23 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> the current user alias is recorded in the journal.
> 
> https://blog.4d.com/who-did-what-store-user-aliases-in-the-journal/
> 
> 2) What gets recorded in the journal file?
> 
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: 4D <-> Development

[Dave Nasralla via 4D_Tech]

Hi Jody,

Well, I started completely from scratch (regarding frontend
development) about 6 months ago. I'd been avoiding it and finally had
a situation where it was needed.
I don't know if this is the best route, but it's the one I took.

Javascript:
I choose scrimba.com for learning HTML, CSS, and Javascript. It's a
remarkable platform for learning. The lessons are short and you can
pause the lesson and insert your cursor into the code they are
demoing, try stuff, then hit play and the code reverts. They have a
frontend developer's path - I did the first 15-20% and got what I
needed to get my project going. As I started to learn javascript I
thought "This looks a lot like the direction 4D is headed"

Framework:
What I learned about frameworks, is that you need to pick one that is
going to be supported. In scrimba, they picked REACT because they say
it is maintained by Facebook. I did not take the time to learn REACT
because my project was for mobile devices and I got some starter code
from a developer that used jQuery Mobile. Of course, jQuery Mobile
stopped development and maintenance back in Oct, but it's good enough
to get me going. (Hence, pay attention to the framework you learn!)
jQuery itself may have more longevity - I don't know.

Software:
Web Browers have AMAZING developer tools right in the browser. I chose
Chrome. Just hit F12 (mac) and BAM, you have a full debugger. You can
trace your Javascript, set break points, force the cache to always
load from the server (key to testing), see all your variables. Pretty
cool!

Visual Studio Code (mac)
Pretty powerful editor. It has features I wish 4D had like:
 - option-shift-down arrow: will instantly duplicate your line to the line below
 - option-click: you can put multiple cursors on the same document.
You can put 6 cursors in six places and when you type you type (or
delete) in all six places at the same time.
 - support for Emmet. As best I can tell it's a standard set of macros
for development. Remarkably powerful. https://emmet.io/

Communicating with 4D:
I chose JSON. It seems like a format both Javascript and 4D like. They
literally have the same commands for converting objects to JSON and
back.  On the web page I create an object in Javascript with all the
data I am sending to 4D (including signon info, tokens, anything). You
stringify it and send it to 4D with a Post command. I send it via
4DAction. The Object shows up directly in the 4D method and you parse
it to a 4D Object. I rolled my own token system so I can know if the
"user" is authorized for the method.  I essentially created an API for
my app. The nice thing is that it completely separates 4D from the
HTML. The advantage is I don't have to rebuild my 4D application to
update the interface - since the interface is just HTML and Javascript
files. If our web guy needs info, I just create a method for him that
returns what he needs.

The biggest leap for me in making calls from Javascript is that the
calls should be asynchronous (synchronous calls have been deprecated
in general because they mess with the web users experience). This
means that before you make a call to 4D from a web page, you tell
Javascript which function will (if it ever gets a response) run when
the browser gets a reply. You make the call and then the webpage
continues as if nothing happened.

Good luck! I'll be curious which way you decide to go!

dave
-- 
David Nasralla
Clean Air Engineering


On Wed, Oct 20, 2021 at 11:17 AM Jody Bevan via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> I have asked a similar question over on the FORUM, and got two responses. I 
> know more people than two have developed web pages and 4D applications 
> working together.
>
> I really need to get into designing both.
>
> - The advantage I have is that I am starting from scratch with web 
> development and 4D and the web. The 4D database linked over the web that I 
> personally developed with HTML back in the early 90s are way out of date. I 
> want to learn the new way of working, because that will future proof my 
> skills, and the sites/Applications I develop.
>
> - The disadvantage I have is that I am starting from scratch.
>
> OK, having said that what tools do you recommend (and why)? There are so many 
> web development tools, and so many web developers that want to gobble up the 
> Database application behind it all (thus my work) as they ‘can do it all’.
>
> - I have seen talk about Angular, AngularJS, React ( Frameworks - correct).
> - There are new tools in 4D since back in the early 90s obviously.
> - Yes, REST is important, but what does that mean.
>
> A white paper from 4D on 4D v19 and the web and working together would be 
> very nice to have.
>
> The web sites I developed way back then, everything was in 4D. I wrote all 
> the static HTML and stored, and sent it out from 4D. That was then, but from 
> what I understand now things can work better as the WebServer itself can 
> interpret the JavaScript to execute code 

Current User and 4D User on Server Are Different

[Dave Nasralla via 4D_Tech]

Hi all,

I'm running a built application in 4D v18.4 with Mac and Windows
clients on a Mac server.
I have an odd situation. I run a custom users and groups which
switches the current user in the background to match the user that's
login in.

On the 4D Server Administration window on the users tab, I can see a
list of the 4D Users logged in. My problem is I have one user whose 4D
Username listed in the admin window does not match what I get when I
execute an ALERT(Current User) on his client machine. The client
machine is correct, but the 4D server is showing the Administrator
name. They don't match.

The reason I want the current user to be accurate is that I use (on
rare occasions) Tony Ringsmith's LogTools to find out who did a
modification on a record and I want the .journal file to be accurate.

So I have two questions:
1) Why would the 4D Server not match the Current User on the respective client
2) What gets recorded in the journal file?

Thanks!

dave
-- 
David Nasralla
Clean Air Engineering
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Can't surf to my dev environment

[Dave Nasralla via 4D_Tech]

Nevermind.

I restarted my mac and now it works as expected.
That was weird.

dave

On Wed, Nov 10, 2021 at 11:24 AM Dave Nasralla  wrote:
>
> Hey All,
>
> I feel like I am missing something.
> I am running Mac OS Big Sur 11.6.1 on a Macbook Pro
> The web server is turned on for port 2000.
> I can surf to http://localhost:2000 and I get the index page.
> If I try 127.0.0.1 or my IP address I get no connection.
> I am running Little Snitch, but I have the network filter turned off.
> The firewall is also turned off.
>
> What am I missing? This may be the first time I've done this with Big Sur
>
> dave
>
> --
> David Nasralla
> Clean Air Engineering



-- 
David Nasralla
Clean Air Engineering
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Can't surf to my dev environment

[Dave Nasralla via 4D_Tech]

Hey All,

I feel like I am missing something.
I am running Mac OS Big Sur 11.6.1 on a Macbook Pro
The web server is turned on for port 2000.
I can surf to http://localhost:2000 and I get the index page.
If I try 127.0.0.1 or my IP address I get no connection.
I am running Little Snitch, but I have the network filter turned off.
The firewall is also turned off.

What am I missing? This may be the first time I've done this with Big Sur

dave

-- 
David Nasralla
Clean Air Engineering
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: File Excel created from 4D

[Dave Nasralla via 4D_Tech]

We also use the Pluggers product and find it works well. Like anything,  there 
is a small learning curve, but he provides examples.

dave

> On Sep 14, 2021, at 9:05 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> We use
> https://www.pluggers.nl/product/xl-plugin/
> 
> Pat
> 
> On Tue, 14 Sept 2021 at 15:32, Koen Van Hooreweghe via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Hi Ferdinando,
>> 
>> It depends of what your needs are.
>> 
>> The very basic is a tab delimited txt file or an csv file which you can
>> open/import in Excel. No formatting.
>> 
>> Second option is to create a text file containing a html formatted table
>> usingtags. Formatting possible using css. Can be easily
>> imported in Excel too.
>> 
>> Third possibility is to use 4D View Pro, which has an export to Excel. 4D
>> native, but license required.> 
>> Or you can choose from one of the plugins which allow to create native
>> Excel files.
>> 
>> HTH,
>> Koen
>> 
>>> Op 14 sep. 2021, om 16:20 heeft stardata.info via 4D_Tech <
>> 4d_tech@lists.4d.com> het volgende geschreven:
>>> 
>>> I need to create an excel file from 4D application.
>>> 
>>> Someone know how i can do?
>> 
>> 
>> 
>> 
>> Compass bv
>> Koen Van Hooreweghe
>> Kloosterstraat 65
>> 9910 Aalter
>> Belgium
>> tel +32 495 511.653
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> New Forum: https://discuss.4D.com
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://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)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

"Search References" Behavior Change

[Dave Nasralla via 4D_Tech]

Hey all,

In the past, I would right-click a method name and select "Search
References" and I would get a list of literal references to that exact
method. Now, when I do that, I get more of a text search of the
database.

For example: If I right click on the method name "Post_Data", I'll get hits for:
 - WS_Post_Data
 - \\ Post_Data is a method for doing
 - UT_Post_Data_Method3

Has anyone else seen this? Is there a way to get the old behaviour back?

Thanks,

dave

-- 
David Nasralla
Clean Air Engineering
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

How do you get a Vertical Splitter's Horizontal 'Move' Resizing Attribute to work?

[Dave Nasralla via 4D_Tech]

Hey All,

Maybe you can't do this, but imagine you have two text boxes side by
side with a vertical splitter between them. When pull the window
wider, I'd like the text box on the left to grow, and the splitter and
text box on the right to move.

(If I have only a vertical on a form with the Horizontal Resizing
option set to Move - it just won't! If I set the Vertical Resizing
option to Move to moves just fine up and down. Side to side seems to
fail)

I've tried on v17.4 and v18.4 on Mac.

dave

-- 
David Nasralla
Clean Air Engineering
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Some Mail Command Broken in v18.4 Internet Commands Plugin

[Dave Nasralla via 4D_Tech]

Hey All,

Just FYI. Several people have run into issues when moving to v18.4.

MSG_MessageSize and MSG_GetBody broke (at least for text emails) as
well as a few other commands.

Reverting to the v18.1 plugin seems to resolve the issue.
Tech support has filed a case.

Take care!

dave
-- 
David Nasralla
Clean Air Engineering
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Straw Poll - Does Get 4D file(Last backup file) fail for anyone?

[Dave Nasralla via 4D_Tech]

This is mostly just curiosity. Most people probably never use this command
A bug report has been filed.

If you are bored - test the command by simply doing a File -> Backup
And then run the command:
Alert(Get 4D file(Last backup file))

If it doesn't work you simply get a path that is completely wrong. For
me, it returns a path that is years old. I am running v17.4 on systems
that have been through many versions of 4D.

Take care!

dave

-- 
David Nasralla
Clean Air Engineering
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Get 4D file(Last backup file) v17.4 returning wrong file path

[Dave Nasralla via 4D_Tech]

Just a followup.
Tech support has filed a bug for the issue. It's a command that not
many people use I'm guessing. I've just started using it to move a 4D
Backup to a BackBlaze folder once a week so it can be backed up on the
weekend to the cloud. During the week, we just backup the daily
journal files.

It turns out 4 out of 5 of my systems fail with this command.
My workaround to get the path is a simple routine to read the XML Backup file.
It seems to work fine in v17. Have not tried in v18.

  // 
  // Method: UT_LastBackupFilePath
  // Method Path: UT_LastBackupFilePath
  // Description
  // Work Around for failed 4D Command "Get 4D File(Last backup file)"
  //
  // Parameters
  // 

C_TEXT($0;$PathToLastBackup_vt)

C_BLOB($BackupFileBlob_vx)
C_TEXT($xml_Struct_Ref;$ElementRef_vt)

DOCUMENT TO BLOB(Get 4D file(Backup configuration file);$BackupFileBlob_vx)

$xml_Struct_Ref:=DOM Parse XML variable($BackupFileBlob_vx)
$ElementRef_vt:=DOM Find XML
element($xml_Struct_Ref;"/Preferences4D/Backup/DataBase/LastBackupPath/Item1")

DOM GET XML ELEMENT VALUE($ElementRef_vt;$PathToLastBackup_vt)

$0:=$PathToLastBackup_vt

I'm kind of interested in a straw poll. I'll post it in another thread.

dave

On Wed, Aug 19, 2020 at 5:47 PM Dave Nasralla  wrote:
>
> It turns out 3 out of 4 of my systems have this issue. The last backup path 
> does show up correctly in the backup.xml file in the Preferences folder, but 
> the command still fails. I’ve opened a case with Tech Support and have them a 
> sample database. We’ll see what they find out.
>
> Thanks for your help.
>
> Dave
>
> On Tue, Aug 18, 2020 at 6:54 PM Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
>>
>> in v18 it is backupHistory.json, I think.
>>
>>
>>
>> https://doc.4d.com/4Dv18R3/4D/18-R3/Configuration-and-trace-files.300-4919427.en.html
>>
>>
>>
>> 2020/08/19 9:21、Dave Nasralla via 4D_Tech 
>> <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:
>>
>> This makes me think something got corrupt. Do you know where the "Last
>>
>> backup file" path information is stored?
>>
>>
>>
>> **
>>
>> 4D Internet Users Group (4D iNUG)
>>
>> New Forum: https://discuss.4D.com
>>
>> Archive:  http://lists.4d.com/archives.html
>>
>> Options: https://lists.4d.com/mailman/options/4d_tech
>>
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>>
>> **
>
> --
> David Nasralla
> Clean Air Engineering



-- 
David Nasralla
Clean Air Engineering
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Get 4D file(Last backup file) v17.4 returning wrong file path

[Dave Nasralla via 4D_Tech]

It turns out 3 out of 4 of my systems have this issue. The last backup path
does show up correctly in the backup.xml file in the Preferences folder,
but the command still fails. I’ve opened a case with Tech Support and have
them a sample database. We’ll see what they find out.

Thanks for your help.

Dave

On Tue, Aug 18, 2020 at 6:54 PM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> in v18 it is backupHistory.json, I think.
>
>
>
>
> https://doc.4d.com/4Dv18R3/4D/18-R3/Configuration-and-trace-files.300-4919427.en.html
>
>
>
> 2020/08/19 9:21、Dave Nasralla via 4D_Tech <4d_tech@lists.4d.com 4d_tech@lists.4d.com>>のメール:
>
> This makes me think something got corrupt. Do you know where the "Last
>
> backup file" path information is stored?
>
>
>
> **
>
> 4D Internet Users Group (4D iNUG)
>
> New Forum: https://discuss.4D.com
>
> Archive:  http://lists.4d.com/archives.html
>
> Options: https://lists.4d.com/mailman/options/4d_tech
>
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>
> **

-- 
David Nasralla
Clean Air Engineering
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Get 4D file(Last backup file) v17.4 returning wrong file path

[Dave Nasralla via 4D_Tech]

Thanks for the advice, Keisuke.

The command seems to work in a blank database (just running it in a
test method after doing a backup), but does not work in my main system
in a test method.
This makes me think something got corrupt. Do you know where the "Last
backup file" path information is stored?

dave

On Tue, Aug 18, 2020 at 5:09 PM Keisuke Miyako via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> sidebar
>
> technically you should move your fresh 4BK file after On Backup Shutdown, not 
> during,
> because 4D updates the backup history json file following the database event,
> and a  missing backup file will trigger a runtime error.
> one way to avoid this is to start a new process and wait a little before 
> moving the backup.
>
> I can't answer your question about Get 4D file + Last backup file
> other than to assume that the information is only updated after On Backup 
> Shutdown.
>
> https://doc.4d.com/4Dv18R4/4D/18-R4/Get-4D-file.301-4982837.en.html
>
> 2020/08/19 5:44、Dave Nasralla via 4D_Tech 
> <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:
> In my "On Backup Shutdown" method I wanted to copy the backup file to
> another disk.
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
David Nasralla
Clean Air Engineering
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Get 4D file(Last backup file) v17.4 returning wrong file path

[Dave Nasralla via 4D_Tech]

Hi,

In my "On Backup Shutdown" method I wanted to copy the backup file to
another disk.
When I call "Get 4D file(Last backup file)" I get a file path to a
very old backup. I get the same old path every time I do a backup.

Am I missing something?

Thanks,

dave

-- 
David Nasralla
Clean Air Engineering
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Here's a great Mac App for testing and consuming REST services

[Dave Nasralla via 4D_Tech]

Hey all,

Just a quick plug for the Mac app JSON Editor by Vlad Badea (available
on the App store.) I'm writing a backend REST server so a third party
can pull data from our system. It's been a huge help to test the REST
Server.

I've also had to integrate one of your system with Bamboo (HR
Software), and it's great at consuming REST services. At first
glance it looks like it just edits JSON files (which it does), but you
can select File-> New HTTP Request where you can construct a GET or
PUT request, etc.

When you get back JSON you can see the text - or beautify it - or see
it as a hierarchical list. Anywho - it's been the missing link for my
development. It's a great $4.99 to spend. (BTW - I have no connection
with the developer.)

dave

--
David Nasralla
Clean Air Engineering
**
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: Transferring Build Mac Client via Google Drive Web Interface Fails

[Dave Nasralla via 4D_Tech]

Thanks Jeremy,

I like your idea of integrating into your build code. I saw an old
tech note on that, but it seems out of date.

I am currently using an Applescript for code signing:
set theDocument to choose file with prompt "Select the 4D Client application:"
set filepath to POSIX path of theDocument
do shell script "xattr -cr \"" & filepath & "\""
do shell script "codesign --deep --force --verbose --sign
\"DEVELOPERID\"  \"" & filepath & "\""

Where DEVELOPERID is the alphanumeric key between the () in the
certificate name you get from apple.

Is there an easy way to get the file path to the built client and
server apps for the command line?

dave
On Tue, Nov 20, 2018 at 5:39 AM Jeremy Roussak via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Dave,
>
> FWIW, I found information on signing hard to unearth and harder to 
> understand. Eventually, I managed to sign my compiled application using these 
> commands at the end of my build method:
>
> LAUNCH EXTERNAL PROCESS("xattr -cr "+$appPath)
> LAUNCH EXTERNAL PROCESS("codesign --deep --force --verify --verbose --sign 
> \”xx\" "+$appPath)
>
>
> Extended attributes must be removed before signing, it seems, hence the first 
> line. I don’t know whether all the flags to codesign are necessary; I do know 
> that it works, and frankly that’s good enough for my purposes at the moment.
>
> Jeremy
>
>
> > On 19 Nov 2018, at 19:36, Dave Nasralla via 4D_Tech <4d_tech@lists.4d.com> 
> > wrote:
> >
> > Thanks Keisuke. Is there information on signing a built app?
> >
> > We did find the command
> > xattr -d com.apple.quarantine filepath
> >
> > but if signing the app will work, I'd like to do that.
> >
> > dave
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: Transferring Build Mac Client via Google Drive Web Interface Fails

[Dave Nasralla via 4D_Tech]

Here is a followup for what I did.
I created and Applescript to remove the quarantine attribute from the
downloaded client:

set theDocument to choose file with prompt "Select the 4D Client application:"
set filepath to POSIX path of theDocument
do shell script "xattr -d com.apple.quarantine \"" & filepath & "\""

I saved it as an Application to make it easy to run the fix. It will
open a dialog and you simply select the 4D Client app.

I did end up signing my 4D Client apps - but that would be another
thread. To sign a 4D Client app you need to pay the $99/year to apple
to get a Developer ID.

Take care,

dave
**
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: Transferring Build Mac Client via Google Drive Web Interface Fails

[Dave Nasralla via 4D_Tech]

Thanks Keisuke. Is there information on signing a built app?

We did find the command
xattr -d com.apple.quarantine filepath

but if signing the app will work, I'd like to do that.

dave
On Mon, Nov 19, 2018 at 11:57 AM Keisuke Miyako via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> the information about where a file was downloaded from, is stored in extended 
> file attributes. it had nothing to do with code signature or md5 checksum. if 
> necessary, you can clear it with cli
>
> xattr -rc
>
> you can sign a built app from the cli or from 4D, but in addition to that, 
> you need to sign the dmg or pkg if you want to distribute it over the network 
> and pass gatekeeper. it is not possible to sign a zip.
>
>
>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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
**

Transferring Build Mac Client via Google Drive Web Interface Fails

[Dave Nasralla via 4D_Tech]

Hey All,

For a long time we would distribute our built mac clients via google
drive using the google drive web interface. We simply zip the built
client and upload. Since the auto-update feature works quite well we
haven't used it recently.

Until today:
 - I have a working built client
 - I zip the client and upload to google drive
 - If I download the zip file (via a browser) and expand to get the
client, the client will crash when I try to open it. The system log
shows an error related to signatures.
 - Here's the kicker: If I use the google drive app, so that google
drive shows up as a local drive, I can download the .zip file, expand
it and it runs fine.

BTW - all the MD5 checksums are the same for the uploaded and
downloaded .zip files.

As best I can tell, the Mac knows where the files are coming from and
is not happy with those from "the internet".  Is there a way to get a
developer signature on the built clients?

I am running 17.0 HF3 and I am seeing this with Mac OS 10.13.6 and OS 10.12.5.

Anyone else running into this?

Thanks,

dave

-- 
David Nasralla
Clean Air Engineering
**
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: Mac Mojave and v17?

[Dave Nasralla via 4D_Tech]

Thanks for the feedback Randy and Jeff.

I sounds like there are some interface issues to be resolved. This
will be the server, and most all the clients will still be on 10.13. I
was surprise 4D was not certified for 10.14. It must take some time.

Dave
On Fri, Nov 9, 2018 at 3:32 PM Randy Jaynes via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> 4D (v17 and all the way back to v13.5) is having some issues with an internal 
> MacOS drawing routine that is causing funkiness in:
> 1) ALP plugin drawing vertical text, the separator lines get a little 
> “squiggle” to them
> 2) ALP drawing checkboxes in a boolean column
> 3) SOME, not all, pictures displayed in the Toolbox Resources/Images 
> viewer don’t get drawn properly in the toolbox or on forms
>
> I’ve already submitted a bug with 4D tech support related to this.
>
> The 2 ALP issues are something tied to an internal plugin call, so it’s out 
> of their hands…they have to wait for 4D to fix it.
>
> This drawing issue appeared in the later versions of Mojave beta, about 2 
> weeks before the official release.
>
> It’s definitely something changed in MacOS that 4D has been using internally 
> for many years.
>
> Randy
>
> --
> Randy Jaynes
> Senior Programmer and Customer Support
>
> http://printpoint.com <http://printpoint.com/> • 845.687.3741 • PrintPoint, 
> Inc • 57 Ludlow Lane • Palisades, NY 10964
> Please send all email contacts to supp...@printpoint.com 
> <mailto:supp...@printpoint.com>
>
>
>
>
>
> > On Nov 9, 2018, at 3:24 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com 
> > <mailto:4d_tech@lists.4d.com>> wrote:
> >
> > Nothing too serious in my experience. There's some odd flickering when you 
> > resize windows, but I haven't had any functionality issues.
> >
> >> On Nov 9, 2018, at 3:18 PM, Dave Nasralla via 4D_Tech 
> >> <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> wrote:
> >>
> >> Anyone have any experience with this? I just picked up one of the new
> >> 6 core Mac Minis with 32GB of RAM. Just wondering if anyone is aware
> >> of any gotcha's or issues. I'll be running 64bit v17 apps and one v17
> >> 32bit app.
>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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
**

Mac Mojave and v17?

[Dave Nasralla via 4D_Tech]

Hi,

Anyone have any experience with this? I just picked up one of the new
6 core Mac Minis with 32GB of RAM. Just wondering if anyone is aware
of any gotcha's or issues. I'll be running 64bit v17 apps and one v17
32bit app.

dave

-- 
David Nasralla
Clean Air Engineering
**
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: Isolating the Cause of a Server Crash

[Dave Nasralla via 4D_Tech]

Hi JPR,

Thanks for your comments.

- On each crash report, it is a different thread. Twice it was similar
to what I'll post at the end of this message (ServerNet select I/O
handler).
Once it was the LabProjects List, but there is nothing unique about
that list of records.
 - Range checking is on (the application always runs compiled)
 - It could be related to network stress - typically is does happen at
busier hours (never after hours)
 - I do generate debug files. It's not a specific method that is
running. It varies. The last command in the debug file always has a
"." after it. My understanding is that means the command executed
complete.
 - I do use interprocess variables to cache employee data for fast
access to names, email addresses, etc. It is relatively small with 7
parallel arrays containing less that 150 elements each. Also some
system settings - also under 100 elements.
 - The cache is set to 1GB. The datafile is 3GB in size.
- I use the 4D Info Reporter. Tim has walked me through looks at the
results. At first it looked like the Server was running low after a
backup, but I wrote in a purge command that clears it up. At the time
of each crash there is nothing remarkable in the report.

I think you are correct, that it probably is not a client issue -
though I do use routines that have the "execute on server" box
checked. Either way, I uploaded a modification last night that turns
on client debugging and creates a session record in a table at the
start of a client session. If the client record is not closed out via
the "On Exit" method, when the user logs in again the system will
upload their debug files (max of two are created). On the next crash
I'll take a closer look to see what clients were doing.

One thing that bothers me, is on occasion the Administration interface
begins to no longer display information. For example, when I went to
quit the application last night for and update, the window appeared
asking how to quit. I told the system to shutdown in 1 minute. The
next dialog contained only a server icon, and the countdown clock
stuck at "00 00". No text or message as displayed. The server did
shutdown as requested in 1 minute.

Thanks for your questions. Another sample crash report is below.

dave


Thread 29 Crashed:: ServerNet select I/O handler (id = 90423)
0   com.4d.ServerNet  0x000110d5837e
xbox::VTCPSelectWatchAction::HandleError(fd_set*) + 38
1   com.4d.ServerNet  0x000110d589ea
xbox::VTCPSelectIOHandler::DoRun() + 712
2   com.4d.ServerNet  0x000110d58afd non-virtual
thunk to xbox::VTCPSelectIOHandler::DoRun() + 13
3   com.4d.kernel 0x000110bbadaa
xbox::VTask::_Run() + 234
4   com.4d.kernel 0x000110bbfb01
xbox::XMacTask_preemptive::_ThreadProc(void*) + 145
5   libsystem_pthread.dylib   0x7fff6e307661 _pthread_body + 340
6   libsystem_pthread.dylib   0x7fff6e30750d _pthread_start + 377
7   libsystem_pthread.dylib   0x7fff6e306bf9 thread_start + 13

On Tue, Sep 4, 2018 at 10:40 AM JPR via 4D_Tech <4d_tech@lists.4d.com> wrote:
>
> [JPR]
>
> Hi Dave, Tim,
>
> This kind of crash is always difficult to track down, for it is not easily 
> reproductible. From what I see (and as Tim pointed) it seems there is a 
> memory problem that is revelated in the process LabProjects List. But a 
> memory problem can occur a while before the actual crash, because the 
> application may have a corrupted memory and not be aware of it until the 
> crash.
>
> - Is your application compiled? If yes, be sure that the Range checking 
> option is set.
> - Is the LabProjects ListProcess a client process on server, or a worker or 
> process running on the server?
> - The time of crash seems irrelevant, but may be it's linked to a peak in 
> activity and a server or network stress?
> - A client problem causing a server crash is unlikely, but it may help to 
> know if there is a correlation between the crash and a particular client 
> doing a particular operation.
> - Do you know which method is executed when it crashes?
> - Do you use interprocess variables like arrays for instance?
> - How much memory has been given to the server and to the cache?
>
> This is just a short list of points to check, but it may help to reduce the 
> problem to a small part of the application.
>
> My very best,
>
> JPR
>
>
> > On 2 Sep 2018, at 21:00, 4d_tech-requ...@lists.4d.com wrote:
> >
> > From: Tim Nevels 
> > To: 4d_tech@lists.4d.com
> > Subject: Re: Isolating the Cause of a Server Crash
> > Message-ID: 
> > Content-Type: text/plain; charset=utf-8
> >
> > On Sep 1, 2018, at 2:00 PM, Dave Nasralla wrote:
> >
> >> One of our systems is crashing about every 3 days and I can't seem to
> >> isolate the cause. Lately these are crashes with a Mac crash report
> >> appearing on the screen.
> >> Some system details are:
> >> - 4D Built Server app with v17.0 HF1 (64 bit Server with 64 Mac 

Re: Isolating the Cause of a Server Crash

[Dave Nasralla via 4D_Tech]

Thanks to all that have responded.
 - I rebooted the machine this evening. (In the past it has run as
long as a year without a reboot - which was only done for a system
update.)
 - No virus scans running on it
 - Backblaze runs, but the .4DD files are skipped.
 - MCS Scans came  back clean
 - Indexes have been rebuilt

One thing I have noticed is that, although the client machines are
running along fine and users can log in or out and do their tasks, the
4D Administration  Interface on the built application gets wonky. For
example, after running for a day, the "Monitor" tab will no longer
show a graph and the Details area (with the pie charts) is blank with
a message something like (only visible to database administrators). Or
I'll go to the Users tab and nothing shows up, yet users are
connected.

Other 4D applications are fine.

dave

On Fri, Aug 31, 2018 at 3:45 PM Stephen J. Orth via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> I strongly recommend what Chuck is saying.  We tell our customers to exempt 
> our folders from any scanning, virus, auto-bots, etc...
>
> We have seen database damage caused by this, which in turn results in 
> crashing.
>
> Steve
>
>
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chuck Miller 
> via 4D_Tech
> Sent: Friday, August 31, 2018 4:32 PM
> To: 4DTechList Tech <4d_tech@lists.4d.com>
> Cc: Chuck Miller 
> Subject: Re: Isolating the Cause of a Server Crash
>
> Are you running any virus detective on that machine. If so you should skip 4D 
> folders
>
> Regards
>
> Chuck
> 
>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064
>  mailto:cjmillerinformed-solutions.com
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com
> 
> This message and any attached documents contain information which may be 
> confidential, subject to privilege or exempt from disclosure under applicable 
> law.  These materials are intended only for the use of the intended 
> recipient. If you are not the intended recipient of this transmission, you 
> are hereby notified that any distribution, disclosure, printing, copying, 
> storage, modification or the taking of any action in reliance upon this 
> transmission is strictly prohibited.  Delivery of this message to any person 
> other than the intended recipient shall not compromise or waive such 
> confidentiality, privilege or exemption from disclosure as to this 
> communication.
>
> > On Aug 31, 2018, at 5:17 PM, Spencer Hinsdale via 4D_Tech 
> > <4d_tech@lists.4d.com> wrote:
> >
> > reboot the computer. it has been running for 40 days?
>
> **
> 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 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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
**

Isolating the Cause of a Server Crash

[Dave Nasralla via 4D_Tech]

One of our systems is crashing about every 3 days and I can't seem to
isolate the cause. Lately these are crashes with a Mac crash report
appearing on the screen.
Some system details are:
 - 4D Built Server app with v17.0 HF1 (64 bit Server with 64 Mac and
32 bit Windows Clients)
 - Mac and Windows Clients
 - Mac OS 10.13.5

What I know so far:
 - I have the Server Debug file. It ends with a "." and so the last
command appears to have executed.
 - I'm using the Report Info component, logging every 5 minutes. There
doesn't seem to be memory problems or run away cache issues.
 - I also know who was one each time it crashes and said out an email
to those users to find patterns (so far I've found none).
 - The crashes typically happen around 10am to 11am.
 - The client and server builds match.

I'm debating turning on the client debugger files and then harvesting
them afterwards when the user logs back in. I'm open to other
debugging techniques.

There are other v17 systems running on the same machine with zero issue.

Below is a snippet of the crash report. It seems to be different each
time, but here is the latest. Thread 73 crashed, so I only included
that one.

Thanks,

dave nasralla


Process:   Corporate [93958]
Path:  /Users/USER/*/Corporate
Server.app/Contents/MacOS/Corporate
Identifier:4d.com.Corporate Server.app
Version:   17.0 build 17.226566 (???)
Code Type: X86-64 (Native)
Parent Process:??? [1]
Responsible:   Corporate [93958]
User ID:   501

Date/Time: 2018-08-31 11:00:05.952 -0500
OS Version:Mac OS X 10.13.5 (17F77)
Report Version:12
Anonymous UUID:723511FD-4CA0-6E8B-0642-883209248DFC


Time Awake Since Boot: 370 seconds

System Integrity Protection: enabled

Crashed Thread:73  LabProjects List (id = -114)

Exception Type:EXC_BAD_ACCESS (SIGSEGV)
Exception Codes:   EXC_I386_GPFLT
Exception Note:EXC_CORPSE_NOTIFY

Termination Signal:Segmentation fault: 11
Termination Reason:Namespace SIGNAL, Code 0xb
Terminating Process:   exc handler [0]
--


Thread 73 Crashed:: LabProjects List (id = -114)
0   4d.com.Corporate Server.app   0x00010694fdbe
V4DConnection::OnPostpone(bool) + 40
1   4d.com.Corporate Server.app   0x000106b095f7
V4DServerUser::PostponeServiceConnection() + 35
2   4d.com.Corporate Server.app   0x000106b20567
V4DServer::exec_ConnectionPostpone(V4DRequestReply&, V4DTaskConcrete*,
short) + 395
3   4d.com.Corporate Server.app   0x000106b211ca
V4DServer::exec_streamreq(V4DRequestReply&, V4DTaskConcrete*) + 100
4   4d.com.Corporate Server.app   0x000106b1ddc3
V4DServer::execreq(V4DRequestReply&, V4DTaskConcrete*) + 297
5   4d.com.Corporate Server.app   0x000106b1c96f
V4DServer::ReadAndExecuteRequest(V4DTaskConcrete*, void*, void*, int)
+ 349
6   4d.com.Corporate Server.app   0x000106b1da6f
V4DServer::_ClientTask(V4DTaskConcrete*, VTaskParams_gereclient*) +
429
7   4d.com.Corporate Server.app   0x000106b1cc8f
V4DServer::ClientTask(V4DTaskConcrete*, xbox::IRefCountable*) + 81
8   4d.com.Corporate Server.app   0x000106928d93
Task4DProc(V4DTaskConcrete*) + 903
9   4d.com.Corporate Server.app   0x00010696fe00
V4DTaskManager::_Task4DProc(xbox::VTask*) + 158
10  com.4d.kernel 0x000108a34d4d
xbox::VTask::_Run() + 141
11  com.4d.kernel 0x000108a3a0c6
xbox::XMacTask_fiber::_ThreadProc(void*) + 70
12  com.4d.kernel 0x000108a6f0df
xbox::VMacFiber_thread::_ThreadProc(void*) + 31
13  com.apple.CoreServices.CarbonCore0x7fff504c3072
CooperativeThread + 282
14  libsystem_pthread.dylib   0x7fff77464661 _pthread_body + 340
15  libsystem_pthread.dylib   0x7fff7746450d _pthread_start + 377
16  libsystem_pthread.dylib   0x7fff77463bf9 thread_start + 13


-- 
David Nasralla
Clean Air Engineering
**
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: Team Developer - Do all developers need to be on same minor version?

[Dave Nasralla via 4D_Tech]

Thanks, Tim. We use the "Current version:" setting to for all the
clients to update to the same version as the server.

What do you do about components? 4D POP is a good example. Those are
not distributed as source code, but rather compiled .4DC files. As far
as I can tell there are no v17 versions on the 4D website.

dave
On Tue, Aug 28, 2018 at 1:01 PM Timothy Penner via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Keep in mind that 4D QA does not test mixing and matching different versions 
> of client and server - there are way too many permutations... QA only tests 
> the same build of the client with the same build of the server. It is 
> typically the expectation that the version of 4D Client will match 4D Server, 
> although, it is only enforced when there are specific changes to the protocol.
>
> I think the following tech note explains the situation and provides code 
> examples of how you can handle it via 4D code:
>
> Tech Note: Validation of Client Build Version
> http://kb.4d.com/assetid=77112
> PRODUCT: 4D Server | VERSION: 14.0 | PLATFORM: Mac & Win
> Published On: July 24, 2014
> This technical note will provide more insight on the changes between 4D 
> releases and the difference and significance between the versions and build 
> numbers. The code changes between different builds of 4D can cause errors and 
> unexpected behaviors may occur when running mismatched builds between clients 
> and servers. While 4D has a mechanism to prevent connection of mismatching 
> Clients and Server, it isn't strongly enforced for builds of the same 
> version. This Technical Note will also provide a technique and methods to 
> address this problem.
>
>
> -Tim
>
>
>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: Team Developer - Do all developers need to be on same minor version?

[Dave Nasralla via 4D_Tech]

Thanks Jeff. For the Deployment, we use the server machine, so the
clients will always have matching versions (Windows and Mac).
What about the components? Do you recompile each component with each
deploy for minors?
I've noticed 4D often does not complain if the component is even from
a different major version (ie v15 - for example if the component was
purchased as a compiled project where you don't have the source code).

dave
On Tue, Aug 28, 2018 at 12:42 PM Jeffrey Kain via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Nope...
>
> If 4D makes a major change to the protocol they'll block it.  For deployment 
> we try to have matching versions always.
>
> > On Aug 28, 2018, at 2:24 PM, Dave Nasralla via 4D_Tech 
> > <4d_tech@lists.4d.com> wrote:
> >
> > One of our systems is developed with 4D Server (Team Developer) with
> > several coders connecting to make changes. If I move the Server from,
> > say v17.0 to v17.0 HF1 or a nightly build, do all the other developers
> > need to update their versions?
>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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
**

Team Developer - Do all developers need to be on same minor version?

[Dave Nasralla via 4D_Tech]

Hi all,

One of our systems is developed with 4D Server (Team Developer) with
several coders connecting to make changes. If I move the Server from,
say v17.0 to v17.0 HF1 or a nightly build, do all the other developers
need to update their versions?

4D does not complain when you connect, as long as your major version
is the same (not sure about, say 16.1 vs 16.2)

dave

-- 
David Nasralla
Clean Air Engineering
**
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: New record numbering system and CALL WORKER

[Dave Nasralla via 4D_Tech]

Hi Bernd,

I ran into a similar situation with Proposal and Project numbers. My
decision was to not give the number out until they saved the record.
This prevented people from using the number elsewhere (say for
purchasing, etc) without a saved record in the system.

dave
On Tue, Aug 28, 2018 at 12:46 AM Bernd Fröhlich via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Pat Bensky:
>
> > The important thing is that all record cancellations go through a
> > *CancelRecord* method.
> > I created a [SpareRecordNumbers] table which contains 3 fields: unique id,
> > table number, and spare record number
>
> > As I said, it hasn't been thoroughly tested yet. So please feel free to
> > chime in if you can see any flaws!
>
>
> I have a similar system for invoice numbers.
> Works perfectly in theory but in real life once or twice a year we got a 
> missing invoice number.
> Took me some time to figure out how it got lost (very obvious, once you know):
>
> User starts writing the invoice - gets a number through the system.
> User goes home, leaving the invoice open.
> User is disconnected, so the number is never returned.
>
> Now I look for lost number on every restart and if I find one I put it in the 
> recycling bin.
> Never lost a number since.
>
> Greetings from Germany,
> Bernd Fröhlich
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: Help please - Compiling

[Dave Nasralla via 4D_Tech]

Hi Chip,

I"m using v17HF1 and it does not compile on the last sort. This does:

C_POINTER($1;$Handle)

C_TEXT($formula)

C_LONGINT($i;$2;$Sort_Column;$3;$Direction;$Sze)


$Handle:=$1

$Direction:=$2

$Sort_Column:=$3


`errutl_Start


$Sze:=Size of array($Handle->)


C_Pointer($a;$b;$c)


If ($Size<=12)


If ($Direction=Ascending)

C_POINTER($a;$b;$c)

Case of

: ($Size=1)
$a:=$Handle->{1}
SORT ARRAY($a->;>)

: ($Size=2)
$a:=$Handle->{1}
$b:=$Handle->{2}
SORT ARRAY($a->;$b->;>)

: ($Size=3)
$a:=$Handle->{1}
$b:=$Handle->{2}
$c:=$Handle->{3}

SORT ARRAY($a->;$b->;$c->;>)

End case

End if

End if



On Fri, Aug 17, 2018 at 9:18 AM, Chip Scheide via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Can some one (everyone?) try to compile the following code
>
> if it compiles, please let me know, or let me know what you did to get
> it to compile.
> I have tried everything I can think of to get this to compile - and it
> will not.
>
> the following is a portion of a much larger case statement which fails
> to compile throwing the error:
> Did not expect the operator <
>
> I can not figure out why...
>
> Thanks in advace
> Chip
>
> Code:
> C_POINTER($1;$Handle)
> C_TEXT($formula)
> C_LONGINT($i;$2;$Sort_Column;$3;$Direction;$Sze)
>
> $Handle:=$1
> $Direction:=$2
> $Sort_Column:=$3
>
> errutl_Start
>
> $Sze:=Size of array($Handle->)
>
> If ($Size<=12)
>
> If ($Direction=Ascending)
> Case of
> : ($Size=1)
> SORT ARRAY(($Handle->{1})->;>)
>
> : ($Size=2)
> SORT ARRAY(($Handle->{1})->;($Handle->{2})->;>)
>
> : ($Size=3)
> SORT ARRAY(($Handle->{1})->;($Handle->{2})->;($Handle->{3})->;>)
> End case
> End if
> End if
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: First day experience using 4D v17.0 HF1

[Dave Nasralla via 4D_Tech]

I'm on the slower end of things with a DSL line that does 25down/2up.
Latency seems to be more critical for me. If it stays under, say,
70ms, everything seems to work remarkably well, even searches.

dave

On Thu, Aug 16, 2018 at 8:58 AM, Jeffrey Kain via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Agreed.
>
> I do some remote development from home using 4D version 15. It's a cable 
> modem on my end (150 down/12 up) to a large university halfway across the 
> country.  Development is very speedy once things get cached, and even using 
> the application is pretty good with a few exceptions where there are lots of 
> tiny queries in loops, etc., instead of optimized S2A.
>
> The first thing I do when connecting to the server is to do a Find In Design 
> for text contains  which ends up locally caching all of the 
> methods. From that point on, everything in the design environment is super 
> fast.
>
>> On Aug 16, 2018, at 10:53 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>>
>> This has only become possible in the last maybe 5 years due to the increases 
>> in internet speeds, and the changes 4D has made to optimize network traffic 
>> between 4D Server and 4D Client. I believe the new network layer is a major 
>> contributor to this.
>>
>> Trying to do what we have been doing 10 years ago with a 10 Mbps down and 
>> 1Mbps up internet connection would have been a horrible experience.
>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: E-Mail in 4D

[Dave Nasralla via 4D_Tech]

Hi Jody,

I think the new Gmail interface is technically following the RFCs for
rendering emails. If you are sending plain text emails, right before
the send command, I do a simple replace like:
$MessageBody_vt:=replace string(MessageBody_vt;<>CR;<>CRLF)

Where:
<>CR:=Char(13)
<>CRLF:=Char(13)+Char(10)

Interestingly, if I send plain text email with Mac Mail that has a
bunch of returns, Mac Mail encodes the carriage returns as <>CRLF - so
they render fine. Emails that have just Linefeeds (Char(10)), also
render fine (which makes so sense to me).

We are business customers with Google Suite and have access to their
Tech Support. On one had they created a support case for me, but on
the other, they said I was the only one complaining. The fix above
seemed to worked for us (though, today, I am troubleshooting sending
emails from Windows PCs with v17.0.HF1 - Macs seem fine).

Not sure if that helps - but there you go.

dave



On Tue, Aug 14, 2018 at 6:56 PM, Jody Bevan via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> The last time I wrote an E-Mail client with 4D was circuit 4D v11 and into 
> v12. It worked great. I left the programming world for a break for 2 years, 
> and then got back in.
>
> Now I am using 16R6, and will likely move into the v17. releases for a 
> product I am working on.
> From my review today, and lurking over the last several months, it looks like 
> not much has changed within 4D to dramatically change from what I did back 
> then. It does sound like the likes of google mail has done some changes that 
> will likely cause me some grief.
>
> For those of you that kept in the game, and advancing is this your take on it?
>
>
> Jody Bevan
> Developer
> Argus Productions Inc. 
> +1 587-487-6120
>
>
>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: V17 and Edit menu (Copy)

[Dave Nasralla via 4D_Tech]

I first ran across this with v16R6, but in conversations with other
developers, not everyone was running into the same issue, so I didn't
report it as a bug (or take the time to isolate and repeat). In my
case, the commands were being called from a component (Foundation
v5.7).

Good luck,

dave

On Tue, Aug 14, 2018 at 11:12 AM, Jeffrey Kain via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Thanks for the tip - I ran across this too and had already changed all of 
> those.  I'm going to double-check though.
>
>> On Aug 14, 2018, at 11:53 AM, Dave Nasralla via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>>
>> Yes I have seen this. The first thing I would look at is the command:
>> SET MENU ITEM PROPERTY(<>Fnd_Menu_FileMenu_t;-1;Associated standard
>> action;ak quit)
>>
>> The old constants need to be updated to the new ones (eg. ak quit) . I
>> found if I "touched" a method with the old constants, they no longer
>> worked and failed..
>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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
**

Some Older PCs Unable to run 4D Client in 64 bit

[Dave Nasralla via 4D_Tech]

Hi All,

Just wondering if anyone else has run into this. We have a older Dell
PC - Optiplex 745 - purchased in 2008. It is currently running Windows
10 64bit. We were experiencing crashes (very predictable) with certain
button clicks which ran fairly benign code when I moved to a 64bit
Windows client (v17). Very consistent.

When I dropped back to 32 bit, the issues went away. Other (more
current) machines are fine.

Is there a chipset issue with older PCs that might cause this? I
remember an earlier post where an old Mac mini with a current OS can't
run the current 4D.

Any thoughts on this?

Thanks,

dave

-- 
David Nasralla
Clean Air Engineering
**
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: V17 and Edit menu (Copy)

[Dave Nasralla via 4D_Tech]

Yes I have seen this. The first thing I would look at is the command:
SET MENU ITEM PROPERTY(<>Fnd_Menu_FileMenu_t;-1;Associated standard
action;ak quit)

The old constants need to be updated to the new ones (eg. ak quit) . I
found if I "touched" a method with the old constants, they no longer
worked and failed..

dave

On Fri, Aug 10, 2018 at 6:27 AM, Jeffrey Kain via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> What we are seeing is a lot more obvious - in the application mode the Copy 
> menu item just becomes permanently disabled after awhile.
>
> We haven't found a pattern yet - it could well be something in our own code — 
> but we haven’t changed our menu handling code in a long time.
>
>> On Aug 9, 2018, at 1:12 PM, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>>
>> I just had an instance (v17 Mac) where "command C" and "command V" to copy 
>> and paste some form objects between two forms had no effect.  It worked when 
>> I used the menus with the mouse.  That also seems to have cured the problem. 
>>  This happens on such rare occasions that I've been blaming my keyboard 
>> (which hasn't had this problem in other apps).
>>
>> Keith
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: OFF - Reconditioning SSD Drives

[Dave Nasralla via 4D_Tech]

Thanks Tim,

On the next system maintenance I'll look into the Samsung software.
I'm seeing mixed reports about TRIM on the Mac - everything from: "it
does not work on external SSDs" to a command line 'trimforce' which
has a disclaimer to not use it on production machines as it may cause
data loss. This is an excerpt from my terminal command line with I
attempt to use the trimforce command:

"IMPORTANT NOTICE:  This tool force-enables TRIM for all relevant attached
devices, even though such devices may not have been validated for data
integrity while using TRIM.  Use of this tool to enable TRIM may result in
unintended data loss or data corruption.  It should not be used in a commercial
operating environment or with important data. Before using this tool, you
should back up all of your data and regularly back up data while TRIM is
enabled.  This tool is provided on an “as is” basis. APPLE MAKES NO WARRANTIES,
EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION THE IMPLIED WARRANTIES OF
NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE,
REGARDING THIS TOOL OR ITS USE ALONE OR IN COMBINATION WITH YOUR DEVICES,
SYSTEMS, OR SERVICES. BY USING THIS TOOL TO ENABLE TRIM, YOU AGREE THAT, TO THE
EXTENT PERMITTED BY APPLICABLE LAW, USE OF THE TOOL IS AT YOUR SOLE RISK AND
THAT THE ENTIRE RISK AS TO SATISFACTORY QUALITY, PERFORMANCE, ACCURACY AND
EFFORT IS WITH YOU."

I'm hesitant to try it in a production environment unless others have
had a good experience with it.

dave

On Wed, Aug 8, 2018 at 10:41 AM, Timothy Penner via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>> Is TRIM enabled?
>> If not that would be my first step.
>
> Definitely look into running TRIM on a regular basis.
>
> Also, have you looked at the software provided by the manufacturer?
> https://www.samsung.com/semiconductor/minisite/ssd/download/tools/
>
> The manufacturer software usually has some stuff to check if all the settings 
> are correct and also benchmark the drive.
>
> -Tim
>
>
>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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
**

OFF - Reconditioning SSD Drives

[Dave Nasralla via 4D_Tech]

Hey All,

This isn't related to 4D per se, but our 4D server is running a
mirrored RAID with two Samsung 850 Pro drives on Mac OS 10.13.x.
Recently I wiped the RAID and upgraded to the current OS from scratch
doing a clean install of everything. Now I am seeing a fairly
noticeable performance hit with write operations. I used to be able to
duplicate a 400MB file in s few seconds, but not anymore. I am not
running the new mac file system (APFS) on the RAID.

I'm thinking the SSDs need to be reconditioned. Any one have any
recommendations? (I can also connect them to a PC to do another wipe
if necessary.)

dave

-- 
David Nasralla
Clean Air Engineering
**
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: Scheduled ISP Maintenance @ 4D Office (France)

[Dave Nasralla via 4D_Tech]

The 4D store is up and running again. Just got my licenses.

dave

On Tue, Aug 7, 2018 at 8:27 AM, Alan Chan via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> I guess most engineers of its ISP were on vacation (the famous French summer 
> vacation).
>
> Alan Chan
>
> 4D iNug Technical <4d_tech@lists.4d.com> writes:
>>I have been trying to get licensing since Friday Still no luck.
>>
>>dave
>>
>>On Tue, Aug 7, 2018 at 4:26 AM, Pat Bensky via 4D_Tech
>><4d_tech@lists.4d.com> wrote:
>>> I'm still unable to register a licence as of Tuesday 11 AM UK time ...
>>>
>>> On Mon, 6 Aug 2018 at 15:24, Tai Bui via 4D_Tech <4d_tech@lists.4d.com>
>>> wrote:
>>>
 Hi,

 For some reason it appears that the internet has been down since the ISP
 performed their maintenance.
 The ISP has been informed and should be working on it.

 Apologies for the inconvenience.

 Best Regards,
 -Tai B.



 **
 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
 **
>>>
>>>
>>>
>>> --
>>> *
>>> 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)
>>> Archive:  http://lists.4d.com/archives.html
>>> Options: https://lists.4d.com/mailman/options/4d_tech
>>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>>> **
>>
>>
>>
>>--
>>David Nasralla
>>Clean Air Engineering
>>**
>>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 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: Frequent and Random Crashes - since 16 conversion

[Dave Nasralla via 4D_Tech]

Hey Bob,

Just read your post. FYI - There is no 4D Pack for v16R6. In general
there are equivalent commands you can use that are native, but it must
be removed.

dave

On Fri, Aug 3, 2018 at 2:02 PM, Bob Miller via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Hi Everyone,
>
> I've recently completed a conversion from 4D v15 -> v16r6 on Windows, for
> a built-server application.  This also changed the client from a 32 bit
> client to a 64 bit client and we went to the "new" network layer.
>
> Since then, we've had many reports from both users with locally installed
> clients as well as users on remote desktop servers that at least 4-5 times
> a day they'll perform some operation (there's no consistency; they can be
> anywhere in the program) and it will instantly crash - no error message
> other than a dialog from 4D Volume Desktop that says, "4D Volume Desktop
> has stopped working".
>
> I'm wondering if this could be related to the new network layer?  I recall
> some chat about a year ago about problems with this layer, but as I was
> not using it at the time and was hoping it all would be worked out before
> I was going to be using it, I kind of ignored it all.  Now I'm having
> problems.
>
> I"m using pretty standard plugins, but I can't trace the behavior to any
> of these:
> 4D Internet commands
> 4D Pack
> ALP
> ObjectTools
> Win32API
> XL Plugin
> XML Plugin
>
> Have others seen this?  I have about 180 users and this was not a problem
> with v15r4.  I'm sure I've logged 100+ instances of such crashes, which
> are probably only a small fraction of the overall problem.
>
> Any insights would be helpful.
>
> Thank you,
>
>
> Bob Miller
> Chomerics, a division of Parker Hannifin Corporation
>
>
> ll
> "PLEASE NOTE: The preceding information may be confidential or privileged. It 
> only should be used or disseminated for the purpose of conducting business 
> with Parker. If you are not an intended recipient, please notify the sender 
> by replying to this message and then delete the information from your system. 
> Thank you for your cooperation."
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: Scheduled ISP Maintenance @ 4D Office (France)

[Dave Nasralla via 4D_Tech]

I have been trying to get licensing since Friday Still no luck.

dave

On Tue, Aug 7, 2018 at 4:26 AM, Pat Bensky via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> I'm still unable to register a licence as of Tuesday 11 AM UK time ...
>
> On Mon, 6 Aug 2018 at 15:24, Tai Bui via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
>> Hi,
>>
>> For some reason it appears that the internet has been down since the ISP
>> performed their maintenance.
>> The ISP has been informed and should be working on it.
>>
>> Apologies for the inconvenience.
>>
>> Best Regards,
>> -Tai B.
>>
>>
>>
>> **
>> 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
>> **
>
>
>
> --
> *
> 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)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
David Nasralla
Clean Air Engineering
**
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
**

New Gmail interface does not render carriage returns as Line breaks in 4D plain text Emails

[Dave Nasralla via 4D_Tech]

Hey all,

This may be a bit obscure for most. Our system (for decades) has sent
plain text emails (mostly alerts and short notices). It's never been
an issue until the new Gmail interface. The new interface does not
render line breaks sent as a carriage return. Everything just runs
together. Line breaks sent as a carriage return plus line feed do
render correctly. Every other email client I have tested does fine
with just carriage returns (including the old Gmail interface.)

I know the RFC rules for headers require a CRLF, but it is less clear
about a message body.
I have an ongoing case with the G Suite tech support. We'll see what happens.

Side note: The funny thing about the G Suite tech support is that they
could not give me a gmail address I could send a demo email to show
them the issue directly. Instead the had me use the developer tools in
chrome to record a session. When I asked why they could not simply
look at the email in the gmail interface, they said they did not have
access to gmail from their system for security reasons. The irony
seemed a bit thick.

dave

-- 
David Nasralla
Clean Air Engineering
**
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: Trouble Decoding Base64 Text

[Dave Nasralla via 4D_Tech]

Nevermind, though I'm not entirely sure this isn't a kind of bug.
If you change the Encoding by adding two equal signs to the end
"eyJ1c2VySWQiOiJiMDhmODZhZi0zNWRhLTQ4ZjItOGZhYi1jZWYzOTA0NjYwYmQifQ=="

It properly decodes to:
{"userId":"b08f86af-35da-48f2-8fab-cef3904660bd"}

Some online decoding sites don't have the same issue. Like this site
does decode the original with the same outcome.
https://www.base64decode.org/

Just a bit confusing. It seems like 4D should throw and error or something.

dave


On Fri, Jun 29, 2018 at 8:06 AM, Dave Nasralla  wrote:
> Can anyone tell me what I am doing wrong here. In the code below I am
> getting back the same text I and trying to decode.
>
> C_BLOB($Blob_vx)
> C_TEXT($EncodedText_vt)
> $EncodedText_vt:="eyJ1c2VySWQiOiJiMDhmODZhZi0zNWRhLTQ4ZjItOGZhYi1jZWYzOTA0NjYwYmQifQ"
> TEXT TO BLOB($EncodedText_vt;$Blob_vx;UTF8 text without length)
> BASE64 DECODE($Blob_vx)
> $DecodedText_vt:=BLOB to text($Blob_vx;UTF8 text without length)
> ALERT($DecodedText_vt)
>
> I must be missing something...
>
> I am using v16R6 on Mac OS.
>
> --
> David Nasralla
> Clean Air Engineering



-- 
David Nasralla
Clean Air Engineering
**
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
**

Trouble Decoding Base64 Text

[Dave Nasralla via 4D_Tech]

Can anyone tell me what I am doing wrong here. In the code below I am
getting back the same text I and trying to decode.

C_BLOB($Blob_vx)
C_TEXT($EncodedText_vt)
$EncodedText_vt:="eyJ1c2VySWQiOiJiMDhmODZhZi0zNWRhLTQ4ZjItOGZhYi1jZWYzOTA0NjYwYmQifQ"
TEXT TO BLOB($EncodedText_vt;$Blob_vx;UTF8 text without length)
BASE64 DECODE($Blob_vx)
$DecodedText_vt:=BLOB to text($Blob_vx;UTF8 text without length)
ALERT($DecodedText_vt)

I must be missing something...

I am using v16R6 on Mac OS.

-- 
David Nasralla
Clean Air Engineering
**
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: Printer Issues

[Dave Nasralla via 4D_Tech]

Hi Kirk,

Here is a method that isn't always pretty...

If it's a limited number of forms (like a standard Invoice or Quote)
you can have the 4D Server generate uniform PDF file that the client
can print. This is what we do where we have a mixed Mac/Windows
environment and we want all the printouts to be the same.

dave

On Thu, Jun 28, 2018 at 12:02 PM, rooftop99--- via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> (All Windows OS, Server/Client, 4D v16R5, multiple laser printers)
>
> Hi All,
>
> We have a large 20+ year old 4D applications.  Some of our printers honor 
> margin changes via SET PRINT OPTION, others do not.  It appears this command 
> in 4D is meant for postscript printers.  Most of our printers are PCL (as far 
> as I can determine).  All of this is causing havoc as some printers truncate 
> columns and others do not.  Unfortunately we don’t have complete control over 
> what printers are in our offices or even the print drivers they use.
>
> Anyone have a creative way to handle printing in such a mix-printer 
> environment?  Thanks in advance for your help!
>
> Kirk
>
>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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
**

Has Anyone Used the Google Admin SDK to Update Google Users?

[Dave Nasralla via 4D_Tech]

Hey All,

I'm hoping I'm not the first to try this :-).

When a user changes their password in my 4D Server app, I want the 4D
Server to update their google password to reflect the change. (Note:
This is for our domain in G Suites and I have admin access.)

There appear to be several routes you can go. I prefer the headless
route in the background which requires signing your requests with a
certificate.

Anyway, just wondering if anyone has attempted this before.

Thanks!

dave

-- 
David Nasralla
Clean Air Engineering
**
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: Is there any reason to not use Windows 64bit for v16R6 clients (Mac 64bit Server)?

[Dave Nasralla via 4D_Tech]

Thanks Pat and Wayne.

On the 4D side I'm 32 bit free (no 4D Write). I spoke with our IT guys
and they said there are some 32 bit machines out there, but they want
to get rid of them, so moving to 64bit will force them out of the wood
work and get them upgraded. Not sure if that is the nicest way to do
things

dave

On Thu, Jun 14, 2018 at 10:28 AM, Wayne Stewart via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> I’d run 64 bit if I could (plugins permitting etc).
>
> On Fri, 15 Jun 2018 at 00:54, Dave Nasralla via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> Hey All,
>>
>> We recently moved all our 4D apps to v16R6, partly to get ready for
>> the Macs going 64bit only. (I thought High Sierra was the last OS to
>> support 32bit, but Apple announced that the next OS, Mojave will still
>> support it - and be the last).
>>
>> Our 4D server is Mac as well, and now everything Mac is 64bit for us.
>>
>> We also have Windows clients. Is there any reason to not run 64bit
>> Windows on the client side (assuming my Windows clients have 64 bit
>> OS's)? Right now I deployed v16r6 on 32bit windows machines.
>>
>> Any thoughts or insights are welcome.
>>
>> dave
>>
>> --
>> David Nasralla
>> Clean Air Engineering
>> **
>> 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
>> **
>
> --
>
> Regards,
>
> Wayne
>
>
> [image: --]
> Wayne Stewart
> [image: http://]about.me/waynestewart
> <http://about.me/waynestewart>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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
**

Is there any reason to not use Windows 64bit for v16R6 clients (Mac 64bit Server)?

[Dave Nasralla via 4D_Tech]

Hey All,

We recently moved all our 4D apps to v16R6, partly to get ready for
the Macs going 64bit only. (I thought High Sierra was the last OS to
support 32bit, but Apple announced that the next OS, Mojave will still
support it - and be the last).

Our 4D server is Mac as well, and now everything Mac is 64bit for us.

We also have Windows clients. Is there any reason to not run 64bit
Windows on the client side (assuming my Windows clients have 64 bit
OS's)? Right now I deployed v16r6 on 32bit windows machines.

Any thoughts or insights are welcome.

dave

-- 
David Nasralla
Clean Air Engineering
**
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 Thomas Maul's Email Component in v16.x?

[Dave Nasralla via 4D_Tech]

Thanks Kirk and Rudy,

I'll take a closer look at your suggestions, because some of the
emails are still failing. For example, if I attach a file, the file
comes through, but the email is blank.

I think the email standard is so old and was never intended to do what
we ask it to do nowadays.

dave

On Fri, Apr 20, 2018 at 3:55 PM, Kirk Brooks via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Dave,
> You know Miyako has posted a number of suggestions and solutions to this
> very issue in the last couple of years. He's also got some good stuff on
> his github:
>
> https://github.com/miyako/4d-tips-send-mail
> https://github.com/miyako/4d-plugin-gmime
>
>
> 4d-plugin-gmime was particularly helpful for me to work out my own set of
> methods for sending HTML emails.
>
>
> On Wed, Apr 18, 2018 at 9:12 AM, Dave Nasralla via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> Hi All,
>>
>> I am updating a system to v16 (16.3 HF2 32bit) from v15.5. The system
>> uses Thomas Maul's excellent HTML Email Component.
>>
>> The problem I am running into is that the body text is now rendered in
>> an email like as Base64 Encoded.
>>
>> Below are two relatively identical emails. One from version 15, and
>> one from version 16 (16.3 HF2 32 bit on Mac OS 10.12.6).
>>
>> These are the raw emails I received with the relevant headers. They
>> should render on an email client as a simply HTML email with a link.
>>
>> Any help would be appreciated. Right now it is a show stopper for
>> upgrading.
>>
>>
>> --
>> David Nasralla
>> Clean Air Engineering
>>
>> From v15 (looks normal in an email client):
>>
>> Message-ID: <5ad75ba5.1c69fb81.9064a.4...@mx.google.com>
>> X-Google-Original-Message-ID: <4/18/18$2144749$"No Reply"
>> <nore...@cleanair.com>>
>> From: No Reply <automa...@cleanair.com>
>> X-Google-Original-From: "No Reply" <nore...@cleanair.com>
>> Mime-Version: 1.0
>> Content-Type: multipart/alternative;
>>   boundary="=_NextPart_001_4/18/18_2144749"
>> Content-Transfer-Encoding: 7bit
>> Date: Wed, 18 Apr 2018 08:52:54 -0600
>> To: dnasra...@cleanair.com
>> Subject: File ready for download
>> Importance: Normal
>>
>> This is a multi-part message in MIME format.
>>
>> --=_NextPart_001_4/18/18_2144749
>> Content-Type: text/plain;
>> charset="UTF-8"
>> Content-Transfer-Encoding: base64
>>
>> VGhlIGZpbGUgQWRoZXNpdmVfR2x1ZV9DaGFydC5wbmcgaXMgY3VycmVudGx5
>> IGF2YWlsYWJsZSBmb3IgZG93bmxvYWQgdXNpbmcgdGhlIGxpbmsgYmVsb3c6
>> IA0NaHR0cHM6Ly9zZWMuY2xlYW5haXIuY29tL2dvZmlsZS9BZGhlc2l2ZV9H
>> bHVlX0NoYXJ0LnBuZz9maWxlaWQ9NXptS2hZUUVLQWtCTnplcSANDVRoaXMg
>> bGluayB3aWxsIHJlbWFpbiB2YWxpZCBmb3IgMSBkYXku
>>
>> --=_NextPart_001_4/18/18_2144749
>> Content-Type: text/html;
>> charset="UTF-8"
>> Content-Transfer-Encoding: base64
>>
>> PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMDEg
>> VHJhbnNpdGlvbmFsLy9FTiI+DTxIVE1MPjxIRUFEPjwvSEVBRD48Qk
>> 9EWT4NVGhlIGZpbGUgPGI+QWRoZXNpdmVfR2x1ZV9DaGFydC5wbmc8L2I+
>> IGlzIGN1cnJlbnRseSBhdmFpbGFibGUgZm9yIGRvd25sb2FkIHVzaW5nIHRo
>> ZSBsaW5rIGJlbG93Og08YnI+DTxicj4NDTxhIGhyZWY9Imh0dHBzOi
>> 8vc2VjLmNsZWFuYWlyLmNvbS9nb2ZpbGUvQWRoZXNpdmVfR2x1ZV9DaGFydC5wbmc/
>> ZmlsZWlkPTV6bUtoWVFFS0FrQk56ZXEiPmh0dHBzOi8vc2VjLmNsZWFuYWly
>> LmNvbS9nb2ZpbGUvQWRoZXNpdmVfR2x1ZV9DaGFydC5wbmc/
>> ZmlsZWlkPTV6bUtoWVFFS0FrQk56ZXE8L2E+DQ08YnI+DTxicj4NDVRoaXMgbGluayB3aWxsIH
>> JlbWFpbiB2YWxpZCBmb3IgMSBkYXkuDTwvQk9EWT48L0hUTUw+
>>
>> --=_NextPart_001_4/18/18_2144749--
>>
>>
>> —
>> —
>>
>> From v16:
>> Message-ID: <5ad757e8.528c1f0a.7151f.5...@mx.google.com>
>> X-Google-Original-Message-ID: <4/18/18$2087269$"No Reply"
>> <nore...@cleanair.com>>
>> From: No Reply <automa...@cleanair.com>
>> X-Google-Original-From: "No Reply" <nore...@cleanair.com>
>> Mime-Version: 1.0
>> Content-Type: multipart/alternative;
>>   boundary="=_NextPart_001_4/18/18_2087269"
>> Content-Transfer-Encoding: base64
>> Date: Wed, 18 Apr 2018 08:36:56 -0600
>> To: dnasra...@cleanair.com
>> Subject: File ready for download
>> Importance: Normal
>>
>> VGhpcyBpcyBhIG11bHRpLXBhcnQgbWVzc2FnZSBpbiBNSU1FIGZvcm1hdC4N
>> Cg0KLS0tLS0tPV9O
>> ZXh0UGFydF8wMDFfNC8xOC8xOF8yMDg3MjY5DQpDb250ZW50LVR5cGU6IHRl
>> eHQvcGxhaW47DQoJ
>

Re: Anyone using Thomas Maul's Email Component in v16.x?

[Dave Nasralla via 4D_Tech]

Hi Magnus.

Wow. The original Tech Note was published over 9 years ago!
http://kb.4d.com/assetid=75229

I've asked Thomas to republish it again somewhere. It's a testimony
that it's been used for so long.

dave

On Fri, Apr 20, 2018 at 12:50 PM, Magnus Torell via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Dear Dave or Thomas,
>
> I would also very much appreciate the component (and source)
> for v16 / 17. I use it heavily in v15R5 and preparing for an upgrade
> and have noticed that my component is not working in v16/17.
>
> I did some tweaking on the version I got. Can't remember what,
> but maybe I need to do it again. I am not sure, but maybe I did a
> transfer of one method to the host ...rewriteURL... or something.
>
> So please if a link could be made public I am most thankful.
> Maybe some useful changes also have made its way in to the latest...
>
>
> Best Regards
> Magnus Torell
>
>
>
> --
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: Legacy network layer or not: 4D v15 on Mac OS server and v15.5

[Dave Nasralla via 4D_Tech]

Dougie,

Yes. We started using it when we moved to v15.x. (We had some issues
in v14 and I think I had an engineer tell me something to the effect
of "Right. Use v15." We do get the concessional ghost session which is
mostly a licensing annoyance. We starting the move to v16R6 and doing
a lot of testing. I won't turn on the .dot notation until we have run
snag-free for some time (can't go back to 16.3 once it's turned
on)

dave

On Fri, Apr 20, 2018 at 1:44 PM, jdcryer--- via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Dave,
>
> Whilst I cannot comment on the specific version I will say that everyone 
> should get on board with the new network layer.  Start testing with it and 
> providing as much feedback as fast as possible.  It is the future whether we 
> like it or not.
>
> It has improved through v15, v16 and even v17 but still has many issues 
> related to ghost connections, speed and seemingly random dropouts.  These are 
> incredibly difficult to diagnose and report an clearly there is not enough 
> being done by 4D to debug and resolve (particularly via the internet where 
> there are so many different factors involved.
>
> To make this robust we need to keep the pressure on and provide feedback from 
> the many environments and uses that we have as users and developers.
>
> Regards,  Dougie
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: Legacy network layer or not: 4D v15 on Mac OS server and v15.5

[Dave Nasralla via 4D_Tech]

FWIW, I don't think the 64Bit Mac Servers support the old network layer

dave

On Fri, Apr 20, 2018 at 3:46 AM, Jeffrey Kain via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Paul - All versions continue to support the legacy network layer for 32 bit 
> applications and Windows 64 bit server.  There’s no change here.
>
> The new network layer seems hugely improved in 16.3 HF2.  We run a few 
> smaller servers (<30 clients) with no problems on this version.  We haven’t 
> tried the 600+ user server yet as it’s such a huge task.
>
> Also, in v17 the legacy network layer is available in 64-bit apps  if you 
> really need it.
>
>> On Apr 20, 2018, at 3:37 AM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>>
>> Hi,
>>
>> We have been having some intermittent crashes with 4D Server, 150+ users and 
>> a 120gb database. We use “Execute on server” quite a bit and the release 
>> notes for 15.5 say a bug was fixed which could cause crashes with Execute on 
>> server.
>>
>> We’re preparing to go from v15.4 to v15.5 and it apparently only has the new 
>> network layer. We have had the legacy layer up until now.
>> Is the new network layer ready for showtime now?
>>
>>
>> Does anyone have any experience with that Execute on server bug and whether 
>> it was resolved with v15.5?
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: Downloading files via FTP

[Dave Nasralla via 4D_Tech]

Hi Pat,

I would try a regular ftp client and see what paths work for it (and
that it does work), and then compare (I like Fetch).

dave

On Fri, Apr 20, 2018 at 6:39 AM, Pat Bensky via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Using v16.3 32-bit and 64-bit
>
> I'm trying to download some files via FTP.
> I get a list of the files in the specified directory:
>
> $error:=*FTP_GetDirList *(vFTP_ID;$hostpath;$atDldFileNames;$aiDldFileSizes;
> $aiDldFileKinds;$adDldFileDates;$aiDldFileTimes)
> (all arrays have been previously declared).
> No problem :)
>
> Then loop through the array of file names and hopefully download each one:
>
> *For *($i;1;*Size of array*($atDldFileNames))
>
> *If *($$aiDldFileKinds{$i}=1)
>
>   // skip this dude
>
> *Else *
>
> $localFilePath:=$localPath+$atDldFileNames{$i} // eg: "Macintosh
> HD:Users:patbensky:clients:Anderson
> Vacations:images:10--MedicineTrailSnow.jpg"
>
> $filepath:=$hostpath+"/"+$atDldFileNames{$i} // eg:
> public_html/Anderson/uploads/10--MedicineTrailSnow.jpg
>
> $err:=*FTP_Receive *(vFTP_ID;$filepath;$localFilePath;0)
>
> // $err is always -1 or 10060 (file not found)
>
> *End for  *
>
>
> I've tried various different versions of the file pathnames but can't find
> one that works.
>
> For example:
>
> $hostpath:=$atDldFileNames{$i}
>
> localFilePath:=$localPath+"temp.jpg"
>
> .. and various other things.
>
>
> A/ny suggestions as to where I'm going wrong?
>
>
> Thanks!
>
>
> Pat
>
>
>
> --
> *
> 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: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
David Nasralla
Clean Air Engineering
**
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 Thomas Maul's Email Component in v16.x?

[Dave Nasralla via 4D_Tech]

Hi Tim,

Thanks for your post. I did look at your forum link, and yes, I was
seeing the exact same thing. Unfortunately, none of their work-arounds
worked for me. I still would end up with a Base64 encoded email being
presented to the user.

This morning, Thomas Maul emailed me with a link to his current
component, and said he was able to successfully send an email - and it
worked for me!

He doesn't remember making any changes specifically, but said he could
have easily changed his code over the years, and the same goes on my
end. If I have time later, I want to compare the key routines to see
what made the difference.

Either way, it's working for me now. Thanks for you input - always appreciated!

dave


On Wed, Apr 18, 2018 at 1:51 PM, Timothy Penner via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Maybe it's related to this:
> http://forums.4d.com/Post/EN/21192530/1/21206974#21192531
>
> -Tim
>
>
>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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 Thomas Maul's Email Component in v16.x?

[Dave Nasralla via 4D_Tech]

Thanks for the reply, John. The problem is that the entire encoding is wrong.

The v15 header is:
Content-Transfer-Encoding: 7bit

While the v16 is:
Content-Transfer-Encoding: base64

I'll look into the encoding options later today. In the mean time I
was wondering if anyone else was having the same issue.

dave


On Wed, Apr 18, 2018 at 10:33 AM, John DeSoi via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Maybe this change in 16.3 HF2?
>
>>
>> ACI0097778"BASE64 ENCODE" command inserts CRLF characters every 4 
>> characters. The new behaviour is that no more CRLF is inserted by the 
>> command. If CRLF is needed, it's up to the develop to insert it.
>
> https://bugs.4d.fr/fixedbugslist?Version=16.3_HF2
>
>
> John DeSoi, Ph.D.
>
>
>> On Apr 18, 2018, at 11:12 AM, Dave Nasralla via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>>
>> The problem I am running into is that the body text is now rendered in
>> an email like as Base64 Encoded.
>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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: What's the easiest way to edit an existing constants file?

[Dave Nasralla via 4D_Tech]

Miyako - Thanks for pointing me to definition of the Constants file.

Koen - Your simple question made me re-look at what I was doing
(clearly, if Koen says I should be able to do it, then I am missing
something). I simply had to put the constants file I wanted to edit in
the Resources folder of the database I was attempting to edit the file
from. I had been looking for some sort of "File Open" in the POP
Constants Editor.

I'm back on track - Thanks!

dave


On Thu, Mar 8, 2018 at 2:01 AM, Koen Van Hooreweghe via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Hi Dave,
>
> Is there a reason why you cannot edit your existing constants file using the 
> same 4D Pop component?
>
> Kind regards,
> Koen
>
>> Op 8 mrt. 2018, om 00:31 heeft Dave Nasralla via 4D_Tech 
>> <4d_tech@lists.4d.com> het volgende geschreven:
>>
>> I found the 4DPop_Constant_Editor for creating a new constants file.
>> How do I edit one that already exists? I'd rather not use a text
>> editor. (I looked at a custom constants .xlf file and the syntax did
>> not seem overly obvious to me.)
>
>
>
> 
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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
**

What's the easiest way to edit an existing constants file?

[Dave Nasralla via 4D_Tech]

Hi All,

I found the 4DPop_Constant_Editor for creating a new constants file.
How do I edit one that already exists? I'd rather not use a text
editor. (I looked at a custom constants .xlf file and the syntax did
not seem overly obvious to me.)

dave

-- 
David Nasralla
Clean Air Engineering
**
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
**

Are All Your Tables Getting Logged?

[Dave Nasralla via 4D_Tech]

Hey All,

I ran into an issue today where I was surprised (understatement) to
see some tables did not show up in my log file. It turns out the
little check box "Include in Log File" on the table definitions was
unchecked. (24 tables out of 229)

For those of you who use custom primary keys, it's an easy mistake to
make. Now-a-days when you create a new table in 4D, 4D automatically
assigns a primary key and turns on logging. The problem is, to change
the primary key format, you need to first drop the existing key which
turns the logging off. Just because you re-add your custom primary
key, the logging is not automatically turned back on - you have to
manually check the box - easy to forget.

When you have 200+ tables in your structure, clicking on each table to
find out where you forgot to turn logging back on is not practical.
Below is code based on an earlier post on the NUG from a thread
between Cannon and Arnaud (thanks to both of you for that). Running it
simply gives you an alert with all the tables that have Journaling
(logging) turned off.

ARRAY BOOLEAN($logged_ab;0)  //>>>this one
ARRAY LONGINT($table_al;0)
ARRAY TEXT($name_at;0)
Begin SQL
SELECT LOGGED, TABLE_NAME, TABLE_ID
FROM _USER_TABLES
INTO :$logged_ab, :$name_at, :$table_al;
End SQL

C_TEXT($NotLogged_vt)
C_LONGINT($x;$Size_vl)
$Size_vl:=Size of array($name_at)
For ($x;1;$Size_vl)
If (Not($logged_ab{$x}))
$NotLogged_vt:=$NotLogged_vt+"\r"+$name_at{$x}
End if

End for

ALERT($NotLogged_vt)

-- 
David Nasralla
Clean Air Engineering
**
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: What Texting Services Are People Using?

[Dave Nasralla via 4D_Tech]

Thanks Jeff and Dani,

The volume will be relatively low - say under 200/month.

Dave

On Wed, Dec 6, 2017 at 12:35 PM, Jeff Grann via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Don’t know what you’re planned volume is, but have a look at 
> https://www.twilio.com <https://www.twilio.com/>.
>
> --
> Jeff Grann
> SuccessWare, Inc.
>
>> On Dec 6, 2017, at 2:22 PM, Dave Nasralla via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>>
>> Hey All,
>>
>> I'm looking at the option of adding texting to mobile phones to one of
>> our systems. Anyone using a system/API they like? I've briefly looked
>> at https://www.eztexting.com.
>>
>> dave
>>
>> --
>> David Nasralla
>> Clean Air Engineering
>
> **
> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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
**

What Texting Services Are People Using?

[Dave Nasralla via 4D_Tech]

Hey All,

I'm looking at the option of adding texting to mobile phones to one of
our systems. Anyone using a system/API they like? I've briefly looked
at https://www.eztexting.com.

dave

-- 
David Nasralla
Clean Air Engineering
**
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: What's the Longest you can DELAY PROCESS?

[Dave Nasralla via 4D_Tech]

Thanks Jim,

It sounds like it almost has to be an integer value...
If there is a limit, it would be nice for the docs to specify what the limit is.

dave

On Mon, Oct 16, 2017 at 10:28 AM, Jim Hays via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Max delay used to be something like 32000 ticks.  (We have an old //comment
> from 2006 that thinks so anyway)
>
> On Mon, Oct 16, 2017 at 12:20 PM, Dave Nasralla via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> Hey All,
>>
>> Ran into an odd issue. Like many of you have have a Cron Daemon to run
>> daily tasks. Usually I have it wake up at least once a day.
>>
>> In one newer system, there was a job that only had to run once a
>> month. I tried to delay the process for 30 days it is fails - like
>> does not delay AT ALL.
>>
>> eg:
>> C_LONGINT($Delay_vl)
>> $Delay_vl:=30*24*60*60*60
>>   //Days*Hours*Min*Sec*Ticks
>>
>> DELAY PROCESS(Current process;$Delay_vl)
>> ALERT("Hello World")
>>
>> This is true for v15.4, v16R2 (on mac).
>> The docs say it should be a real, but it fails whether a real or long
>> integer.
>>
>> Am I missing something? (It does work as expected for shorter times.)
>>
>> dave
>>
>> --
>> David Nasralla
>> Clean Air Engineering
>> **
>> 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
> **



-- 
David Nasralla
Clean Air Engineering
**
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
**

What's the Longest you can DELAY PROCESS?

[Dave Nasralla via 4D_Tech]

Hey All,

Ran into an odd issue. Like many of you have have a Cron Daemon to run
daily tasks. Usually I have it wake up at least once a day.

In one newer system, there was a job that only had to run once a
month. I tried to delay the process for 30 days it is fails - like
does not delay AT ALL.

eg:
C_LONGINT($Delay_vl)
$Delay_vl:=30*24*60*60*60
  //Days*Hours*Min*Sec*Ticks

DELAY PROCESS(Current process;$Delay_vl)
ALERT("Hello World")

This is true for v15.4, v16R2 (on mac).
The docs say it should be a real, but it fails whether a real or long integer.

Am I missing something? (It does work as expected for shorter times.)

dave

-- 
David Nasralla
Clean Air Engineering
**
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
**