Windows utility to generate CSVs from data returned by SQL Query (provided)
£20-250 GBP
Paid on delivery
Project reposted with more meaningful title.
Requirement is for a simple Windows utility to run a (provided) SQL query against a Microsoft SQL Server database, and dump the resulting data to .csv
Utility will prompt the user for two things:
1) a date range – beginning and end dates, with the end date defaulting to 'yesterday'. Start date should load from xml config file, using the 'end date' from the previous time the utility was run
2) checkboxes for what departments to run the query against – '1000', '2000', etc up to '9000'. Default should be loaded from xml config file (user may select/deselect if needed)
When user clicks 'create' button, utility will connect to database and run the query, once for each department, and create a .csv for each execution. Query looks like:
SELECT somedata from TABLES
WHERE Field = Value
AND BranchID='1000'
Where the final line indicates the department.
The results from each run are saved into the default location (stored in the config file) and named Export-Date-Department – eg: [login to view URL]
Utility should display message to indicate success, then save run date to config file and quit.
SQL Query will be provided to winning bidder along with sample results from that query.
Project ID: #8149984
About the project
Awarded to:
Hello. I am able to create such utility in couple of hours. Just let me know . Sincerely yours, Andrei Plinda
25 freelancers are bidding on average £128 for this job
Hello Good Day I have developed a lot of similar utilities to generate CSV files from mssql database. I am ready to start and finish it immediately. Looking forward to hear from you. Thanks Rinsad
Hi Sir/Madam. Ready to start. Thanks. **********************************************************************************
We are very interested in this project. I have read your above description and i think its well within our range to execute this is in a good time frame so would you be kind enough to message me so we can have a fast a More
Hope you are doing great. I have checked the given detail of this project and I am interested to provide you my services. I have more than 7 years in providing professional website development services and worked with More
Respected Sir i can develop an utility in .net framework (c# or vb.net) to create a CSV file(s) using queried data from SQL Server. Warm Regards vnb400
Hello, I have most of it written already, I can do it and deliver within 2 hours max. Available now to start
What columns you require to put in CSV and how many records? I can develop this utility in .NET C# for windows application. I can start this now. Do let me know and we can close this quickly. Thanks
Hi, I am interested. Please see my portfolio at http://www.freelancer.com/u/narendragautam.html Thank-you Narendra
Hi, I have around 10 years experience in the field of Software Development with expertise in Win32, MFC, C++, C# & SQL. I can develop this utility using C# as a stand-alone desktop application. Please contact More
Hi, Thank you for posting your requirement. My name is Inderjeet and I run a small 4-member IT services firm at Chandigarh, India. We have been into IT since 1994 and have done a vast number of software (from Dos+Foxp More
Hi friend, i am programmer with 15 years of experience. This is piece of cake. Let me do it for you.
With 7 yesar of experience using Microsoft technologies in building applications (desktop and web), i can give you a required guaranties for finishing this project successful. Very Best!