Đã hoàn thành

import XML data from email into MS Access database

An MS Access import function is required which imports orders from a webshop into MS Access.

* * *

**Situation

**The requested application is intended for our use by the customers (merchants) of the webshop service we developed: [[url removed, login to view]][1] ([[url removed, login to view]][2]).

When a consumer has bought products in one of the webshops created with our service, the merchant receives an email with all the order details in an XML attachment. These order details can vary per webshop. We want to allow merchants to import these order details into an MS Access database.

Each XML with order details can be described as a dataset with the following structure:

- general order data as date, time, totals

- order lines (1 or more)

- delivery address of client

- billing address of client

Prior to importing the data, the merchant should place the order emails into a specific MS Outlook folder, named: 'orders new'. After succesful import, the emails have to be moved to another folder, names: 'orders processed'.

* * *

**Functionality of the import function**

1. read each XML attachment of the emails in folder 'orders new', add all data to a database and move email to folder 'orders processed'

2. configurater which allows to map fields from the XML document to database fields (because the contents of the XML attachment vary per merchant)

3. MS Access menu item to start import from MS Access

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP

MS Access XP

Kĩ năng: Dịch vụ trang web Amazon, Kĩ thuật, Microsoft Access, MySQL, PHP, Kiến trúc phần mềm, Kiểm tra phần mềm, Web Hosting, Quản lý website, Thử nghiệm trang web

Xem nhiều hơn: use of data structure, new hire email, new data structure, ms new hire, ms access with php, data structure.com, data structure code, c map data structure, application of data structure in c, application of data structure, access database software, start an email, ms access web database, ms access to web, ms access email, MS Access Database, import XML, data importing, import access database php, client database billing

Về Bên Thuê:
( 2 nhận xét ) Netherlands

ID dự án: #3364143

Được trao cho:

airmaxua

See private message.

$38.25 USD trong 30 ngày
(6 Đánh Giá)
3.5

4 freelancer đang chào giá trung bình $39 cho công việc này

Prashantskin

See private message.

$34 USD trong 30 ngày
(511 Nhận xét)
7.0
ItIndia

See private message.

$42.5 USD trong 30 ngày
(125 Nhận xét)
5.9
intersoftdev

See private message.

$42.5 USD trong 30 ngày
(13 Nhận xét)
4.2