Sedang Disiapkan

Update Everyday Automaticaly DB Table/Field from ASCII - .CSV

We have a Joomla web site with VirtueMart Shopping Cart installed. We are looking for a programmer who can build a secure script that updates, through the internet, the server's database field "stock" everyday from an ASCII, .csv or comma delimited file that resides in a folder at a company's PC.

1)We will need a simple desktop icon (executable,XP) so our company's employees can run it to update the database with just one click. (we will provide you the graphics like .ico etc) .

2)The script must automatically update the db field "stock" from ftp once per day at a specific time (without user action).

The script must be easily customizable ( graphic interface or just #Help Comments in the code) so that we will able to change the domain name, IP, User/Pass, add/edit/remove DB tables/fields, paths, time etc. Any suggestions for extra features are more than welcome...

DBtable 'jos_vm_product'

Fields 'product_in_stock' , 'product_sku'

PHP version 5.2.8

MySQL version 4.1.22-standard

We need the script to be portable, for example i want to be able to use it to another joomla/viruemart installation, just changing some lines of code like domain or to add/remove virtuemart_dbfields/tables and also the ability to use different ascii/csv/excell file. Please use #comments in your script.

We need, from the desktop sync application (.exe), to choose the file (.csv,ascii,excell) for upload, and also to enter the server (domain or IP). When the user puss the button it will update existing db product fields, add new db products (if any new in the .csv/ascii/excell), and also to remove db products that there isn't any more in the .csv/ascii/excell.

You have to setup also a cron job to update the 'Stock' field every day for example at 06:00.

In the near future, we will need you to develop the same project for magento platform

I uploaded a sample file with 30 products. This is the explaination because it is in greek language

DB tables --> jos_vm_product field - jos_vm_product_price

Col.A --> product_sku
Col B --> product_desc + product_name
Col.C --> product_unit ## It's a text area in virtuemart admin. You can enter it as it is...
Col F --> product_tax_id ## ='2' -- All the products using taxID=2 (19%)
Col.N --> ##is the product price(with tax included). Tables: product_id from jos_vm_product and product_price_id , product_price from jos_vm_product_price ### Here there are 2 tables involved...
Col.O --> product_in_stock ## (values from 0 - 999)



##Col.N is the Gross Price (with tax included) (Col.M is the Net Price without tax).

***I believe that you have to bypass default values for all fields. Only this way the products will be published right away. For example it's critical for every product to have product_publish=Y etc.


*** I have to be able to change/control those 'columns' which your script will update Mysql of other joomla/virtuemart installations...

Kemahiran: Joomla, PHP, Memasang Skrip, Destop Windows

Lihat lebih lanjut: update table day php, virtuemart mysql product_in_stock update, ascii romanian table, update everyday, mysql update table csv, mysql update day, pc icon, it field, icon for pc, icon folder, icon file ico, company who build mysql database, cart icon, 4122 standard table fields, php csv update field, table jos_vm_product, update table everyday, update field csv file php, virtuemart csv product_in_stock, adding field jos_vm_product, update sql table fields csv, product_in_stock field, create table day automatically mysql php, update sql script day, php csv update table

Tentang Majikan:
( 0 ulasan ) Heraklion, Greece

ID Projek: #375458

20 freelancers are bidding on average $168 for this job

creativewebideas

Hi, We have expertise on this type of projects. Escrow required. Thanks. Best Regards, Creative Web Ideas

$200 USD dalam 5 hari
(194 Ulasan)
8.1
InnovisionLab

Ready to start, Thanks

$200 USD dalam 5 hari
(93 Ulasan)
7.4
sunztech

please see PMB.

$200 USD dalam 5 hari
(30 Ulasan)
7.3
kernelbd

Ready to start. Escrow needed. Thanks.

$250 USD dalam 5 hari
(110 Ulasan)
6.8
hejian

I am ready to start. Thanks.

$250 USD dalam 2 hari
(61 Ulasan)
6.4
richammond

lets start!!

$250 USD dalam 2 hari
(103 Ulasan)
6.2
fastphp

i will complete

$250 USD dalam 8 hari
(29 Ulasan)
5.6
ccristi77

Hi, I can create this database update script for you in php. Best Regards, Cristi

$80 USD dalam 5 hari
(12 Ulasan)
5.6
experter

Expert in Joomla VM. Please check PM. Thank you !

$150 USD dalam 5 hari
(35 Ulasan)
5.2
netcoder

Hi, I think I can do it:-)! Best regards, netcoder:-)

$155 USD dalam 15 hari
(19 Ulasan)
4.5
edatawiz

Hi - Please check PM for details.

$60 USD dalam 2 hari
(9 Ulasan)
4.2
digixpert

please check PM

$100 USD dalam 4 hari
(0 Ulasan)
0.0
vijuvinayak

Please let me know if you would like to see the demo

$50 USD dalam sehari
(0 Ulasan)
0.0
yunshangsky

Dear sir I would like to express my interest and enthusiasm for your assignment and I'd like to propose my service. I have about 9 years total experience of software developing in various areas (Database design, Des Lagi

$50 USD dalam 5 hari
(1 Ulasan)
4.2
linefront

Frontlinesoft Limited (FSL) is an Offshore Software Development Company located at Hyderabad, India. Since its inception in 1999, FSL has steadily grown to become a reputed provider of offshore software web development Lagi

$200 USD dalam 18 hari
(0 Ulasan)
0.0
RamaRao

Please contact me. Looks like it is a good project for me and you.

$250 USD dalam sehari
(0 Ulasan)
0.0
softtechprovider

Hi, Please view the PMB. Thanks,

$250 USD dalam 3 hari
(1 Ulasan)
0.0
bjnath

Hi, This is Mallikarjuna working as a WebDeveloper for the Past 2 Years in Chennai. You can view my latest work [url removed, login to view], which is maintained and developed by me.

$120 USD dalam 2 hari
(0 Ulasan)
0.0
mjcondon

These are the kinds of apps I specialize in. I can develop the app at a significant discount if more development opportunities can be mutually agreed upon. W3C/OWASP/WASC Compliant. Satisfaction 100% assured. Can start Lagi

$200 USD dalam 2 hari
(0 Ulasan)
0.0
ahmed19176

Iam new to this site but not new to this job let's start the task

$200 USD dalam 2 hari
(0 Ulasan)
0.0