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
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 well. I do have a few queries and your answers are critical for delivering as required and for assessment of scope of work. So please read PMB.
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 calculator in the config file. Tell me. One question, how will the script work. A cron script or a single page where you can upload the original CSV then the script create the converted one so you can download by clicking on a link maybe?
Any question, please ask.
Bo
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 containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary (e.g. Fixed percentages, assignments of input and output columns, etc.). Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees.
Regards!
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 application u will be charged 80$
if you want a simple web page that can be access from any where : 110$
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.
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 Scraping.
Able to complete your project in time with 100% accuracy and outstanding performance.
I give updates timely and regularly.
Please reply soon.
Regards,
Virendra
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 reference.
thanks.
farrukh