Find Jobs
Hire Freelancers

Coldfusion Script

$30-100 USD

已关闭
已发布大约 18 年前

$30-100 USD

货到付款
I have a MySQL Database which contains 2 tables - products & prices. Each week, I need to upload a file (which can be provided in either excel or csv format). Now, this file may contain the same product, but at different prices - and it may have slight alterations in the product name, for example it may have the same product 3 times but with different presentation, like so; - Epson R300 - Epson Stylus Photo R300 - Epson Stylus Photo R300 (1 Yr Warranty) and so on... I need a script to parse and insert these into the database and to recognize similar/identical products, and therefore insert just one record into the 'products' table, yet 3 records in the 'prices' table. The end result I need is that when a user searches for a particular product, it needs to only return a single result for that product, yet still display all 3 prices. (A bit like the way price comparison sites work, if you like). Finally, after the first upload, I will need subsequent uploads/parsing to recognise the existing data, and only update as needed. If there is a better way of dealing with this data, or presenting it etc - I'm all ears! ## Deliverables Working script that accomplishes the task described above. All code should be well commented. ## Platform Coldfusion MX7
项目 ID: 3236915

关于此项目

1条提案
远程项目
活跃18 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
1威客以均价$64 USD来参与此工作竞标
用户头像
See private message.
$63.75 USD 在5天之内
5.0 (3条评论)
4.1
4.1

关于客户

UNITED KINGDOM的国旗
United Kingdom
0.0
0
会员自5月 31, 2005起

客户认证

这个客户的其他工作

Amazon Associates Scripts
$30-100 USD
谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。