How to organize the copied text file from the other server to our server in by daily folder, weekly folder or by date folder in c#

Question

0.00/5 (No votes)

See more:

How to organize the copied text file from the other server to our server that will be saved in by daily folder, weekly folder or by date folder.

Below is my code on copying files from the other computer. But I need to organize the copied text files in the folder by daily,weekly and by date.

Please help. Thank you and God bless.. - Jess

// Here's the program in c#

C#

using System;
using System.IO;

class Test 
{
    public static void Main() 
    {
        Copier();
    }

    // Method Copier
    public static void Copier()
    {
        File.Copy(@"\\193.35.208.17\con_d_MeanAct_Inst\201102\
                    sample-data.txt", @"c:\sonix\sample-newdata.txt");

        Console.ReadKey();

    }
}

Posted 3-Feb-11 13:47pm

Silver Lightning

Updated 3-Feb-11 14:09pm

Henry Minute

v2

Add a Solution

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)

Henry Minute · Answer 1 · 2011-02-03T14:23:00

Solution 2

Something like this should do:

C#

// Method Copier
public static void Copier()
{
  string sourceFile = @"\\193.35.208.17\con_d_MeanAct_Inst\201102\sample-data.txt";
  string dir = Path.GetDirectoryName(sourceFile);
  string[] parts= dir.Split('\\');
  string destPath = Path.Combine(@"C:\WhereverYouWant\", parts[parts.Length - 1]);
  if (!Directory.Exists(destPath))
  {
    Directory.CreateDirectory(destPath);
  }
  string destFile = Path.Combine(destPath, @"\newData.txt");
  File.Copy(sourceFile, destFile);
}

Modified to ensure that destination exists.

Posted 3-Feb-11 14:23pm

Henry Minute

Updated 3-Feb-11 14:30pm

v2

Comments

Silver Lightning 3-Feb-11 20:30pm

Hi Sir Henry,
Thanks for the answer but, how could I organize and determine the text files to be copied in by weekly and daily to be saved in particular folder?

Henry Minute 3-Feb-11 20:36pm

Well, if you don't know how they are organized, how can I know?

From the code you posted it looks as if the source directory name consists of the 4 digit year combined with the 2 digit month. Is that all there is to it? Or are they sometimes somewhere else?

How are the destination folders supposed to be organized? Only you know that and you haven't said.

Henry Minute 3-Feb-11 20:58pm

If it helps you, you can get strings for the destination folder names like this:
string monthDirName = DateTime.Now.ToString("yyyyMM"); // gives "201102"
string dayDirName = monthDirName + Path.Combine(@"\", DateTime.Now.ToString("dd")); // gives "201102\04"

Silver Lightning 3-Feb-11 21:03pm

Opps sorry sir Henry. Your code really helps me. Can I ask one more? how can I or What would I use to automate this program just like an scheduler program that would get this text files daily? sorry for disturbing you sir, just I need it urgent. (just give a sample or pattern code for this in c#. Thank you and God bless =)

Henry Minute 3-Feb-11 21:09pm

Well there is always the Windows Task Scheduler, which comes with many editions of Windows.
Look here: http://www.iopus.com/guides/winscheduler.htm

Or there are many other alternatives. Do an internet search on "windows scheduler" (without the quotes). That will get you lots of suggestions like:
http://www.splinterware.com/products/wincron.htm.

Some will be free, some at a cost.

Silver Lightning 3-Feb-11 21:16pm

Thanks you sir. :)

fjdiewornncalwe 3-Feb-11 21:18pm

Well done, Sir Henry!!! (I like that one, I'll have to use it once in a while...:) )

Silver Lightning 13-Feb-11 19:24pm

Good day Sir Henry,
Do you have any idea or sample code in C# on how could I revise or update this code in converting text file to excel in proper format (with header and proper column)? the code below converts text file to excel file but I need the clear output in excel file in a standard format by column. Here's the sample text file data input and my code.

Here's my sample text file: (fixed space)

tag ord_no ref_no prog_no prog_date acv_type_id
--- ------- ------- ---------- ------------------- -----------
DL 6636500 1 11 Feb 3 2011 11:11AM DLINSTLN
DL 6649978 1 8 Feb 4 2011 12:29PM DLINSTLN
DL 6722809 1 3 Feb 2 2011 5:35PM DLINSTLN

Here's my sample code below sir:

private void Convert_TextFile_To_ExcelFile()
{
// Open the text file in Excel.
m_objExcel = new Microsoft.Office.Interop.Excel.Application();
m_objBooks = (Microsoft.Office.Interop.Excel.Workbooks)m_objExcel.Workbooks;
m_objBooks.OpenText(m_strSampleFolder + "sampledoc.txt",
Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, 1,
Microsoft.Office.Interop.Excel.XlTextParsingType.xlDelimited,
Microsoft.Office.Interop.Excel.XlTextQualifier.xlTextQualifierDoubleQuote,
false, true, false, false, false, false, m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objBook = m_objExcel.ActiveWorkbook;
// Save the text file in the typical workbook format and quit Excel.
m_objBook.SaveAs(m_strSampleFolder + "sampledoc.xls",
Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal,
m_objOpt, m_objOpt, m_objOpt, m_objOpt,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objBook.Close(false, m_objOpt, m_objOpt);
m_objExcel.Quit();

Henry Minute 13-Feb-11 19:46pm

Sorry jesurino, I don't do very much with Excel so I am unable to help. There are lots here who do though, so why not post your problem as a new question. I'm sure you'll get lots of help. :)

Silver Lightning 13-Feb-11 19:51pm

Ok sir thank you very much. :)

Silver Lightning 13-Feb-11 20:32pm

Hi Sir Henry, can ask sample code on how to get the fixed space delimited text file (as a sample above text file) and and store it on the array loop? so that I could manipulate every field. Thanks in advance sir.

Henry Minute 14-Feb-11 5:56am

Take a look at this article: http://www.codeproject.com/KB/database/filehelpers.aspx
Download the code, and I think that you will find the solution to both of your problems.

If you have more difficulties with the task you are currently undertaking you should ask them as a new question.

Silver Lightning 17-Feb-11 0:03am

Hi Sir Henry,
Do you have any idea on how could I update this code? here's link. No one wants to answer my question (except the developer ramalinga). Please help me. Thanks

http://www.codeproject.com/Answers/158126/Need-a-sample-code-on-how-to-use-the-excel-autofit.aspx#answer1

vlad781 · Answer 2 · 2011-02-03T13:57:00

Solution 1

well, once its downloaded where is it saved?on the application, or on the computer? And do you have some sort of GUI?

Posted 3-Feb-11 13:57pm

vlad781

Updated 3-Feb-11 13:58pm

v2

Comments

Henry Minute 3-Feb-11 20:10pm

The OPs code shows you where it is copied. Why ask?

vlad781 3-Feb-11 20:19pm

Well, depending on where he wants to organize the files. Whether its directly on the computer or within the application.

fjdiewornncalwe 3-Feb-11 21:19pm

What do you mean by "within the application"?

vlad781 4-Feb-11 18:01pm

whether the application will save files to itself or the computer.