CSV file generator

Completed Posted May 29, 2009 Paid on delivery
Completed Paid on delivery

Need to extract data from an existing MS SQL database and then manipulate the data to produce a CSV file.

There are only 4 fields returned in the SQL data example :

00694 Wood David Wood Jenny Wood

00744 Aird Robert Aird

00760 Howard Andrew Howard Natalie Howard

02530 Vu Cuong Vu Lan Chau

I need to have the csv file output from the above example to be converted to this :

name,sn,givenName,sAMAccountName,displayName,password,pager

David Wood,Wood,David,David Wood, David Wood,<random>,00694

Jenny Wood,Wood,Jenny,Jenny Wood, Jenny Wood,<random>,00694

Cuong Vu,Vu,Cuong,Cuong Vu,Coung Vu,<random>,02530

Lan Chau,Chau,Lan Chau,Lan Chau,<random>,02530

The important example is the last one (Lan Chau and Cuong Vu) where the first name in the returned data has a different sn value to the second item.

Additionally the random password to be generated needs to be upper and lowercase letters and include numbers. Not to be less than 6 characters and no greater than 8 characters.

The SQL query to retreive the data :

SELECT parent.par_code, [url removed, login to view], parent.f_name, parent.m_name

FROM [url removed, login to view] parent

WHERE (parent.cmpy_code='01') AND (parent.status_flg='c') AND ([url removed, login to view] > [doe_data])

The connection string :

DSN=TASS;UID=<XXXXX>;APP=2007 Microsoft Office system;WSID=USERNAME;DATABASE=tass;Network=DBMSSOCN;UseProcForPrepare=0

The completed application needs to take the username and password for the SQL connection at runtime.

Additionally the application needs to have options to set the [url removed, login to view] parameter which is a date in the format of DDMMYYYY.

.NET SQL Windows Desktop

Project ID: #442944

About the project

8 proposals Remote project Active May 30, 2009

Awarded to:

iDivya

Please read my message.

$80 USD in 2 days
(88 Reviews)
6.0

8 freelancers are bidding on average $83 for this job

refractocd

This can certainly be done using VB.NET. I am ready to start IMMEDIATELY. Please refer to PM.

$85 USD in 3 days
(10 Reviews)
4.0
rxsuman

Please check PMB

$50 USD in 2 days
(1 Review)
1.0
guruplus

Hi Please refer my PMB Regards

$92 USD in 2 days
(0 Reviews)
0.0
johnsupakin

I can provide this soltuion to generate csv file with the data maniputaion done and the output in the said format. Please reply to discuss this further. Regards, John

$150 USD in 2 days
(0 Reviews)
3.3
chathura86

ready to start

$100 USD in 2 days
(0 Reviews)
0.0
meetanshu

Sir, Kindly Check PMB. -Regards Meetanshu

$60 USD in 1 day
(0 Reviews)
0.0