Project Detail
CSV file generator
CSV file generator is project number 442944
posted at Freelancer.com. Click here to post your own project.
Bid Count: 9
Average Bid:
$ 91
05/31/2009 at 20:20 EDT
Project Creator:
cerbs
Employer Rating: 
(1 reviews)
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.
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results