Source control for Data Conversion

TL;DR

1. Install Git (if not already installed)

2. Configure Git Username and Email Address

3. Error? SSL certificate problem: self-signed certificate in certificate chain

4. Install Visual Studio (VS) Code (if not already installed)

5. Open a cloned repository in VS Code

6. OPTIONAL Install extensions

Recording of Working Session:

Data Conversion working sessions-20240313_153121-Meeting Recording.mp4

Git

Open

Git is a free and open-source distributed version control system designed to handle everything from small to very large projects with speed and efficiency.

Website:
https://git-scm.com

Visual Studio Code

Learning to code is intimidating, so set yourself up for success with a tool built for you. Visual Studio Code is a free coding editor that helps you start coding quickly. Use it to code in any programming language, without switching editors. Visual Studio Code has support for many languages, including Python, Java, C++, JavaScript, and more.

Website:
https://code.visualstudio.com

Extensions Marketplace:
https://marketplace.visualstudio.com/VSCode

Articles

Why VS Code?

Using Git source control in VS Code

Introduction to Git in VS Code

Video includes installing VS Code, installing Git, using Git Bash to set user.name and user.email, and connecting VS Code to an Azure DevOps repository.

Open

Click View, Command Palette to open the command palette to enhance your VS Code experience. Or use the Ctrl+Shift+P keyboard shortcut on Windows.

Open

Example: Change selected text to uppercase.

Open

Visual Studio

Website:
https://visualstudio.microsoft.com/

Visual Studio Community 2019
Download Community 2019

SSIS Articles

Azure DevOps, SSIS, and Git Part 0 – Getting Started

Branching and Merging Strategy in Git for SSIS Projects

Opening a cloned repository from Azure directly to VS Code

Open

Open your repository from Azure.  On the Files page, you can click the Clone button at the top-right of the page.

Open

From the Clone Repository window, you can click the Clone in VS Code button under the IDE section.  This will initiate a connection to VS Code.

Opening a cloned repository from inside VS Code

Open

Open your repository from Azure.  On the Files page, you can click the Clone button at the top-right of the page.

Open

Copy clone URL to clipboard.

Open

Open VS Code application. Open Source Control pane from the left. Click the Clone Repository button.

Open

Paste URL for your repository and hit enter.

Open

Select a folder on your computer to store the repo and press the Select as Repository Destination button.

Open

Success!

Error? SSL certificate problem: self-signed certificate in certificate chain

1. git config --global http.sslVerify false

Configure Git Username and Email Address

To set your global username/email configuration:

1. Open the command line.

2. Set your username:
   git config --global user.name "Your Name"

3. Set your email address:
   git config --global user.email "Your.Name@catalisgov.com"

Sample VS Code Extensions

Rainbow CSV - Visual Studio Marketplace

Combine Files - Visual Studio Marketplace

Render Line Endings - Visual Studio Marketplace

Git History - Visual Studio Marketplace

Prettier - Code formatter - Visual Studio Marketplace