Re: Migrating to 4D Write Pro

[Tom Benedict via 4D_Tech]

I’m thinking that there is some code which is intercepting the Write Menu 
command and handing it off to some custom code. Look for WR ON COMMAND calls.

Tom

> On Oct 29, 2019, at 12:38, Doug Hall via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Actually, I *tried* to save my 4D Write letter -- both as a template and as
> a file. My "letters" originate in blobs, in a table called [LtrTemplate].
> From the input form of that record, I have the 4D Write area that displays
> the letter's content. I use the 4D Write menu to select File:Save (or
> File:Save As...) and instead of it actually doing this, I get an alert that
> says the file has not been saved. What gives?
> 
> Thanks!
> 
> On Tue, Oct 29, 2019 at 1:18 PM Tom Benedict  wrote:
> 
>> Hi Doug,
>> 
>> I’m pretty sure that the .4W7 format for 4D Write arrived long before v15,
>> so you should be OK. You can confirm by creating a Write document on disk
>> and seeing what extension is assigned.
>> 
>> You can also validate your conversions by having both a Write Classic and
>> a Write Pro area on a form so you can visually compare them. I found that
>> built my confidence in the conversion process. Or course, you’ll need to be
>> using a 32bit version of 4D to do this.
>> 
>> Another this to keep in mind that the blobs may be compressed, and, if so,
>> will need to be uncompressed prior to conversion.
>> 
>> Other than that, WP New makes conversion pretty easy.
>> 
>> You may already be aware, though, that if you are doing any custom
>> configuration or formatting under program control in Write Classic, all of
>> that will need to be re-written in Write Pro.
>> 
>> HTH,
>> 
>> Tom Benedict
>> 
>>> On Oct 29, 2019, at 07:17, Doug Hall via 4D_Tech <4d_tech@lists.4d.com>
>> wrote:
>>> 
>>> I have the very helpful Knowledge Base article and video for converting
>> to
>>> 4D Write Pro. 
>>> 
>>> I'm converting from a blob field, so in my particular case, I need to
>>> create an object field. In the video, it says you need to first convert
>> to
>>> version 7. How do I find out what version of 4D write I have? According
>> to
>>> the plugin file itself, I have version 15.6 build 15.222813. ?
>>> 
>>> Thanks!
>>> Doug
>>> 
>> 
>> 
> **
> 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
**

Re: Migrating to 4D Write Pro

[Doug Hall via 4D_Tech]

Actually, I *tried* to save my 4D Write letter -- both as a template and as
a file. My "letters" originate in blobs, in a table called [LtrTemplate].
From the input form of that record, I have the 4D Write area that displays
the letter's content. I use the 4D Write menu to select File:Save (or
File:Save As...) and instead of it actually doing this, I get an alert that
says the file has not been saved. What gives?

Thanks!

On Tue, Oct 29, 2019 at 1:18 PM Tom Benedict  wrote:

> Hi Doug,
>
> I’m pretty sure that the .4W7 format for 4D Write arrived long before v15,
> so you should be OK. You can confirm by creating a Write document on disk
> and seeing what extension is assigned.
>
> You can also validate your conversions by having both a Write Classic and
> a Write Pro area on a form so you can visually compare them. I found that
> built my confidence in the conversion process. Or course, you’ll need to be
> using a 32bit version of 4D to do this.
>
> Another this to keep in mind that the blobs may be compressed, and, if so,
> will need to be uncompressed prior to conversion.
>
> Other than that, WP New makes conversion pretty easy.
>
> You may already be aware, though, that if you are doing any custom
> configuration or formatting under program control in Write Classic, all of
> that will need to be re-written in Write Pro.
>
> HTH,
>
> Tom Benedict
>
> > On Oct 29, 2019, at 07:17, Doug Hall via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> > I have the very helpful Knowledge Base article and video for converting
> to
> > 4D Write Pro. 
> >
> > I'm converting from a blob field, so in my particular case, I need to
> > create an object field. In the video, it says you need to first convert
> to
> > version 7. How do I find out what version of 4D write I have? According
> to
> > the plugin file itself, I have version 15.6 build 15.222813. ?
> >
> > Thanks!
> > Doug
> >
>
>
**
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
**

Write Pro view mode

[Mitchell Shiller via 4D_Tech]

Thanks,

I had the old docs on my computer.

Mitch
**
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: Migrating to 4D Write Pro

[Tom Benedict via 4D_Tech]

Hi Doug,

I’m pretty sure that the .4W7 format for 4D Write arrived long before v15, so 
you should be OK. You can confirm by creating a Write document on disk and 
seeing what extension is assigned.

You can also validate your conversions by having both a Write Classic and a 
Write Pro area on a form so you can visually compare them. I found that built 
my confidence in the conversion process. Or course, you’ll need to be using a 
32bit version of 4D to do this.

Another this to keep in mind that the blobs may be compressed, and, if so, will 
need to be uncompressed prior to conversion. 

Other than that, WP New makes conversion pretty easy. 

You may already be aware, though, that if you are doing any custom 
configuration or formatting under program control in Write Classic, all of that 
will need to be re-written in Write Pro.

HTH,

Tom Benedict

