Thanks for the tip, Bruce - I now realise how lucky I must have been:
before I retired, this backup system was used for approx. 10 years on
about 30 POS-systems, in different holiday resorts all over France!
The backup files were sent weekly by mail to the company HQ in
Aix-en-Provence, where they were un-ziped and used for control purposes. I
never even thought (nor noticed) that the backup-files might have been
corrupted.
Anyhow, my DP-POS system is now abandoned, me being retired and the new
IT-manager being a 100% so-called "modern" Micro$oft-made man!
:) Geert.
On Wed, 20 Jun 2018 19:09:15 +0200, Ed Marfil, MAST UNITED
<[email protected]> wrote:
Yup, I did notice that as it did happen to me once (corrupted database
due to I suppose we can call it incomplete transactions). >We have
users on travel abroad in different time zones that may be logged in at
any time. Thus, I only use the export to log >function as it won’t let
me back up if someone is still logged in and potentially still updating
data. Usually though they are on >their laptops in another program but
still have the DP database open in the background (for lookup).
Anyway, after hearing from the experts here it doesn’t seem like there
is a direct way to kick them out from just the DP >application. Maybe I
will enforce what Tim suggested (penalizing the offenders) just probably
not in fines as that might bring >about an EDD or Labor board dispute.
Thanks all for the suggestions.
Ed.
From: Dataperf [mailto:[email protected]] On Behalf Of
Bruce Conrad
Sent: Wednesday, June 20, 2018 9:04 AM
To: DataPerfect Users Discussion Group <[email protected]>
Subject: Re: [Dataperf] Forced log-out?
Be careful when making a copy of all the database files, at least while
there is a chance someone >is making changes in DP. At WP one
development group made nightly copies of their issues database >(because
they were afraid of losing things) but when they tried restoring from
the copies, there >was corruption (so their fear actually was realized
by their actions). This led to us writing the >backup utility, which
gets around this some way (I don't remember the details).
The problem comes when say, 1) a user has added a detail record to panel
one, then 2) your copy is >done, then 3) keep-a-total modifies a record
in panel two. Problem: your copy now has an incorrect >total.
On Tue, Jun 19, 2018 at 11:20 AM, <[email protected]> wrote:
Hi all,
I used to make fully automised daily backups of several DP POS-systems,
'avoiding' the problem of >>logged-in users by making a *copy* of the
DataBase-files in a temporary folder first, and then >>backing up that
temporary folder and delete it afterwards.
No need to log-off users, copying the files will work anyhow...
:) Geert
On Tue, 19 Jun 2018 18:59:20 +0200, Tim Rude <[email protected]>
wrote:
Another idea:
On the machine that hosts the database files, use Computer Management
to close the open database >>>files that errant users have left open.
It won't actually shut down DP on their computer, but >>>when they
come back and try to use it they'll get an error message and have to
exit. They can >>>then re-run DP and be back to normal.
Tim Rude
On 6/19/2018 10:49 AM, Ed Marfil, MAST UNITED wrote:
Hello Peter,
Thank you for the reply. Interesting that you use it for transport
management. I use it for the >>>>same; inventory and shipping
management.
Anyway, I was hoping I could disconnect the user solely from the DP
application or database but >>>>not from the server.
Currently I have to remote log-in to the suspect station and properly
log it out. Unfortunately >>>>sometimes there are multiple suspects.
Regards,
Ed.
PS: please know that I feel bad that NL is not in this cup. Just
doesn’t seem right without >>>>them and Italy.
From: Dataperf [mailto:[email protected]] On Behalf Of
Peter Boekestijn
Sent: Tuesday, June 19, 2018 6:29 AM
To: [email protected]
Subject: Re: [Dataperf] Forced log-out?
Hi Ed,
It happens to me quit often with approx 40 users working every day in
our transport management >>>>application.
We work on a window server with terminal servers
I work as follow:
- Remove all *.tmp files (3 per user)
- Some of them remain because of incorrect log-out
- I get the names of those users from the files attributes
- Next step is to log out those users from the server
- Final step to remove the remaining *.tmp files
Success
Peter
Van: Dataperf [mailto:[email protected]] Namens Ed
Marfil, MAST UNITED
Verzonden: maandag 18 juni 2018 02:54
Aan: [email protected]
Onderwerp: [Dataperf] Forced log-out?
I back up my DP database regularly at off hours when it is supposed
to be inactive. However, >>>>there are times when it fails because a
user forgot to log-out of the database.
I was wondering if there is a way to forcibly eject users from the
database.
Thanks,
Ed.
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
[Image removed by sender.]
Garanti sans virus. www.avast.com
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel
antivirus Avast.
https://www.avast.com/antivirus
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
