所有软件外包项目 Gray arrow bg Pricelist Database Update script using P...

Pricelist Database Update script using Perl+PostgreSQL 资金已经托管 线上项目,线下洽谈,智城安排

发包方 : Philip thompson 接包方 : Csoon02 状态 :完成
项目编号 : 90430
项目预算 : 多于$100
开发周期 : 7 天
技能 : Perl PostgreSQL C
发布日期 : 2009-10-22

描述

I have a PostgreSQL 7.4 Database with about 30000 products with Manufacturer-ID, Manufacturer-Name, Item-ID, Description, Price, Rebate(%), and some more.
Every month i get a new pricelist as a csv-file but there are some informations in it that arent correct for me. So i cannot just import and overwrite the whole thing.

What i need is a perl based website where i can choose in detail, what information i want to import and what has to be excluded.

Case 1)
Import the whole csv EXCEPT Manufacturer-ID 1,2,3,...
Case 2)
Import ONLY Manufacturer-ID 1,2,3,...
(there must be a list and this lists should be loadable and storable, for example in a seperate table in the database)

Furthermore i have to be able to choose either to import a) ONLY the Rebate or b) ONLY the Price or c) Rebate AND Price.
If there is a new article in the csv which does not already exist in the database then all csv fields need to be imported (obviously).
After the import is complete a list (textfile) should be reported with the newly added products (only Item-ID) and a status info about how many prices has been updated.

After all this page should be integrated in an existing Perl-web-application but this is optional and will be a seperate bonus.

项目竞标

接包方 国家/地区
拥有案例
3
Csoon02 (中标)
拥有案例
2
Iphonesdkpros

竞标

请您先登录,然后提交此项目的竞标方案。
还不是智城用户? 智城期待您的加入,请注册成为我们的一员吧!
Project ad2