Key Points

an integrated SharePoint app for collaboration with links to other Microsoft apps
Basically an improved version of Lotus Domino Sametime from 2001
Sharepoint docs can be accessed by tools for reporting etc ( using JDBC, ODBC drivers that are free )

References

Reference_description_with_linked_URLs_______________________	Notes____________________________________________________________________________

windows-commands-document.pdf


ftp-windowsitpro.com-FTP using PowerShell-microsoft.pdf

Windows file handlers
windows-add-default-file-type-associations-superuser.com-Adding or registering a file type so it can be associated with an application.pdf	Set a Windows file type handler

Teams features
Teams keyword searches for messages, files	Teams keyword searches for messages, files **
MS KQL search reference	MS KQL search reference **




Windows apps & tools

	vscode
	sharepoint cms
	ms teams sharepoint app
SharePoint references
MSFT SQL Server JDBC driver support policies
export sharepoint list to excel for jdbc access	https://support.microsoft.com/en-au/office/export-an-external-list-to-excel-fcbb5cdc-cf49-4131-8294-21bc25e66952
Eclipse Sharepoint JDBC Driver
free MSFT SQL Server JDBC drivers	can these drivers access Sharepoint docs ?
billable cdata Sharepoint JDBC driver	https://www.cdata.com/drivers/sharepoint/jdbc/
billable Progress Sharepoint JDBC driver	https://www.progress.com/jdbc/microsoft-sharepoint

MS Project references

Key Concepts

Teams CMS App

Team feature summary

teams notes from

------------------------
teams project workspace 

teams = domino sametime ..

integrates 
	files, docs
	messaging
	meetings online
	calling
	office access
	shifts for scheduled work
	group calendar usage?

	activity feed w filter
	@mentions
	chats - pin to top 
	teams ..  dept or project level .. channels in a team for topics 
		multi language
		channels x work type, role, vendor
		messages w attachment files
		can open in sharepoint
	all uses onedrive storage
	sharepoint runs teams app
	search by your name, date etc
	q> how to search by title, topic, channel, date, author etc
	q> full text or tag or attribute search ??? eg cql

	can add msoft apps to teams links ( power bi etc )
	app store integration
	meetings scheduled and live events
	q> private threaded conversations ???
	
	teams native integration w office is pointless - just share window
	psd calling integration options
	
	admin
	can set data loss policies for chats, files etc
	control teams apps rules
	monitor teams, activities
	option for policies per user
	meeting record options
	messaging - chat settings
	org wide settings for external access, guest access
		
	quick start
	enable teams 
	aka.ms/successwithteams
	enable in tenant

Teams Meeting Recordings

Save a Teams video as mp4

Generate and save Teams Transcript

---------------
save transcript from ms teams meeting?

recording transcripts in teams meetings
https://www.youtube.com/watch?v=kD50wjtz18w

access transcript from the chat application view
you can download the transcript as word doc
or
go to calendar and open the transcript box on the meeting calendar

transcript NOT available in channel meetings ...

recording transcripts in teams meetings
https://www.youtube.com/watch?v=PqzGP40Krks

MUST run meeting from a teams calendar event

go to chat tab in teams to find transcript file

download teams recording
https://www.youtube.com/watch?v=PuBgkZW6Xbc

how to extract video from teams meetings
https://www.youtube.com/watch?v=-RTFBsqTXEA

Microsoft KQL Content Search - Teams, SharePoint

https://learn.microsoft.com/en-us/sharepoint/dev/general-development/keyword-query-language-kql-syntax-reference

Teams Search Commands

https://tech.rochester.edu/using-the-search-bar-in-microsoft-teams/

For more advanced searches in messages, you can use the built-in Keyword Query Language (KQL). Below are the keywords that Teams supports. Note: there’s no space between the colon and the search terms.

“From:Then” enter the person’s name
“In:Then” enter the channel or group chat name
“Subject:The” keyword from a message or a subject line
“Sent:The” date the message was sent

The search feature isn’t just a simple find in Teams. It’s been overloaded with commands. To view the list of available commands type “/” into the search bar.

MS KQL search reference **