> On Oct 29, 2019, at 07:17, Doug Hall via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> I have the very helpful Knowledge Base article and video for converting to
> 4D Write Pro. 
> 
> I'm converting from a blob field, so in my particular case, I need to
> create an object field. In the video, it says you need to first convert to
> version 7. How do I find out what version of 4D write I have? According to
> the plugin file itself, I have version 15.6 build 15.222813. ?
> 
> Thanks!
> Doug
> 

**
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: Cache flushing did not complete... best practice

[Jody Bevan via 4D_Tech]

For what it is worth, I second the recommendation by Jeff. We used mirrors from 
the day they were released many years ago. For critical data (like medical 
data), that just cannot be lost it is the way. 

It takes time to get the configuration you need figured out. There are 
different ways to handle this depending on how hot you want a recovery server. 
We needed as hot as we could get so here is what we did.

1. Have a second server with a complete backup on it of the data file.
2. The main server was set up to write the log files for the mirror consumption.
3. We wrote the log files to the local servers RAID 10 configuration (or RAID 5 
from way back when).
4. At set intervals the logs files where moved over to the backup server, where 
it imported in the log files.
This brings that server up to the moment of the last transaction in 
that log file.
5. The main server creates a new log file for the transactions.


There are many choices to be made in the configuration.
1. Where to write the log files for the mirror. As technology changed we 
changed where we wrote them to.
Considerations are:
- if you write to them over the network, what if the network is 
unavailable - your logs are no good.
- if you write them on a local volume of the main server, what if the 
mother board dies so you cannot access that last log file on the mirror server.
- you could write to a USB etc, volume mounted on the main server so 
that if  b occurs, you can physically move to the mirror server

All three of the above options have potential failures. Maintaining 
good equipment is therefore important.
Using RAID drives with hardware RAID provides good storage failsafe.

2. What intervals to have new log files be created and sent to the mirror server
This all depends on the volume of changes to the data file on your main 
server. Way back when we started, the OS file size limit was our limiting 
factor.

We had several sites with ~ 130 users with heavy data change patterns. We would 
be importing hundreds of thousands of lab results a day, plus required in 
datafile pre change versions of records, and
much more. At these sites we would have data files very large, and 
terabytes of data stored externally that they accessed.

Once you get all the mirror configuration figured out and tested, it was rock 
solid for us. Like everything testing the configurations, monitoring, and 
adjusting as necessary. We had a way
that if a log file was not consumed by the mirror, or still sitting on the main 
server when a second new log file was created an automated check would notify 
our support department. We 
learned to have a lot of automated notices sent to us. When your reputation is 
on the line to have reliable systems, I think it is critical to have automated 
tests and notifications. Then if
a problem does occur, you can know about it, and fix it before the client even 
knows there was a problem. 

NOTE: I got out of that business in 2013 when we were using 4D v12. I am not up 
to date on the latest mirroring configuration and issues. I suspect that what I 
have said above still holds true
to a large degree. Those that are using mirror in v16, v17 can correct where I 
am out of date.

Jody Bevan



> On Oct 28, 2019, at 11:06 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Or use a mirror. Highly recommended if the database is important...
> 
>> On Oct 28, 2019, at 12:59 PM, JPR via 4D_Tech <4d_tech@lists.4d.com> wrote:
>> 
>> The only 100% accurate way is to restart from the Backup file (made by 4D) 
>> and  integrate the current log file(s). This is the only way to be sure of 
>> the data integrity.
> 
> **
> 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
**

Migrating to 4D Write Pro

[Doug Hall via 4D_Tech]

I have the very helpful Knowledge Base article and video for converting to
4D Write Pro. 

I'm converting from a blob field, so in my particular case, I need to
create an object field. In the video, it says you need to first convert to
version 7. How do I find out what version of 4D write I have? According to
the plugin file itself, I have version 15.6 build 15.222813. ?

Thanks!
Doug
**
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
**

OPEN DATA FILE

[wangel--- via 4D_Tech]

I may be the only one who have tried using OPEN DATA FILE without knowing
how it works. But all the same I like to point out the following:

OPEN DATA FILE (MyDataFile) informs 4D to use MyDataFile. It then closes 4D
and start it up again. Simple enough. To avoid a loop (like in the On
Startup) OPEN DATA FILE must be inactivated after this first run. Several
ways to do that when you know how OPEN DATA FILE work.

Thanks for your patience Chip and Jeremy

Regards

Carl

 

**
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: MySQL connection from 4D

[Paul Dennis via 4D_Tech]

Ive been using pluggers MyConnect for years it just works. No need to mess
around with odbc.
Paul



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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: Cache flushing did not complete... best practice

[JPR via 4D_Tech]

Yes, very true. Thanks, Jeffrey, I forgot this one!

> Date: Mon, 28 Oct 2019 13:06:14 -0400
> From: Jeffrey Kain 
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Subject: Re: Cache flushing did not complete... best practice
> Message-ID: <259c18b2-ff04-4e84-bdbd-9828335b9...@gmail.com>
> Content-Type: text/plain; charset=us-ascii
> 
> Or use a mirror. Highly recommended if the database is important...
> 
>> On Oct 28, 2019, at 12:59 PM, JPR via 4D_Tech <4d_tech@lists.4d.com> wrote:
>> 
>> The only 100% accurate way is to restart from the Backup file (made by 4D) 
>> and  integrate the current log file(s). This is the only way to be sure of 
>> the data integrity.
> 

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