Käynnissä

Migrating to a new crm

I would like to bring to your attention a problem we are experiencing as regard as our CRM. Actually we are migrating to a new crm software; so we are arranging data in order to export them from the old crm to the new one. Both the crm softwares import and export data in excel format.

We got a problem as regard as a 1 to many relationship.

Indeed, due to a limitation of our previous crm we are not able to achieve a unique excel file containing all the data we need. Multiple exports and relative merging via cut & paste have been performed in order to achieve the final excel file to import in the new crm software. (i.e.

[url removed, login to view], see the attach).

Unfortunatelly, the data relative to the transcription of phone conversations have been stored by our previous crm in a particular way so that we are not able to export them merged and joined to its unique relative and single record.

As you can view on your own in the "conversation.xls" file there are as many fields (IDcliente)recurrences as input performed by the crm operator.

We'd like, first of all, to merge them (one idclient - one single conversation field) and then join the entire column "Conversazione" to the others contained in the file named:

"totale.xls".

Obviously the relationship among them have to be considered the field "idcliente", like in a traditional "1 to many relationship".

Would you be so smart to perform this task for us using the two attached files for a try?

Thanks for the attention

best regards

Taidot: tekniikka, Excel, Järjestelmänvalvoja

Näytä lisää: export crm excel, task transcription, smart input, smart and final, recurrences, i need a crm excel system, field engineering, data input operator, migrate data crm excel file, crm project, new excel, Data e try, smart xls, regard, migrating, indeed, Exports, crm export, file cut paste, cut paste file, crm order, task export, task export data, excel order system, conversations

Tietoa työnantajasta:
( 20 arvostelua ) Roma, Italy

Projektin tunnus: #447966

Myönnetty käyttäjälle:

nagybatonyi

To make sure I understood exactly xour request I've made a trial solution assumpting that in your live files IDCliente strings will match in [url removed, login to view] and [url removed, login to view] and attached it to my post in PMB. To demons Lisää

30 $ USD 0 päivässä
(53 arvostelua)
5.7

4 freelanceria on tarjonnut keskimäärin 30 $ tähän työhön

AlosDeveloper

Hi, please see PMB.

30 $ USD 0 päivässä
(8 arvostelua)
5.3
maneseema

having Strong exp in VBA XL this can be done sing XL funtion only

30 $ USD 0 päivässä
(0 arvostelua)
0.0
MrJTheExpert

Dear Sir, I am Computer Engineer and have strong background of working on Excel and other databases related projects. I can do it quite easily and efficiently. I am asking for two days to ensure the best quality of wo Lisää

30 $ USD 2 päivässä
(1 arvostelu)
0.0