Update CSV upload tool and image upload tool

IN PROGRESS
Project Budget (USD)
$120

Project Description:
I need create new version of the csv upload to accomodate the attached file

Here is the current CSV upload page http://www.couponqueen.com/flyerForm?viewCSVForm=1

We have these new fields in the:

1.)
flyer_x1 flyer_y1 flyer_x2 flyer_y2 flyer_id Flyer Image URL
162 789 342 865 4 http://krogercentral.cntk.mywebgrocer.com/circular/266/pages/B_15137926_ED8503FCF913.jpg


flyer_xxx columns are entered into storeName_data tables, i.e. couponqu_parsers2->kroger_data

flyer_id is entered into flyer_id

2.) In addition, some infomration is entered into kroger_flyer (which should ALSO be located in couponqu_parsers - not couponqu_parsers2_flyer)

Unique records are equal to storeid AND flyerid combination.

In other words, each storeID has between 4 and 20 pages per flyer, we need to create records in kroger_flyer for each unique record, the records should be numeric by storeID, flyer_id

here is an example
storeID 903/00903461 flyer_id=1
storeID 903/00903461 flyer_id=2
storeID 903/00903461 flyer_id=3

in this example, storeID 903/00903461 has three pages in the flyer


A.) id is auto numeric
B.) storeid= storeid
C.) page number = flyer_id
D.) Source image URl = the original image url in the file, flyer image URL
E.) imageURl, = "http://www.couponqueen.com/beta2/grocery_flyers/" & storeName/xxxx.jp

example: http://www.couponqueen.com/beta2/grocery_flyers/cvs/140126_XX_01_63_lalvu.jpg

F.) Valid Date = valid date

3.) We need to modify the image upload tool to accept these new flyer image
http://www.couponqueen.com/flyerForm?zipupload=1

Will provide a sample upload file


4.) Need to update this page to show the new flyer images field (we dont need all fields, just flyer images)

http://www.couponqueen.com/coupons_admin_cp/flyerWork.php?viewWork=1&id=680


5.) I need you create storeName_flyer tables inside couponqu_parsers2, see CVS for example. One of the coders needed to have these table in the same db

6.) We need to create the same storeName_flyer tables inside couponqu_parsers2_archive


Keep in mind that the new fields are not required, so the file should still upload and approve (on the admin side) if the new fields are missing.


Thanks

Stuart

Skills required:
AJAX, HTML, MySQL, PHP, Wordpress
Project offered by:
Verified