A windows service to import a CSV file and apply to a MS-SQL database table
$100-120 USD
Berlangsung
Dibuat hampir 12 tahun yang lalu
$100-120 USD
Dibayar ketika dikirim
A windows service to import a CSV file and apply to a MS-SQL database table
it should be written in vb.net
This project requires a service to run under windows to carry out two CSV file imports
the first is to pick up a csv file of permenant staff, delete all of the staff records from a SQL database and replace them with the contents of the CSV file.
this file is only sent once a day at 09:00. The file should be renamed to indicate that it has been processed.
We are only processing the staff number, firstname, lastname and mobile phone number, as well as hard coding a "group number" into the table
the second part is to pick up a csv file of visitors, and from the data within the file, decide to add, leave alone, or delete the visitor records from the database.
so if there is a visitor in the csv file and not in the table, with an arrival time but no departure time, it should be added to the table
if there is a visitor in the csv file and in the table, with an arrival time, but no departure time, it should remain in the table
if there is a visitor in the csv file with an arrival and departure time, it should be deleted from the table
this file is sent every hour on the hour. The file should be renamed to indicate that it has been processed.
We are only processing the visitor number, firstname, lastname and mobile phone number, as well as hard coding a "group number" into the table
the service should create/append a log file with the date/time and number of records added/edited/deleted.
the service should be driven from a config file with database connection parameters and a settings section which will be copied exactly into the output file.
the service should be installed froma [login to view URL] and be able to install as a service.