[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

PLease: I need program which moves files from one directory to another and renames each file to a unique name before placing it to another directory I m handling csv files.

PLease:  I need program which moves files from one directory to another and renames each file to a unique name before placing it to another directory I m handling csv files.

Files that come in directory where they shoudl be moved from have 10 or more caracters xxxxxxxxxxxxxx.csv  and when they are moved they should be assigned a unique file name of max 8 caracters. Pelase help.
0
dm98101
Asked:
dm98101
  • 3
  • 2
1 Solution
 
Fernando SotoCommented:


Imports System.IO

    Private Sub Button1_Click(ByVal sender As System.Object, _
        ByVal e As System.EventArgs) Handles Button1.Click

        ' Test the MoveFiles function
        MoveFiles("C:\Temp", "C:\Temp\TempData")

    End Sub

    Private Sub MoveFiles(ByVal SourceDir As String, ByVal DestDir As String)

        If Not Directory.Exists(SourceDir) Then
            MessageBox.Show("Source directory does not exist, correct and try again", _
                "Source Directory Error")
            Return
        End If

        If Not Directory.Exists(DestDir) Then
            Dim results As DialogResult
            results = MessageBox.Show("Destination directory does not exist." & _
                " Do you want to create it " & vbCrLf & DestDir, _
                "Destination Directory Error", MessageBoxButtons.YesNo, _
                MessageBoxIcon.Error, MessageBoxDefaultButton.Button2)
            If results = Windows.Forms.DialogResult.Yes Then
                Directory.CreateDirectory(DestDir)
            Else
                Return
            End If
        End If

        Dim Count As Integer = 1    ' Used to make file name unique
        Dim di As New DirectoryInfo(SourceDir)
        Dim fi() As FileInfo = di.GetFiles("*.csv")
        For Each f As FileInfo In fi
            ' The moved file will have the name, the time it was done as hhmmss format
            ' plus - plus the value of count
            File.Move(f.FullName, DestDir & "\" & Now.ToString("hhmmss") & "-" & _
                Count.ToString & ".csv")
            Count += 1
        Next

    End Sub


Fernando
0
 
dm98101Author Commented:
how to generate this code in to one exe file?????
0
 
dm98101Author Commented:
is this monitoring when files are written in source directory ansd pickes them up ???? or?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Fernando SotoCommented:
Hi dm98101;

To your question, "how to generate this code in to one exe file?????", I guess my next question should be; Are you a programmer?

To your question, "is this monitoring when files are written in source directory ansd pickes them up ???? or?", The above code just moves the files from a source directory to a target directory and checks to see if the directories exist and assignes the moved file a unique name.

Fernando
0
 
saintsairforceCommented:

Here is an updated program    

import java.io.*;
import java.io.File;
import javax.swing.*;
import javax.swing.filechooser.*;

/*******************************************************************************
     loadHTML(String)
     
     This loads html files into the home directory
     *******************************************************************************/
     private void loadCSV(String home)
     {
          String fileDiscription="";
          File intputFile,outputFile;
         
          getFiles();
         
          if(cancelFlag!=JFileChooser.CANCEL_OPTION)
          {
               for(int knt=0;knt<selectedFiles.length;knt++)
               {
                    intputFile = new File(directory+"\\"+selectedFiles[knt]);          //sets the location of the input file

                         String outFile="xxxxxxxxxx";
                          while(outFile.length>8)
                       {
                               //outFile = get the file name from the user
                               //check that outFile endsWith .csv
                     }
                    outputFile = new File(home+outFile);                         //sets the location of the output file
                   
                    try
                    {    
                         copyFile(intputFile,outputFile,home);
               }
                    catch(IOException e)
                    {
                         JOptionPane.showMessageDialog(null,"Unable to upload "+selectedFiles[knt],"ERROR",JOptionPane.ERROR_MESSAGE);
                    }
               }
          }
     }
     
     /*******************************************************************************
     getFiles()
     
     This opens a JFileChooser and allows the user to browse their computer for files.
     *******************************************************************************/
     
     private void getFiles()
     {
          JFileChooser chooser = new JFileChooser();

          chooser.setAcceptAllFileFilterUsed(false);               //does not allow user to use the AllFiles type option.
          chooser.addChoosableFileFilter(new csvFilter());     //filters selection to only allow html and htm files
          chooser.setMultiSelectionEnabled(true);                //Allows the user to select multiple files

          try     //this sets the look and feel of the file chooser to the currently selected look and feel
          {
               UIManager.setLookAndFeel(UserMenu.looks[UserMenu.lookNumber].getClassName());
               SwingUtilities.updateComponentTreeUI(this);
          }
          catch(Exception e)
          {
               new ErrorLogger("Error getFiles() - fileLoader.java:    "+e);
          }
         
          cancelFlag = chooser.showOpenDialog(this);
         
          directory = (chooser.getCurrentDirectory()).toString();     //gets the current directory
         
          File tempFiles[] = chooser.getSelectedFiles();
         
          selectedFiles = new String[tempFiles.length];
         
          for(int knt=0;knt<tempFiles.length;knt++)
          {
               selectedFiles[knt] = tempFiles[knt].getName();
          }
     }

/*******************************************************************************
     copyFile(File, File, String)
     
     This method copies the input file to the selected output directory.
     *******************************************************************************/
     
     public void copyFile(File inputFile, File outputFile, String directory) throws IOException
     {
          if((new File(directory).mkdir()));           //creates home directory if needed
         
          InputStream inStream = new FileInputStream(inputFile);
          OutputStream outStream = new FileOutputStream(outputFile);
         
          byte[] buffer = new byte[1024];
          int length;
         
          while ((length = inStream.read(buffer)) > 0)
          {
               outStream.write(buffer, 0, length);
          }
         
          inStream.close();
          outStream.close();
     }

//Another Class to filter out the csv files

import java.io.File;
import javax.swing.*;
import javax.swing.filechooser.*;

public class csvFilter extends FileFilter
{
     /*******************************************************************************
     accept(File)
     
     This filters out files and only allows htm and html files to be selected
     *******************************************************************************/
     
     public boolean accept(File file)
     {
          if (file.isDirectory())
               return true;

          String extension = getExtension(file);
         
          if (extension != null)
          {
               if (extension.equals("csv")&&(file.toString()).length()>=14) //10+.csv
                    return true;
               else
                    return false;
          }
          return false;
     }
     
     /*******************************************************************************
     getDescription()
     
     This returns the discription of the available files
     *******************************************************************************/
     
     public String getDescription()
     {
          return ".htm, .html";
     }
     
     /*******************************************************************************
     getExtension(File)
     
     This returns the extension of a file
     *******************************************************************************/
     
     private String getExtension(File file)
     {
               String ext = null;
               String name = file.getName();
               int index = name.lastIndexOf('.'); //finds the index of the '.' thus any data after this is the extension
               
               if(index>0&&(index<name.length()-1))
               {
                    ext = name.substring(index+1).toLowerCase(); //this gets the extension characters
               }
               
               return ext;
     }
}

As for deleting the file go to this link for a simple example http://javaalmanac.com/egs/java.io/DeleteFile.html
0
 
Fernando SotoCommented:
Hi Bob;

I would like to see a resolution to this question because I have posted a working solution to the question.

Fernando
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now