Re: What are some causes of Plugin and Component folder synchronization errors?

[Nigel Greenlee via 4D_Tech]

Kirk

I don’t know if the following information has any relevance to you issue.  A 
few months back I was testing something out that resulted in my creating large 
files(>2gb) inside my .4dbase(package). When i logged in from ‘client’ to 
server i noticed a significant load on folder synching and the synching would 
then fail. 

It is worth checking you have not ended up with something large in your folder 
that is synching to client.

Nigel Greenlee




> On 14 Jun 2017, at 21:26, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi folks,
> 
> A couple of users are suddenly getting these errors attempting to login to
> our server over WAN. One had recently upgraded his OS to Sierra and I
> thought it might be something to do with that. I deleted all his old 4D
> folders, reinstalled the db and still got a plugin sync error. I'm using
> Sierra 12.6 so it's a mystery to me why his machine barfs and I don't.
> 
> Then another user, at the same location, noticed a computer there was
> throwing the component sync error.
> 
> I've typically seen this sort of thing involve network lag issues but there
> are other users on that same network apparently having no issues.
> 
> Any thoughts?
> 
> Thanks
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
> 
> *- Edmund Burke*
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Macros...why have i forgotten this.

[Tim Nevels via 4D_Tech]

On Jun 14, 2017, at 2:47 AM,Nigel Greenlee wrote:

> I think old age has crept up on me.
> 
> I have some macros which I use in my development structure. I want those 
> macros to work client server(i normally develop on single user). 
> 
> The Macros V2 folder is next to the .4db at the same level as plug ins, 
> components folders etc. In Client server thie Macros V2 folder does not get 
> copied to the client cache. 
> 
> I seem to remember tackling this before but cant find what i did and cant 
> remember how to get the macros on the ’server’  to auto implement on the 
> client.
> 
> Thanks to anyone who can set me straight

The "Macros v2” currently lives at “~/Library/Application Support/4D/Macros 
v2/“ on macOS. It is not automatically distributed to 4D Clients when running 
4D Server. If you want this you have 2 options:

1. Put a copy of “Macros v2” in your “Resources” folder. That will get it 
automatically to your 4D Client “Resources” folder. Then write some code to 
move it to it’s final home at “~/Library/Application Support/4D/Macros v2/“ .

2. Put “Macros v2” folder in a component next to the .4DB or .4DC file. The 
macro .xml will then be automatically distributed to 4D Client AND 4D will 
integrate the macros with the other macros already on the 4D Client machine. 
This allows you to include some macros with a component and 4D will recognize 
them. It’s a feature most do not know about. I know it works because I’ve used 
it in 2 of my own components.

Tim


Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com


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

Re: FootRunner + V13.5 Windows?

[Douglas von Roeder via 4D_Tech]

Tim:

When we get the app to V16, I'll use Process 4D tags but this issue needs
to be resolved now, when the app is in V13.

--
Douglas von Roeder
949-336-2902

On Tue, Jun 13, 2017 at 5:22 PM, Timothy Penner via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Doug,
>
> I am not sure about Footrunner (maybe Pat's suggestions about C++
> Redistributable files will help).
>
> But I wanted to provide some light at the end of the tunnel by
> reminding/informing you that beginning with v16 this functionality can be
> achieved directly in 4D without any plugins simply by using PROCESS 4D TAGS
> and the #4DCODE tag.
> http://livedoc.4d.com/4Dv16/help/Title/en/page2850.html#2880146
>
> -Tim
>
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Best solution for printing Enterable PDF docs from 4D v15 or

[Ingo Wolf via 4D_Tech]

Hello,

we do exactly what you describe via xdp-files. That are pdf forms encapsulated 
in some xml. The forms are created with Adobe Acrobat and enhanced with 
Livecycle Designer. The pdf is then converted to Base64 and embedded in a xdp, 
wich is xml following some specs from adobe. From 4D we set the values of 
certain xml tags (via PROCESS 4D TAGS), which have the same names as the form 
fields of the pdf form. Adobe Acrobat Reader then feeds these values 
automatically into the corresponding form fields (upon opening the .xdp-file). 
The maybe changed form field values are then sent via email as xml file to 4D 
and imported back into the database records. For linking with the original 
records we have xml tags containig the primary keys.

HTH
Ingo Wolf

4d_tech-requ...@lists.4d.com schrieb am Wed, 14 Jun 2017 00:47:18 -0700:
>I have a project where my client wants me to generate Enterable PDF forms
>within 4D that would be populated by variable data but also have form fields
>that would be enterable by the customer.  
>
> 
>
>Then my 4D App would email the form directly to the customer to be completed
>and then emailed back to my client.
>
> 
>
>It would then be best for automation if my 4D App could parse the PDF
>returned and populate data in 4D with the customer's completed form data.


