Air Compressor Bot
|
|
Home |
How it works |
Projects archive |
Contact Us Air Compressor Bot |
|
| The Career Path of Freelance Programming Jobs |
OSCommerce ZIP+4 based tax rate upload |
 |
Bidding Time: |
03/07/2008 03:46 - 07/07/2008 00:00 |
Budget: |
$30-250 |
Status: |
Pending |
|
|
|
Job Type: |
|
Description: |
OSCommerce admin user shall be able to upload a CSV file via an admin page and data will get posted automatically into stores database. Deliverables include: 1. create php page in admin side that allows upload of a zip file via browse button that allows the user to browse the local file structure or type in the path and file name in a editable file 2. below a selection list shall show description of tax_class_ids (table: tax_class show all tax_class_title:tax_class_combination) 3. below a selection list shall show description of tax_zone_ids (table: geo_zones show all geo_zone_name:geo_zone_description) 4. below a upload button shall be shown that triggers the actual upload. file format is as follows Field Name TYPE Description ZIP Varchar(5) Five-digit zip code PLUS4 Varchar(4) four-digit zip code extension CODE Varchar(4) Location code number STATE Decimal 7.4 State rate LOCAL Decimal 7.4 Local rate (For location codes in RTA areas, includes RTA rate) TOT_RATE Decimal 7.4 Combined state and local rates EFF_START Datetime YYYY-MM-DD 00:00:00 Rate effective start date EFF_END Datetime YYYY-MM-DD 23:59:59 Rate expiration date Sample data: 98001 0 1700 0.065 0.025 0.09 20080701 20080930 98001 1000 1700 0.065 0.025 0.09 20080701 20080930 98001 1001 1700 0.065 0.025 0.09 20080701 20080930 98001 1002 1700 0.065 0.025 0.09 20080701 20080930 98001 1003 1700 0.065 0.025 0.09 20080701 20080930 98001 1004 1700 0.065 0.025 0.09 20080701 20080930 98001 1005 1700 0.065 0.025 0.09 20080701 20080930 98001 1006 1700 0.065 0.025 0.09 20080701 20080930 98001 1007 1700 0.065 0.025 0.09 20080701 20080930 98001 1008 1700 0.065 0.025 0.09 20080701 20080930 98001 1009 1700 0.065 0.025 0.09 20080701 20080930 98001 1010 1700 0.065 0.025 0.09 20080701 20080930 98001 1011 1700 0.065 0.025 0.09 20080701 20080930 98001 1012 1700 0.065 0.025 0.09 20080701 20080930 Full file at http://dor.wa.gov/downloads/Add_Data/ZIP4Q308E.zip once file is uploaded, unzip and parse file into table: tax-rates as follows Tax_rates_id <unique ID> Tax_zone_id <geo_zone_id> based on user selection in selection list Tax_class_id <tax_class_id> based on user selection in selection list Tax_priority 0 Tax_rate <LOCAL field> Tax-description ^<ZIP>-<PLUS4>^county tax (e.g. ^98123-1234^county tax Last_modified <update with time when updated> Date_added <add when created> Overwrite existing tax_rate_ids based on ^<ZIP>-<PLUS4>^ in tax description field 5. upon import show status message with number of rows in uploaded file and number of rows successfully imported 6. in case of error state error condition as part of status message. 7. delete uploaded file after import deliverable must include all source code and usage rights Next:  Flash Intro -
Export our design to an oscommerce checkout -
Job site -
Recover Word Document. -
Writer for 14 articles -
This project is the proprietary information of .
Click here to remove this project from OUR database.
|
Operating System: |
Linux |
Database System: |
MySQL |
|
| |
| <<< back |
|
| Home | Projects archive | RSS | Resources | Links | Contact Us | © 2004-2007 ProjectsList.biz /0.496 |