Re: Question about storing data outside of datafile

2017-02-16 Thread David Adams via 4D_Tech 
On Fri, Feb 17, 2017 at 5:45 PM, flury olivier via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I am currently thinking of rewriting an existing document management
> system. What is the "best" way to move files from the clients to the server
> and back from the server to the client?
>
> VARIABLE TO VARIABLE? Execute on Client / Execute on Server? Using a kind
> of caching table (store the last x used files)? ...
>

Not sure if this will map well to your case, but the following strategy has
worked well for me. For reference, this a database with zillions of scanned
PDFs. Here's how it works.

* There's a documents table with a field for the stored document.
* The data is stored outside of the data file automatically by 4D.
* When a document is needed, it's loaded by 4D.

Works great. The data file is small and documents aren't loaded when they
aren't needed.

Since I'm not 100% certain what/how 4D would deal with the external
documents if something went wrong with the data file, I thought about
taking over document management server-side. It looked like that meant
giving up a lot of the speed and ease of the built-in system. (I'd like to
hear from others that have gone down this road and liked where they ended
up.) Instead, I leave the 4D system alone and have a redundant backup. The
documents are all exported to an external file hierarchy regularly so that
we have a complete mirror of the internal documents. Even if the data file
got trashed, we've got a recoverable file hierarchy. (It would take some
work, but it would be doable as each document is stored in a folder for its
'owner' record.) This external file dump can be backed up safely using
regular OS tools, reused for a Web site, etc.
**
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: Question about storing data outside of datafile

2017-02-16 Thread Maurice Inzirillo - AJAR via 4D_Tech 
Hello Olivier,

Blob to document And Document to blob with a method set to be executed on 
server is an easy and reliable solution !



Best regards,

Maurice Inzirillo
-- 
AJAR S.A.

4D v16: http://www.ajar.ch/
Wakanda Wednesday Lab : http://www.ajar.ch/wwl
twitter: ajar_info
Tél : +41 (0)323422684




> On 17 Feb 2017, at 07:45, flury olivier via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am currently thinking of rewriting an existing document management system. 
> What is the "best" way to move files from the clients to the server and back 
> from the server to the client?
> 
> VARIABLE TO VARIABLE? Execute on Client / Execute on Server? Using a kind of 
> caching table (store the last x used files)? ...
> 
> Gladly appreciate all sharing of experience.
> 
> -Ursprüngliche Nachricht-
> Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von G-Mail via 
> 4D_Tech
> Gesendet: Donnerstag, 16. Februar 2017 23:55
> An: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: G-Mail 
> Betreff: Re: Question about storing data outside of datafile
> 
>> On 02/16/2017, at 11:09 AM, Peter Bozek via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Would you like to exchange your know-how? I did similar system, and 
>> there are some tricky parts in case of C/S.
> 
> 
> There is lots of decisions we made for our purposes, and there are different 
> ways to do things for sure. We had to meet various security regulations 
> therefore we changed some of the ways we did things over the 20 or so years 
> that we had built it. Of course new technologies came along too that 
> permitted us to change that up.
> 
> Is there something specific that you are wanting to discuss?
> 
> 
> 
> Jody Bevan
> 
> **
> 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
> **

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

AW: Question about storing data outside of datafile

2017-02-16 Thread flury olivier via 4D_Tech 
I am currently thinking of rewriting an existing document management system. 
What is the "best" way to move files from the clients to the server and back 
from the server to the client?

VARIABLE TO VARIABLE? Execute on Client / Execute on Server? Using a kind of 
caching table (store the last x used files)? ...

Gladly appreciate all sharing of experience.

-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von G-Mail via 
4D_Tech
Gesendet: Donnerstag, 16. Februar 2017 23:55
An: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: G-Mail 
Betreff: Re: Question about storing data outside of datafile

> On 02/16/2017, at 11:09 AM, Peter Bozek via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Would you like to exchange your know-how? I did similar system, and 
> there are some tricky parts in case of C/S.


There is lots of decisions we made for our purposes, and there are different 
ways to do things for sure. We had to meet various security regulations 
therefore we changed some of the ways we did things over the 20 or so years 
that we had built it. Of course new technologies came along too that permitted 
us to change that up.

Is there something specific that you are wanting to discuss?



Jody Bevan

**
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: Understanding 4D Mobile...

2017-02-16 Thread Robert ListMail via 4D_Tech 
Not such a hot topic I see….   :)

R

> On Feb 16, 2017, at 12:53 PM, Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Care to describe 4DM and explain how Wakanda and/or 4DM fits into your 
> strategy? 

**
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: Corrupted Explorer Window

2017-02-16 Thread Timothy Penner via 4D_Tech 
Try closing it and then running the code from this tech tip (while the explorer 
window is closed):
http://kb.4d.com/assetid=77586

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

Corrupted Explorer Window

2017-02-16 Thread Sujit Shah via 4D_Tech 
The 4D Explorer window has gone all funny on me.

It is displaying in a small area correctly but not maximising.