-- 
ViELMAC Ingo Wolf
Rheinhessenring 53A
D 55597 Wöllstein
Tel. +49 (0)6703 3070320
Fax  +49 (0)6703 3070321
e-mail i...@vielmac.de
**
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: FootRunner + V13.5 Windows?

[Douglas von Roeder via 4D_Tech]

Pat:

Thanks for the suggestion. I'll give that a try.

--
Douglas von Roeder
949-336-2902

On Tue, Jun 13, 2017 at 5:06 PM, Pat Bensky via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Doug,
> We had a problem like this with a customer last year and we were able to
> (kinda) fix it by installing the appropriate version of the C++
> Redistributable. I say "kinda" because at one point we got it working, and
> then it stopped working again - I think the customer's IT guy changed
> something that broke it again, but don't know what. In the end we wrote a
> component to do the job instead. But anyway, that might be worth checking.
>
> https://www.microsoft.com/en-gb/download/details.aspx?id=
>
> HTH!
> Pat
>
> On 14 June 2017 at 00:17, Douglas von Roeder via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > I'm trying to use FR with 13.5 on Windows. My runs fine interpreted but
> > "nothing happens" running compiled.
> >
> > I'm not modifying records so I don't know that it can't modify records.
> The
> > code that I've written performs a looping operation to Sum the size of a
> > picture field and then displays the result.
> > Run the code and "nothing happens".
> >
> >
> > A second method contains all the code shown here:
> >
> > ALERT("Hello world")
> >
> > Run *that* code and "nothing happens".
> >
> >
> > In all cases, the code runs interpreted but the Alert does not
> display…even
> > the one line of code shown above.
> >
> > Any help is much appreciated.
> > --
> > Douglas von Roeder
> > 949-336-2902
> > **
> > 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
> > **
>
>
>
>
> --
> *
> CatBase - The Database Publishing Solution
> 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: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Best solution for printing Enterable PDF docs from 4D v15 or later

[Rob Laveaux via 4D_Tech]

> On 14 Jun 2017, at 05:23, Chuck Morris via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> I have a project where my client wants me to generate Enterable PDF forms
> within 4D that would be populated by variable data but also have form fields
> that would be enterable by the customer.

Hi Chuck,

My recommendation would be to use QPDF Plugin for this.

It allows you to:
- import PDF forms (designed using i.e. Adobe Acrobat) and fill-in data 
programmatically
- create PDF forms programmatically
- merge multiple PDF documents together
- flatten PDF forms so that the data becomes non-editable
- digitally sign a PDF document with a certificate in order to prove its 
authenticity

The plugin has a really rich feature set when it comes to working with PDF 
documents.
I suggest you have a look at the product documentation. Feel free to ask if you 
have more questions.

Kind regards,

- Rob Laveaux


Pluggers Software
Scholekstersingel 48
2496 MP  Den Haag
The Netherlands

Email: rob.lave...@pluggers.nl 
Website: http://www.pluggers.nl 





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

Re: 4D and Sage

[Paul Dennis via 4D_Tech]

I had sage line 50 working ok with odbc. I was able to export data from sage
into our 4D app. However this was for a one of conversion rather than
ongoing integration.
Paul



--
View this message in context: 
http://4d.1045681.n5.nabble.com/4D-and-Sage-tp5752571p5752592.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How to create Object field via SQL

[David Adams via 4D_Tech]

Jeff,

Just a note of thanks for drawing attention to thisuh"feature." I
would have been digging around in my code for some time had I not had your
post in the back of my mind.

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

Macros...why have i forgotten this.

[Nigel Greenlee via 4D_Tech]

Hi.

I think old age has crept up on me.

I have some macros which I use in my development structure. I want those macros 
to work client server(i normally develop on single user). 

 The Macros V2 folder is next to the .4db at the same level as plug ins, 
components folders etc. In Client server thie Macros V2 folder does not get 
copied to the client cache. 

I seem to remember tackling this before but cant find what i did and cant 
remember how to get the macros on the ’server’  to auto implement on the client.


Thanks to anyone who can set me straight




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

Re: 4D and Sage

[Nigel Greenlee via 4D_Tech]

Pat

I have code for this:..it uses the ODBC plug in but should be converted to just 
use SQL i think.



