|
Home > Archive > Programming with dBASE > February 2006 > Runing Plus app in background
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Runing Plus app in background
|
|
|
| I have the need to use a program that would check for the existence of a file, and if found, upload the data into a local table. This checking would need to be set to occur continuously, or to occur at specified times of the day.
I thought I would create the program and install it as an application that starts whenever the workstation is booted up. My concern is whether anyone thinks a plus app always running like that could cause a slow down on the workstation or other problems.
For example, I imagine any attempt to restart the workstation would lead to windows notifying the user that this app is still running and do they wish to end it now. This could be disconcerting to the user and, if the upload were in progress, could damag
e open tables I imagine.
It would be nice to run this as a thread inside my app, but my understanding is that plus does not handle multithreading.
Any comments or suggestions would be appreciated.
Thanks,
Rick
| |
| Robert Bravery 2006-02-28, 8:25 pm |
| HI
All depends on what processing youre doing.
I have a similar thing running on our web server, watching a folder that
clients upload csv type files to,
It imports these files into a tables, then runs through a huge import
routine
So, you could use a timer object
Import the data intoa table, when your process is finnished, delete each
record the table that has finnished the process. If the user closes the app,
you could check the table, and carry on from where you left
I set my timer to an hour, because we don't need to check more than that.
Robert
"Rick" <Sportman7@netzero.com> wrote in message
news:CEWRlQ8OGHA.1148@news-server...
> I have the need to use a program that would check for the existence of a
file, and if found, upload the data into a local table. This checking would
need to be set to occur continuously, or to occur at specified times of the
day.
>
> I thought I would create the program and install it as an application that
starts whenever the workstation is booted up. My concern is whether anyone
thinks a plus app always running like that could cause a slow down on the
workstation or other problems.
>
> For example, I imagine any attempt to restart the workstation would lead
to windows notifying the user that this app is still running and do they
wish to end it now. This could be disconcerting to the user and, if the
upload were in progress, could damage open tables I imagine.
>
> It would be nice to run this as a thread inside my app, but my
understanding is that plus does not handle multithreading.
>
> Any comments or suggestions would be appreciated.
>
> Thanks,
> Rick
>
| |
| Paul Van House 2006-02-28, 8:25 pm |
| In article <CEWRlQ8OGHA.1148@news-server>, Sportman7@netzero.com says...
> I have the need to use a program that would check for the existence of a file, and if found, upload the data into a local table. This checking would need to be set to occur continuously, or to occur at specified times of the day.
>
If you want to do the "timer" aspect outside of Plus, Make your update
utility a self-standing Excutable and use the Windows Scheduler to have
it run. You can define multiple run times based on hour, day of week,
weekday, and so on.
I have a few of these running on the server that hosts the applications
tables.
--
Paul Van House
remove ".removeme" for e-mail replies
Radio/TV Software and Baseball Stat Software:
http://www.binxsoftware.com
Family Home Page: http://vanhouse.binxsoftware.com
Church Home Page: http://www.ashfordumc.org
| |
| Dan Barbaria 2006-02-28, 8:25 pm |
|
"Paul Van House" <pvanhouse1.removeMe@houston.rr.com> wrote in message
news:MPG. 1e6d1ecffd31fcc89896
c9@news.dbase.com...
> utility a self-standing Excutable and use the Windows Scheduler to have
> it run. You can define multiple run times based on hour, day of week,
> weekday, and so on.
That is how I do it.
I have Windows Scheduler run a small dbase app every 3 minutes on our
webserver (as well as many one-a-day maintenance apps). It's purpose is to
send email to customers based on requests made. In most cases the email is
sent right away but if the mail server is down or rejects the attempt the
email is put in a local queue. The app the runs every 3 minutes continues to
attempt the email until it gets sent.
There is a catch to not send email if the mail server rejects the email
address. This rejection is added to a log and use the log to resolve the
issue with a bad email address.
Dan Barbaria
| |
|
| Paul,
Ah, I see. Then the plus app would not be running continuously, but rather Windows would just run the plus app every 1 hour. Yes, I think I like that better.
Will have to look into windows scheduler.
Thanks,
Rick
Paul Van House Wrote:
> In article <CEWRlQ8OGHA.1148@news-server>, Sportman7@netzero.com says...
>
>
> If you want to do the "timer" aspect outside of Plus, Make your update
> utility a self-standing Excutable and use the Windows Scheduler to have
> it run. You can define multiple run times based on hour, day of week,
> weekday, and so on.
>
> I have a few of these running on the server that hosts the applications
> tables.
>
> --
> Paul Van House
> remove ".removeme" for e-mail replies
> Radio/TV Software and Baseball Stat Software:
> http://www.binxsoftware.com
> Family Home Page: http://vanhouse.binxsoftware.com
> Church Home Page: http://www.ashfordumc.org
| |
|
| Robert,
Yes, that is similar to what I need. I like the idea of using windows scheduler rather than running the plus app continously with a timer, tho I suppose either would work.
Cool idea how you track the process so you can pick up where you left off.
Thanks again,
Rick
Robert Bravery Wrote:
> HI
> All depends on what processing youre doing.
> I have a similar thing running on our web server, watching a folder that
> clients upload csv type files to,
> It imports these files into a tables, then runs through a huge import
> routine
> So, you could use a timer object
> Import the data intoa table, when your process is finnished, delete each
> record the table that has finnished the process. If the user closes the app,
> you could check the table, and carry on from where you left
> I set my timer to an hour, because we don't need to check more than that.
>
> Robert
>
> "Rick" <Sportman7@netzero.com> wrote in message
> news:CEWRlQ8OGHA.1148@news-server...
> file, and if found, upload the data into a local table. This checking would
> need to be set to occur continuously, or to occur at specified times of the
> day.
> starts whenever the workstation is booted up. My concern is whether anyone
> thinks a plus app always running like that could cause a slow down on the
> workstation or other problems.
> to windows notifying the user that this app is still running and do they
> wish to end it now. This could be disconcerting to the user and, if the
> upload were in progress, could damage open tables I imagine.
> understanding is that plus does not handle multithreading.
>
>
| |
|
| Dan,
Thanks. Good ideas. I think I prefer using Windows scheduler as well.
Rick
Dan Barbaria <daniel.barbaria at ops.org> Wrote:
>
> "Paul Van House" <pvanhouse1.removeMe@houston.rr.com> wrote in message
> news:MPG. 1e6d1ecffd31fcc89896
c9@news.dbase.com...
>
> That is how I do it.
>
> I have Windows Scheduler run a small dbase app every 3 minutes on our
> webserver (as well as many one-a-day maintenance apps). It's purpose is to
> send email to customers based on requests made. In most cases the email is
> sent right away but if the mail server is down or rejects the attempt the
> email is put in a local queue. The app the runs every 3 minutes continues to
> attempt the email until it gets sent.
>
> There is a catch to not send email if the mail server rejects the email
> address. This rejection is added to a log and use the log to resolve the
> issue with a bad email address.
>
> Dan Barbaria
>
>
| |
|
| Dan,
Another question, what are you using to send the emails form in dbase?
Thanks,
Rick
Dan Barbaria <daniel.barbaria at ops.org> Wrote:
>
> "Paul Van House" <pvanhouse1.removeMe@houston.rr.com> wrote in message
> news:MPG. 1e6d1ecffd31fcc89896
c9@news.dbase.com...
>
> That is how I do it.
>
> I have Windows Scheduler run a small dbase app every 3 minutes on our
> webserver (as well as many one-a-day maintenance apps). It's purpose is to
> send email to customers based on requests made. In most cases the email is
> sent right away but if the mail server is down or rejects the attempt the
> email is put in a local queue. The app the runs every 3 minutes continues to
> attempt the email until it gets sent.
>
> There is a catch to not send email if the mail server rejects the email
> address. This rejection is added to a log and use the log to resolve the
> issue with a bad email address.
>
> Dan Barbaria
>
>
|
|
|
|
|