Tried deleting preferences etc

Did not fix

http://kb.4d.com/assetid=77026



-- 

xxx
"There must be ingenuity as well as intention, strategy as well as
strength. "
**
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 Web Server and PHP

2017-02-16 Thread Keisuke Miyako via 4D_Tech 
until v2003 you would locate a php interpreter inside a folder named "cgi-bin".
http://www.4d.com/docs/CMU/CMU02066.HTM

since v2004 you would call SET CGI EXECUTABLE.
http://www.4d.com/docs/CMU/CMU00813.HTM

since v12 you would simply call PHP Execute (or LAUNCH EXTERNAL PROCESS, if you 
like)
in your web connection process or one of its subroutines.

If so, how?


**
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 Web Server and PHP

2017-02-16 Thread npdennis via 4D_Tech 
Can the 4D web server be configured to accept and execute a PHP script to 
process a form?




If so, how?

Neil
--
Neil Dennis
4D Developer since 1990


GreaText - Designing Software for the Way You Work
716 East 1850 N
North Ogden, UT 84414

mailto:npden...@greatext.com
http://www.greatext.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: ST Get plain text (Why does a space character get returned?)

2017-02-16 Thread Keisuke Miyako via 4D_Tech 
is it a problem that an inserted dynamic expression is returns a length:1 
placeholder as "plain text"?

it has been that way since the feature was introduced,
same with old 4D Write plugin.

a URL, when highlighted would be

$highlightedText:=ST Get plain text(ST Get text(...;ST Start highlight;ST End 
highlight))
ST GET URL(...;$label;$url;ST Start highlight;ST End highlight)