Nigel
> On 13 Jun 2017, at 12:17, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> We've had a few enquiries from customers and prospects about interfacing
> with Sage and I'd like to get an idea of how much work would be involved in
> setting this up.
> Basically we need to:
> - Extract data into our 4D database
> - Push data from 4D to Sage
> 
> Standard stuff I guess :)
> 
> We'll be using 4D v16.
> 
> I'm guessing this could be done via ODBC.
> 
> ​What tools would be required? EG:
> - 4D ODBC Pro?
> - ​Sage developer account?
> 
> I'd be interested to receive quotes form 4D developers who have done this
> on setting it up for us.
> 
> Pat Bensky
> 
> -- 
> *
> CatBase - The Database Publishing Solution
> 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: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

RE: v16 sort editor

[Timothy Penner via 4D_Tech]

Hi Keith,

I think the only reason the Query Editor has the fields in alphabetical order 
is because of the recent redesign.

I am not sure if there is any plan to redesign the Sort Editor; it certainly 
isn't listed as a bug.

So, to work with the current behavior, I think you can use the SET FIELD TITLES 
command:
{
SET FIELD TITLES lets you mask, rename, and reorder the fields of the table 
passed in aTable or aSubtable when they appear in standard 4D dialog boxes, 
such as the Query editor, within the Application environment (more 
specifically, when the editors are called using 4D language commands).
}
http://livedoc.4d.com/4Dv15.4/help/Command/en/page602.html

There is some code available on the Forums (posted by Arnaud De Montard) that 
will automatically sort the available fields for you using the SET FIELD TITLES 
command, this could be called on startup:
http://forums.4d.fr/Post/EN/11766178/1/11766179#11766294
http://forums.4d.fr/Code4DText/EN/2/1/11766294/771132927


C_LONGINT($table_l;$field_l;$nbOfTables_l;$nbOfFields_l)
$nbOfTables_l:=Count tables
ARRAY LONGINT($number_al;$nbOfTables_l)
ARRAY TEXT($name_at;$nbOfTables_l)
For($table_l;1;$nbOfTables_l)
$number_al{$table_l}:=$table_l
$name_at{$table_l}:=Table name($table_l)
End for
SORT ARRAY($name_at;$number_al;>)
SET TABLE TITLES($name_at;$number_al)
For($table_l;1;$nbOfTables_l)
$nbOfFields_l:=Count fields($table_l)
ARRAY LONGINT($number_al;$nbOfFields_l)
ARRAY TEXT($name_at;$nbOfFields_l)
For($field_l;1;$nbOfFields_l)
$number_al{$field_l}:=$field_l
$name_at{$field_l}:=Field name($table_l;$field_l)
End for
SORT ARRAY($name_at;$number_al;>)
SET FIELD TITLES(Table($table_l)->;$name_at;$number_al)
End for

Kind Regards,

Tim PENNER




-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Keith Goebel 
via 4D_Tech
Sent: Wednesday, June 14, 2017 3:28 PM
To: 4D Tech Mailing List Technical
Cc: Keith Goebel
Subject: v16 sort editor

Hi all.
Up until v15, the list of fields displayed in the Order By editor and in the 
Property List > Expression editor, for a listbox, display in the order of 
creation rather than alphabetically.
This behaviour makes it a pain to find a field in a large table.

The new-ish Query editor displays the fields alphabetically which is so 
much better.

I was hoping that v16 would have fixed the sort editor but I can see that it 
hasn't changed (just opened v16.1 for the first time).

Am I missing something that will make those field lists sort alphabetically?
Am I the only one that would like the list of fields to be sorted?
Cheers, Keith
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D and Sage

[Pat Bensky via 4D_Tech]

Nigel,
It would be cool to see that code :) No rush. This is not an urgent job.
Cheers
Pat

On 14 June 2017 at 08:55, Nigel Greenlee via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Pat
>
> I have code for this:..it uses the ODBC plug in but should be converted to
> just use SQL i think.
>
>
>
> Nigel
> > On 13 Jun 2017, at 12:17, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> > We've had a few enquiries from customers and prospects about interfacing
> > with Sage and I'd like to get an idea of how much work would be involved
> in
> > setting this up.
> > Basically we need to:
> > - Extract data into our 4D database
> > - Push data from 4D to Sage
> >
> > Standard stuff I guess :)
> >
> > We'll be using 4D v16.
> >
> > I'm guessing this could be done via ODBC.
> >
> > ​What tools would be required? EG:
> > - 4D ODBC Pro?
> > - ​Sage developer account?
> >
> > I'd be interested to receive quotes form 4D developers who have done this
> > on setting it up for us.
> >
> > Pat Bensky
> >
> > --
> > *
> > CatBase - The Database Publishing Solution
> > 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: 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
> **
>



-- 
*
CatBase - The Database Publishing Solution
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: How to create Object field via SQL

[Jeffrey Kain via 4D_Tech]

This bit me again yesterday too. I tried to do a SELECT * from a simple table. 
I forgot that I had used an object field.

So annoying.


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