|
Server/SharePoint/WebParts
SharePoint CamlQuery Sum
|
25.03.2020 54
|
|
Query Sum in
SharePoint with a CamlQuery
In
SharePointOnline mit pnp sp, React WebParts
Import der
pnp sp
|
|
Server/SharePoint/Tools
How to debug a webpart in VS Code with the Microsoft Browser
|
25.03.2020 64
|
|
Settings for VS
Code ->SharePoint Web Part Development so that the Microsoft Edge Browser
can be used to directly examine the WebPart in SharePoint Online
launch json
Settings vscode launch json
Please make sure
that the new
|
|
Server/SharePoint/WebParts
Code Sample to Hello World SharePoint WebParts and Lists
|
16.03.2020 39
|
|
SharePoint Liste
in Webpart, Code
SharePoint
WebPart Code des HelloWorld Sample
Typescript,
React
WebPart
Code
WebPart01WebPart ts
Directory : src webparts WebPart01 WebPart01WebPart ts
|
|
Server/SharePoint/Tools
Automatically update SharePoint WebPart from Visual Studio Code
|
19.12.2019 207
|
|
This guide sends changes from SharePoint WebParts to the DevOps server and installs them automatically
Step 1: Name changes
First, you give a label to the changes in the code
You click on the Git symbol on the left, then you enter a tex
|
|
Server/SharePoint/Tools
Deploy SharePoint WebParts automatically
|
19.12.2019 204
|
|
If in DevOps of deployment has been switched to automatic deployment, then any programming in Visual Studio code is automatically distributed after synchronization
That is, you write a change to a WebPart in Visual Studio Code, enter the title of the change in the synchronizatio
|
|
Server/SharePoint/Tools
Include SharePoint Lists in MS Access
|
18.12.2019 213
|
|
Include SharePoint Lists in MS Access
Under Microsoft Access, you can directly bind SharePoint lists from SharePoint Online and the on-Premise Framework as bound datalists
After that you can edit the data directly here
How to include SharePoint lists in
|
|
Server/SharePoint/WebParts
SharePoint Code: Get ListItem by Code
|
17.12.2019 199
|
|
With the following React code you can
find an item from a list in SharePoint and then evaluate it
The underlying code is
|
|
Server/SharePoint/WebParts
Debugging with the Microsoft Browser in VS Code
|
17.12.2019 416
|
|
Many SharePoint applications run in
Citrix environments and customer corporate environments using Microsoft
Internet Explorer MSIE or Microsoft Edge
If you want to create, develop and
debug reproducible test developments for SharePoint solutions at the c
|
|
Server/SharePoint/WebParts
Debugging von SharePoint in Visual Studio Code
|
17.12.2019 196
|
|
In order to debug a SharePoint
application or a SharePoint WebPart directly in VSCode, you have to use the
launch json file in the
Name: Hosted workbench the registration
url: enter the SharePoint Workbench on the target server system
the hosted workben
|
|
Server/SharePoint/Error
Error SharePoint Gulp Serve: Local modules not found in
|
16.12.2019 234
|
|
SharePoint: Local modules not found in
when you create a new WebPart in SharePoint or get the code from the DevOps directory you cannot run gulp serve for debugging
Error message for gulp serve
|
|
Server/SharePoint/WebParts
Publish Install SharePoint WebPart on Server
|
16.12.2019 199
|
|
How to copy the locally developed code of a web part to the server ?
è With the following script you can deploy a web part automatically to the server under VS Code, React
|
|
Server/SharePoint/WebParts
Enable JS-Link for WebParts in SharePoint
|
16.12.2019 196
|
|
SharePoint: Enable Javascript
the following commands allow you to enable embedding client scripts for web parts in SharePoint for a specific site
As a result, the client scripts used under JS-Link are active on WebParts
|
|
Server/SharePoint
SharePoint setting: Open in the Office app
|
22.11.2019 148
|
|
Where to change the settings in SharePoint so that a document opens directly in a list in the Office application and not in the browser
|
|
Server/SharePoint
Issues in SharePoint: Service Status
|
22.11.2019 154
|
|
Where can I check if there are any problems in SharePoint or the attached Office applications?
To do this, go to Microsoft 365 Admin Center->Status->ServiceStatus->All Services (or Recommendations)
Then open the incident
|
|
Server/SharePoint
Where are the Status Messages from SharePoint Online
|
22.11.2019 161
|
|
Where can I find the messages about SharePoint activities and changes in your own SharePoint page?
The descendants can be found in Admin Microsoft com->AdminPortal->Status->Message Center
Nachrichtencenter
Each message gives you a rough overvi
|
|
Server/SharePoint
Error: Server relative urls must start with SPWeb.ServerRelativeUrl
|
21.11.2019 160
|
|
Error: Server relative urls must
start with SPWeb ServerRelativeUrl
making HttpClient request in
queryable [400] Bad Request System ArgumentException
sp web
|
|
Server/SQL
SQL Commands
|
24.10.2019 213
|
|
SQL Transact Commands
the following 4 SQL commands are required when accessing data in SQL Server tables
SELECT
INSERT
UPDATE
DELETE
On a SQL server, data resides in tables
The SQL Server tables are listed un
|
|
Server/SQL
Install SQL Server Express Edition and Start login
|
24.10.2019 237
|
|
Download SQL SErver Express Edition at: version 2017
There are 2 versions:
Express Edition
SQL Server 2017 Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications
&eg
|
|
Server/Management-Studio
SQL Server Management Studio : Install a different language
|
24.10.2019 293
|
|
on the following page you can download a suitable language pack for the Microsoft SQL Server Management Studio
There are the following language packs
Available languages (SSMS
|
|
Server/Tutorial
Create a Console App with Timer
|
17.10.2019 444
|
|
Embed console
with timer
Code example for
creating a Consollen application with a timer
in Visual STudio 2019
Console in Core
using
|
|
Server/Tutorial
Synchronize Azure DevOps with local code directory
|
17.10.2019 260
|
|
Step 1: Azure DevOps
First create a new project in Azure Devops and then select a repos
A: Start empty project:
To do this, open Azure Devops
then open a project and click on the repository (file management)
then click
|
|
Server/Tutorial/VS-Code
Error message: git The name git was not used as the name of a cmdlet, function, script file, or executable program detected
|
17.10.2019 285
|
|
Error message: git : The name "git" was not used as the name of a cmdlet, function, script file, or executable
program detected
Error message in VS Code and Windows Powershell (admin)
gi
|
|
Server/Tutorial
Edit data in SQL query, on SQL Server Management Studio SSMS
|
08.11.2018 834
|
|
Edit data
in SQL query
Edit records in SQL Management Studio
Data
queries in Microsoft SQL Server Management Studio can only open and edit the
first 200 records
With a
trick you can edit more records
|
|
Server/SQL/Errors
SQL exception unhandled
|
19.02.2018 1716
|
|
When
trying to save a URL in a SQL database using sqlclient and T-SQL
Error message:
System Data SQLClient SqlException:
'Incorrect syntax near
|
|
Server/SQL/Errors
SQL error: Can not insert the value NULL into column IDDetail
|
04.01.2018 3079
|
|
SQL error: Can not
insert the value NULL into column IDDetail
With C # applications, a database
error is reported:
System Data SqlClient SqlException
occurred
|
|
Server/SQL
SQL Server Warning: Data loss could occur
|
14.12.2017 1401
|
|
When
modifying tables in SQL Server Object Explorer in Visual Studio 2017 by
renaming column fields,
then
threatens the complete loss of data in a SQL Server database
Important is T-SQL: If you change a
field name in the T-SQL area of โโthe table design of a
|
|
Server/SQL
SQL Server: Default default current time
|
13.12.2017 1021
|
|
How do
you enter the current time in a SQL Server database as the default value in a date
field?
[dtEdit] DATETIME
|
|
Server/Management-Studio/Errors
SQL Server Problem: File path can not be accessed and can not be searched
|
09.03.2017 1153
|
|
Problem: File path can not be accessed and can not be searched
SQL Server 2014
Problem:
Since the upgrade to SQL Server 2014 I can only place the data path under the standard path of MS SQL Server 2014
The file IDs and accesses do not find any files and
|
|
Server/Management-Studio
SQL Server 2014: Can not connect to SQLEXPRESS
|
09.03.2017 1476
|
|
error message
No connection to SQLEXPRESS can be established
Details
Network-related or instance-specific error when connecting to SQL Server
Server not found or can not be accessed
Verify that the instance name is correct and that SQL Server al
|
|
Server/Management-Studio
SQL Server: Compress a SQL Database with Shrink Database
|
09.03.2017 1784
|
|
SQL Server: Shrink Database
Task: Shrink or compress the database
Over time, databases are getting bigger and bigger This is also due to the fact that data that is deleted is only internally blown out
Therefore, it is often recommended to compress the database fro
|
|