Write a C++ program to convert from one CSV format to another

Completed Posted Jan 13, 2014 Paid on delivery
Completed Paid on delivery

Write a command line program in C++ Visual studio 2008/2010.

Read in the [login to view URL] and export it to [login to view URL]

You have to rename or rearrange some fields and data. (As described in the specification)

I will provide a short [login to view URL] as a reference when the task will start.

Deliver the full tested source code and project.

Write the source code in an industry standard manner with comments.

When this task was done, perhaps, we will have additional requirements. I expect them to be done in an additional task.

Specification:

Create a CSV separated by comma.

Surround the content of all columns with quotes.

Remove the HTML tags in all fields.

“AutoID” and “Group No.” should not be exported.

Merge the content of “Business Reason” and “Implementation notes” to one field:

Add a line with the following prefix before each entry of the following columns:

Business Reason “Business Reason:“

Implementation notes “Implementation notes:”

And merge both text together to the “Comment” column.

Create tree columns called “Label”. In the Type field from the import file sometimes are several (up to 3) types. In the export file should be only one type per column. To export several types, use the several label columns. Leave unused types blank.

Create a column “Issue Type”. The column Issue type should be filled always with the string “Task”.

The value for the priority has to be renamed for the input file to other values in the output file. When no priority was set, set the value to “Unknown”.

Rename the “Priority” in the following way:

“1” -> “Blocker”

“2” -> “Critical”

“3” -> “Order”

“4” -> “Request”

“5” -> “Minor”

“” -> “Unknown”

Rename the “Status“ in the following way:

“new” -> “NEW”

“added to product strategy” -> “OPEN”

“declined” -> “CLOSED”

“unclear” -> “REJECTED”

“done” -> “CLOSED”

“on hold” -> “ONHOLD”

“wait for response” -> “SPECIFICATION”

“removed” -> “CLOSED”

The sampleOutput.csv should have the following table structure:
“Title”
“Description”
“Machine Info”
“Comment”
“Created”
“Issue Type”
“Contact Person”
“Due date”
“Status“
“Priority”
“Effort”
“Label”
“Label”
“Label”

Map the input table to the output table in the following manner:
SampleInput.csv -> SampleOutput.csv:
“AutoID”
“Status” -> “Status”
“Goal” -> “Title”
“Comment/Description” -> “Description”
“Business Reason” -> “Comment”
“Priority” -> “Priority”
“Implementation notes” -> “Comment”
“Responsible” -> “Contact Person”
“loose time estimate” -> “Effort”
“Type” (1) -> “Label”
“Type” (2) -> “Label”
“Type” (3) -> “Label”
“Group No.”
“Target Version -> “Due date”

C++ Programming

Project ID: #5314713

About the project

17 proposals Remote project Active Jan 13, 2014

Awarded to:

vano101

It looks as easy assignment for me, there is chance to do it in 2 days or even sooner...................

$30 USD in 2 days
(1040 Reviews)
7.5

17 freelancers are bidding on average $149 for this job

urmate

HI Contact me for an efficient, well documented and perfect solution and development of your project. I ensure quality work with always on time delivery of project and dedicated support and follow up. Than More

$144 USD in 1 day
(374 Reviews)
7.0
hbxfnzwpf

I am very proficient in c, c++. I have 15 years c++ developing experience now, and I have worked for 5 years. My work is online game developing, and mainly focus on server side, the lauguage is c++ under linux os. So, More

$111 USD in 2 days
(133 Reviews)
6.9
deadheadvw

Gone through the project description and clearly understood your requirements. I'm an experienced C++ programmer and willing to work on this project. Quality code with timely delivery guaranteed.

$100 USD in 3 days
(89 Reviews)
5.4
oobretenov

I have experience in VS2010 and I could do the task. . . .

$155 USD in 5 days
(9 Reviews)
4.0
rakib062

Hi, I am developing systems in C++ for 6+ years. Involved in core development where accuracy and efficient are of prime importance. I have previously developed some tools for text parsing, sorting and other kind of pr More

$100 USD in 3 days
(19 Reviews)
4.2
mrbrave1703

Hello, I have used VC++ for years now, and your problem is just a small task to me. Pick me, I wont let you down. Thank you!

$100 USD in 1 day
(3 Reviews)
2.2
VnBestSolutions

Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! More

$305 USD in 5 days
(0 Reviews)
0.0
sayantanauddy

I have over 4 years of professional experience in the information technology industry and am proficient in C++, C and Java. I have already delivered a project, based on C, in freelancer. I will be able to provide you t More

$55 USD in 2 days
(0 Reviews)
0.0
drkameleon

Hi, I've had a careful look at your specifications and the project seems perfectly doable, perhaps even in a lot less than the 3 days I mentioned in my original offer. (I have a lot of experience with parsing and CS More

$211 USD in 3 days
(0 Reviews)
0.0
MakersOfAndroid

Hello sir, This is suhan gorya, i`m new on freelancer, but you can check my name on google. i assure the work success. just message me for more conversation about project. thanks

$200 USD in 10 days
(0 Reviews)
0.0
bvsarathi

This is very tricky to write. I will use c++ stl's which I feel are the better suited tools for this kind of task. There could be many ways to solve this But using STL containers would have the advantage of: More re More

$155 USD in 5 days
(0 Reviews)
0.0
burhan393

Hey! I went through the project description and its interesting. I would love to work on this project. Had to ask you several questions. Looking forward to hear form you. Thanks.

$30 USD in 3 days
(1 Review)
0.0
Uriev

A proposal has not yet been provided

$100 USD in 1 day
(0 Reviews)
0.0
bob1982

is C# or VB.NET ok to you? i am very good in c#,vb.net,php/mysql. let me know if thats ok to you so that we can talk further Regards

$155 USD in 3 days
(0 Reviews)
0.0
gerrypostprogram

A proposal has not yet been provided

$333 USD in 3 days
(0 Reviews)
0.0
eery

Návrh doposud nebyl poskytnut

$244 USD in 3 days
(0 Reviews)
0.0