Welcome, Guest. Please Login or Register.
Sesame Forum


Need help getting started?!

Welcome, Guest. Please Login or Register.
Sep 6th, 2010, 8:22pm


Email Address


Note: Your email address will be used only to notify you of updates and events related to Lantica and Sesame. Your address will not be sold or used for any other purpose.



Pages: 1
Check if files exist (Read 237 times)
Amor
Full Member
Members
***


No personal text

Posts: 260
Check if files exist
Sep 25th, 2007, 6:09am
 
Hello!  
We place the medical laboratory reports our customers (physicians...) to download into mailbox.
So data to mailbox computer skillfully as ASCII file (C_DFU.ASC; V_DFU.ASC;E_DFU..) and from there the Files in the listing at the Server2003 (F:\iLab) is queried and processed by the MailBox(Unix server) In distance of 10 minutes are queried and processed and removed at the end.
 
when these files are deleted from the Folder F:\iLab, then we know that the laboratory reports for the customer stand ready.
 
My question: How  can i transfer this task a Sesame application.  
The operator does not need to go any longer to the server area and control it.  
My conception is:  From The Sesame - application muss come a akoustik/optical signal or both.
How can i realize this  simply.  
I would like to thank you for each suggestion or contribution.  
 
Dr. Belhareth
Back to top
 
« Last Edit: Sep 26th, 2007, 7:12am by Hammer »  

Dr. med. Amor Belhareth
Medizin Labor
Germany
Email   IP Logged
Hammer
YaBB Administrator
Lanticans
*****


Fire bad. Tree
pretty.

Posts: 2985
Re: Does Sesame DO know the JOB?
Reply #1 - Sep 25th, 2007, 6:24am
 
Sesame can transfer ASCII files and can run a process on a timed interval. To help further, we need you to clarify exactly what needs to happen.
Back to top
 
 

- Hammer
The plural of anecdote is not data.
WWW   IP Logged
Amor
Full Member
Members
***


No personal text

Posts: 260
Re: Does Sesame DO know the JOB?
Reply #2 - Sep 25th, 2007, 7:35am
 
Hello!  
I would like that each employee from the main menu application (our Sesame application) of SesameClient, which certainty gets that its ASCII file of mailbox is processed. So running to the server is void.  
 
That is perfectly if this message into a control file is automatically stored:
 e.g.. Entry the server DATE, server time and user ID.  
 
Thank you  again Erika.
 
Dr. Belhareth
 
Back to top
 
 

Dr. med. Amor Belhareth
Medizin Labor
Germany
Email   IP Logged
Hammer
YaBB Administrator
Lanticans
*****


Fire bad. Tree
pretty.

Posts: 2985
Re: Does Sesame DO know the JOB?
Reply #3 - Sep 25th, 2007, 3:19pm
 
OK, I'm going to take this one bit at a time until I understand what you need.
 
Quote:
We place the medical laboratory reports our customers (physicians...) to download into mailbox.

Are you saying that you check your email and the messages include lab reports?
Back to top
 
 

- Hammer
The plural of anecdote is not data.
WWW   IP Logged
Amor
Full Member
Members
***


No personal text

Posts: 260
Re: Does Sesame DO know the JOB?
Reply #4 - Sep 25th, 2007, 4:28pm
 
Hello Erika,
 
Each work-area  asked if his ASCII file is still in the Folder F:\iLab. That īs all.
 
Thanks.
 
Dr. Belhareth
Back to top
 
 

Dr. med. Amor Belhareth
Medizin Labor
Germany
Email   IP Logged
Hammer
YaBB Administrator
Lanticans
*****


Fire bad. Tree
pretty.

Posts: 2985
Re: Does Sesame DO know the JOB?
Reply #5 - Sep 25th, 2007, 5:23pm
 
Quote from Amor on Sep 25th, 2007, 4:28pm:
Hello Erika,

Each work-area asked if his ASCII file is still in the Folder F:\iLab. That īs all.

 
So, all you want to do is check if there are any files in the F:\iLab directory? Or do you want to see if a particular file is there?
Back to top
 
 

- Hammer
The plural of anecdote is not data.
WWW   IP Logged
Amor
Full Member
Members
***


No personal text

Posts: 260
Re: Does Sesame DO know the JOB?
Reply #6 - Sep 26th, 2007, 3:39am
 
Hello Erika,  
 
Everyone uses would like to know whether its file is still there.  
 
Thanks
 
Dr. Belhareth
Back to top
 
 

Dr. med. Amor Belhareth
Medizin Labor
Germany
Email   IP Logged
Hammer
YaBB Administrator
Lanticans
*****


Fire bad. Tree
pretty.

Posts: 2985
Re: Does Sesame DO know the JOB?
Reply #7 - Sep 26th, 2007, 7:01am
 
Try the FileExists() command.
Back to top
 
 

- Hammer
The plural of anecdote is not data.
WWW   IP Logged
Amor
Full Member
Members
***


No personal text

Posts: 260
Re: Does Sesame DO know the JOB?
Reply #8 - Sep 26th, 2007, 7:06am
 
Hello Erika,
 
i will try it.
 
Thanks.
Dr. Belhareth
Back to top
 
 

Dr. med. Amor Belhareth
Medizin Labor
Germany
Email   IP Logged
Pages: 1



Inside Sesame - The Monthly Newsletter for Sesame Database Manager
Read a FREE issue!