|
Server/SharePoint/Tools
Automatically update SharePoint WebPart from Visual Studio Code
|
19.12.2019 56
|
|
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 40
|
|
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 51
|
|
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 38
|
|
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 68
|
|
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 41
|
|
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 44
|
|
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 34
|
|
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 38
|
|
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 55
|
|
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 52
|
|
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 65
|
|
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 59
|
|
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 88
|
|
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 120
|
|
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 119
|
|
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 202
|
|
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 123
|
|
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 143
|
|
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 678
|
|
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 1542
|
|
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 2721
|
|
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 1202
|
|
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 870
|
|
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 1018
|
|
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 1316
|
|
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 1572
|
|
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
|
|
Server/Management-Studio
SQL Server: Anmelden mit .\Sqlexpress
|
07.03.2017 1272
|
|
SQL Server: Anmelden mit Sqlexpress
Log on to a local SQLExpress database
When using the SQLExpress version of SQL Server from Microsoft, you should always make sure that the servername with Sqlexpress is set as default
The characters Before the serve
|
|
Server/Tutorial
SQL Server: Copying a table
|
20.12.2016 1247
|
|
SQL Server: Copying a table
How to copy a table in SQL Server
Microsoft SQL Server Management Studio
Select the table
Then in the context menu of the table about the script for creating a table
: scriptTable as -> CREATE to-> New
|
|
Server/Tutorial
SQL Server: Saving changes is not allowed.
|
16.12.2016 1733
|
|
SQL Server: Saving changes is not allowed
Problem:
SQL Server shows that saving changes is not allowed
Solution:
Set the permissions under Tools Options Designer
Error message when saving:
SQL Server: Saving changes is
|
|