DMC’s priority is to address pain points for customers. We started this project with a discovery phase to fully understand the functionality of the current solution and generate complete documentation of requirements. Then, we were able to create an architecture for a solution that addressed pain points while leveraging familiar tools and entry patterns by building within the SharePoint framework. A selection of custom forms was built using React Typescript in an SPFx webpart. These covered data entry needs for project initiation, budget entry and amendment, and tracking payment commitments and status. Budget information became easily available in a familiar table format on the landing page for each project. 

The approval process leverages Microsoft’s built-in solution for approvals for notification in Teams and Outlook. It uses Power Automate to pull in additional information from SharePoint Lists and the .NET backend. The approval status is displayed on the main project page within the custom webpart. This improved visibility for the team and allowed project managers to effectively delegate budget tracking tasks to others while still being able to track and approve overall project status. 

Additionally, DMC built automatic coversheet generation, which streamlined the processes for providing billing information to vendors and invoicing end clients. Generation is performed in the .NET backend, and documents are saved to the project SharePoint folders for easy re-access. Automated emails, including the relevant data and coversheets, are automatically set based on user-entered contact information.  

Learn more about DMC’s Custom Application expertise and contact us for your next project. 

The post Custom Budget Management Solution in SharePoint appeared first on DMC, Inc..

DMC’s client needed an efficient and seamless transition from File Explorer to SharePoint Online to improve their security and modernize their user experience while leveraging SharePoint’s enhanced file storage capabilities.

Design and Development

To assist the client, DMC held initial sessions to determine the ideal SharePoint Online structure and identify all files to be migrated. DMC also gathered employee information that would be required for the migration of personal folders to OneDrive. After these sessions, DMC methodically planned the site creation and migration timeline, which they then presented to the client team for approval.

Testing and Deployment

Once approved, DMC designed and implemented a custom SharePoint home page based on the customer’s branding. DMC ensured that all sites were locked down before making site changes. They implemented 49 site collections and the corresponding document libraries.

For enhanced security, DMC led the creation of a permissions structure with the client IT team, which was implemented site-wide. With permissions in place and confirmation from the client IT team that the Shared Drives were locked down, DMC migrated 1.3 TB worth of content to SharePoint Online and performed 750+ user migrations to individual OneDrive accounts.

If DMC can assist with any SharePoint Online transition, whether from an existing cloud setup or from a file server like this one, please feel free to reach out, and we’d be happy to help out!

Learn more about DMC’s Digital Workplace Solutions expertise and contact us for your next project.

The post SharePoint Setup with Data Migration appeared first on DMC, Inc..

The team began with UI design. The client requested a variety of pages, which DMC engineers created using React TypeScript and Material UI. Back-end programming was completed using C#, Microsoft Azure, and .NET Core. The resulting solution consolidated previous processes and streamlined the monitoring process. Staff watching the app to monitor alerts now have a cleaner interface, faster reporting, and more control over machines.

The post Location Monitoring Using React and .NET appeared first on DMC, Inc..

To begin designing a solution for the client, DMC met with key stakeholders to learn about the various departments and their functions. After understanding the client’s business model, DMC worked with each department head to determine what combination of Microsoft solutions was needed. This holistic approach allowed DMC to leverage Microsoft technology across departments and minimize information silos. 

Design and Development 

After gathering requirements, DMC began implementation. This included a custom SharePoint navigation header to easily navigate between site collections, creation of each site collection, and implementation of the SharePoint content managers such as document libraries, lists, pages, and news posts. 

DMC also created Power Automate workflows to minimize redundant tasks. For example, a Microsoft Form was created to allow external users to submit survey responses. When new responses were received, they were automatically added to a SharePoint list. This minimized the number of application touch points needed for day-to-day work. 

Additionally, DMC organized all the client’s SharePoint content into a spreadsheet to document permissions. DMC collaborated with the client’s IT department to create the necessary Active Directory and Microsoft 365 groups to efficiently manage permissions. 

Testing and Deployment 

