OCM => Sharepoint/Power BI => Teamleader overview

%3CLINGO-SUB%20id%3D%22lingo-sub-285227%22%20slang%3D%22en-US%22%3EOCM%20%3D%26gt%3B%20Sharepoint%2FPower%20BI%20%3D%26gt%3B%20Teamleader%20overview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285227%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Anyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20some%20of%20you%20can%20he%2Cp%20me%20out%20with%20any%20help%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20like%20to%20use%20OCM%20for%20some%20time%20until%20our%20own%20IT%20Team%20comes%20up%20with%20a%20new%20solution.%20So%20far%20for%20our%20Sales%20Team%20it%20is%20most%20likely%20all%20we%20need%20in%20the%20moment.%20I%20added%20the%20needed%20lines%20to%20the%20Contacts.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20i%20have%20some%20understanding%20questions%3A%3C%2FP%3E%3CP%3E1.%20after%20installation%20it%20opens%20a%20group.%20Also%20i%20can%20share%20my%20contacts%2C%20Companies%20and%20Deals%20with%20Team%20Members.%20How%20can%20generate%20an%20overview%20on%20a%20sharepoint%20site%20for%20our%20Team%20Leader%20or%20even%20in%20Power%20BI%20to%20give%20him%20overview%20in%20what%20situation%20the%20leads%20%26amp%3B%20Prospects%20of%20each%20Member%20is%3F%3C%2FP%3E%3CP%3E2.%20How%20can%20i%20access%20the%20database%3F%20Where%20are%20the%20Deals%20and%20Companies%20stores%3F%20So%20far%20just%20a%20contact%20pops%20up%20as%20soon%20as%20i%20make%20one%20for%20a%20company.%3C%2FP%3E%3CP%3EAfter%26nbsp%3BI%20import%20a%20list%20of%20companies%20in%20OCM%20they%20didn't%20showed%20up%20in%20my%20Outlook%20contacts%2C%20which%20is%20totally%20fine...%20%3A)%3C%2Fimg%3E%20but%20where%20are%20they%20and%20how%20can%20i%20make%20a%20sharepoint%20list%20of%20those%20contact%20given%20free%26nbsp%3B%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20or%20suggestion%20how%20i%20can%20make%20an%20Overview%20for%20the%20team%20leader%20in%20which%20phase%20are%20how%20many%20companies%20and%20how%20many%20Actions%20(Phone%2FEmail%2FMeeting)%20are%20added%2FDone%20would%20be%20great.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20the%20best%20to%20anyone%20and%20thanks%20for%20your%20help%20in%20advance...%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENicolas%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-285227%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECRM%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Business%20Premium%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOutlook%20Customer%20Manager%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285735%22%20slang%3D%22en-US%22%3ERe%3A%20OCM%20%3D%26gt%3B%20Sharepoint%2FPower%20BI%20%3D%26gt%3B%20Teamleader%20overview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285735%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Leo%2C%3C%2FP%3E%3CP%3Ethanks%20for%20your%20answer.%3C%2FP%3E%3CP%3EGot%20a%20question%20for%20you.%3C%2FP%3E%3CP%3EIf%20the%20Data%20is%20stored%20in%20the%20Group%2C%20which%20also%20has%20a%20SharePoint%20site%20automaticly%2C%20is%20there%20any%20way%20i%20can%20make%20a%20list%20view%20in%20the%20SharePoint%20site%20which%20contains%20the%20Contact%2FCompany%20and%20Deal%20Information%20which%20are%20shared%20with%20this%20group%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENicolas%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285733%22%20slang%3D%22en-US%22%3ERe%3A%20OCM%20%3D%26gt%3B%20Sharepoint%2FPower%20BI%20%3D%26gt%3B%20Teamleader%20overview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285733%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Nicolas%2C%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20for%20posting%20here.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.Based%20on%20my%20experience%2C%20there%20is%20no%20method%20to%20link%20the%20OCM%20items%20with%20PowerBI%20or%20SharePoint%20site.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E2.The%20data%20is%20stored%20in%20the%20corresponding%20O365%20group%20named%20%22Outlook%20Customer%20Manager%22%20that%20the%20system%20generated%20at%20the%20first%20time%20you%20use%20OCM.%20But%20it%20cannot%20be%20directly%20accessed%2C%20you%20may%20use%20the%20export%20button%20in%20OCM%20to%20export%20them%20in%20a%20CSV%20file%26nbsp%3Bto%20make%20lists%20of%20them.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegards%2C%3C%2FP%3E%0A%3CP%3ELeo%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi Anyone, 

hope some of you can he,p me out with any help here.

 

I like to use OCM for some time until our own IT Team comes up with a new solution. So far for our Sales Team it is most likely all we need in the moment. I added the needed lines to the Contacts. 

 

Now i have some understanding questions:

1. after installation it opens a group. Also i can share my contacts, Companies and Deals with Team Members. How can generate an overview on a sharepoint site for our Team Leader or even in Power BI to give him overview in what situation the leads & Prospects of each Member is?

2. How can i access the database? Where are the Deals and Companies stores? So far just a contact pops up as soon as i make one for a company.

After I import a list of companies in OCM they didn't showed up in my Outlook contacts, which is totally fine... :) but where are they and how can i make a sharepoint list of those contact given free ? 

 

Any help or suggestion how i can make an Overview for the team leader in which phase are how many companies and how many Actions (Phone/Email/Meeting) are added/Done would be great.

 

All the best to anyone and thanks for your help in advance... :)

 

Nicolas

 

2 Replies
Highlighted

Hi Nicolas, 

 

Thanks for posting here. 

 

1.Based on my experience, there is no method to link the OCM items with PowerBI or SharePoint site. 

2.The data is stored in the corresponding O365 group named "Outlook Customer Manager" that the system generated at the first time you use OCM. But it cannot be directly accessed, you may use the export button in OCM to export them in a CSV file to make lists of them. 

 

Regards,

Leo 

Highlighted

Hi Leo,

thanks for your answer.

Got a question for you.

If the Data is stored in the Group, which also has a SharePoint site automaticly, is there any way i can make a list view in the SharePoint site which contains the Contact/Company and Deal Information which are shared with this group?

 

Thanks for your help in advance.

 

Nicolas