none
Autostart application after copied the file RRS feed

  • Question

  • I am using C# 4.5 and SQL Server 2014. I wrote a console application which takes 3 file names and folder which is defined in the app.config file and validates the data and imports the data in SQL Server.

    I have given FTP portal to the client, they upload the data and informed me then manually I am running my exe file then data is importing. But I want an automatic process like once the client uploads 3 files in folder my console application auto start.

    I thought of using FileSystemWatcher, but here problem is that if put file watcher to folder, create file event, I am getting event when the file is created, this will not work because I need the event when 3 files copied successfully.

    This is my app.config file

    <appSettings>
        <add key="SourceFolder" value="E:\UploadData" />
        <add key="ArchiveFolder" value="E:\UploadData\Archive" />
        <add key="LogFile" value="E:\UploadData\LogFile" />
    
        <add key="DisbursementFile" value="xxx_DISB.csv" /> 
        <add key="EmployeeFile" value="xxx_EMP.csv" />
        <add key="AmountFile" value="xxx_AMT.csv" />
    </appSettings>


    Thanks Best Regard Naweez

    Monday, December 16, 2019 7:37 AM

All replies