DMC took an iterative approach to development, testing, and deployment. During the creation of features, the SharePoint site was locked down to those involved with development. Once larger features were implemented, the department heads were granted access to provide feedback. After all department heads were satisfied with their site and permissions were checked, the site was ready for the go live! 

Training and Support 

Prior to go live, DMC conducted both end user training and administrative training. During end user training, users received training on how to navigate the contents of the site and utilize other basic features such as adding files to a document library, adding and removing items from lists, and how to filter and sort lists to quickly find information. 

Administrative training was more in-depth and included tasks like updating list views and columns, updating pages, managing webparts, and managing permissions. 

Both training courses were vital in giving the client the confidence they needed to manage the site. Additionally, DMC continues to support the client by providing ongoing consultation on features and performing complex configuration as needed. 

Conclusion 

DMC’s detailed approach to implementing SharePoint sites gives clients a reliable framework to manage their business content. To learn more about how DMC can customize a Microsoft solution for your organization, contact us for your next project.

The post Custom Microsoft SharePoint Implementation appeared first on DMC, Inc..

DMC digitized this process by creating SharePoint lists for each sample the client received. For every sample the client received for testing, a new SharePoint project was created to store the data digitally. Once the new sample was logged and a project folder created, technical sheets about the product, the material, and the required tests could be stored inside. 

DMC added additional metadata fields where upper management could add test types, notes, work orders, agreements, and additional details. Lab managers would then view work orders and assign them to the appropriate staff online instead of having to manually input it into a scheduling system or do so on paper. Staff was then able to access this schedule and easily see their tasks for that day. 

This system eliminated the need for a hard copy system of logging samples and scheduling follow up tasks, creating a faster, and more efficient scheduling workflow. 

Learn how DMC’s SharePoint solutions can help you and contact us for your next project.

The post Digitizing Scheduling Workflow with Microsoft SharePoint appeared first on DMC, Inc..

MD4IoT goes beyond monitoring computers on a network. It can scan, detect, and report on OT equipment such as PLCs, HMIs, VFDs, and more. This information is aggregated into a local dashboard on the MD4IoT appliance and in the Azure dashboard for the product. It is ingestible by SOC software like Service Now (SNOW), Splunk, and LogRhythm.

DMC’s client reached out to get AD4IoT implemented at their various sites across the globe. We implemented the program in four phases: Discovery, Design, Deployment, and Operationalization.

Discovery

DMC began by collaborating with the client site and their third-party vendor to remotely gather information from the client’s existing network. We developed a questionnaire, and the answers helped us to determine the type of network the client used, the types of devices used, and the number of devices on that network. Our discovery included switch diagnostic information, which allowed developing detailed network diagrams and device relationships.

Design

Using the information gathered during the discovery phase, DMC built a map that plotted the connections between switches at each site. Once we had a thorough understanding of how each switch was connected, we created switch configurations to route OT traffic via SPAN/RSPAN to the central manager.

RSPAN was used for the distribution switches and SPAN was used for traffic mirroring to the sensor. We then developed commands for the sensor that was to be installed. The sensor is a local AD4IoT instance that aggregates traffic and sends data to the global central manager instance of MD4IoT used for reporting.

Deployment

Next, DMC installed the MD4IoT operating system, which is Ubuntu based, on the client-provided Dell R350 PowerEdge Server at each site. There were three network ports to configure on the server: one that was used for AD4IoT Management, one used for ingesting SPAN data, and one used for Dell server administration (iDRAC).

We reconfigured their network by adding around 15 – 20 configuration changes for each distribution and core switch. To minimize risk and issues that are likely to occur in OT Networks such as the high traffic caused by high-definition cameras, we performed thorough testing.

Operationalization

DMC then made improvements to the monitored targets and subnets that the SPAN brought in. We also applied alert filtering to reduce anomalies and false positives in reports. Any alert determined to be a false positive was cleared and filtered so that future alerts provided the most meaningful data.

