В роботі

CSV file generator

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

Показати більше: csv file generator, csv generator, csv data generator, value options, letters example, example letters, csv generator net, random data csv file generator, tass database sql, generatore dati csv sql, data mining warehousing, upper sql, sql less than, david data, wood , vu, pager, dsn, cuong, csv, csv file, Andrew, sql query format, runtime app, runtime

Про роботодавця:
( 4 відгуки(-ів) ) Corinda, Australia

ID проекту: #442944

Доручено:

iDivya

Please read my message.

$80 USD за 2 дні(-в)
(88 відгуків(-и))
6.0

8 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $83

refractocd

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

$85 USD за 3 дні(-в)
(10 відгуків(-и))
4.0
suraArumugam

Hi, I have 4 years of experience in .NET(C#), SQL Server, Ms Access and Visual Basic. Also I have well knowledge about 3-tier architectures, Web services, XML and XSD. I am working as a senior software engineer in a Більше

$50 USD за 1 день
(3 відгуків(-и))
3.1
rxsuman

Please check PMB

$50 USD за 2 дні(-в)
(1 відгук)
1.0
guruplus

Hi Please refer my PMB Regards

$92 USD за 2 дні(-в)
(0 відгуків(-и))
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 за 2 дні(-в)
(0 відгуків(-и))
3.3
chathura86

ready to start

$100 USD за 2 дні(-в)
(0 відгуків(-и))
0.0
meetanshu

Sir, Kindly Check PMB. -Regards Meetanshu

$60 USD за 1 день
(0 відгуків(-и))
0.0