ProJob
Projob works as a windows service. You should install by command line.
Download the zip file and extract it to c:\projob folder.
Open Ini file and set FTP address where csv files located.
Set Connection string to connect DB.
*You should install SQL native connection driver if you will use it, or you can use ODBC, MDAC ... something like that.
Set Mail parameters to send report email after process.
ProJob works every hour and downloads csv files from ftp server, processes csv files, read every lines in csv files and insert them to sql table row by row. Sends an email after all process done.
Ini Parameter Details:
JobType=0
Default 0, don't change it.
LocalDir=C:\LOCAL\DOWNLOAD\DIRECTORY
Local location to download csv files from ftp.
FTP Parameters:
FtpHost=FTP.ADDRESS.COM.OR.IP
FtpUser=FTPUSERNAME
FtpPass=FTPPASS
FtpDir=
CSV Files in this FTP Directory, you should left empty this parameter if files are in the root folder.
FtpArchDir=/FTP/ROOT
After process CSV files will be move to this folder if the MoveToArch parameter is equal 1
MoveToArch=1
Move CSV files to FTPArchDir after process done, 1 is true, 0 is false
DelFromFTP=0
Delete CSV files after process done, 1 is true, 0 is false
Database Parameters
Define SQL Connection string like below.
ConnStr=Provider=SQLNCLI11;Persist Security Info=False;User ID=SQLUSER;Password=SQLPASS;Initial Catalog=SQLDB;Data Source=SQLSERVER;Initial File Name="";Server SPN=""
TableName=DATABASETABLENAME
Projob processes data and insert them to this SQL table
Mail Parameters
SendMail=1
Mail send for report, 1 is true, 0 is false
MailHost=MAIL.SERVER.COM.OR.IP
MailUser=MAILUSER@DOMAIN
MailPass=MAILPASSWORD
MailRcpt=MAILRCPT@DOMAIN
How to Install:
1- Run CMD as administrator and go to projob directory with “cd” command.
2- Type “projob.exe /install” and press enter.
3- You will see “Service installed successfully” like below, click “ok”.
4- You should see Projob windows service in services like below. You can start it.
How to Uninstall:
1- Run CMD as administrator and go to projob directory with “cd” command.
2- Type “projob.exe /uninstall” and press enter.
3- You will see “Service uninstalled successfully” like below, click “ok”.
4- You sould control removed service in services.