Excel and CSV download manipulation of data

Đã hoàn thành Đã đăng vào Apr 1, 2010 Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

Hi Freelancers,

this is not the sort of job I normally would post so I hope it will make sense.

I am currently downloading an excel list of data from my website which is broken down into field parameters, e.g name, address, email address etc. we also download within this data the products that the customer has purchased, this in most cases will be fairly simple if the customer has bought only one item as this appears on one line in excel. However, if the customer has purchased more than one product the second product purchaed appears on a seperate line in excel. We wish to transfer this data across to an email CRM system but we have a problem. The data needs to be transfered across so that all of the products purchased by the relevant customer appear on one single line in excel, I have attached an example of how our data currently is downloaded. This data is downloaded on a weekly basis with multiple purchases per customer.

What we wish to happen is that once this complete data list has been transfered to the CRM system that we will download weekly and then upload this data to the CRM system. So, the initial part of the project is to create a formula that can attribute any seperate product lines to the customer line in seperate fields. The second part of the project is to formulate either with excel or SQL, any subsequent orders with customers that already in the CRM database are appended to the customer in seperate fields. If the customer purchases the same product regularly for 10 ocassions this product should only be listed in 1 field as it is repeated, however, if the customer purchases something different on the 11th purchase the new unique product is appeneded under a seperate field.

This needs to be a lasting solution so that each unique record will be updated with the latest purchase information on a regular basis.

I hope I have outlined sufficiently the project, I would appreciate any questions if you require further information.

CRM Nhập liệu Xử lí dữ liệu Excel SQL

ID dự án: #649581

Về dự án

47 đề xuất Dự án từ xa Apr 8, 2010 đang mở

Được trao cho:

cdumitru

Hello, I would like to do this project. Please see PMB. Best regards, CDumitru

$50 USD trong 1 ngày
(5 Đánh Giá)
3.2

47 freelancer chào giá trung bình$166 cho công việc này

HussienSharaf

hi, I have made similar projects recently. plz check PM Regards, Hussien Sharaf

$240 USD trong 4 ngày
(42 Nhận xét)
7.1
mrbrave

See PMB Please.

$100 USD trong 1 ngày
(307 Nhận xét)
7.0
AlosDeveloper

Hello, please see PMB

$250 USD trong 10 ngày
(42 Nhận xét)
6.3
spawar

Hi, I have very good experience of xls VBA macros. I will do it exactly as per your requirements. Ready to start it immediately. Interested to work with you long term.

$200 USD trong 3 ngày
(60 Nhận xét)
6.2
jay2success

Hi, i am Jay. How are you? Please check PM. Thanks and have a nice day.

$150 USD trong 5 ngày
(58 Nhận xét)
6.3
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$225 USD trong 4 ngày
(41 Nhận xét)
6.3
vserv

Pls see your PMB. Thanks

$75 USD trong 5 ngày
(62 Nhận xét)
5.9
nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

$150 USD trong 4 ngày
(64 Nhận xét)
5.7
schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram

$200 USD trong 5 ngày
(46 Nhận xét)
6.0
garbar

Ready to start,send pm for detail

$130 USD trong 5 ngày
(72 Nhận xét)
6.2
toinnisfree

pls chk pmb

$150 USD trong 3 ngày
(31 Nhận xét)
5.3
ccpplinux

Hi, Please see PMB for more details. Best Regards ... ccpplinux

$100 USD trong 5 ngày
(38 Nhận xét)
5.4
agihcam

Please check PMB.

$50 USD trong 2 ngày
(42 Nhận xét)
5.1
piyushdpatel

Hi This is Piyush Patel I have 5 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$100 USD trong 3 ngày
(8 Nhận xét)
4.6
florinserban

Hi. Please check PM. Thanks!

$150 USD trong 3 ngày
(6 Nhận xét)
4.7
Wonderer

Hi I do completely understand what's required. Thanks Al

$250 USD trong 5 ngày
(16 Nhận xét)
4.2
arudam

Hi, Here is the place for excel and data manipulation. thanks

$200 USD trong 8 ngày
(27 Nhận xét)
4.3
asaikiran1979

Hi, Check pm.

$75 USD trong 30 ngày
(46 Nhận xét)
4.9
UltimateJob

Please checK PMB. Regards

$200 USD trong 5 ngày
(7 Nhận xét)
3.7
oFAZo

Exceptional quality & Quick work. Please refer to Profile, Reviews & PMB for details. Thanks FAZ

$175 USD trong 2 ngày
(14 Nhận xét)
4.6