Each server was connected to a central manager, which allowed the client to access data from multiple sites via a single pane of glass. DMC then conducted administrator training for IT and OT personnel so that they could operate the AD4IoT sensor appropriately.

Learn more about DMC’s Microsoft Azure Cloud Solutions and Services expertise and contact us today for your next project.

The post Operational Technology Network Security Monitoring appeared first on DMC, Inc..

DMC built an intranet on SharePoint Online that stored all the documents specific to the client. The internal site helped the client’s employees easily access information for documents pertaining to a specific customer. 

We worked to ensure that the intranet was based on the specific person logging in and built a Web Part that grants clients access to their specific intranet using two-factor authentication with Microsoft Authenticator. DMC also built an extranet for the client’s customers to be able to log in and access their documents with ease.

Our expertise in SharePoint Online, React, and .Net allowed us to provide the client with a cleaner interface and an easier navigable, more organized method of file tracking. Our clients now have better visibility of their documents, and they can provide their clients with a branded user interface.

Learn more about DMC’s Digital Workplace Solutions and contact us today for your next project!

The post Using SharePoint Online as an Extranet appeared first on DMC, Inc..

Before Power BI, the client was manually creating reports on a weekly/monthly basis to send to their company. Our work provided the client with a clean interface and an easy way to analyze their business data. DMC also increased reporting speed as the new reports automatically refresh.

The first Power BI report we built provided the client with a mechanism to match healthcare providers to hospital orders. We were able to match providers with hospitals based on location preference, specialty, and certification. The client can use Power BI’s drill through functionality to display only the orders a specific provider in their system qualifies for.

DMC continued to build Power BI dashboards using the client’s Azure SQL database as a data source and also built out a SharePoint site where they could store Excel documents that were used as data sources for some of the Power BI reports.

We created several types of reports: some of which were designed for management to view live and accurate numbers of order counts, submittals, revenue, and other metrics that help them follow the process of matching orders to healthcare providers.

Then, we built dashboards that allowed recruiters to view their own numbers in real time and track their performance from a recruiting standpoint. We used Power BI’s row level security to ensure that the recruiter could only view their own data.

DMC has had great success in building Power BI dashboards to give clients powerful insights into their data. We are also a proud Microsoft Solutions Partner with a designation in Data & AI (Azure) and held the Microsoft Gold Certified Partner status for 19 consecutive years prior. Our Microsoft partnership exemplifies our track record of creating great solutions using Microsoft Power Bi and the rest of the Microsoft stack of technologies.

DMC continues to build out the Power BI environment for the client to provide increased insight into their business data.

Learn more about our Microsoft Consulting Services, and contact us today for your next project.

The post Power BI Business Intelligence Dashboards appeared first on DMC, Inc..

First, DMC engineers retrieved exports from the third-party system. Our engineers then developed the architecture for document storage. They worked with the client to determine which metadata tags were useful for each employee to have. Once they established a structure for the site, our engineers imported the client’s data to the new system. A confidential document set for each employee was then auto created.

The new SharePoint implementation was programmed to tag document sets with useful information about employees such as their date of employment, office location, and title. Managers, HR, and other required personnel could access files and documents based on the user’s tagged information.

All new documentation moving forward was handled by the system that DMC created to automatically make document sets for each new employee. These sets provided the client with a place to sort, file, and apply custom permissions to all documents.

This solution provided the client with confidentiality protection while utilizing the document management capability offered out of the box by Microsoft 365.

Learn more about DMC’s Microsoft Consulting Services and contact us for your next project.

The post Managing Employee Files with Document Sets appeared first on DMC, Inc..

The team began with UI design. DMC used React TypeScript and Material UI to create a variety of pages for viewing and interacting with events and live data from RES’ sites. We completed back-end programming using C#, Microsoft Azure, and .Net Core. The resulting solution consolidated previous processes and streamlined the monitoring process. Staff who use the app to monitor alerts now have a cleaner interface and faster reporting.

Learn more about DMC’s Application Development expertise. 

The post Location Monitoring Using React and .NET Core appeared first on DMC, Inc..