(Length($label)#0)
(Length($url)#0)
(Length($highlightedText)=1)

the only difference since v14 is that the character is now character code 32;
before, it was character code 160.

think of it this way;

the expression could evaluate as "".
the user could select a range with or without the expression.
for practical purposes (range selection) you need a placeholder for the 
expression.
whether that character should be a space or some control character is probably 
a design choice.

2017/02/17 8:30、Jeremy French via 4D_Tech 
<4d_tech@lists.4d.com> のメール：
What am I missing?


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

ST Get plain text (Why does a space character get returned?)

2017-02-16 Thread Jeremy French via 4D_Tech 
This styled text inserts a 4D Expression:
--
C_TEXT($styled_source_t)
$styled_source_t:=""
ST INSERT EXPRESSION($styled_source_t;"String(current time;HH MM SS)";ST End 
text)
--

Before the insertion the styled text is empty. After the insertion, the styled 
text contains only the insertion, which is a 4D Expression.

Here's what "$styled_source_t" contains after the above call:
--
 

--

Note the styled text contains only a 4D Expression. There is **no** URL. There 
is **no** User link.

But each of these calls returns a single space character in "$found_t".
--
C_TEXT($styled_source_t) 
$found_t:=ST Get plain text($styled_source_t;ST URL as labels)
$found_t:=ST Get plain text($styled_source_t;ST URL as links)
$found_t:=ST Get plain text($styled_source_t;ST User links as labels)
$found_t:=ST Get plain text($styled_source_t;ST User links as links)
--

I would have thought that "$found_t" would be an **empty** string, since the 
styled text is a 4D expression (NOT a URL and NOT a User link.)

What am I missing?


Command documentation at:
http://livedoc.4d.com/4D-Language-Reference-16/Styled-Text/ST-Get-plain-text.301-3037109.en.html

**
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: Question about storing data outside of datafile

2017-02-16 Thread G-Mail via 4D_Tech 
> On 02/16/2017, at 11:09 AM, Peter Bozek via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Would you like to exchange your know-how? I did similar system, and there
> are some tricky parts in case of C/S.


There is lots of decisions we made for our purposes, and there are different 
ways to do things for sure. We had to meet various security regulations 
therefore we changed some of the ways we did things over the 20 or so years 
that we had built it. Of course new technologies came along too that permitted 
us to change that up.

Is there something specific that you are wanting to discuss?



Jody Bevan

**
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: Question about storing data outside of datafile

2017-02-16 Thread Chip Scheide via 4D_Tech 
I use a separate process to move the file(s) from client to server.
Because i work inside transactions a lot.

copy file to blob (document to blob)
save record
daemon on server watches for files  (it is actually kicked awake when a file is 
transferred)
; extracts them (blob to document), and saves on the server in a specified 
directory

> On Thu, Feb 16, 2017 at 4:55 PM, G-Mail via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> We programmed in the management of the files outside of the database. We
>> started doing this with 4D version 3.5 so we had to. We continued doing
>> this since it worked very well. There was no need for us to change it, so
>> we never really investigated having 4D manage this. Too many other things
>> to work on.
>> 
>> 
> Would you like to exchange your know-how? I did similar system, and there
> are some tricky parts in case of C/S.

Hell is other people 
 Jean-Paul Sartre
**
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
**

Understanding 4D Mobile...

2017-02-16 Thread Robert ListMail via 4D_Tech 
So, 4DM (4D Mobile) allows a particular single user (or one user per "4D Mobile 
Client session") to connect to 4D Server with the idea that the mobile device 
can have a 4D Client like experience over the web and they can switch to a 
desktop and other devices with the same license….? I was thinking that Wakanda, 
via 4D Mobile, was the latest 4D way to quickly build a web client (allow web 
access to a portion of your application) for a public web-site. Now, after 
reviewing the licensing terms, I see that 4D Mobile has a far more specific 
purpose that’s not entirely clear to me. Care to describe 4DM and explain how 
Wakanda and/or 4DM fits into your strategy? 

Thanks,

Robert

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

[ANN] Register for the 2017 4D World Tour

2017-02-16 Thread Brian Young via 4D_Tech 
Two days to learn about 4D v16 and increase your skill.
  Join us for a journey through the best of 4D.

Registration is now open for most 4D World Tour locations.
Choose the city nearest you:

http://events.4d.com/wt2017/



The 4D World Tour is a series of 38 events around the world
where our experts share the latest advancements
and offer in‐depth training.

Day 1: Step it up – v16 & more

Day 2: State-of-the-art training *

* Not offered in every city.
  Please view the local description
  for the city near you.



**
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: [off] DreamWeaver replacement for maintaining 4D based website?

2017-02-16 Thread npdennis via 4D_Tech 
> Do you still like to use Dreamweaver?

Yes I do, I still haven’t found an editor that I like better. 

Neil


--
Neil Dennis
4D Developer since 1990

GreaText - Designing Software for the Way You Work
716 East 1850 N
North Ogden, UT 84414

mailto:npden...@greatext.com
http://www.greatext.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: Question about storing data outside of datafile

2017-02-16 Thread Peter Bozek via 4D_Tech 
On Thu, Feb 16, 2017 at 4:55 PM, G-Mail via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> We programmed in the management of the files outside of the database. We
> started doing this with 4D version 3.5 so we had to. We continued doing
> this since it worked very well. There was no need for us to change it, so
> we never really investigated having 4D manage this. Too many other things
> to work on.
>
>
Would you like to exchange your know-how? I did similar system, and there
are some tricky parts in case of C/S.


-- 

Peter Bozek
**
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: [off] DreamWeaver replacement for maintaining 4D based website?

2017-02-16 Thread Robert ListMail via 4D_Tech 
Neil,

Do you still like to use Dreamweaver?

Thanks,

Robert

> On Sep 29, 2014, at 12:48 PM, Dennis, Neil  wrote:
> 
> I haven't found a tool as good as DreamWeaver... I find the tool to be 
> expensive but worth it in what I can produce with it. 

**
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: Question about storing data outside of datafile

2017-02-16 Thread G-Mail via 4D_Tech 
Aaron:

re Your Questions:

> On 02/15/2017, at 2:55 PM, Aaron via 4D_Tech <4d_tech@lists.4d.com> wro

> 1) Is your solution self managing files outside of the database? …  Or are 
> you referring to the 4D database field option “outside data file” 

We programmed in the management of the files outside of the database. We 
started doing this with 4D version 3.5 so we had to. We continued doing this 
since it worked very well. There was no need for us to change it, so we never 
really investigated having 4D manage this. Too many other things to work on.

We would store specific information for being able to search for the records 
within 4D (i.e. Patient’s Key, dates, times, subject, etc).



Jody Bevan


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

Question about storing data outside of datafile

2017-02-16 Thread Mitchell Shiller via 4D_Tech 
Kirk,

Not sure this will help in your situation but this is what we do. This applies 
to OSX only.

I store all documents (hundreds of thousands) in their native format outside 
the data file in a directory on the same drive as the 4D datafile. I store the 
files by client / patient in their own folder with several subfolders. I use 
Execute on Server to retrieve / save the documents.  I store all the relevant 
metadata including the relative path of the document in the 4D datafile. I like 
to keep the 4D datafile as small as reasonable. e.g. for repairs etc.

Now for the backup, I have a separate RAID drive attached to the 4D Server. I 
use Carbon Copy Cloner to clone the documents folder every 15 minutes. At 
night, the 4D Server runs the backup to a separate directory on this second 
drive.

Once the 4D backup is complete, I use Retrospect to backup encrypted to a 
removable drive that goes offsite and to the cloud.

Just another option.

Mitch

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

Slow queries in v16

2017-02-16 Thread Jerker Stenberg via 4D_Tech 

Hello all

When we uppgaderade from v14 to v16 (32bit windows) there were 
immediately an increased response time (like 1/4-1/2 seconds) on as 
simple things as opening a dialog window.

However, we could live with that.

But worse, queries against Windows SQL-Server from our application (a 4D 
volume desktop uses ODBSLite) can vary from 1/2 second up to 20 seconds. 
Same query, same client.
We can´t see any explanation on the SQL-server side, which of course was 
our first suspected.


Is there someone who has experienced the same thing or have any idea of 
​​the cause?


--
Regards //
Jerker Stenberg
Clue

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