Peruttu

Write some Software

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: [url removed, login to view]

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.

Taidot: tietojärjestelmäarkkitehtuuri, Windows Desktop

Näytä lisää: named query, free software write company profile, input field change check value, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, software write protect software, software write technical manual

Tietoa työnantajasta:
( 17 arvostelua ) Newark On Trent, United Kingdom

Projektin tunnus: #8149843

3 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

HussienSharaf

Dear Sir, I have a ready made program that can run several queries and export the result of each one into a CSV or merge all results into one CSV. I intend to customize the interface to suite ur needs or build an int Lisää

£250 GBP 3 päivässä
(22 arvostelua)
6.8
nuprogramer

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 Lisää

£388 GBP 3 päivässä
(8 arvostelua)
5.5
NewLightIE

Hello there, I'm a MS Windows specialist using C++ and VC++. Using the MFC Library and either ODBC would be the quickest and most-recommended way to implement this Windows application for you. Can I help, pe Lisää

£211 GBP 5 päivässä
(0 arvostelua)
0.0