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