In Progress

project to read SQL data and write text file

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) |

Skills: MySQL, Oracle, SQL, Windows Desktop

See more: use data structure, type data structure, true results, table data structure, set data structure, prefix data structure, net scheduler, js write, data structure type, data structure set, data structure example, read example, command group, application data structure, write text, text file, sql data, sql commands, sql 2012, selection criteria, memo, data text file, d file, calling projects, boolean

About the Employer:
( 17 reviews ) Austin, United States

Project ID: #2789272

Awarded to:

kalpesh2804

See private message.

$70.55 USD in 5 days
(24 Reviews)
4.5

18 freelancers are bidding on average $93 for this job

desconit

See private message.

$127.5 USD in 5 days
(27 Reviews)
5.7
kapoorprateek82

See private message.

$90 USD in 5 days
(30 Reviews)
4.9
eagleeyesvw

See private message.

$100.3 USD in 5 days
(28 Reviews)
3.9
feninsoftech

See private message.

$100.3 USD in 5 days
(3 Reviews)
3.7
ranju61

See private message.

$76.5 USD in 5 days
(12 Reviews)
3.5
codeindiadigital

See private message.

$80 USD in 5 days
(5 Reviews)
3.2
pramodv

See private message.

$85 USD in 5 days
(12 Reviews)
3.1
sstanojevic

See private message.

$80.75 USD in 5 days
(4 Reviews)
2.7
DonBarry

See private message.

$100.3 USD in 5 days
(2 Reviews)
2.6
Swaroborno

See private message.

$127.5 USD in 5 days
(2 Reviews)
2.2
mfelch

See private message.

$100.3 USD in 5 days
(0 Reviews)
0.0
nitalsoni

See private message.

$100.3 USD in 5 days
(0 Reviews)
0.0
hardik0601

See private message.

$79 USD in 5 days
(0 Reviews)
0.0
Quadroz

See private message.

$100.3 USD in 5 days
(0 Reviews)
0.0
Pharoa

See private message.

$100.3 USD in 5 days
(0 Reviews)
3.7
ognyanobretenov

See private message.

$110.5 USD in 5 days
(0 Reviews)
0.0
hpexconsultancy

See private message.

$40.8 USD in 5 days
(0 Reviews)
0.0
Vicar

See private message.

$100.3 USD in 5 days
(0 Reviews)
0.0