Custom windows service wont read from folder?

Question

0.00/5 (No votes)

See more:

I have created a windows service that activates at certain times of the day, to copy one file in a folder to another folder.
the filepaths:
Source: C:\\users\\bebe2011\\desktop\\excel
Destination: C:\\users\\bebe2011\\desktop\\newexcel
My code;

C#

protected override void OnStart(string[] args)
 {
     int hour = DateTime.Now.Hour;
     int minute = DateTime.Now.Minute;
     if (hour == 11 && minute == 40)
     {
         Copy_Excelfile_And_Paste_at_anotherloaction();
     }
 }

 protected override void OnStop()
 {
     Create_ServiceStoptextfile();
 }

 public static void Copy_Excelfile_And_Paste_at_anotherloaction()
 {
     try
     {
         string source = "C:\\users\\bebe2011\\desktop\\excels";
         string Destination = "C:\\users\\bebe2011\\desktop\\newexcel";
         string filename = string.Empty;
         if (!(Directory.Exists(Destination) && Directory.Exists(source)))
             return;
         string[] Templateexcelfile = Directory.GetFiles(source);
         foreach (string file in Templateexcelfile)
         {
             if (Templateexcelfile[0].Contains("Template"))
             {
                 filename = System.IO.Path.GetFileName(file);
                 Destination = System.IO.Path.Combine(Destination, filename.Replace(".xlsx", DateTime.Now.ToString("yyyyMMdd")) + ".xlsx");
                 System.IO.File.Copy(file, Destination, true);
             }
         }

     }
     catch (Exception ex)
     {
         Create_ErrorFile(ex);
     }

 }

What I have tried:

Im not quite sure what to do , because the ServiceStopTextFile is created in same folders with the status of the windows service?

Posted 10-Jun-16 1:22am

BEBE2011

Updated 10-Jun-16 6:52am

Add a Solution

Comments

F-ES Sitecore 10-Jun-16 7:24am

The Users folder is restricted so that only the owner account can access it. You'll need to run your service as an account that has access to the folder.

BEBE2011 10-Jun-16 7:30am

the service is run as Local System

BEBE2011 10-Jun-16 7:39am

The service is able to create a txt file -ServiceStopTextFile in the same folder?

ZurdoDev 10-Jun-16 8:23am

The error will tell you everything. What is it?

BEBE2011 10-Jun-16 8:56am

There is no error , the excel files just wont appear in the destination folder.

ZurdoDev 10-Jun-16 9:00am

You'll have to debug it then. Put the code in a console app and see what happens.
But your code writes to a file when there is an error. So, guess what, if you get an error trying to write the file and it jumps to your catch and then can't write to the error file, you'll never know about it.

Hermann Jung 10-Jun-16 12:29pm

Copy...()-method will be called when you start the service at 11:40 AM (hour == 11 && minute == 40). Create_ServiceStoptextfile always when the service stops.

U@007 13-Jun-16 8:30am

try to give full access/rights to the folder as well file and try again.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

xszaboj · Answer 1 · 2016-06-10T05:16:00

Solution 1

Try to debug your application, I know it is difficult with service. But it is possible.

Put this code into your main method

#if DEBUG
service.DebugMode();
Thread.Sleep(Timeout.Infinite);
#else
           
ServiceBase[] ServicesToRun;
ServicesToRun = new ServiceBase[] 
{ 
    service
};
ServiceBase.Run(ServicesToRun);       
#endif

and in your service you going to have DebugMode method:

public void DebugMode()
{
     this.OnStart(null);
}

and you can easily debug your service in VisualStudio in DEBUG mode.

here is a working example:
GitHub - xszaboj/debugWindowsService: simple solution how to debug windows service[^]

Posted 10-Jun-16 5:16am

xszaboj

Updated 13-Jun-16 1:32am

v2

Comments

BEBE2011 13-Jun-16 5:26am

Hi , thats for the possible solution, its coming back with this error?
"An object reference is required for the non-static field, method, or property "

xszaboj 13-Jun-16 5:54am

Hi, ok and on what line? Or better what piece of code?

BEBE2011 13-Jun-16 6:31am

Hi, when I declare DebugMode() in service.

xszaboj 13-Jun-16 7:33am

Hi, you can download simple demo from github that I setup ;).
Check Program.cs and Service1.cs

Richard Deeming · Answer 2 · 2016-06-10T06:52:00

Solution 2

I suspect the line:

C#

if (Templateexcelfile[0].Contains("Template"))

should be:

C#

if (file.Contains("Template"))

Otherwise, you'll only copying the files if the first file in the source folder contains the word "Template".

Posted 10-Jun-16 6:52am

Richard Deeming

Comments

BEBE2011 13-Jun-16 5:27am

Hi, Thanks for the possible solution, i have change the code to what you have recommended.