CSV file manipulation/change format

Cancelled Posted Apr 12, 2013 Paid on delivery
Cancelled Paid on delivery

We have a csv file which is updated every day. We need to output another CSV using the data in this file, with a different layout and some simple formula applied to the data.

Example import layout:

Product Code, Product, Brand, Category, Price, Unit, Qty, Product Image, EAN

Example output layout:

Product Code, Maximum price (Price*fixed % from config file), Minimum price (Price*another fixed% from config file), Qty, Fixed Text from config file, Fixed Text from config file,

We would like to be able to change the format in the future so a config file would be required. In the config file we would need to be able to match the columns and set them to the output along with any fixed text values or minimum cost percentages etc i.e

Config file:

Set Input file:

Column 1 = Product Code

Column 2 = Product

Column 3 = Brand

Contains headers

Set Output file:

Column 1 = Product code

Column 2 = Price % Fixed percentage

If you can help please place a bid

Thanks

Data Processing Excel MySQL PHP Website Testing

Project ID: #4422894

About the project

41 proposals Remote project Active Apr 28, 2013

41 freelancers are bidding on average $114 for this job

rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$200 USD in 1 day
(1012 Reviews)
8.8
kabirchy

HI, I am ready to build such a csv processing script. best quality assured. Thanks

$185 USD in 3 days
(1230 Reviews)
9.3
hits

We are a team of web developers with expertise and experience in PHP and MySql. We have delivered successfully on many custom applications. I have read the project requirements and I am confident of delivering very More

$262 USD in 3 days
(991 Reviews)
9.0
gopalvora

Hi ready to start Thanks

$156 USD in 5 days
(531 Reviews)
8.4
sureshdevi

I can create script to handle csv file, manipulate and output calculated data. I will be complete this work in 2 days.

$64 USD in 2 days
(1216 Reviews)
8.1
SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$99 USD in 2 days
(283 Reviews)
8.2
Teloquence

Consider it done. Check your PM for my bid details.

$198 USD in 3 days
(336 Reviews)
7.7
gangabass

I have completed many projects like this that's why I'm sure you'll be impressed with my work. See PMB for details.

$50 USD in 1 day
(508 Reviews)
7.6
dboyzhang

Hello, I have think about the solution and I'm close. Will need to follow some rules to config each column. Some symbol or brackets will be used. I'm sure the script can be done by me. But if you want more calcul More

$150 USD in 3 days
(338 Reviews)
7.3
Sphinks

Hello. I worked with CSV/XML files before. I can help you with this job. Regards, Daniel!

$220 USD in 3 days
(89 Reviews)
6.7
prakashmondal

Hi, I am interested to develop a software application to work with your CSV. Please see PM.

$75 USD in 3 days
(83 Reviews)
6.1
dzmitrij

Hello, Can make this. So you have some php-script which operate with csv. Need to see this script. Have big experience working with csv. Regards. Dima

$84 USD in 2 days
(70 Reviews)
5.9
MustafaSR

Hello Sir, can delever the exact script you are looking for. Please check the PMB

$140 USD in 2 days
(92 Reviews)
5.9
aboobakr

Hi sir, I can give you the solution within a day. Please refer my PM too.

$30 USD in 1 day
(44 Reviews)
5.9
nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet co More

$95 USD in 3 days
(64 Reviews)
5.7
pkcyber

I can give u simple windows application which will take the csv file as input and give u output csv file the format and calculations you require. You can get it with simple windows click If you want a windows applic More

$75 USD in 1 day
(33 Reviews)
5.7
fejs

Hi Sir. I'm expert in Python programming and have good knowledge of Excel. I've done similar project recently, with some tax calculations, so this job shouldn't be a problem. Best regards, Fejs.

$35 USD in 1 day
(54 Reviews)
5.3
vsprybhanu

Hi, I've read and understood your project description. I've 10 year experience of data entry and typing work. Typing speed 60 WPM. Excellent knowledge of MS Excel 2007, 2010, Internet Research and Web Scra More

$30 USD in 3 days
(73 Reviews)
5.5
farrukhp

hi i am very good in php and i have done similar work earlier... i can take the input and manipulate it get the required output... and the system can be make quiet flexible. kindly have a look at my reviews for re More

$80 USD in 1 day
(32 Reviews)
4.9
proauthor

Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks, Shaik.

$30 USD in 0 days
(45 Reviews)
5.2