Đã hoàn thành

146587 Email to XML web service

Email to XML web service (based on Microsoft technology, it needs to be installed on a microsoft server, no unix)

What we need is a web service which can transform the content of an e-mail to an XML file (this XML will be imported into our database). The e-mail will have customer data like organisation name, contact persons name, address, telephone etc. This data needs to be transformed into the correct names and then put into an XML file. The main ‘problem’ will be mapping the name used in the content of the e-mails with the names used in our database. For example:

e-mail with the following content:

Organisation name: Company X

Person: M. Homefield

Telephone: + 31 23 5125252

Gender: Male

These fields needs to be mapped to the following fields and transformed into an XML file:

Organisation name = Organisation

Person = initials: M.

Surname: Homefield

Gender = Gender / Male = M

So basically what needs to be build is:

A mapping tool where a customer can store a template, based on example above

Map the following fields:

Organisation name = Organisation

Person = initials:


Male = M

A user needs to do this in a user friendly way.

This mapping needs to be stored so from that point on the user can redirect an email to the web service (a special email address) and the service will scan the email and transform it (with the template as reference) into an XML file which will be delivered to our program (also a web service which can read XML files)

The mapping will be pretty much straight forward (Organisation name map on Organisation etc.) but the one which needs to have some intelligence is the Person one. For example: Michael van Buren needs to be broken down into

First name: Michael

Initials: M

Middle name: van

Lastname: Buren

There will be a dozen or so middle names to consider but we can provide them, so it will not be that hard.

Besides making a template for the mapping, a user can also configurate some things: This configuration will result in automatically adding some extra field to the XML field, predefined by the user. An example is categories. The user sets that every email send to the web service with the email address importfromwebsite1(email sign)[url removed, login to view] needs to have the category “source: Website” added. So what will happen. An email is send to the webservice email address, the data is transformed to a XML file and the field: Source= website is added to the XML file before it is presented to our database. The user can make different email addresses with different rules (The rules will only be about adding one or more fields with predefined data).

Ofcourse the settings and mapping needs to be possible in a user friendly gui.

Kĩ năng: AJAX, Bất kì công việc gì, Thiết kế đồ họa, HTML, SQL, XML

Xem nhiều hơn: xml web server, web tool design, web design company names, web based graphic design tool, unix service, tool design web, to-do categories, store web template, some graphic design company names, service source, service first, rules for web design, nl graphic design, names of graphic design company, names for web design company, graphic design web service, graphic design customer service, e service company, design web service, design web gui tool, design intelligence, data map template, customer service contact, customer email template, correct email address

Về Bên Thuê:
( 19 nhận xét ) Raamsdonkveer, Netherlands

ID dự án: #1892764

Được trao cho:

$80 USD trong 3 ngày
(92 Đánh Giá)