Completed

project to read SQL data and write text file

This project was successfully completed by kalpesh2804 for $70.55 USD in 5 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$100 - $150 USD
Completed In
5 days
Total Bids
19
Project Description

1. [url removed, login to view] project
2. Small user interface with just a "Start" button.
3. Callable from a command line, so it can be called from Windows Scheduler or other processes, and run hidden.
4. Application functions
a. Connect to SQLServer database (or any ODBC-compliant DB)
b. Open command table in DB (see structure below) and executes all active commands
c. Command will execute a SELECT SQL statement and package the results into a formatted JS file.
d. File location will be as specified in the command table; if destination is NULL, default will be current local folder
e. Application will create/add to a log file to document performed actions.
5. Calling parameter (optional)
a. If a calling parameter is used, this is a selection criteria to use when choosing command lines to execute
b. Example
i. "Ref1"
ii. Executes only command lines with CSet = "Ref1"
6. Read intialization file
a. File Name = [url removed, login to view]
<Prefix>text to prefix data in the file<\Prefix>
<Suffix>text to add as suffix to data in the file<\Suffix>
<Delim>|<\Delim>
7. Include a config text file that specifies the DB connection parameters



## Deliverables

Command Table


Name: RefCommand
Structure:
| Field name | Type | Description/use | Example |
| CSet | C 50 | Set (group) of command lines to execute | Ref1 (default is NULL) |
| CName | C 50 | Command line name/description | Get Projects |
| SQLText | Memo | The SQL command to be executed | SELECT * from Projects where?. |
| OutputName | C50 | The name of the JS file to be created | Projects |
| Olocation | Memo | The destination folder; if NULL then use current folder | C:\Myfiles |
| ActiveLine | Boolean | Denotes active line to execute as part of set | True (default value) |

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online