https://docs.microsoft.com/en-us/sharepoint/dev/general-development/keyword-query-language-kql-syntax-reference

Syntax	Returns
`author:"John Smith"`	Returns content items authored by John Smith.
`filetype:docx`	Returns Microsoft Word documents.
`filename:budget.xlsx`	Returns content items with the file name `budget.xlsx`.

keyword search examples

author:Shakesp*

title:"Advanced Sear*"

title:"Advanced Sear*"

The following queries do not return the expected results:

title:"Advan* Search"

title:"Advanced Sear"

Using phrases in the free-text KQL query

For example, the following KQL queries return content items that contain the terms "federated" and "search":

federated search

federat* search

search fed*

KQL queries don't support suffix matching.

When you use phrases in a free-text KQL query, Search in SharePoint returns only the items in which the words in your phrase are located next to each other. To specify a phrase in a KQL query, you must use double quotation marks.

KQL queries don't support suffix matching, so you can't use the wildcard operator before a phrase in free-text queries. However, you can use the wildcard operator after a phrase.

Date searches

ISO date formats

YYYY-MM-DD
YYYY-MM-DDThh:mm:ss
YYYY-MM-DDThh:mm:ssZ
YYYY-MM-DDThh:mm:ssfrZ

LastModifiedTime>=yesterday

LastModifiedTime>=2019-01-01 AND LastModifiedTime<=2019-04-26

SharePoint CMS

Search in SharePoint

supports several property operators for property restrictions, as shown in Table 2.

Table 2. Valid property operators for property restrictions

Operator	Description	Supported managed property type
:	Returns results where the value specified in the property restriction is equal to the property value that is stored in the Property Store database, or matches individual terms in the property value that is stored in the full-text index.	Text DateTime Integer Decimal Double YesNo
=	Returns search results where the property value is equal to the value specified in the property restriction. Note: We do not recommend combining the=operator together with asterisk (*) when you do exact matching.	Text DateTime Integer Decimal Double YesNo
<	Returns results where the property value is less than the value specified in the property restriction.	DateTime Integer Decimal Double
>	Returns search results where the property value is greater than the value specified in the property restriction.	DateTime Integer Decimal Double
<=	Returns search results where the property value is less than or equal to the value specified in the property restriction.	DateTime Integer Decimal Double
>=	Returns search results where the property value is greater than or equal to the value specified in the property restriction.	DateTime Integer Decimal Double
<>	Returns search results where the property value does not equal the value specified in the property restriction.	DateTime Integer Decimal Text Double YesNo
..	Returns search results where the property value falls within the range specified in the property restriction. For example, the range A..B represents a set of values from A to B where both A and B are inclusive. For date ranges this means from the beginning of day A to the end of day B.	DateTime Integer Decimal Double

SharePoint search examples

https://learn.microsoft.com/en-us/microsoft-365/community/query-string-url-tricks-sharepoint-m365

search

https://learn.microsoft.com/samples/search?products=m365&languages=javascript

browse

https://learn.microsoft.com/samples/browse?products=m365&languages=javascript

edit mode for a url

https://<yoursite>.sharepoint.com/sites/<sitename>/SitePages/default.aspx?Mode=Edit

Other Microsoft Collaboration Products

Audio-codes integrates with many products including Teams

Market Trends and Challenges: The transcript highlights the ongoing transition to cloud-based and subscription-oriented unified communications, the rise of the hybrid workplace merging office and home environments, and the resurgence of voice interaction, propelled by AI advancements.
AudioCodes' Offering: AudioCodes presents a comprehensive suite of voice solutions for Microsoft Teams, encompassing direct routing, operator connect services, certified business phones, and meeting room devices.
Enhanced Features: Additional offerings include solutions for compliance recording, conversational interactions, and meeting productivity enhancements, aiming to enrich the Microsoft Teams experience.
Subscription Service: AudioCodes Live services consolidate these offerings into a subscription model, simplifying access even for those without in-house voice expertise.
Partner Opportunities: The company promotes significant market opportunities for Microsoft partners to add value and increase revenue through its nearly three-decade track record in the VoIP industry, inviting partners to join their global community.

khub

m MS Teams & Sharepoint