Victor Looren de Jong
Home
Projecten
Demo's
Leerpad
Voortgang
Uren verklaring
Over mij
Runways
Runways
Op deze pagina worden alle project uitdagingen en toekomstplannen weer gegeven.
Als ik een oplossing hier voor heb, dan sla ik het op in mijn Progress Application,
bij Challenges en Additions. Hierdoor kan ik terugvinden waar ik in mijn leerproces veel aan gehad heb.
Als andere mensen hier ook mee geholpen zijn, is dat helemaal mooi mee genomen.
Klik
hier
om zelf toekomstplannen en uitdagingen toe te voegen aan projecten.
Zoek
Probleem
Runway
isp address ubfuscation last 2 digits always **
No solution suggestion yet.
Text File
No solution suggestion yet.
Unit Test
No solution suggestion yet.
.NET Core on raspberry
https://github.com/dotnet/core/blob/main/release-notes/5.0/5.0-supported-os.md
https://learn.microsoft.com/en-us/dotnet/iot/deployment
https://www.petecodes.co.uk/install-and-use-microsoft-dot-net-5-with-the-raspberry-pi/
.Net Core Roles and permisson claims
https://www.thereformedprogrammer.net/a-better-way-to-handle-authorization-in-asp-net-core/#how-do-i-turn-the-roles-into-a-permissions-claim
{Not yet computed}
Forgot the await
01. Show applications
No solution suggestion yet.
02. Search for: Passwords
No solution suggestion yet.
03. Arrow to left <
No solution suggestion yet.
04. Rightclick: Login
No solution suggestion yet.
05. Change password
No solution suggestion yet.
06. Enter password
No solution suggestion yet.
07. Leave new password blank
No solution suggestion yet.
08. Change VNC password to desired value
No solution suggestion yet.
1. Soda machine planning
No solution suggestion yet.
132
sudo ss -tlnp | grep :"portGoesHere"
2. Soda machine Interfaces
No solution suggestion yet.
3. Soda machine Unit Tests
No solution suggestion yet.
3d printing Bowden tube replacement
https://www.3djake.nl/suche?keyword=PTFE-Buis
https://www.tinytronics.nl/shop/en/3d-printing/extrusion/ptfe-tubes/ptfe-tube-1m-2x4mm
3d printing Afbramen / Deburring
https://www.hoffmann-group.com/NL/nl/hnl/Handgereedschappen/Afbramers-schrapers/Afbramer/Universele-afbramers/Universele-afbramer%2C-2-componenten-greep-met-2-messen-%28N1%2C-N2%29/p/839120-?tId=229&wayIntoCart=SRP
https://www.hoffmann-group.com/NL/nl/hnl/Handgereedschappen/Afbramers-schrapers/Afbramer/Universele-afbramers/Universele-afbramergreep-met-keramische-kling/p/838150-75
https://www.hoffmann-group.com/NL/nl/hnl/Handgereedschappen/Handgereedschappen-reserve-onderdelen-accessoires/Afbramers-schrapers-reserve-onderdelen-accessoires/Keramisch-afbraammes/p/838160-75
3d printing Cura Arc welder
01. Install Cura
02.Go to -> Marketplace (Button right top -> next to sign in)
03. Search for -> arc welder
3d printing Filament dehydration
https://www.bol.com/nl/nl/p/voedseldroger-transparant-wit-250-w-esperanza-ekd002/9300000002475781/?Referrer=ADVNLGOO002028-S--9300000002475781&gclid=Cj0KCQjwk96lBhDHARIsAEKO4xZBKmS_S96bPmDVCBWOO5ZInca2gyJMcZIOoiocKs16Mj5byDtQqCwaAlKhEALw_wcB
3d Printing Gridfinity
https://gridfinity.perplexinglabs.com/
https://makerworld.com/en/models/856330#profileId-805694
https://www.printables.com/model/242711-gridfinity-master-collection/files
https://www.youtube.com/watch?v=TvIvoY013xQ
3d printing Pla filament
https://kamami.pl/module/jzsphinxsearch/jsssearch?searchstring=Rosa+pla&id_lang=1
https://mdeiman4.wixsite.com/3dei
3d printing Powersupply 24v
https://www.playtool.com/pages/psuconnectors/connectors.html#oldpc
3d printing Single board computers
https://www.google.com/shopping/product/3891629464237004109/offers?q=raspberry+4b+8gb&client=ms-android-motorola-rev2&biw=360&bih=592&oq=raspberry+4b+8gb&gs_lcp=Cg5tb2JpbGUtc2gtc2VycBADMgcIABAYEIAEMgYIABAWEB4yBggAEBYQHjIGCAAQFhAeMgYIABAWEB4yBggAEBYQHjIGCAAQFhAeMgYIABAWEB46BQgAEIAEUPYMWJ8iYMMlaAFwAHgAgAGCAogB7wuSAQU3LjYuMZgBAKABAaoBEm1vYmlsZS1zaC13aXotc2VycMABAQ&sclient=mobile-sh-serp&prds=cid:3891629464237004109,cs:1,eto:7169428918157729673_0,pid:17243478145315352990,rsk:CID_3891629464237004109
https://www.tinytronics.nl/shop/en/development-boards/accessories
https://www.tinytronics.nl/shop/en/development-boards/single-board-computers
3d printing storage solution
https://youtube.com/shorts/uIly6EMU5Mw?si=ZpNqpJ5utr7knAls
3D printing Temperature tower
01. Open Cura
02. Extensions > Post-Processing > Modify G-Code.
03. Click on Add a script and select ChangeAtZ.
3d printing Tinkercad Filesize max 25Mb
No solution suggestion yet.
3d printing Tinkercad Mesh to complex
00. 3dLess might be easier (See link below)
01. Import file in to Meshmixer
02. Click SELECT in menu on the left
03. Click somewhere on the object
04. In the appearing menu on the left: MODIFY -> SELECT ALL
05. The object color should be solid now
06. In the menu on the left go to: EDIT -> REDUCE
07. Reduce Target -> TRIANGLE BUDGET
08. For Tri count a number of triangles can be entered (1000 is default not the max)
09. Play arrount with this till done
10. Accept the changes
11. File -> Export -> select .STL
https://3dless.com/
https://meshmixer.com/
https://meshmixer.com/download.html
https://www.youtube.com/watch?v=921cDYBpuL4
3d printing Tinkercad smooth cirkle, sides count, polygon
01. Click the round shape you want to change
02. Below Solid / Hole -> Look for -> Sides
03 TS: 2.43
https://www.youtube.com/watch?v=bVQBZArIt34
4. Soda machine DataAccess
No solution suggestion yet.
5. Soda machine Source control
No solution suggestion yet.
6. Soda machine continuous integration
No solution suggestion yet.
7. Soda machine Razor Pages with authentication
No solution suggestion yet.
8. Soda machine Razor Pages coin and soda inventory
No solution suggestion yet.
9. Soda machine Razor Pages Azure deploy
No solution suggestion yet.
Abstract classes
No solution suggestion yet.
Abstract classes
No solution suggestion yet.
Acces modifiers
No solution suggestion yet.
Account security
No solution suggestion yet.
Add button niet in focus zodat enter niet direct werkt om iets toe te voegen
No runway suggestion yet.
Add person to shared mail box in MS365
01 Login to Microsoft online
02. Admin
03. On the left Click: Show all
04. Exchange
05. Mailboxes
06. Click on the mailbox
07. Tab: Delegation
08. Read and manage: edit
https://login.microsoftonline.com/
Add SASS & SCSS to a project
01. in Visual studio
02. GoTo: Extensions
03. GoTo: Manage Extensions
04. Search for: webcompiler
05. Install: webcompiler
06. Close all VisualStudio instances
07. webcompiler will now be installed
08. At the appsettings level (right click project name) add -> new item: compilerconfig.json
09. compilerconfig.json content:
10. [ { "outputFile": "wwwroot/css/main.css", "inputFile": "wwwroot/scss/main.scss", "options": { "sourceMap": true } } ]
11. In wwwroot add folder: scss
12. in scss folder add -> new item file: main.scss
13. In the scss folder add a new folder: layout
14. In the new folder add -> new item file: _main-layout.scss
15. To create a link to that file in main.scss add the code: @import "layout/main-layout.scss";
16. in _main-layout.scss add the following class: .test-class{ font-weight:100; font-family:'Comic Sans MS'; font-size:xx-large; background-color:yellow; }
17. When you save the file in the left bottom it should say: Compiled successfully
18. In the wwwroot/css folder now should be a new file: main.css
19. This should contain the compiled styling and in the right bottom it should say Generated
20. in Pages->_Host.cshtml add the following code (below: <link href="css/site.css"..... />): <link href="css/main.css" rel="stylesheet" />
21. now in your component add the following code: <div class="test-class"> Test text </div>
Add shared mailbox manualy
https://support.microsoft.com/en-us/office/open-and-use-a-shared-mailbox-in-outlook-d94a8e9e-21f1-4240-808b-de9c9c088afd?WT.mc_id=365AdminCSH_inproduct
Addid SignalR to send messages to Dashboard
https://learn.microsoft.com/en-us/aspnet/core/signalr/background-services?view=aspnetcore-7.0
https://learn.microsoft.com/en-us/aspnet/core/signalr/configuration?view=aspnetcore-7.0&tabs=dotnet
https://learn.microsoft.com/en-us/aspnet/core/tutorials/signalr?view=aspnetcore-7.0&tabs=visual-studio
Agile Scrum User story
https://scrumacademy.nl/blog/zo-zorg-je-dat-user-stories-wel-duidelijk-zijn/?gclid=EAIaIQobChMIwPj-8uqL-AIV25BoCR1c_QQwEAAYASAAEgJPFPD_BwE
Altering columns
No solution suggestion yet.
Angular 17 Dependecy injection
01. Create a service tin typescript
02. Register service in root
03. Inject service in the constructor
04. User this.service to interact with the service
Angular Compiler error's
No solution suggestion yet.
Angular debugging
01. VSCode
02. Browser debugging tools -> Debugger in source tab
03. CLI: ng test --watch
04. CLI: ng lint
Angular error handling
01. Try catch
02. Observables
03. Promises
04. Global error handling class
Angular logging Best practices
01. Centralized logging
Angular logging methods
01. console.log()
02. console.error()
03. console.warn()
04. console.info()
05. console.debug()
Library: ngx-logger
Tools: Sentry, New Relic, Datadog Only use if needed
You can create a logger service with these methods
Angular Runtime error's
https://v17.angular.io/errors
Angular VS Code extensions for compiler syntaxt checking
01. Angular language service
02. Eslint
03.Tslint
Answering the phone
01. Name Organisation:
02. Naam person:
03. Reason for calling:
04. Phone Number:
Apache
sudo a2dissite "SiteName.conf"
sudo a2ensite "SiteName.conf"
sudo apachectl configtest
Apache config comments
# in front of line
https://codeburst.io/configuring-a-subdomain-in-apache2-f7a8b316b42c
API
No solution suggestion yet.
API 401 -> Unauthorized
401 (Unauthorized) -> If the resource does exist but you do not have access, then a 401 Unauthorized should be returned
API 404 -> Not found
Status 404 (Not found) -> The status means that the endpoint does not exist and that is not correct in this case. In case of an endpoint where you retrieve a specific resource, for example a location based on the ID in the URL, then 404 is correct.
API 500 -> Internal server error
500 (Internal server error) -> is returned when somathing goes wrong
API defenition generation
01. Get a API running with swagger (default now a days swagger is included in API projects, if you see the swagger site your ok)
02. In the Client application install this nuget package: newtonsoft.json
03. Download NswagStudio (Link below)
04. Install NSwagStudio
05. Specify the correct runtime
06. Specify the Specification URL (This is a URL fgrom the previous names Swagger website, click on the link below you API name (https://localhost..../swagger/v1/swagger.json))
07. Check the CSharp client box on the right
08. In the CShap Client -> Settings tab -> Unckeck: “Inject Http Client via Constructor (life cycle is managed by caller)”
09. In the SCharp Client -> Settings tab -> Check the Generate interfaces for client classes
10. In the SCharp Client -> Settings tab -> Ouput: select the folder you want the output in and specific the class name
11. Start the API project
12. Click -> Create local copy (In the left side should json apear)
13. Click -> Generate files (The file specified in the output should be updated)
14. Click -> Generate outputs (On the right code should apear)
15. Now the endpoints and classes should be available in the client application
16. When exitting NSwagStusio save the config file
17. In VisualStudio in the solution explorer right click the new .nswag file
18. Click -> Open with
19. Set NSwagStudio as default
https://github.com/RicoSuter/NSwag/releases
https://learn.microsoft.com/en-us/aspnet/core/tutorials/getting-started-with-nswag?view=aspnetcore-7.0&tabs=visual-studio
https://www.c-sharpcorner.com/article/how-to-use-nswag-with-asp-net-core-and-generate-client-code-with-nswag-studio/
API Delete
No solution suggestion yet.
API Get
Ophalen
API laag inbouwen
No runway suggestion yet.
API Nswag Studio Change BaseURL for API
01. in Nswag studio -> CSharpclient tab
02. Check the following boxes:
03. Use the base URL for the request
04. Generate the BaseURL property (must be ....)
05. Generate optional parameters (reorder parameters ....)
06. In the APIClient -> Find the property -> BaseUrl -> change string value to API url
07. Example: https://localhost:5203/
API NswagStudio string deserialisation
[Produces("text/plain")]
[ProducesResponseType(StatusCodes.Status200OK, Type = typeof(string))]
https://github.com/RicoSuter/NSwag/issues/2384
API Post
Get with a model as argument
Nieuwe toevoegen / Actie uitvoeren
string Id, [FromBody] DataModel argument
API Put
Wijzigen / Nieuwe versie
API return types
https://learn.microsoft.com/en-us/aspnet/core/web-api/action-return-types?view=aspnetcore-8.0#actionresultt-type
API URL
// PUT/POST/GET/DELETE: api/controller/subject/5/BodyDescription
API usage
No solution suggestion yet.
API's
No solution suggestion yet.
Arrays
No solution suggestion yet.
ASP .Net Core API
No solution suggestion yet.
ASP .Net Core MVC
No solution suggestion yet.
ASP .Net Core Razor Pages
No solution suggestion yet.
ASP.Net Core with Docker
No solution suggestion yet.
Async saving
No solution suggestion yet.
Async saving
https://www.youtube.com/watch?v=2moh18sh5p4
Automatische publicatie
No solution suggestion yet.
Azure Active Directory
No solution suggestion yet.
Azure regio's
No solution suggestion yet.
Basis principes van Object Oriented Programming
No solution suggestion yet.
Basis principes voor programmeren
No solution suggestion yet.
Bij project verschuiven tijd overdracht gaat mis
No solution suggestion yet.
Birthday
No solution suggestion yet.
Blazor EditorRequired
01. [Parameter, EditorRequired]
02. public string SomeStringValue { get; set; } = null;
https://mjconrad.com/blog/non-nullable-parameters-editorrequired-blazor
Blazor add spaces in a string
\u00A0 (unicode space)
Blazor adding font-awesome
01. right click on project.Client/wwwroot/css folder
02. click on Add client side library
03. Then select the Font Awesome library and installed it
04.Go to _hosts.cshtml
05. Add line: <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.1/css/all.min.css">
06. Change the number in the line to your version
https://fontawesome.com/
https://stackoverflow.com/questions/59197533/how-to-add-font-awesome-to-blazor-client-razor-component-app
Blazor Animations
https://stackoverflow.com/questions/56219984/how-to-animate-state-transitions-in-blazor
Blazor authorisation (permissions)
https://github.com/JonPSmith/AuthPermissions.AspNetCore
https://learn.microsoft.com/en-us/aspnet/core/blazor/security/?view=aspnetcore-7.0#authorization
https://www.thereformedprogrammer.net/a-better-way-to-handle-authorization-in-asp-net-core/
Blazor binding converter
https://stackoverflow.com/questions/59146361/inputnumber-binding-converter-in-blazor
Blazor bootstrap modal
https://www.youtube.com/watch?v=udb6DNKZyhU
Blazor Cascading parameters
https://www.youtube.com/watch?v=Am7Zl072nHg
Blazor Cascading Values & Cascading Parameters
https://chrissainty.com/understanding-cascading-values-and-cascading-parameters/
Blazor Component communication
https://chrissainty.com/3-ways-to-communicate-between-components-in-blazor/
https://jonhilton.net/blazor-state-management/
Blazor component lifecycle/ Rendering
https://learn.microsoft.com/en-us/aspnet/core/blazor/components/lifecycle?view=aspnetcore-8.0
Blazor component lifetime questions
01. Why does on initialized get called twice?
02. Why are in the second OnInitialized call the properties empty again?
Blazor component use of @body
No solution suggestion yet.
Blazor Component validation
https://docs.microsoft.com/en-us/aspnet/core/blazor/forms-validation?view=aspnetcore-6.0#validation-summary-and-validation-message-components
Blazor create binding in custom components
01. Custom component code: <CustomComponent @bind-CustomBindValue="@localBool" />
02. Inside custom CustomComponent
03. private bool componentLocalBool;
04. [Parameter]
05. public bool CustomBindValue
06. {
07. get =>componentLocalBool;
08. set
09. {
10. if (componentLocalBool== value) return;
11. componentLocalBool = value;
13. CustomBindValueChanged.InvokeAsync(componentLocalBool);
14. }
15. }
17. [Parameter]
18. public EventCallback<bool> CustomBindValueChanged{ get; set; }
https://stackoverflow.com/questions/57932850/how-to-make-two-way-binding-on-blazor-component
Blazor CSS style adding in component
https://www.syncfusion.com/faq/blazor/general/how-do-i-apply-custom-css-style-to-a-blazor-component
Blazor drag and drop
https://chrissainty.com/investigating-drag-and-drop-with-blazor/
Blazor edit context
001. Parent component
002. <EditForm EditContext="@context" OnValidSubmit="Optional">
003. some component with edit fields
004. </EditForm>
011. Child component
012. [CascadingParameter]
013. public EditContext Context { get; set; }
Blazor EditContext
https://jonhilton.net/why-use-blazor-edit-forms/
Blazor editcontext fieldidentifiers fieldstate
https://blazor-university.com/forms/editcontext-fieldidentifiers-and-fieldstate/
Blazor EventCallback anonimous method
OnEventCallBack="@((args) => someVariable = args)"
Blazor how to use edit form
https://executecommands.com/blazor-editform-model-validation-aspnetcore-5/
Blazor inline if statement
@( condition ? "true" : "false" )
Blazor InputNumer Spinner
https://www.codegrepper.com/code-examples/whatever/remove+input+select+number+arrows
Blazor Loading component
https://www.meziantou.net/showing-a-loading-screen-while-initializing-a-blazor-application.htm
Blazor page redirections
01. Option1
02. @page "/route/to/page/{Param1}/{Param2}";
03. [Parameter]
04. public string Param1{ get; set; }
05. [Parameter]
06. public string Param2{ get; set; }
07. Option 2
08. URL/route/to/page?Param1=1&Param2=2
09. [Parameter, SupplyParameterFromQuery(Name = "Param1")]
10. public string Param1{ get; set; }
11. [Parameter, SupplyParameterFromQuery(Name = "Param2")]
12. public string Param2{ get; set; }
Blazor page routes
@page "/pageRoute1"
@page "/pageRoute2"
1.1. @page "/pageRoute1/PageRoute2/{variable}";
1.2. [Parameter]
1.3. public string variable{ get; set; }
2.1. @page "/pageRoute1/{variable1}/PageRoute2/{variable2}";
2.2. [Parameter]
2.3. public string variable1{ get; set; }
2.4. [Parameter]
2.5. public string variable2 { get; set; }
Blazor ProcessPro Port not listening
Restart service -> WinNat -> WindowsNat driver
Blazor Radio button change event
https://github.com/dotnet/aspnetcore/issues/5579#issuecomment-548061223
Blazor Server Side
No solution suggestion yet.
Blazor StateContainer
https://chrissainty.com/3-ways-to-communicate-between-components-in-blazor/
https://support.syncfusion.com/kb/article/11937/communicating-between-blazor-components-using-statecontainer
Blazor string interpolation
@($"Hello {this.Model.SomeProperty}")
Blazor type parameter
!! No semicolon ; !!
@typeparam TData
Blazor unintentional triggering overritten method
Remove the base in the method
Blazor Web Assembly
No solution suggestion yet.
Blender 3d modeling
https://www.youtube.com/watch?v=VYuUlQO-kYE&t=652s
Boot Raspberry from SD
02. For OS select: Misc utility images
01. Open Raspberry imager
03. Select: Bootloader
04. Select SD card boot
https://downloads.raspberrypi.org/imager/imager_latest.exe
https://www.makeuseof.com/how-to-boot-raspberry-pi-ssd-permanent-storage/#:~:text=Boot%20Raspberry%20Pi%204%20or%20400%20from%20SSD&text=Click%20the%20Choose%20OS%20button,take%20a%20few%20seconds%20only.
Boot Raspberry from USB
01. Open Raspberry imager
02. For OS select: Misc utility images
03. Select: Bootloader
04. Select USB boot
https://downloads.raspberrypi.org/imager/imager_latest.exe
https://www.makeuseof.com/how-to-boot-raspberry-pi-ssd-permanent-storage/#:~:text=Boot%20Raspberry%20Pi%204%20or%20400%20from%20SSD&text=Click%20the%20Choose%20OS%20button,take%20a%20few%20seconds%20only.
Bulgarian
Pronounciation: hello: dsravej
Written: Hello -> Здравей
Bulgarian (hello)
Hello -> dsravey
Bulk File Renaming
No solution suggestion yet.
C# .net core 7.0 Optionspattern Program.cs
builder.Services.Configure<PositionOptions>(builder.Configuration.GetSection(PositionOptions.Position));
C# .net Core Configuration values
https://stackoverflow.com/questions/41738692/read-appsettings-json-in-main-program-cs
C# {Not yet computed}
No solution suggestion yet.
C# Access Modifiers
https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/classes-and-structs/access-modifiers
C# add list to list
initialList.AddRange(listToAdd);
C# An object reference is required for the nonstatic field, method, or property
De method is waarschijnlijk static
https://stackoverflow.com/questions/498400/cs0120-an-object-reference-is-required-for-the-nonstatic-field-method-or-prop
C# anonymous function
https://medium.com/@technicadil_001/anonymous-functions-with-c-cfb3fe7db1a5
C# Async
async Task<"expecteddataType"> "MethodName"()
Do not forget the await in front of task in method
Task.Run(() => "Not async task")
C# async await
no AWAIT = {Not yet computed}
C# Byte array [] and string
byte[] array = System.Text.Encoding.UTF8.GetBytes("string value");
string value = System.Text.Encoding.UTF8.GetString("Byte[] here");
C# casting
a = (int)x;
C# Casting collection / List
List<string> collection = objectCollection.Values.Cast<string>().ToList();
C# Character replacement
s = s.Replace("\"", "");
C# Characterset encoding 1252
€ (Euro sign) ‚ (Single low-9 quotation mark) ƒ (Latin small letter f with hook) „ (Double low-9 quotation mark) … (Horizontal ellipsis) † (Dagger) ‡ (Double dagger) ˆ (Modifier letter circumflex accent) ‰ (Per mille sign) Š (Latin capital letter S with caron) ‹ (Single left-pointing angle quotation mark) Œ (Latin capital ligature OE) Ž (Latin capital letter Z with caron) ‘ (Left single quotation mark) ’ (Right single quotation mark) “ (Left double quotation mark) ” (Right double quotation mark) • (Bullet) – (En dash) — (Em dash) ˜ (Small tilde) ™ (Trade mark sign) š (Latin small letter s with caron) › (Single right-pointing angle quotation mark) œ (Latin small ligature oe) ž (Latin small letter z with caron) Ÿ (Latin capital letter Y with diaeresis)
01. C# code byte[] -> string: stringContentArray = CodePagesEncodingProvider.Instance.GetEncoding(1252).GetString(array);
02. C# string -> code byte[]: byte[] byteContent= CodePagesEncodingProvider.Instance.GetEncoding(1252).GetBytes(arrayStringContent);
C# clicking a button in a table row that is a link
<div @onclick:stopPropagation="true">
https://www.google.com/search?q=youtube+stop+propagation&client=firefox-b-d&ei=ER4yYsXPNcqYkwWZ-q6ABQ&ved=0ahUKEwiFnNHak8v2AhVKzKQKHRm9C1AQ4dUDCA0&uact=5&oq=youtube+stop+propagation&gs_lcp=Cgdnd3Mtd2l6EAM6BwgAEEcQsAM6BwgAELADEEM6BQgAEIAEOggIABCABBCxAzoECAAQQzoGCAAQFhAeOgQIABATOggIABAWEB4QEzoHCCEQChCgAUoECEEYAEoECEYYAFCVBFijG2C2HWgBcAF4AIABfYgBlgqSAQQxNC4zmAEAoAEByAEKwAEB&sclient=gws-wiz#kpvalbx=_Fx4yYrbxJIOwkwWM1rf4Cg12
C# Coding styles
https://github.com/dotnet/runtime/blob/main/docs/coding-guidelines/coding-style.md
https://learn.microsoft.com/en-us/
https://learn.microsoft.com/en-us/dotnet/standard/design-guidelines/capitalization-conventions?redirectedfrom=MSDN
C# create a collection with properties of a collection with Linq
List<Item> items = dtos.Select(dto => new Item { ItemProperty1 = dto.Property1, ItemProperty2 = dto.Property2 }).ToList();
C# DateTime formatting
1. CultureInfo culture = new CultureInfo("en-US");
1. DateTime tempDate = Convert.ToDateTime("1/1/2010 12:10:15 PM", culture);
2. America ("MM/dd/yyyy")
2. NL ("dd/MM/yyyy")
https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
https://www.tutorialsteacher.com/articles/datetime-formats-in-csharp
C# Delegates
https://www.geeksforgeeks.org/c-sharp-delegates/
C# Dependency Injection
01. Startup.cs
02. public void ConfigureServices(.....)
services.AddScoped : One per session/scope
services.AddSingleton : One for the entire life of the application
services.AddTransient : Get a new instance when we request one
C# Dependency Injection DataAccess
01. Startup.cs
02. IfNeeded: Global: private readonly string _connectionType = "";
03. IfNeeded: _connectionType = Configuration.GetSection("").GetValue<string>("");
04. public void ConfigureServices(.....)
05. If (x.tolower() == "x")
06. services.Add"Scoped/Transient/Singleton"<Interface, DataAccessType>
C# Dictionary update
01. private Dictionary<string, List<string>> dictionaryCollection { get; private set; } = new();
02. List<string> newDictionaryItem = new();
03. string collectionKey = "key";
04. bool dictionaryExists = dictionaryCollection.ContainsKey(collectionKey);
05. if (!dictionaryExists) dictionaryCollection.Add(CollectionKey, newDictionaryItem);
06. else dictionaryCollection[CollectionKey] = newDictionaryItem;
07.
08. Most important:
09. bool dictionaryExists = dictionaryCollection.ContainsKey(collectionKey);
10. if (!dictionaryExists) dictionaryCollection.Add(CollectionKey, newDictionaryItem);
11. else dictionaryCollection[CollectionKey] = newDictionaryItem;
C# Drag and drop
01. // Item dragged down
02. if (dropIndex > fromIndex)
03. List<T> itemsToChange = itemsCollection.Where(x => x.RowIndex > fromIndex && x.RowIndex <= dropIndex).ToList();
04. foreach (T itemToChange in itemsToChange)
05. itemToChange .RowIndex = itemToChange .RowIndex - 1;
06. // Item dragged up
07. if (dropIndex < fromIndex)
08. List<T>itemsToChange = itemsCollection.Where(x => x.RowIndex < fromIndex && x.RowIndex >= dropIndex).ToList();
09. foreach (T itemToChange in itemsToChange)
10. itemToChange.RowIndex.RowIndex = itemToChange .RowIndex + 1;
C# enum const string
01. public class SomeConstandNames
02. public const string ConstandName = "ConstantStringValue";
C# Enums Enheritance
https://stackoverflow.com/questions/757684/enum-inheritance/4042826#4042826
https://stackoverflow.com/questions/757684/enum-inheritance/757815#757815
C# Enums loop trough / Create a list of enums
Anonimous list: var values = Enum.GetValues(typeof(Foos));
https://stackoverflow.com/questions/972307/how-to-loop-through-all-enum-values-in-c
Library/HelperMethod: public static class EnumUtil { public static IEnumerable<T> GetValues<T>() { return Enum.GetValues(typeof(T)).Cast<T>(); } }
StronglyTyped array of enums: var values = Enum.GetValues(typeof(Foos)).Cast<Foos>().ToList();
C# Enums, Get enum from int
YourEnum foo = (YourEnum)yourInt;
C# Enums, Get Enum int
int value = (int) "Enum";
C# Factory pattern
No solution suggestion yet.
C# get exception type
01. Type exceptionType = ex.GetType();
02. Console.WriteLine($"The exception type is {exceptionType}");
C# Get Type
01. PropertyInfo propInfo = modelType.GetProperty(propertyName);
02. Type filterOption = propInfo.PropertyType;
C# Getting the weeknumber from a date
https://stackoverflow.com/questions/662379/calculate-date-from-week-number
C# HttpContext
https://www.c-sharpcorner.com/UploadFile/dacca2/httpcontext-class-in-Asp-Net/
C# inline if statement
oneSelected = oneSelected == true? false : true;
01. This is called: Ternary operator
evaluation (example x == y) ? ifTrue : ifFalse
https://newbedev.com/c-inline-if-statement-example
someValue = condition ? newValue : someValue;
string neededValue = (string.IsNullOrWhiteSpace(stringToEval) == true ? "-" : neededValue)
C# inline string comparison not case sensitive
@if (string.Equals("NullableObject"?."desired property", "evaluation value", StringComparison.CurrentCultureIgnoreCase))
C# lambda change value from selction
orders.Where(x => x.Verified == true && x.OrderID != order.OrderID).ToList().ForEach(x => x.Verified = false);
C# Linq create a list of one model collection proprty
testList = modelCollection.Select(x => x.PropertyName).ToList();
C# Logging
https://stackoverflow.com/questions/52200484/why-logging-doesnt-use-string-interpolation
C# logging with Serilog
https://www.youtube.com/watch?v=_iryZxv8Rxw
https://www.youtube.com/watch?v=QjO2Jac1uQw
https://www.youtube.com/watch?v=w7yDuoCLVvQ
C# Make a project Nullable
01 *.csproj
02 <Project Sdk="Microsoft.NET.Sdk.Web">
03 <PropertyGroup>
04 <TargetFramework>net6.0</TargetFramework>
05 <Nullable>enable</Nullable>
06 </PropertyGroup>
https://csharpplayersguide.com/articles/disable-null-checking.html
C# Make a sentence from data collection
var res = string.Join(" ", words);
var temp = words.Aggregate((x, y) => x + " " + y);
C# mapping
collection = collection.Select( x => new TestClass(x.Property, x.Property, x.Property)).ToList();
C# multi threading
https://dotnettutorials.net/lesson/multithreading-in-csharp/
https://learn.microsoft.com/en-us/dotnet/standard/threading/using-threads-and-threading
C# not null check
https://www.thomasclaudiushuber.com/2020/03/12/c-different-ways-to-check-for-null/
C# Observer pattern
No solution suggestion yet.
C# OptionsPattern
https://andrewlock.net/how-to-use-the-ioptions-pattern-for-configuration-in-asp-net-core-rc2/
https://docs.microsoft.com/en-us/aspnet/core/fundamentals/configuration/options?view=aspnetcore-6.0
https://medium.com/the-crazy-coder/net-working-with-options-pattern-34d81fcd3b15
C# programming where to start
https://github.com/VLoorenDeJong/ProjectProgressApplications/wiki/Starting-programming-in-C%23-for-free
C# property generation
01. public get private set: propg TAB TAB
02. private property and pulic methods: propfull
C# Random bool
new Random().Next(2) == 0
C# Random string from array
= (new string[] { "", "", "", "", "", "", "", "" })[new Random().Next(8)],
string variable = (new string[] { "", "", "", "", "", "", "", "" })[new Random().Next(8)]
C# Razor Pages Nested Layouts
https://www.youtube.com/watch?v=SrlU8sr5Tqc
C# regular expressions
https://docs.microsoft.com/en-us/dotnet/standard/base-types/regular-expression-language-quick-reference
https://www.techiedelight.com/check-string-consists-alphanumeric-characters-csharp/
Regex.IsMatch(str, "^[a-zA-Z0-9]*$")
C# remove empty entries from list
dtList = dtList.Where(s => !string.IsNullOrWhiteSpace(s)).Distinct().ToList()
C# Remove spaces from strin
https://www.csharp411.com/remove-whitespace-from-c-strings/
string trim = text.Replace( " ", "" );
string trim = text.Trim();
C# Repository patern
No solution suggestion yet.
C# Repository pattern
No solution suggestion yet.
C# roles authentication
Nuget: autofac
C# security checks
01. ________Option 1________
02. bool checksPassed = true;
03. if (item is null || item is null)
04. {
05. checksPassed = false;
06. }
07. return checksPassed;
08. ________Option 2________
09. List<bool> securityChecks = new();
10. bool itemInstanciated= item1 is not null || item2 is not null;
11. securityChecks.Add(itemInstanciated);
12. bool anyFailedChecks = securityChecks.Contains(false);
13. bool checksPassed = anyFailedChecks ? false : true;
14. return checksPassed;
C# string compare
string.Equals(string1, string2, StringComparison.CurrentCultureIgnoreCase)
C# string from all capital letters to TitleCase
output = output + " " + char.ToUpper(s[0]) + s.Substring(1).ToLower();
https://www.educative.io/edpresso/how-to-capitalize-the-first-letter-of-a-string-in-c-sharp
C# string prefix with zeros
For 8 characters: int.ToString("D8")
https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings
C# string split
string[] delimitedArray = stringToSplit.Split("DelimiterHere");
https://docs.microsoft.com/en-us/dotnet/api/system.string.split?view=net-6.0
C# substring
https://www.c-sharpcorner.com/UploadFile/mahesh/substring-in-C-Sharp/
C# summary comments
https://learn.microsoft.com/en-us/dotnet/csharp/language-reference/language-specification/documentation-comments
https://learn.microsoft.com/en-us/dotnet/csharp/language-reference/xmldoc/recommended-tags
C# summary comments Code
<c> </c>
C# summary comments line breaks
/// <br> </br>
C# summary comments Paragraph
/// <para> </para>
C# summary comments paragraph and line breaks
01. /// <summary>
02. /// <para>
03. /// <br>- </br>
04. /// </para>
05. /// </summary>
C# summary documentation
https://learn.microsoft.com/en-us/dotnet/csharp/language-reference/xmldoc/recommended-tags
C# summary XML < operator
01. To use markup language in XML you replace th < with <
02. /// <summary>
03. /// Some instructional text
04. /// <example>
05. /// <br> </br>
06. /// <br> </br>
07. /// Example markup code:
08. /// <code>
09. /// <ComponentName Parameter1="@(parameter)" Parameter2="@parameter2" />
10. /// </code>
11. /// </example>
12. /// </summary>
C# Switch
https://www.geeksforgeeks.org/switch-statement-in-c-sharp/
C# Switch bool on Get or set
1. private bool someBoolVariable
2. {
3. get { return "TheStringVariable" == "true condition"; }
4. set { TheStringVariable= value ? "valueTrue" : "valueFalse"; }
5. }
C# Switch resource file .resx
https://stackoverflow.com/questions/3479922/how-to-switch-resx-at-runtime
C# upgrading .Net versions -> Upgrade assistant
01. In CLI -> dotnet tool install -g upgrade-assistant
02. In CLI -> dotnet tool install -g upgrade-assistant
03. In CLI -> dotnet tool uninstall -g upgrade-assistant
04. In CLI -> Get commands -> upgrade-assistant
C# upgrading .Net versions 6-8
https://akifmt.github.io/dotnet/2024-01-20-blazor-.net8-migrating-app-from-.net-6-or-.net-7-to-.net-8/#update-programcs
https://jonhilton.net/blazor-net8-migration/
C# User claims
https://dotnetcodr.com/2013/02/11/introduction-to-claims-based-security-in-net4-5-with-c-part-1/
C# user secrets
.Net 8.0 Timestamp: 32 min
https://www.youtube.com/watch?v=_2_qksdQKCE
https://www.youtube.com/watch?v=walv3nLTJ5g
C3 Create model from json
https://app.quicktype.io/
Caching
No solution suggestion yet.
Calculations
No solution suggestion yet.
Casting
No solution suggestion yet.
Certbot
sudo certbot renew --dry-run
Certbot Certificaat aanvragen voor apache virtual server
sudo certbot --apache
Certbot Configuratie testen voor SSL certificaat
https://certbot.eff.org/instructions?ws=apache&os=ubuntufocal
sudo certbot renew --dry-run
Certbot SSL certificaat verwijderen
https://mhagemann.medium.com/correct-way-to-delete-a-certbot-ssl-certificate-e8ee123e6e01
sudo certbot --cert-name nameOfYourCertificate -d conservationsymposium.com -d archive.conservationsymposium.com
sudo certbot delete
Change host name
sudo nano /etc/hostname
Change Ubuntu hostname
01. sudo nano /etc/cloud/cloud.cfg
02. preserve_hostname true
03. sudo hostnamectl set-hostname night-hawk
04. sudo nano /etc/hostname
05. sudo reboot
https://askubuntu.com/questions/1132933/unable-to-change-hostname-in-ubuntu-18-04-server-on-virtualbox
https://www.cyberciti.biz/faq/ubuntu-change-hostname-command/
Changes
No solution suggestion yet.
Circular project verwijzingen
1. Maak een lijst met alle boven liggende project ids
2. Maak een lijst met alle onderliggende ids
3. Ga deze met elkaar vergelijken er mag geen dubbele inzitten
directed acyclic graph
Class libraries
No solution suggestion yet.
Commentaar opslaan bij een tijd eenheid
No solution suggestion yet.
Commentaar opslaan bij een tijd eenheid
No runway suggestion yet.
Common Setup
No solution suggestion yet.
Condities
https://www.iamtimcorey.com/courses/448486/lectures/6884077
Configuratie
https://serverfault.com/questions/232145/command-for-checking-apache-configuration
Configure Samba
sudo nano /etc/samba/smb.conf
Connecting with workbench
https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql
1. Add connection
2. Connection method: ssh
3. HostName: "10.0.0.1:22"
4. SSH Username : "SSH User Name"
5. SSH password : "SSH Password"
6. MySQL HostName : localhost
7. MySQL username: "test"
8. MySQL Password: "Pa$$w.rd"
9. Connection should work now
Connection String
DevOps: Releases -> Pipelines -> Edit -> variables
https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/introduction/creating-a-connection-string
https://www.connectionstrings.com
Cookies
https://www.codeproject.com/Articles/422249/Understanding-and-Implementing-Cookies-ASPNET
Cooling fan upgrades
https://www.google.com/shopping/product/10756817010280111134/offers?client=ms-android-motorola-rev2&q=noctua+40mm+fan&biw=360&bih=592&dpr=3&prds=cid:10756817010280111134,cs:1,eto:9871325195095494558_0,pid:5509962706409782295,rsk:PC_12710516787008563289
https://www.google.com/shopping/product/3920073821109647498/offers?client=ms-android-motorola-rev2&q=noctua+40mm+fan&biw=360&bih=592&dpr=3&prds=cid:3920073821109647498,cs:1,eto:8516346197665270457_0,pid:4662801802111214652,rsk:PC_7396069433405485623
Copying Objects
No solution suggestion yet.
Create Icon/Favicon
https://image.online-convert.com/convert-to-ico
Create MySQL User
1. In Command line type: sudo mysql
2. CREATE USER 'test'@'localhost' IDENTIFIED BY 'Pa$$w.rd';
3. GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'test'@'localhost' WITH GRANT OPTION;
4. FLUSH PRIVILEGES;
5. exit
Creating VS code snippets
https://www.youtube.com/watch?v=rn9p_K9J4yg
CSS Adressing an element
# element name
CSS Align
https://css-tricks.com/almanac/properties/t/text-align/
CSS Append
https://getbootstrap.com/docs/4.0/components/input-group/
CSS Bootstrap 5 alignment
https://stackoverflow.com/questions/18672452/left-align-and-right-align-within-div-in-bootstrap
CSS Bootstrap 5 margin and padding
https://stackoverflow.com/questions/32233489/does-bootstrap-have-builtin-padding-and-margin-classes
CSS Bootstrap 5.0 documentation
https://getbootstrap.com/docs/5.0/getting-started/introduction/
CSS bootstrap screen size breakpoints
https://getbootstrap.com/docs/5.0/layout/breakpoints/
CSS Check if stylus works
*{border:1px solid red}
F5
CSS Choose project colors
https://mycolor.space/
CSS chose fonts
https://youtu.be/_4cW79vF1mU
CSS Color codes
https://www.google.com/search?q=%23343a40&oq=%23343a40&aqs=chrome..69i57j0i512j0i30j0i5i30.1087j0j7&sourceid=chrome&ie=UTF-8
https://www.rapidtables.com/convert/color/rgb-to-hex.html
CSS Columns
01. col = grid systeem
02. row = regel
https://getbootstrap.com/docs/4.0/layout/grid/
LG= Large size display
MD = Midsize Display
SM = Small display
CSS find css path
01. Inspect element
02. Below: This element applied CSS classes are shown
CSS Find examples
Search for: CSS .....
CSS Fix elements
https://stackoverflow.com/questions/20762823/set-div-width-equal-to-window-size
CSS Gradient
https://cssgradient.io/
CSS hanging punctuations
https://developer.mozilla.org/en-US/docs/Web/CSS/hanging-punctuation
CSS Link color
https://www.w3schools.com/html/html_links_colors.asp
CSS List style position
https://developer.mozilla.org/en-US/docs/Web/CSS/list-style-position
CSS Margin Padding
https://docs.microsoft.com/en-us/xamarin/xamarin-forms/user-interface/layouts/margin-and-padding
CSS media query
https://css-tricks.com/a-complete-guide-to-css-media-queries/
https://developer.mozilla.org/en-US/docs/Web/CSS/Media_Queries/Using_media_queries
CSS Mixins
https://tommcfarlin.com/using-mixins-in-css/
CSS path selector (conditionals)
01. Example: .example_div .btn
02. When a buton in example_div {..} will be applied
03. Do not forget space between classes and the . before the classes
https://www.freecodecamp.org/news/css-selectors-cheat-sheet/
CSS Path Selector >
https://stackoverflow.com/questions/20782995/apply-css-for-the-first-label-of-div/20783176
https://www.freecodecamp.org/news/css-selectors-cheat-sheet/
CSS Phone screen sizes and resolutions
https://viewportsizer.com/phone-screen-dimensions/
CSS responsive pictures
https://css-tricks.com/responsive-images-css/
CSS Screen sizes and resolutions
https://screensiz.es/tablet
https://support.microsoft.com/en-us/windows/change-your-screen-resolution-5effefe3-2eac-e306-0b5d-2073b765876b
https://www.dimensions.com/element/dell-ultrasharp-up3218k-31-5-inch
https://www.logicalincrements.com/articles/resolution
CSS shadow
box-shadow: 2px 5px 0px 2px rgba(0, 0, 0, 0.2) !important;
https://www.w3schools.com/css/css3_shadows_box.asp
CSS Show divs side by side (Flex box)
<div> Verticaal <span> horizontaal
https://coder-coder.com/display-divs-side-by-side/
CSS Units
https://www.w3schools.com/cssref/css_units.asp
CSS3 implementatie
No solution suggestion yet.
Culture change during runtime
https://github.com/samxx47/POC-for-Culture-Switch-Blazor
https://learn.microsoft.com/en-us/aspnet/core/blazor/globalization-localization?view=aspnetcore-8.0#dynamically-set-the-server-side-culture-by-user-preference
Cura 5.6.0 Import John's Profile
01. go to Settings -> Printer -> Manage Printers
02. Go to Profiles
03. Go to Import (top right)
04. Find and select correct Profile
05. Close window
06. Go to Print Settings (right top)
07. Select the correct Profile
Cura download page
https://ultimaker.com/software/ultimaker-cura/#downloads
Custom fields
No solution suggestion yet.
Data collecties
No solution suggestion yet.
Data manipulatie
No solution suggestion yet.
Data transport met JSON en XML
No solution suggestion yet.
Data type conversie
No solution suggestion yet.
Data verwerking met JavaScript
No solution suggestion yet.
Database importeren
No solution suggestion yet.
DateTime
No solution suggestion yet.
DateTime formating
https://www.c-sharpcorner.com/blogs/date-and-time-format-in-c-sharp-programming1
https://www.c-sharpcorner.com/UploadFile/manas1/string-to-datetime-conversion-in-C-Sharp/
DateTime input
https://www.learnrazorpages.com/razor-pages/forms/dates-and-times
De 7 ITIL Guiding Principles
No solution suggestion yet.
Debuggen
No solution suggestion yet.
Debugging
No solution suggestion yet.
Dependency injection
No solution suggestion yet.
Dependency Injection Scopes / Service types (use cases)
Scoped (Once per scope (Instance of the application))
Singleton (Only once per application start)
Transient (Creates a new every time it is called upon)
Designer 'Framesets' and 'Pages' are missing
https://support.hcltechsw.com/csm?id=kb_article&sysparm_article=KB0092092
Developer meetings
https://dev.events/meetups/EU/NL/Nieuwegein
https://www.meetup.com/find/?location=nl--Nieuwegein&categoryId=546&source=EVENTS&distance=twoMiles
Developer take aways
01. Keep in touch with testers (At least quarterly)
02. Coding standards is a shared concern talk about it (At least quarterly)
03. Check which part of the application is slow (At least quarterly)
DevOps Wiki add subpages table
[[_TOSP_]]
DevOps Wiki apply color
01. <span style="color:orange">
02. Some text
03. </span>
04.
05. <div style="color:orange">
06. Some text
07. </div>
08.
09. <span style="color:lightgreen">
10. <span style="color:orange">
DevOps Wiki Checkboxes
- [ ]
1. [ ]
DevOps WIKI expand example code
01. <details>
02. <summary>
03. Example code:
06. <span style="color:orange"> Illustration: <span style="color:orange"> </span>
07. <span style="color:lightgreen"> YourText </span>
08. </summary>
09.
10. ```csharp
11. code goes here
12. ```
13. </details>
DevOps WIKI expand picture
01. <details>
02. <summary>
03. <span style="color:orange"> Illustration: <span style="color:orange"> </span>
04. <span style="color:lightgreen"> YourText </span>
05. </summary>
06.
07. !image
08.
09. </details>
DevOps WIKI Show underlying pages TOSP
[[_TOSP_]]
DevOps WIKI Syntax
https://learn.microsoft.com/en-us/azure/devops/project/wiki/wiki-markdown-guidance?view=azure-devops
DevOps WIKI Table of content TOC
01. [[_TOC_]]
02. #Item
03. ##SubItem
Diagrams
https://www.yworks.com/products/yed
Dictionaries
No solution suggestion yet.
Disk and Folder management
No solution suggestion yet.
Display IP address in ubuntu
https://itsfoss.com/check-ip-address-ubuntu/
sudo ip addr show
DNS records
https://docs.digitalocean.com/products/networking/dns/how-to/add-subdomain/
Do/While loop
No solution suggestion yet.
Document Object Model
No solution suggestion yet.
Domino designer settings
https://www.openntf.org/main.nsf/blog.xsp?permaLink=BELT-8HVKY2
Don't Repeat Yourself
No solution suggestion yet.
DotNet Commandline
No solution suggestion yet.
Download 1Password
No solution suggestion yet.
Download NSwag
https://github.com/RicoSuter/NSwag/releases
Download Postman
https://www.postman.com/downloads/
Download SQL developer
https://www.oracle.com/database/sqldeveloper/technologies/download/
DPKG unlock
01. sudo dpkg --configure -a
02. If no output continue
03. sudo rm /var/lib/dpkg/lock-frontend && sudo rm /var/lib/dpkg/lock
04. sudo dpkg --configure -a
05. sudo apt update && sudo apt upgrade -y sudo apt autoremove --purge -y
https://itsfoss.com/could-not-get-lock-error/
Dubbele entries uit data collectie halen
var distinctItems = items.GroupBy(x => x.Id).Select(y => y.First());
Dynamische foto collecties
Articles
Cards
Tabel
Edit button weg by default no solution added
No runway suggestion yet.
Een menu aan de zijkant maken in razor pages
https://startbootstrap.com/template/simple-sidebar
Neem uit het gedownloade bestand het menu over uit de web pagina
Een project starten in Visual Studio
No solution suggestion yet.
Enable chunk borders
F3 + G
Enable firewall UFW
https://www.cyberciti.biz/faq/how-to-setup-a-ufw-firewall-on-ubuntu-18-04-lts-server/
Enable Lan (eth0)
01. sudo nano /etc/netplan/50-cloud-init.yaml
02. Inspect this file to have: ethernets: eth0
03. If it does not contain this part ask copilot/Chat GPT to add this
04. sudo netplan apply
05. sudo ip addr show
06. sudo reboot
07. sudo ip addr show
Enable remote access
1. sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
2. Find 'bind-adress' set it to 0.0.0.0 (maybe server own IP)
3. sudo systemctl restart mysql
4. sudo systemctl restart mysql
5. Create a user in MySQL (See Create MySQL user)
6. sudo ufw allow from remote_IP_address to any port "Port number here ""default 3306"
https://alvinalexander.com/blog/post/mysql/show-users-i-ve-created-in-mysql-database/
https://phoenixnap.com/kb/install-mysql-ubuntu-20-04
https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql
https://www.digitalocean.com/community/tutorials/how-to-connect-to-a-mysql-server-remotely-with-mysql-workbench
Enable second network interface in Ubuntu
sudo ifconfig eth0 up
Enable UFW (Uncomplicated Fire Wall) in Ubuntu
01. sudo ufw status verbose
02. First enable SSH: sudo ufw allow ssh
03. sudo ufw enable
04. sudo ufw status verbose
https://linuxhint.com/ufw_list_rules/
https://serverspace.io/support/help/osnovnye-komandy-ufw#:~:text=Switching%20on%20UFW,all%20ports%20on%20the%20server.
Encryption key toevoegen
https://ubuntu.com/server/docs/service-openssh
Entity Framework
No solution suggestion yet.
Entity Framework
No solution suggestion yet.
Error Handling
No solution suggestion yet.
Events
No solution suggestion yet.
Excel Cell color conditional
https://www.ablebits.com/office-addins-blog/change-background-color-excel-based-on-cell-value/
Excel checkbox
https://support.microsoft.com/en-us/office/add-a-check-box-or-option-button-form-controls-9f201e46-8f6b-4a9d-a320-f44b28088cb0
Excel Dropdown
https://support.microsoft.com/en-us/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b
excel H lookup (Horizontallookup)
No solution suggestion yet.
Excel sticky top row (Freeze)
https://support.microsoft.com/en-us/office/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f
Excel V-lookup (Verticallookup)
No solution suggestion yet.
Excel Web App
No solution suggestion yet.
Excell Pictures disapeared
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-pictures-disappered/a506db04-9807-47e1-8c33-6bb7d1a71393
Extension methods
No solution suggestion yet.
Extension methods
No solution suggestion yet.
Extension Methods
No solution suggestion yet.
fiber spareparts
https://schenkict.nl/pages/hoe-verbind-ik-een-router-met-het-xgs-pon-glasvezel-netwerk-van-delta-en-kpn
https://schenkict.nl/products/delta-xgs-pon-aansluitkabel-2m-apc?_pos=2&_sid=cc622340d&_ss=r
https://schenkict.nl/products/glasvezel-patchkabel-sc-apc-8-sc-upc-geel?pr_prod_strat=pinned&pr_rec_id=6a524c748&pr_rec_pid=8817141973259&pr_ref_pid=8817139384587&pr_seq=uniform
https://schenkict.nl/products/nokia-xs-010x-q?pr_prod_strat=jac&pr_rec_id=b10fd080b&pr_rec_pid=8817139613963&pr_ref_pid=8817140662539&pr_seq=uniform
File management
No solution suggestion yet.
File types -> Mimetypes
https://www.sitepoint.com/mime-types-complete-list/
file/folder
sudo rm -rf "file/folder path"
Fire Fox
https://1password.com/downloads/browser-extension/
https://1password.com/resources/guides/1password-for-firefox/
https://www.google.com/search?client=firefox-b-m&sca_esv=594075593&q=firefox+on+android+turn+off+password+saving&oq=firefox+on+android+turn+off+password+saving&aqs=heirloom-srp..
FireFox Cooky blocking
https://addons.mozilla.org/nl/firefox/addon/cookieblock/
FireFox Exporting bookmakrs
https://support.mozilla.org/en-US/kb/export-firefox-bookmarks-to-backup-or-transfer
FireFox restoring importing bookmarks
https://support.mozilla.org/en-US/kb/restore-bookmarks-from-backup-or-move-them
Firewall UFW
sudo apt-get install ufw -y
FizzBuzz
No solution suggestion yet.
Flsun q5 cooling fan
https://www.google.com/search?q=flsun+q5+fans&oq=flsun+q5+fans&aqs=chrome..69i57j0i22i30l3j0i390i650l3.3817j0j7&client=ms-android-motorola-rev2&sourceid=chrome-mobile&ie=UTF-8#sbfbu=1&pi=flsun%20q5%20fans
Flsun V400 calibrationn stock Klipper
01. turn on printer
02. set extruder to 220°C
03. put filament in
03.1. nozzle temp -> 220!!
04. measure 110mm from boden tube up and mark with tape
05. extrude 4x 25mm
06. measure part of filament between boden tube and markingtape
07. do this 3x
08. take the average of the 3 measurements
09. in case of overextrusion add to 100 / in case of under extrusion extract from 100
10. divide outcome by 100 en multuply with the number in -> printer.cfg -> Section: Extruder & Driver Settings -> rotation_distance : (~line 175)
11. EXAMPLE :
11.1 measurement 1: 11.40
11.2 measurement 2: 11.73
11.3 measurement 3: 11.99
11.4 average: 11.7
11.5 number in configfile: 4.399
11.6 100 - 1.17 = 98.83 /100 = 0.988 * 4.399 = 4.348
12. change the number in -> printer.cfg -> Section: Extruder & Driver Settings -> rotation_distance : (~line 175) (4.348 in our example)
13. SAVE & EXIT
https://youtu.be/yoLxQPxASxk?si=2s0ripvpWZ_rUpHJ
Flsun V400 honest reviews
https://youtu.be/WNBbY0BPOJ0?si=1OwQc6xvFZoqgoen
Flsun V400 installing stock Klipper
0001. Download Flsun stock Images
0002. https://flsun3d.com/pages/v400-support
0003. https://flsun3d.com/pages/speeder-pad-support
001. Download V1.2 Image from --> https://drive.google.com/file/d/11FraKdFJ5tIX5uzo8qZxaVx9p5Q_Lzoa/view?usp=share_link
002. Create Sd-card with V1.2 image
003. Insert created Sd-Card into SpeederPad
004. Wait for Progressbar to fill completely (~8min, have patience)
005. Switch off speederpad
006. Remove Sd-card
007. Instructions -> Connect Printer USB & start up SpeederPad -> This gave an unwanted error (somethinbg with a negative value) -> Keep printer disconnected
008. Wait for connection error message (have patience)
009. Connect to WiFi
010. ---> Connect with SSH
010.1 Username: pi
010.2 Password: flsun
010.3 sudo passwd pi
010.4 type: flsun
010.5: type: new pa$$w0rd (2x)
011. ---> Update ubuntu
012. sudo apt update && sudo apt full-upgrade -y --> If the packager report not to upgrade run commands seperately -->> && is the divider for the commands
013. sudo apt autoremove
014. sudo apt autoclean
015. sudo apt clean
016. sudo reboot
016.1 Install Raspberry pi standard welcome screen => https://victordeveloper.victorloorendejong.nl/SolutionsPage?SearchTerm=welcome&SearchEnabled=True&Classification=All
017. ---> Change the time zone ---> https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki/Change-Timezone
018. timedatectl
019. sudo dpkg-reconfigure tzdata
020. timedatectl
021. Reboot if changes are not reflected
022. ---> Change Wifi Country ---> https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki/Change-Wi-Fi-Location
023. iw reg get
024. On the 2nd line of the result look @ country: DE?
025. To set to NL -> sudo iw reg set NL
026. iw reg get
027. Country code for NL: 98
028. sudo sed -i 's/^REG.*=$/&NL/' /etc/default/crda
029. sudo sed -i '/^exit 0/ d' /etc/rc.local
030. echo -e "iw reg set NL\nexit 0 " | sudo tee -a /etc/rc.local
031. To see list of all countries --> sudo cat /usr/share/zoneinfo/zone.tab
032. sudo reboot
033. iw reg get
034. ---> Update dependencies ---> https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki/Update-dependencies
035. curl -L https://raw.githubusercontent.com/Guilouz/Klipper-Flsun-Speeder-Pad/main/Downloads/sp_installer1.sh -o /home/pi/sp_installer1.sh
036. sudo bash /home/pi/sp_installer1.sh
037. !!--> On the speederpad < --!!
038. Config -> Settings -> Hide sensors in temp -> off
039. MCU temp is shown in pad
040. sudo apt-get install network-manager -y
040.1 Screen: processing triggers for systemd --> speederpad: wait for temp graph to indicate idle
041. Powercycle SpeederPad
041.1 on speederpad connect to wifi
042. sudo mkdir -p /etc/NetworkManager/conf.d
043. sudo nano /etc/NetworkManager/conf.d/any-user.conf
044. Add Following lines:
045. [main]
046. auth-polkit=false
047. CTRL + X
048. Y --> ENTER
049. sudo reboot
049.1 on speederpad connect to wifi
050. Enter the following commends 1 by 1:
051. sudo systemctl -q disable dhcpcd 2> /dev/null
052. sudo systemctl -q stop dhcpcd 2> /dev/null
053. sudo systemctl enable NetworkManager
054. sudo systemctl -q --no-block start NetworkManager
055. nmcli device wifi list
056. nmcli device wifi connect "Your_SSID" password "Your_Password"
057. nmcli device status
058. curl -L https://raw.githubusercontent.com/Guilouz/Klipper-Flsun-Speeder-Pad/main/Downloads/sp_installer2.sh -o /home/pi/sp_installer2.sh
059. sudo bash /home/pi/sp_installer2.sh
060. ---> Delete Flsun builds --> https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki/Delete-Flsun-Builds
061. Start kiauh
062. ./kiauh/kiauh.sh
062.1 Chose 4 -> Do not use Alpha & remember
063. If this error is shown -> fatal: detected dubious ownership in repository at '/home/pi/kiauh'
064. Remove folder
065. sudo rm -rf kiauh
066. ---> Install kiauh
067. cd ~ && git clone https://github.com/dw-0/kiauh.git
068. ./kiauh/kiauh.sh
069. Try using kiauh v6-alpha We chose: 4 -> No, remember answer
070. Type -> 3 -> Remove
071. Type -> 10 -> MJPG Streamer
072. Type -> 7 -> KlipperScreen
073. Type -> 3 -> MainSail
074. Type -> 2 -> MoonRaker
075. Type -> 1 -> Klipper
076. Type -> b -> Main menu
077. Type -> q -> Exit kiauh
078. ---> Clean up Flsun things
079. sudo rm -rf /home/pi/.moonraker_database_1 && rm -rf /home/pi/.moonraker_database_2 && rm -rf /home/pi/.moonraker_database_3
080. sudo rm -rf /home/pi/klipper_config && rm -rf /home/pi/klipper_logs && rm -rf /home/pi/moonraker-timelapse
081. sudo rm /home/pi/savedVariables1.cfg && rm /home/pi/savedVariables2.cfg && rm /home/pi/savedVariables3.cfg
082. sudo rm -rf /home/pi/.cache && rm -rf /home/pi/.gnupg && rm -rf /home/pi/.local && rm -rf /home/pi/.config
083. ---> Install Official Builds (1 instance) --> https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki/Install-Official-Builds-(1-instance)
083.1 --> Do steps --> 510 first
084. ./kiauh/kiauh.sh
085. type -> 1 -> Install
086. Type -> 1 -> Klipper
087. Type -> 1 -> Python 3.x -> most recent
088. Type -> 1 -> Klipper instances --> (Creation of Klipper virtualenv failed -> see common issues 510)
089. Type -> 2 -> Moon Raker
090. Type -> 3 -> MainSail
091. Type -> n -> Download recommended macro's
092. Type -> b -> Back to main menu
093. Type -> q -> Exit
094. ---> Download KlipperScreen
095. cd ~ && git clone https://github.com/Guilouz/KlipperScreen-Flsun-Speeder-Pad.git /home/pi/KlipperScreen
096. ./KlipperScreen/scripts/KlipperScreen-install.sh
097. Press ENTER ->Standallone ->Default -> Yes
098. Press ENTER -> Xserver or Wayland -> Default -> X(server)
099. Type -> n -> Install network manager -> No -> Already done in previous steps (2x)
100. cd ~ && ln -s ~/gcode_files/USB-Disk ~/printer_data/gcodes/USB-Disk
101. sudo reboot
102. Go to Web interface --> http://192.168.2.24/
103. Machine -> Open file: moonraker.conf
104. @ the BOTTOM, add the following lines
105. [update_manager KlipperScreen]
106. type: git_repo
107. path: ~/KlipperScreen
108. origin: https://github.com/Guilouz/KlipperScreen-Flsun-Speeder-Pad.git
109. virtualenv: ~/.KlipperScreen-env
110. requirements: scripts/KlipperScreen-requirements.txt
111. system_dependencies: scripts/system-dependencies.json
112. managed_services: KlipperScreen
113. Click -> Save & Restart
113.1 -> previous step might fail --> Desired result: SpeederPad Showing Klipper homescreen with Logo --> Restart with step 1 :(
114. ---> Update V400 Motherboard Firmware --> Printer specific --> https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki/Update-V400-Motherboard-Firmware-(Nano-V2.1-Clone---GD32F303)
115. https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki/Update-V400-Motherboard-Firmware-(Nano-V2.1-Clone---GD32F303)
116. cd ~/klipper/
117. make menuconfig
118. Highlight -> Enable extra low-level config.... -> Press ENTER
119. Highlight -> Micro-controller Arch.... -> Press ENTER
120 Hightlight -> STMicroelectronics STM32 --> Press ENTER
121. Hightlight -> Bootloader --> Press ENTER
122. Hightlight -> 28KiB --> Press ENTER
123. Hightlight -> Communication interface ..... --> Press ENTER
124. Hightlight -> Serial (on USART3 PB11/PB10) --> Press ENTER
125. Press Q (Quit) -> Y (yes)
126. make clean
127. make
128. ./scripts/update_mks_robin.py out/klipper.bin out/Robin_nano35.bin
129. In MobaXterm File explorer -> Left side of screen with folders
130. Go To -> klipper -> out -> Copy file -> Robin_nano35.bin (/home/pi/klipper/out/)
131. Get a small USd card (Les then 4gb -> No big cards supported!)
132. Format SD card -> File system -> Fat-32 --> Allocation ... -> 4096
133. Copy Robin_nano35.bin -> to SD-card
134. Eject SD-Card
135. Turn off printer
136. In the top of the printer is the mainboard with USD slot --> Insert Sd card into PRINTER MAINBOARD
137. Turn on printer -> LOOK AT FLSUN LOGO!
138. Correct Flashing pattern: 1x -> 2x -> Flikkering
139. Worng Flasshing pattern: 1x -> 2x -> steady
140 Wait 1 minute
141. Turn off printer
142. Remove SD card from mainboard
143. Re insert SD card into PC
144. Check file on SD card, it should be renamed to ->ROBIN_NANO35.BIN.CUR
145. If this is not the case flashing FAILED! --> Look at 520
146. Turn on printer for next steps
150. ---> Configure MainSail -> Use configurations --> https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki/Use-Configurations
151. Download files from github -> https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/archive/refs/heads/main.zip
152. Unzip files -> Folder Flsun_V400 -> Needed_for_conversion -> SpeederPad-Main - Conigurations --- MKS Robin Nano 2.0 - Stock ---
153. --> Get USB Serial from Motherboard --> https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki/Get-USB-Serial-from-Motherboard
154. Connect USB cable to speederpad
155. connect to speederpad with SSH
156. cd ~ && ls /dev/serial/by-id/*
156.1 Result in console should look similar to --> /dev/serial/by-id/usb-1a86_USB_Serial-if00-port0
157. ls /dev/serial/by-path/* --> should return 1 result per instance
158. Go to the unzipped Configuration folder from previous step
159. Open file --> printer.cfg
160. Go to section --> [mcu]
161. See serial: XXXXX (~line 353)
162. replace XXXXX with output --> cd ~ && ls /dev/serial/by-id/*
162.1 Result in console should look similar to --> /dev/serial/by-id/usb-1a86_USB_Serial-if00-port0
163. Example in printer.cfg file -> serial: /dev/serial/by-id/usb-1a86_USB_Serial-if00-port0
164. Save & Exit the printer.cfg file
165. Open Mainsail webinterface
166. Go to tab Machine
167. upload needed Configuration files (KlipperScreen.conf -> macros.cfg -> printer.cfg)
168. click --> FIRMWARE RESTART (same page)
169. In Config Files file will be added --> variables.cfg
170. 2 gauges will be added --> MEM & mcu
180. --> Fix Shutdown button in Mainsail --> https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki/Fix-Shutdown-button-in-Mainsail
181. cd ~/moonraker/scripts
182. ./set-policykit-rules.sh
183. sudo reboot
184. Go to Mainsail webinterface
185. Click --> Machine tab
186. Open file--> moonraker.conf
187. Add the following lines AT THE BOTTOM
188. [machine]
189. shutdown_action: halt
190. click --> SAVE & RESTART
200. --> Add Webcams Support --> https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki/Add-Webcams-Support
200.1 connect webcam
201. connect to speederpad with SSH
202. ./kiauh/kiauh.sh
203. type -> 1 -> Install
204. type -> 14 -> Crowsnest
205. type -> y -> add 'update manager' to moonraker.conf
206. type -> y -> reboot
207. Go to Mainsail webinterface
208. click --> Machine
209. Open file --> moonraker.conf
210. confirm [update manager crowsnest] section
211. Go to interface settings
212. Go to --> Webcams
213. click --> ADD WEBCAM (webcam footage should be seen)
214. enter name
215. click --> SAVE WEBCAM
220. --> Add Exclude Objects Support -->https://docs.mainsail.xyz/overview/features/exclude-objects
221. On the site mentioned above -> Go to section --> Enable the G-Code preprocessor in Moonraker
222. Go to Mainsail webinterface
223. click --> machine tab
224. open file --> moonraker.conf
225. add the following lines AT THE BOTTOM:
226. [file_manager]
227. enable_object_processing: True
228. click --> SAVE & RESTART
229. open file --> printer.cfg
230. add the following line in section # Editable Settings:
231. [exclude_object]
232. click --> SAVE & RESTART
240. --> STL Files & Themes --> https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki/STL-Files-&-Themes
241. click --> FLSUN V400 Mainsail Theme
242. unzip files
243. Go to Mainsail webinterface
244. click --> Machine tab
245. click --> Settings cogwheel
246. check box --> hidden files
247. Create new folder --> .theme
248. click --> .themes
249. upload images from unzipped folder --> .themes
500. Common Issues:
501. ---> Cloning Klipper from ....... failed (After step 088)
502. SOLUTION -> Just redo the same step again
510. ---> Creation of Klipper virtualenv failed! (Step 088)
511. SOLUTION --> export SETUPTOOLS_USE_DISTUTILS=stdlib
512. SOLUTION --> virtualenv --download -p python3 ~/klippy-env/
513. SOLUTION --> sudo pip uninstall setuptools
514. SOLUTION --> sudo pip install setuptools==59.6.0
515. Proceed with step -> 84
515. SOLUTION --> virtualenv --download -p python3 ~/klippy-env/
520. ---> Wrong flashing of the mainboard
521. SOLUTION: Smaller Sd card -> formated-> NTFS -> 2048
https://drive.google.com/file/d/11FraKdFJ5tIX5uzo8qZxaVx9p5Q_Lzoa/view?usp=share_link
https://flsun3d.com/pages/speeder-pad-support
https://flsun3d.com/pages/v400-support
https://github.com/dw-0/kiauh
https://github.com/Guilouz/Klipper-Flsun-Speeder-Pad/wiki
https://www.youtube.com/watch?v=QrKlNbrCGLw
https://youtube.com/watch?v=RoReOf8sMDI&si=NgB2WJGOMu-7vuRp
Flsun V400 network issues
01. nano /etc/network/interfaces
02. auto wlan0 iface wlan0 inet dhcp wpa-ssid "Your_SSID" wpa-psk "Your_Password" auto wlan1 iface wlan1 inet dhcp wpa-ssid "Your_SSID" wpa-psk "Your_Password"
03. sudo systemctl restart networking
dmesg | grep -i error
Flsun v400 no internet
sudo systemctl restart NetworkManager
Flsun V400 Speederpad not / intermittent able to connect
01. Find a way to connect with mainsail
02. Go to -> Machine tab
03. Open -> moonraker.conf
04. Look for Section --> [authorization] --> trusted_clients:
05. Add --> 192.168.2.0/24
06. This will trust all devices with the base IP: 192.168.2.*
Flsun V400 SpeederPad Repo
https://github.com/Flsun3d
Flsun V400 upgrade Ubuntu 20.04 -> 22.04
No solution suggestion yet.
Flsun V400 Using mesh in cura
01. Go to -> Klipper -> Height map
02. Look at the name of the mesh profile -> Most likely -> default
03. In Cura -> Settings -> Printer -> Manage printers -> Select v400 -> Machine settings
04. In Start G-code add the following code
05. BED_MESH_PROFILE LOAD="profile_name"
06. BED_MESH_PROFILE LOAD="default"
Flsun v400 WLan reset
01. sudo nano /home/pi/toggle_wlan.sh
02. #!/bin/bash # Define the interface variable INTERFACE="wlan0" # Define the sleep duration variable (in seconds) SLEEP_DURATION=1 # Run the script 5 times initially with a 2-second interval for i in {1..5} do # Get the current time CURRENT_TIME=$(date +"%Y-%m-%d %H:%M:%S") # Disable the interface sudo ifconfig $INTERFACE down echo "$CURRENT_TIME: $INTERFACE disabled" # Wait for the specified duration sleep $SLEEP_DURATION echo "Sleep for $SLEEP_DURATION Second('s)" # Get the current time again CURRENT_TIME=$(date +"%Y-%m-%d %H:%M:%S") # Enable the interface sudo ifconfig $INTERFACE up echo "$CURRENT_TIME: $INTERFACE enabled" # Wait for 2 seconds before the next iteration sleep 2 done # Run the script indefinitely every 10 seconds while true do # Get the current time CURRENT_TIME=$(date +"%Y-%m-%d %H:%M:%S") # Disable the interface sudo ifconfig $INTERFACE down echo "$CURRENT_TIME: $INTERFACE disabled" # Wait for the specified duration sleep $SLEEP_DURATION echo "Sleep for $SLEEP_DURATION Second('s)" # Get the current time again CURRENT_TIME=$(date +"%Y-%m-%d %H:%M:%S") # Enable the interface sudo ifconfig $INTERFACE up echo "$CURRENT_TIME: $INTERFACE enabled" # Wait for 30 minutes before the next iteration sleep 1800 done
03. sudo chmod +x /home/pi/toggle_wlan.sh
04. sudo nano /etc/systemd/system/toggle_wlan.service
05. [Unit] Description=Run Toggle WLAN Script [Service] ExecStart=/home/pi/toggle_wlan.sh User=root [Install] WantedBy=multi-user.target
06. sudo systemctl daemon-reload
07. sudo systemctl enable toggle_wlan.service
08. sudo systemctl start toggle_wlan.service
09. sudo systemctl start toggle_wlan.service
Flsun V490 psu fan
guestematuon: 80mm
power regulated
screw distance: 75mm
Folder permissions
https://www.pluralsight.com/blog/it-ops/linux-file-permissions
FontAwesome toevoegen aan een project
01. Open NuGet manager
02. browse: FontAwesome
03. install the package
04. In pages -> _Host.cshtml <head> add this code: <script src="https://kit.fontawesome.com/YOURCODEHERE.js" crossorigin="anonymous"></script>
05. In you web page use: <i class="fas fa-check"></i>
For each loop
No solution suggestion yet.
For loop
No solution suggestion yet.
Foreach
No solution suggestion yet.
fp 4 microphone issues
https://forum.fairphone.com/t/call-microphone-issues/80888
Free icon sets for coding
https://dev.to/icons/free-icons-jna
Free video edit software
01. Lightworks (See 1Password for account details)
02. X NCH VideoPad (Only 1 free video export)
03. X Cool cut
04. X Movavi Video Editor
Gcode
https://marlinfw.org/docs/gcode/M104.html
Generics
No solution suggestion yet.
Generics
No solution suggestion yet.
GIT (Soft reset ) remove local commits keep changes
git reset --soft HEAD~1 -> All changes will we staged
https://stackoverflow.com/questions/19859486/how-to-un-commit-last-un-pushed-git-commit-without-losing-the-changes
GIT CLI (Hard reset) remove local commits
git reset --hard origin/<branch_name>
https://stackoverflow.com/questions/5097456/throw-away-local-commits-in-git
GIT CLI Commit
Commit -> git commit
GIT CLI config
git config --list
GIT CLI Course
https://courses.iamtimcorey.com/courses/1757881/lectures/39624925
GIT CLI create branch
git branch new_branch_name
GIT CLI Create new branch based on branch
01. git checkout <branch-name>
02. git pull origin <branch-name>
03. git checkout -b <new-branch-name> -> Creates a new branch from current checked out branch
04. git push origin <branch-name> -> Optional
GIT CLI create new branch during checkout
git checkout -b New-Branch-Name
GIT CLI Delete branch
Delete upstream branch: git push origin --delete <branch_name>
Force delete: git branch -D branch-name
git branch -d branch-name
GIT CLI Delete commit
01. git reset --hard HEAD~1
02. git push -f
GIT CLI Delete local branch
01. Normal delete
02. git branch -d <branch_name>
03. Force delete the branch regardless of its merge status, potentially leading to loss of work.
04. git branch -D <branch_name>
GIT CLI gitignore
comment -> #
Ignore debug folders -> **/[Dd]ebug
Ignore folder at any level-> **/<folder_name>
Ignore log files -> *.log
Ignore log folder at any level-> **/log
GIT CLI install
https://git-scm.com/downloads
GIT CLI Merge branches
01. git pull origin <source_branch>
02. git pull origin<target_branch>
03. git checkout <target_branch>
04. git merge <source_branch>
05. git push origin
GIT CLI Merge FastForeward - ff
01. git fetch
02. git checkout <target_branch>
03. git merge --ff-only <source_branch>
04. git push origin
GIT CLI Outgaing change push fails (prune)
git remote prune origin
GIT CLI Pull
git pull origin <branch-name>
GIT CLI Push
git push origin <branch-name>
GIT CLI Push changes and create a new upstream branch
git push --set-upstream origin <Branch_Name>
GIT CLI set upstream
git push -u origin <feature_branch_name>
GIT CLI Show git tree
gitk --all
GIT CLI Stage -> Commit -> Push
01. git add . -> stages all changes
02. git commit -m "Commit message goes here"
03. git push origin
GIT CLI Stage / Staging
Stage git ignore -> git add .gitignore
Unstage file -> git rm --cached <file>.
GIT CLI Update git windows
git update-git-for-windows
Git CLI update/change commit
Ammend
Git CLI version
git version
GIT CLI view branches
git branch
GIT filter appsettings
01. git filter-branch --force --index-filter 'git rm --cached --ignore-unmatch "RepoNameGoesHEreRemove"""/appsettings.json' --prune-empty --tag-name-filter cat -- --all
02. git push --force
GIT ignore appsetting.dev
01. Go to project folder look for the file: .gitignore
02. Open it in notepad
03. It should have some lines already!
04. ## Ignore Visual Studio temporary files, build results, and
05. ## files generated by popular Visual Studio add-ons.
06. add these lines:
07. # Ignore appsettings.Development.json in all subdirectories
08. **/appsettings.Development.json
09. Remove the file from the Git index with the following command:
10. git rm --cached appsettings.Development.json
11. Commit changes:
12. git add .gitignore
13. git commit -m "Update .gitignore to exclude appsettings.Development.json"
14. Push the changes:
15. git push origin <your-branch-name>
16. This will ensure that appsettings.Development.json is excluded from your repository and won’t be tracked by Git anymore
GIT initialize / create a repository
New folder in this folder: git init <repo_name>
This folder: git init
GIT local step back
youtube git reset
GIT management GUI
https://gitforwindows.org/
Git show git tree
gitk --all
GIT Tree visual representation
https://gitextensions.github.io/
GIT workflow
https://www.atlassian.com/git/tutorials/comparing-workflows/gitflow-workflow
GitHub Change default branch
01. Sign in to GitHub
02. Go to repository
03. Settings
04. Default branch
05. click -><- button
06. Select new default branch
07. Click: Update
GITHub Markdown
https://github.com/im-luka/markdown-cheatsheet?tab=readme-ov-file#paragraph
Group Policies
No solution suggestion yet.
GTI CLI View commits / log
Exit log -> q
git log
GutHub Copilot referencing a file
For analisys: #<file1> #file#2 analyze these files and .....
Use #<filename> in prompt
GutHub Copilot Writing XML (Reutn comment above methods)
Add XMl documentation for #<file-name>
Handle time change (DayLightSavings)
No runway suggestion yet.
Het gebruik van Breakpoints
No solution suggestion yet.
Het opslaan op meerdere locaties via json file
Directory.CreateDirectory(filePath);
File.Create(filePath)
HexOs zfs disks
https://cobesu.nl/product/16tb-seagate-ironwolf-pro/
Hindi (Telugu) (hello)
01. Goede morgen = sju bodaium
02. Goede middag = sju madjeno
03. Good night = Subaratrie
04. Congratulations = Subakansjalu
04. Its my pleasure = Anamdam
05. Ahmah = moeder
sju = goed
Hoe bouw ik de verbeteringen in een bestaande applicatie
No solution suggestion yet.
Hoe bouw ik een applicatie
No solution suggestion yet.
Hoe debug ik een applicatie
No solution suggestion yet.
Hoe ga ik om met Exceptions
No solution suggestion yet.
Hoe groei ik door als developer
No solution suggestion yet.
Hoe kan ik anderen helpen
No solution suggestion yet.
Hoe plan ik een applicatie van te voren
No solution suggestion yet.
Hoe stel ik vragen op forums
No solution suggestion yet.
Hoe verbeter ik de applicatie
No solution suggestion yet.
Hoe verhoog ik mijn efficientie
No solution suggestion yet.
Hosting meerdere .net web apps
https://ollie10.medium.com/how-to-host-an-asp-net-core-3-1-application-on-linux-ubuntu-20-04-with-apache-as-reverse-proxy-34bf2fb18502
https://www.syncfusion.com/blogs/post/hosting-multiple-asp-net-core-apps-in-ubuntu-linux-server-using-apache.aspx
How to use the Where clouse
No solution suggestion yet.
HTML accessibility richtlijnen
https://www.forumstandaardisatie.nl/open-standaarden/digitoegankelijk-en-301-549-met-wcag-21
https://www.lullabot.com/articles/what-heck-aria-beginners-guide-aria-accessibility
HTML add empty line in list li
01. <li>Item 1</li>
02.
03. <li>Item 2</li>
HTML Basics
https://www.websiteplanet.com/blog/html-guide-beginners/
HTML block browser to see disapearing HTML in the inspector
01. Note: "Edit as HTML" breaks the events like OnClick (Try RMB(on element) -> Attributes -> Add attribute)
02.01. //Block browser with alert to check HTML
02.02. document.body.setAttribute("onclick", "");
02.03. document.body.setAttribute("onmousemove", "");
02.04. // To switch to different mouse event switch comment below
02.05. document.body.setAttribute("onclick", "iets(event)");
02.06. //document.body.setAttribute("onmousemove", "iets(event)");
02.07. var itv;
02.08. function iets (e) {
02.09. console.clear()
02.10. console.info(e)
02.11. clearTimeout(itv)
02.12. itv = setTimeout(function (){
02.13. alert("Browser is blocked, check inspector for HTML");
02.14. }, 1000);
02.15. }
03. do not forget the CTRL + Enter to enable the function
Html browser standarts
https://caniuse.com/
HTML Elementen
No solution suggestion yet.
HTML elements get disappearing code by class
01. Edit as HTML breaks the events like OnClick (Try RMB(on element) -> Attributes -> Add attribute)
02.01. //export class to alert
02.02. document.body.setAttribute("onclick", "");
02.03. document.body.setAttribute("onmousemove", "");
02.04. // To switch to different mouse event switch comment below
02.05. document.body.setAttribute("onclick", "iets(event)");
02.06. //document.body.setAttribute("onmousemove", "iets(event)");
02.07. var itv;
02.08. function iets (e) {
02.09. console.clear()
02.10. console.info(e)
02.11. clearTimeout(itv)
02.12. itv = setTimeout(function (){
02.13. alert(document.querySelector(".e-ddl").outerHTML);
02.14. }, 1000);
02.15. }
03. Do not forget: In the console: CTRL + Enter (should report:<- undefined )
HTML Event (mouse click) not working
Edit as HTML breaks all events
Try RMB(on element) -> Attributes -> Add attribute
HTML id element
Something that is unique in the entire page
HTML Inspector and console one screen
Press: Esc
HTML Lorem ipsum Generator
https://www.blindtextgenerator.com/lorem-ipsum
HTML make a table row draggable
https://htmldom.dev/drag-and-drop-table-row/
HTML make things draggable
https://htmldom.dev/drag-and-drop-element-in-a-list/
HTML Non-breaking space
https://mailtrap.io/blog/nbsp/
HTML Number input
No solution suggestion yet.
HTML Remove alert code from console
01. Note: "Edit as HTML" breaks the events like OnClick (Try RMB(on element) -> Attributes -> Add attribute)
02.01. document.body.removeAttribute("onclick", "");
02.02. document.body.removeAttribute("onmousemove", "");
03. Do not forget: In the console: CTRL + Enter (should report:<- undefined )
HTML Style element multiple stylings
<h2 style="text-align:center;font-family:tahoma">TITLE</h2>
style="property1:value1;property2:value2"
HTTP Request trace
https://www.telerik.com/blogs/get-started-tracing-http-requests-in-a-few-clicks-windows-macos-linux
https://learn.microsoft.com/en-us/aspnet/core/web-api/action-return-types?view=aspnetcore-8.0#actionresultt-type
No solution suggestion yet.
https://www.oracle.com/database/sqldeveloper/
No solution suggestion yet.
https://www.youtube.com/watch?v=Kx0dsGHxt_Y
No solution suggestion yet.
Hybrid Cloud
No solution suggestion yet.
I/O Opperations
No solution suggestion yet.
Identity en access management
No solution suggestion yet.
IEnumerable VS IQueryable
https://www.youtube.com/watch?v=J2u1DmnE9mU
IEnumerable si fetch all with the linq query later
IQueryable fetches with the filters
Informatie verzenden naar volgende pagina
Example: <a asp-action="Edit" asp-route-id="10" asp-route-foo="bar">Edit</a>
Inheritance
No solution suggestion yet.
Inheritance
No solution suggestion yet.
Inheritance
No solution suggestion yet.
Inserting data
No solution suggestion yet.
Install .Net 7 on Raspberry
01. wget -O - https://raw.githubusercontent.com/pjgpetecodes/dotnet7pi/master/install.sh | sudo bash
02. sudo reboot
03. dotnet run
https://www.petecodes.co.uk/install-and-use-microsoft-dot-net-7-with-the-raspberry-pi/
Install IfConfig on Ubuntu 22.04
01. sudo apt-get update
02. sudo apt-get install net-tools
Install MySQL
1. sudo apt update
2. sudo apt upgrade
3. sudo apt install mysql-server
4. mysql --version
5. sudo mysql_secure_installation
6. sudo systemctl status mysql
https://phoenixnap.com/kb/install-mysql-ubuntu-20-04
https://phoenixnap.com/kb/install-mysql-ubuntu-20-04
Install PHP on Ubuntu
https://phoenixnap.com/kb/install-php-on-ubuntu
sudo apt install php
Install Samba
1. sudo apt update
2. sudo apt install samba -y
3. Check the status for UFW -> sudo ufw status verbose
4. If UFW is planned or active -> sudo ufw allow Samba
https://ubuntu.com/tutorials/install-and-configure-samba#2-installing-samba
Install Ubuntu on Raspberry
https://ubuntu.com/tutorials/how-to-install-ubuntu-on-your-raspberry-pi#3-wifi-or-ethernet
Installeren Apache server
1. sudo apt-get update
2. sudo apt-get install apache2 -y
3. In browser: http://local.server.ip
https://phoenixnap.com/kb/how-to-install-apache-web-server-on-ubuntu-18-04
https://www.digitalocean.com/community/tutorials/how-to-install-the-apache-web-server-on-ubuntu-20-04#step-5-%E2%80%94-setting-up-virtual-hosts-(recommended)
Installeren ssh-server
01. sudo apt install openssh-server openssh-client
02. sudo systemctl status ssh
03. sudo ufw allow ssh
04. sudo ufw status
05. sudo ufw enable
05. sudo ufw status
https://linuxhint.com/how-to-install-and-enable-openssh-on-ubuntu/
Installeren van .net 5.0 in Ubuntu
https://docs.microsoft.com/en-us/dotnet/core/install/linux-ubuntu#2004-
https://tecadmin.net/how-to-install-net-core-on-ubuntu-20-04/
Instantiated Classes
No solution suggestion yet.
Instantiated Classes
No solution suggestion yet.
Interfaces
No solution suggestion yet.
Interfaces
No solution suggestion yet.
Inzicht geven van activiteiten voor een project
No runway suggestion yet.
IP adress binaire calculatie
http://kernelpokenic.blogspot.com/2011/11/subnetting-ipv4-primer.html
ISO Language Code Table
http://www.lingoes.net/en/translator/langcode.htm
Join (Inner, left and right) querys
No solution suggestion yet.
json editor create tree from serialized data
!! Clear json when done !!
https://jsoneditoronline.org
Json validation
https://jsonlint.com/
Key shortcuts voor Visual Studio
No solution suggestion yet.
Ko-Ken
https://www.hoffmann-group.com/NL/nl
https://www.koken-tool.co.jp/
https://www.koken-tool.co.jp/catalog/KOKEN_202308ENSP.pdf
https://www.koken-tool.co.jp/en/
https://www.misterworker.com/en/cart?action=show
Libraries
No solution suggestion yet.
Lightworks Fade in and out
https://www.youtube.com/watch?app=desktop&v=RkRxJ9P_Sgs&t=4
Lightworks Still image audio continues
01. Add video track
02. Split video to new track (Highest track is shown)
03. Drag audio to extra audio layer
04. Disable extra audio track
05. Cut out the frame you want
06. Change speed to 0% (Right click Deselect all -> right click -> Speed -> 0%)
07. Edit the still image with sepia or other things
08. Drag the still to the correct position
Linq / Lambdas
No solution suggestion yet.
Linq / Lambdas
No solution suggestion yet.
Linq join opperations
https://learn.microsoft.com/en-us/dotnet/csharp/linq/standard-query-operators/join-operations
LINQ JOINS and UNIONS
https://learn.microsoft.com/en-us/dotnet/api/system.linq.enumerable.join
https://learn.microsoft.com/en-us/dotnet/api/system.linq.enumerable.unionNo solution suggestion yet.
Linq translate SQL to Linq
https://www.linqpad.net/
Linux CLI Commandline space
my\ dir
Linux mint (Mate) Boot menu (Grub) timer change
01. Open the grub config: sudo nano /etc/default/grub
02. Modify the GRUB_TIMEOUT_STYLE: -> GRUB_TIMEOUT_STYLE=menu
03. Modify the GRUB_TIMEOUT -> GRUB_TIMEOUT=5
04. Save and close the file: CTRL + S -> CTRL + X
05. Run the command: sudo update-grub
06. Reboot the system: sudo reboot
Linux mint (Mate) Cron GUI
01. sudo add-apt-repository ppa:blaze/main
02. sudo apt update
03. sudo apt install zeit
04. In the menu you can search for: Zeit
https://github.com/loimu/zeit
Linux mint (Mate) giving smb (samba) v1.0 access
01. Open config file-> sudo nano /etc/samba/smb.conf
02. Add SMB1 Protocol Support: Inside the [global] section -> server min protocol = NT1
03. sudo service smbd restart
04. sudo systemctl restart smbd
Linux Mint (Mate) mounting a folder as a drive
00. One of the limitations I found sofar: Subfodlers might not be available since fstab mounting is not recursive (Recursive = underlaying files and folders)
01. Make a directory -> sudo mkdir /media/mydrive
02. Mount the Folder Using bind Option: -> sudo mount --rbind /mnt/myfolder /media/mydrive
03. Verify the Mount: ->ls /media/mydrive
04. Make the Mount Persistent: -> sudo nano /etc/fstab
05. Add the following line to the end of the file: -> /mnt/myfolder /media/mydrive none bind 0 0
06. Verify the fstab file to work: -> Test the configuration -> sudo mount -a
07. If a error comes up comment the added line('s) with # and MAKE SURE it works. (If Fstab is not configured correctly the system will no longer boot (Boot with a USB stick with some linux to change the fstab back))
Linux Mint (Mate) Mounting a smb v1.0 drive
//192.168.100.100/share/ /mnt/share/ cifs credentials=/path/to/.smbcredentials,uid=1000,gid=1000,nofail,x-systemd.automount,vers=1.0 0 0
https://victordeveloper.victorloorendejong.nl/DictionaryValuesManagementPage?ProjectTitle=Linux%20Mint%2021.3%20(Mate)&FutureFeaturesLoaded=False&ChallengesLoaded=True&Mode=Challenges&ItemTitle=Linux%20mint%20auto%20mount%20network%20share
Linux Mint (Mate) Shutdown cron job
01. This script must be set for the root user!!
02. sudo crontab -u root -e
03. Add lines:
04. #ShutDown 5 o'clock
05. 0 5 * * * /home/bosviool/Scripts/ShutDown/10sec_shutdown.sh
06. cron time: min hour
07. sudo service cron reload
https://acquia.my.site.com/s/article/360004224494-Cron-time-string-format
https://phoenixnap.com/kb/set-up-cron-job-linux
https://spinupwp.com/doc/add-cron-jobs/
Linux Mint (Mate) Shutdown script
01. #!/bin/bash
02. echo "Shutting down in 10 seconds..."
03. sleep 10
04. shutdown now
Linux mint (Mate) VNC
01. sudo apt-get -y remove vino
02. sudo apt-get -y install x11vnc
03. sudo mkdir /etc/x11vnc
04. sudo x11vnc --storepasswd /etc/x11vnc/vncpwd
05. You will be asked to enter and verify the password. Then press Y to save the password file.
06. Nano is text editor: sudo nano /lib/systemd/system/x11vnc.service
07. copy and paste code below -> save the file
08. [Unit]
09. Description=Start x11vnc at startup.
10. After=multi-user.target
11.
12. [Service]
13. Type=simple
14. ExecStart=/usr/bin/x11vnc -auth guess -forever -noxdamage -repeat -rfbauth /etc/x11vnc/vncpwd -rfbport 5900 -shared
15.
16. [Install]
17. WantedBy=multi-user.target
18.
19. Close and save the file: CTRL X -> Y to save the file
20. sudo systemctl daemon-reload
21. sudo systemctl enable x11vnc.service
22. sudo systemctl start x11vnc.service
23. If you can not connect maybe UFW (Firewall is running)
24. sudo ufw status
25. If status = active
26. for testing: sudo ufw disable
27. sudo ufw enable
28. sudo ufw allow 5900/tcp
29. Retry connecting with VNC
https://community.linuxmint.com/tutorial/view/2334
Linux mint 21.3 (mate) Getting the network speed
cat /sys/class/net/enp4s0/speed
Linux Mint 21.3 (Mate) Speed test
01. sudo apt install speedtest-cli
02. speedtest-cli
Linux mint 21.3 torrent client
01. In appstore download: qBittorrent
02. In mint menu go to: Startup Applications -> Add
03. Command:
04. /usr/bin/flatpak run --branch=stable --arch=x86_64 --command=qbittorrent --file-forwarding org.qbittorrent.qBittorrent @@u %U @@
05. Start minimized: Preferences -> Window state on startup -> Minimized
Linux Mint 23 (Mate) FreeFileSync Boot settings
FreeFileSync /home/USER_NAME/Scripts/FreeFileSync/SCRIPT.ffs_batch
Linux Mint 23 (Mate) RealTimeFileSync Boot settings
No runway suggestion yet.
Linux mint auto mount network share
01. Create a directory for mounting -> sudo mkdir /mnt/network_share
02. Get the UID of your user -> id -u your_username
03. Get the GID of your user -> id -g your_username
04. Edit the /etc/fstab file -> sudo nano /etc/fstab
05. Add a line to mount the network share -> //server_address/share/_name/ mnt/network_share/ cifs credentials=/path/to/.smbcredentials,uid=1000,gid=1000,nofail,x-systemd.automount 0 0
06. Example: //192.168.1.100/share /mnt/network_share/ cifs credentials=/home/your_username/.smbcredentials,uid=1000,gid=1000 0 0
07. //server_address/share_name: The address and name of the network share.
08. /mnt/network_share: The directory you created as the mount point.
09. cifs: The filesystem type for mounting Windows shares.
10. credentials=/path/to/credentials_file: Path to a file containing the username and password required to access the share.
11. uid=your_uid,gid=your_gid: The UID and GID of your user account.
12. 0 0: These values are for filesystem checks and should typically be 0 0.
13. Add the following line in the fstab file (below your previous line entry).
14. LABEL=network_share /mnt/network_share auto nosuid,nodev,nofail,x-gvfs-show 0 0
15. This will make the shred folder show up in your devices list (Twice :) )
16. Save and exit the editor: CTRL + S for save -> CTRL - X -> for exit
17. Create a credentials file ->sudo nano /home/your_username/.smbcredentials
18. Add the following lines to the file:
19. username=your_username
20. password=your_password
21. Replace your_username and your_password with your actual credentials.
22. Save and exit the editor: CTRL + S for save -> CTRL - X -> for exit
23. Set permissions on the credentials file -> sudo chmod 600 /home/your_username/.smbcredentials
24. Test the configuration -> sudo mount -a
25. Possible error's: mount: /etc/fstab: parse error at line 21 -- ignored
26. For disabling your added line use -> # -> commenting the line out (The line of code with # in front of it will not be used!)
27. If a error comes up comment the added line('s) with # and MAKE SURE it works. (If Fstab is not configured correctly the system will no longer boot)
Linux mint automount drives
01. In the menu look for -> Disks
02. Left click on desired Partition
03. Click on the Gears
04. Edit mount options
05. Turn off User session defualts
06. Check Mount at system startup
07. Mountpoint -> Rename last part to partition name
08. Identify as -> Label
Linux mint ExpressVPN (Install)
00. In terminal
01. sudo dpkg -i expressvpn_3.62.0.9-1_amd64.deb
02. sudo expressvpn activate
03. Enter the activation code
04. expressvpn connect
05. expressvpn autoconnect true
06. sudo reboot
07. sudo expressvpn status
https://www.expressvpn.com/nl/support/vpn-setup/app-for-linux/
Linux mint File manager
Caja (Default)
Nautilus
Linux Mint flavour
cat /etc/linuxmint/info
Linux mint mate file sync
https://freefilesync.org/download.php
Linux Mint Mate TeamViewer
01. Install TeamViewer
02. Extras -> Options
03. Start TeamViewer with system
04. General -> Account assignment
05. Login with TeamViewer credentials
06. Confirm device E-mail ->v.....@live.nl
07. Security -> Grant easy access
08. Password strength -> Disabled
09. Apply & close
10. Computers & Contacts
11. Rightclick -> Properties current machine in the devices list
12. Assign password
Linux Mint Mate User Auto Login
01. Search Login window
02. Fill in password
03. click Users tab
04. Fill in username @ Automatic login
05. Make sure there is no delay specified
Linux mint Sharing folders in GUI (Caja)
01. Install: Samba
03. in terminal: sudo nano /etc/samba/smb.conf
04. Below [global] paste:
05. ## To Enable Caja share functionality
06. usershare owner only = false
07. sudo service smbd restart
08. sudo service smbd status
09. Install: Caja Share
Linux mint Sharing folders in GUI (Nautilus)
01. sudo apt-get install nautilus-share
02. In: smb.conf
03. To the [global] section, add the line "usershare owner only = false"
Linux recommended apps
Command history: atuin
Linux USB stick creation
https://etcher.balena.io/#download-etcher
https://github.com/balena-io/etcher/releases/download/v1.18.11/balenaEtcher-Portable-1.18.11.exe
List modifications
No solution suggestion yet.
List virtual hosts
sudo apache2ctl -S
Lists
No solution suggestion yet.
Maak de Class library
No solution suggestion yet.
Maak de nodige tabellen aan in SQL
No solution suggestion yet.
Maak de webpaginas in Razor Pages
No solution suggestion yet.
Maak een index pagina met overzicht van de vooruitgang
No solution suggestion yet.
Maak een index pagina met overzicht van de vooruitgang
No runway suggestion yet.
Maak een lijst per project met alle relevante subprojecten
No solution suggestion yet.
Maak een side menu in razor pages
https://startbootstrap.com/template/simple-sidebarhttps://startbootstrap.com/template/simple-sidebar
Neem uit het gedownloade bestand het menu over uit de web pagina
Maandelijkse rapportage email
No solution suggestion yet.
Maandelijkse rapportage email
No runway suggestion yet.
Main points of application failure
01. Performance
02. Security
Mainproject niet actief bij toevoegen time unit via Add time unit aan subproject
No solution suggestion yet.
Maintainability
No solution suggestion yet.
Mappen delen
Samba
MD5 hash
https://md5.gromweb.com/
Mede8er firmware
https://www.mede8erforum.com/index.php?board=48.0
Mede8er serials
01. med500x2
01. v3.0.5
Meer Security en Validatie inbouwen
No solution suggestion yet.
Meer Security en Validatie inbouwen
No runway suggestion yet.
Meerdere domeinen hosten op een server
https://codeburst.io/configuring-a-subdomain-in-apache2-f7a8b316b42c
https://linuxize.com/post/how-to-set-up-apache-virtual-hosts-on-ubuntu-20-04/
https://publib.boulder.ibm.com/httpserv/manual70/vhosts/mass.html
https://serverfault.com/questions/942587/how-to-configure-multiple-apache-subdomains-for-net-core-2-0-on-ubuntu
https://webmasters.stackexchange.com/questions/83316/virtualhost-config-routing-and-wildcard-usage/83320#83320
https://www.atlantic.net/vps-hosting/host-multiple-websites-on-a-single-server-with-apache-on-ubuntu-18-04/
Meerdere items versturen via asp-route maken zoals het hoort
No solution suggestion yet.
Meerdere items versturen via asp-route maken zoals het hoort
Dictionary management
Dictionary management page
Zoek naar delimiter in cshtml
Meerdere websites aan certbot SSL certificaat toevoegen
sudo certbot --cert-name example.com -d example.com -d www.example.com -d mail.example.com
sudo certbot --expand -d mysite.com,imap.mysite.com,smtp.mysite.com
Method overloading
No solution suggestion yet.
Method overriding
No solution suggestion yet.
Methods/Functions
No solution suggestion yet.
Microsoft 365 productivity en teamwork solutions
No solution suggestion yet.
Minecraft How-To creata a village
https://minecraft.fandom.com/wiki/Tutorials/Creating_a_village
https://minecraft.wiki/w/Village
Minecraft How-To videos Allay Item Catcher
01. Shoppinglist TS 09:06
01a. 1 noteblock
01b. 2 observers
01c. 1 block of planks
01d. 8 trapdoors
01e. 1 bucket of water
01f. 1 temporary block sand/dirt
01g. 1 hopper
01h. 1 or double chest
https://www.youtube.com/watch?v=jCUoHzODwLg
Minecraft Installing shaderpacks 1.20.4
00. Guide: https://www.patreon.com/posts/guide-ptgi-27260900
01. Download Java: https://www.java.com/en/download/
02. Download Optifine: https://optifine.net/adloadx?f=OptiFine_1.20.4_HD_U_I7.jar&x=7d82
03. Download SEUS PTGI: https://www.sonicether.com/seus/
04. Install: Java
05. Install: Optifine
06. Start: Minecraft
07. Options (Esc) -> Video setiings -> Shaders -> Shaders folder
08. Go in Explorer -> View -> Show -> Hidden items
09. Go to folder: C:/users/YourUserName/AppData/Roaming/.minecraft/shaderpacks
10. Copy the ZIP/Compressed SEUS file to the shaderpacks folder
11. The shader pack should appear in the Minecraft options
12. Select the SuesPTGI in the list
13. Let's Play!
https://optifine.net/adloadx?f=OptiFine_1.20.4_HD_U_I7.jar&x=7d82
https://optifine.net/downloads
https://www.java.com/en/download/
https://www.patreon.com/posts/guide-ptgi-27260900
https://www.sonicether.com/seus/
Minecraft Installing shaderpacks optifine 1.20.2
-1. Intsall New minecraft version in the Launcher version 1.20.2
00. Guide: https://www.patreon.com/posts/guide-ptgi-27260900
01. Download Java: https://www.java.com/en/download/
02. https://optifine.net/downloadx?f=OptiFine_1.21.1_HD_U_J1.jar&x=42a9770e64db4482d45b6d18fa72df28
03. Download SEUS PTG / Renewed (lower end systems)I: https://www.sonicether.com/seus/
04. Install: Java
05. Start: Minecraft 1.20.2
06. Install: Optifine
08. Start: Optifine Minecraft 1.20.2
09. Options (Esc) -> Video setiings -> Shaders -> Shaders folder
10. Go in Explorer -> View -> Show -> Hidden items
11. Go to folder: C:/users/YourUserName/AppData/Roaming/.minecraft/shaderpacks
12. Copy the ZIP/Compressed SEUS file to the shaderpacks folder
13. The shader pack should appear in the Minecraft options
14. Select the Sues PTGI / Renewed in the list
15. Let's Play!
https://optifine.net/adloadx?f=preview_OptiFine_1.20.2_HD_U_I7_pre1.jar&x=00dc
https://optifine.net/downloads
https://optifine.net/downloadx?f=OptiFine_1.21.1_HD_U_J1.jar&x=42a9770e64db4482d45b6d18fa72df28
https://s3.us-east-2.amazonaws.com/ardentfilops/qhkh116jrn/Setup_854959.html?utm_source=partner_consent
https://www.java.com/en/download/
https://www.patreon.com/posts/guide-ptgi-27260900
https://www.sonicether.com/seus/
Minecraft List of all stones
https://game8.co/games/Minecraft/archives/378274
Minecraft log checker
01. java -jar LogChecker.jar
04. 3
05. /home/SERVERNAME/minecraft/logs/
Minecraft log Patern recognition
zgrep -H -E 'Failed to verify username!|lost connection: Internal Exception' *.log *.gz
Minecraft log4J exploid
01. sudo java -jar LogChecker.jar
02. 1 -> Check .minecraft logs
03. 2 -> ~/.minecraft (Linux Default)
04. y -> The above '.minecraft' directory does not appear to exist! Would you like to input a custom '.minecraft' directory? (Currently: ~/.minecraft)
05. /home/<USER_NAME>/minecraft/
Minecraft logs
sudo tail 15 -f /home/craftyjr/minecraft/logs/latest.log
Minecraft making Iron golem
1 -> Carved pumpkin -> On top of middle of T -> +
1 block of space arround
36 Iron ingets -> 4 Iron blocks -> T shape
Minecraft Pinecraft server scrips (Start/Stop/Reboot)
~/minecraft/server
~/minecraft/stop
sudo ~/minecraft/reboot
tail -f ~/minecraft/logs/latest.log
Minecraft remove copper oxidation
When copper is fully Oxidized -> With axe -> Right click (Like stripping wood)
Minecraft seed world map Coords
Amethyst: X= 147 Y= -12 Z= 138
Axolotl Coords: X= 95 Y= 14 Z= 203
Azalea Coords: X= 55 Y= -1 Z= 282
brewing stand x=-209 Z=1194
CAve Big x= 1862 Z= 3062
Cherry Coords: X= -1159 Z= 27
Coral X= -540 Z= -1268
Desert coords: X= -156 Z= -1387
Donkey X=-640 Z= 1497
Dripstone Caves coords: X=14 Z=303
Elizaberry: X= 146 Y= 66 Z= -1564
Flowers X= -2181 Z= -1324
Home coords: X=18 Z=37
Horse coords: X=-929 Z=-139
https://static.wikia.nocookie.net/minecraft_gamepedia/images/7/7b/Minecraft_brewing_en.png/revision/latest/scale-to-width-down/1000?cb=20231102221116
https://www.chunkbase.com/
https://www.chunkbase.com/apps/biome-finder
https://www.chunkbase.com/apps/biome-finder#4647294665657212242
https://www.chunkbase.com/apps/slime-finder#seed=4647294665657212242&platform=java&x=131&z=234&zoom=1.332
https://www.chunkbase.com/apps/village-finder#seed=4647294665657212242&platform=java_1_20&x=931&z=82&zoom=0.238
Jan-Willem Glass dome: X= -485 Y-1472
Jan-Willem: X= -772 Y= 99 Z= -2029
Midwaypoint februari x=31 Z=1697
Mud Hut Cherry Coords: X=-1150 Z=15
Pale Garden X=-575 Z=2723
Pandas? X=2508 Z=3276
Shipwreck X= 2723 Z= 3554
Shipwreck: X= 584 Z= 993
Snowy Plains Coords: X= -2487 Z= -274
Snowy Plains Coords: X= -2526 Z= -28
Swamp: X:3102 Z:3769
Thornfield Hall Coords: X=106 Z= -66
Village closest to home: X -1024 Y 63
Village cooords: X= -1133 Z=181
Village X=645 Z= 1210
Waypoint1 to snowy frogs: X-1009 Z -1343
Minecraft server backup
01. Stopping minecraft server: ~/minecraft/stop
02. Copy mincraft folder to Vance
03. Remove backup world folders:
04. sudo rm -R /home/craftyjr/backup_worlds/world/
05. sudo rm -R /home/craftyjr/backup_worlds/world_nether/
06. sudo rm -R /home/craftyjr/backup_worlds/world_the_end/
07. Backup worlds to backup folder
08. sudo cp -R /home/craftyjr/minecraft/world/ /home/craftyjr/backup_worlds/world/
09. sudo cp -R /home/craftyjr/minecraft/world_nether/ /home/craftyjr/backup_worlds/world_nether/
10. sudo cp -R /home/craftyjr/minecraft/world_the_end/ /home/craftyjr/backup_worlds/world_the_end/
11. sudo chown -R craftyjr /home/craftyjr/backup_worlds/
12. sudo chmod -R 777 /home/craftyjr/backup_worlds/
13. sudo reboot
14. Copy backup_worlds to backup folder on vance
Minecraft server Block unwanted IP adresses
01. sudo cp /home/craftyjr/backup_config/blockingISP/monitor_and_block.sh /home/craftyjr
02. sudo chmod +x /home/craftyjr/monitor_and_block.sh
03. sudo cp /home/craftyjr/backup_config/blockingISP/monitor_and_block.service /etc/systemd/system/
04. sudo systemctl daemon-reload
05. sudo systemctl enable monitor_and_block.service
06. sudo systemctl start monitor_and_block.service
07. sudo systemctl status monitor_and_block.service
08. Optional -> sudo systemctl restart monitor_and_block.service
Minecraft server console
Adding a player to operators (Highest privilage (4)): op PLAYERNAMEGOESHERE
Adding player to whitelist: whitelist add PLAYERNAMEGOESHERE
Get out of server console: Ctrl + a, then press d
Go to server console: screen -r
https://minecraft.fandom.com/wiki/Permission_level
Removing a player from operators (Highest privilage (4)): deop PLAYERNAMEGOESHERE
Removing player to whitelist: whitelist remove PLAYERNAMEGOESHERE
Starting the server: java -Xms4458M -Xmx5379M -XX:+UseG1GC -XX:+ParallelRefProcEnabled -XX:MaxGCPauseMillis=200 -XX:+UnlockExperimentalVMOptions -XX:+DisableExplicitGC -XX:+AlwaysPreTouch -XX:G1NewSizePercent=30 -XX:G1MaxNewSizePercent=40 -XX:G1HeapRegionSize=8M -XX:G1ReservePercent=20 -XX:G1HeapWastePercent=5 -jar minecraft.jar nogui
Minecraft server Raspberry Pi
01. Check if git is installed: sudo apt install git
02. git clone https://github.com/Cat5TV/pinecraft.git
03. cd pinecraft/
04. sudo ./install
05. Choose custom Seed
05. Stopping minecraft server: ~/minecraft/stop
06. seed 4647294665657212242 (Neebs Gaming)
07. Select: Paper
08. Select Survival
https://github.com/Cat5TV/pinecraft
https://papermc.io/downloads/paper
https://www.youtube.com/watch?v=Mz_i15dUqFw
https://www.youtube.com/watch?v=OKfeB3jklqo
PineCraft
Minecraft server Raspberry Pi Port forwarding
01. Mincraft default port: 25565 TCP and UDP
02. sudo ufw status verbose
03. sudo ufw allow 25565
04. sudo ufw enable
05. sudo ufw status verbose
Minecraft Shader browser
https://www.curseforge.com/minecraft/mc-mods/resourcify/files/5841406/changelog
Minecraft Skin editor
https://www.minecraftskins.com/search/skin/titanfall/1/
https://www.minecraftskins.com/skin-editor/
Minecraft Sliding door
https://www.youtube.com/watch?v=1QSVqBLQ-bk
https://www.youtube.com/watch?v=hFMfUPkhHO8
https://www.youtube.com/watch?v=niS_Fpy_2-U
https://www.youtube.com/watch?v=TL7OYOHWaYA
Minecraft Sliding door / flying machine
https://www.google.com/search?q=minecraft+piston+door+designs&client=firefox-b-d&sca_esv=86a88d896bcf14c1&ei=SvBdZ6jeJc6ci-gPwI280Ac&ved=0ahUKEwioq7qekqiKAxVOzgIHHcAGD3oQ4dUDCBA&uact=5&oq=minecraft+piston+door+designs&gs_lp=Egxnd3Mtd2l6LXNlcnAiHW1pbmVjcmFmdCBwaXN0b24gZG9vciBkZXNpZ25zMgUQABiABDILEAAYgAQYhgMYigUyCxAAGIAEGIYDGIoFMgsQABiABBiGAxiKBTIFEAAY7wUyBRAAGO8FMgUQABjvBTIFEAAY7wUyBRAAGO8FSOkSUI0KWPkQcAF4AZABAJgBbqAB4gOqAQM2LjG4AQPIAQD4AQGYAgigAoEEwgIKEAAYsAMY1gQYR8ICDRAAGIAEGLADGEMYigXCAgcQABiABBgNwgIGEAAYBxgewgIGEAAYDRgewgIIEAAYBRgNGB7CAggQABgIGA0YHsICCBAAGIAEGKIEmAMAiAYBkAYKkgcDNy4xoAeXMg&sclient=gws-wiz-serp#fpstate=ive&vld=cid:b05bbd31,vid:1QSVqBLQ-bk,st:0
https://www.youtube.com/watch?v=hjcWk3KrWJc
Minecraft Storingen
https://allestoringen.nl/storing/minecraft/
https://minecraftstatus.net/
https://support.xbox.com/nl-NL/xbox-live-status
Minecraft update Paper server
https://papermc.io/downloads/paper
Minecraft update server
https://papermc.io/downloads/paper
https://www.ionos.com/digitalguide/server/know-how/update-the-minecraft-server-to-the-latest-version/
Minecraft updates Paper Optifine Pinecraft
https://github.com/Cat5TV/pinecraft
https://optifine.net/downloads
https://papermc.io/downloads/paper
Minecraft user stop script setup
01. sudo adduser stopminecraft
03. sudo cp /home/craftyjr/backup_config/stopMinecraftServerScripts/stopminecraft.sh /home/stopminecraft/
03.1 sudo cp /home/craftyjr/backup_config/stopMinecraftServerScripts/restartminecraft.sh /home/stopminecraft/
03.1 sudo cp /home/craftyjr/backup_config/stopMinecraftServerScripts/stopminecraft.sh /home/stopminecraft/ && sudo cp /home/craftyjr/backup_config/stopMinecraftServerScripts/restartminecraft.sh /home/stopminecraft/
05.1 sudo chmod +x /home/stopminecraft/stopminecraft.sh && sudo chmod +x /home/stopminecraft/restartminecraft.sh
06. sudo visudo
07.1 stopminecraft ALL=(ALL) NOPASSWD: /home/craftyjr/backup_config/stopMinecraftServerScripts/stop_backup_update_crafty.sh
07.2 stopminecraft ALL=(ALL) NOPASSWD: /home/craftyjr/backup_config/stopMinecraftServerScripts/stop_backup_update_reboot_crafty.sh
08. sudo visudo -c
09. ./stopminecraft.sh
10. cp /home/craftyjr/backup_config/stopMinecraftServerScripts/stopminecraftserver.sh /home/craftyjr/ && sudo cp /home/craftyjr/backup_config/stopMinecraftServerScripts/shutdownserver.sh /home/craftyjr/
11. sudo chmod +x /home/craftyjr/stopminecraftserver.sh && sudo chmod +x /home/craftyjr/shutdownserver.sh
12. sudo visudo
13. craftyjr ALL=(ALL) NOPASSWD: /home/craftyjr/backup_config/stopMinecraftServerScripts/stop_minecraft_server.sh
14. craftyjr ALL=(ALL) NOPASSWD: /home/craftyjr/backup_config/stopMinecraftServerScripts/shutdown_server.sh
15. sudo visudo -c
Minecraft villagers professions
01. Professions -> Armorer -> 10.38
01. Professions -> Armorer -> Blastfurnace
02. Professions -> Weaponssmith-> 11.03
02. Professions -> Weaponssmith-> Grindstone
03. Professions -> ToolSmith-> 11.25
03. Professions -> ToolSmith-> Smithing Table
04. Professions -> Fletcher-> 11.55
04. Professions -> Fletcher-> Fletching Table
05. Professions -> Cartographer-> 12.23
05. Professions -> Cartographer-> Cartographers Table
06. Professions -> Butcher-> 13.06
06. Professions -> Butcher-> Smoker
07. Professions -> NitWit-> 13.44
08. Professions -> Leather worker-> 14.36
08. Professions -> Leather worker-> Cauldron
09. Professions -> Cleric-> 14.55
09. Professions -> Cleric-> Brewing Stand
10. Professions -> Farmer-> 15.25
10. Professions -> Farmer-> Composter
11. Professions -> Mason -> 16.10
11. Professions -> Mason -> Stonecutter
12. Professions -> Fisherman-> 16.39
12. Professions -> Fisherman-> Barrel
13. Professions -> Librarian-> 17.02
13. Professions -> Librarian-> Lectern
14. Professions -> Shepherd-> 17.41
14. Professions -> Shepherd-> Loom
https://youtube.com/watch?v=HSgYT-t2Iv0&si=9i6DEyWdo27Z6td7
Minecraft: How to Make a Clay Farm
https://www.youtube.com/watch?v=sbWNc_x2veAstion yet.
Mionecraft clock
No solution suggestion yet.
Modellen verliezen eigenschappen voor het opslaan
Zijn alle gegevens mee genomen bij alle saves acties?
MongoDB
No solution suggestion yet.
Mounting network shares
Cifs
https://wiki.ubuntu.com/MountWindowsSharesPermanently
https://www.youtube.com/watch?v=qBPxgVxOvTQ
Mouse lag Cura
01. Marketplace (In standard GUI top right)
02. Installed
03. Look for: USB Printing
04. Uncheck: USB Printing
https://community.ultimaker.com/topic/29332-cura-lagging-on-a-surface-with-bluetooth-mouse/
It's an issue with the module for USB Printing. Try going in to the Marketplace and turning it off.
mRemoteNG
https://mremoteng.org/download
MS DevOps Pipeline variables
01. Go to the projects page
02. For the project of your interest click on the rocket icon (Pipelines)
03. Click in the menu on the left on Releases -> Select the branch you want -> Click Edit
04. Click on Variables
05. This is where the variables can be set for deployment
MS Microsoft 365 Deleted file retrieval
01. Free undelete on local folder
https://support.microsoft.com/en-us/office/find-lost-or-missing-files-in-onedrive-0d929e0d-8682-4295-982b-4bd75a3daa01?ui=en-us&rs=en-us&ad=us
https://support.microsoft.com/en-us/office/restore-items-in-the-recycle-bin-that-were-deleted-from-sharepoint-or-teams-6df466b6-55f2-4898-8d6e-c0dff851a0be
https://www.easeus.com/data-recovery/free-undelete-tool-program.html
https://www.officerecovery.com/freeundelete/
MS Microsoft 365 restrict Sharepoint folder share
https://businesstechplanet.com/how-to-restrict-access-to-a-specific-folder-in-sharepoint/
MS Microsoft 365 Sharepoint folder share
No solution suggestion yet.
MS Microsoft Office 365 plans
https://www.microsoft.com/en-us/microsoft-365/business?=&ef_id=EAIaIQobChMIy-OUh5-w-wIVgcx3Ch2lkQqyEAAYASAAEgJmtfD_BwE%3AG%3As&ocid=AIDcmmwf9kwzdj_SEM_EAIaIQobChMIy-OUh5-w-wIVgcx3Ch2lkQqyEAAYASAAEgJmtfD_BwE%3AG%3As&lnkd=Google_O365SMB_Brand&gclid=EAIaIQobChMIy-OUh5-w-wIVgcx3Ch2lkQqyEAAYASAAEgJmtfD_BwE
MS365 Outlook disable automaticly mark email read
https://www.extendoffice.com/documents/outlook/4604-outlook-stop-auto-read.html
Multi Factor Authenticatie
No solution suggestion yet.
MVC
No solution suggestion yet.
MySQL
No solution suggestion yet.
Name issues
https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/
Namespaces
No solution suggestion yet.
Network sharing Octoprint
https://www.sublimelayers.com/2016/12/file-sharing-with-octoprint.html?m=1
Notepad++ Download
https://notepad-plus-plus.org/downloads/
Notepad++ plugins
Notepad++ Compare Plugin (Compares two files)
Notepad++ VisualStudio line copy (Copy behaviour same as in Visual Studio)
Notepad++ Remove duplicate lines
Edit -> LineOperations -> Remove duplicate lines
https://www.google.com/search?client=firefox-b-d&q=notepad%2B%2B+remove+doubles#kpvalbx=_Ry2jYvS_G4G7sAeah6GgDw15
Octoprint remote gcode folder
https://nathanaelgandhi.wordpress.com/2020/03/30/how-to-sync-3d-prints-from-cloud-storage-drive-onedrive-dropbox-etc-to-octoprint/
OneDrive
No solution suggestion yet.
Opzetten van asp.net web apps op Ubuntu in combinatie met Apache
1. Create folder on server
2. Create samba share
3. Copy programm files to share
4. Create systemctl service
5. configure apache virtual server
https://ollie10.medium.com/how-to-host-an-asp-net-core-3-1-application-on-linux-ubuntu-20-04-with-apache-as-reverse-proxy-34bf2fb18502
https://www.youtube.com/watch?v=mBhT_MRwGYE
Oracle Compare query resultset result set
WITH query1 AS ( ), query2 AS ( ) -- Find keys in query1 but not in query2 SELECT KEY FROM query1 MINUS SELECT KEY FROM query2 UNION ALL -- Find keys in query2 but not in query1 SELECT KEY FROM query2 MINUS SELECT KEY FROM query1;
Oracle dotconnect DevArt Incompatible version found in Global Assembly Cache
01. Remove DevArt folders in: C:\Windows\assembly\GAC_MSIL\
https://forums.devart.com/viewtopic.php?t=34423
Oracle error
http://ora-00001.ora-code.com/
http://ora-NumberGoesHere.ora-code.com/
Oracle NVL function
0.0 NVL = Null coallesse
01. NVL(a1, a2)
02. A NVL() function accepts two arguments.
03. If a1 is not-null, returns a1.
04. If a1 is null, then it returns a2.
https://www.oracletutorial.com/oracle-comparison-functions/oracle-nvl/
Oracle random
DBMS RANDOM
ORACLE SQL COALESCE
https://www.simplilearn.com/tutorials/sql-tutorial/coalesce-in-sql
Oracle SQL Count
SELECT department_id, COUNT(*) FROM employees GROUP BY department_id;
SELECT COUNT(*) FROM employees WHERE department_id = 6;
SELECT COUNT(*) FROM employees;
Oracle SQL Developer Comment / Un comment
CTRL /
Oracle SQL Developer Excel export
https://hevodata.com/learn/oracle-sql-developer-export-to-excel-csv/
Oracle SQL Order By
ORDER BY <property> ASC;
ORDER BY <property> DESC;
Oracle SQL Query screen
01. Workscreen
02. (in the row with save buton) Green button with SQL
03. Select connection (CHose the DB you want)
04. write the query ans end it with ;
05. Click run or press F5
Oracle SQL Show properties and count
00. 2 properties
01. SELECT Column1, Column2, COUNT(Column2) AS Count
02. FROM table1
03. GROUP BY Column1, Column2;
04. Optional: ORDER BY Count DESC;
05. Optional: ORDER BY Count ASC;
06.
07. 1 property
08. SELECT Column1, COUNT(Column2) AS Count
09. FROM table1
10. GROUP BY Column1;
Oracle SQL Update values
No solution suggestion yet.
Oracle SQLDeveloper Warning - could not install some modules
01. Go in C:\users**UserName**\AppData\Roaming : delete SQL Developer and sqldeveloper folders
https://stackoverflow.com/questions/36790835/oracle-sql-developer-error-could-not-install-some-modules
Oracle VirtualBox Folder sharing
01. Download Oracle Virtualbox & ExtensionPack (Extension pack download after clicking the (All supported platforms) link
02. Install Virtual box
03. Select the folder where you want the Visrtual machine to live (C: is not recomended)
04. Setup a device with mounting a ISO to the disk drive
05. Install the extension pack
06. !! Start up the virtual machine !!
07. In the top menu go to Device -> Insert Guest Additions CD Image
08. Install the Prompted software
09. In the "Oracle VM VirtualBox Manager" Select the machine and go to -> Settings -> Shared Folders
10. Add new folder (Folder icon with + symbol)
11. Folderpath -> Other => Origin folder on host machine
12. Mount point = Keep empty
13. Read only = Keep empty
14. Auto-mount = Check
15. Make permanent = Check
16. Click Ok
17. Click Ok
18. Go to Virtual machine and check the file explorer => OS Windows? (Folder can be found inside Computer )
https://forums.virtualbox.org/viewtopic.php?t=97073
https://www.virtualbox.org/wiki/Downloads
Organisatie en Mensen
No solution suggestion yet.
OSI Model
https://www.guru99.com/layers-of-osi-model.html
Outlook diable email read when clicked
01. Go to the Inbox folder in Outlook
02. Click the View tab on the ribbon.
03. Click the Layout tab on the ribbon.
04. Click the Reading pane and click "Options"
05. Deselect Mark items as read when selection changes
https://www.extendoffice.com/documents/outlook/4604-outlook-stop-auto-read.html
Outlook disable Focused view
01. Go to the Inbox folder in Outlook
02. Click the View tab on the ribbon.
03. Select “show Focused Inbox” to turn it on or off.
Outlook Export calendar
01. Log into outlook web
02. Settings icon (in the top right corner)
03. Options (in the dropdown)
04. Make sure the drop down menu under "calendar" is opened.
05. Publish calendar.
06. Select the calendar you want to export.
07. Decide how much calendar info you want to download.
08. Select "Create."
09. Out of the options HTML or ICS Select -> ICS
https://answers.microsoft.com/en-us/outlook_com/forum/all/how-do-i-export-my-new-outlookcom-calendar/5be53f7e-114f-48bb-a5c6-3988b3b527c9
https://www.outlook.com
Outlook Import calendar
01. Make sure you have a ICS file exported
02. In Outlook goto "Calendar"
03. File
04. Open & Export
05. Open Calendar
Outlook Out of office
01. File
02. Automatic replies
Outlook signature
01. File > Options > Mail > Signatures.
02. Edit signature
03. Save > OK.
Outlook turn Focussed inbox of
View -> Show Focused Inbox
Outlook Web App
No solution suggestion yet.
Package management
1. sudo apt-get remove "packagename"
1. will remove the binaries, but not the configuration or data files of the package packagename. It will also leave dependencies installed with it on installation time untouched.
2. sudo apt-get purge "packagename"
2. sudo apt-get remove --purge "packagename"
2. will remove about everything regarding the package packagename, but not the dependencies installed with it on installation. Both commands are equivalent. Particularly useful when you want to 'start all over' with an application because you messed up the configuration. However, it does not remove configuration or data files residing in users home directories, usually in hidden folders there. There is no easy way to get those removed as well.
3. removes orphaned packages, i.e. installed packages that used to be installed as an dependency, but aren't any longer. Use this after removing a package which had installed dependencies you're no longer interested in.
3. sudo apt-get autoremove
4. List all installed packages: apt list --installed
5. install Packages: sudo apt-get install "Package name"
https://askubuntu.com/questions/187888/what-is-the-correct-way-to-completely-remove-an-application
Paint.net Download
https://github.com/paintdotnet/release/releases/
https://www.dotpdn.com/downloads/pdn.html
Paint.net Drawing arrows
01. in the left menu select the line and s icon
02. above in style select the arrow
Palindrome
No solution suggestion yet.
Parameters
No solution suggestion yet.
Partners en suppliers
No solution suggestion yet.
Password secure PDF
01. Download and install LibreOffice
02. Open your PDF with -> LibreOffice Draw
03. Go to: File -> Export as PDF
04. Go to Tab: Security -> Set Passwords
05. Set the passwords you want
06. Click: Ok -> Export
07. Select your folder and file name and Click -> Save
https://nl.libreoffice.org/download/libreoffice-nieuwste-versie/
https://www.youtube.com/watch?v=jqlgRm_Aayo
Pinecraft Minecraft server update
01. cd ~/pinecraft
02. git pull
03. sudo ./install
04. keep world
Plan de applicatie van te voren
No solution suggestion yet.
Pointers to become e better developer
01. Try to understand the point of view of the end user
02. Keep looking for edgecases to test
Port listening
sudo netstat -tulpn
sudo netstat -tulpn | grep :80
Port management
List all used ports : ss -townlup
ufw allow "Apache Full"
What listens at a specific port: sudo ss -tulpn | grep :"port number"
Portable Adobe reader
https://www.adobereader9.net/portable-adobe-reader/
Portable software
https://portableapps.com/
Portfolio webhosting security testing
http://www.internet.nl
https://www.forumstandaardisatie.nl/open-standaarden/verplicht
Power Shell
No solution suggestion yet.
PowerPoint Web App
No solution suggestion yet.
PR Checklist
https://gist.githubusercontent.com/sherakama/0ba17601381e3adbe0cad566ad4d80a5/raw/be88e9c03ca606024ec9491a687ebde327afe52b/pr-checklist.md
Pre/Post Scripts
No solution suggestion yet.
Preformance evaluation
No solution suggestion yet.
Prime numbers
No solution suggestion yet.
Principen van cloud computing
No solution suggestion yet.
Private Cloud
No solution suggestion yet.
Productivity
No solution suggestion yet.
Project Comparison
No solution suggestion yet.
Project Creation
No solution suggestion yet.
Propperties
No solution suggestion yet.
Proxying naar .Net Core applicaties
https://ollie10.medium.com/how-to-host-an-asp-net-core-3-1-application-on-linux-ubuntu-20-04-with-apache-as-reverse-proxy-34bf2fb18502
Public Cloud
No solution suggestion yet.
Publishing web apps
No solution suggestion yet.
Putty Downloaden
https://www.putty.org/
Radio stick Getting it to work
https://airspy.com/download/
https://www.haje.nl/pub/pdf/communicatie/sdr1_ontvangst/installatie-rtl-sdr-windows-linux.pdf
Randon slide transition
01. Select all slides
02. Transitions tab
03. Look for random
04. Set duration to 0.5
05. Set After to 10 / 5 seconds
Raspberry Activity led op GPIO pin
https://www.richinfante.com/2021/08/11/raspberry-pi-gpio-status-lights
Raspberry Autostart chromium browser
https://raspberrypi.stackexchange.com/questions/101733/raspberry-pi-4-autostart-chromium
Raspberry GPIO
https://i0.wp.com/randomnerdtutorials.com/wp-content/uploads/2023/03/Raspberry-Pi-Pinout-Random-Nerd-Tutorials.png?quality=100&strip=all&ssl=1
Raspberry imager Advanced options
Advanced options: CTRL + SHIFT + X
https://downloads.raspberrypi.org/imager/imager_latest.exe
Raspberry install OS SD
https://www.raspberrypi.com/software/
Raspberry internet radio via terminal
https://askubuntu.com/questions/193737/how-to-listen-radio-from-terminal
https://opensource.com/article/18/12/linux-toy-mplayer
https://www.youtube.com/watch?v=N5-eEdbvEaY
Raspberry Ubuntu 20.04 eth0 not enabled
sudo dhclient -v
Razor component details
https://docs.microsoft.com/en-us/aspnet/core/blazor/components/?view=aspnetcore-7.0#overwritten-parameters-1
Razor Pages
No solution suggestion yet.
Razor Pages
No solution suggestion yet.
Refactoring
No solution suggestion yet.
Remote access
https://bitlaunch.io/blog/how-to-install-and-configure-vnc-viewer-on-ubuntu-20-04/
https://serverspace.io/support/help/install-tightvnc-server-on-ubuntu-20-04/
https://www.cyberciti.biz/faq/ubuntu-linux-install-openssh-server/
https://www.ubuntu18.com/ubuntu-change-ssh-port/
Remove Files and Directories
https://linuxize.com/post/how-to-remove-files-and-directories-using-linux-command-line/
Removing packages
https://askubuntu.com/questions/187888/what-is-the-correct-way-to-completely-remove-an-application
Renamed properties
01. Run unit tests
02. Check the use of the properties for external use
Rendering best practices
https://learn.microsoft.com/en-us/aspnet/core/blazor/performance?view=aspnetcore-7.0
Request new Ip address from DCHP server for Ubuntu
sudo dhclient eth0
Reusability
No solution suggestion yet.
Role based acces control
No solution suggestion yet.
Rules
No solution suggestion yet.
Rules management
No solution suggestion yet.
Safely erase files Eraser
https://eraser.heidi.ie/download/
https://sourceforge.net/projects/eraser/files/Eraser%206/6.2/Eraser%206.2.0.2982_with_runtimes.exe/download
Samba
sudo service smbd restart
sudo service smbd start
sudo service smbd status
sudo service smbd stop
Samba folder sharing
1. Open config file: sudo nano /etc/samba/smb.conf
2. In the end of the document add share as show on the page link and save the file
3. Restart samba service: sudo service smbd restart
4. Allow samba true firewall: sudo ufw allow samba
https://ubuntu.com/tutorials/install-and-configure-samba#3-setting-up-samba
Samba shares locked
01. Attempt 1
01.1 sudo chown root:sambashare /var/lib/samba/usershares/mcgee
01.2 sudo chmod 770 /var/lib/samba/usershares/mcgee
02. Original
02.1 sudo chown bosviool:bosviool /var/lib/samba/usershares/mcgee
02.2 sudo chmod 744 /var/lib/samba/usershares/mcgee
SASS & SCSS Using variables in variables
01. code in variables file:$font-comic-sans: 'Comic Sans MS'; $font-seg-ui: 'Segoe UI'; // Application font $basic-font: $font-comic-sans;
02. code in class: .test-class { font-weight: 100; font-family: $basic-font; font-size: xx-large; background-color: yellow; }
03. Make sure you declare the variables first
04. Switching between fonts can now be done with the value of variable: $basic-font
SASS & SCSS Variables
01. Get SCSS & SASS working, look for: Add SASS & SCSS
02. In wwwroot -> scss folder add folder: partials
03. In wwwroot -> scss -> partials folder add -> new item: _partials.scss
04. In wwwroot -> scss -> partials folder add -> new item: _variables.scss
05. In wwwroot -> scss -> partials -> _partials.scss the code is: @import "_variables.scss";
06. In wwwroot -> scss -> partials -> _variables the code is: $primary-color: yellow;
07. In wwwroot -> scss -> _main-layout.scss the test class now is: .test-class { font-weight: 100; font-family: 'Comic Sans MS'; font-size: xx-large; background-color: $primary-color; }
08. In wwwroot -> scss -> main.scss the new code is: @import "partials/_partials.scss"; @import "layout/main-layout.scss";
09. The variables should be declared before use (Undeclared variable: is the order of imports right?)
Scoped
Creates a new instance one per request
Creates one instance per scope
Cut down on overhead without sharing data
Example: request to server is scope
Screen grab / capture software
https://getgreenshot.org/
https://picpick.app/en/download/portable/
Screen grab software (Green shot)
https://getgreenshot.org/downloads/
Screen recording (PicPick)
https://picpick.app/en/download/
SCSS crash course
https://blog.logrocket.com/the-definitive-guide-to-scss/
scss mixins
https://glennmccomb.com/articles/useful-sass-scss-media-query-mixins-for-bootstrap/
Search for data
No solution suggestion yet.
Security, Privacy, Compliance en Vertrouwen
No solution suggestion yet.
Send logging to GUI
Create live connection with API via signalR?
Server aliases
ServerAlias mail.example.com files.example.com r.example.com
Server data tools
No solution suggestion yet.
Service en Value
No solution suggestion yet.
Service management
https://phoenixnap.com/kb/start-stop-restart-linux-services
Service typen als IaaS, PaaS, SaaS
No solution suggestion yet.
Service Value Chain
No solution suggestion yet.
Service Value System
No solution suggestion yet.
Shaderpacks
https://shaderlabs.org/wiki/Shaderpacks
Share point
No solution suggestion yet.
SharePoint map delen
01. https://login.microsoftonline.com/
02. On the left click : Admin
03. On the left Click: Show all
04. On the left: Admin centers: SharePoint
05. On the left: Active sites
Sharepoint map in explorer (Verkenner) toevoegen
https://www.techreader.co.uk/how-to-add-sharepoint-team-sites-to-file-explorer-in-windows-11/
Sharing personal data
01. Put the data in 1Password
02. Share the link with the person requesting the info
Show MySQL users
https://alvinalexander.com/blog/post/mysql/show-users-i-ve-created-in-mysql-database/
SELECT host, user FROM mysql.user;
Shutdown command
https://stackoverflow.com/questions/34039845/how-to-shutdown-a-computer-using-python
Singleton
Can share information between users
Can use it for configuration
Creates one instance as long as the application is running
Not releasing memory during the life off application
Socket set holders
https://www.thingiverse.com/thing:3770669
Solutions page: display project name
No runway suggestion yet.
Solutions page: Show Challenge or Addition in table
No runway suggestion yet.
Solutions page: Update button for solution that redirects to edit page
No runway suggestion yet.
Source control
No solution suggestion yet.
SQL account security
Add seperate role for stored procedures
Remove/Rename sa account it is well known
SQL alter column
ALTER TABLE table_name ALTER COLUMN column_name DATA_TYPE [(COLUMN_SIZE)] NOT NULL;
SQL auto growth
Enable autogrowth unless good argument
If you expect a database to become a size make it that size
SQL Combine fields / Custom field
SELECT t.Column + ' ' + t.Column AS 'CompleteColumn'
SQL comments
If combination is used with DELETE statement, put DELETE in comments, it wil not execute by accident
Row: --
Section: /* */
SQL Copy data
01. Create a SELECT query that fits your needs (Be aware of the Id)
02. Create a INSERT INTO statement
03. Combine the two statements and use the SELECT as the arguments for the values
INSERT INTO "TableName" ("Column Names") SELECT "New Id", ColumnNames WHERE Id = "Old Id";
SQL data base files
No solution suggestion yet.
SQL data files
Data file SQL server = *.MDF
Log file SQL server = *.LDF
SQL Database data type to model conversion
https://stackoverflow.com/questions/1440620/which-sql-server-data-type-best-represents-a-double-in-c
SQL Database gebruiken voor opslag
No solution suggestion yet.
SQL Database gebruiken voor opslag
No runway suggestion yet.
SQL Delete row
DELETE FROM table_name WHERE condition;
SQL Developer Finding tables / views
01. Use a filter in the desired category
02. Start en end the filter with %
03. Example: %YourTableName%
SQL developer run selected
CTRL + Enter
SQL DISTINCT
Groups all data in to unique groups
SELECT DISTINCT ColumnName FROM TableName;
SQL Insert data
INSERT INTO "TableName" (Column Name, Etc) VALUES ('String Value, 'Etc', 123'), ('String Value, 'Etc', 123');
INSERT INTO "TableName" (Column Name, Etc) VALUES ('String Value, 'Etc', 123');
SQL joins
INNER JOIN table_name 2 ON 1.column = 2.column (Only shows the records that match)
LEFT JOIN table_name 2 ON 1.column = 2.column (Shows all records from the left table, and the matching from the right)
RIGHT JOIN table_name 2 ON 1.column = 2.column (Shows all records from the right table and the matching from the left)
SQL Laat verschillende invullingen zien
SELECT DISTINCT TableName FROM DatabaseName
SQL Order by
default is Ascending
Order by is last
ORDER BY T.Column DESC / ASC
SQL partial words search / Wildcard characters
https://stackoverflow.com/questions/14290857/sql-select-where-field-contains-words
See wilcards
SELECT * FROM mytable WHERE column1 LIKE '%word1%'
SQL Query creation/evolution
Use notepad to save the steps
SQL Server
No solution suggestion yet.
SQL Update statement
01. Make the where conditions maximum verbose!
02. Check the where conditions with a SELECT first
03. SELECT * FROM table_name WHERE condition
04. UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
https://www.w3schools.com/sql/sql_update.asp
SQL view analisys visualisation
https://sqlflow.gudusoft.com/#/
SQL Where clouse
WHERE (t.Column = 'ExactMatch') OR (t.Column = 'ExactMatch')
WHERE t.Column = 'ExactMatch'
WHERE t.Column = 'ExactMatch' AND t.Column = 'ExactMatch'
WHERE t.Column LIKE '%Contains%'
SQL wildcards
% = * (0 or more characters)
Use Like instead of = in where clouse
SQLite
No solution suggestion yet.
SSH key maken
https://jdblischak.github.io/2014-09-18-chicago/novice/git/05-sshkeys.html
SSH port veranderen
https://linuxconfig.org/how-to-change-ssh-port-on-linux
SSH toelaten door firewall
No solution suggestion yet.
Standaard naam van de persoon uit appsettings
No runway suggestion yet.
Standaard naam van de persoon uit appsettings
No solution suggestion yet.
Start Qbittorent on boot
01. Go to Linux start menu
02. Type: Session
03. Click: Startup applications -> Add
04. Name: qBittorent
05. Command: qbittorrent %U
06. Delay: 0
07. Save
08. Reboot
09. sudo reboot
Starten met GitHub
https://www.youtube.com/watch?v=iv8rSLsi1xo
Starten met Visual Studio
No solution suggestion yet.
Starting with Syncfusion
https://www.syncfusion.com/succinctly-free-ebooks/asp-net-core-3-1-succinctly/asp-net-core-basics
Static classes
No solution suggestion yet.
Static Classes
No solution suggestion yet.
Step down converter
https://www.benselectronics.nl/xl4015-dc-dc-step-down-converter-voltmeter.html?source=googlebase
https://www.google.com/search?client=ms-android-motorola-rev2&sca_esv=558593241&q=step+down+converter+24v+12v&tbm=shop&source=lnms&sa=X&ved=2ahUKEwjl286k9euAAxWB76QKHdp5ARAQ0pQJegQICxAB&biw=360&bih=592&dpr=3
https://www.google.com/shopping/product/1?q=step+down+converter+24v+12v&client=ms-android-motorola-rev2&sca_esv=558593241&biw=360&bih=592&tbs=vw:l&prds=num:1,of:1,eto:16714832830420030607_0,prmr:1,cs:1
Stop terminal command
CTRL + C
String replacement
No solution suggestion yet.
Subnetting
No solution suggestion yet.
succes percentage calculation
01. count of calls is 100%
02. count of success
03. calculate succes percentage
04. send succes percentage to GUI
Sudoers
https://devconnected.com/how-to-add-user-to-sudoers-on-ubuntu-20-04/#Adding_a_group_to_the_sudoers_file
Syncfusion Data Grid
https://www.youtube.com/watch?v=ClAlwPUv0_s&t=61s
Syncfusion Blazor Date range picker output text change
01. Add event on date change
01.5. <DateRangePickerEvents TValue="Data type"?" ValueChange="ValueChangeHandler">
02. Create event handler method
02.5. public void ValueChangeHandler(RangePickerEventArgs<"Data type"?> args) { string periodString = args.Text; periodString = periodString.Replace("-", "t/m"); args.Text = periodString; }
Syncfusion Blazor demo's
https://blazor.syncfusion.com/demos/
Syncfusion Comboboxes internal collection count
01. await comboboxObj.FilterAsync(collection, CreateFilterQuery(args.Text));
02. object results = await comboboxObj.DataManager.ExecuteQueryAsync<DataModel>(CreateFilterQuery(args.Text));
03. int totalResults = (results as IEnumerable<object>).Cast<object>().ToList().Count;
Syncfusion Comboboxes internal filtering
01. private Query CreateFilterQuery(string filter)
02. {
03. var orWhere = WhereFilter.Or(new List<WhereFilter> {
04. new WhereFilter() { Field = nameof(DataModel.Property), Operator = "contains", value = filter, IgnoreCase = true }
05. predicate.Add(new WhereFilter() { Condition = "or", Field = nameof(DataModel.Property), value = args.Text, Operator = "contains", IgnoreAccent = true, IgnoreCase = true });
06. Query query = new Query().Where(orWhere);
07. });
08. query = !string.IsNullOrEmpty(filter) ? query : new Query();
09. return query;
10. }
Syncfusion Data Grid AllowSorting=true
Dan kan je op de naam klikken en dan krijg je en pijltje hoe er is gesorteerd
Syncfusion Data Grid Documentation
https://blazor.syncfusion.com/documentation/datagrid/getting-started
Syncfusion NuGet datagrid
Syncfusion.Blazor
ts 3.59
Syncfusion Value
ComboBox Value = Name to show
Sysctl commands
https://access.redhat.com/sites/default/files/attachments/12052018_systemd_6.pdf
Systeem cloning
No solution suggestion yet.
Systeem migratie
No solution suggestion yet.
systemctl
sudo systemctl --type=service
sudo systemctl daemon-reload
sudo systemctl enable "ServiceName.service"
sudo systemctl start "ServiceName.service"
sudo systemctl status "ServiceName.service"
Systemctl
https://access.redhat.com/sites/default/files/attachments/12052018_systemd_6.pdf
systemctl read log
sudo journalctl -f --unit=kestrel-"your-service-here".service
Task cheduler
https://www.hangfire.io/
Teams
No solution suggestion yet.
Testing stories
01. Test stories before pushing (FireFox)
02. merge branches
03. Test again (Edge)
04. Go to test site (Chrome)
05. Switch back to main branch
Testing styling stylus FireFox addon
https://addons.mozilla.org/en-US/firefox/addon/styl-us/
Text files
No solution suggestion yet.
TimeZone
http://manpages.ubuntu.com/manpages/bionic/man3/DateTime::TimeZone::Catalog.3pm.html
https://vworld.nl/?p=4524
https://www.atlantic.net/vps-hosting/how-to-set-up-time-synchronization-with-ntp-on-ubuntu-18-04/
Tiny10
https://archive.org/details/tiny-10-23-h2
ToDo API
No solution suggestion yet.
ToDo app in Razor pages
No solution suggestion yet.
ToDo Console
No solution suggestion yet.
ToDo List
Extension -> ToDo+
ToDo Win Forms
No solution suggestion yet.
Todo WPF
No solution suggestion yet.
Toevoegen en modificeren HTML elementen
No solution suggestion yet.
Totaal eigen front end bouwen
http://www.getbootstrap.com
Transient
Creates a new instance every time
Does not share info between users
Releases memory when done
Translate CSS to HTML
background-color -> backgroundColor
text-align -> textAlign
textAlign and max-height -> maxHeight
Truck rental
No solution suggestion yet.
Ubunbtu 20.04 Get available WLans
nmcli -f ALL dev wifi
nmcli dev wifi
Ubuntu 20.04 Certbot SSL Certificate
https://github.security.telekom.com/2020/05/smuggling-http-headers-through-reverse-proxies.html
https://letsencrypt.org/docs/staging-environment/
https://www.digitalocean.com/community/tutorials/how-to-secure-apache-with-let-s-encrypt-on-ubuntu-20-04
Ubuntu 20.04 Failed to start OpenBSD Secure Shell server error after install
01. sudo ssh-keygen -A
02. sudo reboot
https://askubuntu.com/questions/1113607/failed-to-start-openbsd-secure-shell-server-error-when-i-try-to-run-apt-get-or-t
Ubuntu 20.04 LTS SHow lan adapters
iwconfig
Ubuntu 20.04 Show system stats
htop
Ubuntu 22.04 Certbot SSL Certificate
https://www.digitalocean.com/community/tutorials/how-to-secure-apache-with-let-s-encrypt-on-ubuntu-22-04
Ubuntu 24.04 SSH
01. sudo systemctl status ssh (service disabled)
02. sudo systemctl enable ssh.service
03. sudo systemctl status ssh (service enabled active running)
Ubuntu add CI/CD SSH user
01. sudo adduser deployuser
02. sudo usermod -aG sudo deployuser
03. su - deployuser
04. mkdir ~/.ssh
05. chmod 700 ~/.ssh
06. touch ~/.ssh/authorized_keys
07. chmod 600 ~/.ssh/authorized_keys
08. nano ~/.ssh/authorized_keys
Ubuntu change boot partition size
01. Backup boot partition: sudo dd if=/dev/mmcblk0p4 of=~/boot_partition_backup.img
02. sudo parted /dev/mmcblk0
03. (parted) rm 4
04. (parted) print free
05. (parted) resizepart 5 14.5GB
06. (parted) print free
07. (parted) mkpart primary 14.5GB 15.6GB
08. (parted) print free
09. (parted) set 4 boot on
10. (parted) print free
11. (parted) quit
12. sudo dd if=~/boot_partition_backup.img of=/dev/mmcblk0p4
13. sudo file -s /dev/mmcblk0p4
14. sudo reboot
Ubuntu check logs with live update
sudo tail -f /Path/To/File.yay
Ubuntu Ckeck ISP address
curl -s https://icanhazip.com
Ubuntu desktop VNC Password
No solution suggestion yet.
Ubuntu enable automatic unattended update
01. sudo apt update
02. sudo apt install unattended-upgrades
03. sudo dpkg-reconfigure unattended-upgrades
04. sudo nano /etc/apt/apt.conf.d/50unattended-upgrades
04.1 //Unattended-Upgrade::Automatic-Reboot "true";
04.2 //Unattended-Upgrade::Remove-Unused-Dependencies "true";
04.3 //Unattended-Upgrade::InstallOnShutdown "true";
05. sudo systemctl enable --now unattended-upgrades
06. sudo systemctl status unattended-upgrades
07. less /var/log/unattended-upgrades/unattended-upgrades.log
Ubuntu FTP server
01. Install vsftpd
02. sudo apt-get install vsftpd
03. Copy original config file:
04. sudo cp /etc/vsftpd.conf /etc/vsftpd.conf.original
05. Check UFW status
06. sudo ufw status
07. Allow FTP trafic
08. ufw allow ftp
09. Add the user for the FTP connection
10. sudo adduser hostinger
11. Change the users folder permissions
12. sudo chmod *** /foldername
13. Configure VSFTPD
14. sudo nano /etc/vsftpd.conf
15. Remove # (uncomment) to enable the following options:
16. anon_upload_enable=YES
16. chroot_local_user=YES
17. To enable future users to have access add this line at the bottom of the config file
18. user_sub_token=$USER local_root=/home/$USER/ftp
19. Restart VSFTPD
20. sudo systemctl restart vsftpd
https://www.digitalocean.com/community/tutorials/how-to-setup-a-firewall-with-ufw-on-an-ubuntu-and-debian-cloud-server
https://www.hostinger.com/tutorials/how-to-setup-ftp-server-on-ubuntu-vps/#Step_3_%E2%80%93_Creating_the_User_Directory
Ubuntu Raspberry pi standard welcome screen
01. sudo apt install landscape-common -y
02. sudo nano /etc/update-motd.d/10-sysinfo
Ubuntu read log files
-f -> Keep monitoring live
tail -f [filename]
Ubuntu release upgrade
01. sudo apt update && sudo apt upgrade -y
02. sudo apt autoremove -y
03. sudo apt install update-manager-core -y
04. sudo do-release-upgrade
05. Do release upgrade with as few user interactions as possible: sudo do-release-upgrade -f DistUpgradeViewNonInteractive
Ubuntu UFW block ip
01. Check status UFW: sudo systemctl status ufw
02. Check current status: sudo ufw status
03. Block ip: sudo ufw deny from xxx.xxx.xxx.xxx to any
04. Check current status: sudo ufw status
05. Check the IpTables: sudo iptables -L
06. When result copied to NotePad result ~Line 154 -> Chain ufw-user-input (1 references)
07. --- Extra messures -- If the issue persists Add to iptables --- Extra messures --
08. sudo iptables -A INPUT -s ***.***.***.*** -j DROP
09. To Check the result: sudo iptables -L
10. 06. When result copied to NotePad result ~Line 10 -> Chain INPUT (policy DROP)
11. Save changes to be persistent after reboot:
12. install -> iptables-persistent
13. sudo apt-get install iptables-persistent
14. Save Iptables
15. sudo netfilter-persistent save
16. If folder does not exsist: sudo mkdir -p /etc/iptables
Ubuntu UFW logs
01. Check if logging is on: sudo ufw status verbose
02. If logging is of: sudo ufw logging on
03. Check the logs live: sudo tail 15 -f /var/log/ufw.log
Ubutu distribution / version update
https://itsfoss.com/upgrade-ubuntu-version/
UFW
01. Block before allow: sudo ufw default deny incoming
02. Server can outside connections: sudo ufw default allow outgoing
sudo ufw allow "Apache Full"
sudo ufw allow <service name>
sudo ufw deny <service name>
sudo ufw deny ssh
sudo ufw enable
sudo ufw status
To allow putty: sudo ufw allow ssh
To allow samba folder share: sudo ufw allow samba
Unexpected merge conflicts
01. Go to the branch with issues
02. git reset --hard HEAD
Uninstall Apache server
1. sudo service apache2 stop
2. sudo apt-get purge apache2 apache2-utils apache2.2-bin apache2-common
3. sudo apt-get --purge remove apache2
4. Result: apache2: /etc/apache2
4. whereis apache2
5. sudo rm -rf /etc/apache2
https://www.edureka.co/community/46181/how-to-uninstall-apache2-on-ubuntu
Uninstall MySQL
1. sudo apt purge mysql-server*
2. ls /etc/mysql
3. sudo ls /var/lib/mysql
4. sudo rm -r /etc/mysql/ /var/lib/mysql
5. sudo rm -r /var/log/mysql
6. sudo apt autoremove
7. MySQL is removed now
https://www.digitalocean.com/community/tutorials/how-to-connect-to-a-mysql-server-remotely-with-mysql-workbench
https://www.linuxshelltips.com/completely-uninstall-mysql-server-in-ubuntu/
Uninstall Samba
sudo apt-get autoremove --purge samba -y
Unit testing
No solution suggestion yet.
Unmounting Network Shares
sudo umount -l /mnt/your-folder-name/
Up to date houden
https://www.cyberciti.biz/faq/upgrade-update-ubuntu-using-terminal/
sudo apt update && sudo apt upgrade -y
Update and upgrade Ubuntu
sudo apt update && sudo apt upgrade -y
sudo apt-get autoclean
sudo apt-get autoremove --purge
sudo apt-get clean
Upgrade Ubuntu to 22.04 LTS
https://jumpcloud.com/blog/how-to-upgrade-ubuntu-20-04-to-ubuntu-22-04
Uren rapportage pagina
Zie uren verklaring portfolio
Uren rapportage pagina
No runway suggestion yet.
Urinoir afvoer concept onderdelen
https://doemarkt.be/doe-het-zelf/pvc-riolering-afvoer/pvc-sanitair/pvc-ivoorwit-verloop-50m-40f
https://doemarkt.be/doe-het-zelf/pvc-riolering-afvoer/pvc-sanitair/pvc-ivoorwit-verloopmof-50f-40m
https://www.deboerdrachten.nl/bst0110715-mega-verloopsok-pvc-u-6350-mm-x-40-mm-lijmspielijmmof-x-lijmmof-16bar-grijs/3?srsltid=AfmBOopLXJ4rMBmMnzYbBI3-wXDXCQgZ17VMKQMbZ8TQr8OUckLH1lrlcjo
https://www.warmteservice.nl/Installatiemateriaal/Waterafvoermateriaal/PP-Hulpstukken/PP-T-stuk-2-x-mof-spie-45-manchet-wit-50/p/57402690?gclsrc=aw.ds&gclid=EAIaIQobChMI5rTQvbuRggMV4opoCR0tSwntEAQYAiABEgJ_Q_D_BwE
Urinoir afvoer definitief onderdelen
https://www.installerendoejezelf.nl/sanitair/wastafels/viega-sifon-afvoerbuis-afvoerbuis-40x500mm-29897
https://www.qpool24.nl/nl/alcaplast-a45-urinoir-sifon-dn-50-x-dn-40-50-afzuigsifon-verticaal
https://www.warmteservice.nl/Installatiemateriaal/Waterafvoermateriaal/PP-Hulpstukken/PP-T-stuk-2-x-mof-spie-45-manchet-wit-50/p/57402690?gclsrc=aw.ds&gclid=EAIaIQobChMI5rTQvbuRggMV4opoCR0tSwntEAQYAiABEgJ_Q_D_BwE
User management
https://askubuntu.com/questions/410244/is-there-a-command-to-list-all-users-also-to-add-delete-modify-users-in-the
https://www.cyberciti.biz/faq/unix-create-user-account/
List all users: cut -d: -f1 /etc/passwd
User management
groups "UserName"
https://linuxhint.com/add-remove-users-on-ubuntu-22-04/
https://thucnc.medium.com/how-to-create-a-sudo-user-on-ubuntu-and-allow-ssh-login-20e28065d9ff
Ubuntu Add user to sudoers:sudo usermod -aG sudo "UserName"
Ubuntu add user: sudo adduser "UserName"
Ubuntu List all users: cat /etc/passwd
Ubutu Remove user: sudo deluser --remove-home "userNameHere"
User story delivery template
01. Comment description
02. Notes:
03. 1.
04. For testing (Possible addition):
05. Create Link
06. Also done:
07. 1.
08. Things that were not discribed in this story but need folow up:
09. 1.
10. Improvement suggestions:
11. 1.
12. Points for discussion:
13. 1.
UWF firewall configureren
https://help.ubuntu.com/community/UFW
https://www.digitalocean.com/community/tutorials/how-to-set-up-a-firewall-with-ufw-on-ubuntu-20-04
Validatie en security
No runway suggestion yet.
Value stream en processen
No solution suggestion yet.
Variabelen
https://www.iamtimcorey.com/courses/448486/lectures/6884098
Veranderingen publiseren
No solution suggestion yet.
Verwerking van JSON en XML informatie
No solution suggestion yet.
Visual studio aanpassen
No solution suggestion yet.
Visual studio VS Breakpoint not working
01. menu option: Build
02. Clean solution
Visual studio VS Change default repo folder
01. Open Visual Studio.
02. Go to Tools > Options.
03. Source control (3rd option) -> Git global settings -> Default location
Visual Studio VS Download
https://visualstudio.microsoft.com/vs/community/
Visual studio VS Multiple startup projects
01. In Solution Explorer, select the solution (the top node).
02. Choose the solution node's context (right-click) menu and then choose Properties. The Solution Property Pages dialog box appears.
03. Expand the Common Properties node, and choose Startup Project.
04. Choose the Multiple Startup Projects option and set the appropriate actions.
https://learn.microsoft.com/en-us/visualstudio/ide/how-to-set-multiple-startup-projects?view=vs-2022
Visual studio VS no browser selectable
01. Dropdown in Green play button: Browse with
Visual studio VS Set tabs list on the left
01. Tools
02. Options
03. Environment
04. Tabs and Windows
05. Set tab layout -> Left
https://davecallan.com/configure-vertical-tabs-visual-studio/
Visual Studio VS wierd behaviour
Clear solution: Build -> Clean solution
Delete all the files in: C:\Users\"UserName"\AppData\Local\Temp
VisualStudio VS break mode screen
https://www.google.com/search?client=firefox-b-d&q=visual+studio+break+mode+screen
VisualStudio VS Comment/Uncomment
CTRL + K + C
CTRL + K + U
VisualStudio VS Conditional breakpoints
https://stackoverflow.com/questions/6670415/how-to-set-conditional-breakpoints-in-visual-studio
Right click breakpoint then select conditions
VisualStudio VS Extensions
Format document on save 2. !!!!not!!!!! VS2022
Github Copilot Chat
WebCompiler
VisualStudio VS Find and Replace
Ctrl + Shift + H
https://learn.microsoft.com/en-us/visualstudio/ide/finding-and-replacing-text?view=vs-2022
VisualStudio VS Format document
CTRL + K + D
Select text -> Edit (top menu) -> Advanced -> Format document (First entry)
VisualStudio VS format on save
01. Format document on save
02. !!!!not!!!!! Format document on save VS2022
03. Does not yet work for blazor mark up
VisualStudio VS Github Copilot
01. Install github Copilot
02. Extensions ->Manage Extensions -> Visual Studio Marketplace
03. Search for GitHub Copilot
04. Install Github Copilot & Copilot Chat
https://docs.github.com/en/copilot/getting-started-with-github-copilot?tool=visualstudio#prerequisites-1
VisualStudio VS Go to method/model
Select method or model and press F12
VisualStudio VS Keyboard shortcuts
https://visualstudio.microsoft.com/keyboard-shortcuts.pdf
VisualStudio VS Outlining Document
CTRL + K + D
VisualStudio VS References (CodeLens)
01. Tools > Options > Text Editor > All Languages > CodeLens.
02. Go to a model and see if it works
VisualStudio VS Remove variable data Pins
https://docs.microsoft.com/en-us/visualstudio/debugger/view-data-values-in-data-tips-in-the-code-editor?view=vs-2022
VisualStudio VS Rename variables/methods
CTRL + R + R
VisualStudio VS tab order on the Right
01. Solution Explorer
02. Git Changes
03. Notifications
04. Diagnostic Tools
VisualStudio VS WebCompiler
https://marketplace.visualstudio.com/items?itemName=MadsKristensen.WebCompiler
VisualStudo VS go to line GoTo
CTRL + G
Voortgans verslag een eigen sectie
No runway suggestion yet.
VS Code developer powershell
CTRL + ~
VS Code Download
https://code.visualstudio.com/download
VS Code snel toetsen
1 https://www.youtube.com/watch?v=WPqXP_kLzpo&t=605s
2 ts 10:35
Debugging - (Ctrl + Shift + D) (Command + Shift + D)
Explorer - (Ctrl + Shift + E) (Command + Shift + E)
Find - (Ctrl + Shift + F) (Command + Shift + F)
Side bar toggle - (Ctrl + B ) (Command + B)
Source Control - (Ctrl + Shift + G) (Command + Shift + G)
VS Visual Studio color themes
https://www.google.com/search?q=visual+studio+theme+change&client=firefox-b-d&ei=ZrLuYc63EYybsAe4uJj4BQ&oq=visual+stio+theme+chanhe&gs_lcp=Cgdnd3Mtd2l6EAEYADIECAAQDTIGCAAQDRAeMggIABANEAUQHjIICAAQCBANEB4yCAgAEAgQDRAeMggIABAIEA0QHjIICAAQCBANEB4yCAgAEAgQDRAeMggIABAIEA0QHjIICAAQCBANEB46DQgAEEcQsAMQ6gIQtAI6DQgAELADEEMQ6gIQtAJKBAhBGABKBQhAEgExSgQIRhgAUIYIWM0tYPA9aAFwAXgAgAFeiAG8ApIBATWYAQCgAQHIAQnAAQE&sclient=gws-wiz
VS Visual Studio Github account link with MS account
01. Open VS
02. File -> Accountsettings
03. Sign in with github
VS VisualStudio Generics
Not working (Finish method!)
VS VisualStudio Collapse all methods
CTRL + M + O
VS VisualStudio Editor Tips
https://www.youtube.com/watch?v=qv6ZflueASY
VS VisualStudio Extract interface from class
01. Cursor op class name
02. CTRL + R + I
VS VisualStudio TimeSavers
https://www.youtube.com/watch?v=b4T63cdGs0U
VS vusual studio NameSpace does not show up in intellisense
Add foldername to class namespace
Create new class in folder and look @ namespace
Wat plaats ik in mijn portfolio
No solution suggestion yet.
Web deployment
No solution suggestion yet.
Web file uploads
No solution suggestion yet.
Website down check Just me
https://downforeveryoneorjustme.com/
Website zelf SSL certificeren met certbot
https://www.digitalocean.com/community/tutorials/how-to-secure-apache-with-let-s-encrypt-on-ubuntu-20-04
Why use Interfaces with Dependency Injection
Because you only need to change it at adding the service
Wildcard characters
No solution suggestion yet.
Windows win10 Lock screen/Lock pc
Windows Key + L
WIndows 10 Hostname change
01. Windows explorer
02. Right click -> This PC
03. Properties
04. Rename this PC
05. Enter the desired name
06. Next
07. Restart PC
Windows 10 Real shutdown
https://www.howtogeek.com/349114/shutting-down-doesnt-fully-shut-down-windows-10-but-restarting-it-does/
SHIFT + Click on shutdown
Windows 10 remote deploy
No solution suggestion yet.
Windows 10 Share Folder permissions
01. Right Mouse Button -> the folder/disk you want to share
02. Properties
03. Sharing Tab
04. Advanced sharing
05. Permissions
06. Set permission level (Full control, Change & Read)
07. Apply these changes
08. Security Tab
09. Edit
10. Add User -> Everyone
11. Set permission level (Full control, Change & Read)
12. Apply changes
Windows 10 Startup folder
1. windowskey + R
2. shell:startup
https://support.microsoft.com/en-us/windows/add-an-app-to-run-automatically-at-startup-in-windows-10-150da165-dcd9-7230-517b-cf3c295d89dd
Windows 10 user sign in without entering password
01. Assign password to the account
02. In search field: netplwiz
03. Uncheck: Users must enter a username and password to use this computer
Windows 11 Cedenials identity management
Control Panel\User Accounts\Credential Manager
In start bar search for: Credential Manager
Windows 11 Erase files
https://sourceforge.net/projects/eraser/
Windows 11 File explorer legacy menu
01. Right-click the Start button and choose Terminal (admin).
02. Copy the command below, paste it into the Windows Terminal window, and press enter:
03. reg.exe add "HKCU\Software\Classes\CLSID\{86ca1aa0-34aa-4e8b-a509-50c905bae2a2}\InprocServer32" /f /ve
04. Restart File Explorer or your computer for the changes to take effect1.
05. To undo this change and restore the modern context menu
06. reg.exe delete "HKCU\Software\Classes\CLSID\{86ca1aa0-34aa-4e8b-a509-50c905bae2a2}" /f
07. Then, restart the File Explorer or your computer for the changes to take effect
Windows 11 install older machine tiny11
01. Download win 11 iso -> https://www.microsoft.com/nl-nl/software-download/windows11
02. Download Tiny11 -> https://github.com/ntdevlabs/tiny11builder
03. Click on Code -> Download zip
04. Dowload: Rufus -> https://rufus.ie/nl/
05. Unpack the tiny11builder-main zip file
06. Mount the windows 11 iso in file explorer -> Right click iso -> Mount
07. Run tiny11 creator -> run as administrator
08. Enter the CAPITAL Drive letter of the mounted ISO (Only the letter) -> Press Enter
09. A list of possible windows 11 versions is shown -> Enter the number of the Windows 11 version you need
10. If tiny11 is finished with success -> Close Tiny 11
11. In the folder of Tiny 11 a new disk image (iso) has been created with the name -> tiny11
12. Insert the designated USB stick
13. Open Rufus
14. Drag the ISO you need into the Rufus screen
15. Click -> Start
16. Check the boxes that you want (Remove requirements both, Disable data collection and Disable BitLocker is recommended)
17. Confirm that you want all data to be destroid
https://geekflare.com/install-windows-11-lite-version-tiny11/
https://github.com/ntdevlabs/tiny11builder
https://github.com/pbatard/rufus/releases/download/v4.4/rufus-4.4p.exe
https://rufus.ie/nl/
https://www.microsoft.com/nl-nl/software-download/windows11
https://www.techworm.net/2023/08/download-tiny11-iso-pc-windows-11-lite.html
https://www.youtube.com/watch?v=zfYi82_d808
Windows 11 Map network drive
https://www.lifewire.com/map-network-drive-in-windows-11-5205672
windows 11 network Folder share
01. right click on folder you want to share
02. click the tab 'sharing'
03. click 'Share...'
04. Type 'Everyone' -> click 'add'
05. change permission level to read/write in box below
06. click 'share '
07. click 'done'
08. click 'advanced sharing'
09. make sure that the box 'share this folder' is ticked
10. click 'permissions'
11. make sure that Everyone has full control [check all the boxes]
12. click 'apply'
13. click 'ok'
14. click 'cancel'
15. click 'close'
16. Happy Sharing! :)
Windows 11 network protocol features
01. Settings -> System-> Optional features -> More windows features
02. Check all -> SMB1.0/CIFS
03. Open explorer WIN + E
04. Right click network -> PropertiesShow more options
05. Change advanced sharing settings
06. Private networks -> Enable -> Network discovery and File and printersharing
07. Public networks -> Enable -> Network discovery and File and printersharing
08. All networks -> Enable Public folder sharing
09. All networks -> File sharing connections -> 40-56 bit encryption
10. All networks -> Disbable -> Password protected sharing
Windows 11 Remove bing search from start
REG ADD "HKCU\Software\Microsoft\Windows\CurrentVersion\Search" /V BingSearchEnabled /T REG_DWORD /D 0 /F
windows 11 start menu customisation
https://nl.hardware.info/nieuws/81015/explorerpatcher-brengt-oude-startmenu-terug-naar-windows-11
Windows 11 Explorer Patcher
Windows 11 start minimized
01. Find the application exe on your harddrive
02. Create a shortcut to that exe
03. In the shortcut properties add into the target text field (do not forget the space) -> -tray
04. In the properties in the "Run" dorpdown select -> Minimised
05. The combination is important!
06. When you click the shortcut it will start minimized
Windows 11 Startup folder in start menu
C:\Users\UserName\AppData\Roaming\Microsoft\Windows\Start Menu\Programs
Windows 11 Taskbar icons left
https://www.howtogeek.com/737830/how-to-move-the-taskbar-icons-to-the-left-on-windows-11/
Windows add trusted site
https://code2care.org/sharepoint/access-denied-error-mapping-sharepoint-online-library-as-network-drive
https://www.thewindowsclub.com/add-a-trusted-site-in-windows-10
Windows uninstall apps
https://www.revouninstaller.com/nl/start-freeware-download/
Windows win 10 Record
https://www.lifewire.com/record-your-screen-on-windows-10-5071102
WINDOWS + G
Windows win 10 Snippets maken
01. WINDOWS KEY + SHIFT + S
02. Add it in word document
03. Open wordt document in ZIP to get pictures
Windows win10 Night-Light blue light filter
01. Open settings
02. Search for night light
Windows win10 win11 Screen capture
Start > Settings > Gaming > Captures, then select Open folder
WINDWOS + G
WinForms
No solution suggestion yet.
Word change default saving file type
https://www.technipages.com/how-to-change-the-default-file-type-in-word
Word count
No solution suggestion yet.
Word internale link bookmarks
https://support.microsoft.com/en-us/office/add-or-delete-bookmarks-in-a-word-document-or-outlook-message-f68d781f-0150-4583-a90e-a4009d99c2a0
Word Web App
No solution suggestion yet.
WordPress in .Net Core
https://biswakalyan-das.medium.com/multiple-appsettings-json-in-net-core-without-using-an-environment-variable-d4161c4b56bc
https://docs.peachpie.io/scenarios/wordpress/configuration/
https://docs.peachpie.io/scenarios/wordpress/overview/
https://www.wpwhitesecurity.com/secure-mysql-database-privileges-wordpress/
https://www.youtube.com/watch?v=JWbTbXorBwg&t=230s
https://www.youtube.com/watch?v=lT2xcwRSQnk
WPF Core
No solution suggestion yet.
X.509
https://en.wikipedia.org/wiki/X.509
Zoek resultaten met gedeeldtelijke woorden
gebruik .Contains in zoek opdracht
Zorg voor een connectie vanuit de applicatie naar SQL
No solution suggestion yet.