Project Detail

CSV file generator  

CSV file generator is project number 442944
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: iDivya

Budget: $30-250

Created: 05/29/2009 at 20:20 EDT

Bid Count: 9

Average Bid:
$ 91

05/31/2009 at 20:20 EDT

Project Creator: cerbs
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

Description

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, parent.surname, parent.f_name, parent.m_name
FROM tass.dbo.parent parent
WHERE (parent.cmpy_code='01') AND (parent.status_flg='c') AND (parent.doe > [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 parent.doe parameter which is a date in the format of DDMMYYYY.

Messages Posted:1 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

80

2 days

05-29-2009 23:45 EDT

Please read my message.

help

 

150

2 days

05-29-2009 21:23 EDT

Please check pm.

help

 

100

2 days

05-30-2009 00:00 EDT

ready to start

help

 

85

3 days

05-29-2009 23:26 EDT

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

help

 

92

2 days

05-29-2009 21:45 EDT

Hi Please refer my PMB Regards

help

 

50

2 days

05-29-2009 23:10 EDT

Please check PMB

help

 

60

1 day

05-30-2009 00:02 EDT

Sir, Kindly Check PMB. -Regards Meetanshu

help

 

50

1 day

05-30-2009 00:04 EDT

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 private concern. I am having experience in N-Tiers and Client/Server architecture application development using ASP.NET/C#/VB.NET/Visual Basic 6.0 as the Front-end, MS-SQL Server 7.0/2000/2005, Oracle 8.0/8i, MS-Access 9X/2000 as the Back-end and experienced in the execution of Technical/Functional Process Design, Implementation activities of small and large projects. Extensive Experience in ActiveX Controls, ActiveX DLLs, ActiveX EXEs, COM, ADO, DAO, ADO.NET, Web Services, .Net Remoting, Web User Controls and using the Object Oriented Techniques while designing the application program development. Possess strong analytical and problem solving skills. I am working on the data migration process. For that I have worked on windows application which will call the external web services and give you the actual result. Also I am working on a product which is based on financial domain. Here we are using 3-tier architecture. Obviously 3-tier architecture depends on the web services. So I am familiar with web services. I am working on the product. I am working on this project for past 3 years. Actually it is based on financial domain. We are using .NET, SQL Server, 3-tier architecture, Web Services, XML and XSD. Prior to this I have done one project called "Unit testing Tool". It is used to testing the developed code. The input of the application is DLL, which you want to test. From this DLL I will list out all the classes using reflection. After that I will list out the methods based on the selection of the class. You can create a test case and execute it. Using this project you can ensure that whether your code is working properly or not. I am really interested to work on this project. Definitely I will deliver the good quality project within the specified time. Please let me know further details, if you are satisfied with me. Thanks.

help

 

150

2 days

05-29-2009 21:46 EDT

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

help


    Bid on this Project