January 15, 2021

Connections Excel Tool Presentation

This post is a placeholder for a potential presentation. 
It was submitted to DNUG Connections German User Group https://dnug.de/call-for-abstracts/

Abstract / Summary

This presentation presents a tool used at Continental for extracting data from HCL Connections into Excel.
The tool is implemented in Excel with vba/ macros. 
It is available as open source here.

Duration: 30min-60min depending on interest, questions, how deep you want the tool to be explained (incl. implementation explanation or not).
  • Feature highlights
  • Implementation/ technology highlights

Use Cases / Feature highlights

Export a profile search into Excel

Fill User information from ConNext Directory

Based on email in a Table column
Extract also Profile Picture to Column as comment

Extract also Tags with Pre-filtering

Export Feed (e.g. Forum Entries) into Excel

Consolidation of Feed export aggregating over the number of result pages
Get&Transform/PowerQuery

See detailed post here

Network Reporting for Profiles based on Tags taxonomy

Based on this tool we can do a network tag-based analysis / report. 
Example all Knowledge Brokers in the company with distribution over the tools/expertise areas they support.

One can handle the reporting either in Excel or PowerBI.

No comments:

Post a Comment