コード例 #1
0
ファイル: Program.cs プロジェクト: Neil19533/Excel2FuturePro
        static void Main(string[] args)
        {
            var converter = new E2FP.Tpl.TemplateConverter();
            var csvLoader = new E2FP.CSVLoader.CSV();


            string InFolder  = @"C:\Template\In\";
            string OutFolder = @"C:\Template\Out\";
            string templates = @"C:\Template\Templates\";


            var InputTemplateHeaders  = csvLoader.ParseFile(templates + "input.csv");
            var OutputTemplateHeaders = csvLoader.ParseFile(templates + "output.csv");
            var ConverterTemplate     = csvLoader.ParseFile(templates + "converter.csv");


            converter.InputHeaders  = InputTemplateHeaders[0].ToArray();
            converter.OutputHeaders = OutputTemplateHeaders[0].ToArray();

            E2FP.Tpl.Template template = new E2FP.Tpl.Template();

            template.Populate(ConverterTemplate);

            converter.TemplateConvert = template;


            foreach (var InputFile in System.IO.Directory.GetFiles(InFolder))
            {
                var inputfile = csvLoader.ParseFile(InputFile);

                converter.Data = inputfile;

                converter.convert();

                csvLoader.SaveCSV(converter.Output, OutFolder + System.IO.Path.GetFileNameWithoutExtension(InputFile) + DateTime.Now.TimeOfDay.ToString("mmssfff") + ".csv");
            }


            FtpWebRequest request = (FtpWebRequest)WebRequest.Create(@"ftp://innox.co.uk:21");

            request.Method = WebRequestMethods.Ftp.UploadFile;

            request.Credentials = new NetworkCredential("neil", "123456");

            foreach (var item in System.IO.Directory.GetFiles(OutFolder))
            {
                StreamReader sourceStream = new StreamReader(item);
                byte[]       fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());
                sourceStream.Close();

                request.ContentLength = fileContents.Length;

                Stream requestStream = request.GetRequestStream();
                requestStream.Write(fileContents, 0, fileContents.Length);
                requestStream.Close();

                FtpWebResponse response = (FtpWebResponse)request.GetResponse();
                response.Close();
            }
        }
コード例 #2
0
ファイル: Template.cs プロジェクト: Neil19533/Excel2FuturePro
        /// <summary>
        /// Load a template from CSV
        /// </summary>
        /// <param name="Filename">File to load.</param>
        public void Load(string Filename)
        {
            CSV loader = new CSV();

            var TemplateTable = loader.ParseFile(Filename);

            Populate(TemplateTable);
        }
コード例 #3
0
ファイル: Program.cs プロジェクト: Neil19533/Excel2FuturePro
        static void Main(string[] args)
        {
            var converter = new E2FP.Tpl.TemplateConverter();
            var csvLoader = new E2FP.CSVLoader.CSV();

            string InFolder = @"C:\Template\In\";
            string OutFolder = @"C:\Template\Out\";
            string templates = @"C:\Template\Templates\";

            var InputTemplateHeaders = csvLoader.ParseFile(templates + "input.csv");
            var OutputTemplateHeaders = csvLoader.ParseFile(templates + "output.csv");
            var ConverterTemplate = csvLoader.ParseFile(templates + "converter.csv");

            converter.InputHeaders = InputTemplateHeaders[0].ToArray();
            converter.OutputHeaders = OutputTemplateHeaders[0].ToArray();

            E2FP.Tpl.Template template = new E2FP.Tpl.Template();

            template.Populate(ConverterTemplate);

            converter.TemplateConvert = template;

            foreach (var InputFile in System.IO.Directory.GetFiles(InFolder))
            {

                var inputfile = csvLoader.ParseFile(InputFile);

                converter.Data = inputfile;

                converter.convert();

                csvLoader.SaveCSV(converter.Output, OutFolder + System.IO.Path.GetFileNameWithoutExtension(InputFile)+DateTime.Now.TimeOfDay.ToString("mmssfff")+".csv");

            }

            FtpWebRequest request = (FtpWebRequest)WebRequest.Create(@"ftp://innox.co.uk:21");
            request.Method = WebRequestMethods.Ftp.UploadFile;

            request.Credentials = new NetworkCredential("neil", "123456");

            foreach (var item in System.IO.Directory.GetFiles(OutFolder))
            {
                StreamReader sourceStream = new StreamReader(item);
                byte[] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());
                sourceStream.Close();

                request.ContentLength = fileContents.Length;

                Stream requestStream = request.GetRequestStream();
                requestStream.Write(fileContents, 0, fileContents.Length);
                requestStream.Close();

                FtpWebResponse response = (FtpWebResponse)request.GetResponse();
                response.Close();
            }
        }
コード例 #4
0
        public TemplateConverter()
        {
            CsvLoader = new CSV();

            //load input file.
            //CsvLoader.ParseFile(inputFilename);

            // validate input headers.
            validateHeaders();

            //Load templatecnverter
            //TemplateConvert.Load(convertTemplate);

            // convert
            //convert();
        }