예제 #1
0
        static void Main(string[] args)
        {
            Console.WriteLine("Hello...");
            var setUp = new SetUp();

            Console.WriteLine("process starting");
            var ProgramPerams = new myProgramPerams();

            Console.WriteLine("Downloading and Importing Data");
            var import    = new ImportData(ProgramPerams);
            var alterData = new AlterData(import.ImportedData, ProgramPerams.RemovalStringsColumn,
                                          ProgramPerams.RemovalStringsColumn, ProgramPerams.DateColumn,
                                          ProgramPerams.DupsColumn);

            Console.WriteLine("creating new csv file for SharePoint List");
            var outputData = new OutputData(alterData.DataImport, ProgramPerams);

            try
            {
                Directory.Delete(ProgramPerams.DestDir, true);
            }
            catch (Exception x)
            {
                Console.WriteLine(x.Message);
            }
        }
예제 #2
0
 public ImportData(myProgramPerams p)
 {
     perams = p;
     Console.WriteLine("downloading file via vba urlmon c++ com utility");
     downloadFile();
     Console.WriteLine("pulling downloaded csv into memory");
     GetDataTableFromCsv();
 }
예제 #3
0
 public OutputData(DataTable dt, myProgramPerams p)
 {
     perams     = p;
     DataExport = dt;
     Console.WriteLine("creating the csv file");
     createCsvFile();
     Console.WriteLine("uploading the file into sharepoint via access");
     uploadFileToSharePoint();
 }